|
Nothing that the bug is sporadic, and exists only from 10.5. (10.4 is not affected as Table 'performance_schema.user_variables_by_thread' doesn't exist) There is also a different assert on optimized Assertion `length <= NAME_CHAR_LEN' failed in 10.5, ref below. Furthermore, 10.6+ optimized does not crash, so it may be interesting to find out why.
# mysqld options required for replay: --performance-schema
|
SET @X2345678901234567890123456789012345678901234567890123456789012345=12;
|
SELECT variable_name,variable_value FROM performance_schema.user_variables_by_thread;
|
Leads to:
|
10.8.1 0c5d1342ae6b5ab3256848be7a83e5c3b1f21566 (Debug)
|
mysqld: /test/10.8_dbg/storage/perfschema/table_helper.cc:840: void PFS_variable_name_row::make_row(const char*, size_t): Assertion `length <= 64' failed.
|
|
10.8.1 0c5d1342ae6b5ab3256848be7a83e5c3b1f21566 (Debug)
|
Core was generated by `/test/MD290122-mariadb-10.8.1-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x152e3c098700 (LWP 2709198))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x0000152e4c106859 in __GI_abort () at abort.c:79
|
#2 0x0000152e4c106729 in __assert_fail_base (fmt=0x152e4c29c588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5588eee77dae "length <= 64", file=0x5588ef0d9418 "/test/10.8_dbg/storage/perfschema/table_helper.cc", line=840, function=<optimized out>) at assert.c:92
|
#3 0x0000152e4c117f36 in __GI___assert_fail (assertion=assertion@entry=0x5588eee77dae "length <= 64", file=file@entry=0x5588ef0d9418 "/test/10.8_dbg/storage/perfschema/table_helper.cc", line=line@entry=840, function=function@entry=0x5588ef0d97c8 "void PFS_variable_name_row::make_row(const char*, size_t)") at assert.c:101
|
#4 0x00005588ee8191bf in PFS_variable_name_row::make_row (this=this@entry=0x152ddc02f958, str=str@entry=0x152ddc00bdd0 "X2345678901234567890123456789012345678901234567890123456789012345", length=length@entry=65) at /test/10.8_dbg/storage/perfschema/table_helper.cc:840
|
#5 0x00005588ee8276a9 in User_variables::materialize (this=this@entry=0x152ddc00ba38, pfs=pfs@entry=0x152e4b27cd40, thd=thd@entry=0x152ddc000db8) at /test/10.8_dbg/storage/perfschema/table_uvar_by_thread.cc:109
|
#6 0x00005588ee827995 in table_uvar_by_thread::materialize (this=this@entry=0x152ddc00ba10, thread=thread@entry=0x152e4b27cd40) at /test/10.8_dbg/storage/perfschema/table_uvar_by_thread.cc:251
|
#7 0x00005588ee827b08 in table_uvar_by_thread::rnd_next (this=0x152ddc00ba10) at /test/10.8_dbg/storage/perfschema/table_uvar_by_thread.cc:194
|
#8 0x00005588ee7c4b69 in ha_perfschema::rnd_next (this=0x152ddc0288a0, buf=0x152ddc028430 "\377") at /test/10.8_dbg/storage/perfschema/ha_perfschema.cc:359
|
#9 0x00005588ee4d4573 in handler::ha_rnd_next (this=0x152ddc0288a0, buf=0x152ddc028430 "\377") at /test/10.8_dbg/sql/handler.cc:3393
|
#10 0x00005588ee0bac59 in rr_sequential (info=0x152ddc0177d0) at /test/10.8_dbg/sql/records.h:82
|
#11 0x00005588ee23eabc in READ_RECORD::read_record (this=0x152ddc0177d0) at /test/10.8_dbg/sql/records.h:81
|
#12 join_init_read_record (tab=0x152ddc017708) at /test/10.8_dbg/sql/sql_select.cc:22071
|
#13 0x00005588ee225ceb in sub_select (join=0x152ddc016e70, join_tab=0x152ddc017708, end_of_records=<optimized out>) at /test/10.8_dbg/sql/sql_select.cc:21073
|
#14 0x00005588ee25df22 in do_select (procedure=0x0, join=0x152ddc016e70) at /test/10.8_dbg/sql/sql_select.cc:20621
|
#15 JOIN::exec_inner (this=this@entry=0x152ddc016e70) at /test/10.8_dbg/sql/sql_select.cc:4733
|
#16 0x00005588ee25e4ce in JOIN::exec (this=this@entry=0x152ddc016e70) at /test/10.8_dbg/sql/sql_select.cc:4511
|
#17 0x00005588ee25c4df in mysql_select (thd=thd@entry=0x152ddc000db8, tables=0x152ddc014890, fields=@0x152ddc0143c8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x152ddc0146c8, last = 0x152ddc014800, elements = 2}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x152ddc016e48, unit=0x152ddc0051c8, select_lex=0x152ddc014128) at /test/10.8_dbg/sql/sql_select.cc:4991
|
#18 0x00005588ee25c794 in handle_select (thd=thd@entry=0x152ddc000db8, lex=lex@entry=0x152ddc0050f0, result=result@entry=0x152ddc016e48, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.8_dbg/sql/sql_select.cc:543
|
#19 0x00005588ee1bbbc6 in execute_sqlcom_select (thd=thd@entry=0x152ddc000db8, all_tables=0x152ddc014890) at /test/10.8_dbg/sql/sql_parse.cc:6252
|
#20 0x00005588ee1c8b2d in mysql_execute_command (thd=thd@entry=0x152ddc000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.8_dbg/sql/sql_parse.cc:3943
|
#21 0x00005588ee1b4db7 in mysql_parse (thd=thd@entry=0x152ddc000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x152e3c097400) at /test/10.8_dbg/sql/sql_parse.cc:8027
|
#22 0x00005588ee1c3a53 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x152ddc000db8, packet=packet@entry=0x152ddc01a129 "", packet_length=packet_length@entry=84, blocking=blocking@entry=true) at /test/10.8_dbg/sql/sql_class.h:1362
|
#23 0x00005588ee1c6e9a in do_command (thd=0x152ddc000db8, blocking=blocking@entry=true) at /test/10.8_dbg/sql/sql_parse.cc:1402
|
#24 0x00005588ee342110 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5588f161f2c8, put_in_cache=put_in_cache@entry=true) at /test/10.8_dbg/sql/sql_connect.cc:1418
|
#25 0x00005588ee342715 in handle_one_connection (arg=arg@entry=0x5588f161f2c8) at /test/10.8_dbg/sql/sql_connect.cc:1312
|
#26 0x00005588ee7cbc8e in pfs_spawn_thread (arg=0x5588f1516fc8) at /test/10.8_dbg/storage/perfschema/pfs.cc:2201
|
#27 0x0000152e4c615609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#28 0x0000152e4c203293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
|
10.5.14 059a8fd87eb900a5a12185b1963e5623df874c21 (Optimized)
|
mysqld: /test/10.5_opt/storage/perfschema/table_helper.cc:840: void PFS_variable_name_row::make_row(const char*, size_t): Assertion `length <= NAME_CHAR_LEN' failed.
|
|
10.5.14 059a8fd87eb900a5a12185b1963e5623df874c21 (Optimized)
|
Core was generated by `/test/MD290122-mariadb-10.5.14-linux-x86_64-opt/bin/mysqld --no-defaults --core'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x148a785c1700 (LWP 2709173))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x0000148a92a6b859 in __GI_abort () at abort.c:79
|
#2 0x0000148a92a6b729 in __assert_fail_base (fmt=0x148a92c01588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5590688b4f47 "length <= NAME_CHAR_LEN", file=0x5590688b4a98 "/test/10.5_opt/storage/perfschema/table_helper.cc", line=840, function=<optimized out>) at assert.c:92
|
#3 0x0000148a92a7cf36 in __GI___assert_fail (assertion=assertion@entry=0x5590688b4f47 "length <= NAME_CHAR_LEN", file=file@entry=0x5590688b4a98 "/test/10.5_opt/storage/perfschema/table_helper.cc", line=line@entry=840, function=function@entry=0x5590688b4e10 "void PFS_variable_name_row::make_row(const char*, size_t)") at assert.c:101
|
#4 0x0000559068278fc0 in PFS_variable_name_row::make_row (this=this@entry=0x148a34022da8, str=<optimized out>, length=<optimized out>) at /test/10.5_opt/storage/perfschema/table_helper.cc:845
|
#5 0x0000559068286114 in User_variables::materialize (this=0x148a34019548, pfs=<optimized out>, thd=0x148a34000c58) at /test/10.5_opt/storage/perfschema/table_uvar_by_thread.cc:109
|
#6 0x00005590682862ed in table_uvar_by_thread::materialize (thread=0x148a91bea340, this=0x148a34019520) at /test/10.5_opt/storage/perfschema/table_uvar_by_thread.cc:251
|
#7 table_uvar_by_thread::rnd_next (this=0x148a34019520) at /test/10.5_opt/storage/perfschema/table_uvar_by_thread.cc:194
|
#8 0x0000559068222053 in ha_perfschema::rnd_next (buf=0x148a34022070 "\377", this=0x148a34022450) at /test/10.5_opt/storage/perfschema/ha_perfschema.cc:359
|
#9 ha_perfschema::rnd_next (this=0x148a34022450, buf=0x148a34022070 "\377") at /test/10.5_opt/storage/perfschema/ha_perfschema.cc:348
|
#10 0x0000559067fa5fd7 in handler::ha_rnd_next (this=0x148a34022450, buf=0x148a34022070 "\377") at /test/10.5_opt/sql/handler.cc:3080
|
#11 0x00005590680fd896 in rr_sequential (info=0x148a34014750) at /test/10.5_opt/sql/records.h:81
|
#12 0x0000559067dc5e66 in sub_select (end_of_records=false, join_tab=0x148a34014688, join=0x148a340133e0) at /test/10.5_opt/sql/sql_select.cc:20876
|
#13 sub_select (join=0x148a340133e0, join_tab=0x148a34014688, end_of_records=false) at /test/10.5_opt/sql/sql_select.cc:20808
|
#14 0x0000559067df4d44 in do_select (procedure=<optimized out>, join=0x148a340133e0) at /test/10.5_opt/sql/sql_select.cc:20411
|
#15 JOIN::exec_inner (this=0x148a340133e0) at /test/10.5_opt/sql/sql_select.cc:4516
|
#16 0x0000559067df50d8 in JOIN::exec (this=this@entry=0x148a340133e0) at /test/10.5_opt/sql/sql_select.cc:4296
|
#17 0x0000559067df305f in mysql_select (thd=0x148a34000c58, tables=0x148a34010dc0, fields=@0x148a34010748: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x148a34010bd0, last = 0x148a34010d30, elements = 2}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x148a340133b8, unit=0x148a34004c40, select_lex=0x148a340105f8) at /test/10.5_opt/sql/sql_select.cc:4773
|
#18 0x0000559067df3a87 in handle_select (thd=thd@entry=0x148a34000c58, lex=lex@entry=0x148a34004b78, result=result@entry=0x148a340133b8, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.5_opt/sql/sql_select.cc:444
|
#19 0x0000559067d805b1 in execute_sqlcom_select (thd=0x148a34000c58, all_tables=0x148a34010dc0) at /test/10.5_opt/sql/sql_parse.cc:6314
|
#20 0x0000559067d8f2c1 in mysql_execute_command (thd=0x148a34000c58) at /test/10.5_opt/sql/sql_parse.cc:4005
|
#21 0x0000559067d7abf3 in mysql_parse (thd=0x148a34000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.5_opt/sql/sql_parse.cc:8100
|
#22 0x0000559067d87a0d in dispatch_command (command=COM_QUERY, thd=0x148a34000c58, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.5_opt/sql/sql_class.h:1290
|
#23 0x0000559067d8a1e2 in do_command (thd=0x148a34000c58) at /test/10.5_opt/sql/sql_parse.cc:1370
|
#24 0x0000559067e91d41 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55906b604028, put_in_cache=put_in_cache@entry=true) at /test/10.5_opt/sql/sql_connect.cc:1418
|
#25 0x0000559067e921bd in handle_one_connection (arg=arg@entry=0x55906b604028) at /test/10.5_opt/sql/sql_connect.cc:1312
|
#26 0x0000559068226ec2 in pfs_spawn_thread (arg=0x55906b5e6f28) at /test/10.5_opt/storage/perfschema/pfs.cc:2201
|
#27 0x0000148a92f7a609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#28 0x0000148a92b68293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.5.14 (dbg), 10.5.14 (opt), 10.6.6 (dbg), 10.7.2 (dbg), 10.8.1 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.42 (dbg), 10.2.42 (opt), 10.3.33 (dbg), 10.3.33 (opt), 10.4.23 (dbg), 10.4.23 (opt), 10.6.6 (opt), 10.7.2 (opt), 10.8.1 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.36 (dbg), 5.7.36 (opt), 8.0.27 (dbg), 8.0.27 (opt)
|