NCP nc-update -nextcloud failed from 17.0.3 to 18.0.1, database error, rollback failed too, plz help

Nextcloud version (eg, 12.0.2): 17.0.3.1
Operating system and version (eg, Ubuntu 17.04): Raspbian GNU/Linux 10 \n \l
Apache or nginx version (eg, Apache 2.4.25):
PHP version (eg, 7.1): PHP 7.3.14-1~deb10u1 (cli) (built: Feb 16 2020 15:07:23) ( NTS )

The issue you are facing: Update Failed from 17.0.3 to 18.0.1 using the nc-update-nextcloud function of ncp config.

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

  1. I udpated nextcloudpi to v1.21.0 in order to update nextcloud from 17.0.3.1 to 18.x
  2. for the nextcloud update i used ncp config panel with the nc-update-nextcloud panel.
  3. The updated failed with the following information given in the Log Output during the update directly from the iframe:
log output nc-update-nextcloud iframe

[ nc-update-nextcloud ]
Current Nextcloud version 17.0.3.1
Available Nextcloud version 18.0.1
Download Nextcloud 18.0.1…
Back up current instance…
check free space…
Maintenance mode enabled
backup database…
backup files…
backup /var/www//nextcloud-bkp_20200301_1583084833.tar.gz generated
Maintenance mode disabled
Install Nextcloud 18.0.1…
Restore apps…

  • calendar
  • contacts
  • gallery
  • news
  • nextcloudpi
  • notes
  • passwords
  • previewgenerator.orig
  • previewgenerator
  • tasks
  • twofactor_totp
    Fix permissions…
    Upgrade…
    Nextcloud or one of the apps require upgrade - only a limited number of commands are available
    You may use your browser or the occ upgrade command to do the upgrade
    Set log level to debug
    Turned on maintenance mode
    Updating database schema
    Updated database
    Disabled incompatible app: gallery
    Updating …
    Migrate old user config

Starting …
!!! Deleted updates as the text is to long !!!

Checking for update of app oauth2 in appstore
Checked for update of app “oauth2” in appstore
Checking for update of app password_policy in appstore
Checked for update of app “password_policy” in appstore
Checking for update of app passwords in appstore
Update app passwords from appstore
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Checked for update of app “passwords” in appstore
Checking for update of app previewgenerator in appstore
Checked for update of app “previewgenerator” in appstore

Checking for update of app gallery in appstore
Checked for update of app “gallery” in appstore
Starting code integrity check…
Finished code integrity check
Update successful
Turned off maintenance mode
Reset log level
Check indices of the share table.
Check indices of the filecache table.
Check indices of the twofactor_providers table.
Check indices of the login_flow_v2 table.
Check indices of the whats_new table.
Check indices of the cards table.
Check indices of the cards_properties table.
Check indices of the calendarobjects_props table.
Adding calendarobject_calid_index index to the calendarobjects_props table, this can take some time…
calendarobjects_props table updated successfully.
Check indices of the schedulingobjects table.
Adding schedulobj_principuri_index index to the schedulingobjects table, this can take some time…
schedulingobjects table updated successfully.
mv: error writing ‘/media/myCloudDrive/nextcloud/data/ncp-update-backups/nextcloud-bkp_20200301_1583084833-17.0.3.1.tar.gz’: Read-only file system
Abort
Clean up…
Rolling back to backup /var/www/nextcloud-bkp_20200301_1583084833-17.0.3.1.tar.gz…
check free space…
extracting backup file /var/www/nextcloud-bkp_20200301_1583084833-17.0.3.1.tar.gz…
restore files…
restore database…
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (111)
Cleanup…
Rollback failed! Data left at /var/www/ncp-data.zoebFp

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

config.php <?php $CONFIG = array ( 'passwordsalt' => 'xxx', 'secret' => 'xxx', 'trusted_domains' => array ( 0 => 'localhost', xxxx ), 'datadirectory' => '/media/myCloudDrive/nextcloud/data', 'dbtype' => 'mysql', 'version' => '17.0.3.1', 'overwrite.cli.url' => 'xxxx', 'dbname' => 'xxx', 'dbhost' => 'xxx', 'dbport' => '', 'dbtableprefix' => 'oc_', 'mysql.utf8mb4' => true, 'dbuser' => 'xxx', 'dbpassword' => 'xxxx', 'installed' => true, 'instanceid' => 'oclo50ehjl9c', 'memcache.local' => '\\OC\\Memcache\\Redis', 'memcache.locking' => '\\OC\\Memcache\\Redis', 'redis' => array ( 'host' => '/var/run/redis/redis.sock', 'port' => 0, 'timeout' => 0.0, 'password' => 'xxx', ), 'tempdirectory' => '/media/myCloudDrive/nextcloud/data/tmp', 'mail_smtpmode' => 'sendmail', 'mail_smtpauthtype' => 'LOGIN', 'mail_from_address' => 'xxx', 'mail_domain' => 'xxx.com', 'preview_max_x' => '2048', 'preview_max_y' => '2048', 'jpeg_quality' => '60', 'overwriteprotocol' => 'https', 'maintenance' => true, 'logfile' => '/media/myCloudDrive/nextcloud/data/nextcloud.log', 'loglevel' => '2', 'log_type' => 'file', 'mail_sendmailmode' => 'smtp', 'mail_smtpsecure' => 'ssl', 'mail_smtpauth' => 1, 'mail_smtphost' => 'smtp.x.com', 'mail_smtpport' => '587', 'mail_smtpname' => ', 'mail_smtppassword' => '', 'theme' => '', ); ~

The output of nc-diagnostics after the update try:

nc-diagnostics
NextCloudPi diagnostics

NextCloudPi version  v1.21.0
distribution         Raspbian GNU/Linux 10 \n \l
automount            yes
USB devices          sda 
datadir              /media/myCloudDrive/nextcloud/data
data in SD           no
data filesystem      btrfs
data disk usage      457G/895G
rootfs usage         3.8G/29G
swapfile             /var/swap
dbdir                /media/myCloudDrive/nextcloud/ncdatabase
Nextcloud check      error
HTTPD service        up
PHP service          up
MariaDB service      up
Redis service        up
Postfix service      up
internet check       ok
port check 80        open
port check 443       open
IP                   ***REMOVED SENSITIVE VALUE***
gateway              ***REMOVED SENSITIVE VALUE***
interface            eth0
certificates         ***REMOVED SENSITIVE VALUE***
NAT loopback         no
uptime               39min

Nextcloud configuration

An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused in /var/www/nextcloud/lib/private/DB/Connection.php:64
Stack trace:
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(420): OC\DB\Connection->connect()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(380): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(324): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(683): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/nextcloud/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(195): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /var/www/nextcloud/lib/private/DB/ConnectionFactory.php(156): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /var/www/nextcloud/lib/private/Server.php(635): OC\DB\ConnectionFactory->getConnection('mysql', Array)
#8 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#9 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OCP\\IDBConnecti...')
#10 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OCP\\IDBConnecti...')
#11 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#12 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('DatabaseConnect...')
#13 /var/www/nextcloud/lib/private/Server.php(1554): OC\ServerContainer->query('DatabaseConnect...')
#14 /var/www/nextcloud/lib/private/Server.php(362): OC\Server->getDatabaseConnection()
#15 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#16 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\Authenticati...')
#17 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(69): OC\ServerContainer->query('OC\\Authenticati...', true)
#18 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(99): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#19 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->resolve('OC\\Authenticati...')
#20 /var/www/nextcloud/lib/private/ServerContainer.php(145): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...', true)
#21 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(69): OC\ServerContainer->query('OC\\Authenticati...', true)
#22 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(99): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#23 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->resolve('OC\\Authenticati...')
#24 /var/www/nextcloud/lib/private/ServerContainer.php(145): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...', true)
#25 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OC\\Authenticati...')
#26 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#27 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\Authenticati...')
#28 /var/www/nextcloud/lib/private/Server.php(374): OC\ServerContainer->query('OC\\Authenticati...')
#29 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#30 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\User\\Session')
#31 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OC\\User\\Session')
#32 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#33 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('UserSession')
#34 /var/www/nextcloud/lib/private/Server.php(1437): OC\ServerContainer->query('UserSession')
#35 /var/www/nextcloud/lib/private/Server.php(1028): OC\Server->getSession()
#36 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#37 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\Security\\CSR...')
#38 /var/www/nextcloud/lib/private/Server.php(1023): OC\ServerContainer->query('OC\\Security\\CSR...')
#39 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#40 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\Security\\CSR...')
#41 /var/www/nextcloud/lib/private/Server.php(1900): OC\ServerContainer->query('OC\\Security\\CSR...')
#42 /var/www/nextcloud/lib/private/Server.php(823): OC\Server->getCsrfTokenManager()
#43 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#44 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OCP\\IRequest')
#45 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OCP\\IRequest')
#46 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#47 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('Request')
#48 /var/www/nextcloud/lib/private/Server.php(1304): OC\ServerContainer->query('Request')
#49 /var/www/nextcloud/lib/private/Server.php(466): OC\Server->getRequest()
#50 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#51 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OCP\\L10N\\IFacto...')
#52 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OCP\\L10N\\IFacto...')
#53 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#54 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('L10NFactory')
#55 /var/www/nextcloud/lib/private/Server.php(1490): OC\ServerContainer->query('L10NFactory')
#56 /var/www/nextcloud/lib/private/Server.php(1501): OC\Server->getL10NFactory()
#57 /var/www/nextcloud/lib/base.php(234): OC\Server->getL10N('lib')
#58 /var/www/nextcloud/lib/base.php(645): OC::checkConfig()
#59 /var/www/nextcloud/lib/base.php(1078): OC::init()
#60 /var/www/nextcloud/console.php(46): require_once('/var/www/nextcl...')
#61 /var/www/nextcloud/occ(11): require_once('/var/www/nextcl...')
#62 {main}
HTTPd logs

[Sun Mar 01 17:09:54.291195 2020] [proxy_fcgi:error] [pid 26869:tid 2781172768] (104)Connection reset by peer: [client 192.168.1.112:53590] AH01075: Error dispatching request to :4443: 
[Sun Mar 01 17:09:54.347890 2020] [proxy_fcgi:error] [pid 26869:tid 2772771872] [client 192.168.1.181:49391] AH01067: Failed to read FastCGI header
[Sun Mar 01 17:09:54.347980 2020] [proxy_fcgi:error] [pid 26869:tid 2772771872] (104)Connection reset by peer: [client 192.168.1.181:49391] AH01075: Error dispatching request to :4443: 
[Sun Mar 01 17:09:54.740093 2020] [mpm_event:notice] [pid 1016:tid 3070079504] AH00491: caught SIGTERM, shutting down
[Sun Mar 01 17:10:18.719173 2020] [ssl:warn] [pid 778:tid 3069633040] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun Mar 01 17:10:18.781230 2020] [ssl:warn] [pid 1011:tid 3069633040] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun Mar 01 17:10:18.788112 2020] [mpm_event:notice] [pid 1011:tid 3069633040] AH00489: Apache/2.4.38 (Raspbian) OpenSSL/1.1.1d configured -- resuming normal operations
[Sun Mar 01 17:10:18.788211 2020] [core:notice] [pid 1011:tid 3069633040] AH00094: Command line: '/usr/sbin/apache2'
[Sun Mar 01 17:19:25.309841 2020] [proxy_fcgi:error] [pid 1012:tid 2873070624] [client 192.168.1.181:49703] AH01067: Failed to read FastCGI header
[Sun Mar 01 17:19:25.309939 2020] [proxy_fcgi:error] [pid 1012:tid 2873070624] (104)Connection reset by peer: [client 192.168.1.181:49703] AH01075: Error dispatching request to :4443: 
[Sun Mar 01 17:19:28.973206 2020] [core:warn] [pid 1011:tid 3069633040] AH00045: child process 1012 still did not exit, sending a SIGTERM
[Sun Mar 01 17:19:30.975673 2020] [core:warn] [pid 1011:tid 3069633040] AH00045: child process 1012 still did not exit, sending a SIGTERM
[Sun Mar 01 17:19:32.977907 2020] [core:warn] [pid 1011:tid 3069633040] AH00045: child process 1012 still did not exit, sending a SIGTERM
[Sun Mar 01 17:19:34.980194 2020] [core:error] [pid 1011:tid 3069633040] AH00046: child process 1012 still did not exit, sending a SIGKILL
[Sun Mar 01 17:19:35.982031 2020] [mpm_event:notice] [pid 1011:tid 3069633040] AH00491: caught SIGTERM, shutting down
[Sun Mar 01 17:19:59.426379 2020] [ssl:warn] [pid 776:tid 3069547024] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun Mar 01 17:19:59.473479 2020] [ssl:warn] [pid 1007:tid 3069547024] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun Mar 01 17:19:59.478441 2020] [mpm_event:notice] [pid 1007:tid 3069547024] AH00489: Apache/2.4.38 (Raspbian) OpenSSL/1.1.1d configured -- resuming normal operations
[Sun Mar 01 17:19:59.478534 2020] [core:notice] [pid 1007:tid 3069547024] AH00094: Command line: '/usr/sbin/apache2'
[Sun Mar 01 17:59:15.039457 2020] [proxy_fcgi:error] [pid 1009:tid 2856199200] [client 192.168.1.181:50548] AH01071: Got error 'PHP message: PHP Warning:  filemtime(): stat failed for /media/myCloudDrive/ncp-backups/nextcloud-bkp_20200222_1582340402.tar in /var/www/ncp-web/backups.php on line 53PHP message: PHP Warning:  filesize(): stat failed for /media/myCloudDrive/ncp-backups/nextcloud-bkp_20200222_1582340402.tar in /var/www/ncp-web/backups.php on line 54'

