SQLite error when opening Tropy

[wragge]

I'm using Version 1.16.2 (x64) installed on Linux Mint via FlatPak.

When I open Tropy I get the following error.

In the logs it says:

{"msg":"SQLITE_CANTOPEN: unable to open database file","stack":"Error: SQLITE_CANTOPEN: unable to open database file","system":"Linux 5.15.0-105-generic (x64)","time":1715916842595,"version":"1.16.2"}

If I click on 'Dismiss' in the pop-up, Tropy seems to open ok, with current projects listed as expected. Everything seems to work ok.

[inukshuk]

When you start Tropy it will try to open the most recently used project automatically. This seems to fail in your case, likely because you removed or renamed the project. You should still see the project at the top of the recent projects list. If you removed the project, you can just open a different one and the next time you start Tropy that project should then open automatically. You can also clear the removed project from the list of recent projects to make Tropy forget about it. If you did not remove the project but moved or renamed it, you can either just open it at its new location or you can re-associate the project by clicking on it in the recent project list.

[wragge]

Hmm, that doesn't seem to be it. I haven't moved or renamed the project. I tried creating a new project, but the same thing happens when I restart.

It seems Tropy is looking for a project.tpy file in my home directory that doesn't exist:

{"level":30,"time":1715950578303,"type":"renderer","name":"project","mode":"r","msg":"open db /home/tim/project.tpy"}

Here's the full log in case it helps:

{"level":30,"time":1715950577797,"type":"browser","name":"main","args":["file:///home/tim"],"opts":{"env":"production","autoUpdates":true,"contextIsolation":true,"webgl":false,"verbose":false,"trace":false,"data":"/home/tim/.var/app/org.tropy.Tropy/config/tropy","cache":"/home/tim/.var/app/org.tropy.Tropy/cache/tropy","logs":"/home/tim/.var/app/org.tropy.Tropy/config/tropy/log"},"version":"1.16.2","msg":"main.init 1.16.2 Linux 5.15.0-105-generic (x64)"}
{"level":30,"time":1715950577847,"type":"browser","name":"main","msg":"plugins scanned: 1"}
{"level":30,"time":1715950577847,"type":"browser","name":"main","msg":"app state restored"}
{"level":30,"time":1715950577848,"type":"browser","name":"main","file":"/home/tim","msg":"open new project window"}
{"level":30,"time":1715950577879,"type":"browser","name":"main","status":{"2d_canvas":"enabled","canvas_oop_rasterization":"disabled_off","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":"disabled_software","vulkan":"disabled_off","webgl":"enabled","webgl2":"enabled","webgpu":"disabled_off"},"msg":"gpu-info-update"}
{"level":30,"time":1715950577953,"type":"renderer","name":"project","dpx":1.5,"args":{"frameless":true,"locale":"en","webgl":true,"zoom":1},"msg":"project.init"}
{"level":30,"time":1715950577960,"type":"renderer","name":"project","msg":"plugins scanned: 1"}
{"level":30,"time":1715950577961,"type":"renderer","name":"project","msg":"plugins loaded: 1"}
{"level":30,"time":1715950578077,"type":"renderer","name":"project","msg":"restoring projectFiles@tropy"}
{"level":30,"time":1715950578082,"type":"browser","name":"main","msg":"ready after 1248ms"}
{"level":30,"time":1715950578078,"type":"renderer","name":"project","msg":"restoring recent@tropy"}
{"level":30,"time":1715950578078,"type":"renderer","name":"project","msg":"restoring settings@tropy"}
{"level":30,"time":1715950578078,"type":"renderer","name":"project","msg":"restoring ui@tropy"}
{"level":30,"time":1715950578079,"type":"renderer","name":"project","mode":"w+","msg":"open db /home/tim/.var/app/org.tropy.Tropy/config/tropy/ontology.db"}
{"level":30,"time":1715950578290,"type":"renderer","name":"project","mode":"webgl","resolution":1,"msg":"Esper.instance created with webgl renderer"}
{"level":30,"time":1715950578303,"type":"renderer","name":"project","mode":"r","msg":"open db /home/tim/project.tpy"}
{"level":40,"time":1715950578311,"type":"renderer","name":"project","stack":"Error: SQLITE_CANTOPEN: unable to open database file","msg":"failed to create db connection"}
{"level":40,"time":1715950578311,"type":"renderer","name":"project","stack":"Error: SQLITE_CANTOPEN: unable to open database file","msg":"unexpected error in *project.open"}
{"level":30,"time":1715950578315,"type":"renderer","name":"project","msg":"project ready 445ms [dom:85ms init:11ms load:113ms]"}
{"level":40,"time":1715950588737,"type":"renderer","name":"project","action":"project.closed","meta":{"ipc":true,"seq":9,"now":1715950588737},"msg":"project.closed failed: SQLITE_CANTOPEN: unable to open database file","stack":"Error: SQLITE_CANTOPEN: unable to open database file"}
{"level":30,"time":1715950588770,"type":"renderer","name":"project","mode":"r","msg":"open db /home/tim/Documents/test2.tropy/project.tpy"}
{"level":30,"time":1715950588777,"type":"renderer","name":"project","mode":"r","msg":"open db /home/tim/Documents/Trove testing.tropy/project.tpy"}
{"level":30,"time":1715950600824,"type":"renderer","name":"project","mode":"webgl","resolution":1,"msg":"Esper.instance created with webgl renderer"}
{"level":30,"time":1715950600839,"type":"renderer","name":"project","mode":"w","msg":"open db /home/tim/Documents/test2.tropy/project.tpy"}
{"level":30,"time":1715950600875,"type":"renderer","name":"project","msg":"restoring project.watch@cd88ea21-8d14-4a4c-86e2-a6d1d394996a"}
{"level":30,"time":1715950600876,"type":"renderer","name":"project","msg":"restoring project.watch@cd88ea21-8d14-4a4c-86e2-a6d1d394996a"}
{"level":40,"time":1715950600884,"type":"browser","name":"main","stack":"Error: Command gio set,/home/tim/Documents/test2.tropy,metadata::custom-icon,file:///home/tim/Documents/test2.tropy/.DirIcon failed: \n    at ChildProcess.<anonymous> (/app/resources/app.asar/lib/browser/main-CG_pYQw_.js:16404:53)\n    at ChildProcess.emit (node:events:517:28)\n    at maybeClose (node:internal/child_process:1098:16)\n    at Socket.<anonymous> (node:internal/child_process:450:11)\n    at Socket.emit (node:events:517:28)\n    at Pipe.<anonymous> (node:net:350:12)","msg":"gio: failed to set metadata::custom-icon on /home/tim/Documents/test2.tropy"}
{"level":30,"time":1715950600876,"type":"renderer","name":"project","msg":"restoring nav@cd88ea21-8d14-4a4c-86e2-a6d1d394996a"}
{"level":30,"time":1715950600876,"type":"renderer","name":"project","msg":"restoring notepad@cd88ea21-8d14-4a4c-86e2-a6d1d394996a"}
{"level":30,"time":1715950600876,"type":"renderer","name":"project","msg":"restoring esper@cd88ea21-8d14-4a4c-86e2-a6d1d394996a"}
{"level":30,"time":1715950600876,"type":"renderer","name":"project","msg":"restoring imports@cd88ea21-8d14-4a4c-86e2-a6d1d394996a"}
{"level":30,"time":1715950600876,"type":"renderer","name":"project","msg":"restoring sidebar@cd88ea21-8d14-4a4c-86e2-a6d1d394996a"}
{"level":30,"time":1715950600876,"type":"renderer","name":"project","msg":"restoring panel@cd88ea21-8d14-4a4c-86e2-a6d1d394996a"}
{"level":30,"time":1715950600879,"type":"renderer","name":"project","mode":"w","msg":"open db /home/tim/Documents/test2.tropy/project.tpy"}
{"level":30,"time":1715950600879,"type":"renderer","name":"project","mode":"w","msg":"open db /home/tim/Documents/test2.tropy/project.tpy"}

[inukshuk]

How do you launch Tropy? Tropy opens the most recent project file by default, but you can also pass a project file to open on the command line. According to the log file, Tropy is started with a command line option file:///home/tim in your case. Since this is a folder, Tropy assumes it's a standard project and tries to open the project.tpy file -- which doesn't exist obviously.

In our default .desktop file included in the Flatpak we launch Tropy using %u as a command line parameter. This means that if, for example, you drag and drop a folder onto the Tropy icon, it would pass a file URL to that folder as a command line option.

You could try to start the from the Terminal like so: flatpak run org.tropy.Tropy -- if you start this way the error should not happen. If you can confirm this then it's definitely related to the launcher. Which desktop environment do you use?