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

Unexpected Linux AIO errors drop the tablespace/subsequent reads fatal

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.16
    • 10.11
    • None
    • None
    • Can result in hang or crash

    Description

      2026-06-27 20:45:22 11757538 [Note] InnoDB: trying to read page [page id: space=91361, page number=141697] in nonexisting or being-dropped tablespace
      2026-06-27 20:45:22 11757538 [ERROR] [FATAL] InnoDB: Unknown error Tablespace deleted or being deleted
      260627 20:45:22 [ERROR] /usr/sbin/mariadbd got signal 6 ;
      Sorry, we probably made a mistake, and this is a bug.

      Your assistance in bug reporting will enable us to fix this for the next release.
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
      a bug on https://jira.mariadb.org/.

      Please include the information from the server start above, to the end of the
      information below.

      Server version: 10.11.16-MariaDB-log source revision: 3218602d3100db9ce7a875511a591cddc173cc16

      The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
      contains instructions to obtain a better version of the backtrace below.
      Following these instructions will help MariaDB developers provide a fix quicker.

      Attempting backtrace. Include this in the bug report.
      (note: Retrieving this information may fail)

      Thread pointer: 0x7ef72c01d128
      stack_bottom = 0x7ef8c8b44000 thread_stack 0x49000
      2026-06-27 20:45:25 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
      2026-06-27 20:45:25 35510 [Note] Error reading relay log event: slave SQL thread was killed
      2026-06-27 20:45:25 35510 [Note] Slave SQL thread exiting, replication stopped in log 'db1-binary.680387' at position 193635270, master: 10.76.24.71:3306
      2026-06-27 20:45:25 35509 [Note] Slave I/O thread exiting, read up to log 'db1-binary.680387', position 193635270, master 10.76.24.71:3306
      /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x5651dd0d008e]
      /usr/sbin/mariadbd(handle_fatal_signal+0x2fd)[0x5651dcb8b1ad]
      /lib64/libpthread.so.0(+0x12cf0)[0x7f2089bb6cf0]
      /lib64/libc.so.6(gsignal+0x10f)[0x7f2088cf9aff]
      /lib64/libc.so.6(abort+0x127)[0x7f2088cccea5]
      /usr/sbin/mariadbd(+0x6c7331)[0x5651dc7ba331]
      /usr/sbin/mariadbd(+0x6b6671)[0x5651dc7a9671]
      /usr/sbin/mariadbd(+0xe3eb46)[0x5651dcf31b46]
      /usr/sbin/mariadbd(+0xd6f824)[0x5651dce62824]
      /usr/sbin/mariadbd(_ZN7handler18index_read_idx_mapEPhjPKhm16ha_rkey_function+0x6e)[0x5651dcb8b98e]
      /usr/sbin/mariadbd(_ZN7handler21ha_index_read_idx_mapEPhjPKhm16ha_rkey_function+0x2cc)[0x5651dcb931fc]
      /usr/sbin/mariadbd(+0x8a0094)[0x5651dc993094]
      /usr/sbin/mariadbd(+0x8a0238)[0x5651dc993238]
      /usr/sbin/mariadbd(+0x8b2873)[0x5651dc9a5873]
      /usr/sbin/mariadbd(_ZN4JOIN14optimize_innerEv+0x14d7)[0x5651dc9ab697]
      /usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0x9b)[0x5651dc9abd4b]
      /usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xde)[0x5651dc9abe3e]
      /usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x14e)[0x5651dc9ac63e]
      /usr/sbin/mariadbd(+0x8338e0)[0x5651dc9268e0]
      /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x13a9)[0x5651dc931940]
      /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x24d)[0x5651dc9214c1]
      /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1225)[0x5651dc92d8d7]
      /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x138)[0x5651dc92f7f6]
      /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3d5)[0x5651dca5ad75]
      /usr/sbin/mariadbd(handle_one_connection+0x5d)[0x5651dca5b0cd]
      /usr/sbin/mariadbd(+0xcbb4b5)[0x5651dcdae4b5]

      Attachments

        1. dmesg_27jun.txt
          1 kB
          ashish
        2. gdb_output.txt
          21 kB
          ashish
        3. global_variables_20260629_162424.txt
          20 kB
          ashish
        4. mariadb_error_logs_table_corruption.txt
          52 kB
          ashish
        5. messages_27jun.txt
          1.34 MB
          ashish
        6. my.cnf
          6 kB
          ashish

        Issue Links

          Activity

            People

              danblack Daniel Black
              ashishcyrus ashish
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.25d
                  0.25d

                  Git Integration

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