Nextcloud down suite à mise à jour stack docker

Sganus · January 18, 2025, 4:34pm

Bonjour j’ai un soucis suite à la mise à jour docker (sous omv7)

Suite à la mise à jour des containers nexcloud et nexclouddb j’ai du mettre à jour mariadb comme indiqué dans les logs du container nextclouddb grâce à la commande mariadb-upgrade -u root

Cette mise à jour c’est bien passée malgré un temps conséquent pour passer l’étape 3 :

root@1ec15711fc39:/# mariadb-upgrade -u root
Phase 1/8: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.global_priv                                  OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry                         OK
Phase 2/8: Installing used storage engines... Skipped
Phase 3/8: Running 'mysql_fix_privilege_tables'

A l’issue redémarrage des containers nextcloud et nextclouddb. Les logs des containers n’indiquent rien de particulier mais je reste en mode maintenance.

Voici les logs du container nextcloud :

───────────────────────────────────────
      ██╗     ███████╗██╗ ██████╗
      ██║     ██╔════╝██║██╔═══██╗
      ██║     ███████╗██║██║   ██║
      ██║     ╚════██║██║██║   ██║
      ███████╗███████║██║╚██████╔╝
      ╚══════╝╚══════╝╚═╝ ╚═════╝
   Brought to you by linuxserver.io
───────────────────────────────────────
To support LSIO projects visit:
https://www.linuxserver.io/donate/
───────────────────────────────────────
GID/UID
───────────────────────────────────────
User UID:    998
User GID:    100
───────────────────────────────────────
Linuxserver.io version: 30.0.5-ls361
Build-date: 2025-01-16T18:45:43+00:00
───────────────────────────────────────

    
using keys found in /config/keys
[custom-init] No custom files found, skipping...
[ls.io-init] done.```

et ceux du container nextclouddb :

───────────────────────────────────────
██╗ ███████╗██╗ ██████╗
██║ ██╔════╝██║██╔═══██╗
██║ ███████╗██║██║ ██║
██║ ╚════██║██║██║ ██║
███████╗███████║██║╚██████╔╝
╚══════╝╚══════╝╚═╝ ╚═════╝
Brought to you by linuxserver.io
───────────────────────────────────────
To support LSIO projects visit:
Donate | LinuxServer.io
───────────────────────────────────────
GID/UID
───────────────────────────────────────
User UID: 998
User GID: 100
───────────────────────────────────────
Linuxserver.io version: 11.4.4-r1-ls169
Build-date: 2025-01-17T06:44:00+00:00
───────────────────────────────────────

[custom-init] No custom files found, skipping…
250118 16:09:26 mysqld_safe Logging to ‘/config/databases/1ec15711fc39.err’.
250118 16:09:26 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Connection to localhost (::1) 3306 port [tcp/mysql] succeeded!
Logrotate is enabled
[ls.io-init] done.```

vincen · January 18, 2025, 5:53pm

Salut

Pour la partie Docker je pourrais pas t’aider mais as-tu essayé de sortir manuellement du mode maintenance par la commande occ ? normalement il te dira s’il y a quelque chose qui coince et qui explique qu’il reste coincé en mode maintenance !

Vincèn

Sganus · January 19, 2025, 9:31am

Bonjour et merci,
J’ai lancé occ et j’ai pu avoir acces a mon compte admin du coup. Dans les logs j’ai une erreur par rapport à la database :

