Update to 29.0.4 via NCP 1.55 / nc-update-nextcloud failed

schoetju · September 8, 2024, 8:25am

I am on current NextcloudPi version 1.55 (updated yesterday) and tried to update Nextcloud itself coming from 28.0.7 to 29.0.4. I started manually nc-update-nextcloud with version = 0 (to get back to “latest” NCP recommended version).
(Before that it showed up with 28.0.7 - which i’ve manually updated to previously)

output of var/log/ncp-update-nc.log

Current   Nextcloud version 29.0.4
Available Nextcloud version 28.0.7
Download Nextcloud 28.0.7...
Back up current instance...
check free space...
Maintenance mode enabled
backup database...
backup files...
backup /var/www/nextcloud-bkp_20240908_1725769513.tar.gz generated
Maintenance mode disabled
Storing backup at '/var/www/nextcloud-bkp_20240908_1725769513-29.0.4.tar.gz'...
Install Nextcloud 28.0.7...
Restore data...
Fix permissions...
Upgrade...
An unhandled exception has been thrown:
OCP\HintException: [0]: Downgrading is not supported and is likely to cause unpredictable issues (from 29.0.4.1 to 28.0.7.4) ()
Abort
Clean up...
Rolling back to backup /var/www/nextcloud-bkp_20240908_1725769513-29.0.4.tar.gz...
check free space...
extracting backup file /var/www/nextcloud-bkp_20240908_1725769513-29.0.4.tar.gz...
restore files...
restore database...
ERROR 2013 (HY000) at line 323496: Lost connection to server during query
Error restoring nextcloud database
Cleanup...
Rollback failed! Data left at /var/www/recovery/ncp-data.2xGO9J

output of sudo ncp-report

NextcloudPi diagnostics


NextcloudPi version  v1.55.0
NextcloudPi image    NextcloudPi_05-08-24
OS                   Debian GNU/Linux 12. 6.1.0-25-amd64 (x86_64)
automount            no
USB devices          sdb
datadir              /var/www/nextcloud/data
data in SD           yes
data filesystem      ext2/ext3
data disk usage      202G/456G
rootfs usage         202G/456G
swapfile             /media/USBdrive/swap
dbdir                /var/lib/mysql
Nextcloud check      error
HTTPD service        up
PHP service          up
MariaDB service      up
Redis service        up
HPB service          down
Postfix service      up
Internet check       ok
Public IPv4          ***REMOVED SENSITIVE VALUE***
Public IPv6          ***REMOVED SENSITIVE VALUE***
Port 80              open
Port 443             open
IP                   ***REMOVED SENSITIVE VALUE***
Gateway              ***REMOVED SENSITIVE VALUE***
Interface            eno1
Certificates         ***REMOVED SENSITIVE VALUE***
NAT loopback         no
Uptime               25min

Nextcloud configuration


