Error after ncp-update v1.39.19

hannes · October 20, 2021, 5:10pm

Almost, it felt like it was downloading much longer

root@01bc8618bcad:/# ncp-update devel
INFO: updating to development branch 'devel'
Downloading updates
Performing updates
Cannot load Zend OPcache - it was already loaded
Cannot load Zend OPcache - it was already loaded
Cannot load Zend OPcache - it was already loaded
Cannot load Zend OPcache - it was already loaded
Installing nc-restore
Running nc-httpsonly
Forcing HTTPS Off
Cannot load Zend OPcache - it was already loaded
An unhandled exception has been thrown:
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /data/nextcloud/lib/private/DB/Connection.php:85
Stack trace:
#0 /data/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1486): OC\DB\Connection->connect()
#1 /data/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1014): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /data/nextcloud/lib/private/DB/Connection.php(226): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)
#3 /data/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(210): OC\DB\Connection->executeQuery('SELECT * FROM `...', Array, Array)
#4 /data/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /data/nextcloud/lib/private/AppConfig.php(345): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /data/nextcloud/lib/private/AppConfig.php(110): OC\AppConfig->loadConfigValues()
#7 /data/nextcloud/lib/private/AppConfig.php(301): OC\AppConfig->getApps()
#8 /data/nextcloud/lib/private/legacy/OC_App.php(965): OC\AppConfig->getValues(false, 'installed_versi...')
#9 /data/nextcloud/lib/private/Server.php(682): OC_App::getAppVersions()
#10 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(155): OC\Server->OC\{closure}(Object(OC\Server))
#11 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#12 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(122): Pimple\Container->offsetGet('OC\\Memcache\\Fac...')
#13 /data/nextcloud/lib/private/ServerContainer.php(137): OC\AppFramework\Utility\SimpleContainer->query('OC\\Memcache\\Fac...', false)
#14 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query('OC\\Memcache\\Fac...')
#15 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(177): OC\AppFramework\Utility\SimpleContainer->get('OC\\Memcache\\Fac...')
#16 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(155): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#17 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#18 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(122): Pimple\Container->offsetGet('OCP\\ICacheFacto...')
#19 /data/nextcloud/lib/private/ServerContainer.php(137): OC\AppFramework\Utility\SimpleContainer->query('OCP\\ICacheFacto...', false)
#20 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query('OCP\\ICacheFacto...')
#21 /data/nextcloud/lib/private/Server.php(1031): OC\AppFramework\Utility\SimpleContainer->get('OCP\\ICacheFacto...')
#22 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(155): OC\Server->OC\{closure}(Object(OC\Server))
#23 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#24 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(122): Pimple\Container->offsetGet('OCP\\Lock\\ILocki...')
#25 /data/nextcloud/lib/private/ServerContainer.php(137): OC\AppFramework\Utility\SimpleContainer->query('OCP\\Lock\\ILocki...', false)
#26 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query('OCP\\Lock\\ILocki...')
#27 /data/nextcloud/lib/private/Server.php(1990): OC\AppFramework\Utility\SimpleContainer->get('OCP\\Lock\\ILocki...')
#28 /data/nextcloud/lib/private/Files/View.php(119): OC\Server->getLockingProvider()
#29 /data/nextcloud/lib/private/Server.php(430): OC\Files\View->__construct()
#30 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(155): OC\Server->OC\{closure}(Object(OC\Server))
#31 /data/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(Pimple\Container))
#32 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(122): Pimple\Container->offsetGet('OC\\Files\\Node\\H...')
#33 /data/nextcloud/lib/private/ServerContainer.php(137): OC\AppFramework\Utility\SimpleContainer->query('OC\\Files\\Node\\H...', false)
#34 /data/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query('OC\\Files\\Node\\H...')
#35 /data/nextcloud/lib/private/Server.php(1353): OC\AppFramework\Utility\SimpleContainer->get('OC\\Files\\Node\\H...')
#36 /data/nextcloud/lib/base.php(588): OC\Server->boot()
#37 /data/nextcloud/lib/base.php(1076): OC::init()
#38 /data/nextcloud/console.php(49): require_once('/data/nextcloud...')
#39 /data/nextcloud/occ(11): require_once('/data/nextcloud...')
#40 {main}Error while applying update 1.40.0. Exiting...

