Docker upgrade to 10.9 messed up

error while upgrading a docker installation from 10.8 to 10.9 of owncloud and from mariadb from 10.5 to 10.6.
Changed the app container to 10.9, gone in maintenance mode as described here:

https://doc.owncloud.com/server/10.9/admin_manual/maintenance/upgrading/database_upgrade.html

the command php occ db:restore-default-row-format did not went fine and i cant neither exit from maintenace mode with

php occ maintenance:mode --off
An unhandled exception has been thrown:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141
Stack trace:
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(141): PDO->query()
#1 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(38): Doctrine\DBAL\Driver\PDOConnection->doQuery()
#2 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1308): Doctrine\DBAL\Driver\PDOConnection->query()
#3 /var/www/owncloud/lib/private/DB/Connection.php(191): Doctrine\DBAL\Connection->executeQuery()
#4 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): OC\DB\Connection->executeQuery()
#5 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(142): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /var/www/owncloud/lib/private/AppConfig.php(312): OC\DB\QueryBuilder\QueryBuilder->execute()
#7 /var/www/owncloud/lib/private/AppConfig.php(122): OC\AppConfig->loadConfigValues()
#8 /var/www/owncloud/lib/private/AllConfig.php(185): OC\AppConfig->getValue()
#9 /var/www/owncloud/lib/private/legacy/util.php(542): OC\AllConfig->getAppValue()
#10 /var/www/owncloud/lib/private/legacy/util.php(461): OC_Util::loadVersion()
#11 /var/www/owncloud/lib/public/Util.php(75): OC_Util::getVersion()
#12 /var/www/owncloud/lib/private/legacy/util.php(1512): OCP\Util::getVersion()
#13 /var/www/owncloud/lib/public/Util.php(735): OC_Util::needUpgrade()
#14 /var/www/owncloud/lib/base.php(348): OCP\Util::needUpgrade()
#15 /var/www/owncloud/lib/base.php(660): OC::checkUpgrade()
#16 /var/www/owncloud/lib/base.php(1070): OC::init()
#17 /var/www/owncloud/console.php(74): require_once('/var/www/ownclo...')
#18 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#19 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(143): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(38): Doctrine\DBAL\Driver\PDOConnection->doQuery()
#2 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1308): Doctrine\DBAL\Driver\PDOConnection->query()
#3 /var/www/owncloud/lib/private/DB/Connection.php(191): Doctrine\DBAL\Connection->executeQuery()
#4 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): OC\DB\Connection->executeQuery()
#5 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(142): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /var/www/owncloud/lib/private/AppConfig.php(312): OC\DB\QueryBuilder\QueryBuilder->execute()
#7 /var/www/owncloud/lib/private/AppConfig.php(122): OC\AppConfig->loadConfigValues()
#8 /var/www/owncloud/lib/private/AllConfig.php(185): OC\AppConfig->getValue()
#9 /var/www/owncloud/lib/private/legacy/util.php(542): OC\AllConfig->getAppValue()
#10 /var/www/owncloud/lib/private/legacy/util.php(461): OC_Util::loadVersion()
#11 /var/www/owncloud/lib/public/Util.php(75): OC_Util::getVersion()
#12 /var/www/owncloud/lib/private/legacy/util.php(1512): OCP\Util::getVersion()
#13 /var/www/owncloud/lib/public/Util.php(735): OC_Util::needUpgrade()
#14 /var/www/owncloud/lib/base.php(348): OCP\Util::needUpgrade()
#15 /var/www/owncloud/lib/base.php(660): OC::checkUpgrade()
#16 /var/www/owncloud/lib/base.php(1070): OC::init()
#17 /var/www/owncloud/console.php(74): require_once('/var/www/ownclo...')
#18 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#19 {main}

Next Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECT * FROM `appconfig`':

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.appconfig' doesn't exist in /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61
Stack trace:
#0 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
#2 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2225): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1312): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
#4 /var/www/owncloud/lib/private/DB/Connection.php(191): Doctrine\DBAL\Connection->executeQuery()
#5 /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): OC\DB\Connection->executeQuery()
#6 /var/www/owncloud/lib/private/DB/QueryBuilder/QueryBuilder.php(142): Doctrine\DBAL\Query\QueryBuilder->execute()
#7 /var/www/owncloud/lib/private/AppConfig.php(312): OC\DB\QueryBuilder\QueryBuilder->execute()
#8 /var/www/owncloud/lib/private/AppConfig.php(122): OC\AppConfig->loadConfigValues()
#9 /var/www/owncloud/lib/private/AllConfig.php(185): OC\AppConfig->getValue()
#10 /var/www/owncloud/lib/private/legacy/util.php(542): OC\AllConfig->getAppValue()
#11 /var/www/owncloud/lib/private/legacy/util.php(461): OC_Util::loadVersion()
#12 /var/www/owncloud/lib/public/Util.php(75): OC_Util::getVersion()
#13 /var/www/owncloud/lib/private/legacy/util.php(1512): OCP\Util::getVersion()
#14 /var/www/owncloud/lib/public/Util.php(735): OC_Util::needUpgrade()
#15 /var/www/owncloud/lib/base.php(348): OCP\Util::needUpgrade()
#16 /var/www/owncloud/lib/base.php(660): OC::checkUpgrade()
#17 /var/www/owncloud/lib/base.php(1070): OC::init()
#18 /var/www/owncloud/console.php(74): require_once('/var/www/ownclo...')
#19 /var/www/owncloud/occ(11): require_once('/var/www/ownclo...')
#20 {main}

ok then i figured out how to do :slight_smile:

Are you still having trouble? If not, could you perhaps explain how you fixed the issue?

This should usually say oc_appconfig, so perhaps some environment variables weren’t properly loaded?

OWNCLOUD_DB_PREFIX oc_

Source: https://github.com/owncloud-docker/base

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.