Bug #98310 MySQL enterprise backup is failing when Full text index exists
Submitted: 21 Jan 2020 14:45 Modified: 22 Jan 2020 10:39
Reporter: Bharathkumar Hegde Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Backup Severity:S3 (Non-critical)
Version:4.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: full text index, ibd, mysqlbackup, tts

[21 Jan 2020 14:45] Bharathkumar Hegde
Description:
On Running `mysqlbackup` with --use-tts and --include option to backup all tables in a database, got following error.

200121 20:07:23 RDR1 ERROR: MySQL query 'FLUSH TABLES `sakila`.`FTS_0000000000000031_0000000000000045_INDEX_1`,`sakila`.`FTS_0000000000000031_0000000000000045_INDEX_2`,`sakila`.`FTS_0000000000000031_0000000000000045_INDEX_3`,`sakila`.`FTS_0000000000000031_0000000000000045_INDEX_4`,`sakila`.`FTS_0000000000000031_0000000000000045_INDEX_5`,`sakila`.`FTS_0000000000000031_0000000000000045_INDEX_6`,`sakila`.`FTS_0000000000000031_BEING_DELETED`,`sakila`.`FTS_0000000000000031_BEING_DELETED_CACHE`,`sakila`.`FTS_0000000000000031_CONFIG`,`sakila`.`FTS_0000000000000031_DELETED`,`sakila`.`FTS_0000000000000031_DELETED_CACHE`,`sakila`.`actor`,`sakila`.`address`,`sakila`.`category`,`sakila`.`city`,`sakila`.`country`,`sakila`.`customer`,`sakila`.`film`,`sakila`.`film_actor`,`sakila`.`film_category`,`sakila`.`film_text`,`sakila`.`inventory`,`sakila`.`language`,`sakila`.`payment`,`sakila`.`rental`,`sakila`.`staff`,`sakila`.`store` FOR EXPORT': 1146, Table 'sakila.FTS_0000000000000031_0000000000000045_INDEX_1' doesn't exist

Looks like the tool is trying to export based on the ibd files not based on the tables availables under a database.

How to repeat:
Run Mysql Enterprise backup on a server which has MySql provided standard Sakila database.

mysqlbackup --defaults-file="/etc/my.cnf" -u "root" -p'Commvault!12' --socket="/var/lib/mysql/mysql.sock" --backup-image="Sakila-0806" --backup-dir="/bhsbt/backup/Sakila-0806/full" --include="^sakila\." --use-tts backup-to-image
[22 Jan 2020 10:39] MySQL Verification Team
Hello Bharathkumar Hegde,

Thank you for the report and feedback.

regards,
Umesh