nachoparker · October 20, 2021, 5:13pm

ok cool, many thanks. So now this is the database not working, which is a different problem you have, but apache should be now up, right?

you can check ncp-web or ncp-config > SYSTEM > nc-info

hannes · October 20, 2021, 5:16pm

Jap Apache seems to be up:

NextCloudPi version  v1.39.19
NextCloudPi image    NextCloudPi_docker_09-20-21
OS                   Debian GNU/Linux 10. 5.10.60-meson64 (aarch64)
automount            no
USB devices          sda sdb
datadir              /data/nextcloud/data
data in SD           no
data filesystem      btrfs
data disk usage      2.1T/3.7T
rootfs usage         7.5G/29G
swapfile             none
dbdir                /data/database
Nextcloud check      error
HTTPD service        up
PHP service          up
MariaDB service      down
Redis service        up
HPB service          down
Postfix service      up
internet check       ok
port check 80        open
port check 443       open
IP                   172.17.0.3
gateway              172.17.0.1
interface            eth0
certificates         none
NAT loopback         no
uptime               1:01

Cannot load Zend OPcache - it was already loaded

You should run Lets Encrypt for trusted encrypted access

You should enable automount to use your plugged in USB drive
Done. Press any key...

Thank you so much for your help, I really appreciate it!

nachoparker · October 20, 2021, 5:18pm

nice!

Now moving on to the database, can you run mysqld in one terminal window, and then, can you run the following command in another terminal window? the output doesn’t matter, just want to see if there are any errors

mysql -u root nextcloud -Nse "select uid from oc_group_user where gid='admin' limit 1;"

hannes · October 20, 2021, 5:21pm

Yup, I get my username as output in the second terminal.

nachoparker · October 20, 2021, 5:28pm

oh so your database actually works, what happens if you look at the info again now? is mariadb still down?

hannes · October 20, 2021, 5:29pm

It’s up now, but the check has still an error:

NextCloudPi version  v1.39.19
NextCloudPi image    NextCloudPi_docker_09-20-21
OS                   Debian GNU/Linux 10. 5.10.60-meson64 (aarch64)
automount            no
USB devices          sda sdb
datadir              /data/nextcloud/data
data in SD           no
data filesystem      btrfs
data disk usage      2.1T/3.7T
rootfs usage         7.5G/29G
swapfile             none
dbdir                /data/database
Nextcloud check      error
HTTPD service        up
PHP service          up
MariaDB service      up
Redis service        up
HPB service          down
Postfix service      up
internet check       ok
port check 80        open
port check 443       open
IP                   172.17.0.3
gateway              172.17.0.1
interface            eth0
certificates         none
NAT loopback         no
uptime               1:14

Cannot load Zend OPcache - it was already loaded

You should run Lets Encrypt for trusted encrypted access

You should enable automount to use your plugged in USB drive
Done. Press any key...

nachoparker · October 20, 2021, 5:34pm

ok perfect, so if you restart now it should be good. If it isn’t, please compare the dbpassword in /root/.my.cnf with the one in /var/www/nextcloud/config/config.php

(assuming the database is up after restart)

hannes · October 20, 2021, 5:39pm

Jap, after restarting the container the MariaDB is still up and the passwords are similar.
I can access NC again! Thank you so much!

Should I run an update now or is that too risky?

nachoparker · October 20, 2021, 5:40pm

please, run the update, should be fine now, othrewise let me know

thanks for the help with this bug

hannes · October 20, 2021, 5:40pm

With the devel option?

nachoparker · October 20, 2021, 5:40pm

just regular is fine

hannes · October 20, 2021, 5:43pm

