(Bug report) desktop app initial sync never stop

[DayJun]

Description

13:04:18.114 Returning sync stats: {"initialized":false,"outstandingPullCount":75}
13:04:18.114 304 GET /api/sync/stats with 47 bytes took 1ms
13:04:19.111 Returning sync stats: {"initialized":false,"outstandingPullCount":75}
13:04:19.112 304 GET /api/sync/stats with 47 bytes took 1ms
13:04:20.113 Returning sync stats: {"initialized":false,"outstandingPullCount":75}
13:04:20.114 304 GET /api/sync/stats with 47 bytes took 1ms
13:04:21.110 Returning sync stats: {"initialized":false,"outstandingPullCount":75}
13:04:21.110 304 GET /api/sync/stats with 47 bytes took 0ms
13:04:22.109 Returning sync stats: {"initialized":false,"outstandingPullCount":75}
13:04:22.109 304 GET /api/sync/stats with 47 bytes took 0ms
13:04:23.102 Returning sync stats: {"initialized":false,"outstandingPullCount":75}
13:04:23.103 304 GET /api/sync/stats with 47 bytes took 1ms
13:04:24.114 Returning sync stats: {"initialized":false,"outstandingPullCount":75}
13:04:24.114 304 GET /api/sync/stats with 47 bytes took 0ms
13:04:25.117 Returning sync stats: {"initialized":false,"outstandingPullCount":75}
13:04:25.117 304 GET /api/sync/stats with 47 bytes took 1ms
13:04:26.105 Returning sync stats: {"initialized":false,"outstandingPullCount":75}
13:04:26.106 304 GET /api/sync/stats with 47 bytes took 1ms
13:04:27.103 Returning sync stats: {"initialized":false,"outstandingPullCount":75}
13:04:27.103 304 GET /api/sync/stats with 47 bytes took 1ms
13:04:28.110 Returning sync stats: {"initialized":false,"outstandingPullCount":75}
13:04:28.110 304 GET /api/sync/stats with 47 bytes took 1ms

It takes too long to sync, and never stoped

TriliumNext Version

0.90.12

What operating system are you using?

Windows

What is your setup?

Local + server sync

Operating System Version

Windows 10 21H2

Error logs

No response

[eliandoran]

@DayJun , the server runs 0.90.12 as well? And how is the server run, via the Linux binary or Docker?

If you could obtain some logs for the desktop and the server, it would be wonderful.

[DayJun]

Docker deployment server is 0.90.12 as well, I updated it from trilium 0.63.7 yesterday.

server log:

04:11:40.445 Table counts: notes: 135, revisions: 50, attachments: 204, branches: 138, attributes: 161, etapi_tokens: 0, blobs: 159
04:11:40.450 All consistency checks passed with no errors detected (took 4ms)
04:11:58.422 200 GET /api/health-check with 15 bytes took 0ms
04:12:28.607 200 GET /api/health-check with 15 bytes took 1ms
04:12:58.785 200 GET /api/health-check with 15 bytes took 0ms
04:13:28.965 200 GET /api/health-check with 15 bytes took 1ms
04:13:59.142 200 GET /api/health-check with 15 bytes took 0ms
04:14:29.319 200 GET /api/health-check with 15 bytes took 0ms
04:14:59.499 200 GET /api/health-check with 15 bytes took 1ms
04:15:29.669 200 GET /api/health-check with 15 bytes took 0ms
04:15:59.851 200 GET /api/health-check with 15 bytes took 1ms
04:16:30.029 200 GET /api/health-check with 15 bytes took 0ms
04:17:00.192 200 GET /api/health-check with 15 bytes took 1ms
04:17:30.366 200 GET /api/health-check with 15 bytes took 1ms
04:18:00.541 200 GET /api/health-check with 15 bytes took 0ms
04:18:30.721 200 GET /api/health-check with 15 bytes took 0ms
04:19:00.906 200 GET /api/health-check with 15 bytes took 1ms
04:19:31.083 200 GET /api/health-check with 15 bytes took 0ms
04:20:01.273 200 GET /api/health-check with 15 bytes took 1ms
04:20:31.434 200 GET /api/health-check with 15 bytes took 1ms
04:21:01.623 200 GET /api/health-check with 15 bytes took 1ms
04:21:31.798 200 GET /api/health-check with 15 bytes took 1ms
04:22:01.976 200 GET /api/health-check with 15 bytes took 0ms
04:22:32.158 200 GET /api/health-check with 15 bytes took 0ms
04:23:02.329 200 GET /api/health-check with 15 bytes took 1ms
04:23:32.508 200 GET /api/health-check with 15 bytes took 1ms
04:24:02.684 200 GET /api/health-check with 15 bytes took 1ms
04:24:32.866 200 GET /api/health-check with 15 bytes took 0ms
04:25:03.029 200 GET /api/health-check with 15 bytes took 1ms
04:25:33.208 200 GET /api/health-check with 15 bytes took 1ms
04:26:03.382 200 GET /api/health-check with 15 bytes took 1ms
04:26:33.559 200 GET /api/health-check with 15 bytes took 1ms
04:27:03.740 200 GET /api/health-check with 15 bytes took 1ms
04:27:33.932 200 GET /api/health-check with 15 bytes took 0ms
04:28:04.117 200 GET /api/health-check with 15 bytes took 0ms
04:28:34.299 200 GET /api/health-check with 15 bytes took 0ms
04:29:04.478 200 GET /api/health-check with 15 bytes took 1ms
04:29:34.659 200 GET /api/health-check with 15 bytes took 0ms
04:30:04.836 200 GET /api/health-check with 15 bytes took 1ms
04:30:35.017 200 GET /api/health-check with 15 bytes took 0ms
04:31:05.196 200 GET /api/health-check with 15 bytes took 0ms
04:31:35.373 200 GET /api/health-check with 15 bytes took 1ms
04:32:05.547 200 GET /api/health-check with 15 bytes took 0ms
04:32:35.724 200 GET /api/health-check with 15 bytes took 0ms
04:33:05.917 200 GET /api/health-check with 15 bytes took 0ms
04:33:36.094 200 GET /api/health-check with 15 bytes took 1ms
04:34:06.278 200 GET /api/health-check with 15 bytes took 1ms
04:34:36.458 200 GET /api/health-check with 15 bytes took 0ms
04:35:06.643 200 GET /api/health-check with 15 bytes took 1ms
04:35:36.829 200 GET /api/health-check with 15 bytes took 1ms
04:36:06.994 200 GET /api/health-check with 15 bytes took 1ms
04:36:37.182 200 GET /api/health-check with 15 bytes took 1ms
04:37:07.348 200 GET /api/health-check with 15 bytes took 1ms
04:37:37.521 200 GET /api/health-check with 15 bytes took 0ms
04:38:07.702 200 GET /api/health-check with 15 bytes took 1ms
04:38:37.887 200 GET /api/health-check with 15 bytes took 0ms
04:39:08.065 200 GET /api/health-check with 15 bytes took 0ms
04:39:38.239 200 GET /api/health-check with 15 bytes took 1ms
04:40:08.417 200 GET /api/health-check with 15 bytes took 1ms
04:40:38.593 200 GET /api/health-check with 15 bytes took 0ms
04:41:08.772 200 GET /api/health-check with 15 bytes took 2ms
04:41:38.947 200 GET /api/health-check with 15 bytes took 1ms
04:42:09.122 200 GET /api/health-check with 15 bytes took 0ms
04:42:39.299 200 GET /api/health-check with 15 bytes took 0ms
04:43:09.478 200 GET /api/health-check with 15 bytes took 1ms
04:43:39.657 200 GET /api/health-check with 15 bytes took 0ms
04:44:09.831 200 GET /api/health-check with 15 bytes took 1ms
04:44:40.008 200 GET /api/health-check with 15 bytes took 1ms
04:45:10.187 200 GET /api/health-check with 15 bytes took 0ms
04:45:40.367 200 GET /api/health-check with 15 bytes took 1ms
04:46:10.535 200 GET /api/health-check with 15 bytes took 1ms
04:46:40.710 200 GET /api/health-check with 15 bytes took 0ms
04:47:10.896 200 GET /api/health-check with 15 bytes took 0ms
04:47:41.077 200 GET /api/health-check with 15 bytes took 1ms
04:48:11.255 200 GET /api/health-check with 15 bytes took 0ms
04:48:41.430 200 GET /api/health-check with 15 bytes took 1ms
04:49:11.608 200 GET /api/health-check with 15 bytes took 1ms
04:49:41.780 200 GET /api/health-check with 15 bytes took 0ms
04:50:11.964 200 GET /api/health-check with 15 bytes took 0ms
04:50:42.146 200 GET /api/health-check with 15 bytes took 0ms
04:51:12.325 200 GET /api/health-check with 15 bytes took 1ms
04:51:42.500 200 GET /api/health-check with 15 bytes took 1ms
04:52:12.674 200 GET /api/health-check with 15 bytes took 0ms
04:52:42.852 200 GET /api/health-check with 15 bytes took 0ms
04:53:13.030 200 GET /api/health-check with 15 bytes took 1ms
04:53:43.210 200 GET /api/health-check with 15 bytes took 1ms
04:54:13.389 200 GET /api/health-check with 15 bytes took 1ms
04:54:43.566 200 GET /api/health-check with 15 bytes took 1ms
04:55:13.744 200 GET /api/health-check with 15 bytes took 1ms
04:55:43.917 200 GET /api/health-check with 15 bytes took 1ms
04:56:14.093 200 GET /api/health-check with 15 bytes took 0ms
04:56:44.274 200 GET /api/health-check with 15 bytes took 0ms
04:57:14.465 200 GET /api/health-check with 15 bytes took 1ms
04:57:44.641 200 GET /api/health-check with 15 bytes took 1ms
04:58:14.819 200 GET /api/health-check with 15 bytes took 1ms
04:58:45.005 200 GET /api/health-check with 15 bytes took 2ms
04:59:15.183 200 GET /api/health-check with 15 bytes took 0ms
04:59:41.684 200 GET /api/notes/pnirzlxnAcf0/blob with 6587 bytes took 1ms
04:59:41.713 200 GET /api/note-map/pnirzlxnAcf0/backlink-count with 11 bytes took 1ms
04:59:41.728 204 PUT /api/options with 0 bytes took 4ms
04:59:41.908 200 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 2ms
04:59:41.933 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
04:59:41.958 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
04:59:41.982 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 0ms
04:59:42.006 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
04:59:42.030 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
04:59:42.054 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
04:59:42.077 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
04:59:42.102 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
04:59:42.126 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
04:59:42.148 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
04:59:42.795 200 GET /api/tree?subTreeNoteId=T6VxlHV0L91r with 2312 bytes took 1ms
04:59:43.039 204 PUT /api/branches/root_T6VxlHV0L91r/expanded/1 with 0 bytes took 1ms
04:59:44.137 200 GET /api/notes/l33pTi2nEpR7/blob with 364 bytes took 1ms
04:59:44.139 200 GET /api/note-map/l33pTi2nEpR7/backlink-count with 11 bytes took 0ms
04:59:44.145 204 PUT /api/options with 0 bytes took 4ms
04:59:45.346 200 GET /api/health-check with 15 bytes took 1ms
04:59:45.462 304 GET /api/notes/l33pTi2nEpR7/blob with 364 bytes took 0ms
04:59:46.586 304 GET /api/notes/l33pTi2nEpR7/blob with 364 bytes took 0ms
05:00:00.489 304 GET /api/setup/status with 59 bytes took 0ms
05:00:00.516 200 POST /api/login/sync with 54 bytes took 0ms
05:00:00.682 Slow query took 107ms: SELECT * FROM blobs WHERE blobId = ?
05:00:01.147 Returning 3 entity changes in 573ms
05:00:01.975 Slow 200 GET /api/sync/changed?instanceId=y8gU8wXSOSjl&lastEntityChangeId=8532&logMarkerId=NWsDQvMIQI with 83450577 bytes took 1401ms
05:00:15.526 200 GET /api/health-check with 15 bytes took 0ms
05:00:45.709 200 GET /api/health-check with 15 bytes took 1ms
05:01:12.901 GET /api/notes/l33pTi2nEpR7/blob rejected with 401 Logged in session not found
05:01:15.884 200 GET /api/health-check with 15 bytes took 1ms
05:01:20.597 GET /api/note-map/l33pTi2nEpR7/backlink-count rejected with 401 Logged in session not found
05:01:43.363 304 GET /api/setup/status with 59 bytes took 0ms
05:01:43.393 200 POST /api/login/sync with 54 bytes took 1ms
05:01:43.532 Slow query took 109ms: SELECT * FROM blobs WHERE blobId = ?
05:01:43.986 Returning 3 entity changes in 563ms
05:01:44.799 Slow 200 GET /api/sync/changed?instanceId=2Okofr6AcP61&lastEntityChangeId=8532&logMarkerId=pvuAlMRUqE with 83450577 bytes took 1377ms
05:01:46.049 200 GET /api/health-check with 15 bytes took 1ms
05:02:12.797 Generated CSRF token cH1wa6b6-Kknz57sbOK-z9vGA85cfwWAWgaE with secret undefined
05:02:13.039 GET /api/notes/l33pTi2nEpR7/blob rejected with 401 Logged in session not found
05:02:13.225 200 GET /api/options with 6646 bytes took 1ms
05:02:13.245 200 GET /api/tree with 8947 bytes took 1ms
05:02:13.256 304 GET /api/keyboard-actions with 14185 bytes took 5ms
05:02:13.555 Slow 304 GET /api/script/widgets with 10400251 bytes took 201ms
05:02:13.793 200 POST /api/tree/load with 2630 bytes took 0ms
05:02:13.814 200 POST /api/tree/load with 2632 bytes took 0ms
05:02:13.836 200 POST /api/tree/load with 3968 bytes took 1ms
05:02:13.859 200 POST /api/tree/load with 7618 bytes took 1ms
05:02:13.925 304 GET /api/search/%23smmWidgetTemplate%20AND%20note.parents.labels.smmWidgetVersion%3D%22v1.1.0%22 with 16 bytes took 1ms
05:02:13.949 200 POST /api/tree/load with 3784 bytes took 1ms
05:02:14.195 304 GET /api/search/%23smmWidgetCss%20AND%20note.parents.labels.smmWidgetVersion%3D%22v1.1.0%22 with 16 bytes took 1ms
05:02:14.218 200 POST /api/tree/load with 3773 bytes took 1ms
05:02:14.667 200 POST /api/script/exec with 12642 bytes took 1ms
05:02:14.705 200 POST /api/script/exec with 5134 bytes took 1ms
05:02:14.733 200 POST /api/tree/load with 2508 bytes took 0ms
05:02:14.759 200 POST /api/tree/load with 2822 bytes took 0ms
05:02:14.779 200 POST /api/tree/load with 3537 bytes took 0ms
05:02:14.799 200 POST /api/tree/load with 3844 bytes took 1ms
05:02:14.827 200 POST /api/tree/load with 3680 bytes took 1ms
05:02:15.258 304 GET /api/keyboard-shortcuts-for-notes with 2 bytes took 1ms
05:02:15.262 200 POST /api/tree/load with 6054 bytes took 0ms
05:02:15.308 200 POST /api/tree/load with 19596 bytes took 1ms
05:02:15.909 304 GET /api/note-map/l33pTi2nEpR7/backlink-count with 11 bytes took 0ms
05:02:15.911 304 GET /api/notes/l33pTi2nEpR7/blob with 364 bytes took 0ms
05:02:15.955 304 GET /api/note-map/l33pTi2nEpR7/backlink-count with 11 bytes took 0ms
05:02:16.221 200 GET /api/health-check with 15 bytes took 1ms
05:02:16.234 204 PUT /api/options with 0 bytes took 4ms
05:02:17.196 304 GET /api/script/startup with 2 bytes took 1ms
05:02:17.204 304 GET /api/notes/l33pTi2nEpR7/blob with 364 bytes took 1ms
05:02:18.067 304 GET /api/notes/4oZP8KYJtizw/blob with 2025 bytes took 0ms
05:02:18.078 304 GET /api/note-map/4oZP8KYJtizw/backlink-count with 11 bytes took 1ms
05:02:18.088 204 PUT /api/options with 0 bytes took 3ms
05:02:20.585 GET /api/note-map/l33pTi2nEpR7/backlink-count rejected with 401 Logged in session not found
05:02:21.363 200 POST /api/tree/load with 4795 bytes took 0ms
05:02:21.508 200 GET /api/note-map/_options/backlink-count with 11 bytes took 0ms
05:02:21.514 200 GET /api/tree?subTreeNoteId=_hidden with 27106 bytes took 2ms
05:02:21.515 200 GET /api/notes/_options/blob with 155 bytes took 1ms
05:02:21.519 204 PUT /api/options with 0 bytes took 4ms
05:02:21.521 200 POST /api/tree/load with 8224 bytes took 0ms
05:02:21.606 200 GET /api/tree?subTreeNoteId=_options with 8224 bytes took 1ms
05:02:21.607 204 PUT /api/branches/root__hidden/expanded/1 with 0 bytes took 0ms
05:02:23.651 200 GET /api/note-map/_optionsSync/backlink-count with 11 bytes took 1ms
05:02:23.656 200 GET /api/options with 6911 bytes took 0ms
05:02:23.657 200 GET /api/notes/_optionsSync/blob with 157 bytes took 0ms
05:02:23.692 204 PUT /api/branches/root__hidden/expanded/1 with 0 bytes took 1ms
05:02:23.694 204 PUT /api/options with 0 bytes took 2ms
05:02:23.709 204 PUT /api/branches/_hidden__options/expanded/1 with 0 bytes took 1ms
05:02:46.391 200 GET /api/health-check with 15 bytes took 0ms
05:03:06.467 GET /api/notes/_optionsSync/blob rejected with 401 Logged in session not found
05:03:14.903 Serving sync seed.
05:03:14.904 304 GET /api/setup/sync-seed with 272 bytes took 1ms
05:03:14.942 304 GET /api/setup/status with 59 bytes took 1ms
05:03:14.965 200 POST /api/login/sync with 54 bytes took 1ms
05:03:15.073 Returning 294 entity changes in 80ms
05:03:15.142 Slow 200 GET /api/sync/changed?instanceId=dafS7GfChfcO&lastEntityChangeId=0&logMarkerId=FoYML3kUCW with 7039151 bytes took 149ms
05:03:16.553 200 GET /api/health-check with 15 bytes took 1ms
05:03:17.074 GET /api/notes/pnirzlxnAcf0/blob rejected with 401 Logged in session not found
05:03:19.626 Returning 726 entity changes in 23ms
05:03:19.659 Slow 200 GET /api/sync/changed?instanceId=dafS7GfChfcO&lastEntityChangeId=316&logMarkerId=JjQQfxHzeV with 3693385 bytes took 57ms
05:03:25.702 Returning 132 entity changes in 16ms
05:03:25.718 Slow 200 GET /api/sync/changed?instanceId=dafS7GfChfcO&lastEntityChangeId=1259&logMarkerId=RSgvnivkJx with 1141240 bytes took 32ms
05:03:27.223 Returning 142 entity changes in 12ms
05:03:27.234 Slow 200 GET /api/sync/changed?instanceId=dafS7GfChfcO&lastEntityChangeId=1930&logMarkerId=vAvjSLyIrx with 1007657 bytes took 23ms
05:03:29.214 Returning 1000 entity changes in 9ms
05:03:29.219 Slow 200 GET /api/sync/changed?instanceId=dafS7GfChfcO&lastEntityChangeId=4345&logMarkerId=G0Ju4K6cF3 with 504287 bytes took 14ms
05:03:29.548 Returning 791 entity changes in 63ms
05:03:29.586 Slow 200 GET /api/sync/changed?instanceId=dafS7GfChfcO&lastEntityChangeId=7544&logMarkerId=PFyDP3j7UJ with 6668821 bytes took 101ms
05:03:32.674 GET /api/tree rejected with 401 Logged in session not found
05:03:36.313 404 GET /XZfD
05:03:37.399 404 GET /a8Yk
05:03:38.747 404 GET /aab8
05:03:39.079 404 GET /jquery-3.3.1.slim.min.js
05:03:40.428 404 GET /aab9
05:03:40.733 404 GET /jquery-3.3.2.slim.min.js
05:03:42.205 Returning 2 entity changes in 11ms
05:03:42.216 Slow 200 GET /api/sync/changed?instanceId=dafS7GfChfcO&lastEntityChangeId=8526&logMarkerId=Q249c2Ilcz with 2150940 bytes took 22ms
05:03:42.352 GET /api/notes/_options/blob rejected with 401 Logged in session not found
05:03:45.275 Returning 2 entity changes in 29ms
05:03:45.323 Slow 200 GET /api/sync/changed?instanceId=dafS7GfChfcO&lastEntityChangeId=8530&logMarkerId=wjJ8Ye2plM with 4540212 bytes took 77ms
05:03:46.721 200 GET /api/health-check with 15 bytes took 1ms
05:03:53.995 Slow query took 107ms: SELECT * FROM blobs WHERE blobId = ?
05:03:54.435 Returning 3 entity changes in 548ms
05:03:55.255 Slow 200 GET /api/sync/changed?instanceId=dafS7GfChfcO&lastEntityChangeId=8532&logMarkerId=bo0mpcnLAT with 83450577 bytes took 1368ms
05:04:07.022 GET /api/notes/_optionsSync/blob rejected with 401 Logged in session not found
05:04:16.910 200 GET /api/health-check with 15 bytes took 1ms
05:04:25.027 404 GET /api/branches/root_T6VxlHV0L91r/expanded/1
05:04:32.023 GET /api/tree rejected with 401 Logged in session not found
05:04:42.029 GET /api/notes/_options/blob rejected with 401 Logged in session not found
05:04:47.087 200 GET /api/health-check with 15 bytes took 0ms
05:05:02.132 404 GET /api/branches/root__hidden/expanded/1
05:05:17.265 200 GET /api/health-check with 15 bytes took 1ms
05:05:47.445 200 GET /api/health-check with 15 bytes took 1ms
05:06:17.623 200 GET /api/health-check with 15 bytes took 0ms
05:06:47.800 200 GET /api/health-check with 15 bytes took 1ms
05:06:57.779 GET /api/note-map/_options/backlink-count rejected with 401 Logged in session not found
05:07:17.267 404 GET /a8Yk
05:07:17.968 200 GET /api/health-check with 15 bytes took 1ms
05:07:42.632 404 GET /XZfD
05:07:48.129 200 GET /api/health-check with 15 bytes took 1ms
05:07:57.033 GET /api/note-map/_options/backlink-count rejected with 401 Logged in session not found
05:08:17.353 404 GET /a8Yk
05:08:18.295 200 GET /api/health-check with 15 bytes took 0ms
05:08:43.025 404 GET /XZfD
05:08:44.020 404 GET /api/branches/_hidden__options/expanded/1
05:08:48.451 200 GET /api/health-check with 15 bytes took 0ms
05:09:18.631 200 GET /api/health-check with 15 bytes took 1ms
05:09:44.446 404 GET /aab8
05:09:48.791 200 GET /api/health-check with 15 bytes took 1ms
05:10:05.622 GET /api/note-map/pnirzlxnAcf0/backlink-count rejected with 401 Logged in session not found
05:10:12.538 GET /api/notes/pnirzlxnAcf0/attachments rejected with 401 Logged in session not found
05:10:12.705 GET /api/sync/changed rejected with 401 Logged in session not found
05:10:18.955 200 GET /api/health-check with 15 bytes took 1ms
05:10:36.873 404 POST /
05:10:37.377 404 POST /
05:10:37.871 404 GET /WuEL
05:10:38.873 404 GET /a
05:10:39.379 404 GET /download/file.ext
05:10:39.870 404 GET /SiteLoader
05:10:40.384 404 GET /mPlayer
05:10:40.854 404 POST /
05:10:41.328 404 GET /HWi69nR2Ju_iduN3g_cVUQLEOCO3d031o2UIqyYZwAsrVo8gXo9MAQE08r0R1xysXgOB0oD18-94A1Ah0z60/
05:10:41.819 404 GET /download/popy
05:10:42.308 404 GET /en-us/index.html
05:10:44.708 404 GET /aab8
05:10:44.755 404 GET /ui/authentication
05:10:45.264 404 GET /ExecTemplateJDK7.class
05:10:45.750 404 GET /api/v1/version
05:10:46.728 ERROR: WebSocket connection not allowed because session is neither electron nor logged in.
05:10:49.072 GET /api/attachments/TkhoGRZTCFBK/image/image.png rejected with 401 Logged in session not found
05:10:49.118 200 GET /api/health-check with 15 bytes took 1ms
05:10:57.472 404 POST /
05:10:57.979 404 POST /login.php
05:10:58.464 404 GET /neptune
05:11:05.808 GET /api/note-map/pnirzlxnAcf0/backlink-count rejected with 401 Logged in session not found
05:11:13.022 GET /api/notes/pnirzlxnAcf0/attachments rejected with 401 Logged in session not found
05:11:13.913 GET /api/sync/changed rejected with 401 Logged in session not found
05:11:17.028 GET /api/note-map/_optionsSync/backlink-count rejected with 401 Logged in session not found
05:11:19.280 200 GET /api/health-check with 15 bytes took 1ms
05:11:40.447 Table counts: notes: 135, revisions: 50, attachments: 204, branches: 138, attributes: 161, etapi_tokens: 0, blobs: 159
05:11:40.451 All consistency checks passed with no errors detected (took 5ms)
05:11:49.438 200 GET /api/health-check with 15 bytes took 0ms
05:11:57.502 404 GET /SiteLoader
05:12:19.616 200 GET /api/health-check with 15 bytes took 0ms
05:12:23.842 204 PUT /api/branches/root_T6VxlHV0L91r/expanded/0 with 0 bytes took 1ms
05:12:23.845 204 PUT /api/branches/_lbRoot__lbAvailableLaunchers/expanded/0 with 0 bytes took 1ms
05:12:23.848 204 PUT /api/branches/_hidden__lbRoot/expanded/0 with 0 bytes took 0ms
05:12:23.851 204 PUT /api/branches/_lbRoot__lbVisibleLaunchers/expanded/0 with 0 bytes took 1ms
05:12:49.791 200 GET /api/health-check with 15 bytes took 0ms
05:12:58.828 404 GET /SiteLoader
05:13:08.606 404 GET /a
05:13:19.951 200 GET /api/health-check with 15 bytes took 1ms
05:13:50.135 200 GET /api/health-check with 15 bytes took 1ms
05:13:53.195 404 GET /aab9
05:13:57.969 404 GET /download/file.ext
05:14:00.179 404 GET /mPlayer
05:14:03.612 404 GET /ui/authentication
05:14:09.355 404 GET /a
05:14:20.306 200 GET /api/health-check with 15 bytes took 0ms
05:14:50.481 200 GET /api/health-check with 15 bytes took 1ms
05:14:53.023 404 GET /aab9
05:14:58.024 404 GET /download/file.ext
05:15:01.030 404 GET /mPlayer
05:15:02.086 404 GET /neptune
05:15:05.083 404 GET /ui/authentication
05:15:09.047 404 GET /api/branches/_lbRoot__lbAvailableLaunchers/expanded/0
05:15:20.655 200 GET /api/health-check with 15 bytes took 0ms
05:15:50.835 200 GET /api/health-check with 15 bytes took 0ms
05:16:21.017 200 GET /api/health-check with 15 bytes took 1ms
05:16:51.197 200 GET /api/health-check with 15 bytes took 1ms
05:17:21.372 200 GET /api/health-check with 15 bytes took 0ms
05:17:46.553 404 GET /HWi69nR2Ju_iduN3g_cVUQLEOCO3d031o2UIqyYZwAsrVo8gXo9MAQE08r0R1xysXgOB0oD18-94A1Ah0z60/
05:17:51.528 200 GET /api/health-check with 15 bytes took 1ms
05:18:17.131 404 GET /en-us/index.html
05:18:21.693 200 GET /api/health-check with 15 bytes took 2ms
05:18:48.036 404 GET /HWi69nR2Ju_iduN3g_cVUQLEOCO3d031o2UIqyYZwAsrVo8gXo9MAQE08r0R1xysXgOB0oD18-94A1Ah0z60
05:18:51.873 200 GET /api/health-check with 15 bytes took 1ms
05:19:14.495 404 GET /api/v1/version
05:19:22.032 200 GET /api/health-check with 15 bytes took 0ms
05:19:52.216 200 GET /api/health-check with 15 bytes took 1ms
05:20:10.038 404 GET /api/branches/_hidden__lbRoot/expanded/0
05:20:14.636 404 GET /download/popy
05:20:14.748 404 GET /api/v1/version
05:20:22.381 200 GET /api/health-check with 15 bytes took 1ms
05:20:52.566 200 GET /api/health-check with 15 bytes took 1ms
05:21:15.659 404 GET /download/popy
05:21:22.726 200 GET /api/health-check with 15 bytes took 1ms
05:21:52.907 200 GET /api/health-check with 15 bytes took 1ms
05:22:23.086 200 GET /api/health-check with 15 bytes took 1ms
05:22:32.026 404 GET /api/branches/root_T6VxlHV0L91r/expanded/0
05:22:36.031 404 GET /api/branches/_lbRoot__lbVisibleLaunchers/expanded/0
05:22:53.249 200 GET /api/health-check with 15 bytes took 1ms
05:23:23.422 200 GET /api/health-check with 15 bytes took 0ms
05:23:53.601 200 GET /api/health-check with 15 bytes took 0ms
05:24:23.778 200 GET /api/health-check with 15 bytes took 0ms
05:24:53.965 200 GET /api/health-check with 15 bytes took 1ms
05:25:24.143 200 GET /api/health-check with 15 bytes took 1ms
05:25:54.323 200 GET /api/health-check with 15 bytes took 1ms
05:26:24.497 200 GET /api/health-check with 15 bytes took 0ms
05:26:54.679 200 GET /api/health-check with 15 bytes took 1ms
05:27:24.865 200 GET /api/health-check with 15 bytes took 1ms
05:27:55.046 200 GET /api/health-check with 15 bytes took 1ms
05:28:25.226 200 GET /api/health-check with 15 bytes took 1ms
05:28:55.403 200 GET /api/health-check with 15 bytes took 1ms
05:29:25.580 200 GET /api/health-check with 15 bytes took 1ms
05:29:55.757 200 GET /api/health-check with 15 bytes took 0ms
05:30:25.958 200 GET /api/health-check with 15 bytes took 0ms
05:30:56.133 200 GET /api/health-check with 15 bytes took 0ms
05:31:26.321 200 GET /api/health-check with 15 bytes took 0ms
05:31:56.501 200 GET /api/health-check with 15 bytes took 1ms
05:32:26.679 200 GET /api/health-check with 15 bytes took 1ms
05:32:56.865 200 GET /api/health-check with 15 bytes took 1ms
05:33:27.054 200 GET /api/health-check with 15 bytes took 0ms
05:33:57.234 200 GET /api/health-check with 15 bytes took 1ms
05:34:27.410 200 GET /api/health-check with 15 bytes took 1ms
05:34:57.587 200 GET /api/health-check with 15 bytes took 1ms
05:35:27.767 200 GET /api/health-check with 15 bytes took 1ms
05:35:57.947 200 GET /api/health-check with 15 bytes took 0ms
05:36:28.129 200 GET /api/health-check with 15 bytes took 0ms
05:36:58.306 200 GET /api/health-check with 15 bytes took 0ms
05:37:28.481 200 GET /api/health-check with 15 bytes took 0ms
05:37:58.661 200 GET /api/health-check with 15 bytes took 0ms
05:38:28.843 200 GET /api/health-check with 15 bytes took 0ms
05:38:59.019 200 GET /api/health-check with 15 bytes took 0ms
05:39:29.200 200 GET /api/health-check with 15 bytes took 0ms
05:39:59.378 200 GET /api/health-check with 15 bytes took 0ms
05:40:29.559 200 GET /api/health-check with 15 bytes took 0ms
05:40:59.740 200 GET /api/health-check with 15 bytes took 0ms
05:41:29.925 200 GET /api/health-check with 15 bytes took 1ms
05:42:00.120 200 GET /api/health-check with 15 bytes took 1ms
05:42:30.303 200 GET /api/health-check with 15 bytes took 1ms
05:43:00.483 200 GET /api/health-check with 15 bytes took 0ms
05:43:30.663 200 GET /api/health-check with 15 bytes took 2ms
05:44:00.851 200 GET /api/health-check with 15 bytes took 0ms
05:44:31.033 200 GET /api/health-check with 15 bytes took 1ms
05:45:01.209 200 GET /api/health-check with 15 bytes took 1ms
05:45:31.385 200 GET /api/health-check with 15 bytes took 0ms
05:46:01.578 200 GET /api/health-check with 15 bytes took 1ms
05:46:31.756 200 GET /api/health-check with 15 bytes took 0ms
05:47:01.939 200 GET /api/health-check with 15 bytes took 0ms
05:47:32.114 200 GET /api/health-check with 15 bytes took 1ms
05:48:02.309 200 GET /api/health-check with 15 bytes took 1ms
05:48:32.491 200 GET /api/health-check with 15 bytes took 1ms
05:49:02.668 200 GET /api/health-check with 15 bytes took 0ms
05:49:32.844 200 GET /api/health-check with 15 bytes took 1ms
05:50:03.026 200 GET /api/health-check with 15 bytes took 1ms
05:50:33.187 200 GET /api/health-check with 15 bytes took 1ms
05:51:03.367 200 GET /api/health-check with 15 bytes took 0ms
05:51:33.574 200 GET /api/health-check with 15 bytes took 1ms
05:52:03.755 200 GET /api/health-check with 15 bytes took 0ms
05:52:33.944 200 GET /api/health-check with 15 bytes took 0ms
05:53:04.129 200 GET /api/health-check with 15 bytes took 1ms
05:53:34.309 200 GET /api/health-check with 15 bytes took 0ms
05:54:04.482 200 GET /api/health-check with 15 bytes took 1ms
05:54:34.720 200 GET /api/health-check with 15 bytes took 1ms
05:55:04.902 200 GET /api/health-check with 15 bytes took 0ms
05:55:35.077 200 GET /api/health-check with 15 bytes took 1ms
05:56:05.254 200 GET /api/health-check with 15 bytes took 0ms
05:56:35.417 200 GET /api/health-check with 15 bytes took 1ms
05:57:05.599 200 GET /api/health-check with 15 bytes took 1ms
05:57:35.785 200 GET /api/health-check with 15 bytes took 1ms
05:58:05.972 200 GET /api/health-check with 15 bytes took 0ms
05:58:36.152 200 GET /api/health-check with 15 bytes took 0ms
05:59:06.318 200 GET /api/health-check with 15 bytes took 0ms
05:59:36.478 200 GET /api/health-check with 15 bytes took 1ms
06:00:06.669 200 GET /api/health-check with 15 bytes took 1ms
06:00:36.859 200 GET /api/health-check with 15 bytes took 0ms
06:01:07.048 200 GET /api/health-check with 15 bytes took 1ms
06:01:37.037 GET /api/attachments/JrMgrPVDJavf/image/image.png rejected with 401 Logged in session not found
06:01:37.213 200 GET /api/health-check with 15 bytes took 2ms
06:02:07.397 200 GET /api/health-check with 15 bytes took 1ms
06:02:37.578 200 GET /api/health-check with 15 bytes took 1ms
06:03:07.759 200 GET /api/health-check with 15 bytes took 1ms
06:03:37.943 200 GET /api/health-check with 15 bytes took 0ms
06:04:08.119 200 GET /api/health-check with 15 bytes took 0ms
06:04:16.206 GET /api/attachments/4bu3WsrAIpKX/image/image.png rejected with 401 Logged in session not found
06:04:38.283 200 GET /api/health-check with 15 bytes took 1ms
06:05:08.465 200 GET /api/health-check with 15 bytes took 0ms
06:05:38.642 200 GET /api/health-check with 15 bytes took 0ms
06:06:08.817 200 GET /api/health-check with 15 bytes took 0ms
06:06:38.998 200 GET /api/health-check with 15 bytes took 1ms
06:07:09.172 200 GET /api/health-check with 15 bytes took 0ms
06:07:39.350 200 GET /api/health-check with 15 bytes took 0ms
06:08:09.534 200 GET /api/health-check with 15 bytes took 1ms
06:08:39.697 200 GET /api/health-check with 15 bytes took 1ms
06:09:09.882 200 GET /api/health-check with 15 bytes took 1ms
06:09:40.062 200 GET /api/health-check with 15 bytes took 1ms
06:10:10.242 200 GET /api/health-check with 15 bytes took 0ms
06:10:40.421 200 GET /api/health-check with 15 bytes took 0ms
06:11:10.582 200 GET /api/health-check with 15 bytes took 0ms
06:11:40.410 Optimizing database
06:11:40.410 Optimization finished in 0ms.
06:11:40.447 Table counts: notes: 135, revisions: 50, attachments: 204, branches: 138, attributes: 161, etapi_tokens: 0, blobs: 159
06:11:40.452 All consistency checks passed with no errors detected (took 5ms)
06:11:40.742 200 GET /api/health-check with 15 bytes took 1ms
06:12:10.916 200 GET /api/health-check with 15 bytes took 1ms
06:12:41.093 200 GET /api/health-check with 15 bytes took 0ms
06:13:11.275 200 GET /api/health-check with 15 bytes took 1ms
06:13:41.458 200 GET /api/health-check with 15 bytes took 0ms
06:14:11.637 200 GET /api/health-check with 15 bytes took 0ms
06:14:41.825 200 GET /api/health-check with 15 bytes took 0ms
06:15:12.002 200 GET /api/health-check with 15 bytes took 0ms
06:15:42.186 200 GET /api/health-check with 15 bytes took 1ms
06:16:12.367 200 GET /api/health-check with 15 bytes took 0ms
06:16:42.548 200 GET /api/health-check with 15 bytes took 1ms
06:17:12.709 200 GET /api/health-check with 15 bytes took 1ms
06:17:42.885 200 GET /api/health-check with 15 bytes took 0ms
06:18:13.063 200 GET /api/health-check with 15 bytes took 1ms
06:18:43.246 200 GET /api/health-check with 15 bytes took 1ms
06:19:13.428 200 GET /api/health-check with 15 bytes took 0ms
06:19:43.605 200 GET /api/health-check with 15 bytes took 0ms
06:20:13.783 200 GET /api/health-check with 15 bytes took 1ms
06:20:43.972 200 GET /api/health-check with 15 bytes took 0ms
06:21:14.133 200 GET /api/health-check with 15 bytes took 0ms
06:21:44.310 200 GET /api/health-check with 15 bytes took 1ms
06:22:14.488 200 GET /api/health-check with 15 bytes took 0ms
06:22:44.665 200 GET /api/health-check with 15 bytes took 1ms
06:23:14.842 200 GET /api/health-check with 15 bytes took 0ms
06:23:44.999 200 GET /api/health-check with 15 bytes took 0ms
06:24:15.185 200 GET /api/health-check with 15 bytes took 1ms
06:24:45.361 200 GET /api/health-check with 15 bytes took 0ms
06:25:15.540 200 GET /api/health-check with 15 bytes took 0ms

