Upgrade from ownCloud 5.0.13 to 6.0.0 using PostgreSQL fails #6310

Finn10111 · 2013-12-11T13:24:11Z

Hello,

I am running ownCloud with CentOS 6.5 and PostgreSQL 8.4.18 as database. When trying to upgrade to ownCloud 6.0.0 the update fails with following message:

An exception occurred while executing 'ALTER TABLE "oc_appconfig" DROP CONSTRAINT IF EXISTS appconfig_appid_key_index': SQLSTATE[42601]: Syntax error: 7 FEHLER: Syntaxfehler bei »EXISTS« LINE 1: ALTER TABLE "oc_appconfig" DROP CONSTRAINT IF EXISTS appconf... ^

The text was updated successfully, but these errors were encountered:

Glandos · 2013-12-11T14:26:28Z

I got something similar here:

An exception occurred while executing 'ALTER TABLE "properties" ALTER propertyvalue SET ': SQLSTATE[42601]: Syntax error: 7 ERREUR: erreur de syntaxe à la fin de l'entrée LINE 1: ALTER TABLE "properties" ALTER propertyvalue SET ^

Glandos · 2013-12-11T15:18:12Z

I found the error. Doctrine tries to add a default value when nothing's defined inside the XML schema. Instead of adding 'drop default', it adds '' (empty default) which leads to be an invalid SQL request.

karlitschek · 2013-12-11T15:30:37Z

Thanks for debugging this. @bartv2 Do you have an idea how to fix this?

Glandos · 2013-12-11T15:36:29Z

See owncloud-archive/3rdparty#64

It has fixed the migration problem for me

NEOatNHNG · 2013-12-11T19:22:59Z

The adjusted pull request owncloud-archive/3rdparty#64 (replace empty() with different check for empty string) and the errors in the log go away but the site still hangs in the "Owncloud is updating" page and refreshing does nothing. No other errors in the apache/owncloud/postgres log. CalDAV and such seem to work.

PVince81 · 2013-12-11T20:58:48Z

Do we really want to patch the Doctrine library here ?

DeepDiver1975 · 2013-12-11T21:00:12Z

Do we really want to patch the Doctrine library here ?

NO!

karlitschek · 2013-12-11T21:02:05Z

Any other idea what we can do here?

PVince81 · 2013-12-11T21:17:57Z

Reminds me a bit of this: #6261

DeepDiver1975 · 2013-12-11T21:26:19Z

I have just been reviewing 3rdparty#64 - this is not the way to go - looks like our schema generation is creating a default value which is invalid

@bartv2 PLEASE!

PVince81 · 2013-12-11T21:29:48Z

Can someone please post the whole error message ?

PVince81 · 2013-12-11T21:29:57Z

With the full SQL if possible.

PVince81 · 2013-12-11T21:38:05Z

It looks like in the DB schema has added "primary" and "unique" for appconfig_appid_key_index.
For some reason it can't drop the constraint.
I guess it will first try and drop the constraint and then recreate it.

The db schema does contain an empty default value, which should be correct.

Needs further research.

NEOatNHNG · 2013-12-11T21:59:03Z

OK, I have some errors in the PostgreSQL log:

2013-12-11 15:14:13 UTC ERROR:  relation "oc_jobs" does not exist at character 18
2013-12-11 15:14:13 UTC STATEMENT:  SELECT "id" FROM "oc_jobs" WHERE "class" = $1 AND "argument" = $2

This repeats quite a few times, not sure its related to the issue. Then one time:

2013-12-11 15:17:41 UTC ERROR:  relation "oc_fscache" does not exist at character 38
2013-12-11 15:17:41 UTC STATEMENT:  SELECT DISTINCT "user" FROM "oc_fscache"

and then a lot of times:

2013-12-11 15:17:42 UTC ERROR:  syntax error at end of input at character 60
2013-12-11 15:17:42 UTC STATEMENT:  ALTER TABLE "oc_pictures_images_cache" ALTER uid_owner SET

Until I applied the patch.

In the owncloud.log:

{"app":"cron","message":"An exception occurred while executing 'SELECT \"id\", \"class\", \"last_run\", \"argument\" FROM \"oc_jobs\"':\n\nSQLSTATE[42P01]: Undefined table: 7 ERROR:  relation \"oc_jobs\" does not exist\nLINE 1: SELECT \"id\", \"class\", \"last_run\", \"argument\" FROM \"oc_jobs\"\n                                                          ^","level":4,"time":"2013-12-11T15:15:01+00:00"}
{"app":"index","message":"Exception: An exception occurred while executing 'SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = ? AND \"argument\" = ?':\n\nSQLSTATE[42P01]: Undefined table: 7 ERROR:  relation \"oc_jobs\" does not exist\nLINE 1: SELECT \"id\" FROM \"oc_jobs\" WHERE \"class\" = $1 AND \"argument\"...\n                         ^","level":4,"time":"2013-12-11T15:17:38+00:00"}
{"app":"core","message":"App \"\" (files_imageviewer) can't be used because it is not compatible with this version of ownCloud","level":3,"time":"2013-12-11T15:17:41+00:00"}
{"app":"core","message":"can't remove app files_imageviewer. It is not installed.","level":3,"time":"2013-12-11T15:17:41+00:00"}
{"app":"core","message":"App \"\" (user_migrate) can't be used because it is not compatible with this version of ownCloud","level":3,"time":"2013-12-11T15:17:41+00:00"}
{"app":"core","message":"can't remove app user_migrate. It is not installed.","level":3,"time":"2013-12-11T15:17:41+00:00"}
{"app":"core","message":"App \"\" (admin_migrate) can't be used because it is not compatible with this version of ownCloud","level":3,"time":"2013-12-11T15:17:41+00:00"}
{"app":"core","message":"can't remove app admin_migrate. It is not installed.","level":3,"time":"2013-12-11T15:17:41+00:00"}
{"app":"core","message":"App \"\" (media) can't be used because it is not compatible with this version of ownCloud","level":3,"time":"2013-12-11T15:17:41+00:00"}
{"app":"core","message":"can't remove app media. It is not installed.","level":3,"time":"2013-12-11T15:17:41+00:00"}
{"app":"core","message":"App \"\" (files_odfviewer) can't be used because it is not compatible with this version of ownCloud","level":3,"time":"2013-12-11T15:17:41+00:00"}
{"app":"core","message":"can't remove app files_odfviewer. It is not installed.","level":3,"time":"2013-12-11T15:17:41+00:00"}
{"app":"core","message":"Failed to update database structure (exception 'PDOException' with message 'SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at end of input\nLINE 1: ALTER TABLE \"oc_pictures_images_cache\" ALTER uid_owner SET \n                                                                   ^' in \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php:742\nStack trace:\n#0 [internal function]: PDO->query('ALTER TABLE \"oc...')\n#1 \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(742): call_user_func_array(Array, Array)\n#2 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(152): Doctrine\\DBAL\\Connection->query('ALTER TABLE \"oc...')\n#3 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(91): OC\\DB\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\DBAL\\Schema\\SchemaDiff))\n#4 \/var\/www\/owncloud\/lib\/private\/db.php(373): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/ownclo...')\n#5 \/var\/www\/owncloud\/lib\/private\/app.php(965): OC_DB::updateDbFromStructure('\/var\/www\/ownclo...')\n#6 \/var\/www\/owncloud\/lib\/private\/app.php(867): OC_App::updateApp('gallery')\n#7 \/var\/www\/owncloud\/lib\/private\/app.php(92): OC_App::checkUpgrade('gallery')\n#8 \/var\/www\/owncloud\/lib\/private\/app.php(66): OC_App::loadApp('gallery')\n#9 \/var\/www\/owncloud\/lib\/private\/util.php(36): OC_App::loadApps(Array)\n#10 \/var\/www\/owncloud\/lib\/private\/files\/filesystem.php(800): OC_Util::setupFS()\n#11 \/var\/www\/owncloud\/lib\/autoloader.php(143): require_once('\/var\/www\/ownclo...')\n#12 [internal function]: OC\\Autoloader->load('OC\\Files\\Filesy...')\n#13 \/var\/www\/owncloud\/apps\/search_lucene\/appinfo\/app.php(74): spl_autoload_call('OC\\Files\\Filesy...')\n#14 \/var\/www\/owncloud\/lib\/private\/app.php(93): require_once('\/var\/www\/ownclo...')\n#15 \/var\/www\/owncloud\/lib\/private\/app.php(971): OC_App::loadApp('search_lucene')\n#16 \/var\/www\/owncloud\/lib\/private\/app.php(867): OC_App::updateApp('search_lucene')\n#17 \/var\/www\/owncloud\/lib\/private\/app.php(92): OC_App::checkUpgrade('search_lucene')\n#18 \/var\/www\/owncloud\/lib\/private\/app.php(66): OC_App::loadApp('search_lucene')\n#19 \/var\/www\/owncloud\/lib\/private\/updater.php(118): OC_App::loadApps()\n#20 \/var\/www\/owncloud\/core\/ajax\/update.php(34): OC\\Updater->upgrade()\n#21 {main}\n\nNext exception 'Doctrine\\DBAL\\DBALException' with message 'An exception occurred while executing 'ALTER TABLE \"oc_pictures_images_cache\" ALTER uid_owner SET ':\n\nSQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at end of input\nLINE 1: ALTER TABLE \"oc_pictures_images_cache\" ALTER uid_owner SET \n                                                                   ^' in \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php:47\nStack trace:\n#0 \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(744): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(PDOException), 'ALTER TABLE \"oc...')\n#1 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(152): Doctrine\\DBAL\\Connection->query('ALTER TABLE \"oc...')\n#2 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(91): OC\\DB\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\DBAL\\Schema\\SchemaDiff))\n#3 \/var\/www\/owncloud\/lib\/private\/db.php(373): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/ownclo...')\n#4 \/var\/www\/owncloud\/lib\/private\/app.php(965): OC_DB::updateDbFromStructure('\/var\/www\/ownclo...')\n#5 \/var\/www\/owncloud\/lib\/private\/app.php(867): OC_App::updateApp('gallery')\n#6 \/var\/www\/owncloud\/lib\/private\/app.php(92): OC_App::checkUpgrade('gallery')\n#7 \/var\/www\/owncloud\/lib\/private\/app.php(66): OC_App::loadApp('gallery')\n#8 \/var\/www\/owncloud\/lib\/private\/util.php(36): OC_App::loadApps(Array)\n#9 \/var\/www\/owncloud\/lib\/private\/files\/filesystem.php(800): OC_Util::setupFS()\n#10 \/var\/www\/owncloud\/lib\/autoloader.php(143): require_once('\/var\/www\/ownclo...')\n#11 [internal function]: OC\\Autoloader->load('OC\\Files\\Filesy...')\n#12 \/var\/www\/owncloud\/apps\/search_lucene\/appinfo\/app.php(74): spl_autoload_call('OC\\Files\\Filesy...')\n#13 \/var\/www\/owncloud\/lib\/private\/app.php(93): require_once('\/var\/www\/ownclo...')\n#14 \/var\/www\/owncloud\/lib\/private\/app.php(971): OC_App::loadApp('search_lucene')\n#15 \/var\/www\/owncloud\/lib\/private\/app.php(867): OC_App::updateApp('search_lucene')\n#16 \/var\/www\/owncloud\/lib\/private\/app.php(92): OC_App::checkUpgrade('search_lucene')\n#17 \/var\/www\/owncloud\/lib\/private\/app.php(66): OC_App::loadApp('search_lucene')\n#18 \/var\/www\/owncloud\/lib\/private\/updater.php(118): OC_App::loadApps()\n#19 \/var\/www\/owncloud\/core\/ajax\/update.php(34): OC\\Updater->upgrade()\n#20 {main})","level":4,"time":"2013-12-11T15:17:42+00:00"}
{"app":"PHP","message":"Konnte \"search_lucene\" nicht aktualisieren. at \/var\/www\/owncloud\/lib\/private\/app.php#873","level":3,"time":"2013-12-11T15:17:42+00:00"}
{"app":"core","message":"Failed to update database structure (exception 'PDOException' with message 'SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at end of input\nLINE 1: ALTER TABLE \"oc_pictures_images_cache\" ALTER uid_owner SET \n                                                                   ^' in \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php:742\nStack trace:\n#0 [internal function]: PDO->query('ALTER TABLE \"oc...')\n#1 \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(742): call_user_func_array(Array, Array)\n#2 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(152): Doctrine\\DBAL\\Connection->query('ALTER TABLE \"oc...')\n#3 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(91): OC\\DB\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\DBAL\\Schema\\SchemaDiff))\n#4 \/var\/www\/owncloud\/lib\/private\/db.php(373): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/ownclo...')\n#5 \/var\/www\/owncloud\/lib\/private\/app.php(965): OC_DB::updateDbFromStructure('\/var\/www\/ownclo...')\n#6 \/var\/www\/owncloud\/lib\/private\/app.php(867): OC_App::updateApp('gallery')\n#7 \/var\/www\/owncloud\/lib\/private\/app.php(92): OC_App::checkUpgrade('gallery')\n#8 \/var\/www\/owncloud\/lib\/private\/app.php(66): OC_App::loadApp('gallery')\n#9 \/var\/www\/owncloud\/lib\/private\/util.php(36): OC_App::loadApps(Array)\n#10 \/var\/www\/owncloud\/lib\/private\/files\/filesystem.php(800): OC_Util::setupFS()\n#11 \/var\/www\/owncloud\/lib\/autoloader.php(143): require_once('\/var\/www\/ownclo...')\n#12 [internal function]: OC\\Autoloader->load('OC\\Files\\Filesy...')\n#13 \/var\/www\/owncloud\/apps\/search_lucene\/appinfo\/app.php(74): spl_autoload_call('OC\\Files\\Filesy...')\n#14 \/var\/www\/owncloud\/lib\/private\/app.php(93): require_once('\/var\/www\/ownclo...')\n#15 \/var\/www\/owncloud\/lib\/private\/app.php(971): OC_App::loadApp('search_lucene')\n#16 \/var\/www\/owncloud\/lib\/private\/app.php(867): OC_App::updateApp('search_lucene')\n#17 \/var\/www\/owncloud\/lib\/private\/app.php(92): OC_App::checkUpgrade('search_lucene')\n#18 \/var\/www\/owncloud\/lib\/private\/app.php(66): OC_App::loadApp('search_lucene')\n#19 \/var\/www\/owncloud\/lib\/base.php(548): OC_App::loadApps()\n#20 \/var\/www\/owncloud\/lib\/base.php(955): OC::init()\n#21 \/var\/www\/owncloud\/cron.php(49): require_once('\/var\/www\/ownclo...')\n#22 {main}\n\nNext exception 'Doctrine\\DBAL\\DBALException' with message 'An exception occurred while executing 'ALTER TABLE \"oc_pictures_images_cache\" ALTER uid_owner SET ':\n\nSQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at end of input\nLINE 1: ALTER TABLE \"oc_pictures_images_cache\" ALTER uid_owner SET \n                                                                   ^' in \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php:47\nStack trace:\n#0 \/var\/www\/owncloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(744): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(PDOException), 'ALTER TABLE \"oc...')\n#1 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(152): Doctrine\\DBAL\\Connection->query('ALTER TABLE \"oc...')\n#2 \/var\/www\/owncloud\/lib\/private\/db\/mdb2schemamanager.php(91): OC\\DB\\MDB2SchemaManager->executeSchemaChange(Object(Doctrine\\DBAL\\Schema\\SchemaDiff))\n#3 \/var\/www\/owncloud\/lib\/private\/db.php(373): OC\\DB\\MDB2SchemaManager->updateDbFromStructure('\/var\/www\/ownclo...')\n#4 \/var\/www\/owncloud\/lib\/private\/app.php(965): OC_DB::updateDbFromStructure('\/var\/www\/ownclo...')\n#5 \/var\/www\/owncloud\/lib\/private\/app.php(867): OC_App::updateApp('gallery')\n#6 \/var\/www\/owncloud\/lib\/private\/app.php(92): OC_App::checkUpgrade('gallery')\n#7 \/var\/www\/owncloud\/lib\/private\/app.php(66): OC_App::loadApp('gallery')\n#8 \/var\/www\/owncloud\/lib\/private\/util.php(36): OC_App::loadApps(Array)\n#9 \/var\/www\/owncloud\/lib\/private\/files\/filesystem.php(800): OC_Util::setupFS()\n#10 \/var\/www\/owncloud\/lib\/autoloader.php(143): require_once('\/var\/www\/ownclo...')\n#11 [internal function]: OC\\Autoloader->load('OC\\Files\\Filesy...')\n#12 \/var\/www\/owncloud\/apps\/search_lucene\/appinfo\/app.php(74): spl_autoload_call('OC\\Files\\Filesy...')\n#13 \/var\/www\/owncloud\/lib\/private\/app.php(93): require_once('\/var\/www\/ownclo...')\n#14 \/var\/www\/owncloud\/lib\/private\/app.php(971): OC_App::loadApp('search_lucene')\n#15 \/var\/www\/owncloud\/lib\/private\/app.php(867): OC_App::updateApp('search_lucene')\n#16 \/var\/www\/owncloud\/lib\/private\/app.php(92): OC_App::checkUpgrade('search_lucene')\n#17 \/var\/www\/owncloud\/lib\/private\/app.php(66): OC_App::loadApp('search_lucene')\n#18 \/var\/www\/owncloud\/lib\/base.php(548): OC_App::loadApps()\n#19 \/var\/www\/owncloud\/lib\/base.php(955): OC::init()\n#20 \/var\/www\/owncloud\/cron.php(49): require_once('\/var\/www\/ownclo...')\n#21 {main})","level":4,"time":"2013-12-11T15:30:02+00:00"}

And those last messages repeat quite often. Now the only message I get in the log:

{"app":"OCP\\Share","message":"Sharing backend OCA\\Contacts\\Share\\Addressbook not registered, OCA\\Contacts\\Share\\Addressbook is already registered for addressbook","level":2,"time":"2013-12-11T18:05:47+00:00"}

I hope that helps in any way.

PVince81 · 2013-12-11T22:02:55Z

@NEOatNHNG I'm still trying to find out where the log file is on linux... not in /var/log 😦

DeepDiver1975 · 2013-12-11T22:02:56Z

this is the migration sql to be executed on pgsql:

CREATE TABLE "oc_jobs" ("id" SERIAL NOT NULL, "class" VARCHAR(255) DEFAULT '' NOT NULL, "argument" VARCHAR(256) DEFAULT '' NOT NULL, "last_run" INT DEFAULT 0, PRIMARY KEY("id"));
CREATE INDEX job_class_index ON "oc_jobs" ("class");
CREATE TABLE "oc_privatedata" ("keyid" SERIAL NOT NULL, "user" VARCHAR(255) DEFAULT '' NOT NULL, "app" VARCHAR(255) DEFAULT '' NOT NULL, "key" VARCHAR(255) DEFAULT '' NOT NULL, "value" VARCHAR(255) DEFAULT '' NOT NULL, PRIMARY KEY("keyid"));
ALTER TABLE "oc_appconfig" ALTER appid SET  DEFAULT '';
ALTER TABLE "oc_appconfig" ALTER configkey SET  DEFAULT '';
ALTER TABLE "oc_appconfig" DROP CONSTRAINT IF EXISTS appconfig_appid_key_index;
DROP INDEX IF EXISTS appconfig_appid_key_index;
ALTER TABLE "oc_appconfig" ADD PRIMARY KEY ("appid", "configkey");
ALTER TABLE "oc_file_map" ALTER logic_path SET  DEFAULT '';
ALTER TABLE "oc_file_map" ALTER logic_path_hash SET  DEFAULT '';
ALTER TABLE "oc_file_map" ALTER physic_path SET  DEFAULT '';
ALTER TABLE "oc_file_map" ALTER physic_path_hash SET  DEFAULT '';
ALTER TABLE "oc_file_map" DROP CONSTRAINT IF EXISTS file_map_lp_index;
DROP INDEX IF EXISTS file_map_lp_index;
ALTER TABLE "oc_file_map" ADD PRIMARY KEY ("logic_path_hash");
ALTER TABLE "oc_mimetypes" ALTER mimetype SET  DEFAULT '';
ALTER TABLE "oc_filecache" ADD "storage_mtime" INT DEFAULT 0 NOT NULL;
ALTER TABLE "oc_filecache" ALTER path_hash SET  DEFAULT '';
ALTER TABLE "oc_filecache" ALTER etag SET  DEFAULT NULL;
ALTER TABLE "oc_filecache" ALTER etag DROP NOT NULL;
ALTER TABLE "oc_permissions" ALTER "user" SET  DEFAULT NULL;
ALTER TABLE "oc_permissions" ALTER "user" DROP NOT NULL;
ALTER TABLE "oc_permissions" DROP CONSTRAINT IF EXISTS id_user_index;
DROP INDEX IF EXISTS id_user_index;
CREATE INDEX id_user_index ON "oc_permissions" ("fileid", "user");
ALTER TABLE "oc_group_user" ALTER gid SET  DEFAULT '';
ALTER TABLE "oc_group_user" ALTER uid SET  DEFAULT '';
ALTER TABLE "oc_group_user" ADD PRIMARY KEY ("gid", "uid");
ALTER TABLE "oc_group_admin" ALTER gid SET  DEFAULT '';
ALTER TABLE "oc_group_admin" ALTER uid SET  DEFAULT '';
ALTER TABLE "oc_group_admin" ADD PRIMARY KEY ("gid", "uid");
ALTER TABLE "oc_groups" ALTER gid SET  DEFAULT '';
ALTER TABLE "oc_locks" ALTER timeout SET  DEFAULT NULL;
ALTER TABLE "oc_locks" ALTER created SET  DEFAULT NULL;
ALTER TABLE "oc_locks" ALTER scope SET  DEFAULT NULL;
ALTER TABLE "oc_locks" ALTER depth SET  DEFAULT NULL;
ALTER TABLE "oc_preferences" ALTER userid SET  DEFAULT '';
ALTER TABLE "oc_preferences" ALTER appid SET  DEFAULT '';
ALTER TABLE "oc_preferences" ALTER configkey SET  DEFAULT '';
ALTER TABLE "oc_preferences" DROP CONSTRAINT IF EXISTS pref_userid_appid_key_index;
DROP INDEX IF EXISTS pref_userid_appid_key_index;
ALTER TABLE "oc_preferences" ADD PRIMARY KEY ("userid", "appid", "configkey");
ALTER TABLE "oc_properties" ADD "id" SERIAL NOT NULL;
ALTER TABLE "oc_properties" ALTER userid SET  DEFAULT '';
ALTER TABLE "oc_properties" ALTER propertypath SET  DEFAULT '';
ALTER TABLE "oc_properties" ALTER propertyname SET  DEFAULT '';
ALTER TABLE "oc_properties" ALTER propertyvalue SET ;
ALTER TABLE "oc_properties" ADD PRIMARY KEY ("id");
ALTER TABLE "oc_share" ADD "mail_send" SMALLINT DEFAULT '0' NOT NULL;
ALTER TABLE "oc_share" ALTER uid_owner SET  DEFAULT '';
ALTER TABLE "oc_share" ALTER parent SET  DEFAULT NULL;
ALTER TABLE "oc_share" ALTER item_type SET  DEFAULT '';
ALTER TABLE "oc_share" ALTER file_source SET  DEFAULT NULL;
CREATE INDEX item_share_type_index ON "oc_share" ("item_type", "share_type");
CREATE INDEX file_source_index ON "oc_share" ("file_source");
ALTER TABLE "oc_users" ALTER uid SET  DEFAULT '';
ALTER TABLE "oc_users" ALTER password SET  DEFAULT '';
ALTER TABLE "oc_vcategory" ALTER uid SET  DEFAULT '';
ALTER TABLE "oc_vcategory" ALTER type SET  DEFAULT '';
ALTER TABLE "oc_vcategory" ALTER category SET  DEFAULT '';
ALTER TABLE "oc_vcategory_to_object" ALTER type SET  DEFAULT '';
CREATE INDEX vcategory_objectd_index ON "oc_vcategory_to_object" ("objid", "type");

PVince81 · 2013-12-11T22:03:12Z

The log from Postgresql...

NEOatNHNG · 2013-12-11T22:07:41Z

@PVince81 on debian it's in /var/log/postgresql/postgresql-9.1-main.log

asavah · 2013-12-12T12:35:22Z

see https://github.com/Glandos/3rdparty/commit/29c4057fd554ca1ad9a69df14ab9cb4b69af962f

It fixed for me an initial upgrade issue with pgsql9.3

DeepDiver1975 · 2013-12-12T14:35:15Z

Okay - I have to revert my comment from last night: looks like we really have to patch doctrine - thanks @butonic

s24195 · 2013-12-13T08:39:38Z

Hi I got this failure message updating to Version 6 with MYSQL .

An exception occurred while executing 'ALTER TABLE oc_preferences ADD PRIMARY KEY (userid, appid, configkey)': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'jm-files-cache_version' for key 'PRIMARY'

@karlitschek Maybe we can discuss it Monday night, I just reverted to an old snapshot so we can try it out together.

butonic · 2014-01-17T17:43:23Z

has been fixed upstream and then with owncloud-archive/3rdparty#65

Glandos mentioned this issue Dec 11, 2013

Fix SET DEFAULT when there is no default owncloud-archive/3rdparty#64

Closed

PVince81 mentioned this issue Dec 11, 2013

[WIP] hard core unit test for core database schema migration 5.0.13 -> 6.0.0 #6332

Closed

butonic mentioned this issue Dec 12, 2013

[PostgresPlatform] Fixing change detection when a default is removed doctrine/dbal#44

Closed

butonic closed this as completed Jan 17, 2014

adiknoth mentioned this issue Feb 14, 2014

Failed to upgrade from 5.0.10 to 6.0.1 with postgresql #7202

Closed

AdamWill mentioned this issue Mar 17, 2014

Upgrade from 5.x to 6.x fails if using pgsql database and Doctrine-DBAL 2.4.2 #7778

Closed

lock bot locked as resolved and limited conversation to collaborators Aug 18, 2019

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Upgrade from ownCloud 5.0.13 to 6.0.0 using PostgreSQL fails #6310

Upgrade from ownCloud 5.0.13 to 6.0.0 using PostgreSQL fails #6310

Finn10111 commented Dec 11, 2013

Glandos commented Dec 11, 2013

Glandos commented Dec 11, 2013

karlitschek commented Dec 11, 2013

Glandos commented Dec 11, 2013

NEOatNHNG commented Dec 11, 2013

PVince81 commented Dec 11, 2013

DeepDiver1975 commented Dec 11, 2013

