Package: mariadb
Hello, I have a problem on some machines with MariaDB 1:11.8.1-2 : 3 physical machines : 2 are broken 1 virtual machine : is OK When I downgrade to 1:11.4.5-1 the installations are OK, but they are returning to KO at the next system upgrade. The "mariadbd" process quit with a core dump and is indefinitely trying to restart ... with no success and a new dump, I have to use systemctl stop mariadb to end it. I try to upgrade to the last Trixie version with no success, the server dumps immediately and I have to donwgrade again mariadb. Systems : Trixie always "up to date" until now. CPU on machines KO : - Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz + RAM 32Go - Intel(R) Core(TM) i5-7500 CPU @ 3.40GHz + RAM 16Go Kernel in use on all physical machines : - 6.12.20-amd64 Kernel in use on the VM : - 6.12.22-rt-amd64 Kernel in use on the physical machine OK : - 6.12.19-amd64 I join the error log. If a dump is needed I can get one easily. Regards JP P
2025-04-30 14:39:18 0 [Note] Starting MariaDB 11.8.1-MariaDB-2 source revision 1c4aed7c680c0402d6e97e097f03815c0e9bf4c5 server_uid jIuJ3YgYK0jDZho7wAdpkgK8+p0= as process 29270 2025-04-30 14:39:18 0 [Note] mariadbd: Aria engine: starting recovery recovered pages: 0% 10% 23% 33% 43% 54% 65% 76% 86% 97% 100% (0.0 seconds); tables to flush: 1 0 (0.0 seconds); 2025-04-30 14:39:18 0 [Note] mariadbd: Aria engine: recovery done 2025-04-30 14:39:18 0 [Note] CONNECT: Version 1.07.0002 March 22, 2021 2025-04-30 14:39:18 0 [Note] InnoDB: Compressed tables use zlib 1.3.1 2025-04-30 14:39:18 0 [Note] InnoDB: Using transactional memory 2025-04-30 14:39:18 0 [Note] InnoDB: Number of transaction pools: 1 2025-04-30 14:39:18 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2025-04-30 14:39:18 0 [Note] InnoDB: Using liburing 2025-04-30 14:39:18 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB 2025-04-30 14:39:18 0 [Note] InnoDB: Initialized memory pressure event listener 2025-04-30 14:39:18 0 [Note] InnoDB: Completed initialization of buffer pool 2025-04-30 14:39:18 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) 2025-04-30 14:39:18 0 [Note] InnoDB: End of log at LSN=1559235796 2025-04-30 14:39:18 0 [Note] InnoDB: Opened 3 undo tablespaces 2025-04-30 14:39:18 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active. 2025-04-30 14:39:18 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" 2025-04-30 14:39:18 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2025-04-30 14:39:18 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2025-04-30 14:39:18 0 [Note] InnoDB: log sequence number 1559235796; transaction id 844012 2025-04-30 14:39:18 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2025-04-30 14:39:18 0 [Note] RocksDB: 2 column families found 2025-04-30 14:39:18 0 [Note] RocksDB: Column Families at start: 2025-04-30 14:39:18 0 [Note] cf=default 2025-04-30 14:39:18 0 [Note] write_buffer_size=67108864 2025-04-30 14:39:18 0 [Note] target_file_size_base=67108864 2025-04-30 14:39:18 0 [Note] cf=__system__ 2025-04-30 14:39:18 0 [Note] write_buffer_size=67108864 2025-04-30 14:39:18 0 [Note] target_file_size_base=67108864 2025-04-30 14:39:19 0 [Note] InnoDB: Buffer pool(s) load completed at 250430 14:39:19 2025-04-30 14:39:19 0 [Note] RocksDB: Table_store: loaded DDL data for 0 tables 2025-04-30 14:39:19 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer 2025-04-30 14:39:19 0 [Note] MyRocks storage engine plugin has been successfully initialized. 2025-04-30 14:39:19 0 [Note] Plugin 'FEEDBACK' is disabled. 2025-04-30 14:39:19 0 [Warning] mariadbd: GSSAPI plugin : default principal 'mariadb/k2000.jpp.fr@' not found in keytab 2025-04-30 14:39:19 0 [ERROR] mariadbd: Server GSSAPI error (major 458752, minor 2529639093) : gss_acquire_cred failed -No credentials were supplied, or the credentials were unavailable or inaccessible. Keytab FILE:/etc/krb5.keytab is nonexistent or empty. 2025-04-30 14:39:19 0 [ERROR] Plugin 'gssapi' registration as a AUTHENTICATION failed. 2025-04-30 14:39:19 0 [Note] Plugin 'wsrep-provider' is disabled. 2025-04-30 14:39:19 0 [Note] Recovering after a crash using tc.log 2025-04-30 14:39:19 0 [Note] Starting table crash recovery... 2025-04-30 14:39:19 0 [Note] Crash table recovery finished. 250430 14:39:20 [ERROR] /usr/sbin/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.8.1-MariaDB-2 source revision: 1c4aed7c680c0402d6e97e097f03815c0e9bf4c5 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: 0x561dd630c7a8 stack_bottom = 0x7ffe8e539000 thread_stack 0x49000 /usr/sbin/mariadbd(my_print_stacktrace+0x32) [0x561db451c442] /usr/sbin/mariadbd(handle_fatal_signal+0x1a3) [0x561db3fb6f83] /lib/x86_64-linux-gnu/libc.so.6(+0x3fdf0) [0x7fe7af649df0] /usr/sbin/mariadbd(_Z9get_fieldP11st_mem_rootP5Field+0x17) [0x561db3e27927] /usr/sbin/mariadbd(+0x9f071c) [0x561db3e5b71c] /usr/sbin/mariadbd(_Z14servers_reloadP3THD+0x24a) [0x561db3e5d61a] /usr/sbin/mariadbd(_Z12servers_initb+0x14f) [0x561db3e5d7ef] /usr/sbin/mariadbd(+0x786c37) [0x561db3bf1c37] /usr/sbin/mariadbd(_Z11mysqld_mainiPPc+0x44c) [0x561db3bf723c] /lib/x86_64-linux-gnu/libc.so.6(+0x29ca8) [0x7fe7af633ca8] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85) [0x7fe7af633d65] /usr/sbin/mariadbd(_start+0x21) [0x561db3beaee1] Connection ID (thread ID): 0 Status: NOT_KILLED Query (0x561db461a4d4): intern:servers_init Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=on,cset_narrowing=on,sargable_casefold=on Writing a core file... Working directory at /var/lib/mysql Resource Limits (excludes unlimited resources): Limit Soft Limit Hard Limit Units Max stack size 8388608 unlimited bytes Max processes 127662 127662 processes Max open files 32768 32768 files Max locked memory 524288 524288 bytes Max pending signals 127662 127662 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 Kernel version: Linux version 6.12.20-amd64 (debian-ker...@lists.debian.org) (x86_64-linux-gnu-gcc-14 (Debian 14.2.0-19) 14.2.0, GNU ld (GNU Binutils for Debian) 2.44) #1 SMP PREEMPT_DYNAMIC Debian 6.12.20-1 (2025-03-23)
