[MDEV-29243] Assertion `is_last_prefix <= 0' failed at opt_range.cc:15436 Created: 2022-08-04 Updated: 2023-11-13 Resolved: 2022-08-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Insert |
| Affects Version/s: | 10.8.3 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Critical |
| Reporter: | Zuming Jiang | Assignee: | Oleg Smirnov |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | crash | ||
| Environment: |
Ubuntu 20.04 |
||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
I used my fuzzing tool to test MariaDB and found a transaction-related bug that make the crashes. Mariadb installation Setup the environment Reproduce bug Note: must in READ COMMITTED isolation level /usr/local/mysql/bin/mysql -uroot -Dtestdb # set up connection conn_0 conn_0> SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; conn_1> SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; conn_1> START TRANSACTION; conn_0> START TRANSACTION; conn_1> delete from t_swbayb; conn_0> insert into t_swbayb (wkey, pkey) values (88, 74000); conn_1> insert into t_8fjoxb (wkey, pkey, c_yecif) values conn_0> insert into t_swbayb (wkey, pkey, c_ywdp4d) values (90, 83000, 'vyenkd'); conn_0> COMMIT; --- this COMMIT make the above INSERT in conn_1 crash the MariaDB server conn_1> COMMIT; I have simplified the content of the test case, and I hope this report can help you reproduce and fix the bug. In addition, I attached the failure report (which has its stack trace). |