SAP DBTech JDBC: [131]: transaction rolled back by lock wait timeout

[Former Member]

Greetings Team!

When testing the hot folder CSV import in hybris cloud environment, it's giving below issue.

There is no issue in other environments with same build.

Can anyone please provide the details what could be the root cause?

 SAP DBTech JDBC: [131]: transaction rolled back by lock wait timeout: TrexUpdate failed on table 'BPID1:USERGROUPS' with error: transaction rolled back by lock wait timeout: Lock timeout occurs while waiting RECORD_LOCK of mode EXCLUSIVE(TRANSACTION_ID=48, UPDATE_TRANSACTION_ID=47907914), rc=4628; nested exception is com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [131]: transaction rolled back by lock wait timeout: TrexUpdate failed on table 'BPID1:USERGROUPS' with error: transaction rolled back by lock wait timeout: Lock timeout occurs while waiting RECORD_LOCK of mode EXCLUSIVE(TRANSACTION_ID=48, UPDATE_TRANSACTION_ID=47907914), rc=4628
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.integration.handler.MethodInvokingMessageProcessor.processMessage(MethodInvokingMessageProcessor.java:96) ~[spring-integration-core-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.integration.handler.ServiceActivatingHandler.handleRequestMessage(ServiceActivatingHandler.java:89) ~[spring-integration-core-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.integration.handler.AbstractReplyProducingMessageHandler.handleMessageInternal(AbstractReplyProducingMessageHandler.java:109) ~[spring-integration-core-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.integration.handler.AbstractMessageHandler.handleMessage(AbstractMessageHandler.java:127) ~[spring-integration-core-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.integration.dispatcher.AbstractDispatcher.tryOptimizedDispatch(AbstractDispatcher.java:116) ~[spring-integration-core-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.integration.dispatcher.UnicastingDispatcher.doDispatch(UnicastingDispatcher.java:148) ~[spring-integration-core-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.integration.dispatcher.UnicastingDispatcher.dispatch(UnicastingDispatcher.java:121) ~[spring-integration-core-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.integration.channel.AbstractSubscribableChannel.doSend(AbstractSubscribableChannel.java:89) ~[spring-integration-core-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:425) ~[spring-integration-core-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:375) ~[spring-integration-core-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.messaging.core.GenericMessagingTemplate.doSend(GenericMessagingTemplate.java:115) ~[spring-messaging-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 INFO   | jvm 1    | main    | 2018/11/02 07:51:01.299 |     at org.springframework.messaging.core.GenericMessagingTemplate.doSend(GenericMessagingTemplate.java:45) ~[spring-messaging-4.3.14.RELEASE.jar:4.3.14.RELEASE]
 

[swu]

any comments/prompts regarding the issue, I met a similar issue.

[Former Member]

I also got this problem with mysql in 1808.4. This was not happening in 1808.2! (there were other catalog sync problems though, that also were related to concurrency problems, see my other posts)