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

• Submitted: 10 Sep 2014 6:20
• Modified: 9 Jan 2015 9:57
• Reporter: Roel Van de Paar
• Status: Duplicate
• Category: MySQL Server: Query Cache
• Severity: S2 (Serious)
• Version: 5.6.20
• OS: Any
• CPU Architecture: Any

[10 Sep 2014 6:20] Roel Van de Paar

Description:
Thread 1 (LWP 30616):
+bt
#0  0x00007f1fe0946771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000a9035e in my_write_core (sig=6) at /bzr/mysql-5.6/mysys/stacktrace.c:422
#2  0x0000000000723688 in handle_fatal_signal (sig=6) at /bzr/mysql-5.6/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f1fdf752989 in raise () from /lib64/libc.so.6
#5  0x00007f1fdf754098 in abort () from /lib64/libc.so.6
#6  0x00007f1fdf74b8f6 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f1fdf74b9a2 in __assert_fail () from /lib64/libc.so.6
#8  0x00000000007752d7 in Query_cache::end_of_result (this=0x17d9e00 <query_cache>, thd=0x7f1fac66c000) at /bzr/mysql-5.6/sql/sql_cache.cc:1012
#9  0x00000000007cd962 in dispatch_command (command=COM_QUERY, thd=0x7f1fac66c000, packet=0x7f1fac679001 "", packet_length=42) at /bzr/mysql-5.6/sql/sql_parse.c
c:1760
#10 0x00000000007cb646 in do_command (thd=0x7f1fac66c000) at /bzr/mysql-5.6/sql/sql_parse.cc:1034
#11 0x0000000000793a61 in do_handle_one_connection (thd_arg=0x7f1fac66c000) at /bzr/mysql-5.6/sql/sql_connect.cc:982
#12 0x000000000079354a in handle_one_connection (arg=0x7f1fac66c000) at /bzr/mysql-5.6/sql/sql_connect.cc:898
#13 0x0000000000ade888 in pfs_spawn_thread (arg=0x7f1facabc200) at /bzr/mysql-5.6/storage/perfschema/pfs.cc:1860
#14 0x00007f1fe0941df3 in start_thread () from /lib64/libpthread.so.0
#15 0x00007f1fdf8133dd in clone () from /lib64/libc.so.6

How to repeat:
Execute cmd3 in attached bundle using the yy/zz supplied (change dirs as needed)

[10 Sep 2014 6:36] Roel Van de Paar

I've uploaded mysql-bug-73868-BUNDLE_3.tar.gz to SFTP server which contains all info (core, stack traces, detailed stack traces, cmd used, vardir etc.)

[13 Nov 2014 14:01] MySQL Verification Team

Hello Roel,

Thank you for the report.
This is duplicate of Shane's internally reported Bug 18067930 - ASSERTION THD->GET_STMT_DA()->IS_EOF() IN QUERY_CACHE::END_OF_RESULT 

Thanks,
Umesh