Error upgrading from 9.0.0.19 to 9.1.3

9.1.x

#1

Dear OC team, please help me. Thank you in advance!

Steps to reproduce

  1. I connect to the web interface
  2. I start the upgrade
  3. I get the error so I posted the LOG

Expected behaviour

upgrade to 9.1.3

Actual behaviour

start upgrade from 9 to 9.1 but there’s an error

Server configuration

Operating system:

Web server:
Server version: Apache/2.4.18 (Ubuntu)
Server built: 2018-04-18T14:53:04

Database:
mysql Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using EditLine wrapper

PHP version:
PHP 7.0.30-0ubuntu0.16.04.1 (cli) ( NTS )
Copyright © 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright © 1998-2017 Zend Technologies
with Zend OPcache v7.0.30-0ubuntu0.16.04.1, Copyright © 1999-2017, by Zend Technologies

ownCloud version: (see ownCloud admin page)
from 9.0.0.19 to 9.1.3

Updated from an older ownCloud or fresh install:
OLDER working 9 version

Where did you install ownCloud from:
I downloaded from official SITE

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

The content of config/config.php:

ownCloud 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
{
    "system": {
        "updatechecker": false,
        "instanceid": "oc1bwbaqbk1w",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "172.22.16.158",
            "217.221.77.166",
            "cloud.europe-app.com",
            "cloud",
            "cloud.europe.local"
        ],
        "datadirectory": "\/New_Data",
        "overwrite.cli.url": "http:\/\/localhost\/owncloud",
        "dbtype": "mysql",
        "version": "9.0.0.19",
        "dbname": "oc",
        "dbhost": "localhost",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "logtimezone": "Europe\\Rome",
        "installed": true,
        "appstore.experimental.enabled": false,
        "mail_smtpmode": "smtp",
        "skeletondirectory": "",
        "theme": "",
        "default_language": "en",
        "mail_smtphost": "172.22.16.9",
        "mail_from_address": "owncloud",
        "mail_domain": "europe-app.com",
        "singleuser": false,
        "maintenance": true,
        "loglevel": 0
    }
}

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.
ownCloud 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
Enabled:
  - activity: 2.2.1
  - comments: 0.2
  - dav: 0.1.5
  - federatedfilesharing: 0.3.0
  - federation: 0.0.4
  - files: 1.4.4
  - files_antivirus: 0.8.0.1
  - files_external: 0.5.2
  - files_pdfviewer: 0.8.1
  - files_sharing: 0.9.1
  - files_texteditor: 2.1
  - files_trashbin: 0.8.0
  - files_versions: 1.2.0
  - files_videoplayer: 0.9.8
  - firstrunwizard: 1.1
  - gallery: 15.0.0
  - notifications: 0.2.3
  - provisioning_api: 0.5.0
  - systemtags: 0.2
  - templateeditor: 0.1
  - updatenotification: 0.2.1
Disabled:
  - configreport
  - encryption
  - external
  - user_external
  - user_ldap

Are you using external storage, if yes which one:
NO

Are you using encryption:
NO

Are you using an external user-backend, if yes which one:
NO

LDAP configuration (delete this part if not used)

no LDAP


### Client configuration
**Browser:**
Opera

**Operating system:**
Ubuntu 16.04.4 LTS (GNU/Linux 3.13.0-79-generic x86_64)

### Logs
#### Web server error log

[Thu Jun 28 10:34:23.995420 2018] [core:notice] [pid 25750] AH00094: Command line: ‘/usr/sbin/apache2’
[Thu Jun 28 10:34:43.319012 2018] [mpm_prefork:notice] [pid 25750] AH00169: caught SIGTERM, shutting down
[Thu Jun 28 10:34:53.304236 2018] [mpm_prefork:notice] [pid 25835] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured – resuming normal operations
[Thu Jun 28 10:34:53.304259 2018] [core:notice] [pid 25835] AH00094: Command line: ‘/usr/sbin/apache2’
[Thu Jun 28 10:39:39.423344 2018] [mpm_prefork:notice] [pid 25835] AH00169: caught SIGTERM, shutting down
[Thu Jun 28 10:39:40.529016 2018] [mpm_prefork:notice] [pid 25958] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured – resuming normal operations
[Thu Jun 28 10:39:40.529042 2018] [core:notice] [pid 25958] AH00094: Command line: ‘/usr/sbin/apache2’
[Thu Jun 28 10:40:15.832708 2018] [mpm_prefork:notice] [pid 25958] AH00169: caught SIGTERM, shutting down
[Thu Jun 28 10:40:16.941363 2018] [mpm_prefork:notice] [pid 26013] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured – resuming normal operations
[Thu Jun 28 10:40:16.941391 2018] [core:notice] [pid 26013] AH00094: Command line: ‘/usr/sbin/apache2’
[Thu Jun 28 10:40:45.376609 2018] [mpm_prefork:notice] [pid 26013] AH00169: caught SIGTERM, shutting down
[Thu Jun 28 10:40:46.422439 2018] [mpm_prefork:notice] [pid 26070] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured – resuming normal operations
[Thu Jun 28 10:40:46.422463 2018] [core:notice] [pid 26070] AH00094: Command line: ‘/usr/sbin/apache2’
[Thu Jun 28 11:20:18.217207 2018] [mpm_prefork:notice] [pid 26070] AH00169: caught SIGTERM, shutting down
[Thu Jun 28 11:20:19.274736 2018] [mpm_prefork:notice] [pid 27039] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured – resuming normal operations
[Thu Jun 28 11:20:19.274761 2018] [core:notice] [pid 27039] AH00094: Command line: ‘/usr/sbin/apache2’
[Thu Jun 28 12:13:33.290545 2018] [mpm_prefork:notice] [pid 27039] AH00169: caught SIGTERM, shutting down
[Thu Jun 28 12:13:34.347856 2018] [mpm_prefork:notice] [pid 29488] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured – resuming normal operations
[Thu Jun 28 12:13:34.347878 2018] [core:notice] [pid 29488] AH00094: Command line: ‘/usr/sbin/apache2’
[Thu Jun 28 12:22:54.488898 2018] [mpm_prefork:notice] [pid 29488] AH00169: caught SIGTERM, shutting down
[Thu Jun 28 12:22:55.547307 2018] [mpm_prefork:notice] [pid 29609] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured – resuming normal operations
[Thu Jun 28 12:22:55.547328 2018] [core:notice] [pid 29609] AH00094: Command line: ‘/usr/sbin/apache2’
[Thu Jun 28 12:34:47.891463 2018] [mpm_prefork:notice] [pid 29609] AH00169: caught SIGTERM, shutting down
[Thu Jun 28 12:34:48.955942 2018] [mpm_prefork:notice] [pid 30165] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured – resuming normal operations
[Thu Jun 28 12:34:48.955967 2018] [core:notice] [pid 30165] AH00094: Command line: ‘/usr/sbin/apache2’
[Thu Jun 28 12:36:44.884140 2018] [mpm_prefork:notice] [pid 30165] AH00169: caught SIGTERM, shutting down
[Thu Jun 28 12:36:45.933811 2018] [mpm_prefork:notice] [pid 30248] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured – resuming normal operations
[Thu Jun 28 12:36:45.933831 2018] [core:notice] [pid 30248] AH00094: Command line: ‘/usr/sbin/apache2’