Database logs

2020-03-01 17:58:50 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-03-01 17:58:50 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-03-01 17:58:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-01 17:58:50 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-03-01 17:58:50 0 [ERROR] Aborting

2020-03-01 17:59:16 0 [ERROR] mysqld: File '/media/myCloudDrive/nextcloud/ncdatabase/aria_log_control' not found (Errcode: 30 "Read-only file system")
2020-03-01 17:59:16 0 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/media/myCloudDrive/nextcloud/ncdatabase/aria_log_control'
2020-03-01 17:59:16 0 [ERROR] Plugin 'Aria' init function returned error.
2020-03-01 17:59:16 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2020-03-01 17:59:16 0 [Warning] The parameter innodb_file_format is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/
2020-03-01 17:59:16 0 [Note] InnoDB: Using Linux native AIO
2020-03-01 17:59:16 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2020-03-01 17:59:16 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2020-03-01 17:59:16 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-03-01 17:59:16 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-03-01 17:59:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-01 17:59:16 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-03-01 17:59:16 0 [ERROR] Aborting


Nextcloud logs

tail: error reading '/media/myCloudDrive/nextcloud/data/nextcloud.log': Input/output error

nc-update-nextcloud

[ nc-update-nextcloud ]
Current Nextcloud version 17.0.3.1
Available Nextcloud version 18.0.1
Download Nextcloud 18.0.1…
Back up current instance…
check free space…
Maintenance mode enabled
backup database…
backup files…
backup /var/www//nextcloud-bkp_20200301_1583084833.tar.gz generated
Maintenance mode disabled
Install Nextcloud 18.0.1…
Restore apps…

  • calendar
  • contacts
  • gallery
  • news
  • nextcloudpi
  • notes
  • passwords
  • previewgenerator.orig
  • previewgenerator
  • tasks
  • twofactor_totp
    Fix permissions…
    Upgrade…
    Nextcloud or one of the apps require upgrade - only a limited number of commands are available
    You may use your browser or the occ upgrade command to do the upgrade
    Set log level to debug
    Turned on maintenance mode
    Updating database schema
    Updated database
    Disabled incompatible app: gallery
    Updating …
    Migrate old user config

Starting …
0/0 [>---------------------------] 0%
Starting …
1/0 [->--------------------------] 0%
Starting …
2/0 [–>-------------------------] 0%
Starting …
3/0 [—>------------------------] 0%
Starting …
4/0 [---->-----------------------] 0%
Starting …
5/0 [----->----------------------] 0%
Starting …
6/0 [------>---------------------] 0%
Starting …
7/0 [------->--------------------] 0%
Updated to 1.4.0
Updating …
Updated to 1.8.0
Updating <files_pdfviewer> …
Updated <files_pdfviewer> to 1.7.0
Updating <files_rightclick> …
Updated <files_rightclick> to 0.15.2
Updating <files_videoplayer> …
Updated <files_videoplayer> to 1.7.0
Updating …
Updated to 2.3.0
Updating <password_policy> …
Updated <password_policy> to 1.8.0
Updating …
Updated to 1.2.0
Updating <provisioning_api> …
Updated <provisioning_api> to 1.8.0
Updating …
Updated to 0.6.0
Updating …
Updated to 1.8.0
Updating …
Updated to 1.1.0
Updating <survey_client> …
Updated <survey_client> to 1.6.0
Updating …
Updated to 2.0.0
Updating <twofactor_backupcodes> …
Updated <twofactor_backupcodes> to 1.7.0
Updating …
Updated to 1.8.0
Updating …
Updated to 1.8.0
Updating <lookup_server_connector> …
Updated <lookup_server_connector> to 1.6.0
Updating …
Updated to 1.6.0
Updating …
Updated to 1.13.1
Updating …
Updated to 2.11.0
Updating <cloud_federation_api> …
Updated <cloud_federation_api> to 1.1.0
Updating …
Fix broken values of calendar objects

