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

InnoDB: Failing assertion: page_type == i_s_page_type[page_type].type_value

    XMLWordPrintable

Details

    Description

      Note: I don't have information whether it's happening on other versions, so I'm keeping only "10.9" in affected/fix fields. Please adjust based on the results of the analysis.

      10.9 44c9008ba65686abf1c82c9166255a8c52d61f74

      #2  0x00005633fe41635d in ut_dbg_assertion_failed (expr=0x5633ff5f1ec0 "page_type == i_s_page_type[page_type].type_value", file=0x5633ff5f0900 "/data/MDEV-31386/10.9/storage/innobase/handler/i_s.cc", 
          line=4038) at /data/MDEV-31386/10.9/storage/innobase/ut/ut0dbg.cc:60
      #3  0x00005633fe017d5d in i_s_innodb_set_page_type (page_info=0x6260000a6e48, frame=0x640000634000 " Ac") at /data/MDEV-31386/10.9/storage/innobase/handler/i_s.cc:4038
      #4  0x00005633fe018356 in i_s_innodb_buffer_page_get_info (bpage=0x640000465d70, pos=115, page_info=0x6260000a6e48) at /data/MDEV-31386/10.9/storage/innobase/handler/i_s.cc:4112
      #5  0x00005633fe0187d5 in i_s_innodb_buffer_page_fill (thd=0x62b000230218, tables=0x6290007dacf0) at /data/MDEV-31386/10.9/storage/innobase/handler/i_s.cc:4176
      #6  0x00005633fd0ebf0f in get_schema_tables_result (join=0x629000864640, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/MDEV-31386/10.9/sql/sql_show.cc:8924
      #7  0x00005633fcfc91c6 in JOIN::exec_inner (this=0x629000864640) at /data/MDEV-31386/10.9/sql/sql_select.cc:4806
      #8  0x00005633fcfc71b2 in JOIN::exec (this=0x629000864640) at /data/MDEV-31386/10.9/sql/sql_select.cc:4627
      #9  0x00005633fcfcac0e in mysql_select (thd=0x62b000230218, tables=0x6290007dacf0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, 
          result=0x629000864610, unit=0x62b000234440, select_lex=0x6290007da5c8) at /data/MDEV-31386/10.9/sql/sql_select.cc:5107
      #10 0x00005633fcf9fe11 in handle_select (thd=0x62b000230218, lex=0x62b000234368, result=0x629000864610, setup_tables_done_option=0) at /data/MDEV-31386/10.9/sql/sql_select.cc:584
      #11 0x00005633fcee1070 in execute_sqlcom_select (thd=0x62b000230218, all_tables=0x6290007dacf0) at /data/MDEV-31386/10.9/sql/sql_parse.cc:6278
      #12 0x00005633fcecfda1 in mysql_execute_command (thd=0x62b000230218, is_called_from_prepared_stmt=false) at /data/MDEV-31386/10.9/sql/sql_parse.cc:3948
      #13 0x00005633fceeae1b in mysql_parse (thd=0x62b000230218, 
          rawbuf=0x6290007da238 "SELECT /* TID 1-10 QNO 1-4 */ t1.* FROM `information_schema`.`INNODB_BUFFER_PAGE` t1 LEFT JOIN (SELECT /* `information_schema`.`INNODB_SYS_TABLESPACES` */ t11.`FS_BLOCK_SIZE` AS fld1, COUNT(*) AS cnt "..., length=399, parser_state=0x34427f52a920) at /data/MDEV-31386/10.9/sql/sql_parse.cc:8043
      #14 0x00005633fcec33c8 in dispatch_command (command=COM_QUERY, thd=0x62b000230218, 
          packet=0x6290007d0219 "SELECT /* TID 1-10 QNO 1-4 */ t1.* FROM `information_schema`.`INNODB_BUFFER_PAGE` t1 LEFT JOIN (SELECT /* `information_schema`.`INNODB_SYS_TABLESPACES` */ t11.`FS_BLOCK_SIZE` AS fld1, COUNT(*) AS cnt "..., packet_length=400, blocking=true) at /data/MDEV-31386/10.9/sql/sql_parse.cc:1894
      #15 0x00005633fcec0926 in do_command (thd=0x62b000230218, blocking=true) at /data/MDEV-31386/10.9/sql/sql_parse.cc:1407
      #16 0x00005633fd30c57e in do_handle_one_connection (connect=0x60800002c3b8, put_in_cache=true) at /data/MDEV-31386/10.9/sql/sql_connect.cc:1416
      #17 0x00005633fd30bf0b in handle_one_connection (arg=0x60800002c3b8) at /data/MDEV-31386/10.9/sql/sql_connect.cc:1318
      #18 0x00007ffd791cd609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #19 0x0000147ed2b90133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        1. MDEV-31386.cc
          15 kB
          Matthias Leich
        2. MDEV-31386.yy
          11 kB
          Matthias Leich

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.