*** Star-up command
MYEXTRA="--plugin-load=audit_log=audit_log.so;tokudb=ha_tokudb.so --init-file=/ssd/ramesh/percona-qa/TokuDB.sql --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY"
if [ -r /usr/lib64/libjemalloc.so.1 ]; then export LD_PRELOAD=/usr/lib64/libjemalloc.so.1
elif [ -r /usr/lib/x86_64-linux-gnu/libjemalloc.so.1 ]; then export LD_PRELOAD=/usr/lib/x86_64-linux-gnu/libjemalloc.so.1
elif [ -r /ssd/ramesh/Percona-Server-5.6.21-rel70.0-696.Linux.x86_64/lib/mysql/libjemalloc.so.1 ]; then export LD_PRELOAD=/ssd/ramesh/Percona-Server-5.6.21-rel70.0-696.Linux.x86_64/lib/mysql/libjemalloc.so.1
else echo 'Error: jemalloc not found, please install it first'; exit 1; fi
/ssd/ramesh/Percona-Server-5.6.21-rel70.0-696.Linux.x86_64/bin/mysqld ${MYEXTRA} --innodb_buffer_pool_size=2147483648 --basedir=/ssd/ramesh/Percona-Server-5.6.21-rel70.0-696.Linux.x86_64 --tmpdir=/ssd/ramesh/Percona-Server-5.6.21-rel70.0-696.Linux.x86_64/data --datadir=/ssd/ramesh/Percona-Server-5.6.21-rel70.0-696.Linux.x86_64/data --plugin-load=tokudb=ha_tokudb.so --core --socket=/ssd/ramesh/Percona-Server-5.6.21-rel70.0-696.Linux.x86_64/socket.sock --port=11161 --log-error=/ssd/ramesh/Percona-Server-5.6.21-rel70.0-696.Linux.x86_64/log/master.err 2>&1 &
echo 'Server socket: /ssd/ramesh/Percona-Server-5.6.21-rel70.0-696.Linux.x86_64/socket.sock with datadir: /ssd/ramesh/Percona-Server-5.6.21-rel70.0-696.Linux.x86_64/data'
**** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE,READ ONLY;
SET messages=cs_CZ;
SELECT delayed_threads=@@session.max_delayed_threads;
SET STATEMENT sort_buffer_size=0,myisam_repair_threads=0 FOR OPTIMIZE TABLE t0;
**** GDB info
#0 0x00007f814a98c771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x000000000067679d in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/signal_handler.cc:236
#2 <signal handler called>
#3 convert_error_message (to=to@entry=0x7f814af7dce0 "\340\205\a\222\200\177", to_length=511, to_length@entry=512, to_cs=0xc48348c675db8548, from=from@entry=0x7f80ba3247e2 "Cannot execute statement in a READ ONLY transaction.", from_length=52, from_cs=0x1360460 <my_charset_utf8_general_ci>, errors=errors@entry=0x7f814af7dcd0) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_error.cc:1030
#4 0x000000000066ff7c in net_send_error_packet (thd=0x7f80ba321000, sql_errno=<optimized out>, err=0x7f80ba3247e2 "Cannot execute statement in a READ ONLY transaction.", sqlstate=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/protocol.cc:397
#5 0x0000000000670100 in Protocol::end_statement (this=0x7f80ba321540) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/protocol.cc:501
#6 0x00000000006fcab3 in dispatch_command (command=<optimized out>, thd=0x7f80ba321000, packet=<optimized out>, packet_length=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_parse.cc:1859
#7 0x00000000006ff5b9 in do_command (thd=<optimized out>) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_parse.cc:1049
#8 0x00000000006cb3c2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f80ba321000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_connect.cc:1532
#9 0x00000000006cb4b0 in handle_one_connection (arg=arg@entry=0x7f80ba321000) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/sql/sql_connect.cc:1443
#10 0x0000000000af86d3 in pfs_spawn_thread (arg=0x7f80ba337340) at /mnt/workspace/percona-server-5.6-binaries-opt-yassl/label_exp/centos6-64/percona-server-5.6.21-70.0/storage/perfschema/pfs.cc:1860
#11 0x00007f814a987df3 in start_thread () from /lib64/libpthread.so.0
#12 0x00007f814965101d in clone () from /lib64/libc.so.6
I get the crash too when I execute
DROP DATABASE test;CREATE DATABASE test;USE test; threads= @@session. max_delayed_ threads; size=0, myisam_ repair_ threads= 0 FOR OPTIMIZE TABLE t0;
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE,READ ONLY;
SET messages=cs_CZ;
SELECT delayed_
SET STATEMENT sort_buffer_
SELECT 1; // Just to show the mysqld server is gone
mysql> SELECT 1; // Just to show the mysqld server is gone
ERROR 2006 (HY000): MySQL server has gone away