Comment 1 for bug 1420087

Revision history for this message
zhai weixiang (zhaiwx1987) wrote :

'check table' can also corrupt the server:

for example: check table sbtest1;

(gdb) bt
#0 0x000000372c6328a5 in raise () from /lib64/libc.so.6
#1 0x000000372c634085 in abort () from /lib64/libc.so.6
#2 0x0000000000aa1be4 in btr_page_get_father_node_ptr_func (offsets=<value optimized out>, heap=0x2b6de6c7c300, cursor=<value optimized out>, line=<value optimized out>,
    mtr=<value optimized out>, file=0xd397c8 "/u01/project/mysql-lab/percona-server-5.6.22-71.0/storage/innobase/btr/btr0btr.cc")
    at /u01/project/mysql-lab/percona-server-5.6.22-71.0/storage/innobase/btr/btr0btr.cc:1492
#3 0x0000000000aa3b28 in btr_page_get_father_block (index=0x2b6df24435e8, trx=0x2b6de6c29a68) at /u01/project/mysql-lab/percona-server-5.6.22-71.0/storage/innobase/btr/btr0btr.cc:1521
#4 btr_validate_level (index=0x2b6df24435e8, trx=0x2b6de6c29a68) at /u01/project/mysql-lab/percona-server-5.6.22-71.0/storage/innobase/btr/btr0btr.cc:4907
#5 btr_validate_index (index=0x2b6df24435e8, trx=0x2b6de6c29a68) at /u01/project/mysql-lab/percona-server-5.6.22-71.0/storage/innobase/btr/btr0btr.cc:5050
#6 0x00000000009b595e in ha_innobase::check (this=0x2b6de5b5eb10, thd=0x2b6de5bd7000, check_opt=0x2b6de5bda2d8)
    at /u01/project/mysql-lab/percona-server-5.6.22-71.0/storage/innobase/handler/ha_innodb.cc:12090
#7 0x000000000059c82a in handler::ha_check (this=0x2b6de5b5eb10, thd=0x2b6de5bd7000, check_opt=0x2b6de5bda2d8) at /u01/project/mysql-lab/percona-server-5.6.22-71.0/sql/handler.cc:4287
#8 0x0000000000839e05 in mysql_admin_table (thd=0x2b6de5bd7000, tables=0x0, check_opt=0x2b6de5bda2d8, operator_name=0xd55ebc "check", lock_type=TL_READ_NO_INSERT, open_for_modify=false,
    repair_table_use_frm=false, extra_open_options=32, prepare_func=0, operator_func=(int (handler::*)(handler *, THD *, HA_CHECK_OPT *)) 0x59c740 <handler::ha_check(THD*, HA_CHECK_OPT*)>,
    view_operator_func=0x75db50 <view_checksum(THD*, TABLE_LIST*)>) at /u01/project/mysql-lab/percona-server-5.6.22-71.0/sql/sql_admin.cc:654
#9 0x000000000083aa5b in Sql_cmd_check_table::execute (this=<value optimized out>, thd=0x2b6de5bd7000) at /u01/project/mysql-lab/percona-server-5.6.22-71.0/sql/sql_admin.cc:1108
#10 0x00000000006e86cb in mysql_execute_command (thd=0x2b6de5bd7000) at /u01/project/mysql-lab/percona-server-5.6.22-71.0/sql/sql_parse.cc:5444
#11 0x00000000006ec0e8 in mysql_parse (thd=0x2b6de5bd7000, rawbuf=<value optimized out>, length=19, parser_state=<value optimized out>)
    at /u01/project/mysql-lab/percona-server-5.6.22-71.0/sql/sql_parse.cc:6918
#12 0x00000000006ed7d1 in dispatch_command (command=COM_QUERY, thd=0x2b6de5bd7000, packet=0x2b6df470fab0 "", packet_length=19)
    at /u01/project/mysql-lab/percona-server-5.6.22-71.0/sql/sql_parse.cc:1434
#13 0x00000000006b55f5 in do_handle_one_connection (thd_arg=<value optimized out>) at /u01/project/mysql-lab/percona-server-5.6.22-71.0/sql/sql_connect.cc:1532
#14 0x00000000006b5772 in handle_one_connection (arg=0x2b6bb0f2f000) at /u01/project/mysql-lab/percona-server-5.6.22-71.0/sql/sql_connect.cc:1443
#15 0x000000000093d2c7 in pfs_spawn_thread (arg=0x2b6dce7232a0) at /u01/project/mysql-lab/percona-server-5.6.22-71.0/storage/perfschema/pfs.cc:1860
#16 0x000000372ca07851 in start_thread () from /lib64/libpthread.so.0
#17 0x000000372c6e767d in clone () from /lib64/libc.so.6
(gdb) f 4
#4 btr_validate_level (index=0x2b6df24435e8, trx=0x2b6de6c29a68) at /u01/project/mysql-lab/percona-server-5.6.22-71.0/storage/innobase/btr/btr0btr.cc:4907
4907 &mtr, &right_node_cur);
(gdb) p ((buf_page_t *)right_block)->is_corrupt
$11 = 1