Debian testing upgrade fails

[jirikeller]

An exception occurred while executing 'ALTER TABLE oc_oc_appconfig_bcdd03d64eb97 DROP PRIMARY KEY': SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'PRIMARY'; check that column/key exists

I believe this is not a duplicate of #9893 as another table is affected.

[karlitschek]

Can you provide a full bugreport as described here please?
https://github.com/owncloud/core/blob/master/CONTRIBUTING.md

[jirikeller]

Steps to reproduce

1. have Debian testing (x86_64) with Owncloud 6 installed
2. apt-get update;apt-get upgrade
3. apt-get install owncloud (it does not upgrade automatically)

Expected behaviour

Upgrade to 7.0.1 ;-)

Actual behaviour

An exception occurred while executing 'ALTER TABLE oc_oc_appconfig_bcdd03d64eb97 DROP PRIMARY KEY': SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'PRIMARY'; check that column/key exists

Server configuration

Operating system: Debian testing 64bit
Web server:: Apache/2.4.10 (Debian)
Database: mysql Ver 14.14 Distrib 5.5.35, for debian-linux-gnu (x86_64) using readline 6.3
PHP version: PHP 5.6.0RC3
ownCloud version: info not available now :-(
Updated from an older ownCloud or fresh install: update (see above
List of activated apps: calendar, todo, presentation (as far as I remember, I am not able to use OC now)
The content of config/config.php:

<?php
$CONFIG = array (
  'instanceid' => '52e6606981aac',
  'passwordsalt' => 'XXXXXXXXXXX',
  'datadirectory' => '/usr/share/owncloud/data',
  'dbtype' => 'mysql',
  'version' => '5.0.28',
  'appstoreenabled' => false,
  'apps_paths' => 
  array (
    0 => 
    array (
      'path' => '/usr/share/owncloud/apps',
      'url' => '/apps',
      'writable' => false,
    ),
  ),
  'dbname' => 'owncloud',
  'dbhost' => 'localhost',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'XXXXXX',
  'dbpassword' => 'XXXXXX',
  'installed' => true,
  'theme' => '',
  'maintenance' => false,
  'trusted_domains' => 
  array (
    0 => 'myDomain.tld',
  ),
);

Are you using external storage, if yes which one: local storage
Are you using encryption: no

Client configuration

not important

Logs

Web server error log

no errors in the web server log

ownCloud log (data/owncloud.log)

ownCloud.log file not present

[LukasReschke]

1. Your config indicates that you're running 5.0.28 instead of stable6. Please double-check.
2. From which repository do you have the ownCloud package?

[jirikeller]

1. ouch, you are unfortunately right, I overlooked it and now I found it in my log, the upgrade was:
   owncloud:amd64 (5.0.14.a+dfsg-1, 7.0.0+dfsg-2)
2. http://ftp.cz.debian.org/debian/ testing/main amd64 Packages - 7.0.1+dfsg-1

So, after lot of pain, I have my 5.0.14 back up and running, fixed the privileges and successfully upgraded to Owncloud 6. Thank, after activating update app, I had to empty a lot of disk space to be able to perform a backup and update to the latest Oc6 and than I'll re-try updating ..

To sum it up, Debian Testing attempted to upgrade OC -> OC 7, which did not work. Downgrading back was pain, but this is moreless Debian-related problem. Please do not close the issue yet, I'll report on 6->7 upgrade as soon as obligatory backup allows me to do so ...

[jirikeller]

Sorry for little OT - is it normal to have in updater:backup following subdirectories during "creating backup" part of update ?

6.0.0.14-6fb18e17/core/data/updater_backup/6.0.0.14-6fb18e17/core/data/updater_backup/6.0.0.14-6fb18e17/core/data/updater_backup/6.0.0.14-6fb18e17/core/data/updater_backup/6.0.0.14-6fb18e17/core/data/updater_backup/6.0.0.14-6fb18e17/core/data/updater_backup/6.0.0.14-6fb18e17

[DavidPrevot]

Hi,

1. ouch, you are unfortunately right, I overlooked it and now I found it in my log, the upgrade was:
   owncloud:amd64 (5.0.14.a+dfsg-1, 7.0.0+dfsg-2)

Then you’re using the Debian proper package, please report such issues in the Debian BTS instead of the upstream issue tracker (you may have been hit by https://bugs.debian.org/cgi-bin/756658 that has been fixed yesterday).

Thank, after activating update app, I had to empty a lot of disk space to be able to perform a backup and update to the latest Oc6 and than I'll re-try updating ..

If you were actually using the Debian proper package, the updater app should be unavailable (since upgrade are supposed to be handle by the package manager), no idea how you ended up with such an unexpected configuration.

Regards

David

[karlitschek]

upgrading directly from 5 to 7 is not supported