karlitschek commented Dec 11, 2013

PVince81 commented Dec 11, 2013

DeepDiver1975 commented Dec 11, 2013

PVince81 commented Dec 11, 2013

PVince81 commented Dec 11, 2013

PVince81 commented Dec 11, 2013

NEOatNHNG commented Dec 11, 2013

PVince81 commented Dec 11, 2013

DeepDiver1975 commented Dec 11, 2013

PVince81 commented Dec 11, 2013

NEOatNHNG commented Dec 11, 2013

asavah commented Dec 12, 2013

DeepDiver1975 commented Dec 12, 2013

s24195 commented Dec 13, 2013

butonic commented Jan 17, 2014

Upgrade from ownCloud 5.0.13 to 6.0.0 using PostgreSQL fails #6310

Upgrade from ownCloud 5.0.13 to 6.0.0 using PostgreSQL fails #6310

Comments

Finn10111 commented Dec 11, 2013

Glandos commented Dec 11, 2013

Glandos commented Dec 11, 2013

karlitschek commented Dec 11, 2013

Glandos commented Dec 11, 2013

NEOatNHNG commented Dec 11, 2013

PVince81 commented Dec 11, 2013

DeepDiver1975 commented Dec 11, 2013

karlitschek commented Dec 11, 2013

PVince81 commented Dec 11, 2013

DeepDiver1975 commented Dec 11, 2013

PVince81 commented Dec 11, 2013

PVince81 commented Dec 11, 2013

PVince81 commented Dec 11, 2013

NEOatNHNG commented Dec 11, 2013

PVince81 commented Dec 11, 2013

DeepDiver1975 commented Dec 11, 2013

PVince81 commented Dec 11, 2013

NEOatNHNG commented Dec 11, 2013

asavah commented Dec 12, 2013

DeepDiver1975 commented Dec 12, 2013

s24195 commented Dec 13, 2013

butonic commented Jan 17, 2014