Uploaded image for project: 'rancher'
  1. rancher
  2. RANCHER-71

Upgrade Postgres version to 12

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • P2
    • Resolution: Done
    • None
    • 2
    • Folijet
    • Lotus R1 2022

    Description

      During module upgrade (mod-source-record-manager) error occurs:

      07:58:08.110 [vert.x-eventloop-thread-1] ERROR PostgresClient       [101469eqId] { "message": "ALTER TYPE ... ADD cannot run inside a transaction block", "severity": "ERROR", "code": "25001", "file": "xact.c", "line": "3219", "routine": "PreventInTransactionBlock" } 07:58:08.110 [vert.x-eventloop-thread-1] ERROR PostgresClient       [101469eqId] { "message": "ALTER TYPE ... ADD cannot run inside a transaction block", "severity": "ERROR", "code": "25001", "file": "xact.c", "line": "3219", "routine": "PreventInTransactionBlock" } io.vertx.pgclient.PgException: { "message": "ALTER TYPE ... ADD cannot run inside a transaction block", "severity": "ERROR", "code": "25001", "file": "xact.c", "line": "3219", "routine": "PreventInTransactionBlock" }  at io.vertx.pgclient.impl.codec.ErrorResponse.toException(ErrorResponse.java:31) ~[mod-source-record-manager-server-fat.jar:?]  at io.vertx.pgclient.impl.codec.QueryCommandBaseCodec.handleErrorResponse(QueryCommandBaseCodec.java:57) ~[mod-source-record-manager-server-fat.jar:?]  at io.vertx.pgclient.impl.codec.PgDecoder.decodeError(PgDecoder.java:246) ~[mod-source-record-manager-server-fat.jar:?]  at io.vertx.pgclient.impl.codec.PgDecoder.decodeMessage(PgDecoder.java:131) [mod-source-record-manager-server-fat.jar:?]  at io.vertx.pgclient.impl.codec.PgDecoder.channelRead(PgDecoder.java:111) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:719) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:655) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:581) [mod-source-record-manager-server-fat.jar:?]  at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493) [mod-source-record-manager-server-fat.jar:?]  at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) [mod-source-record-manager-server-fat.jar:?]  at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [mod-source-record-manager-server-fat.jar:?]  at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [mod-source-record-manager-server-fat.jar:?]  at java.lang.Thread.run(Thread.java:829) [?:?] 

       

      To resolve this issue we need to upgrade Postgres version from 11 to 12. 

      Attachments

        Issue Links

          Activity

            People

              aliaksei_luhavy Aliaksei Luhavy
              Aivar Iusupov Aivar Iusupov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: