[go: up one dir, main page]
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Saving user preferences fails with sqlite database backend #306

Open
pcguy85 opened this issue Feb 14, 2023 · 2 comments
Open

Saving user preferences fails with sqlite database backend #306

pcguy85 opened this issue Feb 14, 2023 · 2 comments
Labels
bug help-wanted

Comments

@pcguy85
Copy link
pcguy85 commented Feb 14, 2023

Hi.

I'm running agendav version 2.6.0 with radicale caldav server as backend.

After clicking the save button on the preferences page the request times out after around 30 seconds and an internal server error is displayed. The logfile contains the following:

[2023-02-14 18:20:19] agendav.INFO: Matched route "preferences.save". {"route_parameters":{"_controller":"\\AgenDAV\\Controller\\Preferences::saveAction","_route":"preferences.save"},"request_uri":"http://192.168.1.25/preferences"} []
[2023-02-14 18:26:37] agendav.CRITICAL: Doctrine\DBAL\Exception\LockWaitTimeoutException: An exception occurred while executing 'INSERT INTO prefs (username, options) VALUES (?, ?)' with params ["tim", "{\"language\":\"en\",\"timezone\":\"Europe\\\/Madrid\",\"date_format\":\"ymd\",\"time_format\":\"24\",\"weekstart\":\"0\",\"default_calendar\":\"\\\/tim\\\/e664597b-d04f-43bb-885a-9ae9aa797b8b\\\/\",\"show_week_nb\":false,\"show_now_indicator\":true,\"list_days\":\"7\",\"default_view\":\"month\"}"]:  SQLSTATE[HY000]: General error: 5 database is locked (uncaught exception) at /var/www/agendav/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractSQLiteDriver.php line 39 {"exception":"[object] (Doctrine\\DBAL\\Exception\\LockWaitTimeoutException(code: 0): An exception occurred while executing 'INSERT INTO prefs (username, options) VALUES (?, ?)' with params [\"tim\", \"{\\\"language\\\":\\\"en\\\",\\\"timezone\\\":\\\"Europe\\\\\\/Madrid\\\",\\\"date_format\\\":\\\"ymd\\\",\\\"time_format\\\":\\\"24\\\",\\\"weekstart\\\":\\\"0\\\",\\\"default_calendar\\\":\\\"\\\\\\/tim\\\\\\/e664597b-d04f-43bb-885a-9ae9aa797b8b\\\\\\/\\\",\\\"show_week_nb\\\":false,\\\"show_now_indicator\\\":true,\\\"list_days\\\":\\\"7\\\",\\\"default_view\\\":\\\"month\\\"}\"]:\n\nSQLSTATE[HY000]: General error: 5 database is locked at /var/www/agendav/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractSQLiteDriver.php:39, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: HY000): SQLSTATE[HY000]: General error: 5 database is locked at /var/www/agendav/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 5 database is locked at /var/www/agendav/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} []

This happens consistently every time the save button is pressed. Agendav configuration contains all default values except:

$app['db.options'] = [
        'path' => '/var/www/agendav/database/agendav.sqlite',
        'driver' => 'pdo_sqlite'
];

$app['caldav.baseurl'] = 'http://localhost:5232/%u';

I installed agendav using the steps in the official installation guide. As far as I can tell everything else works fine (e.g. creating/deleting events). Sessions are also stored inside the database correctly.

The server runs Debian Bullseye. Installed software versions as follows:

apache2                       2.4.54-1~deb11u1
libapache2-mod-php7.4         7.4.33-1+deb11u1
php7.4                        7.4.33-1+deb11u1
radicale                      3.0.6-3
sqlite3                       3.34.1-3

Apache configuration is stock as well (except that I enabled mod_rewrite). The site configuration was copied from the installation manual's example.

Sadly I do have close to zero experience with the various php frameworks involved. Help is much appreciated. If someone can tell me where to start I'll gladly help debugging this.
@florihupf
Copy link

Same here. Fresh install.

@czephyr czephyr mentioned this issue Mar 29, 2023
Open
@battosai30
Copy link

Same here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug help-wanted
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@pixelbrackets @florihupf @battosai30 @pcguy85