search

johannesjo / super-productivity

Super Productivity is an advanced todo list app with integrated Timeboxing and time tracking capabilities. It also comes with integrations for Jira, Gitlab, GitHub and Open Project.
http://super-productivity.com
MIT License
11.95k stars 927 forks source link

"Cannot access database" error on startup #3521

Open florianbusi opened 1 month ago

florianbusi commented 1 month ago

Your Environment

Expected Behavior

When launching SuperProductivity, the software should start properly.

Current Behavior

When launching SuperProductivity, the software doesn't start but shows an errer message box with the following message:

Cannot access database :( Possible causes are an app update to the app in the background or low disk space. If you installed the app on linux as snap you also want to enable erefresh awareness 'snap set core experimental.refresh-app-awareness=true' until they fix this issue on their side. Press OK to reload the app (might require manual restarting the app on some platforms)'

Even if I click on the "Ok" button, it show the same message again and again and the software never starts.

Steps to Reproduce (for bugs)

  1. Launch SuperProductivity (by gnome or terminal)

Can you reproduce this reliably?

This happens every time since this morning.

Console Output

Start app...
10:24:29.699 › { enabled: null, showDevTools: false, mode: 'bottom' }

(superproductivity:26981): Gtk-WARNING **: 10:24:29.713: Theme parsing error: gtk.css:1413:23: 'font-feature-settings' is not a valid property name

(superproductivity:26981): Gtk-WARNING **: 10:24:29.714: Theme parsing error: gtk.css:3286:25: 'font-feature-settings' is not a valid property name

(superproductivity:26981): Gtk-WARNING **: 10:24:29.715: Theme parsing error: gtk.css:3748:23: 'font-feature-settings' is not a valid property name
Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
10:24:29.775 › Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[26981:0926/102429.781524:ERROR:object_proxy.cc(576)] Failed to call method: org.freedesktop.login1.Manager.Inhibit: object_path= /org/freedesktop/login1: org.freedesktop.DBus.Error.AccessDenied: An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.167" (uid=1000 pid=26981 comm="/snap/superproductivity/2080/superproductivity --n" label="snap.superproductivity.superproductivity (enforce)") interface="org.freedesktop.login1.Manager" member="Inhibit" error name="(unset)" requested_reply="0" destination="org.freedesktop.login1" (uid=0 pid=4101 comm="/usr/lib/systemd/systemd-logind" label="unconfined")

(superproductivity:26981): Gtk-WARNING **: 10:24:29.800: Theme parsing error: gtk-dark.css:1413:23: 'font-feature-settings' is not a valid property name

(superproductivity:26981): Gtk-WARNING **: 10:24:29.801: Theme parsing error: gtk-dark.css:3286:25: 'font-feature-settings' is not a valid property name

(superproductivity:26981): Gtk-WARNING **: 10:24:29.802: Theme parsing error: gtk-dark.css:3748:23: 'font-feature-settings' is not a valid property name
libGL error: MESA-LOADER: failed to open radeonsi (search paths /snap/superproductivity/2080/gnome-platform/usr/lib/x86_64-linux-gnu/dri)
libGL error: failed to load driver: radeonsi
libGL error: MESA-LOADER: failed to open swrast (search paths /snap/superproductivity/2080/gnome-platform/usr/lib/x86_64-linux-gnu/dri)
libGL error: failed to load driver: swrast
[27069:0926/102429.820057:ERROR:angle_platform_impl.cc(44)] Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
ERR: Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
[27069:0926/102429.820179:ERROR:gl_display.cc(497)] EGL Driver message (Critical) eglInitialize: Could not create a backing OpenGL context.
[27069:0926/102429.820205:ERROR:gl_display.cc(767)] eglInitialize OpenGL failed with error EGL_NOT_INITIALIZED, trying next display type
[27069:0926/102429.820814:ERROR:angle_platform_impl.cc(44)] Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
ERR: Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
[27069:0926/102429.820854:ERROR:gl_display.cc(497)] EGL Driver message (Critical) eglInitialize: Could not create a backing OpenGL context.
[27069:0926/102429.820883:ERROR:gl_display.cc(767)] eglInitialize OpenGLES failed with error EGL_NOT_INITIALIZED
[27069:0926/102429.820909:ERROR:gl_display.cc(801)] Initialization of all EGL display types failed.
[27069:0926/102429.820938:ERROR:gl_ozone_egl.cc(26)] GLDisplayEGL::Initialize failed.
[27069:0926/102429.823920:ERROR:angle_platform_impl.cc(44)] Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
ERR: Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
[27069:0926/102429.823963:ERROR:gl_display.cc(497)] EGL Driver message (Critical) eglInitialize: Could not create a backing OpenGL context.
[27069:0926/102429.823991:ERROR:gl_display.cc(767)] eglInitialize OpenGL failed with error EGL_NOT_INITIALIZED, trying next display type
[27069:0926/102429.824562:ERROR:angle_platform_impl.cc(44)] Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
ERR: Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
[27069:0926/102429.824596:ERROR:gl_display.cc(497)] EGL Driver message (Critical) eglInitialize: Could not create a backing OpenGL context.
[27069:0926/102429.824620:ERROR:gl_display.cc(767)] eglInitialize OpenGLES failed with error EGL_NOT_INITIALIZED
[27069:0926/102429.824645:ERROR:gl_display.cc(801)] Initialization of all EGL display types failed.
[27069:0926/102429.824669:ERROR:gl_ozone_egl.cc(26)] GLDisplayEGL::Initialize failed.
[27069:0926/102429.825579:ERROR:viz_main_impl.cc(166)] Exiting GPU process due to errors during initialization
libGL error: MESA-LOADER: failed to open radeonsi (search paths /snap/superproductivity/2080/gnome-platform/usr/lib/x86_64-linux-gnu/dri)
libGL error: failed to load driver: radeonsi
libGL error: MESA-LOADER: failed to open swrast (search paths /snap/superproductivity/2080/gnome-platform/usr/lib/x86_64-linux-gnu/dri)
libGL error: failed to load driver: swrast
[27122:0926/102429.878354:ERROR:angle_platform_impl.cc(44)] Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
ERR: Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
[27122:0926/102429.878645:ERROR:gl_display.cc(497)] EGL Driver message (Critical) eglInitialize: Could not create a backing OpenGL context.
[27122:0926/102429.878769:ERROR:gl_display.cc(767)] eglInitialize OpenGL failed with error EGL_NOT_INITIALIZED, trying next display type
[27122:0926/102429.879614:ERROR:angle_platform_impl.cc(44)] Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
ERR: Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
[27122:0926/102429.879727:ERROR:gl_display.cc(497)] EGL Driver message (Critical) eglInitialize: Could not create a backing OpenGL context.
[27122:0926/102429.879782:ERROR:gl_display.cc(767)] eglInitialize OpenGLES failed with error EGL_NOT_INITIALIZED
[27122:0926/102429.879830:ERROR:gl_display.cc(801)] Initialization of all EGL display types failed.
[27122:0926/102429.879889:ERROR:gl_ozone_egl.cc(26)] GLDisplayEGL::Initialize failed.
[27122:0926/102429.883186:ERROR:angle_platform_impl.cc(44)] Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
ERR: Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
[27122:0926/102429.883243:ERROR:gl_display.cc(497)] EGL Driver message (Critical) eglInitialize: Could not create a backing OpenGL context.
[27122:0926/102429.883276:ERROR:gl_display.cc(767)] eglInitialize OpenGL failed with error EGL_NOT_INITIALIZED, trying next display type
[27122:0926/102429.883825:ERROR:angle_platform_impl.cc(44)] Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
ERR: Display.cpp:1083 (initialize): ANGLE Display::initialize error 12289: Could not create a backing OpenGL context.
[27122:0926/102429.883864:ERROR:gl_display.cc(497)] EGL Driver message (Critical) eglInitialize: Could not create a backing OpenGL context.
[27122:0926/102429.883896:ERROR:gl_display.cc(767)] eglInitialize OpenGLES failed with error EGL_NOT_INITIALIZED
[27122:0926/102429.883928:ERROR:gl_display.cc(801)] Initialization of all EGL display types failed.
[27122:0926/102429.883956:ERROR:gl_ozone_egl.cc(26)] GLDisplayEGL::Initialize failed.
[27122:0926/102429.885088:ERROR:viz_main_impl.cc(166)] Exiting GPU process due to errors during initialization
MESA-LOADER: failed to open radeonsi (search paths /snap/superproductivity/2080/gnome-platform/usr/lib/x86_64-linux-gnu/dri)
failed to load driver: radeonsi
MESA-LOADER: failed to open kms_swrast (search paths /snap/superproductivity/2080/gnome-platform/usr/lib/x86_64-linux-gnu/dri)
failed to load driver: kms_swrast
MESA-LOADER: failed to open swrast (search paths /snap/superproductivity/2080/gnome-platform/usr/lib/x86_64-linux-gnu/dri)
failed to load swrast driver
10:24:30.278 › No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
Gtk-Message: 10:24:30.307: GtkDialog mapped without a transient parent. This is discouraged.

Error Log (Desktop only)

[2024-09-26 09:59:46.545] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 09:59:47.835] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 09:59:49.345] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:03:26.056] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:03:26.147] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:03:26.652] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:03:28.541] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:03:28.627] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:03:29.111] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:03:30.304] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:03:30.398] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:03:30.921] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:03:41.234] [info]  close, isQuiting: true
[2024-09-26 10:04:28.081] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:04:28.159] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:04:28.656] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:04:32.522] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:04:32.607] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:04:33.129] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:04:34.338] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:04:34.425] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:04:34.941] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:04:35.757] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:04:35.858] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:04:36.336] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:04:37.201] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:04:37.288] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:04:37.791] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:04:52.480] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:04:52.584] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:04:53.082] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:05:00.265] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:05:00.355] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:05:00.837] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:05:04.507] [info]  close, isQuiting: true
[2024-09-26 10:07:27.748] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:07:29.071] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:07:30.792] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:07:54.253] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:07:54.336] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:07:54.815] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:18:43.123] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:18:43.214] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:18:43.748] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:18:47.397] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:18:47.492] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:18:48.029] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:18:49.395] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:18:49.494] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:18:49.963] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:19:02.185] [info]  close, isQuiting: true
[2024-09-26 10:19:10.660] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:19:10.733] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:19:11.227] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:19:57.868] [info]  close, isQuiting: undefined
[2024-09-26 10:24:29.699] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:24:29.775] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:24:30.278] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:29:13.969] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:29:14.056] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:29:14.550] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:29:22.327] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:29:22.421] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:29:22.957] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:29:37.601] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:29:37.689] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:29:38.182] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:29:41.903] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:29:42.002] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:29:42.521] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:29:47.677] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:29:47.765] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:29:48.231] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:29:54.963] [info]  { enabled: null, showDevTools: false, mode: 'bottom' }
[2024-09-26 10:29:55.054] [info]  Saving backups to /home/user/snap/superproductivity/2080/.config/superProductivity/backups
[2024-09-26 10:29:55.547] [info]  No custom styles detected at /home/user/snap/superproductivity/common/.config/superProductivity/styles.css
[2024-09-26 10:29:58.109] [info]  close, isQuiting: true
github-actions[bot] commented 1 month ago