[eliandoran]

@DayJun , OK, it seems that the sync is failing due to an authentication error. I guess we could try:

1. On your Windows machine, got to /home/[user]/AppData/Roaming and delete or rename trilium-data.
2. Log in to your server to confirm that the URL and password are correct.
3. Restart the Trilium desktop app and proceed with the sync again, with the host name and password from step (2).

Let me know if it works out for you.

I'm not exactly sure what caused the sync to fail for you, but I will investigate it.

[eliandoran]

If it still doesn't work it might be related to your server setup, 401 logged in session not found can mean that the server is unable to store the session data when someone logs in. Those sessions are stored as files in the data directory, could be a permission issue as well.

[DayJun]

I deleted all the session files in sessions folder, and then restart initial sync, it still stucked, but without 401 error code

06:51:30.674 {
  "appVersion": "0.90.12",
  "dbVersion": 228,
  "nodeVersion": "v20.15.1",
  "syncVersion": 33,
  "buildDate": "2024-09-07T18:36:34Z",
  "buildRevision": "7c0d6930fa8f20d269dcfbcbc8f636a25f6bb9a7",
  "dataDirectory": "/home/node/trilium-data",
  "clipperProtocolVersion": "1.0",
  "utcDateTime": "2024-12-12T06:51:29.449Z"
}
06:51:30.675 CPU model: AMD EPYC 7K62 48-Core Processor, logical cores: 2, freq: 0 Mhz
06:51:30.677 Trusted reverse proxy: false
06:51:30.678 App HTTP server starting up at port 8080
06:51:30.682 Listening on port 8080
06:51:31.651 ERROR: WebSocket connection not allowed because session is neither electron nor logged in.
06:51:32.476 ERROR: WebSocket connection not allowed because session is neither electron nor logged in.
06:51:33.504 ERROR: WebSocket connection not allowed because session is neither electron nor logged in.
06:51:34.654 Table counts: notes: 135, revisions: 50, attachments: 204, branches: 138, attributes: 161, etapi_tokens: 0, blobs: 159
06:51:34.663 All consistency checks passed with no errors detected (took 10ms)
06:51:36.859 Generated CSRF token Buo6zjML-UiRL6x5an_V2mX9NIioB9B8uuO4 with secret undefined
06:51:37.227 304 GET /api/options with 6926 bytes took 2ms
06:51:37.241 304 GET /api/keyboard-actions with 14185 bytes took 4ms
06:51:37.243 304 GET /api/tree with 35859 bytes took 2ms
06:51:37.507 Slow 304 GET /api/script/widgets with 10400251 bytes took 199ms
06:51:37.706 200 POST /api/tree/load with 2630 bytes took 1ms
06:51:37.729 200 POST /api/tree/load with 2632 bytes took 1ms
06:51:37.750 200 POST /api/tree/load with 3968 bytes took 1ms
06:51:37.769 200 POST /api/tree/load with 7618 bytes took 0ms
06:51:37.839 304 GET /api/search/%23smmWidgetTemplate%20AND%20note.parents.labels.smmWidgetVersion%3D%22v1.1.0%22 with 16 bytes took 2ms
06:51:37.862 200 POST /api/tree/load with 3784 bytes took 0ms
06:51:37.881 304 GET /api/search/%23smmWidgetCss%20AND%20note.parents.labels.smmWidgetVersion%3D%22v1.1.0%22 with 16 bytes took 1ms
06:51:37.904 200 POST /api/tree/load with 3773 bytes took 1ms
06:51:38.105 200 POST /api/script/exec with 12642 bytes took 3ms
06:51:38.129 200 POST /api/script/exec with 5134 bytes took 1ms
06:51:38.150 200 POST /api/tree/load with 2508 bytes took 0ms
06:51:38.169 200 POST /api/tree/load with 2822 bytes took 1ms
06:51:38.188 200 POST /api/tree/load with 3537 bytes took 1ms
06:51:38.207 200 POST /api/tree/load with 3844 bytes took 0ms
06:51:38.227 200 POST /api/tree/load with 3680 bytes took 1ms
06:51:38.632 304 GET /api/keyboard-shortcuts-for-notes with 2 bytes took 1ms
06:51:39.414 304 GET /api/note-map/_optionsPassword/backlink-count with 11 bytes took 1ms
06:51:39.416 304 GET /api/notes/_optionsPassword/blob with 157 bytes took 1ms
06:51:39.420 304 GET /api/options with 6926 bytes took 1ms
06:51:40.568 304 GET /api/script/startup with 2 bytes took 1ms
06:51:41.158 304 GET /api/note-map/qvHQvoWtUktz/backlink-count with 11 bytes took 1ms
06:51:41.161 304 GET /api/notes/qvHQvoWtUktz/blob with 8552 bytes took 1ms
06:51:41.278 200 POST /api/tree/load with 2052 bytes took 0ms
06:51:41.286 304 GET /api/notes/qvHQvoWtUktz/attachments with 4589 bytes took 2ms
06:51:41.433 204 PUT /api/options with 0 bytes took 4ms
06:51:41.701 304 GET /api/notes/XIGcBs4y9xmi/blob with 2923 bytes took 1ms
06:51:42.219 304 GET /api/notes/qvHQvoWtUktz/blob with 8552 bytes took 1ms
06:51:44.603 304 GET /api/notes/pnirzlxnAcf0/blob with 6587 bytes took 0ms
06:51:44.614 304 GET /api/note-map/pnirzlxnAcf0/backlink-count with 11 bytes took 0ms
06:51:44.622 204 PUT /api/options with 0 bytes took 3ms
06:51:45.135 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 4ms
06:51:45.155 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
06:51:45.179 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
06:51:45.200 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
06:51:45.220 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 0ms
06:51:45.240 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 0ms
06:51:45.264 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
06:51:45.283 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
06:51:45.302 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
06:51:45.320 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
06:51:45.340 304 GET /api/notes/pnirzlxnAcf0/attachments with 4928 bytes took 1ms
06:51:45.992 304 GET /api/notes/pnirzlxnAcf0/blob with 6587 bytes took 1ms
06:51:47.518 304 GET /api/notes/pnirzlxnAcf0/blob with 6587 bytes took 1ms
06:51:48.602 304 GET /api/notes/pnirzlxnAcf0/blob with 6587 bytes took 1ms
06:51:59.273 200 GET /api/health-check with 15 bytes took 1ms
06:52:21.392 Serving sync seed.
06:52:21.393 304 GET /api/setup/sync-seed with 272 bytes took 1ms
06:52:21.450 304 GET /api/setup/status with 59 bytes took 0ms
06:52:21.472 200 POST /api/login/sync with 54 bytes took 1ms
06:52:21.574 Returning 294 entity changes in 77ms
06:52:21.644 Slow 200 GET /api/sync/changed?instanceId=WYigKDjX76av&lastEntityChangeId=0&logMarkerId=0qpQEbV9lV with 7039151 bytes took 147ms
06:52:26.422 Returning 722 entity changes in 23ms
06:52:26.456 Slow 200 GET /api/sync/changed?instanceId=WYigKDjX76av&lastEntityChangeId=316&logMarkerId=3lAVAcI6Cl with 3691741 bytes took 57ms
06:52:29.441 200 GET /api/health-check with 15 bytes took 1ms
06:52:32.420 Returning 132 entity changes in 13ms
06:52:32.429 Slow 200 GET /api/sync/changed?instanceId=WYigKDjX76av&lastEntityChangeId=1259&logMarkerId=11VupiKrLQ with 1141240 bytes took 22ms
06:52:34.010 Returning 142 entity changes in 14ms
06:52:34.019 Slow 200 GET /api/sync/changed?instanceId=WYigKDjX76av&lastEntityChangeId=1930&logMarkerId=gPUhjQcq89 with 1008014 bytes took 23ms
06:52:35.994 Returning 1000 entity changes in 10ms
06:52:36.001 Slow 200 GET /api/sync/changed?instanceId=WYigKDjX76av&lastEntityChangeId=4348&logMarkerId=908olaUPDi with 503264 bytes took 17ms
06:52:36.291 Returning 788 entity changes in 65ms
06:52:36.332 Slow 200 GET /api/sync/changed?instanceId=WYigKDjX76av&lastEntityChangeId=7547&logMarkerId=yQQKYJcCno with 6668056 bytes took 106ms
06:52:48.988 Returning 2 entity changes in 11ms
06:52:48.999 Slow 200 GET /api/sync/changed?instanceId=WYigKDjX76av&lastEntityChangeId=8526&logMarkerId=kCF9NrJSQG with 2150940 bytes took 22ms
06:52:52.053 Returning 2 entity changes in 51ms
06:52:52.088 Slow 200 GET /api/sync/changed?instanceId=WYigKDjX76av&lastEntityChangeId=8530&logMarkerId=4j7SMSfm7b with 4540212 bytes took 85ms
06:52:59.601 200 GET /api/health-check with 15 bytes took 0ms
06:53:00.707 Slow query took 105ms: SELECT * FROM blobs WHERE blobId = ?
06:53:01.128 Returning 3 entity changes in 528ms
06:53:01.949 Slow 200 GET /api/sync/changed?instanceId=WYigKDjX76av&lastEntityChangeId=8532&logMarkerId=2iNLJTwtKj with 83450577 bytes took 1349ms
06:53:29.765 200 GET /api/health-check with 15 bytes took 1ms
06:53:59.952 200 GET /api/health-check with 15 bytes took 1ms