An unhandled exception has been thrown:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_appconfig' doesn't exist in /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php:130
Stack trace:
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(130): PDOStatement->execute()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1099): Doctrine\DBAL\Driver\PDO\Statement->execute()
#2 /var/www/nextcloud/lib/private/DB/Connection.php(328): Doctrine\DBAL\Connection->executeQuery()
#3 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(344): OC\DB\Connection->executeQuery()
#4 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(384): Doctrine\DBAL\Query\QueryBuilder->executeQuery()
#5 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(280): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(293): OC\DB\QueryBuilder\QueryBuilder->execute()
#7 /var/www/nextcloud/lib/private/AppConfig.php(1246): OC\DB\QueryBuilder\QueryBuilder->executeQuery()
#8 /var/www/nextcloud/lib/private/AppConfig.php(264): OC\AppConfig->loadConfig()
#9 /var/www/nextcloud/lib/private/legacy/OC_App.php(736): OC\AppConfig->searchValues()
#10 /var/www/nextcloud/lib/private/Server.php(694): OC_App::getAppVersions()
#11 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#12 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#13 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#14 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#15 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#16 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(197): OC\AppFramework\Utility\SimpleContainer->get()
#17 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#18 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#19 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#20 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#21 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#22 /var/www/nextcloud/lib/private/Server.php(1094): OC\AppFramework\Utility\SimpleContainer->get()
#23 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#24 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#25 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#26 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#27 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#28 /var/www/nextcloud/lib/private/Files/View.php(110): OC\AppFramework\Utility\SimpleContainer->get()
#29 /var/www/nextcloud/lib/private/Server.php(482): OC\Files\View->__construct()
#30 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#31 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#32 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#33 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#34 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#35 /var/www/nextcloud/lib/private/Server.php(1445): OC\AppFramework\Utility\SimpleContainer->get()
#36 /var/www/nextcloud/lib/base.php(641): OC\Server->boot()
#37 /var/www/nextcloud/lib/base.php(1181): OC::init()
#38 /var/www/nextcloud/console.php(48): require_once('...')
#39 /var/www/nextcloud/occ(11): require_once('...')
#40 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_appconfig' doesn't exist in /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php:28
Stack trace:
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(132): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1099): Doctrine\DBAL\Driver\PDO\Statement->execute()
#2 /var/www/nextcloud/lib/private/DB/Connection.php(328): Doctrine\DBAL\Connection->executeQuery()
#3 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(344): OC\DB\Connection->executeQuery()
#4 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(384): Doctrine\DBAL\Query\QueryBuilder->executeQuery()
#5 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(280): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(293): OC\DB\QueryBuilder\QueryBuilder->execute()
#7 /var/www/nextcloud/lib/private/AppConfig.php(1246): OC\DB\QueryBuilder\QueryBuilder->executeQuery()
#8 /var/www/nextcloud/lib/private/AppConfig.php(264): OC\AppConfig->loadConfig()
#9 /var/www/nextcloud/lib/private/legacy/OC_App.php(736): OC\AppConfig->searchValues()
#10 /var/www/nextcloud/lib/private/Server.php(694): OC_App::getAppVersions()
#11 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#12 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#13 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#14 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#15 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#16 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(197): OC\AppFramework\Utility\SimpleContainer->get()
#17 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#18 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#19 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#20 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#21 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#22 /var/www/nextcloud/lib/private/Server.php(1094): OC\AppFramework\Utility\SimpleContainer->get()
#23 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#24 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#25 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#26 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#27 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#28 /var/www/nextcloud/lib/private/Files/View.php(110): OC\AppFramework\Utility\SimpleContainer->get()
#29 /var/www/nextcloud/lib/private/Server.php(482): OC\Files\View->__construct()
#30 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#31 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#32 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#33 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#34 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#35 /var/www/nextcloud/lib/private/Server.php(1445): OC\AppFramework\Utility\SimpleContainer->get()
#36 /var/www/nextcloud/lib/base.php(641): OC\Server->boot()
#37 /var/www/nextcloud/lib/base.php(1181): OC::init()
#38 /var/www/nextcloud/console.php(48): require_once('...')
#39 /var/www/nextcloud/occ(11): require_once('...')
#40 {main}

Next Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_appconfig' doesn't exist in /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49
Stack trace:
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1943): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1885): Doctrine\DBAL\Connection->handleDriverException()
#2 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1106): Doctrine\DBAL\Connection->convertExceptionDuringQuery()
#3 /var/www/nextcloud/lib/private/DB/Connection.php(328): Doctrine\DBAL\Connection->executeQuery()
#4 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(344): OC\DB\Connection->executeQuery()
#5 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(384): Doctrine\DBAL\Query\QueryBuilder->executeQuery()
#6 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(280): Doctrine\DBAL\Query\QueryBuilder->execute()
#7 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(293): OC\DB\QueryBuilder\QueryBuilder->execute()
#8 /var/www/nextcloud/lib/private/AppConfig.php(1246): OC\DB\QueryBuilder\QueryBuilder->executeQuery()
#9 /var/www/nextcloud/lib/private/AppConfig.php(264): OC\AppConfig->loadConfig()
#10 /var/www/nextcloud/lib/private/legacy/OC_App.php(736): OC\AppConfig->searchValues()
#11 /var/www/nextcloud/lib/private/Server.php(694): OC_App::getAppVersions()
#12 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#13 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#14 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#15 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#16 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#17 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(197): OC\AppFramework\Utility\SimpleContainer->get()
#18 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#19 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#20 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#21 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#22 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#23 /var/www/nextcloud/lib/private/Server.php(1094): OC\AppFramework\Utility\SimpleContainer->get()
#24 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#25 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#26 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#27 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#28 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#29 /var/www/nextcloud/lib/private/Files/View.php(110): OC\AppFramework\Utility\SimpleContainer->get()
#30 /var/www/nextcloud/lib/private/Server.php(482): OC\Files\View->__construct()
#31 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#32 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#33 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#34 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#35 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#36 /var/www/nextcloud/lib/private/Server.php(1445): OC\AppFramework\Utility\SimpleContainer->get()
#37 /var/www/nextcloud/lib/base.php(641): OC\Server->boot()
#38 /var/www/nextcloud/lib/base.php(1181): OC::init()
#39 /var/www/nextcloud/console.php(48): require_once('...')
#40 /var/www/nextcloud/occ(11): require_once('...')
#41 {main}

