mariadb/mysql-test/suite/innodb_fts
Thirunarayanan Balathandayuthapani 6ec57588bd MDEV-30363 InnoDB: Failing assertion: trx->error_state == DB_SUCCESS in que_run_threads
Problem:
=========
- During truncation of a fulltext table, InnoDB does create the
table and does insert the default config fts values in fulltext
common config table using create table transaction.

- Before committing the create table transaction, InnoDB does update
the dictionary by loading the stopword into fts cache
and write the stopword configuration into fulltext common
config table by creating a separate transaction. This leads to
lock wait timeout error and rollbacks the transaction.

- But truncate table holds dict_sys.lock and rollback also
tries to acquire dict_sys.lock. This leads to assertion during
rollback.

Solution:
=========
ha_innobase::truncate(): Commit the create table transaction
before updating the dictionary after create table.
2025-06-16 11:48:06 +02:00
..
r MDEV-30363 InnoDB: Failing assertion: trx->error_state == DB_SUCCESS in que_run_threads 2025-06-16 11:48:06 +02:00
t MDEV-30363 InnoDB: Failing assertion: trx->error_state == DB_SUCCESS in que_run_threads 2025-06-16 11:48:06 +02:00