Bug #83786 Server crash in Prepared_statement::close_cursor
Submitted: 11 Nov 2016 9:27 Modified: 13 Dec 2016 17:05
Reporter: Shipra Jain Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[11 Nov 2016 9:27] Shipra Jain
Description:
Test MYSQL_CLIENT_TEST failing on latest trunk 

http://pb2.no.oracle.com/?template=mysql_show_test_failure&search=yes&push_id=10305609&tes...

 Thread pointer: 0x7ff7cc000be0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7ff84ca82e40 thread_stack 0x40000 /export/home/pb2/test/sb_2-21147589-1478811255.46/mysql/usr/sbin/mysqld-debug(my_print_stacktrace+0x43) [0x254d40c] /export/home/pb2/test/sb_2-21147589-1478811255.46/mysql/usr/sbin/mysqld-debug(handle_fatal_signal+0x406) [0x1ccde8d] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf8d0) [0x7ff854df28d0] /export/home/pb2/test/sb_2-21147589-1478811255.46/mysql/usr/sbin/mysqld-debug(Prepared_statement::close_cursor()+0x2e) [0x1a2edbe] /export/home/pb2/test/sb_2-21147589-1478811255.46/mysql/usr/sbin/mysqld-debug(Prepared_statement::execute(String*, bool)+0x197) [0x1a30aa9] /export/home/pb2/test/sb_2-21147589-1478811255.46/mysql/usr/sbin/mysqld-debug(Prepared_statement::execute_loop(String*, bool, st_ps_param*)+0x1b6) [0x1a3009e] /export/home/pb2/test/sb_2-21147589-1478811255.46/mysql/usr/sbin/mysqld-debug(mysqld_stmt_execute(THD*, Prepared_statement*, bool, unsigned long, st_ps_param*)+0x185) [0x1a2dd99] /export/home/pb2/test/sb_2-21147589-1478811255.46/mysql/usr/sbin/mysqld-debug(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x96c) [0x19f172c] /export/home/pb2/test/sb_2-21147589-1478811255.46/mysql/usr/sbin/mysqld-debug(do_command(THD*)+0x442) [0x19f0a67] /export/home/pb2/test/sb_2-21147589-1478811255.46/mysql/usr/sbin/mysqld-debug() [0x1cc016d] /export/home/pb2/test/sb_2-21147589-1478811255.46/mysql/usr/sbin/mysqld-debug() [0x2572c22] /lib/x86_64-linux-gnu/libpthread.so.0(+0x80a4) [0x7ff854deb0a4] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7ff8538ae04d]

Please note that it started to fail from commit "136b1688bd3ecdfaef462b8a04b4560998e6db02" which enables few of the innodb tests to run by removing innodb checks ( which were getting skipped). However the culprit commit which caused this crash is the commit just before ie "ba3bbfa5fb709dc69b5e31bacc3426b2891b5c15" . 

How to repeat:
./mtr main.mysql_client_test.test

Please note that it can be reproduced only after commit ""136b1688bd3ecdfaef462b8a04b4560998e6db02" which enables few of the innodb tests to run by removing innodb checks ( which were getting skipped before). Also  if one reset to the commit just before Catalin's WL ie Wl#8413, main.mysql_client_test.test works fine.

So its the new test which got enabled using commit ""136b1688bd3ecdfaef462b8a04b4560998e6db02" getting failed for Wl#8413.
[13 Dec 2016 17:05] Paul DuBois
Posted by developer:
 
Fixed in 8.0.1.

Bug affects no released version. No changelog entry needed.