Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15484

[Draft] Assertion `element->m_flush_tickets.is_empty()' failed in tdc_assert_clean_share

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2
    • None
    • Server
    • None

    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)

      Attachments

        1. local2.test
          960 kB
        2. threads
          48 kB

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.