Echec mise à jour de grist et base SQLITE_READONLY

Support apps
,
1

What app is this about, and its version: grist 1.7.11 mise à jour
What YunoHost version are you running: 12.1.39 (stable)
What type of hardware are you using: Old laptop or computer

Describe your issue

Bonjour à tous,

J’ai lancé la mise à jour de grist 1.7.11 en 1.7.12 mais elle a échoué (voir premier log)
J’ai fait une restauration qui a réussi puis retenté la mise à jour.
Celle-ci indique avoir réussi mais le service grist ne démarre pas et le log indique un problème SQLITE_READONLY et un 502 Bad Gateway lors de l’accès à grist.

Une idée ?
Merci par avance

avril 01 23:19:06 run.sh[10043]: code: ‘SQLITE_READONLY’
avril 01 23:19:06 run.sh[10043]: },
avril 01 23:19:06 run.sh[10043]: errno: 8,
avril 01 23:19:06 run.sh[10043]: code: ‘SQLITE_READONLY’
avril 01 23:19:06 run.sh[10043]: }
avril 01 23:19:06 run.sh[10043]: 2026-04-01 23:19:06.847 - error: QueryFailedError: SQLITE_READONLY: attempt to write a readonly database
avril 01 23:19:06 run.sh[10043]: at Statement.handler (/var/www/grist/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:88:37) {
avril 01 23:19:06 run.sh[10043]: query: ‘UPDATE “users” SET “last_connection_at” = ? WHERE “id” IN (1)’,
avril 01 23:19:06 run.sh[10043]: parameters: [ ‘2026-04-01 21:19:06.000’ ],
avril 01 23:19:06 run.sh[10043]: driverError: [Error: SQLITE_READONLY: attempt to write a readonly database] {
avril 01 23:19:06 run.sh[10043]: errno: 8,
avril 01 23:19:06 run.sh[10043]: code: ‘SQLITE_READONLY’
avril 01 23:19:06 run.sh[10043]: },
avril 01 23:19:06 run.sh[10043]: errno: 8,
avril 01 23:19:06 run.sh[10043]: code: ‘SQLITE_READONLY’
avril 01 23:19:06 run.sh[10043]: }
avril 01 23:19:06 systemd[1]: grist.service: Deactivated successfully.
avril 01 23:19:06 systemd[1]: grist.service: Consumed 1.922s CPU time.
avril 01 23:19:25 systemd[1]: Started grist.service - Grist: Modern relational spreadsheet.
avril 01 23:19:27 run.sh[10137]: Welcome to Grist.
avril 01 23:19:27 run.sh[10137]: In quiet mode, see http://localhost:8484 to use.
avril 01 23:19:27 run.sh[10137]: For full logs, re-run with DEBUG=1
avril 01 23:19:27 run.sh[10137]: (node:10137) [DEP0040] DeprecationWarning: The punycode module is deprecated. Please use a userland alternative instead.
avril 01 23:19:27 run.sh[10137]: (Use node --trace-deprecation ... to show where the warning was created)
avril 01 23:19:27 run.sh[10137]: 2026-04-01 23:19:27.383 - info: Setting up database…
avril 01 23:19:27 run.sh[10137]: 2026-04-01 23:19:27.507 - debug: TypeORM transaction error QueryFailedError: SQLITE_READONLY: attempt to write a readonly database
avril 01 23:19:27 run.sh[10137]: at Statement.handler (/var/www/grist/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:88:37) {
avril 01 23:19:27 run.sh[10137]: query: ‘UPDATE “users” SET “last_connection_at” = ? WHERE “id” IN (1)’,
avril 01 23:19:27 run.sh[10137]: parameters: [ ‘2026-04-01 21:19:27.000’ ],
avril 01 23:19:27 run.sh[10137]: driverError: [Error: SQLITE_READONLY: attempt to write a readonly database] {
avril 01 23:19:27 run.sh[10137]: errno: 8,
avril 01 23:19:27 run.sh[10137]: code: ‘SQLITE_READONLY’
avril 01 23:19:27 run.sh[10137]: },
avril 01 23:19:27 run.sh[10137]: errno: 8,
avril 01 23:19:27 run.sh[10137]: code: ‘SQLITE_READONLY’
avril 01 23:19:27 run.sh[10137]: }
avril 01 23:19:27 run.sh[10137]: 2026-04-01 23:19:27.508 - error: QueryFailedError: SQLITE_READONLY: attempt to write a readonly database
avril 01 23:19:27 run.sh[10137]: at Statement.handler (/var/www/grist/node_modules/typeorm/driver/sqlite/SqliteQueryRunner.js:88:37) {
avril 01 23:19:27 run.sh[10137]: query: ‘UPDATE “users” SET “last_connection_at” = ? WHERE “id” IN (1)’,
avril 01 23:19:27 run.sh[10137]: parameters: [ ‘2026-04-01 21:19:27.000’ ],
avril 01 23:19:27 run.sh[10137]: driverError: [Error: SQLITE_READONLY: attempt to write a readonly database] {
avril 01 23:19:27 run.sh[10137]: errno: 8,
avril 01 23:19:27 run.sh[10137]: code: ‘SQLITE_READONLY’
avril 01 23:19:27 run.sh[10137]: },
avril 01 23:19:27 run.sh[10137]: errno: 8,
avril 01 23:19:27 run.sh[10137]: code: ‘SQLITE_READONLY’
avril 01 23:19:27 run.sh[10137]: }
avril 01 23:19:27 systemd[1]: grist.service: Deactivated successfully.
avril 01 23:19:27 systemd[1]: grist.service: Consumed 1.921s CPU time.
avril 01 23:39:20 systemd[1]: Started grist.service - Grist: Modern relational spreadsheet.

Share relevant logs or error messages

1ère MAJ, échouée : https://paste.yunohost.org/raw/xelebiwavi
2ème MAJ, réussite : https://paste.yunohost.org/raw/panelufuda

2

Hi @arn,

Can you share the result of this command, that will tell us who is the owner of the data folder and specifically of the database:

ls -ld /home/yunohost.app/grist
ls -l /home/yunohost.apps/grist

My assumption is that when restoring the app, the data folder has changed ownership and is not owned by `grist`.

If that’s the case, please run this command:

chown -R grist: /home/yunohost.app/grist

and restart the grist service:

systemctl restart grist
3

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.