handle_fatal_signal (sig=11) in MYSQLlex | sql/sql_lex.cc:1223
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Activity
Show:
Venkatesh Prasad May 16, 2022 at 1:13 PM
Fixed in 8.0.21.
Ramesh Sivaraman August 25, 2020 at 4:21 AM
Reproducible test case.
set collation_connection=utf16_bin;
SELECT statement_digest_text('SELECT 1 + 1');Marcelo Altmann May 1, 2020 at 1:03 PM
@Ramesh Sivaraman can you check it against latest trunk version and also provide a reproducible test case?
When I try just the failing query alone I get a proper message:
mysql> SELECT statement_digest_text( '\\0abc' ) IS NULL;
ERROR 3676 (HY000): Could not parse argument to digest function: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\0abc' at line 1".Done
Details
Details
Assignee
Unassigned
UnassignedReporter
Ramesh Sivaraman
Ramesh Sivaraman(Deactivated)Time tracking
1h 15m logged
Fix versions
Affects versions
Priority
LowSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created January 13, 2020 at 12:43 PM
Updated March 6, 2024 at 9:52 PM
Resolved May 16, 2022 at 1:13 PM
GDB Info
#0 __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x0000000004dafb64 in my_write_core (sig=11) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/mysys/stacktrace.cc:305 #2 0x0000000003b6d30f in handle_fatal_signal (sig=11) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/signal_handler.cc:182 #3 <signal handler called> #4 0x00000000039102e3 in lex_one_token (yylval=0x7f797d274c50, thd=0x7f7962829000) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_lex.cc:1285 #5 0x0000000003910061 in MYSQLlex (yacc_yylval=0x7f797d274c50, yylloc=0x7f797d274c70, thd=0x7f7962829000) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_lex.cc:1223 #6 0x0000000003bc401f in MYSQLparse (YYTHD=0x7f7962829000, parse_tree=0x7f797d2769b0) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/target/bld/sql/sql_yacc.cc:23169 #7 0x0000000003877602 in THD::sql_parser (this=0x7f7962829000) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_class.cc:3217 #8 0x000000000361b818 in (anonymous namespace)::parse (thd=0x7f7962829000, statement_expr=0x7f7977985a80, statement_string=0x7f7977985a98) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_strfunc.cc:870 #9 0x000000000361bf96 in Item_func_statement_digest_text::val_str (this=0x7f7977985f78, buf=0x7f797d2776d0) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_strfunc.cc:939 #10 0x0000000003537fef in Item::evaluate (this=0x7f7977985f78, thd=0x7f7962829000, buffer=0x7f797d2776d0) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item.cc:6653 #11 0x0000000003537e33 in Item::update_null_value (this=0x7f7977985f78) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item.cc:6616 #12 0x000000000356cae6 in Item_func::is_null (this=0x7f7977985f78) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_func.h:394 #13 0x0000000003564861 in Item_func_isnull::update_used_tables (this=0x7f7977985cd0) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_cmpfunc.cc:5547 #14 0x0000000003564ed5 in Item_func_isnull::resolve_type (this=0x7f7977985cd0, thd=0x7f7962829000) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_cmpfunc.cc:5658 #15 0x00000000035be9b7 in Item_func::fix_fields (this=0x7f7977985cd0, thd=0x7f7962829000) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_func.cc:295 #16 0x00000000035649c7 in Item_func_isnull::fix_fields (this=0x7f7977985cd0, thd=0x7f7962829000, ref=0x7f7977985e90) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/item_cmpfunc.cc:5571 #17 0x0000000003858865 in setup_fields (thd=0x7f7962829000, ref_item_array=..., fields=..., want_privilege=1, sum_func_list=0x7f79779851f8, allow_sum_func=true, column_update=false) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_base.cc:8934 #18 0x00000000039badb6 in SELECT_LEX::prepare (this=0x7f7977985088, thd=0x7f7962829000) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_resolver.cc:238 #19 0x00000000039d06bd in Sql_cmd_select::prepare_inner (this=0x7f7977986110, thd=0x7f7962829000) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_select.cc:595 #20 0x00000000039cff89 in Sql_cmd_dml::prepare (this=0x7f7977986110, thd=0x7f7962829000) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_select.cc:482 #21 0x00000000039d089a in Sql_cmd_dml::execute (this=0x7f7977986110, thd=0x7f7962829000) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_select.cc:663 #22 0x0000000003962e7b in mysql_execute_command (thd=0x7f7962829000, first_level=true) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:5357 #23 0x000000000396618f in mysql_parse (thd=0x7f7962829000, parser_state=0x7f797d279b60, update_userstat=false) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:6235 #24 0x000000000396a0db in wsrep_mysql_parse (thd=0x7f7962829000, rawbuf=0x7f7977985028 "SELECT statement_digest_text( '\\0abc' ) IS NULL", length=47, parser_state=0x7f797d279b60, update_userstat=false) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:7504 #25 0x0000000003957622 in dispatch_command (thd=0x7f7962829000, com_data=0x7f797d27ac30, command=COM_QUERY) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:2065 #26 0x00000000039551eb in do_command (thd=0x7f7962829000) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/sql_parse.cc:1430 #27 0x0000000003b54c21 in handle_connection (arg=0x7f7977615740) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/sql/conn_handler/connection_handler_per_thread.cc:312 #28 0x00000000055a8913 in pfs_spawn_thread (arg=0x7f799a064960) at /mnt/jenkins/workspace/pxc80-build/BUILD_TYPE/debug/Host/min-xenial-x64/storage/perfschema/pfs.cc:2855 #29 0x00007f799c9a16ba in start_thread (arg=0x7f797d27b700) at pthread_create.c:333 #30 0x00007f799aa2d41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109