[MDEV-15484] [Draft] Assertion `element->m_flush_tickets.is_empty()' failed in tdc_assert_clean_share Created: 2018-03-06  Updated: 2018-03-06

Status: Open
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.2
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Unresolved Votes: 0
Labels: None

Attachments: File local2.test     HTML File threads    

 Description   

10.2 8f98835bb865

mysqld: /data/src/10.2/sql/table_cache.cc:476: void tdc_assert_clean_share(TDC_element*): Assertion `element->m_flush_tickets.is_empty()' failed.
180306 16:38:00 [ERROR] mysqld got signal 6 ;
 
Query (0x7efff40277e8): UPDATE `view_table100_innodb` SET `col_set_latin1_default_null` = 'focus' WHERE `col_float_not_null` < 'other'  /* QNO 170 CON_ID 19 */
Connection ID (thread ID): 21
Status: NOT_KILLED

#7  0x00007f00871bdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x000055a68c0f5a03 in tdc_assert_clean_share (element=0x7f0010107890) at /data/src/10.2/sql/table_cache.cc:476
#9  0x000055a68c0f605f in tdc_hash_initializer (hash=0x55a68d4c2300 <tdc_hash>, element=0x7f0010107890, key=0x7f0084075bd0) at /data/src/10.2/sql/table_cache.cc:583
#10 0x000055a68c8eaebf in lf_hash_insert (hash=0x55a68d4c2300 <tdc_hash>, pins=0x55a68df8ab80, data=0x7f0084075bd0) at /data/src/10.2/mysys/lf_hash.c:406
#11 0x000055a68c0f6929 in tdc_acquire_share (thd=0x7efff4000b00, tl=0x7efff404fca8, flags=3, out_table=0x7f0084075c68) at /data/src/10.2/sql/table_cache.cc:806
#12 0x000055a68be96e07 in open_table (thd=0x7efff4000b00, table_list=0x7efff404fca8, ot_ctx=0x7f00840760a0) at /data/src/10.2/sql/sql_base.cc:1742
#13 0x000055a68be99d69 in open_and_process_table (thd=0x7efff4000b00, lex=0x7efff40045e0, tables=0x7efff404fca8, counter=0x7f00840761b4, flags=0, prelocking_strategy=0x7f0084076120, has_prelocking_list=false, ot_ctx=0x7f00840760a0) at /data/src/10.2/sql/sql_base.cc:3409
#14 0x000055a68be9aea4 in open_tables (thd=0x7efff4000b00, options=..., start=0x7f0084076190, counter=0x7f00840761b4, flags=0, prelocking_strategy=0x7f0084076120) at /data/src/10.2/sql/sql_base.cc:3928
#15 0x000055a68bee2607 in open_tables (thd=0x7efff4000b00, tables=0x7f0084076190, counter=0x7f00840761b4, flags=0) at /data/src/10.2/sql/sql_base.h:463
#16 0x000055a68bff38ff in mysql_update (thd=0x7efff4000b00, table_list=0x7efff4027a00, fields=..., values=..., conds=0x7efff4028440, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f00840768b0, updated_return=0x7f0084076960) at /data/src/10.2/sql/sql_update.cc:286
#17 0x000055a68bf0c007 in mysql_execute_command (thd=0x7efff4000b00) at /data/src/10.2/sql/sql_parse.cc:4273
#18 0x000055a68bf175d1 in mysql_parse (thd=0x7efff4000b00, rawbuf=0x7efff40277e8 "UPDATE `view_table100_innodb` SET `col_set_latin1_default_null` = 'focus' WHERE `col_float_not_null` < 'other'  /* QNO 170 CON_ID 19 */", length=135, parser_state=0x7f0084077250, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7902
#19 0x000055a68bf054f1 in dispatch_command (command=COM_QUERY, thd=0x7efff4000b00, packet=0x7efff4008a51 "UPDATE `view_table100_innodb` SET `col_set_latin1_default_null` = 'focus' WHERE `col_float_not_null` < 'other'  /* QNO 170 CON_ID 19 */", packet_length=135, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1806
#20 0x000055a68bf03e54 in do_command (thd=0x7efff4000b00) at /data/src/10.2/sql/sql_parse.cc:1360
#21 0x000055a68c052646 in do_handle_one_connection (connect=0x55a68eabe0b0) at /data/src/10.2/sql/sql_connect.cc:1335
#22 0x000055a68c0523d3 in handle_one_connection (arg=0x55a68eabe0b0) at /data/src/10.2/sql/sql_connect.cc:1241
#23 0x00007f0088e94494 in start_thread (arg=0x7f0084078700) at pthread_create.c:333
#24 0x00007f008727a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Happened while running the attached test as

perl ./mtr bug.local2 --default-server-options --mem --mysqld=--sql-mode='' --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --nowarnings --repeat=20

(custom default-server-options comes from MDEV-14288 patch)


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