Yess! It worked, with a lot of Zend OPcaches in between - have to fix that right away…

NextCloudPi updated to version v1.41.12

Thank you for your fast response! Amazing!

hannes · October 20, 2021, 5:44pm

Running nc-info
Gathering information...
NextCloudPi version  v1.41.12
NextCloudPi image    NextCloudPi_docker_09-20-21
OS                   Debian GNU/Linux 10. 5.10.60-meson64 (aarch64)
automount            no
USB devices          sda sdb
datadir              /data/nextcloud/data
data in SD           no
data filesystem      btrfs
data disk usage      2.1T/3.7T
rootfs usage         7.5G/29G
swapfile             none
dbdir                /data/database
Nextcloud check      ok
Nextcloud version    21.0.4.1
HTTPD service        up
PHP service          up
MariaDB service      up
Redis service        up
HPB service          down
Postfix service      up
internet check       ok
port check 80        open
port check 443       open
IP                   172.17.0.3
gateway              172.17.0.1
interface            eth0
certificates         none
NAT loopback         no
uptime               1:30


You should run Lets Encrypt for trusted encrypted access

You should enable automount to use your plugged in USB drive
Done. Press any key...

nachoparker · October 20, 2021, 5:45pm

awesome! thanks again

don’t worry about those, they are harmless

hannes · October 20, 2021, 5:48pm

I have to thank!

One last quick question: The HPB is still down. Would you recommend to leave it like that with Caddy in front of everything? Don’t want to break my installation with the little half knowledge that I collected…

nachoparker · October 21, 2021, 7:17pm

HPB is an optimization, mostly noticeable with many users, so no big deal if it’s down but it should be up.

What is the output from

ncc notify_push:self-test

hannes · October 22, 2021, 7:14pm

Doesn’t seem to be configured:

root@01bc8618bcad:/# ncc notify_push:self-test
🗴 no push server configured

But maybe as you say,it shouldn’t be my focus right now
Thanks again for your help!

nachoparker · October 22, 2021, 7:18pm

it should be auto-configured every reboot

hannes · October 22, 2021, 7:21pm

I restarted the container:

root@01bc8618bcad:/# ncc notify_push:self-test
An unhandled exception has been thrown:
RedisException: NOAUTH Authentication required. in /data/nextcloud/lib/private/Memcache/Redis.php:55
Stack trace:
#0 /data/nextcloud/lib/private/Memcache/Redis.php(55): Redis->get('de7911de1e66132...')
#1 /data/nextcloud/lib/private/App/InfoParser.php(60): OC\Memcache\Redis->get('/data/nextcloud...')
#2 /data/nextcloud/lib/private/App/AppManager.php(511): OC\App\InfoParser->parse('/data/nextcloud...')
#3 /data/nextcloud/lib/private/legacy/OC_App.php(597): OC\App\AppManager->getAppInfo('files', false, NULL)
#4 /data/nextcloud/lib/private/AppFramework/App.php(70): OC_App::getAppInfo('files')
#5 /data/nextcloud/lib/private/legacy/OC_App.php(278): OC\AppFramework\App::buildAppNamespace('files')
#6 /data/nextcloud/lib/private/AppFramework/Bootstrap/Coordinator.php(108): OC_App::registerAutoloading('files', '/data/nextcloud...')
#7 /data/nextcloud/lib/private/AppFramework/Bootstrap/Coordinator.php(82): OC\AppFramework\Bootstrap\Coordinator->registerApps(Array)
#8 /data/nextcloud/lib/base.php(634): OC\AppFramework\Bootstrap\Coordinator->runInitialRegistration()
#9 /data/nextcloud/lib/base.php(1076): OC::init()
#10 /data/nextcloud/console.php(49): require_once('/data/nextcloud...')
#11 /data/nextcloud/occ(11): require_once('/data/nextcloud...')
#12 {main}

root@01bc8618bcad:/# ncc notify_push:self-test
🗴 no push server configured

Seems to have problems and then when I run it another time it shows it as not configured.