Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
Note: Run with --repeat=N if it's not reproducible right away.
--connect (con1,localhost,root,,test)
|
--let $conid= `SELECT CONNECTION_ID()`
|
--send
|
CREATE SEQUENCE s; |
--connection default
|
--eval KILL $conid
|
--error 0,ER_NO_SUCH_TABLE
|
SELECT NEXTVAL(s); |
 |
# Cleanup
|
DROP SEQUENCE s; |
The test case above kills a connection in the process of creating a sequence. Expected outcomes are that the sequence either doesn't get created, or is fully functional. However, most often it's created, but remains unusable, attempts to refer to it end up with ER_KEY_NOT_FOUND:
10.3 96cee524fe |
mysqltest: At line 8: query 'SELECT NEXTVAL(s)' failed with wrong errno 1032: 'Can't find record in 's'', instead of 0...
|
It fails nearly every time for me, but it's still a race condition, so sometimes it misses the mark. Run with --repeat if it doesn't fail for you.