we use sysbench to test , and it occurs FATAL: mysql_drv_query() returned error 4018 (Entry not exist) for query 'CREATE INDEX k_1 ON sbtest1(k)'
Describe your question
FATAL: mysql_drv_query() returned error 4018 (Entry not exist) for query 'CREATE INDEX k_1 ON sbtest1(k)'
FATAL: sysbench.cmdline.call_command' function failed: ./oltp_common.lua:238: SQL error, errno = 4018, state = 'HY000': Entry not exist FATAL: mysql_drv_query() returned error 4018 (Entry not exist) for query 'CREATE INDEX k_5 ON sbtest5(k)' FATAL: sysbench.cmdline.call_command' function failed: ./oltp_common.lua:238: SQL error, errno = 4018, state = 'HY000': Entry not exist
FATAL: mysql_drv_query() returned error 4638 (The RootServer is not the master) for query 'CREATE INDEX k_27 ON sbtest27(k)' FATAL: `sysbench.cmdline.call_command' function failed: ./oltp_common.lua:238: SQL error, errno = 4638, state = 'HY000': The RootServer is not the master
this is our sysbench command
/app/sysbench-1.0.20/bin/sysbench oltp_read_write.lua --mysql-host=10.200.124.40 --mysql-port=2883 --mysql-db=test --mysql-user=root@xctest --mysql-password=123456 --table_size=1000000 --tables=30 --threads=150 --report-interval=10 --time=60 cleanup
/app/sysbench-1.0.20/bin/sysbench oltp_read_write.lua --mysql-host=10.200.124.40 --mysql-port=2883 --mysql-db=test --mysql-user=root@xctest --mysql-password=123456 --table_size=1000000 --tables=30 --threads=150 --report-interval=10 --time=60 prepare
it seems not like a regular situation, does u following the way we recommend in https://open.oceanbase.com/docs/observer-cn/V3.1.3/0000000000159988?
can you reproduce this error? if it occurs again, please show more log.