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

Assertion: prebuilt->template_type == ROW_MYSQL_WHOLE_ROW fails in row0mysql.cc line 1752

    XMLWordPrintable

    Details

      Description

      to reproduce:

      ./mtr sp_temp_table.test --mysqld=--log-bin
      

      10.2 fb0b28932ce82903f2fcf

      Version: '10.2.40-MariaDB-debug-log'  
      2021-07-15 11:46:35 0x7fbc0fd1b700  InnoDB: Assertion failure in file /git/10.2/storage/innobase/row/row0mysql.cc line 1752
      InnoDB: Failing assertion: prebuilt->template_type == ROW_MYSQL_WHOLE_ROW
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mysqld startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
      InnoDB: about forcing recovery.
      210715 11:46:35 [ERROR] mysqld got signal 6 ;
       
       
      Server version: 10.2.40-MariaDB-debug-log
       
      linux/raise.c:51(__GI_raise)[0x7fbc25cb97bb]
      stdlib/abort.c:81(__GI_abort)[0x7fbc25ca4535]
      ut/ut0dbg.cc:60(_GLOBAL__sub_D_00099_0_ut0dbg.cc)[0x56074c1a8334]
      row/row0mysql.cc:1753(row_update_for_mysql(row_prebuilt_t*))[0x56074bfb80a3]
      handler/ha_innodb.cc:9126(ha_innobase::delete_row(unsigned char const*))[0x56074bcb204a]
      sql/handler.cc:6178(handler::ha_delete_row(unsigned char const*))[0x56074b77a820]
      sql/sql_delete.cc:585(mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List<st_order>*, unsigned long long, unsigned long long, select_result*))[0x56074bb6f3b1]
      sql/sql_parse.cc:4420(mysql_execute_command(THD*))[0x56074b0eb017]
      sql/sp_head.cc:3331(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x56074af25246]
      sql/sp_head.cc:3094(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x56074af23e00]
      sql/sp_head.cc:3247(sp_instr_stmt::execute(THD*, unsigned int*))[0x56074af24af1]
      sql/sp_head.cc:1326(sp_head::execute(THD*, bool))[0x56074af18ae6]
      sql/sp_head.cc:2202(sp_head::execute_procedure(THD*, List<Item>*))[0x56074af1d7cd]
      sql/sql_parse.cc:2981(do_execute_sp(THD*, sp_head*))[0x56074b0e11d5]
      sql/sql_parse.cc:5622(mysql_execute_command(THD*))[0x56074b0f4c75]
      sql/sp_head.cc:3331(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x56074af25246]
      sql/sp_head.cc:3094(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x56074af23e00]
      sql/sp_head.cc:3247(sp_instr_stmt::execute(THD*, unsigned int*))[0x56074af24af1]
      sql/sp_head.cc:1326(sp_head::execute(THD*, bool))[0x56074af18ae6]
      sql/sp_head.cc:1954(sp_head::execute_function(THD*, Item**, unsigned int, Field*))[0x56074af1ba04]
      sql/item_func.cc:6752(Item_func_sp::execute_impl(THD*))[0x56074b8be3a1]
      sql/item_func.cc:6685(Item_func_sp::execute())[0x56074b8bdc22]
      sql/item_func.h:2419(Item_func_sp::val_real())[0x56074b8c72a6]
      sql/item.cc:6956(Item::send(Protocol*, String*))[0x56074b7bb812]
      sql/protocol.cc:992(Protocol::send_result_set_row(List<Item>*))[0x56074aeb21bf]
      sql/sql_class.cc:2788(select_send::send_data(List<Item>&))[0x56074b0272e5]
      sql/sql_select.cc:3526(JOIN::exec_inner())[0x56074b1a78c5]
      sql/sql_select.cc:3447(JOIN::exec())[0x56074b1a6748]
      sql/sql_select.cc:3851(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x56074b1a9e19]
      sql/sql_select.cc:361(handle_select(THD*, LEX*, select_result*, unsigned long))[0x56074b1868ce]
      sql/sql_parse.cc:6271(execute_sqlcom_select(THD*, TABLE_LIST*))[0x56074b0fa228]
      sql/sql_parse.cc:3582(mysql_execute_command(THD*))[0x56074b0e59af]
      sql/sql_parse.cc:7793(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x56074b103546]
      sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x56074b0da593]
      sql/sql_parse.cc:1381(do_command(THD*))[0x56074b0d6fc4]
      sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x56074b481e5c]
      sql/sql_connect.cc:1242(handle_one_connection)[0x56074b48171d]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x56074c92363c]
      nptl/pthread_create.c:487(start_thread)[0x7fbc263f7fa3]
      x86_64/clone.S:97(clone)[0x7fbc25d7b4cf]
       
      Query (0x62500020d190): DELETE FROM cachedata WHERE
      timestamp < DATE_SUB(@timestamp, INTERVAL 15 SECOND)
      
      

      on 5.5:

      5.5 821a6939087d411f9

      Version: '5.5.69-MariaDB-debug' 
      210715 11:44:15  InnoDB: Assertion failure in thread 140005887186688 in file lock0lock.c line 5494
      InnoDB: Failing assertion: lock_table_has(thr_get_trx(thr), index->table, LOCK_IX)
       
      210715 11:44:15 [ERROR] mysqld got signal 6 ;
       
      Server version: 5.5.69-MariaDB-debug
       
      linux/raise.c:51(__GI_raise)[0x7f55b74467bb]
      stdlib/abort.c:81(__GI_abort)[0x7f55b7431535]
      lock/lock0lock.c:5499(lock_sec_rec_modify_check_and_lock)[0x7f55b0ac053c]
      btr/btr0cur.c:2994(btr_cur_del_mark_set_sec_rec)[0x7f55b0959c14]
      row/row0upd.c:1630(row_upd_sec_index_entry)[0x7f55b0c235ff]
      row/row0upd.c:2328(row_upd)[0x7f55b0c338b2]
      row/row0mysql.c:1493(row_update_for_mysql)[0x7f55b0bd23da]
      handler/ha_innodb.cc:5758(ha_innodb::delete_row(unsigned char const*))[0x7f55b0b4da51]
      sql/handler.cc:5262(handler::ha_delete_row(unsigned char const*))[0x561d6bfd2c33]
      sql/sql_delete.cc:344(mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List<st_order>*, unsigned long long, unsigned long long))[0x561d6c3807bb]
      sql/sql_parse.cc:3098(mysql_execute_command(THD*))[0x561d6bb34bfc]
      sql/sp_head.cc:3223(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x561d6c3279ea]
      sql/sp_head.cc:2999(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x561d6c33f893]
      sql/sp_head.cc:3145(sp_instr_stmt::execute(THD*, unsigned int*))[0x561d6c340964]
      sql/sp_head.cc:1432(sp_head::execute(THD*, bool))[0x561d6c330cb1]
      sql/sp_head.cc:2200(sp_head::execute_procedure(THD*, List<Item>*))[0x561d6c3359c0]
      sql/sql_parse.cc:4120(mysql_execute_command(THD*))[0x561d6bb3eba3]
      sql/sp_head.cc:3223(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x561d6c3279ea]
      sql/sp_head.cc:2999(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x561d6c33f893]
      sql/sp_head.cc:3145(sp_instr_stmt::execute(THD*, unsigned int*))[0x561d6c340964]
      sql/sp_head.cc:1432(sp_head::execute(THD*, bool))[0x561d6c330cb1]
      sql/sp_head.cc:1954(sp_head::execute_function(THD*, Item**, unsigned int, Field*))[0x561d6c334b4a]
      sql/item_func.cc:6906(Item_func_sp::execute_impl(THD*))[0x561d6c11574c]
      sql/item_func.cc:6835(Item_func_sp::execute())[0x561d6c115a65]
      sql/item_func.h:2060(Item_func_sp::val_real())[0x561d6c121baf]
      sql/item.cc:6499(Item::send(Protocol*, String*))[0x561d6bfe3513]
      sql/protocol.cc:903(Protocol::send_result_set_row(List<Item>*))[0x561d6b98c8ae]
      sql/sql_class.cc:2388(select_send::send_data(List<Item>&))[0x561d6ba6c8e9]
      sql/sql_select.cc:2318(JOIN::exec())[0x561d6bc59f18]
      sql/sql_select.cc:3137(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x561d6bc4980c]
      sql/sql_select.cc:312(handle_select(THD*, LEX*, select_result*, unsigned long))[0x561d6bc4bc9c]
      sql/sql_parse.cc:4683(execute_sqlcom_select(THD*, TABLE_LIST*))[0x561d6bb0dd3f]
      sql/sql_parse.cc:2221(mysql_execute_command(THD*))[0x561d6bb280e4]
      sql/sql_parse.cc:5941(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x561d6bb434e0]
      sql/sql_parse.cc:1069(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x561d6bb474a6]
      sql/sql_parse.cc:793(do_command(THD*))[0x561d6bb4c0d0]
      sql/sql_connect.cc:1268(do_handle_one_connection(THD*))[0x561d6be09b67]
      sql/sql_connect.cc:1186(handle_one_connection)[0x561d6be09e51]
      perfschema/pfs.cc:1018(pfs_spawn_thread)[0x561d6c7325f7]
      nptl/pthread_create.c:487(start_thread)[0x7f55b7e1bfa3]
      x86_64/clone.S:97(clone)[0x7f55b75084cf]
       
      Query (0x625000451180): DELETE FROM cachedata WHERE timestamp < DATE_SUB(@timestamp, INTERVAL 15 SECOND)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Elkin Andrei Elkin
              Reporter:
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration