DB issue upgrading to version 30.0.0 on FreeBSD

Support intro

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version 30.0.0
Operating system and version FreeBSD 14.1-RELEASE-p5
nginx version 26.2_4,3
PHP version 8.2.23
mysql version 8.0.3

The issue you are facing:
After installing the update from 29.0.6 to 30.0.0 the occ script run via the web interface failed after attempting to update the database schemas

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

Steps to replicate it:

  1. Update Freshports package from 29.0.6 to 30.0.0
  2. Open the local nextcloud homepage
  3. Click on start upgrade

The output of your Nextcloud log in Admin > Logging:

The web page says:  An error occurred, Please reload page.

If I reload the page I get
"Sorry, the page you are looking for is currently unavailable." code 503

Looking at the nextcloud log, the last entry still is for "version":"29.0.6.1" and has nothing to do with the upgrade.

The status page gives the following info:

{"installed":true,"maintenance":true,"needsDbUpgrade":true,"version":"30.0.0.14","versionstring":"30.0.0","edition":"","productname":"Nextcloud","extendedSupport":false}

I can't figure out how to re-run occ from the CLI.

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.100',
    1 => 'wx.schamschula.com',
  ),
  'datadirectory' => '/tank/www/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '29.0.6.1',
  'overwrite.cli.url' => 'http://192.168.1.100/***',
  'dbname' => 'nextcloud_db',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud_user',
  'dbpassword' => '****',
  'installed' => true,
  'trashbin_retention_obligation' => 'auto, 30',
  'theme' => '',
  'loglevel' => 0,
  'maintenance' => true,
);

The output of your Apache/nginx/system log in /var/log/____:

192.168.1.20 - Marius Schamschula [22/Sep/2024:15:44:46 -0500] "GET /homecloud/index.php/204 HTTP/1.1" 503 497 "-" "Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-23.6.0 ClientArchitecture: arm64 OsArchitecture: arm64)"
192.168.1.20 - Marius Schamschula [22/Sep/2024:15:44:46 -0500] "GET /homecloud/index.php/204 HTTP/1.1" 503 497 "-" "Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-23.6.0 ClientArchitecture: arm64 OsArchitecture: arm64)"
192.168.1.20 - Marius Schamschula [22/Sep/2024:15:44:46 -0500] "GET /homecloud/status.php HTTP/1.1" 200 149 "-" "Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-23.6.0 ClientArchitecture: arm64 OsArchitecture: arm64)"
192.168.1.50 - Marius Schamschula [22/Sep/2024:15:45:04 -0500] "GET /homecloud/index.php/204 HTTP/1.1" 503 497 "-" "Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.1.0 ClientArchitecture: arm64 OsArchitecture: arm64)"
192.168.1.50 - Marius Schamschula [22/Sep/2024:15:45:04 -0500] "GET /homecloud/index.php/204 HTTP/1.1" 503 497 "-" "Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.1.0 ClientArchitecture: arm64 OsArchitecture: arm64)"
192.168.1.50 - Marius Schamschula [22/Sep/2024:15:45:04 -0500] "GET /homecloud/status.php HTTP/1.1" 200 149 "-" "Mozilla/5.0 (Macintosh) mirall/3.14.0daily (Nextcloud, macos-24.1.0 ClientArchitecture: arm64 OsArchitecture: arm64)"
192.168.1.20 - - [22/Sep/2024:15:45:38 -0500] "GET /homecloud/core/ajax/update.php?requesttoken=6W0IkDXJbenZ0trZLal0hQ087A5J7z7yblBU9NhSIHw%3D%3AnCh%2BoVKNX6eI44%2Fpf95fyk8Tm0kktRHGPwlgp74DcRU%3D HTTP/1.1" 200 576 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.0 Safari/605.1.15"
192.168.1.20 - - [22/Sep/2024:15:45:45 -0500] "GET /homecloud/ HTTP/1.1" 503 497 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.0 Safari/605.1.15"

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

4/09/22 15:44:31 [error] 94378#107210: *56 open() "/usr/local/www/nginx/apps/theming/img/background/jenna-kim-the-globe.webp" failed (2: No such file or directory), client: 192.168.1.20, server: wx.schamschula.com, request: "GET /apps/theming/img/background/jenna-kim-the-globe.webp HTTP/1.1", host: "192.168.1.100"
2024/09/22 15:45:38 [error] 94378#107210: *58 upstream timed out (60: Operation timed out) while reading upstream, client: 192.168.1.20, server: wx.schamschula.com, request: "GET /homecloud/core/ajax/update.php?requesttoken=6W0IkDXJbenZ0trZLal0hQ087A5J7z7yblBU9NhSIHw%3D%3AnCh%2BoVKNX6eI44%2Fpf95fyk8Tm0kktRHGPwlgp74DcRU%3D HTTP/1.1", upstream: "fastcgi://127.0.0.
1:9000", host: "192.168.1.100"

Update: I did find all I needed in my notes:

  1. run occ as www (no errors!)
  2. edit config/config.php to set 'maintenance' => false, in config/config.php
  3. service php-fpm restart

su -m www -c 'php occ upgrade'

Does this do anything?

Once the occ upgrade is run successfully, it should be switched to 30… afterwards. So this is the proof, that the occ upgrade didn’t run through properly.

As you can see by my second post I figured it out.

So now it is working?

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