Your message dated Sun, 17 Aug 2014 15:41:06 -0400
with message-id <[email protected]>
and subject line Re: Bug#757549: owncloud: DB-Errors on Migration 6.0.3 to 7.0.0
has caused the Debian Bug report #757549,
regarding owncloud: DB-Errors on Migration 6.0.3 to 7.0.0
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
757549: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=757549
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: owncloud
Version: 7.0.0+dfsg-2~bpo70+2
Severity: normal
Dear Maintainer,
I upgraded OC from 6.0.3+dfsg-2~bpo70+1 to 7.0.0+dfsg-2~bpo70+2 and then
went to my OC-website. I was prompted for clicking to run the update,
which I did. Then it said there was an error and that I should report
this to the community.
The postgres-log says:
ERROR: relation "oc_share_external" already exists
STATEMENT: CREATE TABLE "oc_share_external" ("id" SERIAL NOT NULL,
"remote" VARCHAR(512) NOT NULL, "share_token" VARCHAR(64) NOT NULL,
"password" VARCHAR(64) NOT NULL, "name" VARCHAR(64) NOT NULL, "owner"
VARCHAR(64) NOT NULL, "user" VARCHAR(64) NOT NULL, "mountpoint"
VARCHAR(4000) NOT NULL, "mountpoint_hash" VARCHAR(32) NOT NULL, PRIMARY
KEY("id"))
The OC-log reports:
ailed to update database structure (exception 'PDOException' with
message 'SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation
"oc_share_external" already exists' in
/usr/share/php/Doctrine/DBAL/Connection.php:801 Stack trace: #0
/usr/share/php/Doctrine/DBAL/Connection.php(801): PDO->query('CREATE
TABLE "o...') #1 /usr/share/owncloud/lib/private/db/migrator.php(179):
Doctrine\DBAL\Connection->query('CREATE TABLE "o...') #2
/usr/share/owncloud/lib/private/db/migrator.php(35):
OC\DB\Migrator->applySchema(Object(Doctrine\DBAL\Schema\Schema)) #3
/usr/share/owncloud/lib/private/db/mdb2schemamanager.php(98):
OC\DB\Migrator->migrate(Object(Doctrine\DBAL\Schema\Schema)) #4
/usr/share/owncloud/lib/private/db.php(320):
OC\DB\MDB2SchemaManager->updateDbFromStructure('/usr/share/ownc...') #5
/usr/share/owncloud/lib/private/app.php(1172):
OC_DB::updateDbFromStructure('/usr/share/ownc...') #6
/usr/share/owncloud/lib/private/app.php(980):
OC_App::updateApp('files_sharing') #7
/usr/share/owncloud/lib/private/app.php(87):
OC_App::checkUpgrade('files_sharing') #8
/usr/share/owncloud/lib/private/app.php(72):
OC_App::loadApp('files_sharing') #9
/usr/share/owncloud/lib/private/updater.php(222): OC_App::loadApps() #10
/usr/share/owncloud/lib/private/updater.php(137):
OC\Updater->doUpgrade('7.0.0.8', '6.0.3.1') #11
/usr/share/owncloud/core/ajax/update.php(35): OC\Updater->upgrade() #12
{main} Next exception 'Doctrine\DBAL\DBALException' with message 'An
exception occurred while executing 'CREATE TABLE "oc_share_external"
("id" SERIAL NOT NULL, "remote" VARCHAR(512) NOT NULL, "share_token"
VARCHAR(64) NOT NULL, "password" VARCHAR(64) NOT NULL, "name"
VARCHAR(64) NOT NULL, "owner" VARCHAR(64) NOT NULL, "user" VARCHAR(64)
NOT NULL, "mountpoint" VARCHAR(4000) NOT NULL, "mountpoint_hash"
VARCHAR(32) NOT NULL, PRIMARY KEY("id"))': SQLSTATE[42P07]: Duplicate
table: 7 ERROR: relation "oc_share_external" already exists' in
/usr/share/php/Doctrine/DBAL/DBALException.php:91 Stack trace: #0
/usr/share/php/Doctrine/DBAL/Connection.php(811):
Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException),
'CREATE TABLE "o...') #1
/usr/share/owncloud/lib/private/db/migrator.php(179):
Doctrine\DBAL\Connection->query('CREATE TABLE "o...') #2
/usr/share/owncloud/lib/private/db/migrator.php(35):
OC\DB\Migrator->applySchema(Object(Doctrine\DBAL\Schema\Schema)) #3
/usr/share/owncloud/lib/private/db/mdb2schemamanager.php(98):
OC\DB\Migrator->migrate(Object(Doctrine\DBAL\Schema\Schema)) #4
/usr/share/owncloud/lib/private/db.php(320):
OC\DB\MDB2SchemaManager->updateDbFromStructure('/usr/share/ownc...') #5
/usr/share/owncloud/lib/private/app.php(1172):
OC_DB::updateDbFromStructure('/usr/share/ownc...') #6
/usr/share/owncloud/lib/private/app.php(980):
OC_App::updateApp('files_sharing') #7
/usr/share/owncloud/lib/private/app.php(87):
OC_App::checkUpgrade('files_sharing') #8
/usr/share/owncloud/lib/private/app.php(72):
OC_App::loadApp('files_sharing') #9
/usr/share/owncloud/lib/private/updater.php(222): OC_App::loadApps() #10
/usr/share/owncloud/lib/private/updater.php(137):
OC\Updater->doUpgrade('7.0.0.8', '6.0.3.1') #11
/usr/share/owncloud/core/ajax/update.php(35): OC\Updater->upgrade() #12
{main})
My OC-instance seems to work fine, but I feel uneasy if the DB-migration
executed fine in the end.
I did not find a way to re-run the upgrade or to verify the status of
the system.
Is there a way to check if the upgrade/migration worked correctly?
Warm regards and thanks for the good work,
Tom
-- System Information:
Debian Release: 7.6
APT prefers stable
APT policy: (990, 'stable'), (500, 'stable-updates'), (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 3.2.0-4-amd64 (SMP w/1 CPU core)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages owncloud depends on:
ii fonts-font-awesome 3.2.1~dfsg-2~bpo7+1
ii fonts-liberation 1.07.2-6
ii fonts-linuxlibertine 5.1.3-1
ii fonts-lohit-deva 2.5.1-1
ii fonts-sil-gentium-basic 1.1-5
ii fonts-wqy-microhei 0.2.0-beta-2~bpo70+1
ii libjs-chosen 0.9.11-1~bpo7+1
ii libjs-dojo-dojox 1.7.2+dfsg-1
ii libjs-jcrop 0.9.12+dfsg-1~bpo70+1
ii libjs-jquery-minicolors 1.2.1-1~bpo7+1
ii libjs-jquery-mousewheel 6-1
ii libjs-jquery-timepicker 1.2-1~bpo70+1
ii libjs-pdf 1.0.473+dfsg-1~bpo70+1
ii libphp-phpmailer 5.1-1
ii nginx-extras [httpd] 1.6.0-1~bpo70+1
ii owncloud-doc 0~20140428-1~bpo70+1
ii php-assetic 1.1.2-1~bpo70+1
ii php-doctrine-dbal 2.4.2-3~bpo70+1
ii php-getid3 1.9.7-2~bpo70+1
ii php-opencloud 1.10.0-2
ii php-patchwork-utf8 1.1.7-1~bpo70+1
ii php-pear 5.4.4-14+deb7u12
ii php-pimple 1.1.1-1~bpo70+1
ii php-sabre-dav 1.8.10-1~bpo70+1
ii php-seclib 0.3.5-2~bpo70+1
ii php-symfony-classloader 2.3.6-1~bpo70+1
ii php-symfony-console 2.3.1+dfsg-1~bpo70+1
ii php-symfony-routing 2.0.19-1~bpo70+1
ii php5 5.4.4-14+deb7u12
ii php5-common [php5-json] 5.4.4-14+deb7u12
ii php5-gd 5.4.4-14+deb7u12
ii php5-pgsql 5.4.4-14+deb7u12
ii zendframework 1.11.13-1.1
Versions of packages owncloud recommends:
ii libav-tools 6:10.1-1~bpo70+1
ii libreoffice 1:4.2.5-1~bpo70+1
ii php-aws-sdk 2.6.0-1~bpo70+1
ii php-crypt-blowfish 1.1.0~RC2-3~bpo70+1
ii php-dropbox 1.0.0-1~bpo70+1
ii php-google-api-php-client 0.6.2-1~bpo70+1
ii php5-cli 5.4.4-14+deb7u12
ii php5-curl 5.4.4-14+deb7u12
ii php5-imagick 3.1.0~rc1-1+b2
ii php5-intl 5.4.4-14+deb7u12
ii php5-ldap 5.4.4-14+deb7u12
ii php5-mcrypt 5.4.4-14+deb7u12
ii php5-xcache 2.0.0-4
ii postfix [mail-transport-agent] 2.9.6-2
ii smbclient 2:4.1.9+dfsg-1~bpo70+1
Versions of packages owncloud suggests:
pn libapache2-mod-xsendfile <none>
ii postgresql 9.1+134wheezy4
-- Configuration Files:
/etc/owncloud/htaccess [Errno 13] Permission denied: u'/etc/owncloud/htaccess'
-- no debconf information
--- End Message ---
--- Begin Message ---
Hi,
On Wed, Aug 13, 2014 at 11:53:35AM +0200, Mike Gabriel wrote:
> > On 09/08/14 22:45, Jan Wagner wrote:
> > > > Le 09/08/2014 02:12, Tom Fernandes a écrit :
> > > > > Package: owncloud Version: 7.0.0+dfsg-2~bpo70+2
> > > > > My OC-instance seems to work fine
Not sure it’s worth keeping an open bug about it then.
> > > Just my 2 cents, Jan.
Some people may keep their money for themselve instead of offering
obvious comments.
> IMHO all DB upgrade issues in owncloud can be burned down to upstream or
> system-specific issues.
>
> However, there also is a php package that received much input from owncloud
> upstream (php-doctrine-dbal IIRC).
php-doctrine-dbal is indeed a fair counter-example of the previous
statement (a PostgreSQL fix had been applied more than a month ago, and
another MySQL one has just been applied). pdf.js also includes ownCloud-
specific patches
> But the version in wheezy-bpo is the same as in unstable (atm).
Right (i.e., at the time of your writing), but #756658 has just been
fixed in php-doctrine-dbal/2.4.2-4, thus keeping you and backports on
the loop so you may also get it fixed in a timely manner.
Regards
David
signature.asc
Description: Digital signature
--- End Message ---
