Description:
sysbench v0.5 oltp_complex_rw.lua test fails with duplicate entry error
Running the test with following options:
Number of threads: 2
Threads started!
ALERT: mysql_stmt_execute() for query ' INSERT INTO sbtest VALUES(?,0,' ',
'aaaaaaaaaaffffffffffrrrrrrrrrreeeeeeeeeeyyyyyyyyyy')
' failed: 1062 Duplicate entry '499096' for key 'PRIMARY'
FATAL: failed to execute function `event': (null)
How to repeat:
MYSQLD_CONFIG_BASE="--no-defaults \
--socket=/tmp/mysql.sock"
MYSQLD_CONFIG_GENERAL="$MYSQLD_CONFIG_BASE \
--basedir=/home/hakan/work/mysql/mysql-6.0-falcon-team \
--datadir=/data/mysql \
--tmpdir=/tmp \
--language=/home/hakan/work/mysql/mysql-6.0-falcon-team/sql/share/english \
--key_buffer_size=8M \
--skip-grant-tables \
--sort_buffer_size=2M \
--read_buffer_size=1M \
--table_open_cache=8192 \
--tmp_table_size=67108864 \
--thread_cache=1024 \
--query_cache_size=0 \
--query_cache_type=0 \
--max_allowed_packet=512M \
--max_connections=256 \
--log-error"
MYSQLD_CONFIG_FALCON="$MYSQLD_CONFIG_GENERAL \
--skip_innodb \
--default_storage_engine=Falcon \
--falcon_record_memory_max=650M \
--falcon_page_cache_size=1650M \
--falcon_page_size=8k \
--falcon_serial_log_dir=/data/mysql \
--falcon_serial_log_buffers=100 \
--falcon_record_scavenge_threshold=70 \
--falcon_consistent_read=off"
-- Start mysqld
sql/mysqld $MYSQLD_CONFIG_FALCON &
mysqladmin -uroot create test
sysbench \
--init-rng=on \
--mysql-db=test \
--mysql-engine-trx=yes \
--mysql-table-engine=FALCON \
--mysql-user=root \
--oltp-table-size=1000000 \
--test=/home/hakan/work/mysql/sysbench/trunk/sysbench/tests/db/oltp_complex_rw.lua \
prepare
sysbench \
--max-requests=0 \
--max-time=900 \
--mysql-db=test \
--mysql-engine-trx=yes \
--mysql-table-engine=FALCON \
--mysql-user=root \
--num-threads=2 \
--oltp-table-size=1000000 \
--test=/home/hakan/work/mysql/sysbench/trunk/sysbench/tests/db/oltp_complex_rw.lua \
run
Description: sysbench v0.5 oltp_complex_rw.lua test fails with duplicate entry error Running the test with following options: Number of threads: 2 Threads started! ALERT: mysql_stmt_execute() for query ' INSERT INTO sbtest VALUES(?,0,' ', 'aaaaaaaaaaffffffffffrrrrrrrrrreeeeeeeeeeyyyyyyyyyy') ' failed: 1062 Duplicate entry '499096' for key 'PRIMARY' FATAL: failed to execute function `event': (null) How to repeat: MYSQLD_CONFIG_BASE="--no-defaults \ --socket=/tmp/mysql.sock" MYSQLD_CONFIG_GENERAL="$MYSQLD_CONFIG_BASE \ --basedir=/home/hakan/work/mysql/mysql-6.0-falcon-team \ --datadir=/data/mysql \ --tmpdir=/tmp \ --language=/home/hakan/work/mysql/mysql-6.0-falcon-team/sql/share/english \ --key_buffer_size=8M \ --skip-grant-tables \ --sort_buffer_size=2M \ --read_buffer_size=1M \ --table_open_cache=8192 \ --tmp_table_size=67108864 \ --thread_cache=1024 \ --query_cache_size=0 \ --query_cache_type=0 \ --max_allowed_packet=512M \ --max_connections=256 \ --log-error" MYSQLD_CONFIG_FALCON="$MYSQLD_CONFIG_GENERAL \ --skip_innodb \ --default_storage_engine=Falcon \ --falcon_record_memory_max=650M \ --falcon_page_cache_size=1650M \ --falcon_page_size=8k \ --falcon_serial_log_dir=/data/mysql \ --falcon_serial_log_buffers=100 \ --falcon_record_scavenge_threshold=70 \ --falcon_consistent_read=off" -- Start mysqld sql/mysqld $MYSQLD_CONFIG_FALCON & mysqladmin -uroot create test sysbench \ --init-rng=on \ --mysql-db=test \ --mysql-engine-trx=yes \ --mysql-table-engine=FALCON \ --mysql-user=root \ --oltp-table-size=1000000 \ --test=/home/hakan/work/mysql/sysbench/trunk/sysbench/tests/db/oltp_complex_rw.lua \ prepare sysbench \ --max-requests=0 \ --max-time=900 \ --mysql-db=test \ --mysql-engine-trx=yes \ --mysql-table-engine=FALCON \ --mysql-user=root \ --num-threads=2 \ --oltp-table-size=1000000 \ --test=/home/hakan/work/mysql/sysbench/trunk/sysbench/tests/db/oltp_complex_rw.lua \ run