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.5, 10.6, 11.1(EOL), 11.4, 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.3(EOL)
    • 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. log.err
          12 kB
        2. log.err
          30 kB
        3. log.err
          117 kB
        4. log.err
          16 kB
        5. mdev10777.yy
          1 kB
        6. my.cnf
          4 kB
        7. mysql-general.log
          3.19 MB
        8. mysql-general.log
          4.71 MB
        9. mysql-general.log.gz
          709 kB
        10. mysql-general.log.gz
          2.81 MB
        11. oltp.yy
          2 kB
        12. threads1
          58 kB
        13. threads2
          67 kB
        14. threads4
          44 kB
        15. threads5
          12 kB

        Issue Links

          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.