Starting …
0/0 [>---------------------------] 0%
Updated to 1.14.0
Updating <files_sharing> …
Updated <files_sharing> to 1.10.1
Updating <files_trashbin> …
Updated <files_trashbin> to 1.8.0
Updating <files_versions> …
Updated <files_versions> to 1.11.0
Updating …
Updated to 1.8.0
Updating …
Updated to 2.0.0
Updating …
Updated to 1.8.0
Updating …
Updated to 2.7.0
Updating <nextcloud_announcements> …
Updated <nextcloud_announcements> to 1.7.0
Updating …
Updated to 2.6.0
Updating …
Updated to 1.8.0
Updating …
Updated to 1.9.0
Checking for update of app accessibility in appstore
Checked for update of app “accessibility” in appstore
Checking for update of app activity in appstore
Checked for update of app “activity” in appstore
Checking for update of app calendar in appstore
Checked for update of app “calendar” in appstore
Checking for update of app cloud_federation_api in appstore
Checked for update of app “cloud_federation_api” in appstore
Checking for update of app comments in appstore
Checked for update of app “comments” in appstore
Checking for update of app contacts in appstore
Update app contacts from appstore
Checked for update of app “contacts” in appstore
Checking for update of app dav in appstore
Checked for update of app “dav” in appstore
Checking for update of app federatedfilesharing in appstore
Checked for update of app “federatedfilesharing” in appstore
Checking for update of app federation in appstore
Checked for update of app “federation” in appstore
Checking for update of app files in appstore
Checked for update of app “files” in appstore
Checking for update of app files_pdfviewer in appstore
Checked for update of app “files_pdfviewer” in appstore
Checking for update of app files_rightclick in appstore
Checked for update of app “files_rightclick” in appstore
Checking for update of app files_sharing in appstore
Checked for update of app “files_sharing” in appstore
Checking for update of app files_trashbin in appstore
Checked for update of app “files_trashbin” in appstore
Checking for update of app files_versions in appstore
Checked for update of app “files_versions” in appstore
Checking for update of app files_videoplayer in appstore
Checked for update of app “files_videoplayer” in appstore
Checking for update of app firstrunwizard in appstore
Checked for update of app “firstrunwizard” in appstore
Checking for update of app logreader in appstore
Checked for update of app “logreader” in appstore
Checking for update of app lookup_server_connector in appstore
Checked for update of app “lookup_server_connector” in appstore
Checking for update of app news in appstore
Checked for update of app “news” in appstore
Checking for update of app nextcloud_announcements in appstore
Checked for update of app “nextcloud_announcements” in appstore
Checking for update of app nextcloudpi in appstore
Checked for update of app “nextcloudpi” in appstore
Checking for update of app notes in appstore
Checked for update of app “notes” in appstore
Checking for update of app notifications in appstore
Checked for update of app “notifications” in appstore
Checking for update of app oauth2 in appstore
Checked for update of app “oauth2” in appstore
Checking for update of app password_policy in appstore
Checked for update of app “password_policy” in appstore
Checking for update of app passwords in appstore
Update app passwords from appstore
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Repair Passwords Database Objects

Starting …
0/0 [>---------------------------] 0%
Checked for update of app “passwords” in appstore
Checking for update of app previewgenerator in appstore
Checked for update of app “previewgenerator” in appstore
Checking for update of app privacy in appstore
Checked for update of app “privacy” in appstore
Checking for update of app provisioning_api in appstore
Checked for update of app “provisioning_api” in appstore
Checking for update of app recommendations in appstore
Checked for update of app “recommendations” in appstore
Checking for update of app serverinfo in appstore
Checked for update of app “serverinfo” in appstore
Checking for update of app settings in appstore
Checked for update of app “settings” in appstore
Checking for update of app sharebymail in appstore
Checked for update of app “sharebymail” in appstore
Checking for update of app support in appstore
Checked for update of app “support” in appstore
Checking for update of app survey_client in appstore
Checked for update of app “survey_client” in appstore
Checking for update of app systemtags in appstore
Checked for update of app “systemtags” in appstore
Checking for update of app tasks in appstore
Checked for update of app “tasks” in appstore
Checking for update of app text in appstore
Checked for update of app “text” in appstore
Checking for update of app theming in appstore
Checked for update of app “theming” in appstore
Checking for update of app twofactor_backupcodes in appstore
Checked for update of app “twofactor_backupcodes” in appstore
Checking for update of app twofactor_totp in appstore
Checked for update of app “twofactor_totp” in appstore
Checking for update of app updatenotification in appstore
Checked for update of app “updatenotification” in appstore
Checking for update of app viewer in appstore
Checked for update of app “viewer” in appstore
Checking for update of app workflowengine in appstore
Checked for update of app “workflowengine” in appstore
Checking for update of app gallery in appstore
Checked for update of app “gallery” in appstore
Starting code integrity check…
Finished code integrity check
Update successful
Turned off maintenance mode
Reset log level
Check indices of the share table.
Check indices of the filecache table.
Check indices of the twofactor_providers table.
Check indices of the login_flow_v2 table.
Check indices of the whats_new table.
Check indices of the cards table.
Check indices of the cards_properties table.
Check indices of the calendarobjects_props table.
Adding calendarobject_calid_index index to the calendarobjects_props table, this can take some time…
calendarobjects_props table updated successfully.
Check indices of the schedulingobjects table.
Adding schedulobj_principuri_index index to the schedulingobjects table, this can take some time…
schedulingobjects table updated successfully.
mv: error writing ‘/media/myCloudDrive/nextcloud/data/ncp-update-backups/nextcloud-bkp_20200301_1583084833-17.0.3.1.tar.gz’: Read-only file system
Abort
Clean up…
Rolling back to backup /var/www/nextcloud-bkp_20200301_1583084833-17.0.3.1.tar.gz…
check free space…
extracting backup file /var/www/nextcloud-bkp_20200301_1583084833-17.0.3.1.tar.gz…
restore files…
restore database…
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (111)
Cleanup…
Rollback failed! Data left at /var/www/ncp-data.zoebFp

You should either open a bug report at the nextcloudpi project or at least post it to https://help.nextcloud.com/c/support/appliances-docker-snappy-vm

Check that drive, it may be full or corrupt.

Hi Sven, Hi Oliver,
thank you for the fast feedback.
I wasn’t aware, that my post is in the wrong subarea or forum. I can give it another try there, but to my knowledge on different forums it is seen as bad behavior to post your stuff in various sub areas instead of one and wait for help. Still, if my topic is in the wrong place maybe a mod can switch the topic to the correct location.

@OliverV: the drive is not full, not even near full (hovers at around 25% with auto backups). I will check the drive on corruption and come back with the details when I’m back home.

What comes to my mind, I have problems with some other docker images running on the Rasbian since around two weeks. I update to the latest packages on an irregular basis, but in the past two weeks almost two or three times. So basicly on a weekly schedule. Is it possible that a rasbian update destroyed my usb3.0 drive permissions for www-data and/or root?

Hi Oliver, can you point me to a solution what I must check or how I must repair the possible corrupted file permissions on the external drive?

I’d try ncp’s nc-hdd-test
or, as you are using btrfs, use

btrfs-check

Hi Oliver,
nc-hdd-test short doesn’t gave me any information after over 60min. of wait time in the ncp window. it sais it needs around 2min. and some other feedback, but nothing changed after that.
after a forced reload of nc-hdd-test I now get the information that I’m not alowed to use this function anymore (something like that, I will take a look tonight when I’m back home). The traffic light on top of nc-hdd-test is red. At first try it was green.

BTRFS-check from webmin terminal was not found, also I give it a try as soon as I’m back home with full ssh access.

@Multisaft

ref: crossposting
usually it’s not needed (and not wanted) that someone does a crossposting… in your case it would have been enough to just edit the category of your posting (which someone, maybe you yourself, already did)

so i suggest that you’d delete your crossposting yourself and thus it will be removed after 48hrs, automatically.

my nc-hdd-test (short version):

nc-hdd-test short

[nc-hdd-test ]

=== START OF ENABLE/DISABLE COMMANDS SECTION ===
SMART Enabled.

  • Stats for sda

=== START OF INFORMATION SECTION ===
Model Family: Marvell based SanDisk SSDs
Device Model: SanDisk Ultra II 960GB
Serial Number: 161227800671
LU WWN Device Id: 5 001b44 8b4492724
Firmware Version: X41100RL
User Capacity: 960,197,124,096 bytes [960 GB]
Sector Size: 512 bytes logical/physical
Rotation Rate: Solid State Device
Form Factor: 2.5 inches
Device is: In smartctl database [for details use: -P show]
ATA Version is: ACS-2 T13/2015-D revision 3
SATA Version is: SATA 3.2, 6.0 Gb/s (current: 6.0 Gb/s)
Local Time is: Wed Mar 4 16:25:42 2020 GMT
SMART support is: Available - device has SMART capability.
SMART support is: Enabled

=== START OF READ SMART DATA SECTION ===
SMART Status not supported: Incomplete response, ATA output registers missing
SMART overall-health self-assessment test result: PASSED
Warning: This result is based on an Attribute check.

General SMART Values:
Offline data collection status: (0x00) Offline data collection activity
was never started.
Auto Offline Data Collection: Disabled.
Self-test execution status: ( 0) The previous self-test routine completed
without error or no self-test has ever
been run.
Total time to complete Offline
data collection: ( 0) seconds.
Offline data collection
capabilities: (0x11) SMART execute Offline immediate.
No Auto Offline data collection support.
Suspend Offline collection upon new
command.
No Offline surface scan supported.
Self-test supported.
No Conveyance Self-test supported.
No Selective Self-test supported.
SMART capabilities: (0x0003) Saves SMART data before entering
power-saving mode.
Supports SMART auto save timer.
Error logging capability: (0x01) Error logging supported.
General Purpose Logging supported.
Short self-test routine
recommended polling time: ( 2) minutes.
Extended self-test routine
recommended polling time: ( 10) minutes.

