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

[Draft] Server crashes in Query_cache_query::lock_writing

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7
    • Fix Version/s: N/A
    • Component/s: Query Cache
    • Labels:
      None

      Description

      The draft test case is attached. The failure is reproducible reliably at the moment, but as it happens with query cache issues, it requires exact lengths and order of queries, so cleaning up the test case takes long time. It's neither new nor extremely urgent, so it can be postponed for a little while.

      10.3 80da35a3

      #3  <signal handler called>
      #4  0x000056450beed5a8 in start_rwlock_wait_v1 (state=0x7fb49494f8b0, rwlock=0xa5a5a50000000002, op=PSI_RWLOCK_WRITELOCK, src_file=0x56450bfea968 "/data/src/10.3/sql/sql_cache.cc", src_line=919) at /data/src/10.3/storage/perfschema/pfs.cc:2318
      #5  0x000056450b354442 in inline_mysql_rwlock_wrlock (that=0x56450ee10370, src_file=0x56450bfea968 "/data/src/10.3/sql/sql_cache.cc", src_line=919) at /data/src/10.3/include/mysql/psi/mysql_thread.h:956
      #6  0x000056450b354a08 in Query_cache_query::lock_writing (this=0x56450ee10368) at /data/src/10.3/sql/sql_cache.cc:919
      #7  0x000056450b34da18 in Query_cache::invalidate_query_block_list (this=0x56450c9ef260 <query_cache>, thd=0x7fb448000d90, list_root=0x56450ee1af28) at /data/src/10.3/sql/sql_cache.cc:3362
      #8  0x000056450b34d9cb in Query_cache::invalidate_table_internal (this=0x56450c9ef260 <query_cache>, thd=0x7fb448000d90, key=0x7fb4480ff1e0 "test", key_length=8) at /data/src/10.3/sql/sql_cache.cc:3339
      #9  0x000056450b34d94f in Query_cache::invalidate_table (this=0x56450c9ef260 <query_cache>, thd=0x7fb448000d90, key=0x7fb4480ff1e0 "test", key_length=8) at /data/src/10.3/sql/sql_cache.cc:3317
      #10 0x000056450b34d8a0 in Query_cache::invalidate_table (this=0x56450c9ef260 <query_cache>, thd=0x7fb448000d90, table=0x7fb448102a20) at /data/src/10.3/sql/sql_cache.cc:3300
      #11 0x000056450b34d82e in Query_cache::invalidate_table (this=0x56450c9ef260 <query_cache>, thd=0x7fb448000d90, table_list=0x7fb448012bc8) at /data/src/10.3/sql/sql_cache.cc:3286
      #12 0x000056450b34ad73 in Query_cache::invalidate (this=0x56450c9ef260 <query_cache>, thd=0x7fb448000d90, tables_used=0x7fb448012bc8, using_transactions=0 '\000') at /data/src/10.3/sql/sql_cache.cc:2249
      #13 0x000056450b384f56 in mysql_insert (thd=0x7fb448000d90, table_list=0x7fb448012bc8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.3/sql/sql_insert.cc:1128
      #14 0x000056450b3c9340 in mysql_execute_command (thd=0x7fb448000d90) at /data/src/10.3/sql/sql_parse.cc:4504
      #15 0x000056450b3d4bfa in mysql_parse (thd=0x7fb448000d90, rawbuf=0x7fb448012ad8 "INSERT INTO CC ( `pk` ) VALUES (NULL)", length=37, parser_state=0x7fb4949505b0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7870
      #16 0x000056450b3c142f in dispatch_command (command=COM_QUERY, thd=0x7fb448000d90, packet=0x7fb448008f31 "INSERT INTO CC ( `pk` ) VALUES (NULL)", packet_length=37, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1852
      #17 0x000056450b3bfded in do_command (thd=0x7fb448000d90) at /data/src/10.3/sql/sql_parse.cc:1398
      #18 0x000056450b53c602 in do_handle_one_connection (connect=0x56450f22f9e0) at /data/src/10.3/sql/sql_connect.cc:1403
      #19 0x000056450b53c36d in handle_one_connection (arg=0x56450f22f9e0) at /data/src/10.3/sql/sql_connect.cc:1308
      #20 0x000056450beec090 in pfs_spawn_thread (arg=0x56450f2d43e0) at /data/src/10.3/storage/perfschema/pfs.cc:1869
      #21 0x00007fb49b834ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #22 0x00007fb49b764def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

        Attachments

          Activity

            People

            Assignee:
            elenst Elena Stepanova
            Reporter:
            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.