[eliandoran]

@DayJun , seems quite good actually, how long has it been stuck for? If you reopen the application does anything change?

[DayJun]

It takes more than 20 minutes, and stuck forever
I manully backuped a database, and download it, and overwrite local database.
Then the desktop app seems to be good, but still have sync problem

15:34:17.732 200 GET /api/backend-log with 61107 bytes took 3ms
15:34:43.255 Sync failed: 'Process exceeded time limit 120000', stack: Error: Process exceeded time limit 120000
    at Object.timeLimit (file:///D:/bins/trilium-windows-x64/resources/app.asar/src/services/utils.ts:254:19)
    at syncRequest (file:///D:/bins/trilium-windows-x64/resources/app.asar/src/services/sync.ts:331:32)
    at pullChanges (file:///D:/bins/trilium-windows-x64/resources/app.asar/src/services/sync.ts:164:28)
    at file:///D:/bins/trilium-windows-x64/resources/app.asar/src/services/sync.ts:65:23
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at Object.doExclusively (file:///D:/bins/trilium-windows-x64/resources/app.asar/src/services/sync_mutex.ts:13:16)
    at sync (file:///D:/bins/trilium-windows-x64/resources/app.asar/src/services/sync.ts:53:16)
15:34:43.536 Nothing to push
15:34:53.935 Received request to trigger sync now.

It seems there is a dead lock or some thing else hang on the processing

[DayJun]

Local changes can be applied to remote, but the reverse is not.

[eliandoran]

@DayJun , would it be possible for you to provide me with a lightly or fully anonymized database? You can find this option in the settings.

You can contact me over email ([email protected]).

On my side I'm running 0.90.12 as both client and server and haven't had any issues with it (over 100k sync objects). I wonder if there is something specific with your database.

[DayJun]

sended @eliandoran

[eliandoran]

Thanks, @DayJun .

I'll have a look once I'm back from work.

[eliandoran]

@DayJun , could you please have a look at the following:

1. What is the size of your document.db? You can do thing by checking the Trilium data directory on the server if you are using Docker volume mounts. I saw some very large syncs so it might have something to do with that.
2. Do you use some kind of reverse proxy? Maybe you have a body limit per request which stops one of the synchronization requests with the server. If yes, try connecting directly to the server temporarily to see if it solves your issue.

[DayJun]

@eliandoran There are some pdfs attachment in one document, the size of the largest PDF file is 60MB.

I didn't use proxy.

Maybe I should not attach so much large attachments?