sysbench
sysbench copied to clipboard
Replication failure during DB creation
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