Error during upgrade

lennard · October 13, 2016, 2:07pm

Hi,

I upgraded from version 9.0.53 (from top of my head) to 10.0.1
I am not experiencing any issues. I have the same error as below during all my (minor) updates also. Note that I originally moved from Owncloud.

$ php ./occ 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
Checking whether the database schema can be updated (this can take a long time depending on the database size)
 Done
 27/27 [============================] 100%
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)
 Done
 2/2 [============================] 100%
Checking whether the database schema for <federatedfilesharing> can be updated (this can take a long time depending on the database size)
 Done
 1/1 [============================] 100%
Checking whether the database schema for <files_sharing> can be updated (this can take a long time depending on the database size)
 Done
 1/1 [============================] 100%
Checking whether the database schema for <files_trashbin> can be updated (this can take a long time depending on the database size)
 Done
 1/1 [============================] 100%
Checked database schema update for apps
Updating database schema
Updated database
Updating <federatedfilesharing> ...
Updated <federatedfilesharing> to 1.0.1
Updating <updatenotification> ...
Updated <updatenotification> to 1.0.1
Updating <files> ...
Updated <files> to 1.5.2
Updating <activity> ...
Updated <activity> to 2.3.2
Updating <encryption> ...
Updated <encryption> to 1.3.1
Updating <files_sharing> ...
Updated <files_sharing> to 1.0.0
Updating <files_trashbin> ...
Updated <files_trashbin> to 1.0.0
Updating <files_versions> ...
Updated <files_versions> to 1.3.0
Updating <comments> ...
Updated <comments> to 1.0.0
Updating <systemtags> ...
Updated <systemtags> to 1.0.2
dav: An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VARCHAR(255) DEFAULT NULL, `displayname` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressbook_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists
notifications: An exception occurred while executing 'CREATE TABLE `oc_notifications` (`notification_id` INT AUTO_INCREMENT NOT NULL, `app` VARCHAR(32) NOT NULL, `user` VARCHAR(64) NOT NULL, `timestamp` INT DEFAULT 0 NOT NULL, `object_type` VARCHAR(64) NOT NULL, `object_id` VARCHAR(64) NOT NULL, `subject` VARCHAR(64) NOT NULL, `subject_parameters` LONGTEXT DEFAULT NULL, `message` VARCHAR(64) DEFAULT NULL, `message_parameters` LONGTEXT DEFAULT NULL, `link` VARCHAR(4000) DEFAULT NULL, `actions` LONGTEXT DEFAULT NULL, INDEX oc_notifications_app (`app`), INDEX oc_notifications_user (`user`), INDEX oc_notifications_timestamp (`timestamp`), INDEX oc_notifications_object (`object_type`, `object_id`), PRIMARY KEY(`notification_id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_notifications' already exists
federation: An exception occurred while executing 'CREATE TABLE `oc_trusted_servers` (`id` INT AUTO_INCREMENT NOT NULL, `url` VARCHAR(512) NOT NULL COMMENT 'Url of trusted server', `url_hash` VARCHAR(255) DEFAULT '' NOT NULL COMMENT 'sha1 hash of the url without the protocol', `token` VARCHAR(128) DEFAULT NULL COMMENT 'token used to exchange the shared secret', `shared_secret` VARCHAR(256) DEFAULT NULL COMMENT 'shared secret used to authenticate', `status` INT DEFAULT 2 NOT NULL COMMENT 'current status of the connection', `sync_token` VARCHAR(512) DEFAULT NULL COMMENT 'cardDav sync token', UNIQUE INDEX url_hash (`url_hash`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_trusted_servers' already exists
Drop old database tables
 Done
 31/31 [============================] 100%
Remove old (< 9.0) calendar/contact shares
 Done
 4/4 [============================] 100%
Fix permissions so avatars can be stored again
 Done
 2/2 [============================] 100%
Repair unmerged shares
 Done
 3/3 [============================] 100%
Starting code integrity check...
Finished code integrity check
Update successful
Turned off maintenance mode
Reset log level

tflidd · October 13, 2016, 9:17pm

You had this problem already during the last update:

And there was an issue in owncloud that was fixed:

github.com/owncloud/core

Owncloud 8.2.2 manual upgrade to version 9.0.0 fails

opened 08:44PM - 08 Mar 16 UTC

closed 07:01PM - 06 Apr 16 UTC

samuelstein

Type:Bug db:mysql sev2-high app:dav

