Nextcloud version : 22.2.0
Operating system and version: TrueNAS-12.0-U6 (Core) (installed in a 12.2-RELEASE-p10 jail not using the plugin)
Apache or nginx version: Apache 2.4.51
PHP version: 7.4
MySQL version: Maria db 10.3
The issue you are facing:
I’ve been running Nextcloud for a couple of years now with only a few issues. I tried to update from 21 to 22 using the web updater a couple of weeks ago (it did not go well). I have done several updates in the past with little or no issue, so I did not do any backups outside of what the web updates do automatically (yeah, I know I screwed up…) The updater went through all of the steps and got to the part where I click to perform the update and take it out of maintenance mode. The update fails, and the last message is:
Repair step: Fix the namespace in database tables
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused
I attempt to run the suggested occ repair suggested in many forums only to be greeted with the same error about connection refused.
I also made syre that the mysql user and group had permissions to the /tmp/mysql.sock file.
After much digging I find that the MySql service is not running. If I run the command:
service mysql-server start
It says Starting MySql and then returns the command line with no errors, but when I run:
service mysql-server status
It then says that MySQL is not running.
Some background on my setup. I have Nextcloud installed in Jail, but all of the data, database, and config files are stored in my main pool with mount points form the Jail back to the main pool, so that in theory, if the Jail every corrupts, I can just build a new jail, and re-link it back to the pools. (I installed it mostly fallowing this guide) .
When I try to re-build my jail, I can’t get past the part of starting MySQL service, if I mount the link back to the db in the pool. If I don’t link to the db pool, I can setup the jail, but I don’t have any of my previous settings or the 4 or 5 users setup. It’s like the very presence of the old db files stops MySQL from even running.
I had read several places that said to try to re-add the db mount point and have tried that with no luck.
Is this the first time you’ve seen this error? : Y
Steps to replicate it:
- Upgrade to 22.2.0
The output of your Nextcloud log in Admin > Logging:
No errors in the log, but thi was in the update log:
2021-10-17T18:25:14-0400 2Y4G5LOOxi [info] request to updater
2021-10-17T18:25:14-0400 2Y4G5LOOxi [info] currentStep()
2021-10-17T18:25:14-0400 2Y4G5LOOxi [info] show HTML page
2021-10-17T18:25:14-0400 2Y4G5LOOxi [info] current version: 21.0.5 build time: 2021-09-29T21:00:49+00:00 64e55fdd4a9ab38d5ad5e8fe457b2912e43efead
2021-10-17T18:25:14-0400 2Y4G5LOOxi [info] getUpdateServerResponse()
2021-10-17T18:25:14-0400 2Y4G5LOOxi [info] updaterServer: https://updates.nextcloud.com/updater_server/
2021-10-17T18:25:14-0400 2Y4G5LOOxi [info] releaseChannel: stable
2021-10-17T18:25:14-0400 2Y4G5LOOxi [info] internal version: 21.0.5.1
2021-10-17T18:25:14-0400 2Y4G5LOOxi [info] updateURL: https://updates.nextcloud.com/updater_server/?version=21x0x5x1xxxstablexx2021-09-29T21%3A00%3A49%2B00%3A00+64e55fdd4a9ab38d5ad5e8fe457b2912e43efeadx>
2021-10-17T18:25:16-0400 2Y4G5LOOxi [info] getUpdateServerResponse response: Array
(
[version] => 22.2.0.2
[versionstring] => Nextcloud 22.2.0
[url] => https://download.nextcloud.com/server/releases/nextcloud-22.2.0.zip
[web] => https://docs.nextcloud.com/server/22/admin_manual/maintenance/upgrade.html
[changes] => https://updates.nextcloud.com/changelog_server/?version=22.2.0
[autoupdater] => 1
[eol] => 0
[signature] => IF7GWr7KVXkakHrQixMoXXQziCFMmUNI42fuCbgQLsv1+s8f6Ezaux7VlsO8FRAm
dPkyZq2MNLdZYeWtTTI38xoiqpsaJA8eR8HXEA+KJ83egH0C5K1SacPFsRyJipyc
cynghWwswoHsLht1ms2E6LWPelc4SaIL6Ngitv+1Vxjw7+T6mHzV4/5y7Rc4AFPG
XFdlY91U6sxuhgN9Uti7JJWNeu1V6wSjnzGUqR5egkSeyL+B76TNezhGfbqvVZbb
AUTy0ZHZXAt9LIGI9YmqBv90CgmW5xmBrt/qqw0f/M4A4C1BCDwh4DI2Ylh5OS+R
igCw9M1FBIhT4+LRdFBupQ==
)
2021-10-17T18:25:16-0400 2Y4G5LOOxi [info] checkForUpdate() Array
(
[version] => 22.2.0.2
[versionstring] => Nextcloud 22.2.0
[url] => https://download.nextcloud.com/server/releases/nextcloud-22.2.0.zip
[web] => https://docs.nextcloud.com/server/22/admin_manual/maintenance/upgrade.html
[changes] => https://updates.nextcloud.com/changelog_server/?version=22.2.0
[autoupdater] => 1
[eol] => 0
[signature] => IF7GWr7KVXkakHrQixMoXXQziCFMmUNI42fuCbgQLsv1+s8f6Ezaux7VlsO8FRAm
dPkyZq2MNLdZYeWtTTI38xoiqpsaJA8eR8HXEA+KJ83egH0C5K1SacPFsRyJipyc
cynghWwswoHsLht1ms2E6LWPelc4SaIL6Ngitv+1Vxjw7+T6mHzV4/5y7Rc4AFPG
XFdlY91U6sxuhgN9Uti7JJWNeu1V6wSjnzGUqR5egkSeyL+B76TNezhGfbqvVZbb
AUTy0ZHZXAt9LIGI9YmqBv90CgmW5xmBrt/qqw0f/M4A4C1BCDwh4DI2Ylh5OS+R
igCw9M1FBIhT4+LRdFBupQ==
)
2021-10-17T18:25:16-0400 2Y4G5LOOxi [info] getChangelogURL()
2021-10-17T18:25:16-0400 2Y4G5LOOxi [info] end of checkForUpdate() Update to Nextcloud 22.2.0 available. (channel: "stable")<br /><span class="light">Following file will be downloaded automatically:</sp>
2021-10-17T18:25:24-0400 v17sc6X8oD [info] request to updater
2021-10-17T18:25:24-0400 v17sc6X8oD [info] currentStep()
2021-10-17T18:25:24-0400 v17sc6X8oD [info] POST request for step "1"
2021-10-17T18:25:24-0400 v17sc6X8oD [info] startStep("1")
2021-10-17T18:25:24-0400 v17sc6X8oD [info] checkForExpectedFilesAndFolders()
2021-10-17T18:25:24-0400 v17sc6X8oD [info] end of checkForExpectedFilesAndFolders()
2021-10-17T18:25:24-0400 v17sc6X8oD [info] endStep("1")
2021-10-17T18:25:24-0400 nkYknYMGBG [info] request to updater
2021-10-17T18:25:24-0400 nkYknYMGBG [info] currentStep()
2021-10-17T18:25:24-0400 nkYknYMGBG [info] Step 1 is in state "end".
2021-10-17T18:25:24-0400 nkYknYMGBG [info] POST request for step "2"
2021-10-17T18:25:24-0400 nkYknYMGBG [info] startStep("2")
2021-10-17T18:25:24-0400 nkYknYMGBG [info] checkWritePermissions()
2021-10-17T18:25:24-0400 nkYknYMGBG [info] end of checkWritePermissions()
2021-10-17T18:25:24-0400 nkYknYMGBG [info] endStep("2")
2021-10-17T18:25:24-0400 MpYjCx44zf [info] request to updater
2021-10-17T18:25:24-0400 MpYjCx44zf [info] currentStep()
2021-10-17T18:25:24-0400 MpYjCx44zf [info] Step 2 is in state "end".
2021-10-17T18:25:24-0400 MpYjCx44zf [info] POST request for step "3"
2021-10-17T18:25:24-0400 MpYjCx44zf [info] startStep("3")
2021-10-17T18:25:24-0400 MpYjCx44zf [info] createBackup()
2021-10-17T18:25:24-0400 MpYjCx44zf [info] backup folder location: /mnt/data/updater-oc3mkajlk529/backups/nextcloud-21.0.5.1-1634509524/
2021-10-17T18:26:05-0400 MpYjCx44zf [info] end of createBackup()
2021-10-17T18:26:05-0400 MpYjCx44zf [info] endStep("3")
2021-10-17T18:26:05-0400 ShTDonAtSN [info] request to updater
2021-10-17T18:26:05-0400 ShTDonAtSN [info] currentStep()
2021-10-17T18:26:05-0400 ShTDonAtSN [info] Step 3 is in state "end".
2021-10-17T18:26:05-0400 ShTDonAtSN [info] POST request for step "4"
2021-10-17T18:26:05-0400 ShTDonAtSN [info] startStep("4")
2021-10-17T18:26:05-0400 ShTDonAtSN [info] downloadUpdate()
2021-10-17T18:26:05-0400 ShTDonAtSN [info] getUpdateServerResponse()
2021-10-17T18:26:05-0400 ShTDonAtSN [info] updaterServer: https://updates.nextcloud.com/updater_server/
2021-10-17T18:26:05-0400 ShTDonAtSN [info] releaseChannel: stable
2021-10-17T18:26:05-0400 ShTDonAtSN [info] internal version: 21.0.5.1
2021-10-17T18:26:05-0400 ShTDonAtSN [info] updateURL: https://updates.nextcloud.com/updater_server/?version=21x0x5x1xxxstablexx2021-09-29T21%3A00%3A49%2B00%3A00+64e55fdd4a9ab38d5ad5e8fe457b2912e43efeadx>
2021-10-17T18:26:07-0400 ShTDonAtSN [info] getUpdateServerResponse response: Array
(
[version] => 22.2.0.2
[versionstring] => Nextcloud 22.2.0
[url] => https://download.nextcloud.com/server/releases/nextcloud-22.2.0.zip
[web] => https://docs.nextcloud.com/server/22/admin_manual/maintenance/upgrade.html
[changes] => https://updates.nextcloud.com/changelog_server/?version=22.2.0
[autoupdater] => 1
[eol] => 0
[signature] => IF7GWr7KVXkakHrQixMoXXQziCFMmUNI42fuCbgQLsv1+s8f6Ezaux7VlsO8FRAm
dPkyZq2MNLdZYeWtTTI38xoiqpsaJA8eR8HXEA+KJ83egH0C5K1SacPFsRyJipyc
cynghWwswoHsLht1ms2E6LWPelc4SaIL6Ngitv+1Vxjw7+T6mHzV4/5y7Rc4AFPG
XFdlY91U6sxuhgN9Uti7JJWNeu1V6wSjnzGUqR5egkSeyL+B76TNezhGfbqvVZbb
AUTy0ZHZXAt9LIGI9YmqBv90CgmW5xmBrt/qqw0f/M4A4C1BCDwh4DI2Ylh5OS+R
igCw9M1FBIhT4+LRdFBupQ==
)
2021-10-17T18:26:07-0400 ShTDonAtSN [info] storage location exists
2021-10-17T18:26:41-0400 ShTDonAtSN [info] end of downloadUpdate()
2021-10-17T18:26:41-0400 ShTDonAtSN [info] endStep("4")
2021-10-17T18:26:41-0400 NW4dTwbEXo [info] request to updater
2021-10-17T18:26:41-0400 NW4dTwbEXo [info] currentStep()
2021-10-17T18:26:41-0400 NW4dTwbEXo [info] Step 4 is in state "end".
2021-10-17T18:26:41-0400 NW4dTwbEXo [info] POST request for step "5"
2021-10-17T18:26:41-0400 NW4dTwbEXo [info] startStep("5")
2021-10-17T18:26:41-0400 NW4dTwbEXo [info] verifyIntegrity()
2021-10-17T18:26:41-0400 NW4dTwbEXo [info] getUpdateServerResponse()
2021-10-17T18:26:41-0400 NW4dTwbEXo [info] updaterServer: https://updates.nextcloud.com/updater_server/
2021-10-17T18:26:41-0400 NW4dTwbEXo [info] releaseChannel: stable
2021-10-17T18:26:41-0400 NW4dTwbEXo [info] internal version: 21.0.5.1
2021-10-17T18:26:41-0400 NW4dTwbEXo [info] updateURL: https://updates.nextcloud.com/updater_server/?version=21x0x5x1xxxstablexx2021-09-29T21%3A00%3A49%2B00%3A00+64e55fdd4a9ab38d5ad5e8fe457b2912e43efeadx>
2021-10-17T18:26:43-0400 NW4dTwbEXo [info] getUpdateServerResponse response: Array
(
[version] => 22.2.0.2
[versionstring] => Nextcloud 22.2.0
[url] => https://download.nextcloud.com/server/releases/nextcloud-22.2.0.zip
[web] => https://docs.nextcloud.com/server/22/admin_manual/maintenance/upgrade.html
[changes] => https://updates.nextcloud.com/changelog_server/?version=22.2.0
[autoupdater] => 1
[eol] => 0
[signature] => IF7GWr7KVXkakHrQixMoXXQziCFMmUNI42fuCbgQLsv1+s8f6Ezaux7VlsO8FRAm
dPkyZq2MNLdZYeWtTTI38xoiqpsaJA8eR8HXEA+KJ83egH0C5K1SacPFsRyJipyc
cynghWwswoHsLht1ms2E6LWPelc4SaIL6Ngitv+1Vxjw7+T6mHzV4/5y7Rc4AFPG
XFdlY91U6sxuhgN9Uti7JJWNeu1V6wSjnzGUqR5egkSeyL+B76TNezhGfbqvVZbb
AUTy0ZHZXAt9LIGI9YmqBv90CgmW5xmBrt/qqw0f/M4A4C1BCDwh4DI2Ylh5OS+R
igCw9M1FBIhT4+LRdFBupQ==
)
2021-10-17T18:26:43-0400 NW4dTwbEXo [info] storage location: /mnt/data/updater-oc3mkajlk529/downloads/
2021-10-17T18:26:44-0400 NW4dTwbEXo [info] end of verifyIntegrity()
2021-10-17T18:26:44-0400 NW4dTwbEXo [info] endStep("5")
2021-10-17T18:26:44-0400 YAo2KBQ74h [info] request to updater
2021-10-17T18:26:44-0400 YAo2KBQ74h [info] currentStep()
2021-10-17T18:26:44-0400 YAo2KBQ74h [info] Step 5 is in state "end".
2021-10-17T18:26:44-0400 YAo2KBQ74h [info] POST request for step "6"
2021-10-17T18:26:44-0400 YAo2KBQ74h [info] startStep("6")
2021-10-17T18:26:44-0400 YAo2KBQ74h [info] extractDownload()
2021-10-17T18:26:44-0400 YAo2KBQ74h [info] storage location: /mnt/data/updater-oc3mkajlk529/downloads/
2021-10-17T18:26:47-0400 YAo2KBQ74h [info] end of extractDownload()
2021-10-17T18:26:47-0400 YAo2KBQ74h [info] endStep("6")
2021-10-17T18:26:47-0400 RwWM4NoQoJ [info] request to updater
2021-10-17T18:26:47-0400 RwWM4NoQoJ [info] currentStep()
2021-10-17T18:26:47-0400 RwWM4NoQoJ [info] Step 6 is in state "end".
2021-10-17T18:26:47-0400 RwWM4NoQoJ [info] POST request for step "7"
2021-10-17T18:26:47-0400 RwWM4NoQoJ [info] startStep("7")
2021-10-17T18:26:47-0400 RwWM4NoQoJ [info] setMaintenanceMode("true")
2021-10-17T18:26:47-0400 RwWM4NoQoJ [info] configFileName /usr/local/www/nextcloud/updater/../config/config.php
2021-10-17T18:26:47-0400 RwWM4NoQoJ [info] end of setMaintenanceMode()
2021-10-17T18:26:47-0400 RwWM4NoQoJ [info] endStep("7")
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] request to updater
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] currentStep()
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] Step 7 is in state "end".
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] POST request for step "8"
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] startStep("8")
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] replaceEntryPoints()
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] replace index.php
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] replace status.php
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] replace remote.php
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] replace public.php
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] replace ocs/v1.php
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] replace ocs/v2.php
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] end of replaceEntryPoints()
2021-10-17T18:26:47-0400 RRKSCpXWWb [info] endStep("8")
2021-10-17T18:26:48-0400 YRpOAEznSW [info] request to updater
2021-10-17T18:26:48-0400 YRpOAEznSW [info] currentStep()
2021-10-17T18:26:48-0400 YRpOAEznSW [info] Step 8 is in state "end".
2021-10-17T18:26:48-0400 YRpOAEznSW [info] POST request for step "9"
2021-10-17T18:26:48-0400 YRpOAEznSW [info] startStep("9")
2021-10-17T18:26:48-0400 YRpOAEznSW [info] deleteOldFiles()
2021-10-17T18:26:51-0400 YRpOAEznSW [info] config sample exists
2021-10-17T18:26:51-0400 YRpOAEznSW [info] themes README exists
2021-10-17T18:26:53-0400 YRpOAEznSW [info] end of deleteOldFiles()
2021-10-17T18:26:53-0400 YRpOAEznSW [info] endStep("9")
2021-10-17T18:26:53-0400 27CClzVYy3 [info] request to updater
2021-10-17T18:26:53-0400 27CClzVYy3 [info] currentStep()
2021-10-17T18:26:53-0400 27CClzVYy3 [info] Step 9 is in state "end".
2021-10-17T18:26:53-0400 27CClzVYy3 [info] POST request for step "10"
2021-10-17T18:26:53-0400 27CClzVYy3 [info] startStep("10")
2021-10-17T18:26:53-0400 27CClzVYy3 [info] moveNewVersionInPlace()
2021-10-17T18:26:53-0400 27CClzVYy3 [info] storage location: /mnt/data/updater-oc3mkajlk529/downloads/nextcloud/
2021-10-17T18:26:59-0400 27CClzVYy3 [info] end of moveNewVersionInPlace()
2021-10-17T18:26:59-0400 27CClzVYy3 [info] endStep("10")
2021-10-17T18:27:05-0400 nu1pGXfDT4 [info] request to updater
2021-10-17T18:27:05-0400 nu1pGXfDT4 [info] currentStep()
2021-10-17T18:27:05-0400 nu1pGXfDT4 [info] Step 10 is in state "end".
2021-10-17T18:27:05-0400 nu1pGXfDT4 [info] POST request for step "11"
2021-10-17T18:27:05-0400 nu1pGXfDT4 [info] startStep("11")
2021-10-17T18:27:05-0400 nu1pGXfDT4 [info] setMaintenanceMode("false")
2021-10-17T18:27:05-0400 nu1pGXfDT4 [info] configFileName /usr/local/www/nextcloud/updater/../config/config.php
2021-10-17T18:27:05-0400 nu1pGXfDT4 [info] end of setMaintenanceMode()
2021-10-17T18:27:05-0400 nu1pGXfDT4 [info] endStep("11")
2021-10-17T18:27:05-0400 yl7veNB345 [info] request to updater
2021-10-17T18:27:05-0400 yl7veNB345 [info] currentStep()
2021-10-17T18:27:05-0400 yl7veNB345 [info] Step 11 is in state "end".
2021-10-17T18:27:05-0400 yl7veNB345 [info] POST request for step "12"
2021-10-17T18:27:05-0400 yl7veNB345 [info] startStep("12")
2021-10-17T18:27:05-0400 yl7veNB345 [info] finalize()
2021-10-17T18:27:05-0400 yl7veNB345 [info] storage location: /mnt/data/updater-oc3mkajlk529/downloads/nextcloud/
2021-10-17T18:27:05-0400 yl7veNB345 [info] call opcache_reset()
2021-10-17T18:27:05-0400 yl7veNB345 [info] end of finalize()
2021-10-17T18:27:05-0400 yl7veNB345 [info] endStep("12")
The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'apps_paths' =>
array (
0 =>
array (
'path' => '/usr/local/www/nextcloud/apps',
'url' => '/apps',
'writable' => true,
),
1 =>
array (
'path' => '/usr/local/www/nextcloud/apps-pkg',
'url' => '/apps-pkg',
'writable' => false,
),
),
'logfile' => '/var/log/nextcloud/nextcloud.log',
'memcache.local' => '\\OC\\Memcache\\APCu',
'instanceid' => '***',
'passwordsalt' => '***',
'secret' => '***',
'trusted_domains' =>
array (
0 => '192.168.***.***',
1 => 'nextcloud.***.com',
),
'datadirectory' => '/mnt/data',
'dbtype' => 'mysql',
'version' => '21.0.5.1',
'overwrite.cli.url' => 'http://192.168.***.***',
'dbname' => 'nextcloud',
'dbhost' => 'localhost:/tmp/mysql.sock',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => '****',
'dbpassword' => '***',
'installed' => true,
'mail_smtpmode' => 'sendmail',
'mail_smtphost' => '****.***.***',
'mail_sendmailmode' => '****',
'mail_smtpport' => '***',
'mail_from_address' => '*****',
'mail_domain' => '***.***',
'mail_smtpsecure' => '***,
'mail_smtpauthtype' => '****',
'mail_smtpauth' => 1,
'mail_smtpname' => '***@****.***',
'mail_smtppassword' => '*****',
'maintenance' => false,
'theme' => '',
'loglevel' => 0,
'updater.release.channel' => 'stable',
'default_phone_region' => 'US',
'updater.secret' => '***',
);
The output of your Apache system log in /var/log/apache:
No log file
The output of MySQL in var/log/mysql:
2021-10-29 18:10:42 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/
2021-10-29 18:10:42 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-10-29 18:10:42 0 [Note] InnoDB: Uses event mutexes
2021-10-29 18:10:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-10-29 18:10:42 0 [Note] InnoDB: Number of pools: 1
2021-10-29 18:10:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-10-29 18:10:42 0 [ERROR] mysqld: Can't create/write to file '/tmp/ibmP82F5' (Errcode: 13 "Permission denied")
2021-10-29 18:10:42 0 [ERROR] InnoDB: Unable to create temporary file; errno: 13
2021-10-29 18:10:42 0 [ERROR] mysqld: Can't create/write to file '/tmp/ibcXkhtC' (Errcode: 13 "Permission denied")
2021-10-29 18:10:42 0 [ERROR] InnoDB: Unable to create temporary file; errno: 13
2021-10-29 18:10:42 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-10-29 18:10:42 0 [Note] InnoDB: Starting shutdown...
2021-10-29 18:10:43 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-10-29 18:10:43 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-10-29 18:10:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-10-29 18:10:43 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-10-29 18:10:43 0 [ERROR] Aborting