Like in the past I’ve tried to upgrade NC 11 to 12.
I change the docker image from nextcloud:11-fpm to nextcloud:12-fpm and restarted the docker app and started the upgrade. It fails with errors, (there is no difference if it’s trigged by occ or the website) :
nextcloud.log
Failed to update database structure (PDOException: SQLSTATE[HY000]: General error: 1025 Error on rename of '.\/owncloud\/#sql-1_108' to '.\/owncloud\/oc_properties' (errno: 184 - Tablespace already exists) in \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php:104
Stack trace:
#0 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php(104): PDO->query('ALTER TABLE oc_...')
#1 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(954): Doctrine\\DBAL\\Driver\\PDOConnection->query('ALTER TABLE oc_...')
#2 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(258): Doctrine\\DBAL\\Connection->query('ALTER TABLE oc_...')
#3 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(86): OC\\DB\\Migrator->applySchema(Object(Doctrine\\DBAL\\Schema\\Schema))
#4 \/var\/www\/html\/lib\/private\/DB\/MDB2SchemaManager.php(122): OC\\DB\\Migrator->migrate(Object(Doctrine\\DBAL\\Schema\\Schema))
#5 \/var\/www\/html\/lib\/private\/legacy\/db.php(186): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/html\/d...')
#6 \/var\/www\/html\/lib\/private\/Updater.php(305): OC_DB::updateDbFromStructure('\/var\/www\/html\/d...')
#7 \/var\/www\/html\/lib\/private\/Updater.php(254): OC\\Updater->doCoreUpgrade()
#8 \/var\/www\/html\/lib\/private\/Updater.php(130): OC\\Updater->doUpgrade('12.0.4.3', '11.0.6.1')
#9 \/var\/www\/html\/core\/Command\/Upgrade.php(263): OC\\Updater->upgrade()
#10 \/var\/www\/html\/3rdparty\/symfony\/console\/Command\/Command.php(256): OC\\Core\\Command\\Upgrade->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#11 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(818): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#12 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(186): Symfony\\Component\\Console\\Application->doRunCommand(Object(OC\\Core\\Command\\Upgrade), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#13 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(117): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#14 \/var\/www\/html\/lib\/private\/Console\/Application.php(170): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#15 \/var\/www\/html\/console.php(100): OC\\Console\\Application->run()
#16 \/var\/www\/html\/occ(11): require_once('\/var\/www\/html\/c...')
#17 {main}
Next Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[HY000]: General error: 1025 Error on rename of '.\/owncloud\/#sql-1_108' to '.\/owncloud\/oc_properties' (errno: 184 - Tablespace already exists) in \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOConnection.php:106
Stack trace:
#0 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(954): Doctrine\\DBAL\\Driver\\PDOConnection->query('ALTER TABLE oc_...')
#1 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(258): Doctrine\\DBAL\\Connection->query('ALTER TABLE oc_...')
#2 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(86): OC\\DB\\Migrator->applySchema(Object(Doctrine\\DBAL\\Schema\\Schema))
#3 \/var\/www\/html\/lib\/private\/DB\/MDB2SchemaManager.php(122): OC\\DB\\Migrator->migrate(Object(Doctrine\\DBAL\\Schema\\Schema))
#4 \/var\/www\/html\/lib\/private\/legacy\/db.php(186): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/html\/d...')
#5 \/var\/www\/html\/lib\/private\/Updater.php(305): OC_DB::updateDbFromStructure('\/var\/www\/html\/d...')
#6 \/var\/www\/html\/lib\/private\/Updater.php(254): OC\\Updater->doCoreUpgrade()
#7 \/var\/www\/html\/lib\/private\/Updater.php(130): OC\\Updater->doUpgrade('12.0.4.3', '11.0.6.1')
#8 \/var\/www\/html\/core\/Command\/Upgrade.php(263): OC\\Updater->upgrade()
#9 \/var\/www\/html\/3rdparty\/symfony\/console\/Command\/Command.php(256): OC\\Core\\Command\\Upgrade->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#10 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(818): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#11 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(186): Symfony\\Component\\Console\\Application->doRunCommand(Object(OC\\Core\\Command\\Upgrade), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#12 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(117): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#13 \/var\/www\/html\/lib\/private\/Console\/Application.php(170): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#14 \/var\/www\/html\/console.php(100): OC\\Console\\Application->run()
#15 \/var\/www\/html\/occ(11): require_once('\/var\/www\/html\/c...')
#16 {main}
Next Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing 'ALTER TABLE oc_properties CHANGE `propertyvalue` `propertyvalue` LONGTEXT NOT NULL':
SQLSTATE[HY000]: General error: 1025 Error on rename of '.\/owncloud\/#sql-1_108' to '.\/owncloud\/oc_properties' (errno: 184 - Tablespace already exists) in \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php:116
Stack trace:
#0 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(128): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))
#1 \/var\/www\/html\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(964): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'ALTER TABLE oc_...')
#2 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(258): Doctrine\\DBAL\\Connection->query('ALTER TABLE oc_...')
#3 \/var\/www\/html\/lib\/private\/DB\/Migrator.php(86): OC\\DB\\Migrator->applySchema(Object(Doctrine\\DBAL\\Schema\\Schema))
#4 \/var\/www\/html\/lib\/private\/DB\/MDB2SchemaManager.php(122): OC\\DB\\Migrator->migrate(Object(Doctrine\\DBAL\\Schema\\Schema))
#5 \/var\/www\/html\/lib\/private\/legacy\/db.php(186): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/html\/d...')
#6 \/var\/www\/html\/lib\/private\/Updater.php(305): OC_DB::updateDbFromStructure('\/var\/www\/html\/d...')
#7 \/var\/www\/html\/lib\/private\/Updater.php(254): OC\\Updater->doCoreUpgrade()
#8 \/var\/www\/html\/lib\/private\/Updater.php(130): OC\\Updater->doUpgrade('12.0.4.3', '11.0.6.1')
#9 \/var\/www\/html\/core\/Command\/Upgrade.php(263): OC\\Updater->upgrade()
#10 \/var\/www\/html\/3rdparty\/symfony\/console\/Command\/Command.php(256): OC\\Core\\Command\\Upgrade->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#11 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(818): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#12 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(186): Symfony\\Component\\Console\\Application->doRunCommand(Object(OC\\Core\\Command\\Upgrade), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#13 \/var\/www\/html\/3rdparty\/symfony\/console\/Application.php(117): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#14 \/var\/www\/html\/lib\/private\/Console\/Application.php(170): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#15 \/var\/www\/html\/console.php(100): OC\\Console\\Application->run()
#16 \/var\/www\/html\/occ(11): require_once('\/var\/www\/html\/c...')
#17 {main})
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
config.php
<?php
$CONFIG = array (
'instanceid' => 'xxx',
'passwordsalt' => 'xxx',
'secret' => 'xxx',
'trusted_domains' =>
array (
0 => 'domain',
),
'datadirectory' => '/var/www/html/data',
'overwrite.cli.url' => 'https://domain',
'dbtype' => 'mysql',
'version' => '11.0.6.1',
'dbname' => 'owncloud',
'dbhost' => 'nextcloud_db_1',
'dbtableprefix' => 'oc_',
'dbuser' => 'xxx',
'dbpassword' => 'xxx',
'logtimezone' => 'UTC',
'installed' => true,
'theme' => '',
'loglevel' => 0,
'maintenance' => false,
'mail_from_address' => 'noreply',
'mail_smtpmode' => 'smtp',
'mail_domain' => 'domain',
'mail_smtphost' => 'nextcloud_sendmail_1',
'mail_smtpport' => '25',
'memcache.local' => '\\OC\\Memcache\\APCu',
'auth.bruteforce.protection.enabled' => false,
);