Details
-
Bug
-
Status: Closed (View Workflow)
-
P2
-
Resolution: Done
-
None
-
None
-
CP: sprint 114
-
1
-
Core: Platform
Description
Using 33.0.0-SNAPSHOT with Vertx 4.0.2 (FOLIO) or Vertx 4.0.3 fail.
Problem lies in between:
git bisect good 7b97ff41a8f3a4d3c85af3a60b39ffd58d9721aa
git bisect bad b776a3b570c74f8f0bcce5d19d502928c3bf7948
Running git bisect gives:
d6563fedeb16e3a3fb62966eb6c23db59d364332 is the first bad commit
commit d6563fedeb16e3a3fb62966eb6c23db59d364332
Author: Julian Ladisch <julianladisch@users.noreply.github.com>
Date: Thu Apr 29 10:14:25 2021 +0200
RMB-832: Implement upsert, updateBatch for optimistic locking
Upsert using INSERT ... ON CONFLICT (id) DO UPDATE fails because the INSERT
trigger overwrites the _version property that the UPDATE trigger uses to
detect optimistic locking conflicts.
Possible error:
14:02:12 [] [] [] [] ERROR Conn saveBatch size=1 { "message": "current transaction is aborted, commands ignored until end of transaction block", "severity": "ERROR", "code": "25P02", "file": "postgres.c", "line": "1424", "routine": "exec_parse_message" } io.vertx.pgclient.PgException: { "message": "current transaction is aborted, commands ignored until end of transaction block", "severity": "ERROR", "code": "25P02", "file": "postgres.c", "line": "1424", "routine": "exec_parse_message" } at io.vertx.pgclient.impl.codec.ErrorResponse.toException(ErrorResponse.java:31) ~[vertx-pg-client-4.0.2-FOLIO.jar:4.0.2-FOLIO] at io.vertx.pgclient.impl.codec.PrepareStatementCommandCodec.handleErrorResponse(PrepareStatementCommandCodec.java:88) ~[vertx-pg-client-4.0.2-FOLIO.jar:4.0.2-FOLIO] at io.vertx.pgclient.impl.codec.PgDecoder.decodeError(PgDecoder.java:236) ~[vertx-pg-client-4.0.2-FOLIO.jar:4.0.2-FOLIO] at io.vertx.pgclient.impl.codec.PgDecoder.decodeMessage(PgDecoder.java:122) [vertx-pg-client-4.0.2-FOLIO.jar:4.0.2-FOLIO] at io.vertx.pgclient.impl.codec.PgDecoder.channelRead(PgDecoder.java:102) [vertx-pg-client-4.0.2-FOLIO.jar:4.0.2-FOLIO] at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:714) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:650) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:576) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:493) [netty-transport-4.1.52.Final.jar:4.1.52.Final] at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) [netty-common-4.1.52.Final.jar:4.1.52.Final] at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [netty-common-4.1.52.Final.jar:4.1.52.Final] at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [netty-common-4.1.52.Final.jar:4.1.52.Final] at java.lang.Thread.run(Thread.java:829) [?:?]
TestRail: Results
Attachments
Issue Links
- blocks
-
FOLIO-3144 build-platform-complete-snapshot job failure
-
- Closed
-
-
MODPERMS-147 Tests fail when Vert.x 4.1.0.Beta1 is in use
-
- Closed
-
-
RMB-836 Release RMB 33.0.0-pre3
-
- Closed
-
- is blocked by
-
RMB-841 upsertBatch with transaction (connection) fails
-
- Closed
-
- is duplicated by
-
MODPERMS-147 Tests fail when Vert.x 4.1.0.Beta1 is in use
-
- Closed
-