Komga - Ecriture dans une BDD en lecture seule au lancement du service

Support apps
,
1

What type of hardware are you using: Raspberry Pi 3, 4+
What YunoHost version are you running: 12.0.17
What app is this about: komga

Describe your issue

Bonjour a tous,
Lorsque j’installe komga, des que le service demarre j’ai un log disant qu’il y a un essai d’ecriture sur une BDD en lecture seule.

Je joins le log du service komga.

malheureusement je n’y comprends pas grand chose, cependant je suis en mesure de faire n’importe quelle manipulation (SSH, interface d’admin) que quelqu’un de plus experimenté pourra me demander de faire.

Merci d’avance pour votre aide

Share relevant logs or error messages

LOGFILE: journalctl
Jun 07 16:30:31 java[17000]: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1849) ~[spring-beans-6.2.0.jar!/:6.2.0]
Jun 07 16:30:31 java[17000]: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1798) ~[spring-beans-6.2.0.jar!/:6.2.0]
Jun 07 16:30:31 java[17000]: … 80 common frames omitted
Jun 07 16:30:31 java[17000]: Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException: Script V20240529120933__apikey.sql failed
Jun 07 16:30:31 java[17000]: -----------------------------------------
Jun 07 16:30:31 java[17000]: SQL State : null
Jun 07 16:30:31 java[17000]: Error Code : 8
Jun 07 16:30:31 java[17000]: Message : [SQLITE_READONLY] Attempt to write a readonly database (attempt to write a readonly database)
Jun 07 16:30:31 java[17000]: Location : db/migration/sqlite/V20240529120933__apikey.sql (/var/www/komga/nested:/var/www/komga/komga.jar/!BOOT-INF/classes/!/db/migration/sqlite/V20240529120933__apikey.sql)
Jun 07 16:30:31 java[17000]: Line : 1
Jun 07 16:30:31 java[17000]: Statement : Run Flyway with -X option to see the actual statement causing the problem
Jun 07 16:30:31 java[17000]: at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:256) ~[flyway-core-10.20.1.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:217) ~[flyway-core-10.20.1.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:137) ~[flyway-core-10.20.1.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:75) ~[flyway-core-10.20.1.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.lambda$execute$0(SqlMigrationExecutor.java:66) ~[flyway-core-10.20.1.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:31) ~[flyway-core-10.20.1.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:65) ~[flyway-core-10.20.1.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:391) ~[flyway-core-10.20.1.jar!/:na]
Jun 07 16:30:31 java[17000]: … 98 common frames omitted
Jun 07 16:30:31 java[17000]: Caused by: org.sqlite.SQLiteException: [SQLITE_READONLY] Attempt to write a readonly database (attempt to write a readonly database)
Jun 07 16:30:31 java[17000]: at org.sqlite.core.DB.newSQLException(DB.java:1179) ~[sqlite-jdbc-3.48.0.0.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.sqlite.core.DB.newSQLException(DB.java:1190) ~[sqlite-jdbc-3.48.0.0.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.sqlite.core.DB.execute(DB.java:988) ~[sqlite-jdbc-3.48.0.0.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.sqlite.core.CoreStatement.exec(CoreStatement.java:91) ~[sqlite-jdbc-3.48.0.0.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.sqlite.jdbc3.JDBC3Statement.lambda$execute$0(JDBC3Statement.java:56) ~[sqlite-jdbc-3.48.0.0.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.sqlite.jdbc3.JDBC3Statement.withConnectionTimeout(JDBC3Statement.java:458) ~[sqlite-jdbc-3.48.0.0.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.sqlite.jdbc3.JDBC3Statement.execute(JDBC3Statement.java:44) ~[sqlite-jdbc-3.48.0.0.jar!/:na]
Jun 07 16:30:31 java[17000]: at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-5.1.0.jar!/:na]
Jun 07 16:30:31 java[17000]: at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-5.1.0.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:210) ~[flyway-core-10.20.1.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:88) ~[flyway-core-10.20.1.jar!/:na]
Jun 07 16:30:31 java[17000]: at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:212) ~[flyway-core-10.20.1.jar!/:na]
Jun 07 16:30:31 java[17000]: … 104 common frames omitted
Jun 07 16:30:31 systemd[1]: komga.service: Main process exited, code=exited, status=1/FAILURE
Jun 07 16:30:31 systemd[1]: komga.service: Failed with result ‘exit-code’.
Jun 07 16:30:31 systemd[1]: komga.service: Consumed 1min 38.561s CPU time.
Jun 07 16:30:41 systemd[1]: komga.service: Scheduled restart job, restart counter is at 6.
Jun 07 16:30:41 systemd[1]: Stopped komga.service - Komga: media server for your comics.
Jun 07 16:30:41 systemd[1]: komga.service: Consumed 1min 38.561s CPU time.
Jun 07 16:30:41 systemd[1]: Started komga.service - Komga: media server for your comics.
Jun 07 16:30:49 java[17062]: ____ .
Jun 07 16:30:49 java[17062]: | |/ |_ _____ _________
Jun 07 16:30:49 java[17062]: | < / _ \ / \ / _
Jun 07 16:30:49 java[17062]: | | ( <> ) Y Y / // > __ _
Jun 07 16:30:49 java[17062]: ||__ _/|__|| /___ (____ /
Jun 07 16:30:49 java[17062]: / //_____/ /
Jun 07 16:30:49 java[17062]: Version: 1.20.0
Jun 07 16:30:49 java[17062]: 2025-06-07T16:30:49.787+01:00 INFO 17062 — [ main] org.gotson.komga.ApplicationKt : Starting ApplicationKt v1.20.0 using Java 17.0.15 with PID 17062 (/var/www/komga/komga.jar started by komga in /var/www/komga)
Jun 07 16:30:49 java[17062]: 2025-06-07T16:30:49.806+01:00 INFO 17062 — [ main] org.gotson.komga.ApplicationKt : No active profile set, falling back to 1 default profile: “default”

2

Bonsoir @Fink-Git
As-tu eu des erreurs au cours de l’installation de komga ?
Que renvoie ls -la /home/yunohost.app/komga ?

3

Salut @otm33,
Ce n’est pas la premiere fois que j’essaie d’installer komga, il m’est arrivé d’avoir des soucis a l’install precedemment mais pas cette fois ci.

si j’essaie juste un ls -la /home/yunohost.app/komga j’ai un Permission denied mais si je passe cette commande en sudo
j’ai :

total 528
drwxr-x---  4 komga komga   4096 Jun  7 16:26 .
drwxr-xr-x 10 root  root    4096 Apr 18 18:02 ..
-rw-------  1 komga komga    515 Jun  7 16:26 application.yml
-rw-r--r--  1 lufi  lufi  491520 Dec 26 19:12 database.sqlite
drwxr-xr-x  2 lufi  lufi    4096 Jan  2 10:14 logs
drwxr-xr-x  2 lufi  lufi    4096 Dec 26 17:00 lucene
-rw-r--r--  1 lufi  lufi   28672 Dec 29 18:32 tasks.sqlite

C’est etonnant, j’ai bien sur l’application lufi d’installer sur mon yunohost mais c’est pas normal que les permissions dans le repertoire komga soient attribuées a lufi …

Je vais essayer de faire un chown sur le repertoire …

4

→ tout doit appartenir à komga dans ce dossier, en particulier la BDD.

5

cela dépend juste de l’utilisateur sous lequel tu es loggué

6

Apres un chown sur le repertoire /home/yunohost.app/komga et un redemarrage du yunohost tout semble fonctionner : j’ai acces a l’appli et j’ai la page de creation de compte admin.

Merci @otm33 pour ton aide

7

OK, content de t’avoir aidé;) Si cela est présenté comme la solution, il faut préciser chown -R komga:komga /home/yunohost.app/komga