DbalException  
An exception occurred in the driver: SQLSTATE[HY000] [2002]   Connection refused ```

Et voici l'erreur dans le fichier nextcloud.log :

```{"reqId":"2MkKtmemCs0vULD4h0oI","level":3,"time":"2025-01-18T15:07:08+00:00","remoteAddr":"109.20.102.3","user":"--","app":"index","method":"GET","url":"/index.php/204","message":"An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused","userAgent":"Mozilla/5.0 (Android) Nextcloud-android/3.30.7","version":"30.0.5.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused","Code":2002,"Trace":[{"file":"/app/www/public/lib/private/DB/ConnectionAdapter.php","line":53,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/app/www/public/lib/private/AllConfig.php","line":483,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Service/SubscriptionService.php","line":110,"function":"getUsersForUserValue","class":"OC\\AllConfig","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Service/SubscriptionService.php","line":246,"function":"getUserCount","class":"OCA\\Support\\Service\\SubscriptionService","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Subscription/SubscriptionAdapter.php","line":49,"function":"getSubscriptionInfo","class":"OCA\\Support\\Service\\SubscriptionService","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Capabilities.php","line":48,"function":"hasValidSubscription","class":"OCA\\Support\\Subscription\\SubscriptionAdapter","type":"->"},{"file":"/app/www/public/lib/private/CapabilitiesManager.php","line":61,"function":"getCapabilities","class":"OCA\\Support\\Capabilities","type":"->"},{"file":"/app/www/public/lib/private/Template/JSConfigHelper.php","line":135,"function":"getCapabilities","class":"OC\\CapabilitiesManager","type":"->"},{"file":"/app/www/public/lib/private/TemplateLayout.php","line":228,"function":"getConfig","class":"OC\\Template\\JSConfigHelper","type":"->"},{"file":"/app/www/public/lib/private/legacy/OC_Template.php","line":119,"function":"__construct","class":"OC\\TemplateLayout","type":"->"},{"file":"/app/www/public/lib/private/Template/Base.php","line":113,"function":"fetchPage","class":"OC_Template","type":"->"},{"file":"/app/www/public/lib/base.php","line":244,"function":"printPage","class":"OC\\Template\\Base","type":"->"},{"file":"/app/www/public/lib/base.php","line":961,"function":"checkMaintenanceMode","class":"OC","type":"::"},{"file":"/app/www/public/index.php","line":24,"function":"handleRequest","class":"OC","type":"::"}],"File":"/app/www/public/lib/private/DB/Exceptions/DbalException.php","Line":54,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\ConnectionException","Message":"An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused","Code":2002,"Trace":[{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Connection.php","line":1939,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Connection.php","line":1887,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":257,"function":"convertException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":192,"function":"connectTo","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/app/www/public/lib/private/DB/Connection.php","line":241,"function":"performConnect","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":236,"function":"performConnect","class":"OC\\DB\\Connection","type":"->"},{"file":"/app/www/public/lib/private/DB/Connection.php","line":392,"function":"ensureConnectedToReplica","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/app/www/public/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/app/www/public/lib/private/AllConfig.php","line":483,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Service/SubscriptionService.php","line":110,"function":"getUsersForUserValue","class":"OC\\AllConfig","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Service/SubscriptionService.php","line":246,"function":"getUserCount","class":"OCA\\Support\\Service\\SubscriptionService","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Subscription/SubscriptionAdapter.php","line":49,"function":"getSubscriptionInfo","class":"OCA\\Support\\Service\\SubscriptionService","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Capabilities.php","line":48,"function":"hasValidSubscription","class":"OCA\\Support\\Subscription\\SubscriptionAdapter","type":"->"},{"file":"/app/www/public/lib/private/CapabilitiesManager.php","line":61,"function":"getCapabilities","class":"OCA\\Support\\Capabilities","type":"->"},{"file":"/app/www/public/lib/private/Template/JSConfigHelper.php","line":135,"function":"getCapabilities","class":"OC\\CapabilitiesManager","type":"->"},{"file":"/app/www/public/lib/private/TemplateLayout.php","line":228,"function":"getConfig","class":"OC\\Template\\JSConfigHelper","type":"->"},{"file":"/app/www/public/lib/private/legacy/OC_Template.php","line":119,"function":"__construct","class":"OC\\TemplateLayout","type":"->"},{"file":"/app/www/public/lib/private/Template/Base.php","line":113,"function":"fetchPage","class":"OC_Template","type":"->"},{"file":"/app/www/public/lib/base.php","line":244,"function":"printPage","class":"OC\\Template\\Base","type":"->"},{"file":"/app/www/public/lib/base.php","line":961,"function":"checkMaintenanceMode","class":"OC","type":"::"},{"file":"/app/www/public/index.php","line":24,"function":"handleRequest","class":"OC","type":"::"}],"File":"/app/www/public/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":101,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[HY000] [2002] Connection refused","Code":2002,"Trace":[{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php","line":40,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":255,"function":"connect","class":"Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":192,"function":"connectTo","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/app/www/public/lib/private/DB/Connection.php","line":241,"function":"performConnect","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":236,"function":"performConnect","class":"OC\\DB\\Connection","type":"->"},{"file":"/app/www/public/lib/private/DB/Connection.php","line":392,"function":"ensureConnectedToReplica","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/app/www/public/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/app/www/public/lib/private/AllConfig.php","line":483,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Service/SubscriptionService.php","line":110,"function":"getUsersForUserValue","class":"OC\\AllConfig","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Service/SubscriptionService.php","line":246,"function":"getUserCount","class":"OCA\\Support\\Service\\SubscriptionService","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Subscription/SubscriptionAdapter.php","line":49,"function":"getSubscriptionInfo","class":"OCA\\Support\\Service\\SubscriptionService","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Capabilities.php","line":48,"function":"hasValidSubscription","class":"OCA\\Support\\Subscription\\SubscriptionAdapter","type":"->"},{"file":"/app/www/public/lib/private/CapabilitiesManager.php","line":61,"function":"getCapabilities","class":"OCA\\Support\\Capabilities","type":"->"},{"file":"/app/www/public/lib/private/Template/JSConfigHelper.php","line":135,"function":"getCapabilities","class":"OC\\CapabilitiesManager","type":"->"},{"file":"/app/www/public/lib/private/TemplateLayout.php","line":228,"function":"getConfig","class":"OC\\Template\\JSConfigHelper","type":"->"},{"file":"/app/www/public/lib/private/legacy/OC_Template.php","line":119,"function":"__construct","class":"OC\\TemplateLayout","type":"->"},{"file":"/app/www/public/lib/private/Template/Base.php","line":113,"function":"fetchPage","class":"OC_Template","type":"->"},{"file":"/app/www/public/lib/base.php","line":244,"function":"printPage","class":"OC\\Template\\Base","type":"->"},{"file":"/app/www/public/lib/base.php","line":961,"function":"checkMaintenanceMode","class":"OC","type":"::"},{"file":"/app/www/public/index.php","line":24,"function":"handleRequest","class":"OC","type":"::"}],"File":"/app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000] [2002] Connection refused","Code":2002,"Trace":[{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php","line":33,"function":"__construct","class":"PDO","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":255,"function":"connect","class":"Doctrine\\DBAL\\Driver\\PDO\\MySQL\\Driver","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":192,"function":"connectTo","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/app/www/public/lib/private/DB/Connection.php","line":241,"function":"performConnect","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/app/www/public/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":236,"function":"performConnect","class":"OC\\DB\\Connection","type":"->"},{"file":"/app/www/public/lib/private/DB/Connection.php","line":392,"function":"ensureConnectedToReplica","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->"},{"file":"/app/www/public/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/app/www/public/lib/private/AllConfig.php","line":483,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Service/SubscriptionService.php","line":110,"function":"getUsersForUserValue","class":"OC\\AllConfig","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Service/SubscriptionService.php","line":246,"function":"getUserCount","class":"OCA\\Support\\Service\\SubscriptionService","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Subscription/SubscriptionAdapter.php","line":49,"function":"getSubscriptionInfo","class":"OCA\\Support\\Service\\SubscriptionService","type":"->"},{"file":"/config/www/nextcloud/apps/support/lib/Capabilities.php","line":48,"function":"hasValidSubscription","class":"OCA\\Support\\Subscription\\SubscriptionAdapter","type":"->"},{"file":"/app/www/public/lib/private/CapabilitiesManager.php","line":61,"function":"getCapabilities","class":"OCA\\Support\\Capabilities","type":"->"},{"file":"/app/www/public/lib/private/Template/JSConfigHelper.php","line":135,"function":"getCapabilities","class":"OC\\CapabilitiesManager","type":"->"},{"file":"/app/www/public/lib/private/TemplateLayout.php","line":228,"function":"getConfig","class":"OC\\Template\\JSConfigHelper","type":"->"},{"file":"/app/www/public/lib/private/legacy/OC_Template.php","line":119,"function":"__construct","class":"OC\\TemplateLayout","type":"->"},{"file":"/app/www/public/lib/private/Template/Base.php","line":113,"function":"fetchPage","class":"OC_Template","type":"->"},{"file":"/app/www/public/lib/base.php","line":244,"function":"printPage","class":"OC\\Template\\Base","type":"->"},{"file":"/app/www/public/lib/base.php","line":961,"function":"checkMaintenanceMode","class":"OC","type":"::"},{"file":"/app/www/public/index.php","line":24,"function":"handleRequest","class":"OC","type":"::"}],"File":"/app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php","Line":33}}},"message":"An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused","exception":{},"CustomMessage":"An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused"}}

Sganus · January 19, 2025, 10:09am

Bon bah, l’erreur a disparue et la synchro refonctionne alors que je n’ai rien fait de plus mais j’ai encore pas mal d’erreur en jaune dans la console d’administration et je pense que c’est ce problème sous jacent qui a posé problème lors de la mise à jour des containers docker