260227 17:42:08 [ERROR] /usr/local/mariadb/bin/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.4.10-MariaDB-log source revision: 054a893f1645b77e52a329a7fc8cf614eebd1fad

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: 0x7f8054013168
stack_bottom = 0x7f8d9c3a8000 thread_stack 0x49000
2026-02-27 17:42:09 0 [Note] /usr/local/mariadb/bin/mariadbd (initiated by: unknown): Normal shutdown
Printing to addr2line failed
/usr/local/mariadb/bin/mariadbd(my_print_stacktrace+0x2e) [0x55a5264bf47e]
/usr/local/mariadb/bin/mariadbd(handle_fatal_signal+0x22f) [0x55a525f11dcf]
/lib/x86_64-linux-gnu/libc.so.6(+0x3fdf0) [0x7f8da044adf0]
/usr/local/mariadb/bin/mariadbd(+0xe0b4fb) [0x55a52620b4fb]
/usr/local/mariadb/bin/mariadbd(_ZN7handler10ha_rnd_posEPhS0_+0x292) [0x55a525f19d12]
/usr/local/mariadb/bin/mariadbd(_Z16rr_from_pointersP11READ_RECORD+0x2a) [0x55a525be7b7a]
/usr/local/mariadb/bin/mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x1f1) [0x55a525cee6e1]
/usr/local/mariadb/bin/mariadbd(_ZN4JOIN10exec_innerEv+0xb8f) [0x55a525d21fdf]
/usr/local/mariadb/bin/mariadbd(_ZN4JOIN4execEv+0x33) [0x55a525d222e3]
/usr/local/mariadb/bin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x22d) [0x55a525d2089d]
/usr/local/mariadb/bin/mariadbd(+0x869909) [0x55a525c69909]
/usr/local/mariadb/bin/mariadbd(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0xbd) [0x55a525c6936d]
/usr/local/mariadb/bin/mariadbd(_ZN13st_join_table12preread_initEv+0x79) [0x55a525cee419]
/usr/local/mariadb/bin/mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x368) [0x55a525cee858]
/usr/local/mariadb/bin/mariadbd(_ZN4JOIN10exec_innerEv+0xb8f) [0x55a525d21fdf]
/usr/local/mariadb/bin/mariadbd(_ZN4JOIN4execEv+0x33) [0x55a525d222e3]
/usr/local/mariadb/bin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x22d) [0x55a525d2089d]
/usr/local/mariadb/bin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x1e4) [0x55a525d21084]
/usr/local/mariadb/bin/mariadbd(+0x73a6b7) [0x55a525b3a6b7]
/usr/local/mariadb/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x3323) [0x55a525caf3b3]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x38) [0x55a525e44568]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instrb+0x178) [0x55a525e46918]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_lex_keeper26validate_lex_and_exec_coreEP3THDPjbP12sp_lex_instr+0x11a) [0x55a525e477aa]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_instr_stmt7executeEP3THDPj+0x60e) [0x55a525e4805e]
/usr/local/mariadb/bin/mariadbd(_ZN7sp_head7executeEP3THDb+0xb04) [0x55a525c035a4]
/usr/local/mariadb/bin/mariadbd(_ZN7sp_head16execute_functionEP3THDPP4ItemjP5FieldPP11sp_rcontextP11Query_arena+0x623) [0x55a525c058c3]
/usr/local/mariadb/bin/mariadbd(_ZN7Item_sp12execute_implEP3THDPP4Itemj+0x135) [0x55a525f33e65]
/usr/local/mariadb/bin/mariadbd(_ZN7Item_sp7executeEP3THDPbPP4Itemj+0x21) [0x55a525f340a1]
/usr/local/mariadb/bin/mariadbd(_ZN12Item_func_sp7val_strEP6String+0x57) [0x55a525f9e4d7]
/usr/local/mariadb/bin/mariadbd(_ZN4Item17save_str_in_fieldEP5Fieldb+0x61) [0x55a525f39751]
/usr/local/mariadb/bin/mariadbd(_ZN4Item13save_in_fieldEP5Fieldb+0x36) [0x55a525f2bba6]
/usr/local/mariadb/bin/mariadbd(_Z11fill_recordP3THDP5TABLER4ListI4ItemES6_bb+0x2f1) [0x55a525c3ec91]
/usr/local/mariadb/bin/mariadbd(_Z36fill_record_n_invoke_before_triggersP3THDP5TABLER4ListI4ItemES6_b14trg_event_type+0x39) [0x55a525c3f009]
/usr/local/mariadb/bin/mariadbd(_ZN14Sql_cmd_update19update_single_tableEP3THD+0x1d17) [0x55a525d80e77]
/usr/local/mariadb/bin/mariadbd(_ZN14Sql_cmd_update13execute_innerEP3THD+0x11d) [0x55a525d8199d]
/usr/local/mariadb/bin/mariadbd(_ZN11Sql_cmd_dml7executeEP3THD+0x1bf) [0x55a525ce396f]
/usr/local/mariadb/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x29ca) [0x55a525caea5a]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x38) [0x55a525e44568]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instrb+0x178) [0x55a525e46918]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_lex_keeper26validate_lex_and_exec_coreEP3THDPjbP12sp_lex_instr+0x11a) [0x55a525e477aa]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_instr_stmt7executeEP3THDPj+0x60e) [0x55a525e4805e]
/usr/local/mariadb/bin/mariadbd(_ZN7sp_head7executeEP3THDb+0xb04) [0x55a525c035a4]
/usr/local/mariadb/bin/mariadbd(_ZN7sp_head15execute_triggerEP3THDPK25st_mysql_const_lex_stringS4_P13st_grant_info+0x1eb) [0x55a525c0442b]
/usr/local/mariadb/bin/mariadbd(_ZN19Table_triggers_list16process_triggersEP3THD14trg_event_type20trg_action_time_typeb+0x125) [0x55a525d68855]
/usr/local/mariadb/bin/mariadbd(_ZN14Sql_cmd_update19update_single_tableEP3THD+0x1efa) [0x55a525d8105a]
/usr/local/mariadb/bin/mariadbd(_ZN14Sql_cmd_update13execute_innerEP3THD+0x11d) [0x55a525d8199d]
/usr/local/mariadb/bin/mariadbd(_ZN11Sql_cmd_dml7executeEP3THD+0x1bf) [0x55a525ce396f]
/usr/local/mariadb/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x29ca) [0x55a525caea5a]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x38) [0x55a525e44568]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instrb+0x178) [0x55a525e46918]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_lex_keeper26validate_lex_and_exec_coreEP3THDPjbP12sp_lex_instr+0x11a) [0x55a525e477aa]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_instr_stmt7executeEP3THDPj+0x60e) [0x55a525e4805e]
/usr/local/mariadb/bin/mariadbd(_ZN7sp_head7executeEP3THDb+0xb04) [0x55a525c035a4]
/usr/local/mariadb/bin/mariadbd(_ZN7sp_head15execute_triggerEP3THDPK25st_mysql_const_lex_stringS4_P13st_grant_info+0x1eb) [0x55a525c0442b]
/usr/local/mariadb/bin/mariadbd(_ZN19Table_triggers_list16process_triggersEP3THD14trg_event_type20trg_action_time_typeb+0x125) [0x55a525d68855]
/usr/local/mariadb/bin/mariadbd(_ZN12Write_record26insert_on_duplicate_updateEPyS0_+0x222) [0x55a525c72002]
/usr/local/mariadb/bin/mariadbd(_ZN12Write_record12write_recordEv+0xcd) [0x55a525c722cd]
/usr/local/mariadb/bin/mariadbd(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesbP13select_result+0x1ecb) [0x55a525c7a15b]
/usr/local/mariadb/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x30cd) [0x55a525caf15d]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x38) [0x55a525e44568]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instrb+0x178) [0x55a525e46918]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_lex_keeper26validate_lex_and_exec_coreEP3THDPjbP12sp_lex_instr+0x11a) [0x55a525e477aa]
/usr/local/mariadb/bin/mariadbd(_ZN13sp_instr_stmt7executeEP3THDPj+0x60e) [0x55a525e4805e]
/usr/local/mariadb/bin/mariadbd(_ZN7sp_head7executeEP3THDb+0xb04) [0x55a525c035a4]
/usr/local/mariadb/bin/mariadbd(_ZN7sp_head15execute_triggerEP3THDPK25st_mysql_const_lex_stringS4_P13st_grant_info+0x1eb) [0x55a525c0442b]
/usr/local/mariadb/bin/mariadbd(_ZN19Table_triggers_list16process_triggersEP3THD14trg_event_type20trg_action_time_typeb+0x125) [0x55a525d68855]
/usr/local/mariadb/bin/mariadbd(_ZN12Write_record13single_insertEPy+0xad) [0x55a525c71d4d]
/usr/local/mariadb/bin/mariadbd(_ZN12Write_record12write_recordEv+0xb1) [0x55a525c722b1]
/usr/local/mariadb/bin/mariadbd(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesbP13select_result+0x1ecb) [0x55a525c7a15b]
/usr/local/mariadb/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x30cd) [0x55a525caf15d]
/usr/local/mariadb/bin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x20b) [0x55a525cb126b]
/usr/local/mariadb/bin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x19b4) [0x55a525cb3c04]
/usr/local/mariadb/bin/mariadbd(_Z10do_commandP3THDb+0x12e) [0x55a525cb542e]
/usr/local/mariadb/bin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x16f) [0x55a525dc6d0f]
/usr/local/mariadb/bin/mariadbd(handle_one_connection+0x34) [0x55a525dc6fa4]
/usr/local/mariadb/bin/mariadbd(+0xd75c22) [0x55a526175c22]
/lib/x86_64-linux-gnu/libc.so.6(+0x92b7b) [0x7f8da049db7b]
/lib/x86_64-linux-gnu/libc.so.6(+0x1107b8) [0x7f8da051b7b8]

