State:Closed|icon_flix|icon_bug|database:public|Resolution:None|TargetRelease:Flix 6.5.0|BugID:518209|
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 mysqldump:mysqldump -h MYSQL_HOSTNAME -uMYSQL_USERNAME -p MYSQL_FLIX_DATABASE | gzip > flix_mysql_dump.sql.gz We're sorry to hear that
Please tell us why