SMART Attributes Data Structure revision number: 4
Vendor Specific SMART Attributes with Thresholds:
ID# ATTRIBUTE_NAME FLAG VALUE WORST THRESH TYPE UPDATED WHEN_FAILED RAW_VALUE
5 Reallocated_Sector_Ct 0x0032 100 100 — Old_age Always - 0
9 Power_On_Hours 0x0032 100 100 — Old_age Always - 7313
12 Power_Cycle_Count 0x0032 100 100 — Old_age Always - 1610
165 Total_Write/Erase_Count 0x0032 100 100 — Old_age Always - 111726625574
166 Min_W/E_Cycle 0x0032 100 100 — Old_age Always - 3
167 Min_Bad_Block/Die 0x0032 100 100 — Old_age Always - 57
168 Maximum_Erase_Cycle 0x0032 100 100 — Old_age Always - 30
169 Total_Bad_Block 0x0032 100 100 — Old_age Always - 1005
170 Unknown_Attribute 0x0032 100 100 — Old_age Always - 0
171 Program_Fail_Count 0x0032 100 100 — Old_age Always - 0
172 Erase_Fail_Count 0x0032 100 100 — Old_age Always - 0
173 Avg_Write/Erase_Count 0x0032 100 100 — Old_age Always - 12
174 Unexpect_Power_Loss_Ct 0x0032 100 100 — Old_age Always - 306
184 End-to-End_Error 0x0032 100 100 — Old_age Always - 0
187 Reported_Uncorrect 0x0032 100 100 — Old_age Always - 0
188 Command_Timeout 0x0032 100 100 — Old_age Always - 0
194 Temperature_Celsius 0x0022 066 063 — Old_age Always - 34 (Min/Max 19/63)
199 SATA_CRC_Error 0x0032 100 100 — Old_age Always - 0
230 Perc_Write/Erase_Count 0x0032 100 100 — Old_age Always - 2327893705246
232 Perc_Avail_Resrvd_Space 0x0033 100 100 004 Pre-fail Always - 100
233 Total_NAND_Writes_GiB 0x0032 100 100 — Old_age Always - 12286
234 Perc_Write/Erase_Ct_BC 0x0032 100 100 — Old_age Always - 16521
241 Total_Writes_GiB 0x0030 253 253 — Old_age Offline - 15065
242 Total_Reads_GiB 0x0030 253 253 — Old_age Offline - 13430
244 Thermal_Throttle 0x0032 000 100 — Old_age Always - 0

SMART Error Log Version: 1
No Errors Logged

SMART Self-test log structure revision number 1
Num Test_Description Status Remaining LifeTime(hours) LBA_of_first_error

1 Short offline Completed without error 00% 7313 -

2 Short offline Completed without error 00% 7290 -

Selective Self-tests/Logging not supported

ncc-hdd-test long:

nc-hdd-test long

[ nc-hdd-test ]

=== START OF ENABLE/DISABLE COMMANDS SECTION ===
SMART Enabled.

  • Stats for sda

=== START OF INFORMATION SECTION ===
Model Family: Marvell based SanDisk SSDs
Device Model: SanDisk Ultra II 960GB
Serial Number: 161227800671
LU WWN Device Id: 5 001b44 8b4492724
Firmware Version: X41100RL
User Capacity: 960,197,124,096 bytes [960 GB]
Sector Size: 512 bytes logical/physical
Rotation Rate: Solid State Device
Form Factor: 2.5 inches
Device is: In smartctl database [for details use: -P show]
ATA Version is: ACS-2 T13/2015-D revision 3
SATA Version is: SATA 3.2, 6.0 Gb/s (current: 6.0 Gb/s)
Local Time is: Wed Mar 4 16:41:29 2020 GMT
SMART support is: Available - device has SMART capability.
SMART support is: Enabled

=== START OF READ SMART DATA SECTION ===
SMART Status not supported: Incomplete response, ATA output registers missing
SMART overall-health self-assessment test result: PASSED
Warning: This result is based on an Attribute check.

General SMART Values:
Offline data collection status: (0x00) Offline data collection activity
was never started.
Auto Offline Data Collection: Disabled.
Self-test execution status: ( 0) The previous self-test routine completed
without error or no self-test has ever
been run.
Total time to complete Offline
data collection: ( 0) seconds.
Offline data collection
capabilities: (0x11) SMART execute Offline immediate.
No Auto Offline data collection support.
Suspend Offline collection upon new
command.
No Offline surface scan supported.
Self-test supported.
No Conveyance Self-test supported.
No Selective Self-test supported.
SMART capabilities: (0x0003) Saves SMART data before entering
power-saving mode.
Supports SMART auto save timer.
Error logging capability: (0x01) Error logging supported.
General Purpose Logging supported.
Short self-test routine
recommended polling time: ( 2) minutes.
Extended self-test routine
recommended polling time: ( 10) minutes.

SMART Attributes Data Structure revision number: 4
Vendor Specific SMART Attributes with Thresholds:
ID# ATTRIBUTE_NAME FLAG VALUE WORST THRESH TYPE UPDATED WHEN_FAILED RAW_VALUE
5 Reallocated_Sector_Ct 0x0032 100 100 — Old_age Always - 0
9 Power_On_Hours 0x0032 100 100 — Old_age Always - 7314
12 Power_Cycle_Count 0x0032 100 100 — Old_age Always - 1610
165 Total_Write/Erase_Count 0x0032 100 100 — Old_age Always - 111726625574
166 Min_W/E_Cycle 0x0032 100 100 — Old_age Always - 3
167 Min_Bad_Block/Die 0x0032 100 100 — Old_age Always - 57
168 Maximum_Erase_Cycle 0x0032 100 100 — Old_age Always - 30
169 Total_Bad_Block 0x0032 100 100 — Old_age Always - 1005
170 Unknown_Attribute 0x0032 100 100 — Old_age Always - 0
171 Program_Fail_Count 0x0032 100 100 — Old_age Always - 0
172 Erase_Fail_Count 0x0032 100 100 — Old_age Always - 0
173 Avg_Write/Erase_Count 0x0032 100 100 — Old_age Always - 12
174 Unexpect_Power_Loss_Ct 0x0032 100 100 — Old_age Always - 306
184 End-to-End_Error 0x0032 100 100 — Old_age Always - 0
187 Reported_Uncorrect 0x0032 100 100 — Old_age Always - 0
188 Command_Timeout 0x0032 100 100 — Old_age Always - 0
194 Temperature_Celsius 0x0022 065 063 — Old_age Always - 35 (Min/Max 19/63)
199 SATA_CRC_Error 0x0032 100 100 — Old_age Always - 0
230 Perc_Write/Erase_Count 0x0032 100 100 — Old_age Always - 2327893705246
232 Perc_Avail_Resrvd_Space 0x0033 100 100 004 Pre-fail Always - 100
233 Total_NAND_Writes_GiB 0x0032 100 100 — Old_age Always - 12286
234 Perc_Write/Erase_Ct_BC 0x0032 100 100 — Old_age Always - 16521
241 Total_Writes_GiB 0x0030 253 253 — Old_age Offline - 15065
242 Total_Reads_GiB 0x0030 253 253 — Old_age Offline - 13430
244 Thermal_Throttle 0x0032 000 100 — Old_age Always - 0

SMART Error Log Version: 1
No Errors Logged

SMART Self-test log structure revision number 1
Num Test_Description Status Remaining LifeTime(hours) LBA_of_first_error

1 Extended offline Completed without error 00% 7314 -

2 Short offline Completed without error 00% 7313 -

3 Short offline Completed without error 00% 7290 -

Selective Self-tests/Logging not supported

When I cd into my usb drive by ssh, every single file i try to copy is fine (just some examples i tried).
webmin screenshot of the file permissions:

btrfs-check does not work from my ssh login, command not found
this:
https://btrfs.wiki.kernel.org/index.php/Btrfsck
points me to btrfs scrub to find defect blocks and repair them. i started the scrub with read only:

btrfs scrub start -r /dev/sda1

as soon as i have some statistics I post it here.
status of scrubs:
50

any idea what I can do to get my nextcloud up and running again?!
e.g. to default back to 17.0.3 backup, I see two files in:

/var/www/ncp-data.zoebFp
and a second
/var/www/nextcloud-bkp_20200301_1583084833-17.0.3.1.tar.gz

next update, sorry for the double post
after relogin into ncp web terminal, my status page shown me that the maria-db was online again as well as the nextcloud status error was gone
i’ve turned off the maintanence mode and updated from the web update page on my nextcloud main screen.
that worked well - it managed to reinstall my 17.0.3. from my backup.
the protokoll sais at the end, that two plugins or libraries where falty:
pictures and settings
log level is in german sorry:

log level of web updater to 17.0.3.

Update vorbereiten

Log-Level auf “debug” gesetzt

Wartungsmodus eingeschaltet

Reparaturschritt: Repair MySQL collation

Reparaturinformation: All tables already have the correct collation -> nothing to do

Reparaturschritt: Repair SQLite autoincrement

Reparaturschritt: Copy data from accounts table when migrating from ownCloud

Reparaturschritt: Drop account terms table when migrating from ownCloud

Das Datenbankschema wird aktualisiert

Datenbank aktualisiert

“accessibility” aktualisiert auf 1.3.0

“contacts” aktualisiert auf 3.1.8

“federatedfilesharing” aktualisiert auf 1.7.0

“files_pdfviewer” aktualisiert auf 1.6.0

