In these two weeks, this warning sign appears all the time while working on tropy. Last week, I was ignoring it but as it restarted it , I wonder if it is not a trouble that I should care. I will be happy if you can tell me what is wrong.
Can you copy your log file (after this warning appears) and post it here? This might help us tell what’s causing the issue.
{“level”:30,“time”:1576483613955,“type”:“browser”,“name”:“main”,“opts”:{"_":[],“environment”:“production”,“env”:“production”,“auto-updates”:true,“ignore-gpu-blacklist”:false,“debug”:false,“trace”:false,“port”:null,“p”:null,"$0":“tropy.exe”,“data”:“C:\Users\Drame\AppData\Roaming\Tropy”,“cache”:“C:\Users\Drame\AppData\Roaming\Tropy\cache”,“logs”:“C:\Users\Drame\AppData\Roaming\Tropy\electron\Tropy\logs”},“version”:“1.6.0”,“msg”:“main.init 1.6.0 Windows_NT 10.0.18362 (x64)”,“v”:1}
{“level”:30,“time”:1576483614229,“type”:“browser”,“name”:“main”,“msg”:“plugins scanned: 0”,“v”:1}
{“level”:30,“time”:1576483614235,“type”:“browser”,“name”:“main”,“msg”:“app state restored”,“v”:1}
{“level”:30,“time”:1576483614308,“type”:“browser”,“name”:“main”,“file”:“C:\Phd_tropy_data_analysis\Tropy_annotations\tropy_Tawhid\tropy_tawhid.tpy”,“msg”:“open new project window”,“v”:1}
{“level”:30,“time”:1576483614474,“type”:“browser”,“name”:“main”,“msg”:“ready after 569ms [req:98ms]”,“v”:1}
{“level”:30,“time”:1576483618232,“type”:“renderer”,“name”:“project”,“dpx”:1,“opts”:{“aqua”:false,“dark”:false,“environment”:“production”,“documents”:“C:\Users\Drame\Documents”,“maximizable”:true,“minimizable”:true,“pictures”:“C:\Users\Drame\Pictures”,“scrollbars”:true,“theme”:“light”,“file”:“C:\Phd_tropy_data_analysis\Tropy_annotations\tropy_Tawhid\tropy_tawhid.tpy”,“recent”:[“C:\Phd_tropy_data_analysis\Tropy_annotations\tropy_Tawhid\tropy_tawhid.tpy”,“C:\Phd_tropy_data_analysis\Tropy_annotations\tropy_annotations_analysis\tropy_annoattions_analysis.tpy”,“C:\Phd_tropy_data_analysis\Tropy_annotations\tropy_maqāma_al-ḥarīr\tropy_maqāma_al-ḥarīr.tpy”],“data”:“C:\Users\Drame\AppData\Roaming\Tropy”,“debug”:false,“dev”:false,“cache”:“C:\Users\Drame\AppData\Roaming\Tropy\cache”,“plugins”:“C:\Users\Drame\AppData\Roaming\Tropy\plugins”,“frameless”:false,“level”:“info”,“locale”:“en”,“log”:“C:\Users\Drame\AppData\Roaming\Tropy\electron\Tropy\logs\tropy.log”,“uuid”:“b5697060-a1a6-11e9-a4e0-a976b9ba6f4c”,“update”:{},“version”:“1.6.0”,“webgl”:true,“zoom”:1},“msg”:“project.init”,“v”:1}
{“level”:30,“time”:1576483618586,“type”:“renderer”,“name”:“project”,“msg”:“plugins scanned: 0”,“v”:1}
{“level”:30,“time”:1576483618586,“type”:“renderer”,“name”:“project”,“msg”:“plugins loaded: 0”,“v”:1}
{“level”:30,“time”:1576483624767,“type”:“renderer”,“name”:“project”,“msg”:“open db C:\Users\Drame\AppData\Roaming\Tropy\ontology.db”,“v”:1}
{“level”:30,“time”:1576483624774,“type”:“renderer”,“name”:“project”,“msg”:“restoring recent@tropy”,“v”:1}
{“level”:30,“time”:1576483624975,“type”:“renderer”,“name”:“project”,“msg”:“restoring settings@tropy”,“v”:1}
{“level”:30,“time”:1576483624976,“type”:“renderer”,“name”:“project”,“msg”:“restoring ui@tropy”,“v”:1}
{“level”:30,“time”:1576483625027,“type”:“renderer”,“name”:“project”,“msg”:“project ready 6913ms [dom:401ms win:71ms req:6394ms]”,“v”:1}
{“level”:30,“time”:1576483625102,“type”:“renderer”,“name”:“project”,“msg”:“open db C:\Phd_tropy_data_analysis\Tropy_annotations\tropy_Tawhid\tropy_tawhid.tpy”,“v”:1}
{“level”:30,“time”:1576483626492,“type”:“renderer”,“name”:“project”,“msg”:“esper using webgl renderer”,“v”:1}
{“level”:30,“time”:1576483626691,“type”:“renderer”,“name”:“project”,“msg”:“open db C:\Phd_tropy_data_analysis\Tropy_annotations\tropy_Tawhid\tropy_tawhid.tpy”,“v”:1}
{“level”:30,“time”:1576483626840,“type”:“renderer”,“name”:“project”,“msg”:“db query took 111ms”,“query”:"\n SELECT\n datatype_id AS id,\n vocabulary_id AS vocabulary,\n dt.description,\n dt.comment,\n label\n FROM datatypes dt\n JOIN vocabularies v USING (vocabulary_id)\n LEFT OUTER JOIN labels ON (datatype_id = id AND language = ?)\n WHERE deleted is NULL",“ms”:111,“v”:1}
{“level”:30,“time”:1576483626943,“type”:“renderer”,“name”:“project”,“msg”:“db query took 101ms”,“query”:"\n SELECT\n property_id AS id,\n vocabulary_id AS vocabulary,\n p.description,\n p.comment,\n label\n FROM properties p\n JOIN vocabularies v USING (vocabulary_id)\n LEFT JOIN labels ON (property_id = id AND language = ?)\n WHERE deleted is NULL",“ms”:101,“v”:1}
{“level”:40,“time”:1576483627073,“type”:“renderer”,“name”:“project”,“query”:"\n INSERT INTO access (uuid, version, path) VALUES (?, ?, ?)",“ms”:258,“msg”:“SLOW: db query took 258ms”,“v”:1}
{“level”:30,“time”:1576483627175,“type”:“renderer”,“name”:“project”,“msg”:“db query took 101ms”,“query”:“PRAGMA integrity_check(10)”,“ms”:101,“v”:1}
{“level”:30,“time”:1576483627206,“type”:“renderer”,“name”:“project”,“msg”:“restoring nav@d4240af1-6778-4667-9e60-dc93cc88bfac”,“v”:1}
{“level”:30,“time”:1576483627207,“type”:“renderer”,“name”:“project”,“msg”:“restoring notepad@d4240af1-6778-4667-9e60-dc93cc88bfac”,“v”:1}
{“level”:30,“time”:1576483627207,“type”:“renderer”,“name”:“project”,“msg”:“restoring esper@d4240af1-6778-4667-9e60-dc93cc88bfac”,“v”:1}
{“level”:30,“time”:1576483627207,“type”:“renderer”,“name”:“project”,“msg”:“restoring imports@d4240af1-6778-4667-9e60-dc93cc88bfac”,“v”:1}
{“level”:30,“time”:1576483627207,“type”:“renderer”,“name”:“project”,“msg”:“restoring sidebar@d4240af1-6778-4667-9e60-dc93cc88bfac”,“v”:1}
{“level”:30,“time”:1576483627208,“type”:“renderer”,“name”:“project”,“msg”:“restoring panel@d4240af1-6778-4667-9e60-dc93cc88bfac”,“v”:1}
{“level”:30,“time”:1576483627301,“type”:“renderer”,“name”:“project”,“msg”:“open db C:\Phd_tropy_data_analysis\Tropy_annotations\tropy_Tawhid\tropy_tawhid.tpy”,“v”:1}
{“level”:40,“time”:1576483628496,“type”:“renderer”,“name”:“project”,“ms”:1176,“list”:false,“query”:"",“tags”:false,“msg”:“SLOW: *search query “” took 1176ms”,“v”:1}
{“level”:40,“time”:1576483667044,“type”:“renderer”,“name”:“project”,“query”:“UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, path = $new_path, size = $new_size WHERE id = $id”,“ms”:229,“msg”:“SLOW: db query took 229ms”,“v”:1}
{“level”:40,“time”:1576483671529,“type”:“renderer”,“name”:“project”,“query”:“UPDATE photos SET checksum = $new_checksum, color = $new_color, mimetype = $new_mimetype, orientation = $new_orientation, path = $new_path, size = $new_size WHERE id = $id”,“ms”:274,“msg”:“SLOW: db query took 274ms”,“v”:1}
{“level”:40,“time”:1576483671574,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: photo.consolidate”,“v”:1}
{“level”:30,“time”:1576483674872,“type”:“browser”,“name”:“main”,“msg”:“checking for updates…”,“v”:1}
{“level”:30,“time”:1576483680934,“type”:“browser”,“name”:“main”,“msg”:“no updates available”,“v”:1}
{“level”:40,“time”:1576483906664,“type”:“renderer”,“name”:“project”,“query”:"\n INSERT INTO subjects (template) VALUES (?)",“ms”:183,“msg”:“SLOW: db query took 183ms”,“v”:1}
{“level”:40,“time”:1576483907353,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:588,“msg”:“SLOW: db query took 588ms”,“v”:1}
{“level”:40,“time”:1576483908987,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: selection.create”,“v”:1}
{“level”:40,“time”:1576483928385,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:386,“msg”:“SLOW: db query took 386ms”,“v”:1}
{“level”:40,“time”:1576483955761,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:403,“msg”:“SLOW: db query took 403ms”,“v”:1}
{“level”:40,“time”:1576483971596,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:338,“msg”:“SLOW: db query took 338ms”,“v”:1}
{“level”:40,“time”:1576483980352,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:345,“msg”:“SLOW: db query took 345ms”,“v”:1}
{“level”:40,“time”:1576483987140,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:1328,“msg”:“SLOW: db query took 1328ms”,“v”:1}
{“level”:40,“time”:1576484010356,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:344,“msg”:“SLOW: db query took 344ms”,“v”:1}
{“level”:40,“time”:1576484048191,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:448,“msg”:“SLOW: db query took 448ms”,“v”:1}
{“level”:40,“time”:1576484054852,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:381,“msg”:“SLOW: db query took 381ms”,“v”:1}
{“level”:40,“time”:1576484137545,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:767,“msg”:“SLOW: db query took 767ms”,“v”:1}
{“level”:40,“time”:1576484143902,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:230,“msg”:“SLOW: db query took 230ms”,“v”:1}
{“level”:40,“time”:1576484151034,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:380,“msg”:“SLOW: db query took 380ms”,“v”:1}
{“level”:40,“time”:1576484179330,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:377,“msg”:“SLOW: db query took 377ms”,“v”:1}
{“level”:40,“time”:1576484202399,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:365,“msg”:“SLOW: db query took 365ms”,“v”:1}
{“level”:40,“time”:1576484242303,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:519,“msg”:“SLOW: db query took 519ms”,“v”:1}
{“level”:30,“time”:1576484298609,“type”:“renderer”,“name”:“project”,“msg”:“pruning cache d4240af1-6778-4667-9e60-dc93cc88bfac”,“v”:1}
{“level”:30,“time”:1576484298665,“type”:“renderer”,“name”:“project”,“msg”:“purging cache C:\Users\Drame\AppData\Roaming\Tropy\cache”,“v”:1}
{“level”:30,“time”:1576484299046,“type”:“renderer”,“name”:“project”,“msg”:“cleared 4 file(s) from cache”,“v”:1}
{“level”:40,“time”:1576484536975,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:581,“msg”:“SLOW: db query took 581ms”,“v”:1}
{“level”:40,“time”:1576484542337,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:697,“msg”:“SLOW: db query took 697ms”,“v”:1}
{“level”:40,“time”:1576484569610,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:482,“msg”:“SLOW: db query took 482ms”,“v”:1}
{“level”:40,“time”:1576484580392,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:319,“msg”:“SLOW: db query took 319ms”,“v”:1}
{“level”:40,“time”:1576484604865,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:297,“msg”:“SLOW: db query took 297ms”,“v”:1}
{“level”:40,“time”:1576484665134,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:732,“msg”:“SLOW: db query took 732ms”,“v”:1}
{“level”:40,“time”:1576484666259,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: selection.create”,“v”:1}
{“level”:40,“time”:1576484677388,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:273,“msg”:“SLOW: db query took 273ms”,“v”:1}
{“level”:40,“time”:1576484691102,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:231,“msg”:“SLOW: db query took 231ms”,“v”:1}
{“level”:40,“time”:1576484699227,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:742,“msg”:“SLOW: db query took 742ms”,“v”:1}
{“level”:40,“time”:1576484710443,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:426,“msg”:“SLOW: db query took 426ms”,“v”:1}
{“level”:40,“time”:1576484729318,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:789,“msg”:“SLOW: db query took 789ms”,“v”:1}
{“level”:40,“time”:1576484738360,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:395,“msg”:“SLOW: db query took 395ms”,“v”:1}
{“level”:40,“time”:1576484759476,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:446,“msg”:“SLOW: db query took 446ms”,“v”:1}
{“level”:40,“time”:1576484772471,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:332,“msg”:“SLOW: db query took 332ms”,“v”:1}
{“level”:40,“time”:1576484782329,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:1410,“msg”:“SLOW: db query took 1410ms”,“v”:1}
{“level”:40,“time”:1576484794737,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:1167,“msg”:“SLOW: db query took 1167ms”,“v”:1}
{“level”:40,“time”:1576484802582,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:788,“msg”:“SLOW: db query took 788ms”,“v”:1}
{“level”:40,“time”:1576484810716,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:371,“msg”:“SLOW: db query took 371ms”,“v”:1}
{“level”:40,“time”:1576484830880,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: note.save”,“v”:1}
{“level”:40,“time”:1576484830923,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:1286,“msg”:“SLOW: db query took 1286ms”,“v”:1}
{“level”:30,“time”:1576484855658,“type”:“renderer”,“name”:“project”,“msg”:“db query took 93ms”,“query”:“REPLACE INTO ‘main’.‘fts_notes_data’(id, block) VALUES(?,?)”,“ms”:93,“v”:1}
{“level”:40,“time”:1576484856427,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:1159,“msg”:“SLOW: db query took 1159ms”,“v”:1}
{“level”:40,“time”:1576484909303,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:461,“msg”:“SLOW: db query took 461ms”,“v”:1}
{“level”:40,“time”:1576485034597,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:1145,“msg”:“SLOW: db query took 1145ms”,“v”:1}
{“level”:40,“time”:1576485052843,“type”:“renderer”,“name”:“project”,“query”:“INSERT INTO ‘main’.‘fts_notes_idx’(segid,term,pgno) VALUES(?,?,?)”,“ms”:353,“msg”:“SLOW: db query took 353ms”,“v”:1}
{“level”:40,“time”:1576485054003,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: note.save”,“v”:1}
{“level”:40,“time”:1576485054005,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:1535,“msg”:“SLOW: db query took 1535ms”,“v”:1}
{“level”:40,“time”:1576485072041,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:750,“msg”:“SLOW: db query took 750ms”,“v”:1}
{“level”:40,“time”:1576485105712,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:154,“msg”:“SLOW: db query took 154ms”,“v”:1}
{“level”:40,“time”:1576485107028,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: selection.create”,“v”:1}
{“level”:40,“time”:1576485120953,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: metadata.save”,“v”:1}
{“level”:40,“time”:1576485121000,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:1527,“msg”:“SLOW: db query took 1527ms”,“v”:1}
{“level”:40,“time”:1576485137464,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:186,“msg”:“SLOW: db query took 186ms”,“v”:1}
{“level”:40,“time”:1576485165986,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:226,“msg”:“SLOW: db query took 226ms”,“v”:1}
{“level”:40,“time”:1576485176735,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:369,“msg”:“SLOW: db query took 369ms”,“v”:1}
{“level”:40,“time”:1576485198540,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:13293,“msg”:“SLOW: db query took 13293ms”,“v”:1}
{“level”:40,“time”:1576485198546,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: note.save”,“v”:1}
{“level”:40,“time”:1576485207869,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:2728,“msg”:“SLOW: db query took 2728ms”,“v”:1}
{“level”:40,“time”:1576485207873,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: note.save”,“v”:1}
{“level”:40,“time”:1576485300603,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:321,“msg”:“SLOW: db query took 321ms”,“v”:1}
{“level”:40,“time”:1576485314185,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:424,“msg”:“SLOW: db query took 424ms”,“v”:1}
{“level”:40,“time”:1576485332104,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:235,“msg”:“SLOW: db query took 235ms”,“v”:1}
{“level”:40,“time”:1576485351390,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:948,“msg”:“SLOW: db query took 948ms”,“v”:1}
{“level”:40,“time”:1576485356757,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:1055,“msg”:“SLOW: db query took 1055ms”,“v”:1}
{“level”:40,“time”:1576485364161,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:525,“msg”:“SLOW: db query took 525ms”,“v”:1}
{“level”:40,“time”:1576485378334,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:751,“msg”:“SLOW: db query took 751ms”,“v”:1}
{“level”:40,“time”:1576485404303,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: note.save”,“v”:1}
{“level”:40,“time”:1576485404305,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:2477,“msg”:“SLOW: db query took 2477ms”,“v”:1}
{“level”:40,“time”:1576485442551,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:953,“msg”:“SLOW: db query took 953ms”,“v”:1}
{“level”:40,“time”:1576485488964,“type”:“browser”,“name”:“main”,“msg”:“project[1] has become unresponsive”,“v”:1}
{“level”:40,“time”:1576485519136,“type”:“browser”,“name”:“main”,“msg”:“project[1] has become unresponsive”,“v”:1}
{“level”:40,“time”:1576487717709,“type”:“renderer”,“name”:“project”,“query”:“BEGIN IMMEDIATE TRANSACTION”,“ms”:295,“msg”:“SLOW: db query took 295ms”,“v”:1}
{“level”:30,“time”:1576487717944,“type”:“renderer”,“name”:“project”,“msg”:“db query took 80ms”,“query”:“UPDATE images SET angle = $new_angle, mirror = $new_mirror, negative = $new_negative, brightness = $new_brightness, contrast = $new_contrast, hue = $new_hue, saturation = $new_saturation, sharpen = $new_sharpen WHERE id = $id”,“ms”:80,“v”:1}
{“level”:40,“time”:1576487719163,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: selection.save”,“v”:1}
{“level”:40,“time”:1576487719919,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:998,“msg”:“SLOW: db query took 998ms”,“v”:1}
{“level”:40,“time”:1576487720625,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:321,“msg”:“SLOW: db query took 321ms”,“v”:1}
{“level”:40,“time”:1576487729833,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:1144,“msg”:“SLOW: db query took 1144ms”,“v”:1}
{“level”:40,“time”:1576487730688,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:357,“msg”:“SLOW: db query took 357ms”,“v”:1}
{“level”:40,“time”:1576487734408,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:269,“msg”:“SLOW: db query took 269ms”,“v”:1}
{“level”:40,“time”:1576488085270,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:1129,“msg”:“SLOW: db query took 1129ms”,“v”:1}
{“level”:40,“time”:1576488137017,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:627,“msg”:“SLOW: db query took 627ms”,“v”:1}
{“level”:30,“time”:1576488210036,“type”:“renderer”,“name”:“project”,“msg”:“db query took 104ms”,“query”:"\n SELECT id, note_id AS note\n FROM notes JOIN selections USING (id)\n WHERE id IN (248) AND\n deleted IS NULL\n ORDER BY id, created",“ms”:104,“v”:1}
{“level”:40,“time”:1576488210506,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:342,“msg”:“SLOW: db query took 342ms”,“v”:1}
{“level”:40,“time”:1576488211786,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: selection.create”,“v”:1}
{“level”:30,“time”:1576488224475,“type”:“renderer”,“name”:“project”,“msg”:“db query took 98ms”,“query”:"\n DELETE FROM metadata WHERE id IN (248) AND property IN (“http://purl.org/dc/elements/1.1/title")",“ms”:98,"v”:1}
{“level”:40,“time”:1576488224689,“type”:“renderer”,“name”:“project”,“query”:"\n INSERT INTO metadata_values (datatype, text)\n VALUES (?, ?)",“ms”:163,“msg”:“SLOW: db query took 163ms”,“v”:1}
{“level”:40,“time”:1576488225097,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:322,“msg”:“SLOW: db query took 322ms”,“v”:1}
{“level”:30,“time”:1576488274382,“type”:“renderer”,“name”:“project”,“msg”:“db query took 62ms”,“query”:“INSERT INTO ‘main’.‘fts_notes_idx’(segid,term,pgno) VALUES(?,?,?)”,“ms”:62,“v”:1}
{“level”:30,“time”:1576488274382,“type”:“renderer”,“name”:“project”,“msg”:“db query took 114ms”,“query”:"\n INSERT INTO notes (id, state, text) VALUES (?,?,?)",“ms”:114,“v”:1}
{“level”:40,“time”:1576488275082,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:460,“msg”:“SLOW: db query took 460ms”,“v”:1}
{“level”:40,“time”:1576488312833,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: note.save”,“v”:1}
{“level”:40,“time”:1576488312836,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:2127,“msg”:“SLOW: db query took 2127ms”,“v”:1}
{“level”:40,“time”:1576488318188,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:607,“msg”:“SLOW: db query took 607ms”,“v”:1}
{“level”:40,“time”:1576488322921,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:515,“msg”:“SLOW: db query took 515ms”,“v”:1}
{“level”:40,“time”:1576488335344,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:424,“msg”:“SLOW: db query took 424ms”,“v”:1}
{“level”:40,“time”:1576488342411,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:424,“msg”:“SLOW: db query took 424ms”,“v”:1}
{“level”:40,“time”:1576488356574,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:568,“msg”:“SLOW: db query took 568ms”,“v”:1}
{“level”:40,“time”:1576488362566,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:1571,“msg”:“SLOW: db query took 1571ms”,“v”:1}
{“level”:40,“time”:1576488362573,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: note.save”,“v”:1}
{“level”:40,“time”:1576488402659,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:861,“msg”:“SLOW: db query took 861ms”,“v”:1}
{“level”:40,“time”:1576488428538,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: note.save”,“v”:1}
{“level”:40,“time”:1576488428540,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:1694,“msg”:“SLOW: db query took 1694ms”,“v”:1}
{“level”:40,“time”:1576488443760,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:392,“msg”:“SLOW: db query took 392ms”,“v”:1}
{“level”:40,“time”:1576488452019,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:461,“msg”:“SLOW: db query took 461ms”,“v”:1}
{“level”:40,“time”:1576488463865,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:521,“msg”:“SLOW: db query took 521ms”,“v”:1}
{“level”:40,“time”:1576488470565,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:797,“msg”:“SLOW: db query took 797ms”,“v”:1}
{“level”:40,“time”:1576488564676,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:941,“msg”:“SLOW: db query took 941ms”,“v”:1}
{“level”:40,“time”:1576488601780,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:955,“msg”:“SLOW: db query took 955ms”,“v”:1}
{“level”:40,“time”:1576488612718,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:452,“msg”:“SLOW: db query took 452ms”,“v”:1}
{“level”:40,“time”:1576488623174,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:427,“msg”:“SLOW: db query took 427ms”,“v”:1}
{“level”:30,“time”:1576488665050,“type”:“renderer”,“name”:“project”,“msg”:“db query took 137ms”,“query”:"\n INSERT INTO subjects (template) VALUES (?)",“ms”:137,“v”:1}
{“level”:40,“time”:1576488665573,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:459,“msg”:“SLOW: db query took 459ms”,“v”:1}
{“level”:40,“time”:1576488667123,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: selection.create”,“v”:1}
{“level”:30,“time”:1576488678176,“type”:“renderer”,“name”:“project”,“msg”:“db query took 52ms”,“query”:“SELECT k, v FROM ‘main’.‘fts_metadata_config’”,“ms”:52,“v”:1}
{“level”:30,“time”:1576488678230,“type”:“renderer”,“name”:“project”,“msg”:“db query took 51ms”,“query”:"\n INSERT INTO metadata_values (datatype, text)\n VALUES (?, ?)",“ms”:51,“v”:1}
{“level”:40,“time”:1576488678774,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:403,“msg”:“SLOW: db query took 403ms”,“v”:1}
{“level”:40,“time”:1576488692974,“type”:“renderer”,“name”:“project”,“query”:“COMMIT TRANSACTION”,“ms”:283,“msg”:“SLOW: db query took 283ms”,“v”:1}
{“level”:40,“time”:1576488716451,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:900,“msg”:“SLOW: db query took 900ms”,“v”:1}
{“level”:40,“time”:1576488735098,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:300,“msg”:“SLOW: db query took 300ms”,“v”:1}
{“level”:40,“time”:1576488747432,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:857,“msg”:“SLOW: db query took 857ms”,“v”:1}
{“level”:40,“time”:1576488776975,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:513,“msg”:“SLOW: db query took 513ms”,“v”:1}
{“level”:40,“time”:1576488843787,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:343,“msg”:“SLOW: db query took 343ms”,“v”:1}
{“level”:40,“time”:1576488867987,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:362,“msg”:“SLOW: db query took 362ms”,“v”:1}
{“level”:40,“time”:1576488898270,“type”:“renderer”,“name”:“project”,“query”:"\n UPDATE notes\n SET state = $state, modified = datetime($modified), text = $text\n WHERE note_id = $id",“ms”:478,“msg”:“SLOW: db query took 478ms”,“v”:1}
{“level”:30,“time”:1576489014298,“type”:“browser”,“name”:“main”,“msg”:“checking for updates…”,“v”:1}
{“level”:30,“time”:1576489025056,“type”:“browser”,“name”:“main”,“msg”:“no updates available”,“v”:1}
Hello,
I am still waiting for your reply about the precedent post. PLease, can you tell me if there is nothing to worry about. I am unconfortable about this situation because I do not know if it won’t affect my project data.
How many items are there in your project? The database queries seem extremely slow, I assume this is why the warning shows up. When did the warning start to appear? Did you make any changes before that (e.g., import a lot of new items, move to a new computer or hard drive, etc.)?
For the whole, I have 11 projects on tropy. What I did is for the better organisation of the manuscripts considered, I created a separate project for each set of Mss (based on the manusript genre of course). Some projects contain a very important amount of items whereas others not. For instance, the current project has only 94 items. The warning started appearing when I recently created another project containing 382 items. I am using only one computer for my tropy projects. I notice in general that my computer is very slow, may be this can be the source of the problem. I am very careful about the unusual signs appearance to make sure that every thing is going well.
In such a situation, what would you recommend to do?