250831 6:08:31 [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.3-MariaDB-ubu2204-log source revision: b565b3e7e041c480fd8013e3beec6b99544d6bf8 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: 0x7fe7d02c4248 stack_bottom = 0x7fe8b1a47000 thread_stack 0x80000 2025-08-31 6:08:32 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown /usr/sbin/mariadbd(my_print_stacktrace+0x30)[0x55fc0971d200] /usr/sbin/mariadbd(handle_fatal_signal+0x365)[0x55fc09295455] /lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7fefa4603520] /usr/sbin/mariadbd(_ZN8ha_maria10drop_tableEPKc+0x21)[0x55fc0943dae1] /usr/sbin/mariadbd(_Z14free_tmp_tableP3THDP5TABLE+0xda)[0x55fc08ff8d8a] /usr/sbin/mariadbd(_ZN4JOIN7cleanupEb+0x2c6)[0x55fc08fec316] /usr/sbin/mariadbd(_ZN4JOIN9join_freeEv+0x160)[0x55fc08fec880] /usr/sbin/mariadbd(_ZN4JOIN10exec_innerEv+0xd75)[0x55fc08fca2e5] /usr/sbin/mariadbd(_ZN4JOIN4execEv+0x37)[0x55fc08fca727] /usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x136)[0x55fc08fd50e6] /usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x189)[0x55fc08fba199] /usr/sbin/mariadbd(+0x82f2c5)[0x55fc08f772c5] /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x3db4)[0x55fc08f80474] /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x7be)[0x55fc08f81d4e] /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xb6e)[0x55fc08f8390e] /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x1ac)[0x55fc08f6dd9c] /usr/sbin/mariadbd(_Z11tp_callbackP13TP_connection+0xbc)[0x55fc09209d9c] /usr/sbin/mariadbd(+0xcdc0bd)[0x55fc094240bd] /usr/sbin/mariadbd(+0xd86adc)[0x55fc094ceadc] /lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7fefa4655ac3] /lib/x86_64-linux-gnu/libc.so.6(+0x126850)[0x7fefa46e7850] Connection ID (thread ID): 480842 Status: KILL_SERVER Query (0x7fe7d02d0b70): SELECT c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2504 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC 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 core file size 0 0 bytes Max processes 655360 655360 processes Max open files 300000 300000 files Max locked memory 524288 524288 bytes Max pending signals 256558 256558 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Core pattern: |/usr/share/apport/apport -p%p -s%s -c%c -d%d -P%P -u%u -g%g -F%F -- %E Kernel version: Linux version 5.15.0-153-generic (buildd@lcy02-amd64-105) (gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #163-Ubuntu SMP Thu Aug 7 16:37:18 UTC 2025 2025-08-31 6:11:16 0 [Note] Starting MariaDB 11.8.3-MariaDB-ubu2204-log source revision b565b3e7e041c480fd8013e3beec6b99544d6bf8 server_uid f9/RKB8VNei8V1hazQQW4bAP/1U= as process 4013023 2025-08-31 6:11:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2025-08-31 6:11:16 0 [Note] InnoDB: Number of transaction pools: 1 2025-08-31 6:11:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2025-08-31 6:11:16 0 [Note] InnoDB: Using io_uring 2025-08-31 6:11:16 0 [Note] InnoDB: innodb_buffer_pool_size_max=12736m, innodb_buffer_pool_size=12736m 2025-08-31 6:11:16 0 [Note] InnoDB: Completed initialization of buffer pool 2025-08-31 6:11:17 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes) 2025-08-31 6:11:17 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=393183093557 2025-08-31 6:11:17 0 [Note] InnoDB: End of log at LSN=393211985144 2025-08-31 6:11:17 0 [Note] InnoDB: To recover: 5427 pages 2025-08-31 6:11:17 0 [Note] InnoDB: Opened 3 undo tablespaces 2025-08-31 6:11:17 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active. 2025-08-31 6:11:17 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1" 2025-08-31 6:11:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2025-08-31 6:11:17 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2025-08-31 6:11:17 0 [Note] InnoDB: log sequence number 393211985144; transaction id 1863320655 2025-08-31 6:11:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2025-08-31 6:11:17 0 [Note] Plugin 'wsrep-provider' is disabled. 2025-08-31 6:11:17 0 [Note] Recovering after a crash using tc.log 2025-08-31 6:11:17 0 [Note] Starting table crash recovery... 2025-08-31 6:11:17 0 [Note] Crash table recovery finished. 2025-08-31 6:11:20 0 [Note] Server socket created on IP: '127.0.0.1', port: '3306'. 2025-08-31 6:11:20 0 [Note] mariadbd: Event Scheduler: Loaded 0 events 2025-08-31 6:11:20 0 [Note] /usr/sbin/mariadbd: ready for connections. Version: '11.8.3-MariaDB-ubu2204-log' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2025-08-31 6:11:34 0 [Note] InnoDB: Buffer pool(s) load completed at 250831 6:11:34