“files_rightclick” aktualisiert auf 0.15.1

“files_videoplayer” aktualisiert auf 1.6.0

“logreader” aktualisiert auf 2.2.0

“password_policy” aktualisiert auf 1.7.0

Reparaturschritt: Repair Passwords Database Objects

Reparaturinformation: Checking 0 tag revisions

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 tag revisions

Reparaturinformation: Checking 0 folder revisions

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 folder revisions

Reparaturinformation: Checking 0 password revisions

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 password revisions

Reparaturinformation: Checking 0 tag models

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 tag models

Reparaturinformation: Checking 0 folder models

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 folder models

Reparaturinformation: Checking 0 password models

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 password models

Reparaturinformation: Checking 0 password tag relations

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 password tag relations

“passwords” aktualisiert auf 2020.2.1

“privacy” aktualisiert auf 1.1.0

“provisioning_api” aktualisiert auf 1.7.0

“recommendations” aktualisiert auf 0.5.0

“serverinfo” aktualisiert auf 1.7.0

“support” aktualisiert auf 1.0.1

“survey_client” aktualisiert auf 1.5.0

“text” aktualisiert auf 1.1.1

Reparaturschritt: Add background job to check for backup codes

“twofactor_backupcodes” aktualisiert auf 1.6.0

“updatenotification” aktualisiert auf 1.7.0

“federation” aktualisiert auf 1.7.0

“lookup_server_connector” aktualisiert auf 1.5.0

Reparaturschritt: Update OAuth token expiration times

“oauth2” aktualisiert auf 1.5.0

“files” aktualisiert auf 1.12.0

“activity” aktualisiert auf 2.10.1

“cloud_federation_api” aktualisiert auf 1.0.0

Reparaturschritt: Fix component of birthday calendars

Reparaturinformation: 8 birthday calendars updated.

Reparaturschritt: Regenerating birthday calendars to use new icons and fix old birthday events without year

Reparaturinformation: Repair step already executed

Reparaturschritt: Fix broken values of calendar objects

[0 / 0]: Fix broken values of calendar objects

Reparaturschritt: Registering building of calendar search index as background job

Reparaturinformation: Repair step already executed

Reparaturschritt: Registering background jobs to update cache for webcal calendars

Reparaturinformation: Added 0 background jobs to update webcal calendars

Reparaturschritt: Registering building of calendar reminder index as background job

Reparaturinformation: Repair step already executed

Reparaturschritt: Clean up orphan event and contact data

Reparaturinformation: 0 events without a calendar have been cleaned up

Reparaturinformation: 0 properties without an events have been cleaned up

Reparaturinformation: 0 changes without a calendar have been cleaned up

Reparaturinformation: 0 cached events without a calendar subscription have been cleaned up

Reparaturinformation: 0 changes without a calendar subscription have been cleaned up

Reparaturinformation: 0 contacts without an addressbook have been cleaned up

Reparaturinformation: 0 properties without a contact have been cleaned up

Reparaturinformation: 0 changes without an addressbook have been cleaned up

Reparaturschritt: Remove activity entries of private events

Reparaturinformation: Removed 0 activity entries

“dav” aktualisiert auf 1.13.0

Reparaturschritt: Fix the share type of guest shares when migrating from ownCloud

Reparaturschritt: Copy the share password into the dedicated column

“files_sharing” aktualisiert auf 1.9.0

“files_trashbin” aktualisiert auf 1.7.0

“files_versions” aktualisiert auf 1.10.0

“sharebymail” aktualisiert auf 1.7.0

“workflowengine” aktualisiert auf 1.7.0

“comments” aktualisiert auf 1.7.0

“firstrunwizard” aktualisiert auf 2.6.0

“nextcloud_announcements” aktualisiert auf 1.6.0

“notifications” aktualisiert auf 2.5.0

“systemtags” aktualisiert auf 1.7.0

“theming” aktualisiert auf 1.8.0

Suche nach einer Aktualisierung für die App “accessibility” im App-Store

App-Store auf Aktualisierung für die App “accessibility” geprüft

Suche nach einer Aktualisierung für die App “activity” im App-Store

App-Store auf Aktualisierung für die App “activity” geprüft

Suche nach einer Aktualisierung für die App “calendar” im App-Store

Aktualisiere die App “calendar” aus dem App-Store

Reparaturschritt: Update name of the stored view

App-Store auf Aktualisierung für die App “calendar” geprüft

Suche nach einer Aktualisierung für die App “cloud_federation_api” im App-Store

App-Store auf Aktualisierung für die App “cloud_federation_api” geprüft

Suche nach einer Aktualisierung für die App “comments” im App-Store

App-Store auf Aktualisierung für die App “comments” geprüft

Suche nach einer Aktualisierung für die App “contacts” im App-Store

Aktualisiere die App “contacts” aus dem App-Store

App-Store auf Aktualisierung für die App “contacts” geprüft

Suche nach einer Aktualisierung für die App “dav” im App-Store

App-Store auf Aktualisierung für die App “dav” geprüft

Suche nach einer Aktualisierung für die App “federatedfilesharing” im App-Store

App-Store auf Aktualisierung für die App “federatedfilesharing” geprüft

Suche nach einer Aktualisierung für die App “federation” im App-Store

App-Store auf Aktualisierung für die App “federation” geprüft

Suche nach einer Aktualisierung für die App “files” im App-Store

App-Store auf Aktualisierung für die App “files” geprüft

Suche nach einer Aktualisierung für die App “files_pdfviewer” im App-Store

App-Store auf Aktualisierung für die App “files_pdfviewer” geprüft

Suche nach einer Aktualisierung für die App “files_rightclick” im App-Store

App-Store auf Aktualisierung für die App “files_rightclick” geprüft

Suche nach einer Aktualisierung für die App “files_sharing” im App-Store

App-Store auf Aktualisierung für die App “files_sharing” geprüft

Suche nach einer Aktualisierung für die App “files_trashbin” im App-Store

App-Store auf Aktualisierung für die App “files_trashbin” geprüft

Suche nach einer Aktualisierung für die App “files_versions” im App-Store

App-Store auf Aktualisierung für die App “files_versions” geprüft

Suche nach einer Aktualisierung für die App “files_videoplayer” im App-Store

App-Store auf Aktualisierung für die App “files_videoplayer” geprüft

Suche nach einer Aktualisierung für die App “firstrunwizard” im App-Store

App-Store auf Aktualisierung für die App “firstrunwizard” geprüft

Suche nach einer Aktualisierung für die App “logreader” im App-Store

App-Store auf Aktualisierung für die App “logreader” geprüft

Suche nach einer Aktualisierung für die App “lookup_server_connector” im App-Store

App-Store auf Aktualisierung für die App “lookup_server_connector” geprüft

Suche nach einer Aktualisierung für die App “news” im App-Store

App-Store auf Aktualisierung für die App “news” geprüft

Suche nach einer Aktualisierung für die App “nextcloud_announcements” im App-Store

App-Store auf Aktualisierung für die App “nextcloud_announcements” geprüft

Suche nach einer Aktualisierung für die App “nextcloudpi” im App-Store

App-Store auf Aktualisierung für die App “nextcloudpi” geprüft

Suche nach einer Aktualisierung für die App “notes” im App-Store

App-Store auf Aktualisierung für die App “notes” geprüft

Suche nach einer Aktualisierung für die App “notifications” im App-Store

App-Store auf Aktualisierung für die App “notifications” geprüft

Suche nach einer Aktualisierung für die App “oauth2” im App-Store

App-Store auf Aktualisierung für die App “oauth2” geprüft

Suche nach einer Aktualisierung für die App “password_policy” im App-Store

App-Store auf Aktualisierung für die App “password_policy” geprüft

Suche nach einer Aktualisierung für die App “passwords” im App-Store

Aktualisiere die App “passwords” aus dem App-Store

Reparaturschritt: Repair Passwords Database Objects

Reparaturinformation: Checking 0 tag revisions

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 tag revisions

Reparaturinformation: Checking 0 folder revisions

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 folder revisions

Reparaturinformation: Checking 0 password revisions

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 password revisions

Reparaturinformation: Checking 0 tag models

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 tag models

Reparaturinformation: Checking 0 folder models

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 folder models

Reparaturinformation: Checking 0 password models

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 password models

Reparaturinformation: Checking 0 password tag relations

[0 / 0]: Repair Passwords Database Objects

Reparaturinformation: Fixed 0 password tag relations

App-Store auf Aktualisierung für die App “passwords” geprüft

Suche nach einer Aktualisierung für die App “previewgenerator” im App-Store

App-Store auf Aktualisierung für die App “previewgenerator” geprüft

Suche nach einer Aktualisierung für die App “privacy” im App-Store

App-Store auf Aktualisierung für die App “privacy” geprüft

Suche nach einer Aktualisierung für die App “provisioning_api” im App-Store

App-Store auf Aktualisierung für die App “provisioning_api” geprüft

Suche nach einer Aktualisierung für die App “recommendations” im App-Store

App-Store auf Aktualisierung für die App “recommendations” geprüft

Suche nach einer Aktualisierung für die App “serverinfo” im App-Store

App-Store auf Aktualisierung für die App “serverinfo” geprüft

Suche nach einer Aktualisierung für die App “sharebymail” im App-Store