### Steps to reproduce 1. Owncloud 8.2.2 with addressbook needs to be installed …2. Manual upgrade installation to 9.0.0 (See: https://doc.owncloud.org/server/9.0/admin_manual/maintenance/manual_upgrade.html) 3. Open index.php ### Expected behaviour Owncloud and apps should be upgraded ### Actual behaviour owncloud.log shows following error: ``` json { "reqId": "wQzVLIALlhFjT6ci8uiC", "remoteAddr": "10.30.7.137", "app": "core", "message": "Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\DriverException\",\"Message\":\"An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VARCHAR(255) DEFAULT NULL, `displayname` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressbook_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':\\n\\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes\",\"Code\":0,\"Trace\":\"#0 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/DBALException.php(116): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Connection.php(945): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOMySql\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'CREATE TABLE `o...')\\n#2 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/db\\/mdb2schemamanager.php(167): Doctrine\\\\DBAL\\\\Connection->query('CREATE TABLE `o...')\\n#3 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/db\\/mdb2schemamanager.php(70): OC\\\\DB\\\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\\\DBAL\\\\Schema\\\\Schema))\\n#4 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/db.php(172): OC\\\\DB\\\\MDB2SchemaManager->createDbFromStructure('\\/is\\/htdocs\\/wp10...')\\n#5 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/installer.php(567): OC_DB::createDbFromStructure('\\/is\\/htdocs\\/wp10...')\\n#6 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/installer.php(546): OC_Installer::installShippedApp('dav')\\n#7 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/updater.php(336): OC_Installer::installShippedApps()\\n#8 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/lib\\/private\\/updater.php(215): OC\\\\Updater->doUpgrade('9.0.0.19', '8.2.2.2')\\n#9 \\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/core\\/ajax\\/update.php(120): OC\\\\Updater->upgrade()\\n#10 {main}\",\"File\":\"\\/is\\/htdocs\\/wp10838123_LGOL2QNNTD\\/www\\/samuelstein.de\\/owncloud\\/3rdparty\\/doctrine\\/dbal\\/lib\\/Doctrine\\/DBAL\\/Driver\\/AbstractMySQLDriver.php\",\"Line\":115}", "level": 3, "time": "2016-03-08T20:07:11+00:00", "method": "GET", "url": "/core/ajax/update.php?requesttoken=WRxtLlhgIlocD3IGPCssBj0sXBgyNhgkUSQrXz0c%3Ak%2F%2BM75thUXA1tOtseI0BTYBEfgj6ZjBRLS9nXn8d" } ``` ### Server configuration **Operating system**: shared space at hosteurope **Web server:** apache **Database:** mysql **PHP version:** latest 5 Login as admin user into your ownCloud and access http://example.com/index.php/settings/integrity/failed paste the results here: ``` `ownCloud wird auf Version 9.0.0 aktualisiert. Das könnte eine Weile dauern. Update vorbereiten Log-Level auf "debug" gesetzt Wartungsmodus eingeschaltet Prüft, ob das Datenbankschema aktualisiert werden kann (dies kann je nach Datenbankgröße sehr lange dauern) Datenbankschema-Aktualisierung überprüft Es wird nach Updates für die Apps gesucht Datenbankschema-Aktualisierung für Apps überprüft Das Datenbankschema wird aktualisiert Datenbank aktualisiert Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VARCHAR(255) DEFAULT NULL, `displayname` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressbook_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes` ``` **List of activated apps:** **Are you using external storage:** no **Are you using encryption:** no **Are you using an external user-backend:** no ### Client configuration **Browser:** 48.0.2564.116 m (64-bit) **Operating system:** windows 7 #### Browser log Insert your browser log here, this could for example include: a) The javascript console log: 'https://ssl.webpack.de/cloud.samuelstein.de/core/js/oc.js?v=d78eff885055a5dff1258825d52763d5 Failed to load resource: the server responded with a status of 500 (Internal Server Error)'

@nickvergessen what can the user do to avoid this error in the future?

nickvergessen · October 14, 2016, 7:01am

The problem

Base table or view already exists

was not fixed yet. We still lack a way to reproduce this.

sualko · February 10, 2017, 1:38pm

I am currently facing the same error message, after updating an other app. After the update I got a message like “failed to enable app dav”. If I run ./occ app:enable dav, I get the following output:

[OC\HintException]        
  Failed to enable app dav  
                            

                                                                                                                                                                               
  [Doctrine\DBAL\Exception\TableExistsException]                                                                                                                               
  An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VARCHAR(255) DEFAULT NULL, `displayname  
  ` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressboo  
  k_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':                                                            
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists                                                                              
                                                                                                                                                                               

                                                                                                   
  [Doctrine\DBAL\Driver\PDOException]                                                              
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists  
                                                                                                   

                                                                                                   
  [PDOException]                                                                                   
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists

NC 10.0.3

What can I do to help you?

tobias_zellner · May 10, 2017, 8:00pm

Hello,

did someone already find a solution for this?
I have the same problem here, but I’m on version 11.0.3.

The upgrade showed me some problems, and now I can’t access my calendar any more, no matter if I use a CalDav Client or the Webpage.

When I look into the NC logs, I find some issues about DAV anytime I try to connect the calendar. When I look into the internals I see the following:

    php /var/www/owncloud/occ app:list
       Enabled:
      - activity: 2.4.1
      - admin_audit: 1.1.0
      - audioplayer: 1.5.1
      - calendar: 1.5.2
      - comments: 1.1.0
      - contacts: 1.5.3
      - dav: true
    ...

So DAV seems to be fine. But when I try to enable it anyway this happens:

php /var/www/owncloud/occ app:enable dav

                                                                                                                                           
  [Doctrine\DBAL\Exception\TableExistsException]                                                                                           
  An exception occurred while executing 'CREATE TABLE `oc_addressbooks` (`id` BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, `principaluri` VAR  
  CHAR(255) DEFAULT NULL, `displayname` VARCHAR(255) DEFAULT NULL, `uri` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NU  
  LL, `synctoken` INT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE INDEX addressbook_index (`principaluri`, `uri`), PRIMARY KEY(`id`)) DEFAULT CHA  
  RACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB':                                                                                       
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists                                          
                                                                                                                                           

                                                                                                   
  [Doctrine\DBAL\Driver\PDOException]                                                              
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists  
                                                                                                   

                                                                                                   
  [PDOException]                                                                                   
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oc_addressbooks' already exists  
                                                                                                   

app:enable [-g|--groups GROUPS] [--]

What looks pretty much the same than the messages @sualko sualko got.

So what can I do to get a working DAV and Calendar again?