UPGRADE to nextcloud 31.0.0 and Nextcloud db

ℹ️ Support
,
1

Hello

The Basics

  • Nextcloud Server version (e.g., 29.x.x):
    • 32.0.3.2
  • Operating system and version (e.g., Ubuntu 24.04):
    • raspbian
  • Web server and version (e.g, Apache 2.4.25):
    • replace me
  • Reverse proxy and version _(e.g. nginx 1.27.2)
    • `nginx
  • PHP version (e.g, 8.3):
    • 8.3
  • Is this the first time you’ve seen this error? (Yes / No):
    • yes
  • When did this problem seem to first start?
    • after upgrade docker
  • Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
    • `i upgrage using docker controller bot
  • Are you using CloudfIare, mod_security, or similar? (Yes / No)
    • `no

I have nextcloud docker and after upgrade my docker of maria db i got the message

Internal Server Error

The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.

I have tried to execute ./occ in my docker and i got this message

An unhandled exception has been thrown:
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed: Name or service not known in /var/www/html/lib/private/DB/Connection.php:237
Stack trace:
#0 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(458): OC\DB\Connection->connect()
#1 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(416): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(323): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/html/lib/private/DB/Connection.php(903): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/html/lib/private/DB/ConnectionAdapter.php(235): OC\DB\Connection->getDatabaseProvider()
#5 /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php(96): OC\DB\ConnectionAdapter->getDatabaseProvider()
#6 /var/www/html/lib/private/AppConfig.php(1226): OC\DB\QueryBuilder\QueryBuilder->expr()
#7 /var/www/html/lib/private/AppConfig.php(243): OC\AppConfig->loadConfig(NULL, false)
#8 /var/www/html/lib/private/AppConfig.php(1366): OC\AppConfig->searchValues(‘enabled’, false, 2)
#9 /var/www/html/lib/private/App/AppManager.php(136): OC\AppConfig->getValues(false, ‘enabled’)
#10 /var/www/html/lib/private/App/AppManager.php(157): OC\App\AppManager->getInstalledAppsValues()
#11 /var/www/html/lib/private/legacy/OC_App.php(188): OC\App\AppManager->getInstalledApps()
#12 /var/www/html/lib/private/AppFramework/Bootstrap/Coordinator.php(48): OC_App::getEnabledApps()
#13 /var/www/html/lib/base.php(675): OC\AppFramework\Bootstrap\Coordinator->runInitialRegistration()
#14 /var/www/html/lib/base.php(1156): OC::init()
#15 /var/www/html/console.php(28): require_once(‘/var/www/html/l…’)
#16 /var/www/html/occ(33): require_once(‘/var/www/html/c…’)

I have my infra on raspberry 5 over omv and Nextcloud with docker, also i have reverse proxy with nginx and i can enter on nginx whitout problem

2

Is it possible to downgrade MariaDB? I wanted to try downgrading to see if it works properly. I’m currently on version 10.6.21. Would adding 10.6.19 to the YML file, for example, be enough? Is it possible to do this, or would it break something?

3

The above suggests one of the following:

  • the mariadb container isn’t running
  • your docker network configuration is broken / has changed since the last container start
  • something changed with the container naming configuration
  • something changed in your Nextcloud config

I suggest:

  • checking your MariaDB container status and log
  • describing more specifically what you upgraded (versions) and how specifically (process)

Please also post your Compose file and try to fill to out the support template.

1 Like
4

Sorry iam not native english talker, so i will try my best.

checking your MariaDB container status and log

Container status seems fine

CONTAINER ID   IMAGE                                  COMMAND                  CREATED         STATUS        PORTS                                                                                      NAMES
************   mariadb:10.6                           "docker-entrypoint.s…"   18 hours ago    Up 18 hours   3306/tcp                                                                                   nextcloud-db-1

Last log of maria dbb

025-04-12 21:50:49+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-04-12 21:50:49+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.21+maria~ubu2004 started.
2025-04-12 21:50:50+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2025-04-12 21:50:50 0 [Note] Starting MariaDB 10.6.21-MariaDB-ubu2004-log source revision 066e8d6aeabc13242193780341e0f845528105de server_uid 9i3jSon9fDpVqmaAjm6DlzF+KVQ= as process 1
2025-04-12 21:50:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2025-04-12 21:50:50 0 [Note] InnoDB: Number of pools: 1
2025-04-12 21:50:50 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
2025-04-12 21:50:50 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2025-04-12 21:50:50 0 [Note] InnoDB: Using Linux native AIO
2025-04-12 21:50:50 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2025-04-12 21:50:50 0 [Note] InnoDB: Completed initialization of buffer pool
2025-04-12 21:50:50 0 [Note] InnoDB: 128 rollback segments are active.
2025-04-12 21:50:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-04-12 21:50:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-04-12 21:50:50 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2025-04-12 21:50:50 0 [Note] InnoDB: 10.6.21 started; log sequence number 1977376422; transaction id 4963071
2025-04-12 21:50:50 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-04-12 21:50:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-04-12 21:50:50 0 [Note] Server socket created on IP: '0.0.0.0'.
2025-04-12 21:50:50 0 [Note] Server socket created on IP: '::'.
2025-04-12 21:50:50 0 [Note] mariadbd: ready for connections.
Version: '10.6.21-MariaDB-ubu2004-log'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2025-04-12 21:50:50 0 [Note] InnoDB: Buffer pool(s) load completed at 250412 21:50:50
2025-04-12 22:07:12 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
2025-04-12 22:07:12 0 [Note] InnoDB: FTS optimize thread exiting.
2025-04-12 22:07:12 0 [Note] InnoDB: Starting shutdown...
2025-04-12 22:07:12 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2025-04-12 22:07:12 0 [Note] InnoDB: Restricted to 2028 pages due to innodb_buf_pool_dump_pct=25
2025-04-12 22:07:12 0 [Note] InnoDB: Buffer pool(s) dump completed at 250412 22:07:12
2025-04-12 22:07:12 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2025-04-12 22:07:12 0 [Note] InnoDB: Shutdown completed; log sequence number 1977376434; transaction id 4963072
2025-04-12 22:07:12 0 [Note] mariadbd: Shutdown complete
2025-04-12 22:07:25+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.21+maria~ubu2004 started.
2025-04-12 22:07:25+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-04-12 22:07:25+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.21+maria~ubu2004 started.
2025-04-12 22:07:26+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2025-04-12 22:07:26 0 [Note] Starting MariaDB 10.6.21-MariaDB-ubu2004-log source revision 066e8d6aeabc13242193780341e0f845528105de server_uid 9i3jSon9fDpVqmaAjm6DlzF+KVQ= as process 1
2025-04-12 22:07:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2025-04-12 22:07:26 0 [Note] InnoDB: Number of pools: 1
2025-04-12 22:07:26 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
2025-04-12 22:07:26 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2025-04-12 22:07:26 0 [Note] InnoDB: Using Linux native AIO
2025-04-12 22:07:26 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2025-04-12 22:07:26 0 [Note] InnoDB: Completed initialization of buffer pool
2025-04-12 22:07:26 0 [Note] InnoDB: 128 rollback segments are active.
2025-04-12 22:07:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-04-12 22:07:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-04-12 22:07:26 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2025-04-12 22:07:26 0 [Note] InnoDB: 10.6.21 started; log sequence number 1977376434; transaction id 4963071
2025-04-12 22:07:26 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-04-12 22:07:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-04-12 22:07:26 0 [Note] Server socket created on IP: '0.0.0.0'.
2025-04-12 22:07:26 0 [Note] Server socket created on IP: '::'.
2025-04-12 22:07:26 0 [Note] mariadbd: ready for connections.
Version: '10.6.21-MariaDB-ubu2004-log'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2025-04-12 22:07:26 0 [Note] InnoDB: Buffer pool(s) load completed at 250412 22:07:26
2025-04-12 22:09:28 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
2025-04-12 22:09:28 0 [Note] InnoDB: FTS optimize thread exiting.
2025-04-12 22:09:28 0 [Note] InnoDB: Starting shutdown...
2025-04-12 22:09:28 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2025-04-12 22:09:28 0 [Note] InnoDB: Restricted to 2028 pages due to innodb_buf_pool_dump_pct=25
2025-04-12 22:09:28 0 [Note] InnoDB: Buffer pool(s) dump completed at 250412 22:09:28
2025-04-12 22:09:28 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2025-04-12 22:09:28 0 [Note] InnoDB: Shutdown completed; log sequence number 1977376446; transaction id 4963072
2025-04-12 22:09:28 0 [Note] mariadbd: Shutdown complete
2025-04-12 22:10:02+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.21+maria~ubu2004 started.
2025-04-12 22:10:03+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-04-12 22:10:03+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.21+maria~ubu2004 started.
2025-04-12 22:10:03+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2025-04-12 22:10:03 0 [Note] Starting MariaDB 10.6.21-MariaDB-ubu2004-log source revision 066e8d6aeabc13242193780341e0f845528105de server_uid 9i3jSon9fDpVqmaAjm6DlzF+KVQ= as process 1
2025-04-12 22:10:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2025-04-12 22:10:03 0 [Note] InnoDB: Number of pools: 1
2025-04-12 22:10:03 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
2025-04-12 22:10:03 0 [Note] InnoDB: Using Linux native AIO
2025-04-12 22:10:03 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2025-04-12 22:10:03 0 [Note] InnoDB: Completed initialization of buffer pool
2025-04-12 22:10:03 0 [Note] InnoDB: 128 rollback segments are active.
2025-04-12 22:10:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-04-12 22:10:03 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-04-12 22:10:03 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2025-04-12 22:10:03 0 [Note] InnoDB: 10.6.21 started; log sequence number 1977376446; transaction id 4963071
2025-04-12 22:10:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-04-12 22:10:03 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-04-12 22:10:03 0 [Note] Server socket created on IP: '0.0.0.0'.
2025-04-12 22:10:03 0 [Note] Server socket created on IP: '::'.
2025-04-12 22:10:03 0 [Note] InnoDB: Buffer pool(s) load completed at 250412 22:10:03
2025-04-12 22:10:03 0 [Note] mariadbd: ready for connections.
Version: '10.6.21-MariaDB-ubu2004-log'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
  • describing more specifically what you upgraded (versions) and how specifically (process)

I have docker controller bot of telegram to upgrade my versions

I have mariadb 10.6.21
And i dont sure about nextcloud i guess the last one

your docker network configuration is broken / has changed since the last container start

I think this is the problem how i can see it?

My docker compose file

# Nextcloud
#
version: '2'

volumes:
  nextcloud:
  db:

services:
  db:
    image: mariadb:10.6
    restart: always
    ports:
      - 3306:3306
    command: --transaction-isolation=READ-COMMITTED --log-bin=binlog --binlog-format=ROW
    volumes:
      - /docker/Nextcloud/db:/var/lib/mysql
    environment:
      - MYSQL_ROOT_PASSWORD=*****
      - MYSQL_PASSWORD=*****
      - MYSQL_DATABASE=nextcloud
      - MYSQL_USER=nextcloud

  app:
    image: nextcloud:latest
    restart: always
    ports:
      - 8080:80
    links:
      - db
    volumes:
      - /docker/Nextcloud/app:/var/www/html
    environment:
      - MYSQL_PASSWORD=******
      - MYSQL_DATABASE=nextcloud
      - MYSQL_USER=nextcloud
      - MYSQL_HOST=db
5

edit first post to make proper template support

6

I want to remake all again, since no one know whta happend? theres a way to save the config or something?

7

Just a question, i have reverse proxy with nginx but i dont see any configuration on config.php, Can someone tell me what i need to add