Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-11430

[Rollback] syndesis-db-metrics causes db rollback to fail

XMLWordPrintable

      (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 !!
      
      ...
      

      ``

            lgarciaac Luis García Acosta
            rhn-support-hbraun Heiko Braun
            Andrej Vano Andrej Vano
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: