Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5874

Collection of InnoDB assertion and other failures triggered by wild configuration

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.9
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

          They probably won't be fixed (and maybe even don't need to), but might be useful to diagnose external users' problems and some sporadic failures.

          Failing assertion: srv_log_block_size >= X with non-default innodb_log_block_size

          Bootstrap and start server with --innodb_log_block_size=3333 (no other non-default options necessary).

          InnoDB: Warning: innodb_log_block_size has been changed from default value 512. (###EXPERIMENTAL### operation)
InnoDB: Assertion failure in thread 139997338412896 in file ha_innodb.cc line 3269
InnoDB: Failing assertion: srv_log_block_size >= 512

          #5  0x00007f53a9a506f0 in *__GI_abort () at abort.c:92
#6  0x0000000000b63700 in innobase_init (p=0x7f53a6351870) at 10.0/storage/xtradb/handler/ha_innodb.cc:3269
#7  0x000000000085bdc6 in ha_initialize_handlerton (plugin=0x7f53a63e3550) at 10.0/sql/handler.cc:501
#8  0x00000000006864d6 in plugin_initialize (tmp_root=0x7fffbb06f470, plugin=0x7f53a63e3550, argc=0x18609f0, argv=0x7f53a901e6a0, options_only=false) at 10.0/sql/sql_plugin.cc:1372
#9  0x0000000000686d92 in plugin_init (argc=0x18609f0, argv=0x7f53a901e6a0, flags=0) at 10.0/sql/sql_plugin.cc:1608
#10 0x00000000005bbda3 in init_server_components () at 10.0/sql/mysqld.cc:4763
#11 0x00000000005bce2a in mysqld_main (argc=12, argv=0x7f53a901e6a0) at 10.0/sql/mysqld.cc:5358
#12 0x00000000005b38dc in main (argc=12, argv=0x7fffbb06f988) at 10.0/sql/main.cc:25

          Assertion level <= 50 fails with a set of non-default parameters

          See also http://bugs.mysql.com/bug.php?id=74577

          InnoDB: Assertion failure in thread 140710931433312 in file btr0btr.ic line 143
InnoDB: Failing assertion: level <= 50

          sql/signal_handler.cc:155(handle_fatal_signal)[0x859ff5]
/lib/x86_64-linux-gnu/libpthread.so.0(+0xf030)[0x7ff9d0d49030]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7ff9cf1a3475]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x180)[0x7ff9cf1a66f0]
include/btr0btr.ic:145(btr_page_set_level)[0xcf6477]
btr/btr0btr.cc:2137(btr_page_empty(buf_block_t*, page_zip_des_t*, dict_index_t*, unsigned long, mtr_t*))[0xcf9d39]
btr/btr0btr.cc:2279(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa231]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]
btr/btr0cur.cc:1737(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0xd0bec3]
btr/btr0btr.cc:2674(btr_insert_on_non_leaf_level_func(unsigned long, dict_index_t*, unsigned long, dtuple_t*, char const*, unsigned long, mtr_t*))[0xcfaca6]
btr/btr0btr.cc:2770(btr_attach_half_pages)[0xcfb039]
btr/btr0btr.cc:3014(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfbb63]
btr/btr0btr.cc:2312(btr_root_raise_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0xcfa35b]

          revision-id: elenst@wheezy-64.home-20140315125635-4mv83huc3dntadur
date: 2014-03-15 16:56:35 +0400
build-date: 2014-03-16 18:00:01 +0400
revno: 4055
branch-nick: 10.0

          revision-id: elenst@wheezy-64.home-20140316140147-02f8to9uzbhozte6
date: 2014-03-16 18:01:47 +0400
build-date: 2014-03-16 18:02:33 +0400
revno: 929
branch-nick: randgen-mariadb-patches

          perl ./runall-new.pl --genconfig=2.cnf --grammar=conf/temporal/temporal_functions.yy --gendata=conf/temporal/temporal_functions.zz  --duration=300 --threads=4 --queries=100M --basedir=10.0 --vardir=/home/elenst/test_results/analyze --seed=1394933748

          Config file is attached (2.cnf). It takes over an hour on my machine to bootstrap with this config, so it's certainly needs to be cleaned up before presenting to anyone.

          Big innodb_spin_wait_delay value slows down server dramatically

          --innodb_spin_wait_delay=100000

140316 19:12:25 [Note] InnoDB: Restoring possible half-written data pages 
140316 19:12:25 [Note] InnoDB: from the doublewrite buffer...
140316 19:12:26 [Note] InnoDB: 128 rollback segment(s) are active.
140316 19:12:27 [Note] InnoDB: Waiting for purge to start

          --innodb_spin_wait_delay=1000000

140316 19:12:40 [Note] InnoDB: Restoring possible half-written data pages 
140316 19:12:40 [Note] InnoDB: from the doublewrite buffer...
140316 19:12:42 [Note] InnoDB: 128 rollback segment(s) are active.
140316 19:12:56 [Note] InnoDB: Waiting for purge to start

          --innodb_spin_wait_delay=10000000

140316 19:13:36 [Note] InnoDB: Restoring possible half-written data pages 
140316 19:13:36 [Note] InnoDB: from the doublewrite buffer...
140316 19:13:39 [Note] InnoDB: 128 rollback segment(s) are active.
140316 19:14:10 [Note] InnoDB: Waiting for purge to start

          Failing assertion: len < ((ulint) srv_page_size) due to wrong ibdata1 file

          Start a clean server with default options and with --innodb-fast-shutdown=0, just in case)

          Run create table t1 (i int, c char(255)) engine=InnoDB.

          Stop server, save ibdata1.
          Start server again, same options.

          Run 

          insert into t1 values (1,'a'),(2,'b'),(3,'c'),(4,'d');
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;

          Stop server, replace ibdata1 with the previously saved file.
          Start server again, same options.

          InnoDB: Assertion failure in thread 140352872392448 in file trx0rec.ic line 110
InnoDB: Failing assertion: len < ((ulint) srv_page_size)

          #5  0x00007fa6712e56f0 in *__GI_abort () at abort.c:92
