Bug#757549: owncloud: DB-Errors on Migration 6.0.3 to 7.0.0
Hi Tom, - Original message - > Hi, > > On 09/08/14 22:45, Jan Wagner wrote: > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 > > > > Hi David, > > > > Am 09.08.14 14:04, schrieb David Prévot: > > > Le 09/08/2014 02:12, Tom Fernandes a écrit : > > > > Package: owncloud Version: 7.0.0+dfsg-2~bpo70+2 > > > > > > “Please report bugs that you found in the packages to the > > > backports mailinglist[1] and NOT to the Debian BTS!”[2] > > > > > > 1: http://lists.debian.org/debian-backports/ 2: > > > http://backports.debian.org/Instructions/#index6h2 > > okay - thanks for the information - I wasn't aware of that. I just > posted my issue there. > > > > > > > […] > > > > 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? > > > > as this is a general question, I think the package maintainer could > > even answer this question (much more better then the backporter), even > > if this problem should have been raised on the backports mailing list. > > > > Just my 2 cents, Jan. > > well yes. In case one of the maintainers knows about this question, I'd > be greatfull to here about it. > > warm regards, > > > Tom 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). But the version in wheezy-bpo is the same as in unstable (atm). On my production instance I encountered several DB upgrade issues with PgSQL as backend. All of them I found discussed upstream on the Github issue tracker of owncloud. Regards Mike (the wheezy-bpo maintainer of oc) -- DAS-NETZWERKTEAM mike gabriel, herweg 7, 24357 fleckeby fon: +49 (1520) 1976148 GnuPG Key ID 0x25771B13 mail: mike.gabr...@das-netzwerkteam.de, http://das-netzwerkteam.de -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#757549: owncloud: DB-Errors on Migration 6.0.3 to 7.0.0
Hi, On 09/08/14 22:45, Jan Wagner wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi David, Am 09.08.14 14:04, schrieb David Prévot: Le 09/08/2014 02:12, Tom Fernandes a écrit : Package: owncloud Version: 7.0.0+dfsg-2~bpo70+2 “Please report bugs that you found in the packages to the backports mailinglist[1] and NOT to the Debian BTS!”[2] 1: http://lists.debian.org/debian-backports/ 2: http://backports.debian.org/Instructions/#index6h2 okay - thanks for the information - I wasn't aware of that. I just posted my issue there. […] 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? as this is a general question, I think the package maintainer could even answer this question (much more better then the backporter), even if this problem should have been raised on the backports mailing list. Just my 2 cents, Jan. well yes. In case one of the maintainers knows about this question, I'd be greatfull to here about it. warm regards, Tom -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#757549: owncloud: DB-Errors on Migration 6.0.3 to 7.0.0
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi David, Am 09.08.14 14:04, schrieb David Prévot: > Le 09/08/2014 02:12, Tom Fernandes a écrit : >> Package: owncloud Version: 7.0.0+dfsg-2~bpo70+2 > > “Please report bugs that you found in the packages to the > backports mailinglist[1] and NOT to the Debian BTS!”[2] > > 1: http://lists.debian.org/debian-backports/ 2: > http://backports.debian.org/Instructions/#index6h2 > > […] >> 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? as this is a general question, I think the package maintainer could even answer this question (much more better then the backporter), even if this problem should have been raised on the backports mailing list. Just my 2 cents, Jan. - -- Never write mail to , you have been warned! - -BEGIN GEEK CODE BLOCK- Version: 3.12 GIT d-- s+: a C+++ UL P+ L+++ E--- W+++ N+++ o++ K++ w--- O M V- PS PE Y++ PGP++ t-- 5 X R tv- b+ DI D+ G++ e++ h r+++ y - --END GEEK CODE BLOCK-- -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (Darwin) Comment: GPGTools - http://gpgtools.org iQIcBAEBAgAGBQJT5ohzAAoJEAxwVXtaBlE+gzYQAJLwdoqqF+iOlnuj1iX1ct0H TKt7t6XLnmh/4RuFhNQwMuLNK8SYHGNwDk3pVOIhpOSdMHHAZ8GaIIJNiLUH5kxk 446N4hlFbvGwSrkAAicdBBMQlTkQ9vyYW25HTfqv6lAgWfy1vPdLo+tRCNBBxXq5 AeWpQ4l3Gi94O3MhiMsLBYXfTgSUExCI4KGee84WzR0T69noHKiKudbHnj+JPuuN DUAXLDf2eYamGf2cacJEahWp5YkKgl/kdSy6wudTwAvA1aH7Se/73riOWF829mIw G4OChxHeYrAFnWkLIkGicsSLH96SojQQWgaUBW8E2IVe9bqGr1yCliSqK9XY4wFo uCpyrp0Oo6Ivr0M4m6wcW+/fdne2BU6LLGYCy4plSLaBwHZwUqDRM/r6kiN0nl3Z 2ur/6PxNBkPsADzz0+jBpT4fuYI0Xnngeg0gdFS6VmvYE+0lQGew+qOjzRhhoxkT 105GMyR4SaBlvV+AJCXTw/dAmaNNSWrIRwUqrdO/N6EsU8EIc+nUlhOR79t+o3Nh xN9h+YwjoG5oS3lASrrkr9k5Ge8F1Fni0aeOm6jqhkqFSnGMdzIk9NKtLd2HjPSK LWGjBI0RMpKyXZOLzZnfMFS6i6/JEl7kbzGJbTdwO/1HDdbfVTlkZcEeMDksIXU7 ZyJRNEK2ZX7ETUFLubof =rDXW -END PGP SIGNATURE- -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#757549: owncloud: DB-Errors on Migration 6.0.3 to 7.0.0
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Hi Tom, Thanks for your interest in the backported owncloud package. Le 09/08/2014 02:12, Tom Fernandes a écrit : > Package: owncloud > Version: 7.0.0+dfsg-2~bpo70+2 “Please report bugs that you found in the packages to the backports mailinglist[1] and NOT to the Debian BTS!”[2] 1: http://lists.debian.org/debian-backports/ 2: http://backports.debian.org/Instructions/#index6h2 > 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. […] > 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? Regards David -BEGIN PGP SIGNATURE- Version: GnuPG v1 iQEcBAEBCAAGBQJT5g5WAAoJEAWMHPlE9r08KCgH/RF2qrfLJPmd3m1k+2/J9cRj wDjeTyKTNnCnm7hZ2kCreWoKqlg9XXz9N/MUPC1ZvbjwWhbm2NmubwpJYX8L6IVw fSfJbg4D+d3IqMByuWuLmyNJGE8ye07C1dX1spG7CQMNU4y82Nyr/A5qELasMkZh QFRzY2X93qLw0GFR4G4rEuuuIumfSXnoz6I12olzG6twTvpsEv0Opq6IsVGkBrkA 81zNML77n5yXklR9JQqK7GMefdz45TQixWrzXKbUWqSNpdualyJYmRsMvV6YCUi9 gyRVwiux2Gm1fuxxx6pPmZzEXnuA7Qx1xg0Cfsul8iJXRLxw8ffXlHYu1IbjZnQ= =jNZd -END PGP SIGNATURE- -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Bug#757549: owncloud: DB-Errors on Migration 6.0.3 to 7.0.0
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
