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
- blocks
-
MODDATAIMP-571 Update Folijet Rancher
-
- Closed
-
-
MODDATAIMP-586 Import of new inventory doesn't work in snapshot and test environments
-
- Closed
-
- defines
-
UXPROD-3262 NFR: Data Import R1 2022 Lotus Technical, NFR, & Misc work
-
- Closed
-
-
UXPROD-3463 NFR: Data Import R1 2022 Lotus Support Bug Work
-
- Closed
-
- relates to
-
RANCHER-72 Re-create Folijet environment
-
- Closed
-