Insert ERROR in YSQLSH

General
1

Hi
I am receiving below error while batch insert in YSQLSH. Please suggest how to resolve this.

ERROR: could not serialize access due to concurrent update Detail: [Operation failed. Try again (yb/docdb/conflict_resolution.cc:836): Value write after transaction start: { physical: 1706600595015368 logical: 12 } >= { physical: 1706600595014345 logical: 24 }: kConflict (transaction error 3)] Call getNextException to see othererrors in the batch.java.sql.BatchUpdateException: Batch entry 1 select

2

Hi @subh14

What version are you using?

Are you running concurrent DDL & DML when this error happens?

3

Hi Dorian
sorry for the late reply. I am using version 2.20 and it happened during concurrent DML.

4

Please read https://support.yugabyte.com/hc/en-us/articles/4409627048461-How-to-Troubleshoot-Database-Transaction-Retryable-Errors