00:41:43.239 INFO Notes deleted: 0, not deleted 148 00:41:43.240 INFO Note revisions deleted: 0, not deleted 0 00:41:43.242 INFO Branches deleted: 0, not deleted 165 00:41:43.243 INFO Attributes deleted: 0, not deleted 422 00:41:43.243 INFO API tokens deleted: 0, not deleted 0 00:41:43.268 INFO All consistency checks passed (took 30ms) 01:41:43.237 INFO Notes deleted: 0, not deleted 148 01:41:43.239 INFO Note revisions deleted: 0, not deleted 0 01:41:43.240 INFO Branches deleted: 0, not deleted 165 01:41:43.241 INFO Attributes deleted: 0, not deleted 422 01:41:43.242 INFO API tokens deleted: 0, not deleted 0 01:41:43.266 INFO All consistency checks passed (took 29ms) 02:41:43.237 INFO Notes deleted: 0, not deleted 148 02:41:43.238 INFO Note revisions deleted: 0, not deleted 0 02:41:43.240 INFO Branches deleted: 0, not deleted 165 02:41:43.240 INFO Attributes deleted: 0, not deleted 422 02:41:43.241 INFO API tokens deleted: 0, not deleted 0 02:41:43.270 INFO All consistency checks passed (took 33ms) 03:41:43.238 INFO Notes deleted: 0, not deleted 148 03:41:43.239 INFO Note revisions deleted: 0, not deleted 0 03:41:43.240 INFO Branches deleted: 0, not deleted 165 03:41:43.242 INFO Attributes deleted: 0, not deleted 422 03:41:43.243 INFO API tokens deleted: 0, not deleted 0 03:41:43.270 INFO All consistency checks passed (took 32ms) 04:28:51.939 INFO Generated sourceId=qLUiycS6wAj7 04:28:51.942 INFO App HTTP server starting up at port 8080 04:28:51.942 INFO { "appVersion": "0.40.6", "dbVersion": 158, "syncVersion": 14, "buildDate": "2020-03-15T11:21:43+01:00", "buildRevision": "f5e27278ab2a38484019ee2510781099b60ec2b6", "dataDirectory": "/root/trilium-data", "clipperProtocolVersion": "1.0" } 04:28:52.481 INFO DB ready. 04:28:53.897 INFO DB size: 1540 KB 04:28:53.908 INFO Slow query took 1429ms: INSERT INTO source_ids(sourceId, utcDateCreated) VALUES (?, ?) 04:28:53.909 INFO Slow query took 1428ms: SELECT * FROM options WHERE name = ? 04:28:53.909 INFO Slow query took 1428ms: SELECT noteId, title FROM notes WHERE isDeleted = 0 AND isProtected = 0 04:29:12.487 INFO Notes deleted: 0, not deleted 148 04:29:12.527 INFO Note revisions deleted: 0, not deleted 0 04:29:12.530 INFO Branches deleted: 0, not deleted 165 04:29:12.543 INFO Attributes deleted: 0, not deleted 422 04:29:12.547 INFO API tokens deleted: 0, not deleted 0 04:29:12.711 INFO All consistency checks passed (took 227ms) 09:35:54.477 INFO Generated sourceId=ngWvCZfHBvBe 09:35:54.481 INFO App HTTP server starting up at port 8080 09:35:54.483 INFO { "appVersion": "0.40.6", "dbVersion": 158, "syncVersion": 14, "buildDate": "2020-03-15T11:21:43+01:00", "buildRevision": "f5e27278ab2a38484019ee2510781099b60ec2b6", "dataDirectory": "/root/trilium-data", "clipperProtocolVersion": "1.0" } 09:35:55.447 INFO Slow query took 947ms: SELECT name FROM sqlite_master WHERE type='table' AND name='options' 09:35:55.552 INFO DB ready. 09:35:56.524 INFO DB size: 1540 KB 09:35:56.529 INFO Slow query took 984ms: INSERT INTO source_ids(sourceId, utcDateCreated) VALUES (?, ?) 09:35:56.530 INFO Slow query took 984ms: SELECT * FROM options WHERE name = ? 09:35:56.530 INFO Slow query took 981ms: SELECT noteId, title FROM notes WHERE isDeleted = 0 AND isProtected = 0 09:36:15.552 INFO Notes deleted: 0, not deleted 148 09:36:15.640 INFO Note revisions deleted: 0, not deleted 0 09:36:15.642 INFO Branches deleted: 0, not deleted 165 09:36:16.183 INFO Slow query took 541ms: SELECT isDeleted, count(1) FROM attributes GROUP BY isDeleted 09:36:16.183 INFO Attributes deleted: 0, not deleted 422 09:36:16.184 INFO API tokens deleted: 0, not deleted 0 09:36:16.653 INFO Slow query took 463ms: SELECT DISTINCT notes.noteId FROM notes LEFT JOIN branches ON notes.noteId = branches.noteId AND branches.isDeleted = 0 WHERE notes.isDeleted = 0 AND branches.branchId IS NULL 09:36:17.452 INFO Slow query took 797ms: SELECT noteId FROM notes JOIN note_contents USING (noteId) WHERE isDeleted = 0 AND content IS NULL 09:36:17.575 INFO All consistency checks passed (took 2025ms) 09:43:45.103 INFO Generated sourceId=acPQwXXv7If5 09:43:45.112 INFO App HTTP server starting up at port 8080 09:43:45.115 INFO { "appVersion": "0.40.6", "dbVersion": 158, "syncVersion": 14, "buildDate": "2020-03-15T11:21:43+01:00", "buildRevision": "f5e27278ab2a38484019ee2510781099b60ec2b6", "dataDirectory": "/root/trilium-data", "clipperProtocolVersion": "1.0" } 09:43:45.444 INFO DB ready. 09:43:45.990 INFO DB size: 1540 KB 09:43:46.014 INFO Slow query took 573ms: INSERT INTO source_ids(sourceId, utcDateCreated) VALUES (?, ?) 09:43:46.017 INFO Slow query took 573ms: SELECT * FROM options WHERE name = ? 09:43:46.019 INFO Slow query took 572ms: SELECT noteId, title FROM notes WHERE isDeleted = 0 AND isProtected = 0 09:44:05.450 INFO Notes deleted: 0, not deleted 148 09:44:05.570 INFO Note revisions deleted: 0, not deleted 0 09:44:05.577 INFO Branches deleted: 0, not deleted 165 09:44:05.694 INFO Attributes deleted: 0, not deleted 422 09:44:05.701 INFO API tokens deleted: 0, not deleted 0 09:44:06.337 INFO Slow query took 415ms: SELECT noteId FROM notes JOIN note_contents USING (noteId) WHERE isDeleted = 0 AND content IS NULL 09:44:06.535 INFO All consistency checks passed (took 1088ms) 20:55:18.219 INFO Generated sourceId=tKZSIdjd4Rpv 20:55:18.220 INFO App HTTP server starting up at port 8080 20:55:18.221 INFO { "appVersion": "0.40.6", "dbVersion": 158, "syncVersion": 14, "buildDate": "2020-03-15T11:21:43+01:00", "buildRevision": "f5e27278ab2a38484019ee2510781099b60ec2b6", "dataDirectory": "/root/trilium-data", "clipperProtocolVersion": "1.0" } 20:55:18.717 INFO Slow query took 492ms: SELECT name FROM sqlite_master WHERE type='table' AND name='options' 20:55:18.822 INFO DB ready. 20:55:19.733 INFO DB size: 1540 KB 20:55:19.736 INFO Slow query took 915ms: INSERT INTO source_ids(sourceId, utcDateCreated) VALUES (?, ?) 20:55:19.737 INFO Slow query took 915ms: SELECT * FROM options WHERE name = ? 20:55:19.737 INFO Slow query took 915ms: SELECT noteId, title FROM notes WHERE isDeleted = 0 AND isProtected = 0 20:55:20.560 INFO Created backup at /root/trilium-data/backup/backup-daily.db 20:55:21.223 INFO Slow query took 653ms: COMMIT 20:55:21.228 INFO Slow query took 401ms: SELECT * FROM options WHERE name = ? 20:55:38.824 INFO Notes deleted: 0, not deleted 148 20:55:38.827 INFO Note revisions deleted: 0, not deleted 0 20:55:38.828 INFO Branches deleted: 0, not deleted 165 20:55:38.831 INFO Attributes deleted: 0, not deleted 422 20:55:38.832 INFO API tokens deleted: 0, not deleted 0 20:55:38.876 INFO All consistency checks passed (took 53ms) 21:03:32.422 INFO Generated sourceId=uVug6q0vC3Ne 21:03:32.431 INFO App HTTP server starting up at port 8080 21:03:32.433 INFO { "appVersion": "0.40.6", "dbVersion": 158, "syncVersion": 14, "buildDate": "2020-03-15T11:21:43+01:00", "buildRevision": "f5e27278ab2a38484019ee2510781099b60ec2b6", "dataDirectory": "/root/trilium-data", "clipperProtocolVersion": "1.0" } 21:03:32.759 INFO DB ready. 21:03:33.155 INFO DB size: 1540 KB 21:03:33.177 INFO Slow query took 417ms: INSERT INTO source_ids(sourceId, utcDateCreated) VALUES (?, ?) 21:03:33.180 INFO Slow query took 417ms: SELECT * FROM options WHERE name = ? 21:03:33.182 INFO Slow query took 419ms: SELECT noteId, title FROM notes WHERE isDeleted = 0 AND isProtected = 0 21:03:52.768 INFO Notes deleted: 0, not deleted 148 21:03:52.795 INFO Note revisions deleted: 0, not deleted 0 21:03:52.803 INFO Branches deleted: 0, not deleted 165 21:03:52.841 INFO Attributes deleted: 0, not deleted 422 21:03:52.851 INFO API tokens deleted: 0, not deleted 0 21:03:53.203 INFO All consistency checks passed (took 441ms) 21:10:32.956 INFO Generated sourceId=yW8o5CEaIvUG 21:10:32.961 INFO App HTTP server starting up at port 8080 21:10:32.962 INFO { "appVersion": "0.40.6", "dbVersion": 158, "syncVersion": 14, "buildDate": "2020-03-15T11:21:43+01:00", "buildRevision": "f5e27278ab2a38484019ee2510781099b60ec2b6", "dataDirectory": "/root/trilium-data", "clipperProtocolVersion": "1.0" } 21:10:33.400 INFO DB ready. 21:10:33.755 INFO DB size: 1540 KB 21:10:33.773 INFO Slow query took 363ms: INSERT INTO source_ids(sourceId, utcDateCreated) VALUES (?, ?) 21:10:33.774 INFO Slow query took 365ms: SELECT * FROM options WHERE name = ? 21:10:33.774 INFO Slow query took 374ms: SELECT noteId, title FROM notes WHERE isDeleted = 0 AND isProtected = 0 21:10:53.402 INFO Notes deleted: 0, not deleted 148 21:10:53.717 INFO Slow query took 315ms: SELECT isErased, count(1) FROM note_revisions GROUP BY isErased 21:10:53.717 INFO Note revisions deleted: 0, not deleted 0 21:10:53.720 INFO Slow query took 302ms: SELECT * FROM options WHERE name = ? 21:10:53.720 INFO Branches deleted: 0, not deleted 165 21:10:54.305 INFO Slow query took 585ms: SELECT isDeleted, count(1) FROM attributes GROUP BY isDeleted 21:10:54.305 INFO Attributes deleted: 0, not deleted 422 21:10:54.305 INFO API tokens deleted: 0, not deleted 0 21:10:54.641 INFO Slow query took 330ms: SELECT DISTINCT notes.noteId FROM notes LEFT JOIN branches ON notes.noteId = branches.noteId AND branches.isDeleted = 0 WHERE notes.isDeleted = 0 AND branches.branchId IS NULL 21:10:55.985 INFO Slow query took 1340ms: SELECT noteId FROM notes JOIN note_contents USING (noteId) WHERE isDeleted = 0 AND content IS NULL 21:10:55.986 INFO Slow query took 568ms: SELECT * FROM options WHERE name = ? 21:10:56.004 INFO All consistency checks passed (took 2603ms) 22:10:33.402 INFO Notes deleted: 0, not deleted 148 22:10:33.404 INFO Note revisions deleted: 0, not deleted 0 22:10:33.404 INFO Branches deleted: 0, not deleted 165 22:10:33.406 INFO Attributes deleted: 0, not deleted 422 22:10:33.406 INFO API tokens deleted: 0, not deleted 0 22:10:33.431 INFO All consistency checks passed (took 31ms) 23:10:33.402 INFO Notes deleted: 0, not deleted 148 23:10:33.403 INFO Note revisions deleted: 0, not deleted 0 23:10:33.403 INFO Branches deleted: 0, not deleted 165 23:10:33.405 INFO Attributes deleted: 0, not deleted 422 23:10:33.405 INFO API tokens deleted: 0, not deleted 0 23:10:33.429 INFO All consistency checks passed (took 27ms)