[MDEV-15130] Assertion `table->s->null_bytes == 0' failed in table_setup_timers::read_row_values under 'test_completely_invisible' Created: 2018-01-30  Updated: 2018-04-23  Resolved: 2018-04-20

Status: Closed
Project: MariaDB Server
Component/s: Admin statements, Server
Affects Version/s: 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sachin Setiya (Inactive)
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-15131 Assertion `false' failed in table_se... Closed
is duplicated by MDEV-15137 Assertion `f->real_type() == MYSQL_TY... Closed
Sprint: 10.3.6-1

 Description    

--source include/have_perfschema.inc
 
--source include/have_debug.inc
 
 
 
SET debug_dbug= "+d,test_completely_invisible";
 
UPDATE performance_schema.setup_timers SET timer_name = 'CYCLE' WHERE name = 'wait';

10.3 b8c92d752c34e51dbe

 
mysqld: /data/src/10.3/storage/perfschema/table_setup_timers.cc:123: virtual int table_setup_timers::read_row_values(TABLE*, unsigned char*, Field**, bool): Assertion `table->s->null_bytes == 0' failed.
 
180130 17:25:20 [ERROR] mysqld got signal 6 ;
 
 
 
#7  0x00007fbfb6e46ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
 
#8  0x0000556fedf68946 in table_setup_timers::read_row_values (this=0x7fbfa0184240, table=0x7fbfa01162f0, fields=0x7fbfa0006af8, read_all=true) at /data/src/10.3/storage/perfschema/table_setup_timers.cc:123
 
#9  0x0000556fedf40517 in PFS_engine_table::read_row (this=0x7fbfa0184240, table=0x7fbfa01162f0, buf=0x7fbfa0006968 "\377", fields=0x7fbfa0006af8) at /data/src/10.3/storage/perfschema/pfs_engine_table.cc:271
 
#10 0x0000556fedf3d1f8 in ha_perfschema::rnd_next (this=0x7fbfa0116f28, buf=0x7fbfa0006968 "\377") at /data/src/10.3/storage/perfschema/ha_perfschema.cc:347
 
#11 0x0000556fedc5d8cc in handler::ha_rnd_next (this=0x7fbfa0116f28, buf=0x7fbfa0006968 "\377") at /data/src/10.3/sql/handler.cc:2757
 
#12 0x0000556fedddb200 in rr_sequential (info=0x7fbfb10b4170) at /data/src/10.3/sql/records.cc:485
 
#13 0x0000556fed8e49a7 in READ_RECORD::read_record (this=0x7fbfb10b4170) at /data/src/10.3/sql/records.h:73
 
#14 0x0000556feda6a041 in mysql_update (thd=0x7fbfa0000b00, table_list=0x7fbfa0014db8, fields=..., values=..., conds=0x7fbfa0015780, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7fbfb10b4700, updated_return=0x7fbfb10b47b0) at /data/src/10.3/sql/sql_update.cc:837
 
#15 0x0000556fed9742be in mysql_execute_command (thd=0x7fbfa0000b00) at /data/src/10.3/sql/sql_parse.cc:4561
 
#16 0x0000556fed97f050 in mysql_parse (thd=0x7fbfa0000b00, rawbuf=0x7fbfa0014c38 "UPDATE performance_schema.setup_timers SET timer_name = 'CYCLE' WHERE name = 'wait'", length=83, parser_state=0x7fbfb10b55f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7987
 
#17 0x0000556fed96c87f in dispatch_command (command=COM_QUERY, thd=0x7fbfa0000b00, packet=0x7fbfa000b141 "UPDATE performance_schema.setup_timers SET timer_name = 'CYCLE' WHERE name = 'wait'", packet_length=83, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
 
#18 0x0000556fed96b2b3 in do_command (thd=0x7fbfa0000b00) at /data/src/10.3/sql/sql_parse.cc:1370
 
#19 0x0000556fedad27e8 in do_handle_one_connection (connect=0x556ff08fee70) at /data/src/10.3/sql/sql_connect.cc:1401
 
#20 0x0000556fedad2575 in handle_one_connection (arg=0x556ff08fee70) at /data/src/10.3/sql/sql_connect.cc:1307
 
#21 0x0000556fedf701b4 in pfs_spawn_thread (arg=0x556ff091a650) at /data/src/10.3/storage/perfschema/pfs.cc:1862
 
#22 0x00007fbfb8b1d494 in start_thread (arg=0x7fbfb10b6700) at pthread_create.c:333
 
#23 0x00007fbfb6f0393f in clone () from /lib/x86_64-linux-gnu/libc.so.6



 Comments   
Comment by Elena Stepanova [ 2018-02-01 ]

I also see this failure quite a lot, but when I try to reproduce it, I end up with the one in the description. So we'll need to get rid of that one first, while I'm adding the other one to make it searchable:

