Database stopped working

[mil-ad]

My sioyek database (and therefore my highlights) suddenly stopped working. I'm seeing errors below:

shader_path: /tmp/.mount_sioyekPgfIyS/usr/bin/shaders
Creating shared memory block...
Shared memory created: this is the primary application.
Starting IPC server...
IPC server started.
could not create global databaseunable to open database file
Warning: key defined in /tmp/.mount_sioyekPgfIyS/usr/bin/keys.config:288 overwritten by /home/milad/.config/sioyek/keys_user.config:1. Overriding command: q: replacing quit with close_window
Warning: key defined in /tmp/.mount_sioyekPgfIyS/usr/bin/keys.config:285 overwritten by /home/milad/.config/sioyek/keys_user.config:2. Overriding command: <f5>: replacing toggle_presentation_mode with reload
Warning: key defined in /tmp/.mount_sioyekPgfIyS/usr/bin/keys.config:101 overwritten by /home/milad/.config/sioyek/keys_user.config:3. Overriding command: r: replacing rotate_clockwise with reload
Warning: key defined in /tmp/.mount_sioyekPgfIyS/usr/bin/keys.config:291 overwritten by /home/milad/.config/sioyek/keys_user.config:4. Overriding command: f: replacing open_link with toggle_fullscreen
Warning: key defined in /tmp/.mount_sioyekPgfIyS/usr/bin/keys.config:227 overwritten by /home/milad/.config/sioyek/keys_user.config:5. Overriding command: <tab>: replacing goto_portal with goto_toc
Warning: key defined in /tmp/.mount_sioyekPgfIyS/usr/bin/keys.config:281 overwritten by /home/milad/.config/sioyek/keys_user.config:7. Overriding command: <C-]>: replacing goto_definition with next_state
Warning: key defined in /tmp/.mount_sioyekPgfIyS/usr/bin/keys.config:255 overwritten by /home/milad/.config/sioyek/keys_user.config:12. Overriding command: s: replacing external_search with fit_to_page_height
Warning: key defined in /tmp/.mount_sioyekPgfIyS/usr/bin/keys.config:23 overwritten by /home/milad/.config/sioyek/keys_user.config:15. Overriding command: gg: replacing goto_beginning with goto_begining
Warning: key defined in /tmp/.mount_sioyekPgfIyS/usr/bin/keys.config:31 overwritten by /home/milad/.config/sioyek/keys_user.config:16. Overriding command: <home>: replacing goto_page_with_page_number with goto_begining
Warning: key defined in /tmp/.mount_sioyekPgfIyS/usr/bin/keys.config:76 overwritten by /home/milad/.config/sioyek/keys_user.config:17. Overriding command: <C-t>: replacing new_window with toggle_custom_color
SQL Error: 

I reverted the SQL file to an earlier version and I'm still seeing the same error. Is this a known issue?

[ahrm]

Which version of sioyek are you using? Does the issue happen with the appimage builds in the release directory?

[mil-ad]

I'm using 2.0.0 via the app image package in the AUR (sioyek-appimage 2.0.0-2)

[mil-ad]

I get exactly the same error with the official appimage from github

[ahrm]

Can you share your prefs_user.config? If you are using shared_database_path, maybe there is an issue with permissions on that path? Can you move your shared database file to another directory and see if it happens again?

[mil-ad]

Yeah I'm sharing that db file over multiple machines. Let me play around with permissions a bit.

collapsed_toc 1
fit_to_page_width_ratio 0.5
should_launch_new_window 1
should_warn_about_user_key_override 1
super_fast_search 1
inverse_search_command code -r -g "%1:%2"

background_color #000000

dark_mode_background_color #1d2021

custom_color_contrast 0.3
custom_color_mode_empty_background_color #1d2021
page_separator_color #1d2021
page_separator_width 10
custom_background_color #282828
custom_text_color #fbf1c7
search_highlight_color #7ec16e
status_bar_color #427b58
status_bar_text_color #fbf1c7

#ui_background_color #ff0000
#ui_text_color 0.984 0.945 0.78
ui_font Iosevka

shared_database_path ~/Seafile/documents/sioyek_database.db
startup_commands toggle_custom_color

new_command _add_text python -m sioyek.add_text "%{sioyek_path}" "%{local_database}" "%{shared_database}" "%{file_path}" %{selected_rect} "%{command_text}"
new_command _add_red_text python -m sioyek.add_text "%{sioyek_path}" "%{local_database}" "%{shared_database}" "%{file_path}" %{selected_rect} "%{command_text}" fontsize=5 text_color=255,0,0
new_command _remove_annotations python -m sioyek.remove_annotation "%{sioyek_path}" "%{local_database}" "%{shared_database}" "%{file_path}" %{selected_rect}
new_command _embed_annotations python -m sioyek.embed_annotations "%{sioyek_path}" "%{local_database}" "%{shared_database}" "%{file_path}"
new_command _update_file_timestamp update_file_timestamp %{file_path}

[mil-ad]

oh I know what's going on! I keep getting bitten by this and it was merged by accident. Would be great if ~ or $HOME could be expanded in the config

[ahrm]

It probably will be fixed in the next version of sioyek.