#### ownCloud log (data/owncloud.log)

Preparing update
Set log level to debug
Turned on maintenance mode
Checking whether the database schema can be updated (this can take a long time depending on the database size)
[1 / 24]: Checking table oc_appconfig
[2 / 24]: Checking table oc_storages
[3 / 24]: Checking table oc_mounts
[4 / 24]: Checking table oc_mimetypes
[5 / 24]: Checking table oc_filecache
[6 / 24]: Checking table oc_group_user
[7 / 24]: Checking table oc_group_admin
[8 / 24]: Checking table oc_groups
[9 / 24]: Checking table oc_preferences
[10 / 24]: Checking table oc_properties
[11 / 24]: Checking table oc_share
[12 / 24]: Checking table oc_jobs
[13 / 24]: Checking table oc_users
[14 / 24]: Checking table oc_authtoken
[15 / 24]: Checking table oc_vcategory
[16 / 24]: Checking table oc_vcategory_to_object
[17 / 24]: Checking table oc_systemtag
[18 / 24]: Checking table oc_systemtag_object_mapping
[19 / 24]: Checking table oc_systemtag_group
[20 / 24]: Checking table oc_privatedata
[21 / 24]: Checking table oc_file_locks
[22 / 24]: Checking table oc_comments
[23 / 24]: Checking table oc_comments_read_markers
[24 / 24]: Checking table oc_credentials
Checked database schema update
Checking updates of apps
Checking whether the database schema for activity can be updated (this can take a long time depending on the database size)
[1 / 2]: Checking table oc_activity
[2 / 2]: Checking table oc_activity_mq
Checking whether the database schema for dav can be updated (this can take a long time depending on the database size)
[1 / 10]: Checking table oc_addressbooks
[2 / 10]: Checking table oc_cards
[3 / 10]: Checking table oc_addressbookchanges
[4 / 10]: Checking table oc_calendarobjects
[5 / 10]: Checking table oc_calendars
[6 / 10]: Checking table oc_calendarchanges
[7 / 10]: Checking table oc_calendarsubscriptions
[8 / 10]: Checking table oc_schedulingobjects
[9 / 10]: Checking table oc_cards_properties
[10 / 10]: Checking table oc_dav_shares
Checking whether the database schema for federation can be updated (this can take a long time depending on the database size)
[1 / 1]: Checking table oc_trusted_servers
Checking whether the database schema for files_antivirus can be updated (this can take a long time depending on the database size)
[1 / 2]: Checking table oc_files_antivirus
[2 / 2]: Checking table oc_files_avir_status
Checking whether the database schema for files_external can be updated (this can take a long time depending on the database size)
[1 / 4]: Checking table oc_external_mounts
[2 / 4]: Checking table oc_external_applicable
[3 / 4]: Checking table oc_external_config
[4 / 4]: Checking table oc_external_options
Checking whether the database schema for files_sharing can be updated (this can take a long time depending on the database size)
[1 / 1]: Checking table oc_share_external
Checking whether the database schema for files_trashbin can be updated (this can take a long time depending on the database size)
[1 / 1]: Checking table oc_files_trash
Checking whether the database schema for notifications can be updated (this can take a long time depending on the database size)
[1 / 1]: Checking table oc_notifications
Checked database schema update for apps
Updating database schema
Updated database
An error occurred.


#2

I’m not sure if you have chosen the correct upgrade path. From what i have read in the past you could either do this one:

9.0.0 to 9.0.11, then to 9.1.8 and finally to 10.0.8

or you could try to upgrade directly from 9.0.0 to 10.0.8 (not sure if this works at all). Personally i would prefer the first one but i havn’t that much experiences with such outdated installations like 9.0.0