[MDEV-16286] Killed CREATE SEQUENCE leaves sequence in unusable state Created: 2018-05-24 Updated: 2018-05-27 Resolved: 2018-05-27 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Sequences |
| Affects Version/s: | 10.3 |
| Fix Version/s: | 10.3.8 |
| Type: | Bug | Priority: | Major |
| Reporter: | Elena Stepanova | Assignee: | Michael Widenius |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Note: Run with --repeat=N if it's not reproducible right away.
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:
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. |
| Comments |
| Comment by Michael Widenius [ 2018-05-27 ] |
|
Fixed by deleting the sequence if we where not able to initialize it |