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

Assertion "heap_no == ULINT_UNDEFINED" in trx0i_s.cc

Details

    Description

      Upd: For instructions on reproducing, see comments

      10.5 ff66d38cf26a096854836f

      		 
      2020-04-09 12:50:57 0x7f44f217d300  InnoDB: Assertion failure in file /10.5/storage/innobase/trx/trx0i_s.cc line 852
      		 
      InnoDB: Failing assertion: heap_no == ULINT_UNDEFINED
      		 
      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.
      		 
      200409 12:50:57 [ERROR] mysqld got signal 6 ;
      		 
      Server version: 10.5.3-MariaDB-debug-log
      		 
       
      		 
      linux/raise.c:51(__GI_raise)[0x7f451d046535]
      		 
      ut/ut0dbg.cc:60(_GLOBAL__sub_D_00099_0_ut0dbg.cc)[0x55c9261fec6a]
      		 
      trx/trx0i_s.cc:854(fold_lock(ib_lock_t const*, unsigned long))[0x55c9261fee99]
      		 
      trx/trx0i_s.cc:924(search_innodb_locks(trx_i_s_cache_t*, ib_lock_t const*, unsigned short))[0x55c9261ff6c9]
      		 
      trx/trx0i_s.cc:1086(add_trx_relevant_locks_to_cache(trx_i_s_cache_t*, trx_t const*, i_s_locks_row_t**))[0x55c926200205]
      		 
      trx/trx0i_s.cc:1198(fetch_data_into_cache_low(trx_i_s_cache_t*, trx_t const*))[0x55c926200592]
      		 
      trx/trx0i_s.cc:1233(fetch_data_into_cache(trx_i_s_cache_t*))[0x55c92620072f]
      		 
      trx/trx0i_s.cc:1260(trx_i_s_possibly_fetch_data_into_cache(trx_i_s_cache_t*))[0x55c925e3de28]
      		 
      handler/i_s.cc:990(trx_i_s_common_fill_table(THD*, TABLE_LIST*, Item*))[0x55c924c90b46]
      		 
      sql/sql_show.cc:8647(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x55c924b69d45]
      		 
      sql/sql_select.cc:4419(JOIN::exec_inner())[0x55c924b67c30]
      		 
      sql/sql_select.cc:4245(JOIN::exec())[0x55c924b6bb45]
      		 
      sql/sql_select.cc:4670(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55c924b3de88]
      		 
      sql/sql_select.cc:417(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55c924ab01d5]
      		 
      sql/sql_parse.cc:6168(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55c924a9e5f7]
      		 
      sql/sql_parse.cc:3901(mysql_execute_command(THD*))[0x55c924abb223]
      		 
      sql/sql_parse.cc:7953(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c924a91011]
      		 
      sql/sql_parse.cc:1842(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c924a8da46]
      		 
      sql/sql_parse.cc:1358(do_command(THD*))[0x55c924eaccc7]
      		 
      sql/sql_connect.cc:1422(do_handle_one_connection(CONNECT*, bool))[0x55c924eac562]
      		 
      sql/sql_connect.cc:1321(handle_one_connection)[0x55c925b4b378]
      		 
      nptl/pthread_create.c:487(start_thread)[0x7f451daecfa3]
      		 
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f451d11d4cf]

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-19940 Clean up INFORMATION_SCHEMA.INNODB_ tables

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            alice Alice Sherepa created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Assignee Alice Sherepa [ alice ] Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            Attachment mdev22206_threads_full [ 51820 ]
            Component/s Storage Engine - InnoDB [ 10129 ]
            Component/s XA [ 12400 ]
            Fix Version/s 10.5 [ 23123 ]
            Description {noformat:title=10.5 ff66d38cf26a096854836f}
            2020-04-09 12:50:57 0x7f44f217d300 InnoDB: Assertion failure in file /10.5/storage/innobase/trx/trx0i_s.cc line 852
            InnoDB: Failing assertion: heap_no == ULINT_UNDEFINED
            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.
            200409 12:50:57 [ERROR] mysqld got signal 6 ;
            Server version: 10.5.3-MariaDB-debug-log

            linux/raise.c:51(__GI_raise)[0x7f451d046535]
            ut/ut0dbg.cc:60(_GLOBAL__sub_D_00099_0_ut0dbg.cc)[0x55c9261fec6a]
            trx/trx0i_s.cc:854(fold_lock(ib_lock_t const*, unsigned long))[0x55c9261fee99]
            trx/trx0i_s.cc:924(search_innodb_locks(trx_i_s_cache_t*, ib_lock_t const*, unsigned short))[0x55c9261ff6c9]
            trx/trx0i_s.cc:1086(add_trx_relevant_locks_to_cache(trx_i_s_cache_t*, trx_t const*, i_s_locks_row_t**))[0x55c926200205]
            trx/trx0i_s.cc:1198(fetch_data_into_cache_low(trx_i_s_cache_t*, trx_t const*))[0x55c926200592]
            trx/trx0i_s.cc:1233(fetch_data_into_cache(trx_i_s_cache_t*))[0x55c92620072f]
            trx/trx0i_s.cc:1260(trx_i_s_possibly_fetch_data_into_cache(trx_i_s_cache_t*))[0x55c925e3de28]
            handler/i_s.cc:990(trx_i_s_common_fill_table(THD*, TABLE_LIST*, Item*))[0x55c924c90b46]
            sql/sql_show.cc:8647(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x55c924b69d45]
            sql/sql_select.cc:4419(JOIN::exec_inner())[0x55c924b67c30]
            sql/sql_select.cc:4245(JOIN::exec())[0x55c924b6bb45]
            sql/sql_select.cc:4670(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55c924b3de88]
            sql/sql_select.cc:417(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55c924ab01d5]
            sql/sql_parse.cc:6168(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55c924a9e5f7]
            sql/sql_parse.cc:3901(mysql_execute_command(THD*))[0x55c924abb223]
            sql/sql_parse.cc:7953(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c924a91011]
            sql/sql_parse.cc:1842(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c924a8da46]
            sql/sql_parse.cc:1358(do_command(THD*))[0x55c924eaccc7]
            sql/sql_connect.cc:1422(do_handle_one_connection(CONNECT*, bool))[0x55c924eac562]
            sql/sql_connect.cc:1321(handle_one_connection)[0x55c925b4b378]
            nptl/pthread_create.c:487(start_thread)[0x7f451daecfa3]
            /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f451d11d4cf]

            {noformat}             		_Upd: For instructions on reproducing, see comments_
            ----
            {noformat:title=10.5 ff66d38cf26a096854836f}
            2020-04-09 12:50:57 0x7f44f217d300 InnoDB: Assertion failure in file /10.5/storage/innobase/trx/trx0i_s.cc line 852
            InnoDB: Failing assertion: heap_no == ULINT_UNDEFINED
            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.
            200409 12:50:57 [ERROR] mysqld got signal 6 ;
            Server version: 10.5.3-MariaDB-debug-log

            linux/raise.c:51(__GI_raise)[0x7f451d046535]
            ut/ut0dbg.cc:60(_GLOBAL__sub_D_00099_0_ut0dbg.cc)[0x55c9261fec6a]
            trx/trx0i_s.cc:854(fold_lock(ib_lock_t const*, unsigned long))[0x55c9261fee99]
            trx/trx0i_s.cc:924(search_innodb_locks(trx_i_s_cache_t*, ib_lock_t const*, unsigned short))[0x55c9261ff6c9]
            trx/trx0i_s.cc:1086(add_trx_relevant_locks_to_cache(trx_i_s_cache_t*, trx_t const*, i_s_locks_row_t**))[0x55c926200205]
            trx/trx0i_s.cc:1198(fetch_data_into_cache_low(trx_i_s_cache_t*, trx_t const*))[0x55c926200592]
            trx/trx0i_s.cc:1233(fetch_data_into_cache(trx_i_s_cache_t*))[0x55c92620072f]
            trx/trx0i_s.cc:1260(trx_i_s_possibly_fetch_data_into_cache(trx_i_s_cache_t*))[0x55c925e3de28]
            handler/i_s.cc:990(trx_i_s_common_fill_table(THD*, TABLE_LIST*, Item*))[0x55c924c90b46]
            sql/sql_show.cc:8647(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x55c924b69d45]
            sql/sql_select.cc:4419(JOIN::exec_inner())[0x55c924b67c30]
            sql/sql_select.cc:4245(JOIN::exec())[0x55c924b6bb45]
            sql/sql_select.cc:4670(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55c924b3de88]
            sql/sql_select.cc:417(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55c924ab01d5]
            sql/sql_parse.cc:6168(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55c924a9e5f7]
            sql/sql_parse.cc:3901(mysql_execute_command(THD*))[0x55c924abb223]
            sql/sql_parse.cc:7953(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c924a91011]
            sql/sql_parse.cc:1842(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c924a8da46]
            sql/sql_parse.cc:1358(do_command(THD*))[0x55c924eaccc7]
            sql/sql_connect.cc:1422(do_handle_one_connection(CONNECT*, bool))[0x55c924eac562]
            sql/sql_connect.cc:1321(handle_one_connection)[0x55c925b4b378]
            nptl/pthread_create.c:487(start_thread)[0x7f451daecfa3]
            /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f451d11d4cf]

            {noformat}
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Andrei Elkin [ elkin ]
            elenst Elena Stepanova made changes -
            Summary Assertion "heap_no == ULINT_UNDEFINED" in trx0i_s.cc line 852 Assertion "heap_no == ULINT_UNDEFINED" in trx0i_s.cc
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Affects Version/s 10.5.0 [ 23709 ]
            Affects Version/s 10.5 [ 23123 ]
            Assignee Andrei Elkin [ elkin ] Marko Mäkelä [ marko ]
            marko Marko Mäkelä made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2020-05-29 11:02:15.0 2020-05-29 11:02:15.552
            marko Marko Mäkelä made changes -
            Component/s XA [ 12400 ]
            Fix Version/s 10.5.4 [ 24264 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 106972 ] MariaDB v4 [ 157585 ]

            People

              marko Marko Mäkelä
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.