Next OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_appconfig' doesn't exist in /var/www/nextcloud/lib/private/DB/Exceptions/DbalException.php:71
Stack trace:
#0 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(295): OC\DB\Exceptions\DbalException::wrap()
#1 /var/www/nextcloud/lib/private/AppConfig.php(1246): OC\DB\QueryBuilder\QueryBuilder->executeQuery()
#2 /var/www/nextcloud/lib/private/AppConfig.php(264): OC\AppConfig->loadConfig()
#3 /var/www/nextcloud/lib/private/legacy/OC_App.php(736): OC\AppConfig->searchValues()
#4 /var/www/nextcloud/lib/private/Server.php(694): OC_App::getAppVersions()
#5 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#6 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#7 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#8 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#9 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#10 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(197): OC\AppFramework\Utility\SimpleContainer->get()
#11 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#12 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#13 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#14 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#15 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#16 /var/www/nextcloud/lib/private/Server.php(1094): OC\AppFramework\Utility\SimpleContainer->get()
#17 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#18 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#19 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#20 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#21 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#22 /var/www/nextcloud/lib/private/Files/View.php(110): OC\AppFramework\Utility\SimpleContainer->get()
#23 /var/www/nextcloud/lib/private/Server.php(482): OC\Files\View->__construct()
#24 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(175): OC\Server->OC\{closure}()
#25 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#26 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(142): Pimple\Container->offsetGet()
#27 /var/www/nextcloud/lib/private/ServerContainer.php(173): OC\AppFramework\Utility\SimpleContainer->query()
#28 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(64): OC\ServerContainer->query()
#29 /var/www/nextcloud/lib/private/Server.php(1445): OC\AppFramework\Utility\SimpleContainer->get()
#30 /var/www/nextcloud/lib/base.php(641): OC\Server->boot()
#31 /var/www/nextcloud/lib/base.php(1181): OC::init()
#32 /var/www/nextcloud/console.php(48): require_once('...')
#33 /var/www/nextcloud/occ(11): require_once('...')
#34 {main}

HTTPd logs


[Sun Sep 08 00:00:01.942480 2024] [mpm_event:notice] [pid 841941:tid 841941] AH00489: Apache/2.4.62 (Debian) OpenSSL/3.0.14 configured -- resuming normal operations
[Sun Sep 08 00:00:01.942617 2024] [core:notice] [pid 841941:tid 841941] AH00094: Command line: '/usr/sbin/apache2'
[Sun Sep 08 09:49:22.564333 2024] [mpm_event:notice] [pid 841941:tid 841941] AH00492: caught SIGWINCH, shutting down gracefully
[Sun Sep 08 09:49:55.112708 2024] [mpm_event:notice] [pid 979:tid 979] AH00489: Apache/2.4.62 (Debian) OpenSSL/3.0.14 configured -- resuming normal operations
[Sun Sep 08 09:49:55.113169 2024] [core:notice] [pid 979:tid 979] AH00094: Command line: '/usr/sbin/apache2'

Database logs


tail: '/var/log/mysql/*.log' kann nicht zum Lesen geöffnet werden: Datei oder Verzeichnis nicht gefunden

Nextcloud logs

Is this the first time you’ve seen this error? (Y/N): Y

Any help is appreciated.

schoetju · September 8, 2024, 1:59pm

Updated / additional information:
The initial update (happened yesterday) has been successful! I digged into ncp.log and that shows what happened Saturday / Sunday

Saturday (Successfull update)

