owncloud: DB-Errors on migrating from 6.0.3 to 7.0.0
Hi,
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
PS. I already posted my issue in the BTS (#757549) but was adviced to
rather report it here.
Reply to: