github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-03-09 11:42:54 -05:00
Code Issues 250 Packages Projects Releases 53 Wiki Activity

[Bug]: sync issue #261

New Issue
Closed
opened 2026-02-28 18:54:35 -06:00 by GiteaMirror · 2 comments
GiteaMirror commented 2026-02-28 18:54:35 -06:00
Owner
Copy Link

Originally created by @MatissJanis on GitHub (Feb 4, 2023).

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

Both me and my wife use Actual from different devices. Sometimes I have noticed that sync just breaks on one of the devices.
Screenshot 2023-02-04 at 17 54 06

Actual v23.1.x

What error did you receive?

Error: UNIQUE constraint failed: messages_crdt.timestamp
    at r.handleError (sql-wasm.js:89:129)
    at t.step (sql-wasm.js:80:69)
    at t.run (sql-wasm.js:82:56)
    at Module.c (index.web.js:72:12)
    at Module.j (index.js:99:18)
    at index.js:327:9
    at Module.d (index.web.js:103:20)
    at Module.k (index.js:127:10)
    at index.js:306:3

Where are you hosting Actual?

Fly.io

What browsers are you seeing the problem on?

Chrome

Operating System

Mac OSX

Originally created by @MatissJanis on GitHub (Feb 4, 2023). ### Verified issue does not already exist? - [X] I have searched and found no existing issue ### What happened? Both me and my wife use Actual from different devices. Sometimes I have noticed that sync just breaks on one of the devices. <img width="569" alt="Screenshot 2023-02-04 at 17 54 06" src="https://user-images.githubusercontent.com/886567/216782229-5e53928b-8844-4b8b-9f3b-1354f0655fdc.png"> Actual v23.1.x ### What error did you receive? ``` Error: UNIQUE constraint failed: messages_crdt.timestamp at r.handleError (sql-wasm.js:89:129) at t.step (sql-wasm.js:80:69) at t.run (sql-wasm.js:82:56) at Module.c (index.web.js:72:12) at Module.j (index.js:99:18) at index.js:327:9 at Module.d (index.web.js:103:20) at Module.k (index.js:127:10) at index.js:306:3 ``` ### Where are you hosting Actual? Fly.io ### What browsers are you seeing the problem on? Chrome ### Operating System Mac OSX
GiteaMirror added the bug label 2026-02-28 18:54:35 -06:00
GiteaMirror commented 2026-02-28 18:54:36 -06:00
Author
Owner
Copy Link

@MatissJanis commented on GitHub (Feb 4, 2023):

False alarm :)

After doing some investigation I figured out the root-cause here. I am doing automatic investment account updates. A script is pushing messages to actual-server.

If 2x computers are opened and then pull the messages from actual-server and then attempt to sync them back up - this will cause conflicts to arise in 1x of the devices.

@MatissJanis commented on GitHub (Feb 4, 2023): False alarm :) After doing some investigation I figured out the root-cause here. I am doing automatic investment account updates. A script is pushing messages to actual-server. If 2x computers are opened and then pull the messages from actual-server and then attempt to sync them back up - this will cause conflicts to arise in 1x of the devices.
GiteaMirror commented 2026-02-28 18:54:36 -06:00
Author
Owner
Copy Link

@j-f1 commented on GitHub (Feb 4, 2023):

Ideally that would be supported though, the devices shouldn't come into conflict.

@j-f1 commented on GitHub (Feb 4, 2023): Ideally that would be supported though, the devices shouldn't come into conflict.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
AI generated
API
bank sync
budgeting
bug
can’t replicate
dependencies
docker
documentation
electron
experimental feature
feature
feedback
goal templates
good first issue
help wanted
importers
maintenance
needs info
needs testing
needs triage
needs votes
openid
payees
pull-request
Mirrored from GitHub Pull Request
 regression
reports
responsive
rules
schedules
server
✨ merged
split transactions
tech debt
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#261
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?