App-Store auf Aktualisierung für die App “sharebymail” geprüft

Suche nach einer Aktualisierung für die App “support” im App-Store

App-Store auf Aktualisierung für die App “support” geprüft

Suche nach einer Aktualisierung für die App “survey_client” im App-Store

App-Store auf Aktualisierung für die App “survey_client” geprüft

Suche nach einer Aktualisierung für die App “systemtags” im App-Store

App-Store auf Aktualisierung für die App “systemtags” geprüft

Suche nach einer Aktualisierung für die App “tasks” im App-Store

App-Store auf Aktualisierung für die App “tasks” geprüft

Suche nach einer Aktualisierung für die App “text” im App-Store

App-Store auf Aktualisierung für die App “text” geprüft

Suche nach einer Aktualisierung für die App “theming” im App-Store

App-Store auf Aktualisierung für die App “theming” geprüft

Suche nach einer Aktualisierung für die App “twofactor_backupcodes” im App-Store

App-Store auf Aktualisierung für die App “twofactor_backupcodes” geprüft

Suche nach einer Aktualisierung für die App “twofactor_totp” im App-Store

App-Store auf Aktualisierung für die App “twofactor_totp” geprüft

Suche nach einer Aktualisierung für die App “updatenotification” im App-Store

App-Store auf Aktualisierung für die App “updatenotification” geprüft

Suche nach einer Aktualisierung für die App “viewer” im App-Store

App-Store auf Aktualisierung für die App “viewer” geprüft

Suche nach einer Aktualisierung für die App “workflowengine” im App-Store

App-Store auf Aktualisierung für die App “workflowengine” geprüft

Suche nach einer Aktualisierung für die App “photos” im App-Store

App-Store auf Aktualisierung für die App “photos” geprüft

Suche nach einer Aktualisierung für die App “settings” im App-Store

App-Store auf Aktualisierung für die App “settings” geprüft

Reparaturschritt: Repair MySQL collation

Reparaturinformation: All tables already have the correct collation -> nothing to do

Reparaturschritt: Repair mime types

Reparaturschritt: Clean tags and favorites

Reparaturinformation: 0 tags of deleted users have been removed.

Reparaturinformation: 0 tags for delete files have been removed.

Reparaturinformation: 0 tag entries for deleted tags have been removed.

Reparaturinformation: 0 tags with no entries have been removed.

Reparaturschritt: Repair invalid shares

Reparaturschritt: Move .step file of updater to backup location

Reparaturschritt: Fix potential broken mount points

Reparaturinformation: No mounts updated

Reparaturschritt: Add log rotate job

Reparaturschritt: Clear frontend caches

Reparaturinformation: Image cache cleared

Reparaturinformation: SCSS cache cleared

Reparaturinformation: JS cache cleared

Reparaturschritt: Clear every generated avatar on major updates

Reparaturschritt: Add preview background cleanup job

Reparaturschritt: Queue a one-time job to cleanup old backups of the updater

Reparaturschritt: Cleanup invalid photocache files for carddav

Reparaturschritt: Add background job to cleanup login flow v2 tokens

Reparaturschritt: Remove potentially over exposing share links

Reparaturinformation: No need to remove link shares.

Reparaturschritt: Clear access cache of projects

Reparaturschritt: Cleanup cypress files from viewer app

Reparaturschritt: Switches from deprecated “production” to “stable” update channel

Reparaturschritt: Sets the enterprise logo

Reparaturinformation: Repair step already executed

Code-Integrität wird überprüft

Code-Integritätsprüfung abgeschlossen

Wartungsmodus ausgeschaltet

Ursprüngliches Log-Level wiederhergestellt

Die folgenden Apps wurden deaktiviert: photos (inkompatibel), settings (inkompatibel)

I’m back in my 17.0.3.
So what is the best way to find my faulty update routine to 18.0.1 and what are the steps I should undertake to update?

In my web admin page in my nextcloud, I have no missing actions to undertake (e.g. update the database or stuff). just the two information:
Nextcloud Update 18.0.1.
and the missing nextcloudpi update

ok,
another update: nextcloud starts to fail again after some time.

with
journalctl -u mariadb | tail -20
i get:

journalctl mariadb

Mar 08 16:10:03 raspberrypi systemd[1]: Stopped MariaDB 10.3.22 database server.
Mar 08 16:10:03 raspberrypi systemd[1]: Starting MariaDB 10.3.22 database server…
Mar 08 16:10:24 raspberrypi mysqld[695]: 2020-03-08 16:10:24 0 [Note] /usr/sbin/mysqld (mysqld 10.3.22-MariaDB-0+deb10u1) starting as process 695 …
Mar 08 16:10:24 raspberrypi mysqld[695]: 2020-03-08 16:10:24 0 [Warning] Can’t create test file /media/myCloudDrive/nextcloud/ncdatabase/raspberrypi.lower-test
Mar 08 16:10:24 raspberrypi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Mar 08 16:10:24 raspberrypi systemd[1]: mariadb.service: Failed with result ‘exit-code’.
Mar 08 16:10:24 raspberrypi systemd[1]: Failed to start MariaDB 10.3.22 database server.
Mar 08 16:10:29 raspberrypi systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart.
Mar 08 16:10:29 raspberrypi systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 7.
Mar 08 16:10:29 raspberrypi systemd[1]: Stopped MariaDB 10.3.22 database server.
Mar 08 16:10:29 raspberrypi systemd[1]: Starting MariaDB 10.3.22 database server…
Mar 08 16:10:50 raspberrypi mysqld[913]: 2020-03-08 16:10:50 0 [Note] /usr/sbin/mysqld (mysqld 10.3.22-MariaDB-0+deb10u1) starting as process 913 …
Mar 08 16:10:50 raspberrypi mysqld[913]: 2020-03-08 16:10:50 0 [Warning] Can’t create test file /media/myCloudDrive/nextcloud/ncdatabase/raspberrypi.lower-test
Mar 08 16:10:50 raspberrypi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Mar 08 16:10:50 raspberrypi systemd[1]: mariadb.service: Failed with result ‘exit-code’.
Mar 08 16:10:50 raspberrypi systemd[1]: Failed to start MariaDB 10.3.22 database server.
Mar 08 16:10:55 raspberrypi systemd[1]: mariadb.service: Service RestartSec=5s expired, scheduling restart.
Mar 08 16:10:55 raspberrypi systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 8.
Mar 08 16:10:55 raspberrypi systemd[1]: Stopped MariaDB 10.3.22 database server.
Mar 08 16:10:55 raspberrypi systemd[1]: Starting MariaDB 10.3.22 database server…

and
tail -20 /var/log/mysql/error.log
gives

mysql error log

2020-03-08 16:10:24 0 [ERROR] Plugin ‘InnoDB’ init function returned error.
2020-03-08 16:10:24 0 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2020-03-08 16:10:24 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2020-03-08 16:10:24 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-03-08 16:10:24 0 [ERROR] Aborting

2020-03-08 16:10:50 0 [ERROR] mysqld: File ‘/media/myCloudDrive/nextcloud/ncdatabase/aria_log_control’ not found (Errcode: 30 “Read-only file system”)
2020-03-08 16:10:50 0 [ERROR] mysqld: Got error ‘Can’t open file’ when trying to use aria control file ‘/media/myCloudDrive/nextcloud/ncdatabase/aria_log_control’
2020-03-08 16:10:50 0 [ERROR] Plugin ‘Aria’ init function returned error.
2020-03-08 16:10:50 0 [ERROR] Plugin ‘Aria’ registration as a STORAGE ENGINE failed.
2020-03-08 16:10:50 0 [Warning] The parameter innodb_file_format is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/
2020-03-08 16:10:50 0 [Note] InnoDB: Using Linux native AIO
2020-03-08 16:10:50 0 [ERROR] InnoDB: The innodb_system data file ‘ibdata1’ must be writable
2020-03-08 16:10:50 0 [ERROR] InnoDB: The innodb_system data file ‘ibdata1’ must be writable
2020-03-08 16:10:50 0 [ERROR] Plugin ‘InnoDB’ init function returned error.
2020-03-08 16:10:50 0 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2020-03-08 16:10:50 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2020-03-08 16:10:50 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-03-08 16:10:50 0 [ERROR] Aborting

my ncp-report gives me:

ncp-report

<–! Paste this in GitHub report -->

NextCloudPi diagnostics

NextCloudPi version  v1.21.0
distribution         Raspbian GNU/Linux 10 \n \l
automount            yes
USB devices          sda 
datadir              /media/myCloudDrive/nextcloud/data
data in SD           no
data filesystem      btrfs
data disk usage      318G/895G
rootfs usage         3.9G/29G
swapfile             /var/swap
dbdir                /media/myCloudDrive/nextcloud/ncdatabase
Nextcloud check      error
HTTPD service        up
PHP service          up
MariaDB service      down
Redis service        up
Postfix service      up
internet check       ok
port check 80        open
port check 443       open
IP                   ***REMOVED SENSITIVE VALUE***
gateway              ***REMOVED SENSITIVE VALUE***
interface            eth0
certificates         ***REMOVED SENSITIVE VALUE***
NAT loopback         no
uptime               3days

Nextcloud configuration

