Public bug reported: 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 ** Affects: mysql-5.7 (Ubuntu) Importance: Undecided Status: New ** Description changed: 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. + 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. + 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 ** Description changed: 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 + 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 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1914695 Title: mysqldump --all-databases not dumping with 5.7.33 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1914695/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs