Major (Migrated from https://github.com/syndesisio/syndesis/issues/5166)
Author: Andrej Vaňo
Assignees: Luis Garcia Acosta,
This is a...
[pre][code]
[ ] Feature request
[ ] Regression (a behavior that used to work and stopped working in a new release)
[x] Bug report [!-- Please search GitHub for a similar issue or PR before submitting --]
[ ] Documentation issue or request
[/code][/pre]
Description
When the rollback is trying to drop db (to be restored from the backup right after), it fails because
database "syndesis" is being accessed by other users
. That seems to be the
syndesis-db-metrics
pod that is co-located with the DB, as when I removed it, it didn't fail afterwards
``
... --- * Rolling back 'Migrate database' deploymentconfig.apps.openshift.io/syndesis-server scaled deploymentconfig.apps.openshift.io/syndesis-meta scaled Waiting for syndesis-server to be scaled to 0 NAME READY STATUS RESTARTS AGE httpendpoints-1-x4l2q 1/1 Running 0 9m i-upgrade-1-build 0/1 Completed 0 7m i-upgrade-2-nkgsj 1/1 Running 0 5m syndesis-db-3-z8xjd 2/2 Running 0 1m syndesis-meta-3-ml5kd 1/1 Terminating 0 1m syndesis-oauthproxy-1-fvvzx 1/1 Running 0 1m syndesis-prometheus-1-mk8mt 1/1 Running 0 1m syndesis-server-3-4sx2w 1/1 Terminating 0 1m syndesis-ui-3-pmmtb 1/1 Running 0 1m todo-1-b4jg2 1/1 Running 0 11m todo-1-build 0/1 Completed 0 13m Sleeping 10s ... syndesis-meta-3-ml5kd 0/1 Terminating 0 1m syndesis-meta-3-ml5kd 0/1 Terminating 0 1m syndesis-meta-3-ml5kd 0/1 Terminating 0 1m syndesis-meta-3-ml5kd 0/1 Terminating 0 1m syndesis-server-3-4sx2w 0/1 Terminating 0 1m syndesis-server-3-4sx2w 0/1 Terminating 0 1m syndesis-server-3-4sx2w 0/1 Terminating 0 1m Waiting for syndesis-meta to be scaled to 0 Defaulting container name to postgresql. Use 'oc describe pod/syndesis-db-3-z8xjd -n syndesis' to see all of the containers in this pod. Unable to use a TTY - input is not a terminal or the right kind of file pg_restore: connecting to database for restore pg_restore: creating SCHEMA "public" pg_restore: creating COMMENT "SCHEMA public" pg_restore: creating EXTENSION "plpgsql" pg_restore: creating COMMENT "EXTENSION plpgsql" pg_restore: creating TABLE "public.config" pg_restore: creating TABLE "public.filestore" pg_restore: creating TABLE "public.jsondb" pg_restore: processing data for table "public.config" pg_restore: processing data for table "public.filestore" pg_restore: processing data for table "public.jsondb" pg_restore: creating CONSTRAINT "public.config_pkey" pg_restore: creating CONSTRAINT "public.filestore_pkey" pg_restore: creating CONSTRAINT "public.jsondb_pkey" pg_restore: creating INDEX "public.jsondb_idx" pg_restore: creating ACL "SCHEMA public" dropdb: database removal failed: ERROR: database "syndesis" is being accessed by other users DETAIL: There is 1 other session using the database. command terminated with exit code 1 ====> Rollback Error !! ...
``