[MDEV-15137] Assertion `f->real_type() == MYSQL_TYPE_VARCHAR' failed in PFS_engine_table::set_field_varchar_utf8 upon querying perfschema under 'test_completely_invisible' Created: 2018-01-30  Updated: 2018-04-23  Resolved: 2018-04-23

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
duplicates MDEV-15130 Assertion `table->s->null_bytes == 0'... Closed
Sprint: 10.3.6-1

 Description   

CREATE TABLE t1 (i INT);
SET debug_dbug= "+d,test_completely_invisible";
SELECT * FROM performance_schema.events_stages_summary_by_account_by_event_name STRAIGHT_JOIN t1 ON ( i = SUM_TIMER_WAIT );
 
# Cleanup
DROP TABLE t1;

10.3 926adcfeea

mysqld: /data/src/10.3/storage/perfschema/pfs_engine_table.cc:377: static void PFS_engine_table::set_field_varchar_utf8(Field*, const char*, uint): Assertion `f->real_type() == MYSQL_TYPE_VARCHAR' failed.
180131  0:16:37 [ERROR] mysqld got signal 6 ;
 
#7  0x00007f8cbfff0ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x000055ea0ae6386e in PFS_engine_table::set_field_varchar_utf8 (f=0x7f8ca8117458, str=0x55ea0e1f7110 "stage/sql/After apply log event", len=31) at /data/src/10.3/storage/perfschema/pfs_engine_table.cc:377
#9  0x000055ea0ae75441 in PFS_event_name_row::set_field (this=0x7f8ca8073650, f=0x7f8ca8117458) at /data/src/10.3/storage/perfschema/table_helper.h:165
#10 0x000055ea0ae75287 in table_esgs_by_account_by_event_name::read_row_values (this=0x7f8ca8073460, table=0x7f8ca80fe670, buf=0x7f8ca8116c68 "\002", fields=0x7f8ca8117248, read_all=false) at /data/src/10.3/storage/perfschema/table_esgs_by_account_by_event_name.cc:181
#11 0x000055ea0ae6341b in PFS_engine_table::read_row (this=0x7f8ca8073460, table=0x7f8ca80fe670, buf=0x7f8ca8116c68 "\002", fields=0x7f8ca8117238) at /data/src/10.3/storage/perfschema/pfs_engine_table.cc:271
#12 0x000055ea0ae600fc in ha_perfschema::rnd_next (this=0x7f8ca81183c8, buf=0x7f8ca8116c68 "\002") at /data/src/10.3/storage/perfschema/ha_perfschema.cc:347
#13 0x000055ea0ab80bf8 in handler::ha_rnd_next (this=0x7f8ca81183c8, buf=0x7f8ca8116c68 "\002") at /data/src/10.3/sql/handler.cc:2760
#14 0x000055ea0acfe1be in rr_sequential (info=0x7f8ca814b4f0) at /data/src/10.3/sql/records.cc:485
#15 0x000055ea0a8072c1 in READ_RECORD::read_record (this=0x7f8ca814b4f0) at /data/src/10.3/sql/records.h:73
#16 0x000055ea0a90a783 in join_init_read_record (tab=0x7f8ca814b428) at /data/src/10.3/sql/sql_select.cc:20222
#17 0x000055ea0a908544 in sub_select (join=0x7f8ca8018d10, join_tab=0x7f8ca814b428, end_of_records=false) at /data/src/10.3/sql/sql_select.cc:19296
#18 0x000055ea0a907b0f in do_select (join=0x7f8ca8018d10, procedure=0x0) at /data/src/10.3/sql/sql_select.cc:18839
#19 0x000055ea0a8e0d0e in JOIN::exec_inner (this=0x7f8ca8018d10) at /data/src/10.3/sql/sql_select.cc:4061
#20 0x000055ea0a8dff7a in JOIN::exec (this=0x7f8ca8018d10) at /data/src/10.3/sql/sql_select.cc:3844
#21 0x000055ea0a8e13f3 in mysql_select (thd=0x7f8ca8000b00, tables=0x7f8ca8014f60, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f8ca8018cf0, unit=0x7f8ca8004890, select_lex=0x7f8ca8004fe8) at /data/src/10.3/sql/sql_select.cc:4260
#22 0x000055ea0a8d3316 in handle_select (thd=0x7f8ca8000b00, lex=0x7f8ca80047c8, result=0x7f8ca8018cf0, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
#23 0x000055ea0a89e112 in execute_sqlcom_select (thd=0x7f8ca8000b00, all_tables=0x7f8ca8014f60) at /data/src/10.3/sql/sql_parse.cc:6531
#24 0x000055ea0a8947fc in mysql_execute_command (thd=0x7f8ca8000b00) at /data/src/10.3/sql/sql_parse.cc:3752
#25 0x000055ea0a8a1a66 in mysql_parse (thd=0x7f8ca8000b00, rawbuf=0x7f8ca8014c38 "SELECT * FROM performance_schema.events_stages_summary_by_account_by_event_name STRAIGHT_JOIN t1 ON ( i = SUM_TIMER_WAIT )", length=122, parser_state=0x7f8cba25f5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7988
#26 0x000055ea0a88f27f in dispatch_command (command=COM_QUERY, thd=0x7f8ca8000b00, packet=0x7f8ca800b141 "", packet_length=122, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
#27 0x000055ea0a88dcb3 in do_command (thd=0x7f8ca8000b00) at /data/src/10.3/sql/sql_parse.cc:1370
#28 0x000055ea0a9f5796 in do_handle_one_connection (connect=0x55ea0e4e7dd0) at /data/src/10.3/sql/sql_connect.cc:1401
#29 0x000055ea0a9f5523 in handle_one_connection (arg=0x55ea0e4e7dd0) at /data/src/10.3/sql/sql_connect.cc:1307
#30 0x000055ea0ae930b8 in pfs_spawn_thread (arg=0x55ea0e5035b0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
#31 0x00007f8cc1cc7494 in start_thread (arg=0x7f8cba260700) at pthread_create.c:333
#32 0x00007f8cc00ad93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

I also had this one, probably the same cause:

mysqld: /home/travis/src/storage/perfschema/pfs_engine_table.cc:361: static void PFS_engine_table::set_field_ulonglong(Field*, ulonglong): Assertion `f->real_type() == MYSQL_TYPE_LONGLONG' failed.
180130 18:36:54 [ERROR] mysqld got signal 6 ;



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

patch for 15130 will solve this

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:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.