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

Assertion `thd->get_stmt_da()->is_eof()' failed in Query_cache::end_of_result

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.1(EOL), 11.3(EOL), 11.4
    • 10.5, 10.6
    • Query Cache

    Description

      Comments to this bug contain various observations, non-deterministic tests which could be no longer applicable, and so on.They are an optional read for whoever ends up fixing this bug, there is no need to check every test mentioned there, only the one here in the description; but I preserve them mainly to keep all the variety of stack traces searchable in JIRA. All attachments also relate to comments, not to the description.

      10.4 0b8b11b0

      		 
      mysqld: /data/src/10.4/sql/sql_cache.cc:1175: void Query_cache::end_of_result(THD*): Assertion `thd->get_stmt_da()->is_eof()' failed.
      		 
      191204 17:25:26 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
      # 2019-12-04T17:25:40 [15637] #3  0x00007f38a5705f12 in __GI___assert_fail (assertion=0x55c90441007a "thd->get_stmt_da()->is_eof()", file=0x55c90440fbf0 "/data/src/10.4/sql/sql_cache.cc", line=1175, function=0x55c904412320 <Query_cache::end_of_result(THD*)::__PRETTY_FUNCTION__> "void Query_cache::end_of_result(THD*)") at assert.c:101
      		 
      # 2019-12-04T17:25:40 [15637] #4  0x000055c9036a251b in Query_cache::end_of_result (this=0x55c9050ab260 <query_cache>, thd=0x7f3834000af0) at /data/src/10.4/sql/sql_cache.cc:1175
      		 
      # 2019-12-04T17:25:40 [15637] #5  0x000055c903729696 in dispatch_command (command=COM_QUERY, thd=0x7f3834000af0, packet=0x7f3834008261 "", packet_length=40, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:2435
      		 
      # 2019-12-04T17:25:40 [15637] #6  0x000055c903725bb9 in do_command (thd=0x7f3834000af0) at /data/src/10.4/sql/sql_parse.cc:1360
      		 
      # 2019-12-04T17:25:40 [15637] #7  0x000055c9038ae6a7 in do_handle_one_connection (connect=0x55c90800ced0) at /data/src/10.4/sql/sql_connect.cc:1412
      		 
      # 2019-12-04T17:25:40 [15637] #8  0x000055c9038ae3f6 in handle_one_connection (arg=0x55c90800ced0) at /data/src/10.4/sql/sql_connect.cc:1316
      		 
      # 2019-12-04T17:25:40 [15637] #9  0x00007f38a727b4a4 in start_thread (arg=0x7f38a41f3700) at pthread_create.c:456
      		 
      # 2019-12-04T17:25:40 [15637] #10 0x00007f38a57c2d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

      Steps to reproduce

      		 
      git clone https://github.com/MariaDB/randgen --branch mdev10826 rqg-mdev10826
      		 
      cd rqg-mdev10826
      		 
      perl ./runall-new.pl --basedir=<basedir> --grammar=./mdev10826.yy --duration=350 --threads=8 --seed=1 --mysqld=--query-cache-type=1 --skip-gendata --vardir=/dev/shm/vardir-mdev10826

      Remember to set the right basedir in the command line above.
      Make sure you use the RQG version as described above. There is no guarantee that another one will work the same way.

      Reproducible on current 10.1-10.5. Couldn't reproduce on 5.5.

      Attachments

        1. threads5
          12 kB
        2. threads4
          44 kB
        3. threads2
          67 kB
        4. threads1
          58 kB
        5. oltp.yy
          2 kB
        6. mysql-general.log.gz
          2.81 MB
        7. mysql-general.log.gz
          709 kB
        8. mysql-general.log
          4.71 MB
        9. mysql-general.log
          3.19 MB
        10. my.cnf
          4 kB
        11. mdev10777.yy
          1 kB
        12. log.err
          16 kB
        13. log.err
          117 kB
        14. log.err
          30 kB
        15. log.err
          12 kB

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11622 Mariadb= 10.1.17-MariaDB get crashed after disabling query_cache_type on fly

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23127 Server crash in Query_cache::double_linked_list_exclude or Assertion `table_block_data->m_cached_query_count >= 0' failed in Query_cache::unlink_table

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10498 10.1.9-MariaDB-log MariaDB Server crashed while changing Query cache

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12156 10.1.21 crash

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16368 server crash when query_cache_type is changed

          • Major - Major loss of function.
          • Confirmed

          Activity

            People

              sanja Oleksandr Byelkin
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.