sysbench icon indicating copy to clipboard operation
sysbench copied to clipboard

Replication failure during DB creation

Open djholms opened this issue 4 years ago • 0 comments

During creation test databases Binary Log File Position Based Replication fails with "Error 'Duplicate key name 'k_3'' on query"

Creation script: sysbench --db-driver=mysql --mysql-user=playground --mysql-password=playgroundpassword \ --mysql-db=sbwritetest1 --range_size=100 \ --table_size=100000 --tables=5 --threads=1 --events=0 --time=60 \ --mysql-host=192.168.10.100 --mysql-port=3306 \ --rand-type=uniform /usr/share/sysbench/oltp_insert.lua prepare

On master host DB creates, sysbench status OK. But replication failed on both slaves with error: Last_Errno: 1061 Last_Error: Error 'Duplicate key name 'k_3'' on query. Default database: 'sbwritetest1'. Query: 'CREATE INDEX k_3 ON sbtest3(k)'

Packages: sysbench 1.0.20 mysql 8.0.21 ubuntu 18.04

djholms avatar Sep 21 '20 07:09 djholms