ID 518209 - Unable to backup large databases via Flix

Follow

Problem summary
Unable to use the Flix backup process on large databases as it will run out of memory and crash.
Tested on a database with 44,513,407 total rows across tables adding up to a total size of 7322 MB, with a Flix server having 64GB RAM available.
 
Customer reported version
Flix 6.4.0
 
Steps to reproduce
1) Have a database of at least 7 GB
2) Run the Flix server with the --db-backup flag
 
Expected behaviour
The backup process should complete
 
Actual behaviour
The backup process unnecessarily takes up all available memory and crashes:

DEBU[5898]dump.go#L234 mysqldump.createTableValues: creating values                               Table name=sequence_panelfatal error: runtime: out of memory
 
Workaround
Make sure to turn off all Flix servers and then back up the database using mysqldump:
mysqldump -h MYSQL_HOSTNAME -uMYSQL_USERNAME -p MYSQL_FLIX_DATABASE | gzip > flix_mysql_dump.sql.gz
 
Reproduced by support
This bug has been reproduced in:
6.4.1 - CentOS 7
6.2.0 - CentOS 7
 
Earliest version tested
6.2.0 - This issue appears to be in all tested versions of the product

    We're sorry to hear that

    Please tell us why