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
|
Bug
Major
