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

Recurring: InnoDB: Failing assertion: !lock->recursive

    Details

      Description

      Our partners at Kangaroot reported this subtle assertion failure in InnoDB rwlocks. There was an attempt to fix it previously ( MDEV-6515 Closed ), but apparently it didn't work.

      Version: '10.0.15-MariaDB-log'  socket: '/tmp/mysql.sock'  port: 3306  MariaDB Server
      2014-11-10 12:15:09 3fffaecbf140  InnoDB: Assertion failure in thread 70367381811520 in file sync0rw.cc line 702
      InnoDB: Failing assertion: !lock->recursive
      ...
      sync/sync0rw.cc:702(rw_lock_x_lock_low)[0x1011692c]
      sync/sync0rw.cc:706(rw_lock_x_lock_low)[0x1072d7a0]
      include/sync0rw.ic:926(pfs_rw_lock_x_lock_func)[0x10791488]
      btr/btr0cur.cc:1566(btr_cur_optimistic_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*))[0x1077a7ac]
      row/row0ins.cc:2783(row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*))[0x106e57cc]
      row/row0ins.cc:2969(row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*))[0x106e79fc]
      row/row0upd.cc:1839(row_upd_sec_index_entry)[0x10712f14]
      row/row0upd.cc:2571(row_upd)[0x107176d4]
      row/row0mysql.cc:1738(row_update_for_mysql(unsigned char*, row_prebuilt_t*))[0x106f5f70]
      handler/ha_innodb.cc:8044(ha_innobase::update_row(unsigned char const*, unsigned char*))[0x10630e80]
      sql/handler.cc:5994(handler::ha_update_row(unsigned char const*, unsigned char*))[0x103e70ec]
      sql/sql_update.cc:803(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*))[0x102b8608]
      sql/sql_parse.cc:3294(mysql_execute_command(THD*))[0x101f9ac0]
      sql/sql_prepare.cc:3971(Prepared_statement::execute(String*, bool))[0x10219140]
      sql/sql_prepare.cc:3626(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x102192e4]
      sql/sql_prepare.cc:2725(mysqld_stmt_execute(THD*, char*, unsigned int))[0x10219648]
      sql/sql_parse.cc:1250(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x101ff808]
      sql/sql_connect.cc:1379(do_handle_one_connection(THD*))[0x102fdbac]
      sql/sql_connect.cc:1295(handle_one_connection)[0x102fdcd4]
      

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                svoj Sergey Vojtovich
                Reporter:
                svoj Sergey Vojtovich
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: