MariaDB Server Crashes Calling Stored Procedure

2025-08-14 23:40:02 0 [Note] Starting MariaDB 11.8.3-MariaDB source revision b565b3e7e041c480fd8013e3beec6b99544d6bf8 server_uid zMPRzbEjY/J0pwAy4igsPmTEt4I= as process 1824

2025-08-14 23:40:02 0 [Note] mariadbd: Aria engine: starting recovery

recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% (0.0 seconds); tables to flush: 1 0 (0.0 seconds); 

2025-08-14 23:40:02 0 [Note] mariadbd: Aria engine: recovery done

2025-08-14 23:40:02 0 [Note] InnoDB: Compressed tables use zlib 1.3.1

2025-08-14 23:40:02 0 [Note] InnoDB: Number of transaction pools: 1

2025-08-14 23:40:02 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2025-08-14 23:40:02 0 [Note] InnoDB: Using io_uring

2025-08-14 23:40:02 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m

2025-08-14 23:40:02 0 [Note] InnoDB: Initialized memory pressure event listener

2025-08-14 23:40:02 0 [Note] InnoDB: Completed initialization of buffer pool

2025-08-14 23:40:02 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)

2025-08-14 23:40:02 0 [Note] InnoDB: End of log at LSN=302267

2025-08-14 23:40:02 0 [Note] InnoDB: Opened 3 undo tablespaces

2025-08-14 23:40:02 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.

2025-08-14 23:40:02 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"

2025-08-14 23:40:02 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...

2025-08-14 23:40:02 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.

2025-08-14 23:40:02 0 [Note] InnoDB: log sequence number 302267; transaction id 1284

2025-08-14 23:40:02 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2025-08-14 23:40:02 0 [Note] Plugin 'wsrep-provider' is disabled.

2025-08-14 23:40:02 0 [Note] Recovering after a crash using tc.log

2025-08-14 23:40:02 0 [Note] Starting table crash recovery...

2025-08-14 23:40:02 0 [Note] Crash table recovery finished.

2025-08-14 23:40:02 0 [Note] InnoDB: Buffer pool(s) load completed at 250814 23:40:02

2025-08-14 23:40:03 0 [Note] Server socket created on IP: '0.0.0.0', port: '3306'.

2025-08-14 23:40:03 0 [Note] Server socket created on IP: '::', port: '3306'.

2025-08-14 23:40:03 0 [Note] mariadbd: Event Scheduler: Loaded 33 events

2025-08-14 23:40:03 1 [Note] Event Scheduler: scheduler thread started with id 1

2025-08-14 23:40:03 0 [Note] /usr/bin/mariadbd: ready for connections.

Version: '11.8.3-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Arch Linux

2025-08-14 23:40:11 4 [ERROR] mariadbd: Table './greenlight/rdgs' is marked as crashed and should be repaired

2025-08-14 23:40:11 4 [Warning] Checking table:   './greenlight/rdgs'

2025-08-14 23:40:11 4 [Warning] greenlight.rdgs: 1 client is using or hasn't closed the table properly

2025-08-14 23:40:11 4 [Note] greenlight.rdgs: Table is fixed

2025-08-14 23:40:27 13 [ERROR] mariadbd: Table './greenlight/pg_acs_log' is marked as crashed and should be repaired

2025-08-14 23:40:27 13 [Warning] Checking table:   './greenlight/pg_acs_log'

2025-08-14 23:40:55 20 [ERROR] mariadbd: Table './greenlight/eqm_stat_brg_rdgs_date_brg' is marked as crashed and should be repaired

2025-08-14 23:40:55 20 [Warning] Checking table:   './greenlight/eqm_stat_brg_rdgs_date_brg'

2025-08-14 23:40:55 20 [Warning] greenlight.eqm_stat_brg_rdgs_date_brg: 1 client is using or hasn't closed the table properly

2025-08-14 23:40:55 20 [Note] greenlight.eqm_stat_brg_rdgs_date_brg: Table is fixed

2025-08-14 23:40:55 20 [ERROR] mariadbd: Table './greenlight/eqm_stat_brg' is marked as crashed and should be repaired

2025-08-14 23:40:55 20 [Warning] Checking table:   './greenlight/eqm_stat_brg'

2025-08-14 23:40:55 20 [Warning] greenlight.eqm_stat_brg: 1 client is using or hasn't closed the table properly

2025-08-14 23:40:55 20 [Note] greenlight.eqm_stat_brg: Table is fixed

2025-08-14 23:40:55 20 [ERROR] mariadbd: Table './greenlight/crds' is marked as crashed and should be repaired

2025-08-14 23:40:55 20 [Warning] Checking table:   './greenlight/crds'

2025-08-14 23:40:55 20 [Warning] greenlight.crds: 1 client is using or hasn't closed the table properly

2025-08-14 23:40:55 20 [Note] greenlight.crds: Table is fixed

2025-08-14 23:44:06 76 [ERROR] mariadbd: Table './greenlight/io_log' is marked as crashed and should be repaired

2025-08-14 23:44:06 76 [Warning] Checking table:   './greenlight/io_log'

2025-08-14 23:44:06 76 [Warning] greenlight.io_log: 1 client is using or hasn't closed the table properly

2025-08-14 23:44:06 76 [Note] greenlight.io_log: Table is fixed

2025-08-14 23:44:48 167 [ERROR] mariadbd: Table './greenlight/eqm_com_log' is marked as crashed and should be repaired

2025-08-14 23:44:48 167 [Warning] Checking table:   './greenlight/eqm_com_log'

250814 23:45:06 [ERROR] /usr/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.8.3-MariaDB 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: 0x7f81e2617f18

stack_bottom = 0x7f7ea9200000 thread_stack 0x4000000

/usr/bin/mariadbd(my_print_stacktrace+0x31) [0x55568d2137f1]

/usr/bin/mariadbd(handle_fatal_signal+0x1e2) [0x55568cd7fa42]

/usr/lib/libc.so.6(+0x3e540) [0x7f8252a3e540]

/usr/bin/mariadbd(_ZNK10Item_field11used_tablesEv+0xb) [0x55568cd90cab]

/usr/bin/mariadbd(_ZN10Item_field15fix_outer_fieldEP3THDPP5FieldPP4Item+0x420) [0x55568cdab7b0]

/usr/bin/mariadbd(_ZN10Item_field10fix_fieldsEP3THDPP4Item+0x5c3) [0x55568cdac7a3]

/usr/bin/mariadbd(_ZN9Item_func10fix_fieldsEP3THDPP4Item+0xe9) [0x55568cdf1689]

/usr/bin/mariadbd(_ZN9Item_cond10fix_fieldsEP3THDPP4Item+0x25e) [0x55568cdcf1ae]

/usr/bin/mariadbd(_Z11setup_condsP3THDP10TABLE_LISTR4ListIS1_EPP4Item+0x210) [0x55568ca15610]

/usr/bin/mariadbd(_ZN4JOIN7prepareEP10TABLE_LISTP4ItemjP8st_orderbS5_S3_S5_P13st_select_lexP18st_select_lex_unit+0x8fa) [0x55568cae146a]

/usr/bin/mariadbd(_ZN30subselect_single_select_engine7prepareEP3THD+0x404) [0x55568ce4faf4]

/usr/bin/mariadbd(_ZN14Item_subselect10fix_fieldsEP3THDPP4Item+0x150) [0x55568ce49ab0]

/usr/bin/mariadbd(_Z17create_view_fieldP3THDP10TABLE_LISTPP4ItemP25st_mysql_const_lex_string+0x69) [0x55568cbcec39]

/usr/bin/mariadbd(_Z23find_field_in_table_refP3THDP10TABLE_LISTRK16Lex_ident_columnPKcS7_S7_P4ListIS1_EPP4ItembbPtbPS2_+0x117) [0x55568ca08ff7]

/usr/bin/mariadbd(_Z20find_field_in_tablesP3THDP10Item_identP10TABLE_LISTS4_P4ListIS3_EPP4Item27find_item_error_report_typebb+0x166) [0x55568ca0a0d6]

/usr/bin/mariadbd(_ZN10Item_field10fix_fieldsEP3THDPP4Item+0x1dc) [0x55568cdac3bc]

/usr/bin/mariadbd(_ZN9Item_func10fix_fieldsEP3THDPP4Item+0xe9) [0x55568cdf1689]

/usr/bin/mariadbd(_ZN9Item_cond10fix_fieldsEP3THDPP4Item+0x25e) [0x55568cdcf1ae]

/usr/bin/mariadbd(_ZN9Item_cond10fix_fieldsEP3THDPP4Item+0x25e) [0x55568cdcf1ae]

/usr/bin/mariadbd(_Z11setup_condsP3THDP10TABLE_LISTR4ListIS1_EPP4Item+0x210) [0x55568ca15610]

/usr/bin/mariadbd(_ZN4JOIN7prepareEP10TABLE_LISTP4ItemjP8st_orderbS5_S3_S5_P13st_select_lexP18st_select_lex_unit+0x8fa) [0x55568cae146a]

/usr/bin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x5bc) [0x55568caeac0c]

/usr/bin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x1a9) [0x55568cacfc39]

/usr/bin/mariadbd(+0x388ff7) [0x55568ca90ff7]

/usr/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x452c) [0x55568ca9be1c]

/usr/bin/mariadbd(_Z17mysql_open_cursorP3THDP13select_resultPP18Server_side_cursor+0x16a) [0x55568ca332ca]

/usr/bin/mariadbd(_ZN14sp_instr_cpush9exec_coreEP3THDPj+0x42) [0x55568ccbbbb2]

/usr/bin/mariadbd(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instrb+0x166) [0x55568ccb1b56]

/usr/bin/mariadbd(_ZN13sp_lex_keeper26validate_lex_and_exec_coreEP3THDPjbP12sp_lex_instr+0x186) [0x55568ccb21f6]

/usr/bin/mariadbd(_ZN14sp_instr_copen7executeEP3THDPj+0x81) [0x55568ccba6c1]

/usr/bin/mariadbd(_ZN7sp_head7executeEP3THDb+0xa22) [0x55568c9d4d32]

/usr/bin/mariadbd(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x523) [0x55568c9d61b3]

/usr/bin/mariadbd(+0x37ca28) [0x55568ca84a28]

/usr/bin/mariadbd(_ZN12Sql_cmd_call7executeEP3THD+0x19d) [0x55568ca8543d]

/usr/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x10ce) [0x55568ca989be]

/usr/bin/mariadbd(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x1c) [0x55568ccac33c]

/usr/bin/mariadbd(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instrb+0x166) [0x55568ccb1b56]

/usr/bin/mariadbd(_ZN13sp_lex_keeper26validate_lex_and_exec_coreEP3THDPjbP12sp_lex_instr+0x186) [0x55568ccb21f6]

/usr/bin/mariadbd(_ZN13sp_instr_stmt7executeEP3THDPj+0x824) [0x55568ccb2c14]

/usr/bin/mariadbd(_ZN7sp_head7executeEP3THDb+0xa22) [0x55568c9d4d32]

/usr/bin/mariadbd(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x523) [0x55568c9d61b3]

/usr/bin/mariadbd(+0x37ca28) [0x55568ca84a28]

/usr/bin/mariadbd(_ZN12Sql_cmd_call7executeEP3THD+0x19d) [0x55568ca8543d]

/usr/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x10ce) [0x55568ca989be]

/usr/bin/mariadbd(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x1c) [0x55568ccac33c]

/usr/bin/mariadbd(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instrb+0x166) [0x55568ccb1b56]

/usr/bin/mariadbd(_ZN13sp_lex_keeper26validate_lex_and_exec_coreEP3THDPjbP12sp_lex_instr+0x186) [0x55568ccb21f6]

/usr/bin/mariadbd(_ZN13sp_instr_stmt7executeEP3THDPj+0x824) [0x55568ccb2c14]

/usr/bin/mariadbd(_ZN7sp_head7executeEP3THDb+0xa22) [0x55568c9d4d32]

/usr/bin/mariadbd(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x523) [0x55568c9d61b3]

/usr/bin/mariadbd(+0x37ca28) [0x55568ca84a28]

/usr/bin/mariadbd(_ZN12Sql_cmd_call7executeEP3THD+0x19d) [0x55568ca8543d]

/usr/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x10ce) [0x55568ca989be]

/usr/bin/mariadbd(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x1c) [0x55568ccac33c]

/usr/bin/mariadbd(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instrb+0x166) [0x55568ccb1b56]

/usr/bin/mariadbd(_ZN13sp_lex_keeper26validate_lex_and_exec_coreEP3THDPjbP12sp_lex_instr+0x104) [0x55568ccb2174]

/usr/bin/mariadbd(_ZN13sp_instr_stmt7executeEP3THDPj+0x824) [0x55568ccb2c14]

/usr/bin/mariadbd(_ZN7sp_head7executeEP3THDb+0xa22) [0x55568c9d4d32]

/usr/bin/mariadbd(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x523) [0x55568c9d61b3]

/usr/bin/mariadbd(_ZN14Event_job_data7executeEP3THDb+0x922) [0x55568cbfc392]

/usr/bin/mariadbd(_ZN19Event_worker_thread3runEP3THDP28Event_queue_element_for_exec+0x239) [0x55568cee9599]

/usr/bin/mariadbd(event_worker_thread+0x73) [0x55568cee96d3]

/usr/bin/mariadbd(+0x88660d) [0x55568cf8e60d]

/usr/lib/libc.so.6(+0x969cb) [0x7f8252a969cb]

/usr/lib/libc.so.6(+0x11aa0c) [0x7f8252b1aa0c]

Connection ID (thread ID): 76

Status: NOT_KILLED

Query (0x7f81f29f00b0): Call get_upw_vals_sp( NAME_CONST('★psb_id',1))

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             59694                59694                processes 

Max open files            32768                32768                files     

Max locked memory         524288               524288               bytes     

Max pending signals       59694                59694                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 %d %F

Kernel version: Linux version 6.16.0-arch2-1 (linux@archlinux) (gcc (GCC) 15.2.1 20250813, GNU ld (GNU Binutils) 2.45.0) #1 SMP PREEMPT_DYNAMIC Wed, 13 Aug 2025 23:38:48 +0000