An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused in /var/www/nextcloud/lib/private/DB/Connection.php:64
Stack trace:
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(420): OC\DB\Connection->connect()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(380): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(324): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(683): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/nextcloud/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(195): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /var/www/nextcloud/lib/private/DB/ConnectionFactory.php(156): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /var/www/nextcloud/lib/private/Server.php(635): OC\DB\ConnectionFactory->getConnection('mysql', Array)
#8 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#9 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OCP\\IDBConnecti...')
#10 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OCP\\IDBConnecti...')
#11 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#12 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('DatabaseConnect...')
#13 /var/www/nextcloud/lib/private/Server.php(1554): OC\ServerContainer->query('DatabaseConnect...')
#14 /var/www/nextcloud/lib/private/Server.php(362): OC\Server->getDatabaseConnection()
#15 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#16 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\Authenticati...')
#17 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(69): OC\ServerContainer->query('OC\\Authenticati...', true)
#18 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(99): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#19 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->resolve('OC\\Authenticati...')
#20 /var/www/nextcloud/lib/private/ServerContainer.php(145): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...', true)
#21 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(69): OC\ServerContainer->query('OC\\Authenticati...', true)
#22 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(99): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#23 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->resolve('OC\\Authenticati...')
#24 /var/www/nextcloud/lib/private/ServerContainer.php(145): OC\AppFramework\Utility\SimpleContainer->query('OC\\Authenticati...', true)
#25 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OC\\Authenticati...')
#26 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#27 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\Authenticati...')
#28 /var/www/nextcloud/lib/private/Server.php(374): OC\ServerContainer->query('OC\\Authenticati...')
#29 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#30 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\User\\Session')
#31 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OC\\User\\Session')
#32 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#33 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('UserSession')
#34 /var/www/nextcloud/lib/private/Server.php(1437): OC\ServerContainer->query('UserSession')
#35 /var/www/nextcloud/lib/private/Server.php(1028): OC\Server->getSession()
#36 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#37 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\Security\\CSR...')
#38 /var/www/nextcloud/lib/private/Server.php(1023): OC\ServerContainer->query('OC\\Security\\CSR...')
#39 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#40 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OC\\Security\\CSR...')
#41 /var/www/nextcloud/lib/private/Server.php(1900): OC\ServerContainer->query('OC\\Security\\CSR...')
#42 /var/www/nextcloud/lib/private/Server.php(823): OC\Server->getCsrfTokenManager()
#43 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#44 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OCP\\IRequest')
#45 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OCP\\IRequest')
#46 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#47 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('Request')
#48 /var/www/nextcloud/lib/private/Server.php(1304): OC\ServerContainer->query('Request')
#49 /var/www/nextcloud/lib/private/Server.php(466): OC\Server->getRequest()
#50 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#51 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('OCP\\L10N\\IFacto...')
#52 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query('OCP\\L10N\\IFacto...')
#53 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#54 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet('L10NFactory')
#55 /var/www/nextcloud/lib/private/Server.php(1490): OC\ServerContainer->query('L10NFactory')
#56 /var/www/nextcloud/lib/private/Server.php(1501): OC\Server->getL10NFactory()
#57 /var/www/nextcloud/lib/base.php(234): OC\Server->getL10N('lib')
#58 /var/www/nextcloud/lib/base.php(645): OC::checkConfig()
#59 /var/www/nextcloud/lib/base.php(1078): OC::init()
#60 /var/www/nextcloud/console.php(46): require_once('/var/www/nextcl...')
#61 /var/www/nextcloud/occ(11): require_once('/var/www/nextcl...')
#62 {main}
HTTPd logs

[Sun Mar 08 00:00:03.807703 2020] [ssl:warn] [pid 1001:tid 3069608464] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun Mar 08 00:00:03.808947 2020] [mpm_event:notice] [pid 1001:tid 3069608464] AH00489: Apache/2.4.38 (Raspbian) OpenSSL/1.1.1d configured -- resuming normal operations
[Sun Mar 08 00:00:03.808976 2020] [core:notice] [pid 1001:tid 3069608464] AH00094: Command line: '/usr/sbin/apache2'

Database logs

2020-03-08 16:19:33 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-03-08 16:19:33 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-03-08 16:19:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-08 16:19:33 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-03-08 16:19:33 0 [ERROR] Aborting

2020-03-08 16:19:59 0 [ERROR] mysqld: File '/media/myCloudDrive/nextcloud/ncdatabase/aria_log_control' not found (Errcode: 30 "Read-only file system")
2020-03-08 16:19:59 0 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/media/myCloudDrive/nextcloud/ncdatabase/aria_log_control'
2020-03-08 16:19:59 0 [ERROR] Plugin 'Aria' init function returned error.
2020-03-08 16:19:59 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2020-03-08 16:19:59 0 [Warning] The parameter innodb_file_format is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/
2020-03-08 16:19:59 0 [Note] InnoDB: Using Linux native AIO
2020-03-08 16:19:59 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2020-03-08 16:19:59 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2020-03-08 16:19:59 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-03-08 16:19:59 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-03-08 16:19:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-08 16:19:59 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-03-08 16:19:59 0 [ERROR] Aborting


Hi, any help is highly welcome :frowning:
after my last post I came back to my ncp installation today and now the database was ok again,
after switching off the maintance mode, I can reconnect to my nextcloud again.
who can this be?
this is so frustrating i have no idea what i must check even that this is not my first encounter with nextcloud (previous vps hosting), but this time with this ncp ‘container’ i’m a little lost.

a screenshot from my system log:

so guys i’m still totaly lost here

my automatic upload function (pictures taken and uploaded to a directory with year/month path) does fail from my phone. when I add the march path 2020/03 to my automatic upload picture path, the pictures taken are syncted to my cloud. why is my phone not able to create the path by itself? in the past, this was not a problem.

ok as there were no errors left in the nextcloud log, i gave it another try
first updated ncp
than used nc-update-nextloud.

failed again with this information in the log
help?!!!
:sleepy: :woozy_face:

Zusammenfassung

[ nc-update-nextcloud ]
Current Nextcloud version 17.0.3.1
Available Nextcloud version 18.0.1
Download Nextcloud 18.0.1…
Back up current instance…
check free space…
Maintenance mode enabled
backup database…
backup files…
backup /var/www//nextcloud-bkp_20200314_1584209598.tar.gz generated
Maintenance mode disabled
Install Nextcloud 18.0.1…
Restore apps…

  • calendar
  • contacts
  • gallery
  • news
  • nextcloudpi
  • notes
  • passwords
  • previewgenerator.orig
  • previewgenerator
  • tasks
  • twofactor_totp
    Fix permissions…
    Upgrade…
    Nextcloud or one of the apps require upgrade - only a limited number of commands are available
    You may use your browser or the occ upgrade command to do the upgrade
    Set log level to debug
    Set log level to debug
    Turned on maintenance mode
    Updating database schema
    Updated database
    Updating …
    Migrate old user config

Starting …
0/0 [>---------------------------] 0%
Starting …
1/0 [->--------------------------] 0%
Starting …
2/0 [–>-------------------------] 0%
Starting …
3/0 [—>------------------------] 0%
Starting …
4/0 [---->-----------------------] 0%
Starting …
5/0 [----->----------------------] 0%

Starting …
6/0 [------>---------------------] 0%
Starting …
7/0 [------->--------------------] 0%
Updated to 1.4.0
Updating …
Updated to 1.8.0
Updating <files_pdfviewer> …
Updated <files_pdfviewer> to 1.7.0
Updating <files_rightclick> …
Updated <files_rightclick> to 0.15.2
Updating <files_videoplayer> …
Updated <files_videoplayer> to 1.7.0
Updating …
Updated to 2.3.0
Updating <password_policy> …
Updated <password_policy> to 1.8.0
Updating …
Updated to 1.2.0
Updating <provisioning_api> …
Updated <provisioning_api> to 1.8.0
Updating …
Updated to 0.6.0
Updating …
Updated to 1.8.0
Updating …
Updated to 1.1.0
Updating <survey_client> …
Updated <survey_client> to 1.6.0
Updating …
Updated to 2.0.0
Updating <twofactor_backupcodes> …
Updated <twofactor_backupcodes> to 1.7.0
Updating …
Updated to 1.8.0
Updating …
Updated to 1.8.0
Updating <lookup_server_connector> …
Updated <lookup_server_connector> to 1.6.0
Updating …
Updated to 1.6.0
Updating …
Updated to 1.13.1
Updating …
Updated to 2.11.0
Updating <cloud_federation_api> …
Updated <cloud_federation_api> to 1.1.0
Updating …
Fix broken values of calendar objects

Starting …
0/0 [>---------------------------] 0%
Updated to 1.14.0
Updating <files_sharing> …
Updated <files_sharing> to 1.10.1
Updating <files_trashbin> …
Updated <files_trashbin> to 1.8.0
Updating <files_versions> …
Updated <files_versions> to 1.11.0
Updating …
Updated to 1.8.0
Updating …
Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘UPDATE oc_flow_operations SET entity = ? WHERE entity = ‘’’ with params [“OCA\WorkflowEngine\Entity\File”]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘entity’ in ‘where clause’
Update failed
Maintenance mode is kept active
Reset log level
Abort
Clean up…
Rolling back to backup /var/www/nextcloud-bkp_20200314_1584209598-17.0.3.1.tar.gz…
check free space…
extracting backup file /var/www/nextcloud-bkp_20200314_1584209598-17.0.3.1.tar.gz…
restore files…
restore database…
ERROR 2013 (HY000) at line 1184: Lost connection to MySQL server during query
Error restoring nextcloud database
Cleanup…
Rollback failed! Data left at /var/www/ncp-data.w4lwz0