[ nc-limits ] (Sa 7. Sep 17:59:21 CEST 2024)
Using 6063682560 for PHP max memory
Using 6063682560 for PHP max memory
Installing template 'php/90-ncp.ini.sh'...
Installing template 'php/90-ncp.ini.sh'...
Using 20 PHP threads
Using 20 PHP threads
Installing template 'php/pool.d.www.conf.sh'...
Installing template 'php/pool.d.www.conf.sh'...
Installing template 'mysql/91-ncp.cnf.sh'...
Installing template 'mysql/91-ncp.cnf.sh'...

Enabling conf php8.3-fpm.
To activate the new configuration, you need to run:
  systemctl reload apache2
Starting apache and php-fpm...
  - installed: true
  - version: 29.0.4.1
  - versionstring: 29.0.4
  - edition:
  - maintenance: false
  - needsDbUpgrade: false
  - productname: Nextcloud
  - extendedSupport: false
Update completed successfully.
Backup stored at /var/www/nextcloud/data/ncp-update-backups/nextcloud-bkp_20240907_1725723887-28.0.9.tar.gz
Clean up...
Nextcloud update finished successfully.

Sunday (with traces from nc-preview-auto)

[ nc-previews-auto ]
2024-09-08T00:00:02+00:00 Generating previews for ....
...
[ncp-update-nc]
Failed to reset failed state of unit ncp-encrypt.service: Unit ncp-encrypt.service not loaded.
Running as unit: ncp-update-nc.service
Current   Nextcloud version 29.0.4
Available Nextcloud version 28.0.7
Download Nextcloud 28.0.7...
Back up current instance...
check free space...
Maintenance mode enabled
backup database...
backup files...
backup /var/www/nextcloud-bkp_20240908_1725769513.tar.gz generated
Maintenance mode disabled
Storing backup at '/var/www/nextcloud-bkp_20240908_1725769513-29.0.4.tar.gz'...
Install Nextcloud 28.0.7...
Restore data...
Fix permissions...
Upgrade...
An unhandled exception has been thrown:
OCP\HintException: [0]: Downgrading is not supported and is likely to cause unpredictable issues (from 29.0.4.1 to 28.0.7.4) ()
Abort
Clean up...
Rolling back to backup /var/www/nextcloud-bkp_20240908_1725769513-29.0.4.tar.gz...
check free space...
extracting backup file /var/www/nextcloud-bkp_20240908_1725769513-29.0.4.tar.gz...
restore files...
restore database...
ERROR 2013 (HY000) at line 323496: Lost connection to server during query
Error restoring nextcloud database
Cleanup...
Rollback failed! Data left at /var/www/recovery/ncp-data.2xGO9J
Nextcloud update finished successfully.

[ nc-limits ] (So 8. Sep 09:49:57 CEST 2024)

→ Looks like the automatic ncp-update-nc tried to do an downgrade from 29.0.4 to 28.0.7 and then got stuck somehow…

Will try to do a restore from /var/www/nextcloud-bkp_20240908_1725769513-29.0.4.tar.gz now manually…

theCalcaholic · September 9, 2024, 10:42am

v1.55.1 should fix this issue. Let me know if you are still seeing it after the update

schoetju · September 14, 2024, 8:47pm

Haven’t had time Mo-Fr - now trying to do the restore.
FYI: NCP has been autoupdated to v1.55.1 meanwhile.

But - i am having issues with doing the nc-restore from a full backup (database and files).

output of ncp.log (showing the restore output and ncp-report):

I am worried about following things:

The error message, that shows up during nc-restore (shown in first screenshot too):
ERROR 2013 (HY000) at line 256998: Lost connection to server during query
The fact, that /var/www/nextcloud/data/agnes/files folder does exist - but does not have any files inside it although it’s part of the restore.tar.gz

output of first lines of my backup-file to be restored from (tar -tvf restore.tar.gz)

schoetju · September 21, 2024, 10:49am

Everything is fixed now

Digged into the issue with nc-restore:
ERROR 2013 (HY000) at line 256998: Lost connection to server during query
That issue could be sorted out by manually starting nc-limits
grafik
That created/updated the mysql configuration
Installing template 'mysql/91-ncp.cnf.sh'.

These updated mysql configuration solved the error during nc-restore (restore of database).

Everything running fine afterwards:

NextcloudPi Version already on 1.55.1
started nc-update-nextcloud that actually updated from 28.0.9 to 28.0.10
started nc-update-nextcloud 2nd time and updated from 28.0.10 to 29.0.7

@theCalcaholic Thanks for your work!

system · September 29, 2024, 10:49am

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