Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.3.1, 11.4.5
-
Rocky Linux 8.6 - 4.18.0-372.16.1.el8_6.0.1.x86_64
Description
Had a database crash while importing a table.
When attempting to restart MariaDB the following stack trace repeats continuously until the server process is manually killed.
Tried to upgrade the server from 11.3 to 11.4 hoping perhaps a bug fix would give us a better idea of what the problem is, but both versions error in exactly the same way.
Not sure there is much to go on here, but reporting it since it is a crash. We are just going to reload the database from a backup.
==== trace log below ====
Kernel version: Linux version 4.18.0-372.16.1.el8_6.0.1.x86_64 (mockbuild@dal1-prod-builder001.bld.equ.rockylinux.org) (gcc version 8.5.0 20210514 (Red Hat 8.5.0-10) (GCC)) #1 SMP Thu Jul 14 21:39:58 UTC 2022
|
 |
250421 10:47:10 mysqld_safe Number of processes running now: 0
|
250421 10:47:10 mysqld_safe mysqld restarted
|
2025-04-21 10:47:10 0 [Note] Starting MariaDB 11.4.5-MariaDB source revision 0771110266ff5c04216af4bf1243c65f8c67ccf4 server_uid UzMJCQUspDz5aPpny41yNgW/O84= as process 2510687
|
2025-04-21 10:47:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
2025-04-21 10:47:10 0 [Note] InnoDB: Number of transaction pools: 1
|
2025-04-21 10:47:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
|
2025-04-21 10:47:10 0 [Note] InnoDB: Using Linux native AIO
|
2025-04-21 10:47:10 0 [Note] InnoDB: Initializing buffer pool, total size = 96.000GiB, chunk size = 128.000MiB
|
2025-04-21 10:47:11 0 [Note] InnoDB: Completed initialization of buffer pool
|
2025-04-21 10:47:11 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
|
2025-04-21 10:47:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=5053744503159
|
2025-04-21 10:47:11 0 [Note] InnoDB: End of log at LSN=5053753405847
|
2025-04-21 10:47:11 0 [Note] InnoDB: To recover: 4805 pages
|
2025-04-21 10:47:11 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 1158 row operations to undo
|
2025-04-21 10:47:11 0 [Note] InnoDB: Trx id counter is 781666381
|
2025-04-21 10:47:11 0 [Note] InnoDB: Opened 3 undo tablespaces
|
2025-04-21 10:47:11 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
|
2025-04-21 10:47:11 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
|
2025-04-21 10:47:11 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
|
2025-04-21 10:47:11 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
|
2025-04-21 10:47:11 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
|
2025-04-21 10:47:11 0 [Note] InnoDB: log sequence number 5053753405847; transaction id 781666382
|
2025-04-21 10:47:11 0 [Note] InnoDB: Loading buffer pool(s) from /data02/mariadbdata/ksdctmdb11/ib_buffer_pool
|
2025-04-21 10:47:11 0 [Note] InnoDB: Creating #1 encryption thread id 140537663096576 total threads 4.
|
2025-04-21 10:47:11 0 [Note] InnoDB: Creating #2 encryption thread id 140537654703872 total threads 4.
|
2025-04-21 10:47:11 0 [Note] InnoDB: Creating #3 encryption thread id 140536959043328 total threads 4.
|
2025-04-21 10:47:11 0 [Note] InnoDB: Creating #4 encryption thread id 140536950650624 total threads 4.
|
2025-04-21 10:47:11 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2025-04-21 10:47:11 0 [Note] Plugin 'wsrep-provider' is disabled.
|
2025-04-21 10:47:11 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
|
2025-04-21 10:47:11 0 [Note] Using encryption key id 2 for temporary files
|
2025-04-21 10:47:11 0 [Note] Recovering after a crash using tc.log
|
2025-04-21 10:47:11 0 [Note] Starting table crash recovery...
|
2025-04-21 10:47:11 0 [Note] Crash table recovery finished.
|
2025-04-21 10:47:11 0 [Note] Server socket created on IP: '0.0.0.0'.
|
2025-04-21 10:47:11 0 [Note] Server socket created on IP: '::'.
|
2025-04-21 10:47:11 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
|
2025-04-21 10:47:11 0 [Note] InnoDB: Buffer pool(s) load completed at 250421 10:47:11
|
2025-04-21 10:47:11 0 [Note] /usr/local/mariadb11/bin/mariadbd: ready for connections.
|
Version: '11.4.5-MariaDB' socket: '/usr/local/mariadb11/mysql.sock' port: 3312 Source distribution
|
250421 10:47:11 [ERROR] /usr/local/mariadb11/bin/mariadbd got signal 11 ;
|
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: 11.4.5-MariaDB source revision: 0771110266ff5c04216af4bf1243c65f8c67ccf4
|
 |
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: 0x0
|
stack_bottom = 0x0 thread_stack 0x49000
|
mysys/stacktrace.c:216(my_print_stacktrace)[0x55ed54d23cde]
|
sql/signal_handler.cc:230(handle_fatal_signal)[0x55ed5487342d]
|
/lib64/libpthread.so.0(+0x12cf0)[0x7fe9e3abacf0]
|
/lib64/libc.so.6(+0xcf113)[0x7fe9e2c7f113]
|
bits/string_fortified.h:34(memcpy)[0x55ed54b92c87]
|
dict/dict0dict.cc:3641(dict_index_build_node_ptr(dict_index_t const*, unsigned char const*, unsigned long, mem_block_info_t*, unsigned long))[0x55ed54c56159]
|
btr/btr0btr.cc:765(btr_page_get_parent(unsigned short*, mem_block_info_t*, btr_cur_t*, mtr_t*))[0x55ed54c0f57b]
|
include/mem0mem.inl:407(mem_heap_free)[0x55ed54c10beb]
|
btr/btr0btr.cc:3779(btr_compress(btr_cur_t*, bool, mtr_t*))[0x55ed54c143a9]
|
btr/btr0cur.cc:4305(btr_cur_compress_if_useful(btr_cur_t*, bool, mtr_t*))[0x55ed54c257ee]
|
btr/btr0cur.cc:4738(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned long, bool, mtr_t*))[0x55ed54c2bc55]
|
row/row0uins.cc:307(row_undo_ins_remove_sec_low(btr_latch_mode, dict_index_t*, dtuple_t*, que_thr_t*))[0x55ed54cbf606]
|
row/row0uins.cc:345(row_undo_ins_remove_sec)[0x55ed54cbfc94]
|
row/row0undo.cc:401(row_undo)[0x55ed54bda99c]
|
que/que0que.cc:551(que_thr_step)[0x55ed54b8dc44]
|
trx/trx0roll.cc:308(trx_rollback_active)[0x55ed54bf87c0]
|
trx/trx0roll.cc:492(trx_rollback_all_recovered(void*))[0x55ed544a5c10]
|
tpool/task_group.cc:71(tpool::task_group::execute(tpool::task*))[0x55ed54cc82e9]
|
tpool/tpool_generic.cc:572(tpool::thread_pool_generic::worker_main(tpool::worker_data*))[0x55ed54cc618f]
|
/lib64/libstdc++.so.6(+0xc2b23)[0x7fe9e35d1b23]
|
/lib64/libpthread.so.0(+0x81ca)[0x7fe9e3ab01ca]
|
/lib64/libc.so.6(clone+0x43)[0x7fe9e2be9e73]
|
Writing a core file...
|
Working directory at /data/mariadbdata/mdb11
|
Resource Limits (excludes unlimited resources):
|
Limit Soft Limit Hard Limit Units
|
Max stack size 8388608 unlimited bytes
|
Max core file size 0 unlimited bytes
|
Max processes 2061765 2061765 processes
|
Max open files 32222 32222 files
|
Max locked memory 65536 65536 bytes
|
Max pending signals 2061765 2061765 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %e
|