Score:0

MySQL Dump on Ubuntu 20.04 returns 0 byte file and runs indefinitely. Works on Ubuntu 18.04

za flag

I am using identical configs on Ubuntu 20.04 as I was previously on 18.04; however, on 20.04 the CPU shoots up to 50% usage and the process runs indefinitely, and by indefinitely I mean it was running for over 24hr when I caught the issue. I am completely stumped on why this is not working on 20.04. Mysqldump is installed using the following command:

sudo apt-get update
sudo apt-get install -y --no-install-recommends mysql-client

Output of mysqldump -V Ubuntu 20.04:

mysqldump  Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

Output of mysqldump -V Ubuntu 18.04:

mysqldump  Ver 10.13 Distrib 5.7.36, for Linux (x86_64)

Terminal command:

sudo mysqldump --defaults-file=/var/mysqldump/conf.cfg test_db | gzip > /var/tmp/backup.gz

Contents of conf.cfg:

[client]
host=xxx
user=xxx@db
password=xxx

[mysqldump]
quick
single-transaction
skip-lock-tables

Why would this work on Ubuntu 18.04, but fails indefinitely while consuming CPU resources on 20.04? Is there a settings change on 20.04 that I have overlooked?

br flag
What does it do if you don't pipe the output to `gzip`?
JimmyBanks avatar
za flag
@Bert Same issue unfortunately, a blank 0 byte .sql file instead of a blank 0 byte .gz file
Score:0
za flag

Appears to be a bug with 8.0.27: https://bugs.mysql.com/bug.php?id=105288

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.