2021-02-05 02:59:02 |
Ian Wienand |
bug |
|
|
added bug |
2021-02-05 03:00:14 |
Ian Wienand |
description |
Since the 5.7.33 upgrade, our Xenial host, talking to an old server that reports itself as 5.1.73-1+deb6u1 is no long dumping all databases with "--all-databases". It connects, exits with 0 and puts out some info, but the actual databases are not dumped at all.
I ran strace on it and I can see mysqldump running the query and getting a response, then it does a sync or something and seems to die.
---
13362 sendto(3, "\17\0\0\0\3SHOW DATABASES", 19, 0, NULL, 0) = 19
13362 recvfrom(3, "\1\0\0\1\0011\0\0\2\3def\0\10SCHEMATA\0\10Database\vSCHEMA_NAME\f!\0\300\0\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\"\0\23\0\0\4\22information_schema\7\0\0\5\6zanata\5\0\0\6\376\0\0\"\0", 16384, 0, NULL, NULL) = 110
13362 sendto(3, "'\0\0\0\3SHOW VARIABLES LIKE 'ndbinfo\\_version'", 43, 0, NULL, 0) = 43
13362 recvfrom(3, "\1\0\0\1\0029\0\0\2\3def\0\tVARIABLES\0\rVariable_name\rVARIABLE_NAME\f!\0\300\0\0\0\375\1\0\0\0\0002\0\0\3\3def\0\tVARIABLES\0\5Value\16VARIABLE_VALUE\f!\0\0\f\0\0\375\0\0\0\0\0\5\0\0\4\376\0\0\"\0\5\0\0\5\376\0\0\"\0", 16384, 0, NULL, NULL) = 138
13362 fdatasync(1) = -1 EINVAL (Invalid argument)
13362 sendto(3, "\1\0\0\0\1", 5, 0, NULL, 0) = 5
13362 shutdown(3, SHUT_RDWR) = 0
---
the "zanata" db should be dumped, it clearly seemed to respond with the db.
I installed 5.7.32 from [1] and it works. Here is the similar trace
---
15847 sendto(3, "\17\0\0\0\3SHOW DATABASES", 19, 0, NULL, 0) = 19
15847 recvfrom(3, "\1\0\0\1\0011\0\0\2\3def\0\10SCHEMATA\0\10Database\vSCHEMA_NAME\f!\0\300\0\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\"\0\23\0\0\4\22information_schema\7\0\0\5\6zanata\5\0\0\6\376\0\0\"\0", 16384, 0, NULL, NULL) = 110
15847 sendto(3, "'\0\0\0\3SHOW VARIABLES LIKE 'ndbinfo\\_version'", 43, 0, NULL, 0) = 43
15847 recvfrom(3, "\1\0\0\1\0029\0\0\2\3def\0\tVARIABLES\0\rVariable_name\rVARIABLE_NAME\f!\0\300\0\0\0\375\1\0\0\0\0002\0\0\3\3def\0\tVARIABLES\0\5Value\16VARIABLE_VALUE\f!\0\0\f\0\0\375\0\0\0\0\0\5\0\0\4\376\0\0\"\0\5\0\0\5\376\0\0\"\0", 16384, 0, NULL, NULL) = 138
15847 sendto(3, "\7\0\0\0\2zanata", 11, 0, NULL, 0) = 11
15847 recvfrom(3, "\7\0\0\1\0\0\0\2\0\0\0", 16384, 0, NULL, NULL) = 11
15847 write(1, "\n--\n-- Current Database: `zanata`\n--\n", 37) = 37
... and the db dumps ...
---
I note that [2] has a note
---
When invoked with the --all-databases option, mysqldump now dumps the mysql database first, so that when the dump file is reloaded, any accounts named in the DEFINER clause of other objects will already have been created. (Bug #32141046)
---
possibly this is related.
This is quite unfortunate because you think your backup is working, but it's silently failing
[1] https://launchpad.net/~ubuntu-security/+archive/ubuntu/ppa/+build/20177589
[2] https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-33.html |
Since the 5.7.33 upgrade, our Xenial host, talking to an old server that reports itself as 5.1.73-1+deb6u1 is no long dumping all databases with "--all-databases". It connects, exits with 0 and puts out some info, but the actual databases are not dumped at all.
I ran strace on it and I can see mysqldump running the query and getting a response, then it does a sync and proceeds to exit.
---
13362 sendto(3, "\17\0\0\0\3SHOW DATABASES", 19, 0, NULL, 0) = 19
13362 recvfrom(3, "\1\0\0\1\0011\0\0\2\3def\0\10SCHEMATA\0\10Database\vSCHEMA_NAME\f!\0\300\0\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\"\0\23\0\0\4\22information_schema\7\0\0\5\6zanata\5\0\0\6\376\0\0\"\0", 16384, 0, NULL, NULL) = 110
13362 sendto(3, "'\0\0\0\3SHOW VARIABLES LIKE 'ndbinfo\\_version'", 43, 0, NULL, 0) = 43
13362 recvfrom(3, "\1\0\0\1\0029\0\0\2\3def\0\tVARIABLES\0\rVariable_name\rVARIABLE_NAME\f!\0\300\0\0\0\375\1\0\0\0\0002\0\0\3\3def\0\tVARIABLES\0\5Value\16VARIABLE_VALUE\f!\0\0\f\0\0\375\0\0\0\0\0\5\0\0\4\376\0\0\"\0\5\0\0\5\376\0\0\"\0", 16384, 0, NULL, NULL) = 138
13362 fdatasync(1) = -1 EINVAL (Invalid argument)
13362 sendto(3, "\1\0\0\0\1", 5, 0, NULL, 0) = 5
13362 shutdown(3, SHUT_RDWR) = 0
---
the "zanata" db should be dumped, it clearly seemed to respond with the db so there isn't any problem with the connection, etc.
I installed 5.7.32 from [1] and it works. Here is the similar trace
---
15847 sendto(3, "\17\0\0\0\3SHOW DATABASES", 19, 0, NULL, 0) = 19
15847 recvfrom(3, "\1\0\0\1\0011\0\0\2\3def\0\10SCHEMATA\0\10Database\vSCHEMA_NAME\f!\0\300\0\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\"\0\23\0\0\4\22information_schema\7\0\0\5\6zanata\5\0\0\6\376\0\0\"\0", 16384, 0, NULL, NULL) = 110
15847 sendto(3, "'\0\0\0\3SHOW VARIABLES LIKE 'ndbinfo\\_version'", 43, 0, NULL, 0) = 43
15847 recvfrom(3, "\1\0\0\1\0029\0\0\2\3def\0\tVARIABLES\0\rVariable_name\rVARIABLE_NAME\f!\0\300\0\0\0\375\1\0\0\0\0002\0\0\3\3def\0\tVARIABLES\0\5Value\16VARIABLE_VALUE\f!\0\0\f\0\0\375\0\0\0\0\0\5\0\0\4\376\0\0\"\0\5\0\0\5\376\0\0\"\0", 16384, 0, NULL, NULL) = 138
15847 sendto(3, "\7\0\0\0\2zanata", 11, 0, NULL, 0) = 11
15847 recvfrom(3, "\7\0\0\1\0\0\0\2\0\0\0", 16384, 0, NULL, NULL) = 11
15847 write(1, "\n--\n-- Current Database: `zanata`\n--\n", 37) = 37
... and the db dumps ...
---
I note that [2] has a note
---
When invoked with the --all-databases option, mysqldump now dumps the mysql database first, so that when the dump file is reloaded, any accounts named in the DEFINER clause of other objects will already have been created. (Bug #32141046)
---
possibly this is related.
This is quite unfortunate because you think your backup is working, but it's silently failing
[1] https://launchpad.net/~ubuntu-security/+archive/ubuntu/ppa/+build/20177589
[2] https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-33.html |
|
2021-02-05 03:02:15 |
Ian Wienand |
description |
Since the 5.7.33 upgrade, our Xenial host, talking to an old server that reports itself as 5.1.73-1+deb6u1 is no long dumping all databases with "--all-databases". It connects, exits with 0 and puts out some info, but the actual databases are not dumped at all.
I ran strace on it and I can see mysqldump running the query and getting a response, then it does a sync and proceeds to exit.
---
13362 sendto(3, "\17\0\0\0\3SHOW DATABASES", 19, 0, NULL, 0) = 19
13362 recvfrom(3, "\1\0\0\1\0011\0\0\2\3def\0\10SCHEMATA\0\10Database\vSCHEMA_NAME\f!\0\300\0\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\"\0\23\0\0\4\22information_schema\7\0\0\5\6zanata\5\0\0\6\376\0\0\"\0", 16384, 0, NULL, NULL) = 110
13362 sendto(3, "'\0\0\0\3SHOW VARIABLES LIKE 'ndbinfo\\_version'", 43, 0, NULL, 0) = 43
13362 recvfrom(3, "\1\0\0\1\0029\0\0\2\3def\0\tVARIABLES\0\rVariable_name\rVARIABLE_NAME\f!\0\300\0\0\0\375\1\0\0\0\0002\0\0\3\3def\0\tVARIABLES\0\5Value\16VARIABLE_VALUE\f!\0\0\f\0\0\375\0\0\0\0\0\5\0\0\4\376\0\0\"\0\5\0\0\5\376\0\0\"\0", 16384, 0, NULL, NULL) = 138
13362 fdatasync(1) = -1 EINVAL (Invalid argument)
13362 sendto(3, "\1\0\0\0\1", 5, 0, NULL, 0) = 5
13362 shutdown(3, SHUT_RDWR) = 0
---
the "zanata" db should be dumped, it clearly seemed to respond with the db so there isn't any problem with the connection, etc.
I installed 5.7.32 from [1] and it works. Here is the similar trace
---
15847 sendto(3, "\17\0\0\0\3SHOW DATABASES", 19, 0, NULL, 0) = 19
15847 recvfrom(3, "\1\0\0\1\0011\0\0\2\3def\0\10SCHEMATA\0\10Database\vSCHEMA_NAME\f!\0\300\0\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\"\0\23\0\0\4\22information_schema\7\0\0\5\6zanata\5\0\0\6\376\0\0\"\0", 16384, 0, NULL, NULL) = 110
15847 sendto(3, "'\0\0\0\3SHOW VARIABLES LIKE 'ndbinfo\\_version'", 43, 0, NULL, 0) = 43
15847 recvfrom(3, "\1\0\0\1\0029\0\0\2\3def\0\tVARIABLES\0\rVariable_name\rVARIABLE_NAME\f!\0\300\0\0\0\375\1\0\0\0\0002\0\0\3\3def\0\tVARIABLES\0\5Value\16VARIABLE_VALUE\f!\0\0\f\0\0\375\0\0\0\0\0\5\0\0\4\376\0\0\"\0\5\0\0\5\376\0\0\"\0", 16384, 0, NULL, NULL) = 138
15847 sendto(3, "\7\0\0\0\2zanata", 11, 0, NULL, 0) = 11
15847 recvfrom(3, "\7\0\0\1\0\0\0\2\0\0\0", 16384, 0, NULL, NULL) = 11
15847 write(1, "\n--\n-- Current Database: `zanata`\n--\n", 37) = 37
... and the db dumps ...
---
I note that [2] has a note
---
When invoked with the --all-databases option, mysqldump now dumps the mysql database first, so that when the dump file is reloaded, any accounts named in the DEFINER clause of other objects will already have been created. (Bug #32141046)
---
possibly this is related.
This is quite unfortunate because you think your backup is working, but it's silently failing
[1] https://launchpad.net/~ubuntu-security/+archive/ubuntu/ppa/+build/20177589
[2] https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-33.html |
Since the 5.7.33 upgrade, our Xenial host, talking to an old server that reports itself as 5.1.73-1+deb6u1 is no long dumping all databases with "--all-databases". It connects, exits with 0 and puts out some info, but the actual databases are not dumped at all.
I ran strace on it and I can see mysqldump running the query and getting a response, then it does a sync and proceeds to exit.
---
13362 sendto(3, "\17\0\0\0\3SHOW DATABASES", 19, 0, NULL, 0) = 19
13362 recvfrom(3, "\1\0\0\1\0011\0\0\2\3def\0\10SCHEMATA\0\10Database\vSCHEMA_NAME\f!\0\300\0\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\"\0\23\0\0\4\22information_schema\7\0\0\5\6zanata\5\0\0\6\376\0\0\"\0", 16384, 0, NULL, NULL) = 110
13362 sendto(3, "'\0\0\0\3SHOW VARIABLES LIKE 'ndbinfo\\_version'", 43, 0, NULL, 0) = 43
13362 recvfrom(3, "\1\0\0\1\0029\0\0\2\3def\0\tVARIABLES\0\rVariable_name\rVARIABLE_NAME\f!\0\300\0\0\0\375\1\0\0\0\0002\0\0\3\3def\0\tVARIABLES\0\5Value\16VARIABLE_VALUE\f!\0\0\f\0\0\375\0\0\0\0\0\5\0\0\4\376\0\0\"\0\5\0\0\5\376\0\0\"\0", 16384, 0, NULL, NULL) = 138
13362 fdatasync(1) = -1 EINVAL (Invalid argument)
13362 sendto(3, "\1\0\0\0\1", 5, 0, NULL, 0) = 5
13362 shutdown(3, SHUT_RDWR) = 0
---
the "zanata" db should be dumped, it clearly seemed to respond with the db so there isn't any problem with the connection, etc.
I installed 5.7.32 from [1] and it works. Here is the similar trace
---
15847 sendto(3, "\17\0\0\0\3SHOW DATABASES", 19, 0, NULL, 0) = 19
15847 recvfrom(3, "\1\0\0\1\0011\0\0\2\3def\0\10SCHEMATA\0\10Database\vSCHEMA_NAME\f!\0\300\0\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\"\0\23\0\0\4\22information_schema\7\0\0\5\6zanata\5\0\0\6\376\0\0\"\0", 16384, 0, NULL, NULL) = 110
15847 sendto(3, "'\0\0\0\3SHOW VARIABLES LIKE 'ndbinfo\\_version'", 43, 0, NULL, 0) = 43
15847 recvfrom(3, "\1\0\0\1\0029\0\0\2\3def\0\tVARIABLES\0\rVariable_name\rVARIABLE_NAME\f!\0\300\0\0\0\375\1\0\0\0\0002\0\0\3\3def\0\tVARIABLES\0\5Value\16VARIABLE_VALUE\f!\0\0\f\0\0\375\0\0\0\0\0\5\0\0\4\376\0\0\"\0\5\0\0\5\376\0\0\"\0", 16384, 0, NULL, NULL) = 138
15847 sendto(3, "\7\0\0\0\2zanata", 11, 0, NULL, 0) = 11
15847 recvfrom(3, "\7\0\0\1\0\0\0\2\0\0\0", 16384, 0, NULL, NULL) = 11
15847 write(1, "\n--\n-- Current Database: `zanata`\n--\n", 37) = 37
... and the db dumps ...
---
I note that [2] has a note
---
When invoked with the --all-databases option, mysqldump now dumps the mysql database first, so that when the dump file is reloaded, any accounts named in the DEFINER clause of other objects will already have been created. (Bug #32141046)
---
possibly this is related.
This is quite unfortunate because you think your backup is working, but it's silently failing.
Specifying the individual database to mysqldump does work, it only appears to be the --all-databases option that is not working.
[1] https://launchpad.net/~ubuntu-security/+archive/ubuntu/ppa/+build/20177589
[2] https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-33.html |
|
2021-02-05 05:09:29 |
Ian Wienand |
summary |
mysqldump --all-databases not dumping with 5.7.33 |
mysqldump --all-databases not dumping any databases with 5.7.33 |
|
2021-02-05 08:18:49 |
Dr. Jens Harbott |
bug |
|
|
added subscriber Dr. Jens Harbott |
2021-02-14 05:07:37 |
Bryce Harrington |
nominated for series |
|
Ubuntu Xenial |
|
2021-02-14 05:07:37 |
Bryce Harrington |
bug task added |
|
mysql-5.7 (Ubuntu Xenial) |
|
2021-02-14 05:07:45 |
Bryce Harrington |
mysql-5.7 (Ubuntu): status |
New |
Fix Released |
|
2021-02-14 06:37:34 |
Bryce Harrington |
mysql-5.7 (Ubuntu Xenial): status |
New |
Won't Fix |
|