#6  0x0000000000cc2ab6 in trx_undo_rec_copy (undo_rec=0x7fa65bd88110 "", heap=0x7fa64441f300) at 10.0/storage/xtradb/include/trx0rec.ic:110
#7  0x0000000000cc7e6c in trx_undo_get_undo_rec_low (roll_ptr=11258999090512144, heap=0x7fa64441f300) at 10.0/storage/xtradb/trx/trx0rec.cc:1429
#8  0x0000000000cc7f05 in trx_undo_get_undo_rec (roll_ptr=11258999090512144, trx_id=1843, undo_rec=0x7fa67319f990, heap=0x7fa64441f300) at 10.0/storage/xtradb/trx/trx0rec.cc:1461
#9  0x0000000000cc8125 in trx_undo_prev_version_build (index_rec=0x7fa65bd902c8 "testt1GEN_CLUST_INDEXn_diff_pfx01", index_mtr=0x7fa67319fe10, rec=0x7fa65bd902c8 "testt1GEN_CLUST_INDEXn_diff_pfx01", index=0x7fa6444534f8, offsets=0x7fa67319faf0, heap=0x7fa64441f300, old_vers=0x7fa67319fa10) at 10.0/storage/xtradb/trx/trx0rec.cc:1537
#10 0x0000000000c9c617 in row_vers_build_for_consistent_read (rec=0x7fa65bd902c8 "testt1GEN_CLUST_INDEXn_diff_pfx01", mtr=0x7fa67319fe10, index=0x7fa6444534f8, offsets=0x7fa6731a02e0, view=0x7fa6444140e0, offset_heap=0x7fa6731a02e8, in_heap=0x7fa644453700, old_vers=0x7fa6731a02f8) at 10.0/storage/xtradb/row/row0vers.cc:564
#11 0x0000000000c80af3 in row_sel_build_prev_vers (read_view=0x7fa6444140e0, index=0x7fa6444534f8, rec=0x7fa65bd902c8 "testt1GEN_CLUST_INDEXn_diff_pfx01", offsets=0x7fa6731a02e0, offset_heap=0x7fa6731a02e8, old_vers_heap=0x7fa6444db350, old_vers=0x7fa6731a02f8, mtr=0x7fa67319fe10) at 10.0/storage/xtradb/row/row0sel.cc:707
#12 0x0000000000c8220f in row_sel (node=0x7fa6444daa10, thr=0x7fa6444dc8e8) at 10.0/storage/xtradb/row/row0sel.cc:1674
#13 0x0000000000c82dbe in row_sel_step (thr=0x7fa6444dc8e8) at 10.0/storage/xtradb/row/row0sel.cc:2123
#14 0x0000000000c1b7a7 in que_thr_step (thr=0x7fa6444dc8e8) at 10.0/storage/xtradb/que/que0que.cc:1093
#15 0x0000000000c1bac2 in que_run_threads_low (thr=0x7fa6444dc8e8) at 10.0/storage/xtradb/que/que0que.cc:1177
#16 0x0000000000c1bc54 in que_run_threads (thr=0x7fa6444dc8e8) at 10.0/storage/xtradb/que/que0que.cc:1218
#17 0x0000000000c1bed8 in que_eval_sql (info=0x7fa644453278, sql=0x10f69b0 "PROCEDURE FETCH_STATS () IS\nfound INT;\nDECLARE FUNCTION fetch_table_stats_step;\nDECLARE FUNCTION fetch_index_stats_step;\nDECLARE CURSOR table_stats_cur IS\n  SELECT\n  n_rows,\n  clustered_index_size,\n  "..., reserve_dict_mutex=1, trx=0x7fa6444ca678) at 10.0/storage/xtradb/que/que0que.cc:1301
#18 0x0000000000d7e836 in dict_stats_fetch_from_ps (table=0x7fa64441da78) at 10.0/storage/xtradb/dict/dict0stats.cc:2831
#19 0x0000000000d7edc4 in dict_stats_update (table=0x7fa6444525f8, stats_upd_option=DICT_STATS_FETCH_ONLY_IF_NOT_IN_MEMORY) at 10.0/storage/xtradb/dict/dict0stats.cc:3037
#20 0x0000000000b60dcf in dict_stats_init (table=0x7fa6444525f8) at 10.0/storage/xtradb/include/dict0stats.ic:174
#21 0x0000000000b66c90 in ha_innobase::open (this=0x7fa644491088, name=0x7fa64445ac88 "./mysql/gtid_slave_pos", mode=2, test_if_locked=18) at 10.0/storage/xtradb/handler/ha_innodb.cc:5598
#22 0x000000000085f8a2 in handler::ha_open (this=0x7fa644491088, table_arg=0x7fa644470c70, name=0x7fa64445ac88 "./mysql/gtid_slave_pos", mode=2, test_if_locked=18) at 10.0/sql/handler.cc:2432
#23 0x000000000074c2c6 in open_table_from_share (thd=0x7fa644416070, share=0x7fa64445a688, alias=0xf6e7ca "gtid_slave_pos", db_stat=39, prgflag=44, ha_open_flags=18, outparam=0x7fa644470c70, is_create_table=false) at 10.0/sql/table.cc:2851
#24 0x0000000000612ffe in open_table (thd=0x7fa644416070, table_list=0x7fa6731a17a0, mem_root=0x7fa6731a1540, ot_ctx=0x7fa6731a1500) at 10.0/sql/sql_base.cc:2444
#25 0x000000000061568b in open_and_process_table (thd=0x7fa644416070, lex=0x7fa644419cb0, tables=0x7fa6731a17a0, counter=0x7fa6731a1654, flags=0, prelocking_strategy=0x7fa6731a1690, has_prelocking_list=false, ot_ctx=0x7fa6731a1500, new_frm_mem=0x7fa6731a1540) at 10.0/sql/sql_base.cc:3902
#26 0x000000000061686d in open_tables (thd=0x7fa644416070, start=0x7fa6731a1610, counter=0x7fa6731a1654, flags=0, prelocking_strategy=0x7fa6731a1690) at 10.0/sql/sql_base.cc:4444
#27 0x000000000061771c in open_and_lock_tables (thd=0x7fa644416070, tables=0x7fa6731a17a0, derived=false, flags=0, prelocking_strategy=0x7fa6731a1690) at 10.0/sql/sql_base.cc:5059
#28 0x000000000060be03 in open_and_lock_tables (thd=0x7fa644416070, tables=0x7fa6731a17a0, derived=false, flags=0) at 10.0/sql/sql_base.h:485
#29 0x000000000077c3d4 in rpl_load_gtid_slave_state (thd=0x7fa644416070) at 10.0/sql/rpl_rli.cc:1342
#30 0x00000000005d7db4 in handle_slave_init (arg=0x0) at 10.0/sql/slave.cc:307
#31 0x0000000000a2da80 in pfs_spawn_thread (arg=0x7fa6533ec7b0) at 10.0/storage/perfschema/pfs.cc:1853
#32 0x00007fa672e7fb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
#33 0x00007fa67138aa7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#34 0x0000000000000000 in ?? ()

          revision-id: elenst@wheezy-64.home-20140315125635-4mv83huc3dntadur
date: 2014-03-15 16:56:35 +0400
build-date: 2014-03-17 20:30:48 +0400
revno: 4055
branch-nick: 10.0

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    elenst Elena Stepanova
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated: