Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.5.19
-
None
-
Debian 12
Description
mariadb gets signal 11, when stored procedure is called. The procedure prepares and executes a select, which can sucessfully be run directly ie over command line. I dont know exactly when or witch which mariadb-Version, but this procedure worked very well some months ago. This is from journalctl:
Mai 31 13:53:41 lampe mariadbd[87333]: 230531 13:53:41 [ERROR] mysqld got signal 11 ;
|
Mai 31 13:53:41 lampe mariadbd[87333]: This could be because you hit a bug. It is also possible that this binary
|
Mai 31 13:53:41 lampe mariadbd[87333]: or one of the libraries it was linked against is corrupt, improperly built,
|
Mai 31 13:53:41 lampe mariadbd[87333]: or misconfigured. This error can also be caused by malfunctioning hardware.
|
Mai 31 13:53:41 lampe mariadbd[87333]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
Mai 31 13:53:41 lampe mariadbd[87333]: We will try our best to scrape up some info that will hopefully help
|
Mai 31 13:53:41 lampe mariadbd[87333]: diagnose the problem, but since we have already crashed,
|
Mai 31 13:53:41 lampe mariadbd[87333]: something is definitely wrong and this may fail.
|
Mai 31 13:53:41 lampe mariadbd[87333]: Server version: 10.5.19-MariaDB-0+deb11u2 source revision: f8a85af8ca1c937b8d4f847477bd282f80251cde
|
Mai 31 13:53:41 lampe mariadbd[87333]: key_buffer_size=134217728
|
Mai 31 13:53:41 lampe mariadbd[87333]: read_buffer_size=131072
|
Mai 31 13:53:41 lampe mariadbd[87333]: max_used_connections=6
|
Mai 31 13:53:41 lampe mariadbd[87333]: max_threads=153
|
Mai 31 13:53:41 lampe mariadbd[87333]: thread_count=6
|
Mai 31 13:53:41 lampe mariadbd[87333]: It is possible that mysqld could use up to
|
Mai 31 13:53:41 lampe mariadbd[87333]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467880 K bytes of memory
|
Mai 31 13:53:41 lampe mariadbd[87333]: Hope that's ok; if not, decrease some variables in the equation.
|
Mai 31 13:53:41 lampe mariadbd[87333]: Thread pointer: 0x7f612c000dd8
|
Mai 31 13:53:41 lampe mariadbd[87333]: Attempting backtrace. You can use the following information to find out
|
Mai 31 13:53:41 lampe mariadbd[87333]: where mysqld died. If you see no messages after this, something went
|
Mai 31 13:53:41 lampe mariadbd[87333]: terribly wrong...
|
Mai 31 13:53:41 lampe mariadbd[87333]: stack_bottom = 0x7f615bffed78 thread_stack 0x49000
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(my_print_stacktrace)[0x5583b9a0a16e]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(handle_fatal_signal)[0x5583b9502f45]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(__restore_rt)[0x7f61647c8140]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(Item_field::used_tables() const)[0x5583b952bfb7]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(Item_direct_view_ref::used_tables() const)[0x5583b952c49b]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(Wsrep_client_state::~Wsrep_client_state())[0x5583b92be802]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(Wsrep_client_state::~Wsrep_client_state())[0x5583b92be7f5]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(st_select_lex::update_used_tables())[0x5583b92e14ad]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(JOIN::optimize_inner())[0x5583b9369a18]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(JOIN::optimize())[0x5583b936d300]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(st_select_lex_unit::optimize())[0x5583b93b75b0]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(TABLE_LIST::fill_recursive(THD*))[0x5583b92c5078]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x5583b92c4875]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(JOIN::optimize_inner())[0x5583b936a72f]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(JOIN::optimize())[0x5583b936d300]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(st_select_lex_unit::optimize())[0x5583b93b75b0]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(TABLE_LIST::fill_recursive(THD*))[0x5583b92c5078]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x5583b92c4875]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(JOIN::optimize_inner())[0x5583b936a72f]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(JOIN::optimize())[0x5583b936d300]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5583b936d3>
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5583b936de98]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(comp_ne_creator(bool))[0x5583b92fdd91]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(mysql_execute_command(THD*))[0x5583b930aabb]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(Prepared_statement::execute(String*, bool))[0x5583b931f645]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x5583b931f78d]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(mysql_sql_stmt_execute(THD*))[0x5583b931fae6]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(mysql_execute_command(THD*))[0x5583b9309c10]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5583b92689a5]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5583b9270f14]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(sp_instr_stmt::execute(THD*, unsigned int*))[0x5583b92718ac]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(sp_head::execute(THD*, bool))[0x5583b926c669]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(sp_head::execute_procedure(THD*, List<Item>*))[0x5583b926dfea]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(comp_ne_creator(bool))[0x5583b92fd6e7]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(Sql_cmd_call::execute(THD*))[0x5583b930117e]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(mysql_execute_command(THD*))[0x5583b9307c66]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5583b930bf6b]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5583b930dd2d]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(do_command(THD*))[0x5583b930fc70]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(do_handle_one_connection(CONNECT*, bool))[0x5583b94036c2]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(handle_one_connection)[0x5583b940393d]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x5583b974375b]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(start_thread)[0x7f61647bcea7]
|
Mai 31 13:53:41 lampe mariadbd[87333]: ??:0(clone)[0x7f61643c3a2f]
|
Mai 31 13:53:41 lampe mariadbd[87333]: Trying to get some variables.
|
Mai 31 13:53:41 lampe mariadbd[87333]: Some pointers may be invalid and cause the dump to abort.
|
Mai 31 13:53:41 lampe mariadbd[87333]: Query (0x7f612d576740): select
|
Mai 31 13:53:41 lampe mariadbd[87333]: j.Konto,
|
Mai 31 13:53:41 lampe mariadbd[87333]: k.Bezeichnung AS 'Bezeichnung',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=13,j.Ein,0)) AS 'Eichenstr. 2c|Einnahmen',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=13,j.Aus,0)) AS 'Eichenstr. 2c|Ausgaben',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=15,j.Ein,0)) AS '1170 Jörgerstr.3-5|Einnahmen',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=15,j.Aus,0)) AS '1170 Jörgerstr.3-5|Ausgaben',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=21,j.Ein,0)) AS 'Brückeng.10-12|Einnahmen',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=21,j.Aus,0)) AS 'Brückeng.10-12|Ausgaben',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=22,j.Ein,0)) AS 'Mayerhofg.9|Einnahmen',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=22,j.Aus,0)) AS 'Mayerhofg.9|Ausgaben',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=23,j.Ein,0)) AS 'Troststr.61|Einnahmen',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=23,j.Aus,0)) AS 'Troststr.61|Ausgaben',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=24,j.Ein,0)) AS 'Ottakringerstr.69|Einnahmen',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=24,j.Aus,0)) AS 'Ottakringerstr.69|Ausgaben',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=32,j.Ein,0)) AS 'Lerchenfelderstr.49|Einnahmen',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(if(h.Id=32,j.Aus,0)) AS 'Lerchenfelderstr.49|Ausgaben',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(j.Ein) AS 'Summe|Einnahmen',
|
Mai 31 13:53:41 lampe mariadbd[87333]: sum(j.Aus) AS 'Summe|Ausgaben'
|
Mai 31 13:53:41 lampe mariadbd[87333]: FROM JournalUst j
|
Mai 31 13:53:41 lampe mariadbd[87333]: LEFT JOIN Konten k ON(j.Konto = k.Nummer AND j.Haus = k.Haus)
|
Mai 31 13:53:41 lampe mariadbd[87333]: LEFT JOIN Parameter p ON(p.connection = '36')
|
Mai 31 13:53:41 lampe mariadbd[87333]: LEFT JOIN Haus h ON(h.Id = j.Haus)
|
Mai 31 13:53:41 lampe mariadbd[87333]: WHERE k.istumzubuchen <> 0 AND
|
Mai 31 13:53:41 lampe mariadbd[87333]: (k.AbsetzungJahre = 0 OR k.AbsetzungJahre IS NULL) AND
|
Mai 31 13:53:41 lampe mariadbd[87333]: j.Datum LIKE CONCAT(`p`.`Jahr`,'%') AND
|
Mai 31 13:53:41 lampe mariadbd[87333]: j.Text NOT LIKE '%bertrag' AND
|
Mai 31 13:53:41 lampe mariadbd[87333]: j.Text NOT LIKE 'Umbuchung%' AND
|
Mai 31 13:53:41 lampe mariadbd[87333]: h.SteuerNr='078430881'
|
Mai 31 13:53:41 lampe mariadbd[87333]: GROUP BY h.SteuerNr,j.Konto
|
Mai 31 13:53:41 lampe mariadbd[87333]: ORDER BY h.SteuerNr,j.Konto
|
Mai 31 13:53:41 lampe mariadbd[87333]: Connection ID (thread ID): 36
|
Mai 31 13:53:41 lampe mariadbd[87333]: Status: NOT_KILLED
|
Mai 31 13:53:41 lampe mariadbd[87333]: 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=>
|
Mai 31 13:53:41 lampe mariadbd[87333]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
Mai 31 13:53:41 lampe mariadbd[87333]: information that should help you find out what is causing the crash.
|
Mai 31 13:53:41 lampe mariadbd[87333]: Writing a core file...
|
Mai 31 13:53:41 lampe mariadbd[87333]: Working directory at /var/lib/mysql
|
Mai 31 13:53:41 lampe mariadbd[87333]: Resource Limits:
|
Mai 31 13:53:41 lampe mariadbd[87333]: Limit Soft Limit Hard Limit Units
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max cpu time unlimited unlimited seconds
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max file size unlimited unlimited bytes
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max data size unlimited unlimited bytes
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max stack size 8388608 unlimited bytes
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max core file size 0 unlimited bytes
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max resident set unlimited unlimited bytes
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max processes 7743 7743 processes
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max open files 32768 32768 files
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max locked memory 65536 65536 bytes
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max address space unlimited unlimited bytes
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max file locks unlimited unlimited locks
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max pending signals 7743 7743 signals
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max msgqueue size 819200 819200 bytes
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max nice priority 0 0
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max realtime priority 0 0
|
Mai 31 13:53:41 lampe mariadbd[87333]: Max realtime timeout unlimited unlimited us
|
Mai 31 13:53:41 lampe mariadbd[87333]: Core pattern: core
|
Mai 31 13:53:41 lampe mariadbd[87333]: Kernel version: Linux version 5.10.0-23-amd64 (debian-kernel@lists.debian.org) (gcc-10 (Debian 10.2.1-6) 10.2.1 20210110, GNU ld (GNU Binutils for Debian) 2.35.2) #1 SMP Debian 5.10.179-1 (2023-05->
|
Mai 31 13:53:41 lampe systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
|
Mai 31 13:53:41 lampe systemd[1]: mariadb.service: Failed with result 'signal'.
|
Mai 31 13:53:41 lampe systemd[1]: mariadb.service: Consumed 3.419s CPU time.
|
Mai 31 13:53:46 lampe systemd[1]: mariadb.service: Scheduled restart job, restart counter is at 18.
|