Any advice? 16.0.3 issues with SQL?

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
1

Nextcloud version 16.0.3
Operating system and version Docker:latest
Apache 2.4.25
php 7.3.7

The issue you are facing:

Pull latest docker image 16.0.3 and tried to upgrade - (downgrade apparently are not supported so installation currently unavailable to users) - the system fails to upgrade saying it

Get the following error message:

Preparing update
Set log level to debug
Turned on maintenance mode
Repair step: Repair MySQL collation
Repair info: All tables already have the correct collation -> nothing to do
Repair step: Repair SQLite autoincrement
Repair step: Copy data from accounts table when migrating from ownCloud

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS Null, COLUMN_KEY AS Key, COLUMN_DEFAULT AS Default, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = ‘nextcloud’ AND TABLE_NAME = ‘oc_accounts’’:

SQLSTATE[HY000]: General error: 1 Can’t create/write to file ‘/tmp/#sql_1_0.MAI’ (Errcode: 2 “No such file or directory”)

Is this the first time you’ve seen this error? yes

Steps to replicate it:

  1. pulled and ran the latest container

The output of your Nextcloud log in Admin > Logging:

AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, using 172.19.0.3. Set the ‘ServerName’ directive globally to suppress this message

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

$CONFIG = array (
‘htaccess.RewriteBase’ => ‘/’,
‘memcache.local’ => ‘\OC\Memcache\APCu’,
‘apps_paths’ =>
array (
0 =>
array (
‘path’ => ‘/var/www/html/apps’,
‘url’ => ‘/apps’,
‘writable’ => false,
),
1 =>
array (
‘path’ => ‘/var/www/html/custom_apps’,
‘url’ => ‘/custom_apps’,
‘writable’ => true,
),
),
‘instanceid’ => ‘ockwkhajno92’,
‘passwordsalt’ => ‘xxxxxxxxxxxxxxx’,
‘secret’ => ‘xxxxxxxxxxxxxxxxx’,
‘trusted_domains’ =>
array (
0 => ‘files.xxxxxxxxxxxxxx.net’,
),
‘datadirectory’ => ‘/var/www/html/data’,
‘overwrite.cli.url’ => ‘https://files.xxxxxxxxxxx.net’,
‘dbtype’ => ‘mysql’,
‘version’ => ‘15.0.7.0’,
‘dbname’ => ‘nextcloud’,
‘dbhost’ => ‘db’,
‘dbport’ => ‘’,
‘dbtableprefix’ => ‘oc_’,
‘mysql.utf8mb4’ => true,
‘dbuser’ => ‘xxxxxxxxxxxxxxx’,
‘dbpassword’ => ‘XXXXXXXXXXXXX’,
‘installed’ => true,
‘mail_smtpmode’ => ‘smtp’,
‘mail_from_address’ => ‘nextcloud’,
‘mail_domain’ => ‘XXXXXXXXXXXXX’,
‘mail_smtphost’ => ‘10.50.20.12’,
‘mail_smtpport’ => ‘25’,
‘loglevel’ => 2,
‘maintenance’ => false,
‘mail_sendmailmode’ => ‘smtp’,
‘theme’ => ‘’,
);

The output of your Apache/nginx/system log in /var/log/____:

[Wed Jul 10 07:40:12.016823 2019] [php7:error] [pid 33] [client 185.33.192.114:33686] PHP Fatal error: Uncaught Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known in /var/www/html/lib/private/DB/Connection.php:64\nStack trace:\n#0 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(448): OC\DB\Connection->connect()\n#1 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(410): Doctrine\DBAL\Connection->getDatabasePlatformVersion()\n#2 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(354): Doctrine\DBAL\Connection->detectDatabasePlatform()\n#3 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(710): Doctrine\DBAL\Connection->getDatabasePlatform()\n#4 /var/www/html/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)\n#5 /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(181): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\ in /var/www/html/lib/private/DB/Connection.php on line 64
[Wed Jul 10 07:40:38.034931 2019] [mpm_prefork:notice] [pid 1] AH00169: caught SIGTERM, shutting down
AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, using 172.19.0.3. Set the ‘ServerName’ directive globally to suppress this message
[Wed Jul 10 07:43:02.040172 2019] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.25 (Debian) PHP/7.3.7 configured – resuming normal operations
[Wed Jul 10 07:43:02.040838 2019] [core:notice] [pid 1] AH00094: Command line: ‘apache2 -D FOREGROUND’