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

Trying to write 16384 bytes at 805306368 outside the bounds of the file: ./undo_dir/undo003

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      During some internal MariaDB operations, it crashed and then repeatedly failed to start.
      I found similar issues such as MDEV-34453 and MDEV-35181, but they are supposed to be fixed in version 10.11.11.

      The workaround we used was to set innodb_force_recovery = 1, then run SET GLOBAL innodb_fast_shutdown = 0 , and restart MariaDB.

      What additional information would help to debug or fix this issue?

      Dec 10 04:51:33 hostname mariadbd[2895]: 2025-12-10  4:51:33 0 [Note] InnoDB: Truncating ./undo_dir/undo003
      Dec 10 04:51:33 hostname mariadbd[2895]: 2025-12-10  4:51:33 0 [ERROR] [FATAL] InnoDB: Trying to write 16384 bytes at 805306368 outside the bounds of the file: ./undo_dir/undo003
      Dec 10 04:51:33 hostname mariadbd[2895]: 251210  4:51:33 [ERROR] /usr/sbin/mariadbd got signal 6 ;
      Dec 10 04:51:33 hostname mariadbd[2895]: Sorry, we probably made a mistake, and this is a bug.
      Dec 10 04:51:33 hostname mariadbd[2895]: Your assistance in bug reporting will enable us to fix this for the next release.
      Dec 10 04:51:33 hostname mariadbd[2895]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
      Dec 10 04:51:33 hostname mariadbd[2895]: a bug on https://jira.mariadb.org/.
      Dec 10 04:51:33 hostname mariadbd[2895]: Please include the information from the server start above, to the end of the
      Dec 10 04:51:33 hostname mariadbd[2895]: information below.
      Dec 10 04:51:33 hostname mariadbd[2895]: Server version: 10.11.11-MariaDB-ubu2204-log source revision: e69f8cae1a15e15b9e4f5e0f8497e1f17bdc81a4
      Dec 10 04:51:33 hostname mariadbd[2895]: The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
      Dec 10 04:51:33 hostname mariadbd[2895]: contains instructions to obtain a better version of the backtrace below.
      Dec 10 04:51:33 hostname mariadbd[2895]: Following these instructions will help MariaDB developers provide a fix quicker.
      Dec 10 04:51:33 hostname mariadbd[2895]: Attempting backtrace. Include this in the bug report.
      Dec 10 04:51:33 hostname mariadbd[2895]: (note: Retrieving this information may fail)
      Dec 10 04:51:33 hostname mariadbd[2895]: Thread pointer: 0x0
      Dec 10 04:51:33 hostname mariadbd[2895]: 2025-12-10  4:51:33 0 [Note] InnoDB: Truncated ./undo_dir/undo003
      Dec 10 04:51:33 hostname mariadbd[2895]: stack_bottom = 0x0 thread_stack 0x49000
      Dec 10 04:51:33 hostname mariadbd[2895]: /usr/sbin/mariadbd(my_print_stacktrace+0x30)[0x562b0633b5b0]
      Dec 10 04:51:33 hostname mariadbd[2895]: /usr/sbin/mariadbd(handle_fatal_signal+0x365)[0x562b05ed5d15]
      Dec 10 04:51:34 hostname mariadbd[2895]: libc_sigaction.c:0(__restore_rt)[0x7fa3183f8520]
      Dec 10 04:51:34 hostname mariadbd[2895]: nptl/pthread_kill.c:44(__pthread_kill_implementation)[0x7fa31844c9fc]
      Dec 10 04:51:34 hostname mariadbd[2895]: posix/raise.c:27(__GI_raise)[0x7fa3183f8476]
      Dec 10 04:51:34 hostname mariadbd[2895]: stdlib/abort.c:81(__GI_abort)[0x7fa3183de7f3]
      Dec 10 04:51:34 hostname mariadbd[2895]: /usr/sbin/mariadbd(+0x609031)[0x562b05a34031]
      Dec 10 04:51:34 hostname mariadbd[2895]: /usr/sbin/mariadbd(+0xdb90fb)[0x562b061e40fb]
      Dec 10 04:51:34 hostname mariadbd[2895]: /usr/sbin/mariadbd(_ZN5tpool10task_group7executeEPNS_4taskE+0x70)[0x562b062c6950]
      Dec 10 04:51:34 hostname mariadbd[2895]: /usr/sbin/mariadbd(_ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE+0x8e)[0x562b062c86ae]
      Dec 10 04:51:34 hostname mariadbd[2895]: /lib/x86_64-linux-gnu/libstdc++.so.6(+0xdc253)[0x7fa3187c2253]
      Dec 10 04:51:34 hostname mariadbd[2895]: 2025-12-10  4:51:34 53117 [Warning] InnoDB: Could not free any blocks in the buffer pool! 8028 blocks are in use and 0 free. Consider increasing innodb_buffer_pool_size.
      Dec 10 04:51:34 hostname mariadbd[2895]: nptl/pthread_create.c:442(start_thread)[0x7fa31844aac3]
      Dec 10 04:51:34 hostname mariadbd[2895]: x86_64/clone3.S:83(__clone3)[0x7fa3184dc850]
      Dec 10 04:51:34 hostname mariadbd[2895]: Writing a core file...
      Dec 10 04:51:34 hostname mariadbd[2895]: Working directory at /var/lib/mysql
      Dec 10 04:51:34 hostname mariadbd[2895]: Resource Limits (excludes unlimited resources):
      Dec 10 04:51:34 hostname mariadbd[2895]: Limit                     Soft Limit           Hard Limit           Units
      Dec 10 04:51:34 hostname mariadbd[2895]: Max stack size            8388608              unlimited            bytes
      Dec 10 04:51:34 hostname mariadbd[2895]: Max core file size        0                    unlimited            bytes
      Dec 10 04:51:34 hostname mariadbd[2895]: Max processes             513338               513338               processes
      Dec 10 04:51:34 hostname mariadbd[2895]: Max open files            32768                32768                files
      Dec 10 04:51:34 hostname mariadbd[2895]: Max locked memory         524288               524288               bytes
      Dec 10 04:51:34 hostname mariadbd[2895]: Max pending signals       513338               513338               signals
      Dec 10 04:51:34 hostname mariadbd[2895]: Max msgqueue size         819200               819200               bytes
      Dec 10 04:51:34 hostname mariadbd[2895]: Max nice priority         0                    0
      Dec 10 04:51:34 hostname mariadbd[2895]: Max realtime priority     0                    0
      Dec 10 04:51:34 hostname mariadbd[2895]: Core pattern: core
      Dec 10 04:51:34 hostname mariadbd[2895]: Kernel version: Linux version 5.15.0-143-fips (buildd@lcy02-amd64-099) (gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #153+fips1-Ubuntu SMP Tue Jun 17 23:48:36 UTC 2025
      Dec 10 04:51:35 hostname systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT
      Dec 10 04:51:35 hostname systemd[1]: mariadb.service: Failed with result 'signal'.
      Dec 10 04:51:35 hostname systemd[1]: mariadb.service: Consumed 3w 5d 21h 8min 4.000s CPU time.
      Dec 10 04:51:40 hostname systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 1.
      Dec 10 04:51:40 hostname systemd[1]: Stopped MariaDB 10.11.11 database server.
      Dec 10 04:51:40 hostname systemd[1]: mariadb.service: Consumed 3w 5d 21h 8min 4.000s CPU time.
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Starodubski Reuven
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.