Thank you very much for opening up this issue! I am currently a bit overwhelmed by the many requests that arrive each week, so please forgive me, if I fail to respond personally. I am still very likely to at least skim read your request and I'll probably try to fix all (real) bugs if possible and I will likely review every single PR being made (please, give me a heads up if you intent to do so) and I will try to work on popular requests (please upvote via thumbs up on the original issue) whenever possible, but trying to respond to every single issue over the last years has been kind of draining and I need to adjust my approach for this project to remain fun for me and to make any progress with actually coding new stuff. Thanks for your understanding!

github-actions[bot] commented 1 month ago

Hello there florianbusi! 👋

Thank you and congratulations 🎉 for opening your very first issue in this project! 💖

In case you want to claim this issue, please comment down below! We will try to get back to you as soon as we can. 👀

For more open ended discussions and/or specific questions, please visit the discussions page. 💖

avcourt commented 1 month ago

Super Productivity Version:

System Information:

Issue Description:

I encountered this issue on October 4th and was able to restore my data by re-installing the Snap app and manually importing my backup .json file.

Steps to Reproduce:

  1. Install Super Productivity via Snap.
  2. Launch the app via Gnome or terminal.
  3. Encounter the error message: 
    Cannot access database :( Possible causes are an app update to the app in the background or low disk space. If you installed the app on Linux as a snap, you also want to enable refresh awareness 'snap set core experimental.refresh-app-awareness=true' until they fix this issue on their side. Press OK to reload the app (might require manual restarting the app on some platforms).

Expected Behavior:

The app should load properly and display all tasks and projects.

Current Behavior:

The app shows the error message, and clicking OK does not resolve the issue.

Reproducibility:

This issue occurred consistently until I reinstalled the app and manually restored the backup.

Additional Information:

I will grep through any logs and see if I can find more details. (I did not do a thorough search before reinstalling, so any Snap logs are wiped.)

Snap Info:

name:      superproductivity
summary:   The ToDo List for Digital Professionals
publisher: johannesjo
store-url: https://snapcraft.io/superproductivity
contact:   https://github.com/johannesjo/super-productivity
license:   unset
installed: 10.0.11            (2080) 100MB -
channels:
  latest/stable:    10.0.11 2024-09-23 (2080) 100MB -

Snap Version:

snap    2.63+20.04ubuntu0.1
snapd   2.63+20.04ubuntu0.1
series  16
ubuntu  20.04
kernel  5.15.0-122-generic

System Info:

Distributor ID: Ubuntu
Description:    Ubuntu 20.04.6 LTS
Release:    20.04
Codename:   focal
avcourt commented 1 month ago

Issue reproduced today. No relevant logs found. Forgot to run superproductivity --inspect before snap remove-ing the app and restoring the app from the backed-up JSON file.

Logs Checked: