MDEV-34057 Inconsistent FTS state in concurrent scenarios

[Thirunarayanan]

trafficstars

• [x] The Jira issue number for this PR is: MDEV-34057

Description

• InnoDB FTS can be in inconsistent state when sync operation terminates the server before committing the operation. This could lead to incorrect synced doc id and incorrect query results. Fix:
• During sync commit operation, InnoDB should pass the sync transaction to update the max doc id in the config table.

How can this PR be tested?

./mtr innodb_fts.fts_sync_commit_resiliency

Basing the PR against the correct MariaDB version

• [ ] This is a new feature and the PR is based against the latest MariaDB development branch.
• [x] This is a bug fix and the PR is based against the earliest maintained branch in which the bug can be reproduced.

PR quality check

• [x] I checked the CODING_STANDARDS.md file and my PR conforms to this where appropriate.
• [x] For any trivial modifications to the PR, I am ok with the reviewer making the changes themselves.

[CLAassistant]

Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
_{You have signed the CLA already but the status is still pending? Let us recheck it.}