Upgrade problem. 9.1.6 to 10.0.8, db error: select quote_ident

upgrade

#1

I’ve looked for this, but can’t find any other threads on this error.
Upgrading from 9.1.6 to 10.0.8.
From command line.
apt-get update
sudo -u www-data ./occ maintenance:mode --on
service apache2 stop
apt-get update && apt-get install owncloud-files
sudo -u www-data php occ upgrade

… read some docs on disabling apps …

sudo -u www-data php /var/www/owncloud/occ app:disable calendar
sudo -u www-data php /var/www/owncloud/occ app:disable contacts
sudo -u www-data php /var/www/owncloud/occ app:disable documents
sudo -u www-data php /var/www/owncloud/occ app:disable ownnote
sudo -u www-data php /var/www/owncloud/occ app:disable activity
sudo -u www-data php /var/www/owncloud/occ maintenance:mode --off
sudo -u www-data php occ upgrade

I am getting the following error during upgrade:
ownCloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
June 12, 2018 23:05:54 Set log level to debug
June 12, 2018 23:05:54 Repair step: Repair MySQL database engine
June 12, 2018 23:05:54 Repair info: Not a mysql database -> nothing to do
June 12, 2018 23:05:54 Repair step: Repair MySQL collation
June 12, 2018 23:05:54 Repair info: Not a mysql database -> nothing to do
June 12, 2018 23:05:54 Repair step: Repair SQLite autoincrement
June 12, 2018 23:05:54 Repair step: Repair orphaned reshare
June 12, 2018 23:05:54 Repair step: Repair duplicate entries in oc_lucene_status
June 12, 2018 23:05:54 Repair info: removing duplicate entries from lucene_status
June 12, 2018 23:05:54 Repair step: Upgrade app code from the marketplace
June 12, 2018 23:05:54 Repair info: Enabling market app to assist with update
June 12, 2018 23:05:54 Repair info: Using market to update existing apps
June 12, 2018 23:05:54 Repair info: Attempting to update the following existing compatible apps from market:
June 12, 2018 23:05:54 Repair info: Fetching app from market: comments
June 12, 2018 23:05:56 Repair info: App (comments) is not known at the marketplace.
June 12, 2018 23:05:56 Repair info: Fetching app from market: configreport
June 12, 2018 23:05:57 Repair info: App (configreport) is not known at the marketplace.
June 12, 2018 23:05:57 Repair info: Fetching app from market: dav
June 12, 2018 23:05:58 Repair info: App (dav) is not known at the marketplace.
June 12, 2018 23:05:58 Repair info: Fetching app from market: federatedfilesharing
June 12, 2018 23:06:00 Repair info: App (federatedfilesharing) is not known at the marketplace.
June 12, 2018 23:06:00 Repair info: Fetching app from market: files
June 12, 2018 23:06:01 Repair info: App (files) is not known at the marketplace.
June 12, 2018 23:06:01 Repair info: Fetching app from market: files_external
June 12, 2018 23:06:01 Repair info: App (files_external) is not installed
June 12, 2018 23:06:01 Repair info: Fetching app from market: files_sharing
June 12, 2018 23:06:02 Repair info: App (files_sharing) is not known at the marketplace.
June 12, 2018 23:06:02 Repair info: Fetching app from market: files_texteditor
June 12, 2018 23:06:03 Repair info:
June 12, 2018 23:06:03 Repair info: Fetching app from market: files_trashbin
June 12, 2018 23:06:05 Repair info: App (files_trashbin) is not known at the marketplace.
June 12, 2018 23:06:05 Repair info: Fetching app from market: files_versions
June 12, 2018 23:06:07 Repair info: App (files_versions) is not known at the marketplace.
June 12, 2018 23:06:07 Repair info: Fetching app from market: firstrunwizard
June 12, 2018 23:06:08 Repair info: App (firstrunwizard) is not known at the marketplace.
June 12, 2018 23:06:08 Repair info: Fetching app from market: gallery
June 12, 2018 23:06:09 Repair info:
June 12, 2018 23:06:09 Repair info: Fetching app from market: market
June 12, 2018 23:06:11 Repair info:
June 12, 2018 23:06:11 Repair info: App was not updated: comments
June 12, 2018 23:06:11 Repair info: App was not updated: configreport
June 12, 2018 23:06:11 Repair info: App was not updated: dav
June 12, 2018 23:06:11 Repair info: App was not updated: federatedfilesharing
June 12, 2018 23:06:11 Repair info: App was not updated: files
June 12, 2018 23:06:11 Repair info: App was not updated: files_external
June 12, 2018 23:06:11 Repair info: App was not updated: files_sharing
June 12, 2018 23:06:11 Repair info: App was not updated: files_texteditor
June 12, 2018 23:06:11 Repair info: App was not updated: files_trashbin
June 12, 2018 23:06:11 Repair info: App was not updated: files_versions
June 12, 2018 23:06:11 Repair info: App was not updated: firstrunwizard
June 12, 2018 23:06:11 Repair info: App was not updated: gallery
June 12, 2018 23:06:11 Repair info: App was not updated: market
June 12, 2018 23:06:11 Updating database schema
June 12, 2018 23:06:11 Updated database
June 12, 2018 23:06:11 Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT quote_ident(table_name) AS table_name,
table_schema AS schema_name
FROM information_schema.tables
WHERE table_schema NOT LIKE ‘pg_%’
AND table_schema != ‘information_schema’
AND table_name != ‘geometry_columns’
AND table_name != ‘spatial_ref_sys’
AND table_type != ‘VIEW’’:

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
June 12, 2018 23:06:11 Update failed
June 12, 2018 23:06:11 Maintenance mode is kept active
June 12, 2018 23:06:11 Reset log level


#2

Bump. Several days now, and no responses.


#3

What’s your postgresql version? Note that postgresql 10 isn’t supported in ownCloud 10.0.x and could give some problems


#4

Thanks for replying. I’m running postgres 9.3.
I had been running 9.1.6. I couldn’t find a repo with that version, so now I’m trying to get 9.1.7 installed. I made a backup of the database and directories, and did the following:
apt-get purge --remove owncloud-files
deleted /var/www/owncloud
deleted /var/lib/owncloud
dropped the owncloud database
restored /var/www/owncloud
restored /var/lib/owncloud
restored the owncloud database
apt-get install owncloud-files=9.1.7-1.1
occ upgrade

I get the following, and it looks like the params clause is wrong.

root@dax:/var/www/owncloud/config# sudo -u www-data php /var/www/owncloud/occ upgrade
ownCloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Set log level to debug
Checking whether the database schema can be updated (this can take a long time depending on the database size)
Done
24/24 [============================] 100%
Checked database schema update
Checking updates of apps
Checked database schema update for apps
Updating database schema
Updated database
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘INSERT INTO “oc_appconfig” (“appid”,“configkey”,“configvalue”) SELECT ?,?,? FROM “oc_appconfig” WHERE “appid” = ? AND “configkey” = ? HAVING COUNT(*) = 0’ with params [“systemtags”, “installed_version”, “0.3.0”, “systemtags”, “installed_version”]:

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
Update failed
Maintenance mode is kept active
Reset log level


#5

I am running again on 9.1.6. Instead of using the package manager, I installed from tarball, and restored my data.
When I get more time, I’ll try upgrading again in an attempt to get to version 10.


#6

Could you post the list of applications you have in your ownCloud (both enabled and disabled)? (occ app:list, if I remember correctly)

While I don’t discard a possible bug in the official ownCloud’s apps, I find strange that this has slip by. It might be caused by a bug in another 3rdparty app