oceanbase icon indicating copy to clipboard operation
oceanbase copied to clipboard

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)'

Open youyoucao2018 opened this issue 3 years ago • 2 comments

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

youyoucao2018 avatar Jul 21 '22 03:07 youyoucao2018

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

youyoucao2018 avatar Jul 21 '22 03:07 youyoucao2018

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?

akaError avatar Jul 21 '22 05:07 akaError

can you reproduce this error? if it occurs again, please show more log.

dimstars avatar Nov 24 '22 04:11 dimstars