Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11.8
-
None
-
ubuntu 22.04
Description
This problem appear again with 10.11.8
2024-06-04 16:32:05 0 [Note] Starting MariaDB 10.11.8-MariaDB-ubu2204-log source revision 3a069644682e336e445039e48baae9693f9a08ee as process 3740736 |
2024-06-04 16:32:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 |
2024-06-04 16:32:05 0 [Note] InnoDB: Number of transaction pools: 1 |
2024-06-04 16:32:05 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions |
2024-06-04 16:32:05 0 [Note] InnoDB: Using liburing |
2024-06-04 16:32:05 0 [Note] InnoDB: Initializing buffer pool, total size = 47.000GiB, chunk size = 0.734GiB |
2024-06-04 16:32:06 0 [Note] InnoDB: Initialized memory pressure event listener |
2024-06-04 16:32:06 0 [Note] InnoDB: Completed initialization of buffer pool |
2024-06-04 16:32:06 0 [Note] InnoDB: Buffered log writes (block size=512 bytes) |
2024-06-04 16:32:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=246569381075 |
2024-06-04 16:32:08 0 [Note] InnoDB: End of log at LSN=247070096712 |
2024-06-04 16:32:08 0 [Note] InnoDB: To recover: 27399 pages |
2024-06-04 16:32:09 0 [Note] InnoDB: Last binlog file '/srv/mysql/binlog/mariadb-bin.037958', position 50435899 |
2024-06-04 16:32:09 0 [Note] InnoDB: 128 rollback segments are active. |
2024-06-04 16:32:09 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" |
2024-06-04 16:32:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... |
2024-06-04 16:32:09 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. |
2024-06-04 16:32:09 0 [Note] InnoDB: log sequence number 247070096712; transaction id 254442803 |
2024-06-04 16:32:09 0 [Note] Plugin 'FEEDBACK' is disabled. |
2024-06-04 16:32:09 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mysql/data/ib_buffer_pool |
240604 16:32:09 server_audit: MariaDB Audit Plugin version 1.4.14 STARTED. |
240604 16:32:09 server_audit: logging started to the file /srv/mysql/log/audit.log. |
2024-06-04 16:32:09 0 [Note] RocksDB: 2 column families found |
2024-06-04 16:32:09 0 [Note] RocksDB: Column Families at start: |
2024-06-04 16:32:09 0 [Note] cf=default |
2024-06-04 16:32:09 0 [Note] write_buffer_size=67108864 |
2024-06-04 16:32:09 0 [Note] target_file_size_base=67108864 |
2024-06-04 16:32:09 0 [Note] cf=__system__ |
2024-06-04 16:32:09 0 [Note] write_buffer_size=67108864 |
2024-06-04 16:32:09 0 [Note] target_file_size_base=67108864 |
2024-06-04 16:32:12 0 [Note] RocksDB: Table_store: loaded DDL data for 27 tables |
2024-06-04 16:32:12 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer |
2024-06-04 16:32:12 0 [Note] MyRocks storage engine plugin has been successfully initialized. |
2024-06-04 16:32:12 0 [Note] Recovering after a crash using /srv/mysql/binlog/mariadb-bin |
2024-06-04 16:32:12 0 [Note] Starting table crash recovery... |
2024-06-04 16:32:12 0 [Note] Found 1 prepared transaction(s) in ROCKSDB |
2024-06-04 16:32:12 0 [Note] Crash table recovery finished. |
240604 16:32:12 [ERROR] mysqld 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 |
|
We will try our best to scrape up some info that will hopefully help |
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail. |
|
Server version: 10.11.8-MariaDB-ubu2204-log source revision: 3a069644682e336e445039e48baae9693f9a08ee |
key_buffer_size=134217728 |
read_buffer_size=2097152 |
max_used_connections=0 |
max_threads=1002 |
thread_count=2 |
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 6314105 K bytes of memory |
Hope that's ok; if not, decrease some variables in the equation. |
|
Thread pointer: 0x0 |
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went |
terribly wrong...
|
stack_bottom = 0x0 thread_stack 0x49000 |
/usr/sbin/mariadbd(my_print_stacktrace+0x32)[0x556266e7d0c2] |
/usr/sbin/mariadbd(handle_fatal_signal+0x478)[0x5562669458f8] |
libc_sigaction.c:0(__restore_rt)[0x7b0216c42520] |
/usr/lib/mysql/plugin/ha_spider.so(_Z21spider_sys_open_tableP3THDP10TABLE_LISTPP15start_new_trans+0x1b)[0x7af60c70d3fb] |
/usr/lib/mysql/plugin/ha_spider.so(_Z21spider_open_sys_tableP3THDPKcibPP15start_new_transbPi+0xf6)[0x7af60c70d686] |
/usr/lib/mysql/plugin/ha_spider.so(_Z32spider_internal_xa_commit_by_xidP3THDP21st_spider_transactionP5xid_t+0x15b)[0x7af60c7199db] |
/usr/lib/mysql/plugin/ha_spider.so(_Z23spider_xa_commit_by_xidP10handlertonP5xid_t+0x3f)[0x7af60c71d0bf] |
/usr/sbin/mariadbd(+0xaa3a75)[0x556266947a75] |
/usr/sbin/mariadbd(_Z24plugin_foreach_with_maskP3THDPFcS0_P13st_plugin_intPvEijS3_+0x1a9)[0x5562666fac59] |
/usr/sbin/mariadbd(+0xaa286f)[0x55626694686f] |
/usr/sbin/mariadbd(my_hash_iterate+0x50)[0x556266e5dbc0] |
/usr/sbin/mariadbd(_Z19ha_recover_completeP7st_hashPSt4pairIjyE+0x30)[0x55626694b4d0] |
/usr/sbin/mariadbd(_ZN16Recovery_context8completeEP13MYSQL_BIN_LOGR7st_hash+0x6f)[0x556266a685cf] |
/usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG7recoverEP11st_log_infoPKcP11st_io_cacheP28Format_description_log_eventb+0x790)[0x556266a694e0] |
/usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG18do_binlog_recoveryEPKcb+0x303)[0x556266a69933] |
/usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG4openEPKc+0x3f)[0x556266a6ccdf] |
/usr/sbin/mariadbd(+0x729012)[0x5562665cd012] |
/usr/sbin/mariadbd(_Z11mysqld_mainiPPc+0x41d)[0x5562665d1c1d] |
nptl/libc_start_call_main.h:58(__libc_start_call_main)[0x7b0216c29d90] |
csu/libc-start.c:128(call_init)[0x7b0216c29e40] |
/usr/sbin/mariadbd(_start+0x25)[0x5562665c65f5] |
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains |
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /srv/mysql/data
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes |
Max core file size 0 unlimited bytes |
Max resident set unlimited unlimited bytes
|
Max processes 255010 255010 processes |
Max open files 32768 32768 files |
Max locked memory 524288 524288 bytes |
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 255010 255010 signals |
Max msgqueue size 819200 819200 bytes |
Max nice priority 0 0 |
Max realtime priority 0 0 |
Max realtime timeout unlimited unlimited us
|
Core pattern: |/usr/share/apport/apport -p%p -s%s -c%c -d%d -P%P -u%u -g%g -- %E
|
|
Kernel version: Linux version 6.5.0-35-generic (buildd@lcy02-amd64-079) (x86_64-linux-gnu-gcc-12 (Ubuntu 12.3.0-1ubuntu1~22.04) 12.3.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #35~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 7 09:00:52 UTC 2 |
|
2024-06-04 16:32:19 0 [Note] Starting MariaDB 10.11.8-MariaDB-ubu2204-log source revision 3a069644682e336e445039e48baae9693f9a08ee as process 3741910 |
2024-06-04 16:32:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 |
2024-06-04 16:32:19 0 [Note] InnoDB: Number of transaction pools: 1 |
2024-06-04 16:32:19 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions |
2024-06-04 16:32:19 0 [Note] InnoDB: Using liburing |
2024-06-04 16:32:19 0 [Note] InnoDB: Initializing buffer pool, total size = 47.000GiB, chunk size = 0.734GiB |
2024-06-04 16:32:19 0 [Note] InnoDB: Initialized memory pressure event listener |
2024-06-04 16:32:19 0 [Note] InnoDB: Completed initialization of buffer pool |
2024-06-04 16:32:19 0 [Note] InnoDB: Buffered log writes (block size=512 bytes) |
2024-06-04 16:32:19 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=246569381075 |
2024-06-04 16:32:21 0 [Note] InnoDB: End of log at LSN=247070097013 |
2024-06-04 16:32:21 0 [Note] InnoDB: To recover: 27399 pages |
2024-06-04 16:32:21 0 [Note] InnoDB: Last binlog file '/srv/mysql/binlog/mariadb-bin.037958', position 50435899 |
2024-06-04 16:32:21 0 [Note] InnoDB: 128 rollback segments are active. |
2024-06-04 16:32:21 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" |
2024-06-04 16:32:21 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... |
2024-06-04 16:32:21 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. |
2024-06-04 16:32:21 0 [Note] InnoDB: log sequence number 247070097013; transaction id 254442803 |
2024-06-04 16:32:21 0 [Note] Plugin 'FEEDBACK' is disabled. |
2024-06-04 16:32:21 0 [Note] InnoDB: Loading buffer pool(s) from /srv/mysql/data/ib_buffer_pool |
240604 16:32:21 server_audit: MariaDB Audit Plugin version 1.4.14 STARTED. |
240604 16:32:21 server_audit: logging started to the file /srv/mysql/log/audit.log. |
2024-06-04 16:32:21 0 [Note] RocksDB: 2 column families found |
2024-06-04 16:32:21 0 [Note] RocksDB: Column Families at start: |
2024-06-04 16:32:21 0 [Note] cf=default |
2024-06-04 16:32:21 0 [Note] write_buffer_size=67108864 |
2024-06-04 16:32:21 0 [Note] target_file_size_base=67108864 |
2024-06-04 16:32:21 0 [Note] cf=__system__ |
2024-06-04 16:32:21 0 [Note] write_buffer_size=67108864 |
2024-06-04 16:32:21 0 [Note] target_file_size_base=67108864 |
2024-06-04 16:32:24 0 [Note] RocksDB: Table_store: loaded DDL data for 27 tables |
2024-06-04 16:32:24 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer |
2024-06-04 16:32:24 0 [Note] MyRocks storage engine plugin has been successfully initialized. |
2024-06-04 16:32:24 0 [Note] Recovering after a crash using /srv/mysql/binlog/mariadb-bin |
2024-06-04 16:32:24 0 [Note] Starting table crash recovery... |
2024-06-04 16:32:24 0 [Note] Found 1 prepared transaction(s) in ROCKSDB |
2024-06-04 16:32:24 0 [Note] Crash table recovery finished. |
240604 16:32:24 [ERROR] mysqld 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 |
|
We will try our best to scrape up some info that will hopefully help |
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail. |
|
Server version: 10.11.8-MariaDB-ubu2204-log source revision: 3a069644682e336e445039e48baae9693f9a08ee |
key_buffer_size=134217728 |
read_buffer_size=2097152 |
max_used_connections=0 |
max_threads=1002 |
thread_count=2 |
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 6314105 K bytes of memory |
Hope that's ok; if not, decrease some variables in the equation. |
|
Thread pointer: 0x0 |
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went |
terribly wrong...
|
stack_bottom = 0x0 thread_stack 0x49000 |
/usr/sbin/mariadbd(my_print_stacktrace+0x32)[0x638c338470c2] |
/usr/sbin/mariadbd(handle_fatal_signal+0x478)[0x638c3330f8f8] |
libc_sigaction.c:0(__restore_rt)[0x729117842520] |
/usr/lib/mysql/plugin/ha_spider.so(_Z21spider_sys_open_tableP3THDP10TABLE_LISTPP15start_new_trans+0x1b)[0x72852c3583fb] |
/usr/lib/mysql/plugin/ha_spider.so(_Z21spider_open_sys_tableP3THDPKcibPP15start_new_transbPi+0xf6)[0x72852c358686] |
/usr/lib/mysql/plugin/ha_spider.so(_Z32spider_internal_xa_commit_by_xidP3THDP21st_spider_transactionP5xid_t+0x15b)[0x72852c3649db] |
/usr/lib/mysql/plugin/ha_spider.so(_Z23spider_xa_commit_by_xidP10handlertonP5xid_t+0x3f)[0x72852c3680bf] |
/usr/sbin/mariadbd(+0xaa3a75)[0x638c33311a75] |
/usr/sbin/mariadbd(_Z24plugin_foreach_with_maskP3THDPFcS0_P13st_plugin_intPvEijS3_+0x1a9)[0x638c330c4c59] |
/usr/sbin/mariadbd(+0xaa286f)[0x638c3331086f] |
/usr/sbin/mariadbd(my_hash_iterate+0x50)[0x638c33827bc0] |
/usr/sbin/mariadbd(_Z19ha_recover_completeP7st_hashPSt4pairIjyE+0x30)[0x638c333154d0] |
/usr/sbin/mariadbd(_ZN16Recovery_context8completeEP13MYSQL_BIN_LOGR7st_hash+0x6f)[0x638c334325cf] |
/usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG7recoverEP11st_log_infoPKcP11st_io_cacheP28Format_description_log_eventb+0x790)[0x638c334334e0] |
/usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG18do_binlog_recoveryEPKcb+0x303)[0x638c33433933] |
/usr/sbin/mariadbd(_ZN13MYSQL_BIN_LOG4openEPKc+0x3f)[0x638c33436cdf] |
/usr/sbin/mariadbd(+0x729012)[0x638c32f97012] |
/usr/sbin/mariadbd(_Z11mysqld_mainiPPc+0x41d)[0x638c32f9bc1d] |
nptl/libc_start_call_main.h:58(__libc_start_call_main)[0x729117829d90] |
csu/libc-start.c:128(call_init)[0x729117829e40] |
/usr/sbin/mariadbd(_start+0x25)[0x638c32f905f5] |
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains |
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /srv/mysql/data
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes |
Max core file size 0 unlimited bytes |
Max resident set unlimited unlimited bytes
|
Max processes 255010 255010 processes |
Max open files 32768 32768 files |
Max locked memory 524288 524288 bytes |
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 255010 255010 signals |
Max msgqueue size 819200 819200 bytes |
Max nice priority 0 0 |
Max realtime priority 0 0 |
Max realtime timeout unlimited unlimited us
|
Core pattern: |/usr/share/apport/apport -p%p -s%s -c%c -d%d -P%P -u%u -g%g -- %E
|
|
Kernel version: Linux version 6.5.0-35-generic (buildd@lcy02-amd64-079) (x86_64-linux-gnu-gcc-12 (Ubuntu 12.3.0-1ubuntu1~22.04) 12.3.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #35~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 7 09:00:52 UTC 2 |
Attachments
Issue Links
- relates to
-
MDEV-32822 Crash signal 11 in spider_sys_open_table from spider_internal_xa_rollback_by_xid during recovery after crash
-
- Open
-