[Fixed] Sync with Everdo on VPS broke

Today I bought a VPS (Vultr) and set it up the server for everdo.

I get a connection from my computer (client) to the VPS (server).
All my items appeared on the server and then disappeared on the client. I also can’t add new items on the client. The sync state on the client is “sync status unknown” but they still communicate see the “logs” below.
I also restarted the server, but the problem persists.

In the logs on the client side happens a TypeError which is probably the problem of this issue. I think a file got corrupted.

Here is a snipped from server:
[12:48:32.857] [info] Sync request received. Changes since last sync @ 1533732507: 32 items, 0 tags, 0 deletions.
[12:48:32.858] [info] Data read from DB
[12:48:32.858] [info] Adjusting sync request time to Server Time: 0s based on -22.5ms clock difference.
[12:48:32.864] [info] Applying sync.
[12:48:32.870] [info] Sync complete
[12:48:33.413] [debug] query queue length = 2
[12:48:33.414] [debug] no active transactions, executing command
[12:48:33.414] [debug] BEGIN TRAN by bulkPersist
[12:48:33.417] [debug] COMMIT TRAN by bulkPersist
[12:48:33.519] [debug] active transaction in progress, skipping cycle
[12:48:33.621] [debug] query queue length = 1
[12:48:33.622] [debug] no active transactions, executing command
[12:48:33.623] [debug] BEGIN TRAN by updateSyncTimestamp
[12:48:33.623] [debug] COMMIT TRAN by updateSyncTimestamp

client:
14:48:32.669] [info] Initiating sync.
[14:48:32.670] [info] Sync request created. Changes since last sync @ 1533732507: 32 items, 0 tags, 0 deletions.
[14:48:32.744] [debug] t0=1533732512670, t1=1533732512743, st=1533732512729, d=-22.5
[14:48:32.916] [info] HTTP 200 received.
[14:48:32.917] [info] Got sync result from server: 32 items to create/update, 0 tags to create/update, 0 deletions.
[14:48:32.917] [info] Adjusting sync response time to Client Time: 0s based on -22.5ms clock difference.
[14:48:32.918] [info] Applying sync.
[14:48:32.921] [info] Persisting changes.
[14:48:32.922] [info] Updating sync timestamp: 1533732512.
[14:48:32.922] [info] Sync complete
[14:48:32.936] [error] TypeError: Cannot read property ‘id’ of null
at file:///opt/Everdo/resources/app.asar/bundle.js:24:88197
at Array.forEach ()
at file:///opt/Everdo/resources/app.asar/bundle.js:24:88174
at Array.forEach ()
at t.default (file:///opt/Everdo/resources/app.asar/bundle.js:24:88149)
at file:///opt/Everdo/resources/app.asar/bundle.js:395:1953214
at Array.map (native)
at kA.extendedItems (file:///opt/Everdo/resources/app.asar/bundle.js:395:1952905)
at iA.get (file:///opt/Everdo/resources/app.asar/bundle.js:7:21305)
at iA.evaluate (file:///opt/Everdo/resources/app.asar/bundle.js:7:22455)
[14:48:32.953] [debug] query queue length = 2
[14:48:32.953] [debug] no active transactions, executing command
[14:48:32.953] [debug] BEGIN TRAN by bulkPersist
[14:48:32.955] [debug] COMMIT TRAN by bulkPersist
[14:48:33.056] [debug] query queue length = 1
[14:48:33.056] [debug] no active transactions, executing command
[14:48:33.057] [debug] BEGIN TRAN by updateSyncTimestamp
[14:48:33.058] [debug] COMMIT TRAN by updateSyncTimestamp

I also deactivated sync and reinstalled everdo on the client side, but the problem persists:

log of client with sync deactivated

[15:16:16.692] [info] DB Version 11
[15:16:16.694] [info] No migrations to apply.
[15:16:17.388] [error] TypeError: Cannot read property ‘id’ of null
at file:///opt/Everdo/resources/app.asar/bundle.js:24:88198
at Array.forEach ()
at file:///opt/Everdo/resources/app.asar/bundle.js:24:88174
at Array.forEach ()
at t.default (file:///opt/Everdo/resources/app.asar/bundle.js:24:88149)
at file:///opt/Everdo/resources/app.asar/bundle.js:395:1953214
at Array.map ()
at kA.extendedItems (file:///opt/Everdo/resources/app.asar/bundle.js:395:1952905)
at iA.get (file:///opt/Everdo/resources/app.asar/bundle.js:7:21305)
at iA.evaluate (file:///opt/Everdo/resources/app.asar/bundle.js:7:22455)
[15:16:24.641] [info] view changed: W
[15:16:24.658] [error] TypeError: Cannot read property ‘id’ of null
at file:///opt/Everdo/resources/app.asar/bundle.js:24:88198
at Array.forEach ()
at file:///opt/Everdo/resources/app.asar/bundle.js:24:88174
at Array.forEach ()
at t.default (file:///opt/Everdo/resources/app.asar/bundle.js:24:88149)
at file:///opt/Everdo/resources/app.asar/bundle.js:395:1953214
at Array.map ()
at kA.extendedItems (file:///opt/Everdo/resources/app.asar/bundle.js:395:1952905)
at iA.get (file:///opt/Everdo/resources/app.asar/bundle.js:7:21305)
at iA.evaluate (file:///opt/Everdo/resources/app.asar/bundle.js:7:22455)

How can I solve this issue?

Christoph

Looking into your issue

Do you happen to have a backup?
If so, then a quick fix would be to remove the database file from both installations, then retry

Quick option 2: If there are no errors on the server, try to run Pull instead of sync. This should copy the correct state to the client, overriding any errors.

Option 2 worked :+1:

Thank you

You are welcome! Sorry for your trouble. Thank you for bringing this issue to attention. You report will certainly help kill this bug.