Two threads try inserting records with same ID into the table respectively

[TeslaCN]

Hi community,

This issue is related to apache/shardingsphere#10273, could you have a look?

My script:

#!/bin/zsh

TABLES=10
TABLE_SIZE=100000
THREADS=12

sysbench oltp_read_only --db-driver=pgsql --pgsql-host=${PROXY_HOST} --pgsql-port=3307 --pgsql-user=${USER} --pgsql-password=${PASSWORD} --pgsql-db=${DB_NAME} --tables=${TABLES} --table-size=${TABLE_SIZE} --report-interval=5 --time=15 --threads=$THREADS --percentile=99 --rand-type=uniform --range_selects=off --auto_inc=off cleanup
sysbench oltp_read_only --db-driver=pgsql --pgsql-host=${PROXY_HOST} --pgsql-port=3307 --pgsql-user=${USER} --pgsql-password=${PASSWORD} --pgsql-db=${DB_NAME} --tables=${TABLES} --table-size=${TABLE_SIZE} --report-interval=5 --time=15 --threads=$THREADS --percentile=99 --rand-type=uniform --range_selects=off --auto_inc=off prepare

sysbench oltp_write_only --db-driver=pgsql --pgsql-host=${PROXY_HOST} --pgsql-port=3307 --pgsql-user=${USER} --pgsql-password=${PASSWORD} --pgsql-db=${DB_NAME} --tables=${TABLES} --table-size=${TABLE_SIZE} --report-interval=5  --time=600 --threads=$THREADS --percentile=99  --range_selects=off --rand-type=uniform --auto_inc=off run | tee oltp_write_only.master.txt

sysbench oltp_read_only --db-driver=pgsql --pgsql-host=${PROXY_HOST} --pgsql-port=3307 --pgsql-user=${USER} --pgsql-password=${PASSWORD} --pgsql-db=${DB_NAME} --tables=${TABLES} --table-size=${TABLE_SIZE} --report-interval=${TABLES} --time=15 --threads=$THREADS --percentile=99 --rand-type=uniform --range_selects=off --auto_inc=off cleanup