mysqld: /data/src/10.3/storage/perfschema/pfs_engine_table.cc:369: static void PFS_engine_table::set_field_char_utf8(Field*, const char*, uint): Assertion `f->real_type() == MYSQL_TYPE_STRING' failed.
 
180201 16:35:41 [ERROR] mysqld got signal 6 ;
 
 
 
#7  0x00007f80245a3ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
 
#8  0x0000557ca5cd5362 in PFS_engine_table::set_field_char_utf8 (f=0x7f7f800344a8, str=0x7f7f800b6878 "rqg", len=3) at /data/src/10.3/storage/perfschema/pfs_engine_table.cc:369
 
#9  0x0000557ca5cf7afd in PFS_user_row::set_field (this=0x7f7f800b6878, f=0x7f7f800344a8) at /data/src/10.3/storage/perfschema/table_helper.cc:61
 
#10 0x0000557ca5cf3a97 in table_ews_by_user_by_event_name::read_row_values (this=0x7f7f800b6850, table=0x7f7f800adb90, buf=0x7f7f80036638 "", fields=0x7f7f80034458, read_all=true) at /data/src/10.3/storage/perfschema/table_ews_by_user_by_event_name.cc:234
 
#11 0x0000557ca5cd4fb3 in PFS_engine_table::read_row (this=0x7f7f800b6850, table=0x7f7f800adb90, buf=0x7f7f80036638 "", fields=0x7f7f80034458) at /data/src/10.3/storage/perfschema/pfs_engine_table.cc:271
 
#12 0x0000557ca5cd1c94 in ha_perfschema::rnd_next (this=0x7f7f8006fb18, buf=0x7f7f80036638 "") at /data/src/10.3/storage/perfschema/ha_perfschema.cc:347
 
#13 0x0000557ca59f23d8 in handler::ha_rnd_next (this=0x7f7f8006fb18, buf=0x7f7f80036638 "") at /data/src/10.3/sql/handler.cc:2757
 
#14 0x0000557ca59e692a in find_all_keys (thd=0x7f7f80000b00, param=0x7f7fd8354560, select=0x7f7f800b1a40, fs_info=0x7f7f8005f150, buffpek_pointers=0x7f7fd8354760, tempfile=0x7f7fd83545f0, pq=0x7f7fd8354510, found_rows=0x7f7f8005f330) at /data/src/10.3/sql/filesort.cc:787
 
#15 0x0000557ca59e4e86 in filesort (thd=0x7f7f80000b00, table=0x7f7f800adb90, filesort=0x7f7f800b1d40, tracker=0x7f7f800b2538, join=0x7f7f800187f8, first_table_bit=1) at /data/src/10.3/sql/filesort.cc:275
 
#16 0x0000557ca5781690 in create_sort_index (thd=0x7f7f80000b00, join=0x7f7f800187f8, tab=0x7f7f800b0ca0, fsort=0x7f7f800b1d40) at /data/src/10.3/sql/sql_select.cc:22426
 
#17 0x0000557ca577bf9e in st_join_table::sort_table (this=0x7f7f800b0ca0) at /data/src/10.3/sql/sql_select.cc:20261
 
#18 0x0000557ca577bbb2 in join_init_read_record (tab=0x7f7f800b0ca0) at /data/src/10.3/sql/sql_select.cc:20202
 
#19 0x0000557ca5779b42 in sub_select (join=0x7f7f800187f8, join_tab=0x7f7f800b0ca0, end_of_records=false) at /data/src/10.3/sql/sql_select.cc:19296
 
#20 0x0000557ca577910d in do_select (join=0x7f7f800187f8, procedure=0x0) at /data/src/10.3/sql/sql_select.cc:18839
 
#21 0x0000557ca57522c2 in JOIN::exec_inner (this=0x7f7f800187f8) at /data/src/10.3/sql/sql_select.cc:4061
 
#22 0x0000557ca575152e in JOIN::exec (this=0x7f7f800187f8) at /data/src/10.3/sql/sql_select.cc:3844
 
#23 0x0000557ca57529a7 in mysql_select (thd=0x7f7f80000b00, tables=0x7f7f80013f28, wild_num=1, fields=..., conds=0x7f7f800156b0, og_num=2, order=0x7f7f80016060, group=0x0, having=0x7f7f80015dd8, proc_param=0x0, select_options=551903562496, result=0x7f7f800187d8, unit=0x7f7f80004890, select_lex=0x7f7f80004ff8) at /data/src/10.3/sql/sql_select.cc:4260
 
#24 0x0000557ca57448cb in handle_select (thd=0x7f7f80000b00, lex=0x7f7f800047c8, result=0x7f7f800187d8, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
 
#25 0x0000557ca570f695 in execute_sqlcom_select (thd=0x7f7f80000b00, all_tables=0x7f7f80013f28) at /data/src/10.3/sql/sql_parse.cc:6522
 
#26 0x0000557ca5705d98 in mysql_execute_command (thd=0x7f7f80000b00) at /data/src/10.3/sql/sql_parse.cc:3747
 
#27 0x0000557ca5712ff8 in mysql_parse (thd=0x7f7f80000b00, rawbuf=0x7f7f80013928 "SELECT * FROM performance_schema.`events_waits_summary_by_user_by_event_name` AS table1 WHERE ( ( ( ( table1.`COUNT_STAR` IN ( 0, 2, 9 ) OR table1.`MIN_TIMER_WAIT` LIKE 'wait/synch/mutex/%') OR table1"..., length=437, parser_state=0x7f7fd83565e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7977
 
#28 0x0000557ca570083f in dispatch_command (command=COM_QUERY, thd=0x7f7f80000b00, packet=0x7f7f8000b161 "", packet_length=439, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1825
 
#29 0x0000557ca56ff27f in do_command (thd=0x7f7f80000b00) at /data/src/10.3/sql/sql_parse.cc:1370
 
#30 0x0000557ca5866b74 in do_handle_one_connection (connect=0x557ca9ab0ea0) at /data/src/10.3/sql/sql_connect.cc:1402
 
#31 0x0000557ca5866901 in handle_one_connection (arg=0x557ca9ab0ea0) at /data/src/10.3/sql/sql_connect.cc:1308
 
#32 0x0000557ca5d04c50 in pfs_spawn_thread (arg=0x557ca9b74cd0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
 
#33 0x00007f802627a494 in start_thread (arg=0x7f7fd8357700) at pthread_create.c:333
 
#34 0x00007f802466093f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Comment by Sachin Setiya (Inactive) [ 2018-04-20 ]

Not a bug, dbug_debug can make server to misbehave.

Generated at Thu Feb 08 08:18:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.