Connection ID (thread ID): 111622
Status: KILL_SERVER
Query (0x7f7ff64d4860): SELECT^M
      COALESCE(GROUP_CONCAT(CONCAT(a.regione, IF(a.provincie <> '', CONCAT(' (', a.provincie, ')'), ''), IF(a.esclusiva = 1, ' (*)', '')) ORDER BY a.regione), '') INTO @provincie^M
    FROM (SELECT^M
        r.id,^M
        r.codice AS regione,^M
        IF(MAX(solo.provincie_regione) <> COUNT(*), GROUP_CONCAT(sigla ORDER BY sigla SEPARATOR '-'), '') AS provincie,^M
        MAX(IF(cep.esclusiva, 1, 0)) AS esclusiva^M
      FROM antique.regioni r^M
        -- mi prendo solo le regioni dove ho qualcosa^M
        INNER JOIN (SELECT DISTINCT^M
            r.id,^M
            COUNT(*) AS provincie_regione^M
          FROM antique.contratti_editori_provincie cep^M
            INNER JOIN antique.provincie p^M
              ON cep.provinciaID = p.ID^M
            INNER JOIN antique.regioni r^M
              ON p.regioneID = r.id^M
              AND r.isonazione = 'IT'^M
          WHERE cep.contrattoEditoriID =  NAME_CONST('var_in_contrattoeditoriID',2055)^M
          GROUP BY r.id) solo^M
          ON r.id = solo.id^M
        INNER JOIN antique.provincie p^M
          ON r.ID = p.regioneID^M
          AND NOT p.deprecata^M
        INNER JOIN antique.contratti_editori_provincie cep^M
          ON p.id = cep.provinciaID^M
          AND cep.contrattoEditoriID =  NAME_CONST('var_in_contrattoeditoriID',2055)^M
      WHERE r.isonazione = 'IT'^M
      GROUP BY r.id) a

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=off,sargable_casefold=on

Writing a core file...
Working directory at /data/mariadb
Resource Limits (excludes unlimited resources):
Limit                     Soft Limit           Hard Limit           Units
Max stack size            8388608              unlimited            bytes
Max core file size        0                    unlimited            bytes
Max processes             353784               353784               processes
Max open files            65535                65535                files
Max locked memory         8388608              8388608              bytes
Max pending signals       353784               353784               signals
Max msgqueue size         819200               819200               bytes
Max nice priority         0                    0
Max realtime priority     0                    0
Core pattern: core

Kernel version: Linux version 6.12.73+deb13-amd64 (debian-kernel@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.73-1 (2026-02-17)

2026-02-27 17:43:01 0 [Note] Starting MariaDB 11.4.10-MariaDB-log source revision 054a893f1645b77e52a329a7fc8cf614eebd1fad server_uid C8aam3Zv7DDY5MWUdi6y2ZgqDzE= as process 548396
2026-02-27 17:43:01 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
2026-02-27 17:43:01 0 [Note] InnoDB: Number of transaction pools: 1
2026-02-27 17:43:01 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2026-02-27 17:43:01 0 [Note] InnoDB: Using Linux native AIO
2026-02-27 17:43:01 0 [Note] InnoDB: innodb_buffer_pool_size_max=49152m, innodb_buffer_pool_size=49152m
2026-02-27 17:43:03 0 [Note] InnoDB: Initialized memory pressure event listener
2026-02-27 17:43:03 0 [Note] InnoDB: Completed initialization of buffer pool
2026-02-27 17:43:03 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2026-02-27 17:43:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=212204613490286
2026-02-27 17:43:03 0 [Note] InnoDB: End of log at LSN=212204619224973
2026-02-27 17:43:03 0 [Note] InnoDB: To recover: 2551 pages
2026-02-27 17:43:04 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 2 row operations to undo
2026-02-27 17:43:04 0 [Note] InnoDB: Trx id counter is 22559740541
2026-02-27 17:43:04 0 [Note] InnoDB: Last binlog file '/data/replica/bin.003783', position 590485044
2026-02-27 17:43:04 0 [Note] InnoDB: Opened 3 undo tablespaces
2026-02-27 17:43:04 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2026-02-27 17:43:04 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
2026-02-27 17:43:04 0 [Note] InnoDB: Removed temporary tablespace data file: "/data/mariadb/ibtmp1"
2026-02-27 17:43:04 0 [Note] InnoDB: Setting file '/data/mariadb/ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2026-02-27 17:43:04 0 [Note] InnoDB: File '/data/mariadb/ibtmp1' size is now 12.000MiB.
2026-02-27 17:43:04 0 [Note] InnoDB: log sequence number 212204619224973; transaction id 22559740542
2026-02-27 17:43:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2026-02-27 17:43:04 0 [Note] InnoDB: Loading buffer pool(s) from /data/mariadb/ib_buffer_pool
2026-02-27 17:43:04 0 [Note] Plugin 'wsrep-provider' is disabled.
2026-02-27 17:43:04 0 [Note] Recovering after a crash using /data/replica/bin
2026-02-27 17:43:04 0 [Note] Starting table crash recovery...
2026-02-27 17:43:04 0 [Note] Crash table recovery finished.
2026-02-27 17:43:04 0 [Note] InnoDB: Rolled back recovered transaction 22559740532
2026-02-27 17:43:04 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2026-02-27 17:43:12 0 [Note] Server socket created on IP: '0.0.0.0', port: '3306'.
2026-02-27 17:43:12 0 [Note] Server socket created on IP: '::', port: '3306'.
2026-02-27 17:43:12 0 [Warning] 'user' entry '@mysqldata1.libroco.local' ignored in --skip-name-resolve mode.
2026-02-27 17:43:12 0 [Warning] 'proxies_priv' entry '@% root@mysqldata1.libroco.local' ignored in --skip-name-resolve mode.
2026-02-27 17:43:13 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2026-02-27 17:43:13 0 [Note] /usr/local/mariadb/bin/mariadbd: ready for connections.
Version: '11.4.10-MariaDB-log'  socket: '/var/run/mariadb/mariadb.sock'  port: 3306  MariaDB Server
2026-02-27 17:43:23 0 [Note] InnoDB: Buffer pool(s) load completed at 260227 17:43:23