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)
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
Issue Links
- duplicates
-
MDEV-11622 Mariadb= 10.1.17-MariaDB get crashed after disabling query_cache_type on fly
- Closed
- relates to
-
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
- Confirmed
-
MDEV-10498 10.1.9-MariaDB-log MariaDB Server crashed while changing Query cache
- Closed
-
MDEV-12156 10.1.21 crash
- Closed
-
MDEV-16368 server crash when query_cache_type is changed
- Confirmed