Resolving stuck database imports in Adobe Commerce Cloud
This article explains how to resolve issues where database imports in Adobe Commerce Cloud become stuck due to InnoDB Full-Text Search (FTS) limitations or other configuration constraints. Generate and then import a new database dump to bypass the FTS feature.
Description description
Environment
Adobe Commerce Cloud
Issue/Symptoms
During a database dump import into the environment, the process may appear stuck, leaving the environment unusable. A common cause is an error related to the InnoDB Full-Text Search (FTS) feature. This occurs when the full-text search index size exceeds the configured cache size (innodb_ft_cache_size
).
An error similar to the following may appear:
InnoDB:Total InnoDB FTS size X for the table Y exceeds the innodb_ft_cache_size Z
Resolution resolution
To resolve this issue, generate a new database dump to bypass the FTS feature and then import the new dump.
-
Disable full-text indexes during dump:
- Drop the full-text indexes before creating the database dump and recreate them after the import.
ALTER TABLE table_name DROP INDEX index_name
-
Use
--skip-extended-insert
option:- Generate the dump using the
--skip-extended-insert
option to create separateINSERT
statements for each row, reducing memory usage during import. mysqldump --skip-extended-insert -u username -p database_name > dumpfile.sql
- Generate the dump using the
-
Use
--single-transaction
option:- Use the
--single-transaction
option to create a consistent snapshot of the database without locking tables. This is helpful for large databases. mysqldump --single-transaction -u username -p database_name > dumpfile.sql
- Use the
-
Support request:
- Submit a support request to restart MySQL services
-
Restart MySQL:
- If restarting MySQL services does not resolve the issue, drop and recreate the database.
-
Documentation
- Import your functional database dump after the above steps. Follow the guide here: Import Your Database.
Related Readings
For more information, refer to the following articles in the Commerce on Cloud Infrastructure Guide: