Nov 15 13:40:17 1011atc2 mariadbd[31966]: 241115 13:40:17 [ERROR] mysqld got signal 11 ; Nov 15 13:40:17 1011atc2 mariadbd[31966]: Sorry, we probably made a mistake, and this is a bug. Nov 15 13:40:17 1011atc2 mariadbd[31966]: Your assistance in bug reporting will enable us to fix this for the next release. Nov 15 13:40:17 1011atc2 mariadbd[31966]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Nov 15 13:40:17 1011atc2 mariadbd[31966]: We will try our best to scrape up some info that will hopefully help Nov 15 13:40:17 1011atc2 mariadbd[31966]: diagnose the problem, but since we have already crashed, Nov 15 13:40:17 1011atc2 mariadbd[31966]: something is definitely wrong and this may fail. Nov 15 13:40:17 1011atc2 mariadbd[31966]: Server version: 10.6.20-MariaDB source revision: f00711bba2cd383825d0be1867f7d7d7f641c9e4 Nov 15 13:40:17 1011atc2 mariadbd[31966]: key_buffer_size=134217728 Nov 15 13:40:17 1011atc2 mariadbd[31966]: read_buffer_size=131072 Nov 15 13:40:17 1011atc2 mariadbd[31966]: max_used_connections=6 Nov 15 13:40:17 1011atc2 mariadbd[31966]: max_threads=34 Nov 15 13:40:17 1011atc2 mariadbd[31966]: thread_count=8 Nov 15 13:40:17 1011atc2 mariadbd[31966]: It is possible that mysqld could use up to Nov 15 13:40:17 1011atc2 mariadbd[31966]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 205927 K bytes of memory Nov 15 13:40:17 1011atc2 mariadbd[31966]: Hope that's ok; if not, decrease some variables in the equation. Nov 15 13:40:17 1011atc2 mariadbd[31966]: Thread pointer: 0x7f2bbc0008f8 Nov 15 13:40:17 1011atc2 mariadbd[31966]: Attempting backtrace. You can use the following information to find out Nov 15 13:40:17 1011atc2 mariadbd[31966]: where mysqld died. If you see no messages after this, something went Nov 15 13:40:17 1011atc2 mariadbd[31966]: terribly wrong... Nov 15 13:40:17 1011atc2 mariadbd[31966]: stack_bottom = 0x7f2c00567000 thread_stack 0x49000 Nov 15 13:40:22 1011atc2 mariadbd[31966]: /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x55a3b9162bbe] Nov 15 13:40:27 1011atc2 mariadbd[31966]: /usr/sbin/mariadbd(handle_fatal_signal+0x545)[0x55a3b8b8e445] Nov 15 13:40:43 1011atc2 mariadbd[31966]: /lib64/libc.so.6(+0x57980)[0x7f2c17a57980] Nov 15 13:40:44 1011atc2 mariadbd[31966]: spider/spd_db_conn.cc:7912(spider_db_print_item_type(Item*, Field*, ha_spider*, spider_string*, char const*, unsigned int, unsigned int, bool, spider_fields*))[0x7f2c0cdaf604] Nov 15 13:40:44 1011atc2 mariadbd[2883]: addr2line: DWARF error: unable to read alt ref 347212 Nov 15 13:40:44 1011atc2 mariadbd[31966]: spider/spd_db_mysql.cc:14161(spider_mbase_handler::append_group_by(st_order*, spider_string*, char const*, unsigned int, bool, spider_fields*))[0x7f2c0ce1b511] Nov 15 13:40:48 1011atc2 mariadbd[2883]: addr2line: DWARF error: unable to read alt ref 428777 Nov 15 13:40:49 1011atc2 mariadbd[31966]: /usr/lib64/mysql/plugin/ha_spider.so(_ZN23spider_group_by_handler9init_scanEv+0x3ff)[0x7f2c0ce1e70f] Nov 15 13:40:50 1011atc2 mariadbd[2883]: addr2line: DWARF error: unable to read alt ref 347212 Nov 15 13:40:53 1011atc2 mariadbd[2883]: addr2line: DWARF error: unable to read alt ref 347212 Nov 15 13:41:00 1011atc2 mariadbd[31966]: /usr/sbin/mariadbd(_ZN14Pushdown_query7executeEP4JOIN+0x33)[0x55a3b89d23e3] Nov 15 13:41:05 1011atc2 mariadbd[31966]: /usr/sbin/mariadbd(_ZN4JOIN10exec_innerEv+0x84e)[0x55a3b89b1c3e] Nov 15 13:41:08 1011atc2 mariadbd[31966]: sql/group_by_handler.cc:49(Pushdown_query::execute(JOIN*))[0x55a3b89b2609] Nov 15 13:41:08 1011atc2 mariadbd[31966]: sql/sql_select.cc:21807(JOIN::exec_inner())[0x55a3b89b0839] Nov 15 13:41:08 1011atc2 mariadbd[31966]: sql/sql_select.cc:4715(JOIN::exec())[0x55a3b89b0fe1] Nov 15 13:41:08 1011atc2 mariadbd[31966]: sql/sql_select.cc:5195(mysql_select(THD*, TABLE_LIST*, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55a3b8946c61] Nov 15 13:41:08 1011atc2 mariadbd[31966]: sql/sql_select.cc:573(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55a3b8942388] Nov 15 13:41:08 1011atc2 mariadbd[31966]: sql/sql_parse.cc:6408(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55a3b894a746] Nov 15 13:41:08 1011atc2 mariadbd[31966]: sql/sql_parse.cc:3999(mysql_execute_command(THD*, bool))[0x55a3b893dad5] Nov 15 13:41:08 1011atc2 mariadbd[31966]: sql/sql_parse.cc:8211(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55a3b893b665] Nov 15 13:41:08 1011atc2 mariadbd[31966]: sql/sql_parse.cc:1879(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55a3b8a5ded5] Nov 15 13:41:08 1011atc2 mariadbd[31966]: sql/sql_parse.cc:1423(do_command(THD*, bool))[0x55a3b8a5e234] Nov 15 13:41:08 1011atc2 mariadbd[31966]: sql/sql_connect.cc:1407(do_handle_one_connection(CONNECT*, bool))[0x55a3b8df70ed] Nov 15 13:41:11 1011atc2 mariadbd[31966]: /lib64/libc.so.6(+0xa760c)[0x7f2c17aa760c] Nov 15 13:41:11 1011atc2 mariadbd[31966]: /lib64/libc.so.6(+0x12eaa8)[0x7f2c17b2eaa8] Nov 15 13:41:11 1011atc2 mariadbd[31966]: Trying to get some variables. Nov 15 13:41:11 1011atc2 mariadbd[31966]: Some pointers may be invalid and cause the dump to abort. Nov 15 13:41:11 1011atc2 mariadbd[31966]: Query (0x7f2bbc0492e0): SELECT DISTINCT t1.`ID` FROM JAX_FORM_RESOURCES t1 WHERE (t1.`ID` LIKE 'resources/SYSTEM/SCHEDULER_JOBS_FORM/V%') Nov 15 13:41:11 1011atc2 mariadbd[31966]: Connection ID (thread ID): 215 Nov 15 13:41:11 1011atc2 mariadbd[31966]: Status: NOT_KILLED Nov 15 13:41:11 1011atc2 mariadbd[31966]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=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=off,cset_narrowing=off Nov 15 13:41:11 1011atc2 mariadbd[31966]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains Nov 15 13:41:11 1011atc2 mariadbd[31966]: information that should help you find out what is causing the crash. Nov 15 13:41:11 1011atc2 kernel: mariadbd[2879]: segfault at 0 ip 00007f2c0cdaf604 sp 00007f2c00564200 error 4 in ha_spider.so[7f2c0cd47000+f8000] likely on CPU 0 (core 0, socket 0) Nov 15 13:41:11 1011atc2 kernel: Code: 41 54 49 89 fd 53 49 89 cc 48 89 d3 48 83 ec 28 8b 45 18 48 89 75 b8 4c 89 45 c8 44 89 4d c4 44 8b 75 10 4c 8b 7d 20 89 45 c0 <48> 8b 07 ff 90 d8 00 00 00 83 f8 0c 74 2e 49 8b 45 00 4c 89 ef ff Nov 15 13:41:11 1011atc2 mariadbd[31966]: Writing a core file... Nov 15 13:41:11 1011atc2 mariadbd[31966]: Working directory at /var/lib/mysql Nov 15 13:41:11 1011atc2 mariadbd[31966]: Resource Limits: Nov 15 13:41:11 1011atc2 mariadbd[31966]: Limit Soft Limit Hard Limit Units Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max cpu time unlimited unlimited seconds Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max file size unlimited unlimited bytes Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max data size unlimited unlimited bytes Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max stack size 8388608 unlimited bytes Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max core file size unlimited unlimited bytes Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max resident set unlimited unlimited bytes Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max processes 15573 15573 processes Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max open files 32768 32768 files Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max locked memory 8388608 8388608 bytes Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max address space unlimited unlimited bytes Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max file locks unlimited unlimited locks Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max pending signals 15573 15573 signals Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max msgqueue size 819200 819200 bytes Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max nice priority 0 0 Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max realtime priority 0 0 Nov 15 13:41:11 1011atc2 mariadbd[31966]: Max realtime timeout unlimited unlimited us Nov 15 13:41:11 1011atc2 mariadbd[31966]: Core pattern: |/bin/false Nov 15 13:41:11 1011atc2 mariadbd[31966]: Kernel version: Linux version 6.4.0-150600.23.25-default (geeko@buildhost) (gcc (SUSE Linux) 7.5.0, GNU ld (GNU Binutils; SUSE Linux Enterprise 15) 2.43.1.20240828-150100.7.49) #1 SMP PREEMPT_DYNAMIC Tue Oct 1 10:54:01 UTC 2024 (ea7c56d) Nov 15 13:41:11 1011atc2 systemd[1]: mariadb.service: Main process exited, code=dumped, status=11/SEGV Nov 15 13:41:11 1011atc2 systemd[1]: mariadb.service: Failed with result 'core-dump'. Nov 15 13:41:11 1011atc2 systemd[1]: mariadb.service: Consumed 3min 24.852s CPU time. Nov 15 13:41:16 1011atc2 systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 5. Nov 15 13:41:16 1011atc2 systemd[1]: Starting MariaDB 10.6.20 database server... Nov 15 13:41:17 1011atc2 (mariadbd)[3018]: mariadb.service: Referenced but unset environment variable evaluates to an empty string: MYSQLD_OPTS, _WSREP_NEW_CLUSTER Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] Starting MariaDB 10.6.20-MariaDB source revision f00711bba2cd383825d0be1867f7d7d7f641c9e4 server_uid Ga47XwqU2OLahqo38T9RWMfKPkk= as process 3018 Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Warning] You need to use --log-bin to make --binlog-format work. Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] mariadbd: Aria engine: starting recovery Nov 15 13:41:17 1011atc2 mariadbd[3018]: recovered pages: 0% 12% 26% 40% 50% 63% 75% 89% 99% 100% (0.0 seconds); tables to flush: 1 0 Nov 15 13:41:17 1011atc2 mariadbd[3018]: (0.0 seconds); Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] mariadbd: Aria engine: recovery done Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Warning] InnoDB: innodb_open_files 268435456 should not be greater than the open_files_limit 32065 Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Number of pools: 1 Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Using Linux native AIO Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Completed initialization of buffer pool Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=5765334,5765334 Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: 128 rollback segments are active. Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: 10.6.20 started; log sequence number 5765414; transaction id 5464 Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] Plugin 'FEEDBACK' is disabled. Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] InnoDB: Buffer pool(s) load completed at 241115 13:41:17 Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files. Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Warning] 'innodb-buffer-pool-instances' was removed. It does nothing now and exists only for compatibility with old my.cnf files. Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Warning] 'innodb-buffer-pool-instances' was removed. It does nothing now and exists only for compatibility with old my.cnf files. Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Warning] 'innodb-locks-unsafe-for-binlog' was removed. It does nothing now and exists only for compatibility with old my.cnf files. Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Warning] 'innodb-undo-logs' was removed. It does nothing now and exists only for compatibility with old my.cnf files. Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] Recovering after a crash using tc.log Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] Starting table crash recovery... Nov 15 13:41:17 1011atc2 mariadbd[3018]: 2024-11-15 13:41:17 0 [Note] Crash table recovery finished. Nov 15 13:41:18 1011atc2 mariadbd[3018]: 2024-11-15 13:41:18 0 [Note] Server socket created on IP: '0.0.0.0'. Nov 15 13:41:18 1011atc2 mariadbd[3018]: 2024-11-15 13:41:18 0 [Warning] 'user' entry '@1011atc2' ignored in --skip-name-resolve mode. Nov 15 13:41:18 1011atc2 mariadbd[3018]: 2024-11-15 13:41:18 0 [Warning] 'proxies_priv' entry '@% mysql@1011atc2' ignored in --skip-name-resolve mode. Nov 15 13:41:18 1011atc2 mariadbd[3018]: 2024-11-15 13:41:18 0 [Note] /usr/sbin/mariadbd: ready for connections. Nov 15 13:41:18 1011atc2 mariadbd[3018]: Version: '10.6.20-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server Nov 15 13:41:18 1011atc2 systemd[1]: Started MariaDB 10.6.20 database server.