the Datasbase Error is not found with a google search related to nextcloud updates, or no help is provided to my knowledge.
is it related to the

Updating …

line? so what is msising in my 17.0.3.1 that 18.0.1 needs?

I’m still posting here even that it does not look like that anyone is willing to help me. is this support area also watched by nextcloud support staff? what can I do to get some help or feedback that points me to any solution?

when i use the nc-report, my console gives me a huge amount of nextcloud log reqid errors where sensible information is not deleted (e.g. user names)

what are my options now? i can post here any details, I’ve searched EXTENSIVLY during the past 14 days about the problem, I searched for failed rollback and did not found any solution that points me to the right explenation how to get my 17.0.3 up and running again. why is this so problematic with ncp used for nextcloud installation?

I dont even have a basic clue what is wrong with my installation now :frowning:

here is the actual output without the nextcloud logs:

nc-report

<–! Paste this in GitHub report -->

NextCloudPi diagnostics

NextCloudPi version  v1.23.1
distribution         Raspbian GNU/Linux 10 \n \l
automount            yes
USB devices          sda 
datadir              /media/myCloudDrive/nextcloud/data
data in SD           no
data filesystem      btrfs
data disk usage      318G/895G
rootfs usage         4.1G/29G
swapfile             /var/swap
dbdir                /media/myCloudDrive/nextcloud/ncdatabase
Nextcloud check      ok
Nextcloud version    17.0.3.1
HTTPD service        up
PHP service          up
MariaDB service      up
Redis service        up
Postfix service      up
internet check       ok
port check 80        open
port check 443       open
IP                   ***REMOVED SENSITIVE VALUE***
gateway              ***REMOVED SENSITIVE VALUE***
interface            eth0
certificates         ***REMOVED SENSITIVE VALUE***
NAT loopback         no
uptime               20:24

Nextcloud configuration

{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": {
***REMOVED SENSITIVE VALUE***
        },
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "17.0.3.1",
        "overwrite.cli.url": ***REMOVED SENSITIVE VALUE***,
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "timeout": 0,
            "password": "***REMOVED SENSITIVE VALUE***"
        },
        "tempdirectory": "\/media\/myCloudDrive\/nextcloud\/data\/tmp",
        "mail_smtpmode": "sendmail",
        "mail_smtpauthtype": "LOGIN",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "preview_max_x": "2048",
        "preview_max_y": "2048",
        "jpeg_quality": "60",
        "overwriteprotocol": "https",
        "maintenance": false,
        "logfile": "\/media\/myCloudDrive\/nextcloud\/data\/nextcloud.log",
        "loglevel": "2",
        "log_type": "file",
        "mail_sendmailmode": "smtp",
        "mail_smtpsecure": "ssl",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "theme": ""
    }
}

HTTPd logs

[Tue Mar 17 00:00:06.317871 2020] [ssl:warn] [pid 1026:tid 3070083600] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Tue Mar 17 00:00:06.325558 2020] [mpm_event:notice] [pid 1026:tid 3070083600] AH00489: Apache/2.4.38 (Raspbian) OpenSSL/1.1.1d configured -- resuming normal operations
[Tue Mar 17 00:00:06.325616 2020] [core:notice] [pid 1026:tid 3070083600] AH00094: Command line: '/usr/sbin/apache2'
[Tue Mar 17 07:47:46.225512 2020] [authnz_external:error] [pid 16472:tid 2755965984] [client 192.168.1.181:49508] AuthExtern pwauth [/usr/sbin/pwauth]: Failed (1) for user ncp
[Tue Mar 17 07:47:46.225690 2020] [auth_basic:error] [pid 16472:tid 2755965984] [client 192.168.1.181:49508] AH01617: user ncp: authentication failure for "/": Password Mismatch
[Tue Mar 17 07:47:48.594422 2020] [authnz_external:error] [pid 16472:tid 2764366880] [client 192.168.1.181:49508] AuthExtern pwauth [/usr/sbin/pwauth]: Failed (1) for user ncp
[Tue Mar 17 07:47:48.594569 2020] [auth_basic:error] [pid 16472:tid 2764366880] [client 192.168.1.181:49508] AH01617: user ncp: authentication failure for "/": Password Mismatch
[Tue Mar 17 07:47:50.049654 2020] [authnz_external:error] [pid 16472:tid 2755965984] [client 192.168.1.181:49508] AuthExtern pwauth [/usr/sbin/pwauth]: Failed (1) for user ncp
[Tue Mar 17 07:47:50.049775 2020] [auth_basic:error] [pid 16472:tid 2755965984] [client 192.168.1.181:49508] AH01617: user ncp: authentication failure for "/": Password Mismatch

Database logs


Nextcloud logs

DELETED LOG WITH URL OR USERNAMES ...
</details>

support staff? i think never. nextcloud gmbh lives from selling their support. so i bet they won’t give it away for free.

there are several other companies trying to help ppl though… if you’re willing to pay for support. maybe you wanna ask @autoize for help here?

Delete everythin in youre account except:
/config
/data

Or if it start with a . /.data***

Download the latest zip file, put all the files in youre directory, except /config and run

php occ upgrade

ok so you recomment a complete reinstallation?
to be honest i need more help or information from you about what the steps you recomment will do.

step 1)
you mean i should delete everything in
/var/www/nextcloud
except the sub directory
/data
and
/config
Bildschirmfoto 2020-03-18 um 08.13.30

i have no
./.data***
directory or files in my /var/www/nextcloud path.

what zip file to download? i guess the 17.0.3. or 18.0.1 nextcloud installation zip file? in what directory to put the files? you mean /var/www/nextcloud correct?
when i than use the occ upgrade command, what will happen with my config - that is missing after that routine correct?

another error I get from ncp web interface when trying to force nextcloud into maintanance mode:

nc-maintenance

[ nc-maintenance ]
An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused in /var/www/nextcloud/lib/private/DB/Connection.php:64
Stack trace:
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(420): OC\DB\Connection->connect()
#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(380): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(324): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(683): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/nextcloud/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(195): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /var/www/nextcloud/lib/private/DB/ConnectionFactory.php(156): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /var/www/nextcloud/lib/private/Server.php(635): OC\DB\ConnectionFactory->getConnection(‘mysql’, Array)
#8 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#9 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet(‘OCP\IDBConnecti…’)
#10 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query(‘OCP\IDBConnecti…’)
#11 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#12 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet(‘DatabaseConnect…’)
#13 /var/www/nextcloud/lib/private/Server.php(1554): OC\ServerContainer->query(‘DatabaseConnect…’)
#14 /var/www/nextcloud/lib/private/Server.php(362): OC\Server->getDatabaseConnection()
#15 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#16 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet(‘OC\Authenticati…’)
#17 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(69): OC\ServerContainer->query(‘OC\Authenticati…’, true)
#18 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(99): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#19 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->resolve(‘OC\Authenticati…’)
#20 /var/www/nextcloud/lib/private/ServerContainer.php(145): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’, true)
#21 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(69): OC\ServerContainer->query(‘OC\Authenticati…’, true)
#22 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(99): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#23 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(114): OC\AppFramework\Utility\SimpleContainer->resolve(‘OC\Authenticati…’)
#24 /var/www/nextcloud/lib/private/ServerContainer.php(145): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’, true)
#25 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query(‘OC\Authenticati…’)
#26 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#27 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet(‘OC\Authenticati…’)
#28 /var/www/nextcloud/lib/private/Server.php(374): OC\ServerContainer->query(‘OC\Authenticati…’)
#29 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#30 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet(‘OC\User\Session’)
#31 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query(‘OC\User\Session’)
#32 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#33 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet(‘UserSession’)
#34 /var/www/nextcloud/lib/private/Server.php(1430): OC\ServerContainer->query(‘UserSession’)
#35 /var/www/nextcloud/lib/private/Server.php(688): OC\Server->getUserSession()
#36 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#37 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet(‘OC\App\AppManag…’)
#38 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(161): OC\ServerContainer->query(‘OC\App\AppManag…’)
#39 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#40 /var/www/nextcloud/lib/private/ServerContainer.php(120): Pimple\Container->offsetGet(‘AppManager’)
#41 /var/www/nextcloud/lib/private/Server.php(1725): OC\ServerContainer->query(‘AppManager’)
#42 /var/www/nextcloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#43 /var/www/nextcloud/lib/private/legacy/app.php(114): OC_App::getEnabledApps()
#44 /var/www/nextcloud/lib/base.php(640): OC_App::loadApps(Array)
#45 /var/www/nextcloud/lib/base.php(1078): OC::init()
#46 /var/www/nextcloud/console.php(46): require_once(’/var/www/nextcl…’)
#47 /var/www/nextcloud/occ(11): require_once(’/var/www/nextcl…’)
#48 {main}

Do you have backups?
Connection to db-server seems to be down, did you move db to your external drive?
And add a 2nd drive with automount enabled?

output of:

sudo systemctl status mariadb.service

and if down

sudo systemctl start mariadb.service