search

zadam / trilium

Build your personal knowledge base with Trilium Notes
GNU Affero General Public License v3.0
26.98k stars 1.89k forks source link

Entire Trilium window turned blank white - restarted... #3898

Open LorenAmelang opened 1 year ago

LorenAmelang commented 1 year ago

Trilium Version

0.59.4

What operating system are you using?

Windows

What is your setup?

Local + server sync

Operating System Version

22H2 19045.2846

Description

Any idea what happened here? The entire Trilium window turned pure white, had to hard kill. Reopened with same view of same note.

--> I'm typing into a note:

13:44:54.437 200 GET /api/notes/QjDQhCAjCWVk with 29969 bytes took 1ms 13:44:55.462 204 PUT /api/notes/QjDQhCAjCWVk/data with 0 bytes took 1ms 13:44:55.466 200 GET /api/notes/QjDQhCAjCWVk with 29971 bytes took 1ms 13:45:00.276 304 GET /api/clipper/handshake with 45 bytes took 1ms

--> somewhere around here the entire Trilium window turned pure white:

13:45:18.715 Sending message to all clients: {"type":"sync-push-in-progress","lastSyncedPush":190807} 13:45:18.715 Sync jqjshRnxrF: Pushing 1 sync changes in 399ms 13:45:18.715 Nothing to push 13:45:18.902 Finished pull 13:45:18.902 Nothing to push 13:45:19.846 Slow query took 93ms: SELECT entityName, entityId, hash FROM entity_changes WHERE isSynced = 1 AND entityName != 'note_reordering' 13:45:19.899 Content hash computation took 146ms 13:45:19.899 Content hash checks PASSED 13:45:19.899 Sending message to all clients: {"type":"sync-finished","lastSyncedPush":190825} 13:46:00.280 304 GET /api/clipper/handshake with 45 bytes took 1ms 13:46:17.991 Nothing to push 13:46:18.195 Finished pull 13:46:18.195 Nothing to push 13:46:19.076 Slow query took 99ms: SELECT entityName, entityId, hash FROM entity_changes WHERE isSynced = 1 AND entityName != 'note_reordering' 13:46:19.145 Content hash computation took 168ms 13:46:19.145 Content hash checks PASSED 13:46:19.145 Sending message to all clients: {"type":"sync-finished","lastSyncedPush":190825} 13:47:00.265 304 GET /api/clipper/handshake with 45 bytes took 0ms

--> I tried a few things, and finally hard killed trilium - but it looks like it must have been running behind the empty white window...

13:47:15.658 DB size: 274255 KB 13:47:17.852 Trusted reverse proxy: false 13:47:17.852 App HTTP server starting up at port 37840 13:47:17.852 { "appVersion": "0.59.4", "dbVersion": 213, "syncVersion": 29, "buildDate": "2023-04-17T21:40:35+02:00", "buildRevision": "1d3272e9f8c27106a66227fbb580677ae5d70427", "dataDirectory": "C:\Users\loren\AppData\Roaming\trilium-data", "clipperProtocolVersion": "1.0", "utcDateTime": "2023-05-03T20:47:15.656Z" } 13:47:17.853 CPU model: Intel(R) Core(TM) i7-6600U CPU @ 2.60GHz, logical cores: 4 freq: 2808 Mhz 13:47:17.876 Listening on port 37840 13:47:17.968 Slow query took 91ms: SELECT noteId, title, type, mime, isProtected, dateCreated, dateModified, utcDateCreated, utcDateModified FROM notes WHERE isDeleted = 0 13:47:18.023 Slow query took 45ms: SELECT branchId, noteId, parentNoteId, prefix, notePosition, isExpanded, utcDateModified FROM branches WHERE isDeleted = 0 13:47:18.182 Slow query took 132ms: SELECT attributeId, noteId, type, name, value, isInheritable, position, utcDateModified FROM attributes WHERE isDeleted = 0 13:47:18.229 Becca (note cache) load took 352ms 13:47:18.562 Keyboard action showNoteInfo found in database, but not in action definition. 13:47:18.562 Keyboard action showLinkMap found in database, but not in action definition. 13:47:18.563 Keyboard action toggleZenMode found in database, but not in action definition. 13:47:18.563 Keyboard action focusOnAttributes found in database, but not in action definition. 13:47:18.563 Registered global shortcut Ctrl+Alt+P for action createNoteIntoInbox 13:47:19.016 Generated CSRF token cGIrmrXO-ILDa8xuS9NbBRL0vpdC7AOisu-s with secret _csrf=CWUAaQtSRiAuVegqBLGJRkLt; Path=/ 13:47:19.650 200 GET /api/options with 7022 bytes took 1ms 13:47:19.657 200 GET /api/tree with 298493 bytes took 6ms 13:47:19.662 Keyboard action showNoteInfo found in database, but not in action definition. 13:47:19.662 Keyboard action showLinkMap found in database, but not in action definition. 13:47:19.662 Keyboard action toggleZenMode found in database, but not in action definition. 13:47:19.662 Keyboard action focusOnAttributes found in database, but not in action definition. 13:47:19.663 200 GET /api/keyboard-actions with 12153 bytes took 2ms 13:47:19.671 200 GET /api/script/widgets with 2893 bytes took 7ms 13:47:19.688 200 POST /api/tree/load with 2000 bytes took 1ms 13:47:19.841 200 GET /api/keyboard-shortcuts-for-notes with 2 bytes took 0ms 13:47:19.948 200 POST /api/tree/load with 5801 bytes took 1ms 13:47:19.989 200 POST /api/tree/load with 20447 bytes took 2ms 13:47:20.666 200 GET /api/notes/QjDQhCAjCWVk with 29971 bytes took 2ms 13:47:20.667 200 GET /api/note-map/QjDQhCAjCWVk/backlink-count with 11 bytes took 0ms 13:47:21.855 Slow 200 GET /api/script/startup with 2 bytes took 10ms 13:47:22.282 Slow query took 25ms: SELECT COUNT(1) FROM attributes 13:47:22.283 Table counts: notes: 5088, note_revisions: 1103, branches: 5162, attributes: 12233, etapi_tokens: 1 13:47:22.313 Slow query took 30ms: SELECT noteId as entityId FROM notes LEFT JOIN entity_changes ON entity_changes.entityName = 'notes' AND entity_changes.entityId = noteId WHERE entity_changes.id IS NULL 13:47:22.544 Slow query took 231ms: SELECT id, entityId FROM entity_changes LEFT JOIN notes ON entityId = noteId WHERE entity_changes.isErased = 0 AND entity_changes.entityName = 'notes' AND noteId IS NULL 13:47:22.579 Slow query took 29ms: SELECT noteId as entityId FROM note_contents LEFT JOIN entity_changes ON entity_changes.entityName = 'note_contents' AND entity_changes.entityId = noteId WHERE entity_changes.id IS NULL 13:47:22.652 Slow query took 31ms: SELECT branchId as entityId FROM branches LEFT JOIN entity_changes ON entity_changes.entityName = 'branches' AND entity_changes.entityId = branchId WHERE entity_changes.id IS NULL 13:47:22.696 Slow query took 44ms: SELECT id, entityId FROM entity_changes LEFT JOIN branches ON entityId = branchId WHERE entity_changes.isErased = 0 AND entity_changes.entityName = 'branches' AND branchId IS NULL 13:47:22.754 Slow query took 52ms: SELECT attributeId as entityId FROM attributes LEFT JOIN entity_changes ON entity_changes.entityName = 'attributes' AND entity_changes.entityId = attributeId WHERE entity_changes.id IS NULL 13:47:22.781 Slow query took 27ms: SELECT id, entityId FROM entity_changes LEFT JOIN attributes ON entityId = attributeId WHERE entity_changes.isErased = 0 AND entity_changes.entityName = 'attributes' AND attributeId IS NULL 13:47:24.557 Slow query took 1723ms: SELECT notes.noteId, notes.type, notes.mime FROM notes JOIN note_contents USING (noteId) WHERE isDeleted = 0 AND isProtected = 0 AND content IS NULL 13:47:24.591 All consistency checks passed with no errors detected (took 2354ms) 13:47:25.537 Sending message to all clients: {"type":"sync-push-in-progress","lastSyncedPush":190825} 13:47:25.538 Sync Rlm2V6Uqrz: Pushing 3 sync changes in 218ms 13:47:25.539 Nothing to push 13:47:25.726 Finished pull 13:47:25.726 Nothing to push 13:47:26.703 Slow query took 78ms: SELECT entityName, entityId, hash FROM entity_changes WHERE isSynced = 1 AND entityName != 'note_reordering' 13:47:26.774 Content hash computation took 149ms 13:47:26.774 Content hash checks PASSED 13:47:26.774 Sending message to all clients: {"type":"sync-finished","lastSyncedPush":190828}

--> the window is finally back and I'm typing again:

13:47:29.287 200 GET /api/notes/QjDQhCAjCWVk with 29971 bytes took 2ms 13:47:46.101 204 PUT /api/notes/QjDQhCAjCWVk/data with 0 bytes took 6ms 13:47:46.108 200 GET /api/notes/QjDQhCAjCWVk with 29972 bytes took 1ms

Error logs

trilium-2023-05-03.log

Nyar233 commented 1 year ago

I've also encountered similar issues.