Uploaded image for project: 'mod-users'
  1. mod-users
  2. MODUSERS-213

current transaction is aborted

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: P2
    • Resolution: Done
    • Affects Version/s: 17.1.0
    • Fix Version/s: None
    • Environment:

      Multi-node K8s cluster backed by vSphere
      Dedicated and separate Postgres v10.11 database hosts for Okapi and Folio modules
      Dockerized Okapi v3.1.2

    • Template:
      Standard Bug Write-Up Format
    • Sprint:
      CP: sprint 97, CP: sprint 98, CP: sprint 99, CP: sprint 100, CP: sprint 101
    • Story Points:
      3
    • Development Team:
      Core: Platform
    • Release:
      R1 2021
    • Affected Institution:
      TAMU

      Description

      When upgrading from Q1 v16.1.0 to Q2 v17.1.0, mod-users gets upgraded and enabled successfully for the tenant. However, a login cannot successfully occur with these errors:

      In Folio UI:

      Sorry, the information entered does not match our records.
      

      mod-users pod log:

      INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
      21:31:34 INFO CQLWrapper CQL >>> SQL: username==tamu_admin >>>WHERE lower(f_unaccent(users.jsonb->>'username')) LIKE lower(f_unaccent('tamu\_admin')) LIMIT 10 OFFSET 0
      Jul 30, 2020 9:31:34 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
      INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
      21:31:34 INFO CQLWrapper CQL >>> SQL: username==tamu_admin >>>WHERE lower(f_unaccent(users.jsonb->>'username')) LIKE lower(f_unaccent('tamu\_admin')) LIMIT 10 OFFSET 0
      21:31:34 ERROR PgUtil current transaction is aborted, commands ignored until end of transaction block
      io.vertx.pgclient.PgException: current transaction is aborted, commands ignored until end of transaction block
      at io.vertx.pgclient.impl.codec.ErrorResponse.toException(ErrorResponse.java:29) ~[mod-users-fat.jar:?]
      at io.vertx.pgclient.impl.codec.QueryCommandBaseCodec.handleErrorResponse(QueryCommandBaseCodec.java:57) ~[mod-users-fat.jar:?]
      at io.vertx.pgclient.impl.codec.PgDecoder.decodeError(PgDecoder.java:233) ~[mod-users-fat.jar:?]
      at io.vertx.pgclient.impl.codec.PgDecoder.decodeMessage(PgDecoder.java:122) [mod-users-fat.jar:?]
      at io.vertx.pgclient.impl.codec.PgDecoder.channelRead(PgDecoder.java:102) [mod-users-fat.jar:?]
      at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251) [mod-users-fat.jar:?]
      at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [mod-users-fat.jar:?]
      at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [mod-users-fat.jar:?]
      at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [mod-users-fat.jar:?]
      at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286) [mod-users-fat.jar:?]
      at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [mod-users-fat.jar:?]
      at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [mod-users-fat.jar:?]
      at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [mod-users-fat.jar:?]
      at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) [mod-users-fat.jar:?]
      at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [mod-users-fat.jar:?]
      at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [mod-users-fat.jar:?]
      at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) [mod-users-fat.jar:?]
      at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:163) [mod-users-fat.jar:?]
      at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:714) [mod-users-fat.jar:?]
      at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:650) [mod-users-fat.jar:?]
      at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:576) [mod-users-fat.jar:?]
      at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493) [mod-users-fat.jar:?]
      at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) [mod-users-fat.jar:?]
      at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [mod-users-fat.jar:?]
      at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [mod-users-fat.jar:?]
      at java.lang.Thread.run(Thread.java:748) [?:1.8.0_222]
      Jul 30, 2020 9:31:37 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
      

      So, created a fresh tenant and superuser to test with. Tenant with Q2 modules enabled for it was created successfully. However, when boot-strapping the tenant superuser, it fails with these errors...

      From folio-install Q2 branch superuser perl script:

      Finding module ID for authtoken...OK
      Disabling authtoken for tenant...OK
      Disabled:
      [ {
        "id" : "folio_tenant-settings-4.0.0",
        "action" : "disable"
      }, {
        "id" : "mod-login-saml-2.0.0",
        "action" : "disable"
      }, {
        "id" : "folio_stripes-core-5.0.2",
        "action" : "disable"
      }, {
        "id" : "folio_users-4.0.6",
        "action" : "disable"
      }, {
        "id" : "mod-users-bl-6.0.0",
        "action" : "disable"
      }, {
        "id" : "mod-authtoken-2.5.1",
        "action" : "disable"
      } ]
      Creating user record...500 Internal Server Error
      

      mod-user pod logs:

      18:24:56 INFO  ProxyContext         328589/users RES 500 16648us mod-users-17.1.0 http://mod-users-17-1-0:8081/users
      18:24:56 INFO  LogUtil              10.42.16.230:57576 POST /users null HTTP_1_1 500 71 12 tid=tern Internal Server Error
      org.folio.rest.RestVerticle start  invoking postUsers
      ... 21 more
      at io.vertx.pgclient.impl.codec.PgDecoder.channelRead(PgDecoder.java:102) ~[mod-users-fat.jar:?]
      at io.vertx.pgclient.impl.codec.PgDecoder.decodeMessage(PgDecoder.java:122) ~[mod-users-fat.jar:?]
      io.vertx.pgclient.PgException: current transaction is aborted, commands ignored until end of transaction block
      18:24:56 ERROR PostgresClient       query with count: current transaction is aborted, commands ignored until end of transaction block - SELECT count_estimate('SELECT * FROM tern_mod_users.custom_fields WHERE true')
      18:24:56 INFO  CQLWrapper           CQL >>> SQL: cql.allRecords = 1 sortby order/number >>>WHERE true ORDER BY custom_fields.jsonb->'order' LIMIT 2147483647 OFFSET 0
       SEVERE: loadDbSchema loadDbSchema(): Table custom_fields NOT FOUND
      Jul 31, 2020 6:24:56 PM org.folio.cql2pgjson.CQL2PgJSON initDbTable
      INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
      Jul 31, 2020 6:24:56 PM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
      

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                julianladisch Julian Ladisch
                Reporter:
                jroot Jason Root
                Votes:
                0 Vote for this issue
                Watchers:
                11 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases