Tropy crashing resulting in loss of data

Troubleshooting
1

Dear,

Since I updated Tropy in February 2024, the system crashes regularly when importing files or entering notes. The main storage is on our uni.server (Atlas).
Yesterday (15.04.2024), the program crashed while importing a file, resulting in the loss of all my notes from last week (over three full days of work).

Here are today’s log files of today 11: 11 (called “tropy”) (not sure if this helps):

{“level”:30,“time”:1713251574928,“type”:“browser”,“name”:“main”,“args”:,“opts”:{“env”:“production”,“autoUpdates”:true,“contextIsolation”:true,“webgl”:false,“verbose”:false,“trace”:false,“data”:“C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy”,“cache”:“C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\cache”,“logs”:“C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\log”},“version”:“1.16.2”,“msg”:“main.init 1.16.2 Windows_NT 10.0.19045 (x64)”}
{“level”:30,“time”:1713251574979,“type”:“browser”,“name”:“main”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1713251574980,“type”:“browser”,“name”:“main”,“msg”:“app state restored”}
{“level”:30,“time”:1713251574982,“type”:“browser”,“name”:“main”,“file”:“C:\Users\sarahmaya.vercruysse\Documents\WARLUX.tpy”,“msg”:“open new project window”}
{“level”:30,“time”:1713251575273,“type”:“browser”,“name”:“main”,“status”:{“2d_canvas”:“enabled”,“canvas_oop_rasterization”:“enabled_on”,“direct_rendering_display_compositor”:“disabled_off_ok”,“gpu_compositing”:“enabled”,“multiple_raster_threads”:“enabled_on”,“opengl”:“enabled_on”,“rasterization”:“enabled”,“raw_draw”:“disabled_off_ok”,“skia_graphite”:“disabled_off”,“video_decode”:“enabled”,“video_encode”:“enabled”,“vulkan”:“disabled_off”,“webgl”:“enabled”,“webgl2”:“enabled”,“webgpu”:“enabled”},“msg”:“gpu-info-update”}
{“level”:30,“time”:1713251575604,“type”:“renderer”,“name”:“project”,“dpx”:1,“args”:{“frameless”:true,“locale”:“en”,“webgl”:true,“zoom”:1},“msg”:“project.init”}
{“level”:30,“time”:1713251575673,“type”:“renderer”,“name”:“project”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1713251575673,“type”:“renderer”,“name”:“project”,“msg”:“plugins loaded: 0”}
{“level”:30,“time”:1713251576361,“type”:“renderer”,“name”:“project”,“msg”:“restoring projectFiles@tropy”}
{“level”:30,“time”:1713251576369,“type”:“renderer”,“name”:“project”,“msg”:“restoring recent@tropy”}
{“level”:30,“time”:1713251576369,“type”:“renderer”,“name”:“project”,“msg”:“restoring settings@tropy”}
{“level”:30,“time”:1713251576370,“type”:“renderer”,“name”:“project”,“msg”:“restoring ui@tropy”}
{“level”:30,“time”:1713251576373,“type”:“renderer”,“name”:“project”,“mode”:“w+”,“msg”:“open db C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\ontology.db”}
{“level”:30,“time”:1713251576380,“type”:“browser”,“name”:“main”,“msg”:“ready after 769.6650390625ms”}
{“level”:30,“time”:1713251576683,“type”:“renderer”,“name”:“project”,“mode”:“webgl”,“resolution”:1,“msg”:“Esper.instance created with webgl renderer”}
{“level”:30,“time”:1713251576717,“type”:“renderer”,“name”:“project”,“mode”:“w”,“msg”:“open db C:\Users\sarahmaya.vercruysse\Documents\WARLUX.tpy”}
{“level”:30,“time”:1713251576809,“type”:“renderer”,“name”:“project”,“msg”:“project ready 1707ms [dom:533ms init:79ms load:658ms]”}
{“level”:40,“time”:1713251577493,“type”:“renderer”,“name”:“project”,“query”:“VACUUM”,“ms”:681,“msg”:“SLOW: db query took 681ms”}
{“level”:30,“time”:1713251577633,“type”:“renderer”,“name”:“project”,“msg”:“db query took 132ms”,“query”:“PRAGMA integrity_check(10)”,“ms”:132}
{“level”:30,“time”:1713251577670,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251577675,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251577676,“type”:“renderer”,“name”:“project”,“msg”:“restoring nav@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251577676,“type”:“renderer”,“name”:“project”,“msg”:“restoring notepad@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251577676,“type”:“renderer”,“name”:“project”,“msg”:“restoring esper@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251577681,“type”:“renderer”,“name”:“project”,“msg”:“restoring imports@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251577682,“type”:“renderer”,“name”:“project”,“msg”:“restoring sidebar@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251577682,“type”:“renderer”,“name”:“project”,“msg”:“restoring panel@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251577701,“type”:“renderer”,“name”:“project”,“mode”:“w”,“msg”:“open db C:\Users\sarahmaya.vercruysse\Documents\WARLUX.tpy”}
{“level”:30,“time”:1713251577702,“type”:“renderer”,“name”:“project”,“mode”:“w”,“msg”:“open db C:\Users\sarahmaya.vercruysse\Documents\WARLUX.tpy”}
{“level”:30,“time”:1713251578107,“type”:“renderer”,“name”:“project”,“msg”:“db query took 101ms”,“query”:“\n SELECT\n id,\n template,\n strftime("%Y-%m-%dT%H:%M:%f", created, "localtime") AS created,\n strftime("%Y-%m-%dT%H:%M:%f", modified, "localtime") AS modified,\n deleted\n FROM subjects\n JOIN items USING (id)\n LEFT OUTER JOIN trash USING (id)”,“ms”:101}
{“level”:40,“time”:1713251579430,“type”:“renderer”,“name”:“project”,“query”:“\n SELECT\n id,\n item_id AS item,\n template,\n strftime("%Y-%m-%dT%H:%M:%f", created, "localtime") AS created,\n strftime("%Y-%m-%dT%H:%M:%f", modified, "localtime") AS modified,\n angle,\n color,\n density,\n mirror,\n negative,\n brightness,\n contrast,\n hue,\n saturation,\n sharpen,\n width,\n height,\n path,\n filename,\n page,\n size,\n protocol,\n mimetype,\n checksum,\n orientation\n FROM subjects\n JOIN images USING (id)\n JOIN photos USING (id)”,“ms”:553,“msg”:“SLOW: db query took 553ms”}
{“level”:40,“time”:1713251579431,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: photo.load#20”}
{“level”:40,“time”:1713251579458,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: item.load#19”}
{“level”:40,“time”:1713251579783,“type”:“renderer”,“name”:“project”,“query”:“\n SELECT id, property, text, datatype AS type\n FROM subjects\n JOIN metadata USING (id)\n JOIN metadata_values USING (value_id) ORDER BY id, metadata.created ASC”,“ms”:252,“msg”:“SLOW: db query took 252ms”}
{“level”:40,“time”:1713251579784,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: metadata.load#21”}
{“level”:40,“time”:1713251579918,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: note.load#23”}
{“level”:40,“time”:1713251579920,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: selection.load#22”}
{“level”:40,“time”:1713251580001,“type”:“renderer”,“name”:“project”,“ms”:2291,“list”:null,“query”:“”,“tags”:false,“trash”:null,“msg”:“SLOW: *search query "" took 2291ms”}
{“level”:30,“time”:1713251634990,“type”:“browser”,“name”:“main”,“msg”:“checking for updates…”}
{“level”:30,“time”:1713251635582,“type”:“browser”,“name”:“main”,“msg”:“no updates available”}
{“level”:30,“time”:1713251695441,“type”:“browser”,“name”:“main”,“status”:{“2d_canvas”:“enabled”,“canvas_oop_rasterization”:“enabled_on”,“direct_rendering_display_compositor”:“disabled_off_ok”,“gpu_compositing”:“enabled”,“multiple_raster_threads”:“enabled_on”,“opengl”:“enabled_on”,“rasterization”:“enabled”,“raw_draw”:“disabled_off_ok”,“skia_graphite”:“disabled_off”,“video_decode”:“enabled”,“video_encode”:“enabled”,“vulkan”:“disabled_off”,“webgl”:“enabled”,“webgl2”:“enabled”,“webgpu”:“enabled”},“msg”:“gpu-info-update”}
{“level”:30,“time”:1713251701378,“type”:“browser”,“name”:“main”,“status”:{“2d_canvas”:“enabled”,“canvas_oop_rasterization”:“enabled_on”,“direct_rendering_display_compositor”:“disabled_off_ok”,“gpu_compositing”:“enabled”,“multiple_raster_threads”:“enabled_on”,“opengl”:“enabled_on”,“rasterization”:“enabled”,“raw_draw”:“disabled_off_ok”,“skia_graphite”:“disabled_off”,“video_decode”:“enabled”,“video_encode”:“enabled”,“vulkan”:“disabled_off”,“webgl”:“enabled”,“webgl2”:“enabled”,“webgpu”:“enabled”},“msg”:“gpu-info-update”}
{“level”:30,“time”:1713252326295,“type”:“renderer”,“name”:“project”,“msg”:“pruning cache 9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713252326301,“type”:“renderer”,“name”:“project”,“msg”:“purging cache C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\cache”}
{“level”:30,“time”:1713256975013,“type”:“browser”,“name”:“main”,“msg”:“checking for updates…”}
{“level”:30,“time”:1713256975975,“type”:“browser”,“name”:“main”,“msg”:“no updates available”}
{“level”:30,“time”:1713258601979,“type”:“renderer”,“name”:“prefs”,“dpx”:1,“args”:{“frameless”:true,“locale”:“en”,“webgl”:true,“zoom”:1},“msg”:“prefs.init”}
{“level”:30,“time”:1713258602028,“type”:“renderer”,“name”:“prefs”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1713258602154,“type”:“browser”,“name”:“main”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1713258602170,“type”:“renderer”,“name”:“project”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1713258602170,“type”:“renderer”,“name”:“project”,“msg”:“plugins loaded: 0”}
{“level”:30,“time”:1713258602028,“type”:“renderer”,“name”:“prefs”,“msg”:“plugins loaded: 0”}
{“level”:30,“time”:1713258602520,“type”:“renderer”,“name”:“prefs”,“msg”:“restoring prefs@tropy”}
{“level”:30,“time”:1713258602527,“type”:“renderer”,“name”:“prefs”,“msg”:“restoring settings@tropy”}
{“level”:30,“time”:1713258602530,“type”:“renderer”,“name”:“prefs”,“mode”:“w+”,“msg”:“open db C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\ontology.db”}
{“level”:30,“time”:1713258602714,“type”:“renderer”,“name”:“prefs”,“mode”:“w”,“msg”:“open db C:\Users\sarahmaya.vercruysse\Documents\WARLUX.tpy”}
{“level”:30,“time”:1713258602721,“type”:“renderer”,“name”:“prefs”,“msg”:“prefs ready 1242ms [dom:525ms init:24ms load:449ms]”}
{“level”:30,“time”:1713258602724,“type”:“renderer”,“name”:“prefs”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1713258602725,“type”:“renderer”,“name”:“prefs”,“msg”:“plugins loaded: 0”}
{“level”:30,“time”:1713258602728,“type”:“renderer”,“name”:“prefs”,“mode”:“w+”,“msg”:“open db C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\ontology.db”}
{“level”:30,“time”:1713258602730,“type”:“renderer”,“name”:“prefs”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713258614867,“type”:“renderer”,“name”:“prefs”,“msg”:“persisting prefs@tropy”}
{“level”:30,“time”:1713258614871,“type”:“renderer”,“name”:“project”,“msg”:“restoring settings@tropy”}
{“level”:30,“time”:1713258614874,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713258614867,“type”:“renderer”,“name”:“prefs”,“msg”:“persisting settings@tropy”}
{“level”:30,“time”:1713258614876,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713258615116,“type”:“renderer”,“name”:“project”,“msg”:“restoring settings@tropy”}
{“level”:30,“time”:1713258615121,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713258615122,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713258677265,“type”:“renderer”,“name”:“prefs”,“dpx”:1,“args”:{“frameless”:true,“locale”:“en”,“webgl”:true,“zoom”:1},“msg”:“prefs.init”}
{“level”:30,“time”:1713258677297,“type”:“renderer”,“name”:“prefs”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1713258677297,“type”:“renderer”,“name”:“prefs”,“msg”:“plugins loaded: 0”}
{“level”:30,“time”:1713258677751,“type”:“renderer”,“name”:“prefs”,“msg”:“restoring prefs@tropy”}
{“level”:30,“time”:1713258677757,“type”:“renderer”,“name”:“prefs”,“msg”:“restoring settings@tropy”}
{“level”:30,“time”:1713258677761,“type”:“renderer”,“name”:“prefs”,“mode”:“w+”,“msg”:“open db C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\ontology.db”}
{“level”:30,“time”:1713258677893,“type”:“renderer”,“name”:“prefs”,“mode”:“w”,“msg”:“open db C:\Users\sarahmaya.vercruysse\Documents\WARLUX.tpy”}
{“level”:30,“time”:1713258677896,“type”:“renderer”,“name”:“prefs”,“mode”:“w+”,“msg”:“open db C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\ontology.db”}
{“level”:30,“time”:1713258677898,“type”:“renderer”,“name”:“prefs”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713258677907,“type”:“renderer”,“name”:“prefs”,“msg”:“prefs ready 927ms [dom:301ms init:16ms load:391ms]”}
{“level”:30,“time”:1713258701523,“type”:“renderer”,“name”:“prefs”,“msg”:“persisting prefs@tropy”}
{“level”:30,“time”:1713258701525,“type”:“renderer”,“name”:“project”,“msg”:“restoring settings@tropy”}
{“level”:30,“time”:1713258701523,“type”:“renderer”,“name”:“prefs”,“msg”:“persisting settings@tropy”}
{“level”:30,“time”:1713258701531,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713258701532,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713258701758,“type”:“renderer”,“name”:“project”,“msg”:“restoring settings@tropy”}
{“level”:30,“time”:1713258701761,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713258701761,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}

I also saw another log file of today 9:10 (called “tropy.log”):

{“level”:30,“time”:1713186605917,“type”:“browser”,“name”:“main”,“args”:,“opts”:{“env”:“production”,“autoUpdates”:true,“contextIsolation”:true,“webgl”:false,“verbose”:false,“trace”:false,“data”:“C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy”,“cache”:“C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\cache”,“logs”:“C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\log”},“version”:“1.16.2”,“msg”:“main.init 1.16.2 Windows_NT 10.0.19045 (x64)”}
{“level”:30,“time”:1713186605954,“type”:“browser”,“name”:“main”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1713186605956,“type”:“browser”,“name”:“main”,“msg”:“app state restored”}
{“level”:30,“time”:1713186605957,“type”:“browser”,“name”:“main”,“file”:“C:\Users\sarahmaya.vercruysse\Documents\WARLUX.tpy”,“msg”:“open new project window”}
{“level”:30,“time”:1713186606155,“type”:“browser”,“name”:“main”,“status”:{“2d_canvas”:“enabled”,“canvas_oop_rasterization”:“enabled_on”,“direct_rendering_display_compositor”:“disabled_off_ok”,“gpu_compositing”:“enabled”,“multiple_raster_threads”:“enabled_on”,“opengl”:“enabled_on”,“rasterization”:“enabled”,“raw_draw”:“disabled_off_ok”,“skia_graphite”:“disabled_off”,“video_decode”:“enabled”,“video_encode”:“enabled”,“vulkan”:“disabled_off”,“webgl”:“enabled”,“webgl2”:“enabled”,“webgpu”:“enabled”},“msg”:“gpu-info-update”}
{“level”:30,“time”:1713186606340,“type”:“renderer”,“name”:“project”,“dpx”:1,“args”:{“frameless”:true,“locale”:“en”,“webgl”:true,“zoom”:1},“msg”:“project.init”}
{“level”:30,“time”:1713186606375,“type”:“renderer”,“name”:“project”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1713186606375,“type”:“renderer”,“name”:“project”,“msg”:“plugins loaded: 0”}
{“level”:30,“time”:1713186606778,“type”:“renderer”,“name”:“project”,“msg”:“restoring projectFiles@tropy”}
{“level”:30,“time”:1713186606783,“type”:“renderer”,“name”:“project”,“msg”:“restoring recent@tropy”}
{“level”:30,“time”:1713186606783,“type”:“renderer”,“name”:“project”,“msg”:“restoring settings@tropy”}
{“level”:30,“time”:1713186606783,“type”:“renderer”,“name”:“project”,“msg”:“restoring ui@tropy”}
{“level”:30,“time”:1713186606787,“type”:“renderer”,“name”:“project”,“mode”:“w+”,“msg”:“open db C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\ontology.db”}
{“level”:30,“time”:1713186606791,“type”:“browser”,“name”:“main”,“msg”:“ready after 520.15087890625ms”}
{“level”:30,“time”:1713186606806,“type”:“renderer”,“name”:“project”,“msg”:“project ready 769ms [dom:323ms init:30ms load:395ms]”}
{“level”:30,“time”:1713186607022,“type”:“renderer”,“name”:“project”,“mode”:“webgl”,“resolution”:1,“msg”:“Esper.instance created with webgl renderer”}
{“level”:30,“time”:1713186607039,“type”:“renderer”,“name”:“project”,“mode”:“w”,“msg”:“open db C:\Users\sarahmaya.vercruysse\Documents\WARLUX.tpy”}
{“level”:40,“time”:1713186607058,“type”:“renderer”,“name”:“project”,“query”:“\n SELECT count(*) AS count FROM sqlite_schema”,“ms”:230,“msg”:“SLOW: db query took 230ms”}
{“level”:40,“time”:1713186607436,“type”:“renderer”,“name”:“project”,“query”:“VACUUM”,“ms”:360,“msg”:“SLOW: db query took 360ms”}
{“level”:30,“time”:1713186607537,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713186607539,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713186607539,“type”:“renderer”,“name”:“project”,“msg”:“restoring nav@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713186607539,“type”:“renderer”,“name”:“project”,“msg”:“restoring notepad@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713186607540,“type”:“renderer”,“name”:“project”,“msg”:“restoring esper@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713186607542,“type”:“renderer”,“name”:“project”,“msg”:“restoring imports@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713186607542,“type”:“renderer”,“name”:“project”,“msg”:“restoring sidebar@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713186607542,“type”:“renderer”,“name”:“project”,“msg”:“restoring panel@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713186607551,“type”:“renderer”,“name”:“project”,“mode”:“w”,“msg”:“open db C:\Users\sarahmaya.vercruysse\Documents\WARLUX.tpy”}
{“level”:30,“time”:1713186607551,“type”:“renderer”,“name”:“project”,“mode”:“w”,“msg”:“open db C:\Users\sarahmaya.vercruysse\Documents\WARLUX.tpy”}
{“level”:40,“time”:1713186608517,“type”:“renderer”,“name”:“project”,“query”:“\n SELECT\n id,\n item_id AS item,\n template,\n strftime("%Y-%m-%dT%H:%M:%f", created, "localtime") AS created,\n strftime("%Y-%m-%dT%H:%M:%f", modified, "localtime") AS modified,\n angle,\n color,\n density,\n mirror,\n negative,\n brightness,\n contrast,\n hue,\n saturation,\n sharpen,\n width,\n height,\n path,\n filename,\n page,\n size,\n protocol,\n mimetype,\n checksum,\n orientation\n FROM subjects\n JOIN images USING (id)\n JOIN photos USING (id)”,“ms”:366,“msg”:“SLOW: db query took 366ms”}
{“level”:30,“time”:1713186608863,“type”:“renderer”,“name”:“project”,“msg”:“db query took 183ms”,“query”:“\n SELECT id, property, text, datatype AS type\n FROM subjects\n JOIN metadata USING (id)\n JOIN metadata_values USING (value_id) ORDER BY id, metadata.created ASC”,“ms”:183}
{“level”:40,“time”:1713186609128,“type”:“renderer”,“name”:“project”,“ms”:1575,“list”:73,“query”:“”,“tags”:false,“trash”:null,“msg”:“SLOW: *search query "" took 1575ms”}
{“level”:30,“time”:1713251354475,“type”:“browser”,“name”:“main”,“msg”:“checking for updates…”}
{“level”:30,“time”:1713251355238,“type”:“renderer”,“name”:“project”,“msg”:“pruning cache 9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251357844,“type”:“renderer”,“name”:“project”,“msg”:“purging cache C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\cache”}
{“level”:40,“time”:1713251358742,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: cache.purge#37”}
{“level”:30,“time”:1713251363577,“type”:“browser”,“name”:“main”,“status”:{“2d_canvas”:“enabled”,“canvas_oop_rasterization”:“enabled_on”,“direct_rendering_display_compositor”:“disabled_off_ok”,“gpu_compositing”:“enabled”,“multiple_raster_threads”:“enabled_on”,“opengl”:“enabled_on”,“rasterization”:“enabled”,“raw_draw”:“disabled_off_ok”,“skia_graphite”:“disabled_off”,“video_decode”:“enabled”,“video_encode”:“enabled”,“vulkan”:“disabled_off”,“webgl”:“enabled”,“webgl2”:“enabled”,“webgpu”:“enabled”},“msg”:“gpu-info-update”}
{“level”:50,“time”:1713251367851,“type”:“browser”,“name”:“main”,“msg”:“failed to fetch update”}
{“level”:30,“time”:1713251384008,“type”:“browser”,“name”:“main”,“status”:{“2d_canvas”:“enabled”,“canvas_oop_rasterization”:“enabled_on”,“direct_rendering_display_compositor”:“disabled_off_ok”,“gpu_compositing”:“enabled”,“multiple_raster_threads”:“enabled_on”,“opengl”:“enabled_on”,“rasterization”:“enabled”,“raw_draw”:“disabled_off_ok”,“skia_graphite”:“disabled_off”,“video_decode”:“enabled”,“video_encode”:“enabled”,“vulkan”:“disabled_off”,“webgl”:“enabled”,“webgl2”:“enabled”,“webgpu”:“enabled”},“msg”:“gpu-info-update”}
{“level”:30,“time”:1713251442855,“type”:“browser”,“name”:“main”,“msg”:“switch to "light" theme”}
{“level”:40,“time”:1713251451996,“type”:“renderer”,“name”:“project”,“msg”:“SLOW: cache.prune#36”}
{“level”:30,“time”:1713251453633,“type”:“renderer”,“name”:“project”,“msg”:“persisting nav@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251453634,“type”:“renderer”,“name”:“project”,“msg”:“persisting notepad@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251453634,“type”:“renderer”,“name”:“project”,“msg”:“persisting esper@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251453651,“type”:“renderer”,“name”:“project”,“msg”:“persisting imports@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251453652,“type”:“renderer”,“name”:“project”,“msg”:“persisting sidebar@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251453653,“type”:“renderer”,“name”:“project”,“msg”:“persisting panel@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251453765,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713251454119,“type”:“renderer”,“name”:“project”,“msg”:“db query took 153ms”,“query”:“\n DELETE\n FROM metadata_values\n WHERE value_id IN (\n SELECT v.value_id\n FROM metadata_values v\n LEFT OUTER JOIN metadata m\n USING (value_id)\n WHERE m.value_id IS NULL\n )”,“ms”:153}
{“level”:30,“time”:1713251454209,“type”:“renderer”,“name”:“project”,“msg”:“persisting projectFiles@tropy”}
{“level”:30,“time”:1713251454209,“type”:“renderer”,“name”:“project”,“msg”:“persisting recent@tropy”}
{“level”:30,“time”:1713251454209,“type”:“renderer”,“name”:“project”,“msg”:“persisting settings@tropy”}
{“level”:30,“time”:1713251454210,“type”:“renderer”,“name”:“project”,“msg”:“persisting ui@tropy”}
{“level”:30,“time”:1713251454495,“type”:“browser”,“name”:“main”,“msg”:“saving app state”}
{“level”:30,“time”:1713251454515,“type”:“browser”,“name”:“main”,“quit”:true,“code”:0,“msg”:“quit with exit code 0”}

Thanks a lot.

2

Tropy continuously saves your changes to the project file. If the application crashes this should not result in any data loss. If you access the project file on a network drive the most likely reason is that there has been an issue syncing the file. How is your Documents folder shared with the server? Are you accessing the project file only from one device or using several? Is there any file history or backup that you can access? If you’re missing notes over a period of three days, that means the changes you made locally on your computer were either not synced to the server or they were overwritten afterwards. If you share your project with us, we can check the access log to see the exact dates when the file was opened in Tropy.

As far as frequent crashes, there is nothing to see in the period covered by the logs you posted. However, if the crashes happen during import and when typing notes they seem to happen when writing to the project file. It’s difficult to tell without a specific error message, but I’d assume that that this is also related to the way the Documents folder is shared. Could you try disabling the network share or moving the project file out of the shared folder to see if there are any crashes then?

3

Hi @SarahMaya, thanks for sharing your issue here.

I see my colleage @inukshuk had already answer to you while we were talking.

@inukshuk – Sarah is a c2dh colleague of mine, we were in touch and were able to clarify the ‘data loss’ part asap. After closing her project, she didn’t notice she had opened her old advanced (.tpy) project instead of the most recent standard (.tropy) project in which she added the notes she thought that were missing. Now she has created a way to make a clear distinction.

However, the regular crashing is still something we should look at, she explained it is happening when working outside the uni’s network. Please, @SarahMaya let us know if you experience something else and make sure you copy the error message if it pops up again so we can try to help.

4

Dear @alucchesi and @inukshuk ,

Thanks a lot for you help.
I received the error as we speak (while being on campus). I was able to copy it, tropy crashed shortly after.

image

Logs:

{“level”:30,“time”:1713267180216,“type”:“browser”,“name”:“main”,“args”:,“opts”:{“env”:“production”,“autoUpdates”:true,“contextIsolation”:true,“webgl”:false,“verbose”:false,“trace”:false,“data”:“C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy”,“cache”:“C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\cache”,“logs”:“C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\log”},“version”:“1.16.2”,“msg”:“main.init 1.16.2 Windows_NT 10.0.19045 (x64)”}
{“level”:30,“time”:1713267180274,“type”:“browser”,“name”:“main”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1713267180278,“type”:“browser”,“name”:“main”,“msg”:“app state restored”}
{“level”:30,“time”:1713267180293,“type”:“browser”,“name”:“main”,“file”:“Z:\01. Research\2. Important administration\WARLUX.tropy”,“msg”:“open new project window”}
{“level”:30,“time”:1713267180482,“type”:“browser”,“name”:“main”,“status”:{“2d_canvas”:“enabled”,“canvas_oop_rasterization”:“enabled_on”,“direct_rendering_display_compositor”:“disabled_off_ok”,“gpu_compositing”:“enabled”,“multiple_raster_threads”:“enabled_on”,“opengl”:“enabled_on”,“rasterization”:“enabled”,“raw_draw”:“disabled_off_ok”,“skia_graphite”:“disabled_off”,“video_decode”:“enabled”,“video_encode”:“enabled”,“vulkan”:“disabled_off”,“webgl”:“enabled”,“webgl2”:“enabled”,“webgpu”:“enabled”},“msg”:“gpu-info-update”}
{“level”:30,“time”:1713267180761,“type”:“renderer”,“name”:“project”,“dpx”:1,“args”:{“frameless”:true,“locale”:“en”,“webgl”:true,“zoom”:1},“msg”:“project.init”}
{“level”:30,“time”:1713267180792,“type”:“renderer”,“name”:“project”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1713267180792,“type”:“renderer”,“name”:“project”,“msg”:“plugins loaded: 0”}
{“level”:30,“time”:1713267181445,“type”:“renderer”,“name”:“project”,“msg”:“restoring projectFiles@tropy”}
{“level”:30,“time”:1713267181449,“type”:“renderer”,“name”:“project”,“msg”:“restoring recent@tropy”}
{“level”:30,“time”:1713267181449,“type”:“renderer”,“name”:“project”,“msg”:“restoring settings@tropy”}
{“level”:30,“time”:1713267181449,“type”:“renderer”,“name”:“project”,“msg”:“restoring ui@tropy”}
{“level”:30,“time”:1713267181452,“type”:“renderer”,“name”:“project”,“mode”:“w+”,“msg”:“open db C:\Users\sarahmaya.vercruysse\AppData\Roaming\Tropy\ontology.db”}
{“level”:30,“time”:1713267181458,“type”:“browser”,“name”:“main”,“msg”:“ready after 699.175048828125ms”}
{“level”:30,“time”:1713267181468,“type”:“renderer”,“name”:“project”,“msg”:“project ready 1076ms [dom:385ms init:35ms load:639ms]”}
{“level”:30,“time”:1713267181689,“type”:“renderer”,“name”:“project”,“mode”:“webgl”,“resolution”:1,“msg”:“Esper.instance created with webgl renderer”}
{“level”:30,“time”:1713267181708,“type”:“renderer”,“name”:“project”,“mode”:“w”,“msg”:“open db Z:\01. Research\2. Important administration\WARLUX.tropy\project.tpy”}
{“level”:40,“time”:1713267181739,“type”:“renderer”,“name”:“project”,“query”:“\n SELECT count(*) AS count FROM sqlite_schema”,“ms”:238,“msg”:“SLOW: db query took 238ms”}
{“level”:40,“time”:1713267182853,“type”:“renderer”,“name”:“project”,“query”:“VACUUM”,“ms”:1008,“msg”:“SLOW: db query took 1008ms”}
{“level”:30,“time”:1713267183574,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713267183581,“type”:“renderer”,“name”:“project”,“msg”:“restoring project.watch@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713267183581,“type”:“renderer”,“name”:“project”,“msg”:“restoring nav@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713267183581,“type”:“renderer”,“name”:“project”,“msg”:“restoring notepad@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713267183581,“type”:“renderer”,“name”:“project”,“msg”:“restoring esper@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713267183585,“type”:“renderer”,“name”:“project”,“msg”:“restoring imports@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713267183585,“type”:“renderer”,“name”:“project”,“msg”:“restoring sidebar@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713267183585,“type”:“renderer”,“name”:“project”,“msg”:“restoring panel@9b86f389-b3cd-4402-8b7e-a66e68497b48”}
{“level”:30,“time”:1713267183600,“type”:“renderer”,“name”:“project”,“mode”:“w”,“msg”:“open db Z:\01. Research\2. Important administration\WARLUX.tropy\project.tpy”}
{“level”:30,“time”:1713267183601,“type”:“renderer”,“name”:“project”,“mode”:“w”,“msg”:“open db Z:\01. Research\2. Important administration\WARLUX.tropy\project.tpy”}
{“level”:40,“time”:1713267184633,“type”:“renderer”,“name”:“project”,“query”:“\n SELECT\n id,\n item_id AS item,\n template,\n strftime("%Y-%m-%dT%H:%M:%f", created, "localtime") AS created,\n strftime("%Y-%m-%dT%H:%M:%f", modified, "localtime") AS modified,\n angle,\n color,\n density,\n mirror,\n negative,\n brightness,\n contrast,\n hue,\n saturation,\n sharpen,\n width,\n height,\n path,\n filename,\n page,\n size,\n protocol,\n mimetype,\n checksum,\n orientation\n FROM subjects\n JOIN images USING (id)\n JOIN photos USING (id)”,“ms”:293,“msg”:“SLOW: db query took 293ms”}
{“level”:30,“time”:1713267184801,“type”:“renderer”,“name”:“project”,“msg”:“db query took 142ms”,“query”:“\n SELECT id, property, text, datatype AS type\n FROM subjects\n JOIN metadata USING (id)\n JOIN metadata_values USING (value_id) ORDER BY id, metadata.created ASC”,“ms”:142}
{“level”:40,“time”:1713267184830,“type”:“renderer”,“name”:“project”,“ms”:1224,“list”:79,“query”:“”,“tags”:false,“trash”:null,“msg”:“SLOW: *search query "" took 1224ms”}

5

Thanks! Yes, this looks like the crash happens because Tropy can’t write to the project file. I suspect the Z: drive is a network share? Is it possible that you were disconnected from the network when this happened? That would be the first explanation that comes to mind.

6

This time I was indeed disconnected from the network for a few moments.
And when it happens outside the uni network, it’s possible that the VPN disconnects shortly without me noticing.

7

Yes, that sounds plausible. Of course it’s not ideal, but in general there’s nothing too bad that can happen. Like I said, Tropy will try to save everything right away if you make any changes. Therefore, if you get this error because of a network problem normally this means that only your most recent change was not saved. I.e., reconnecting and then opening the project should solve the issue.

To work around this you can also copy the project file to your local disk and open it there, especially if you’re planning a longer working session or expecting frequent disconnects. The downside is that you need to remember to copy the file back when you’re done of course.

8

Thank you very much @inukshuk. This clarifies the crashing.

So if I understand correctly I can just move the main file to my local disk and open it from there? Do I need to make any other adjustments in the application itself? (in the preferences or other)
What do you mean with the fact that I need to copy the file back when i’m done? You mean when i’m done with the project completely? or after every working session?

Thank you again for your assistance!

9

For standard project you need to copy the entire .tropy folder (which contains all photos). If you’ve copied the project to a new location, you need to be careful which copy you open in Tropy. By default, Tropy will open the copy you’ve had open most recently. If you’re not sure which copy is open, you can right click on the project name in the sidebar and select ‘Show project file’ to reveal the location in Windows explorer. In the new project window, hovering over a project should also reveal its full path.

If you make a copy of a project file and you make changes to it, these changes will not be in the original copy. This can be confusing hence why I would generally not recommend working with multiple copies of the same project (other than keeping read-only backup copies). In your case I would only do this if your VPN is very slow or if you can’t connect to it for a longer period of time. In such a case you could move the project folder to your local disk, work on it there, and later you can move it back to the network drive.

10

Ok. Thank you very much.