group.of.nepali.translators team mailing list archive

[Bryce Harrington <1914695@xxxxxxxxxxxxxxxxxx>]

** Also affects: mysql-5.7 (Ubuntu Xenial)
   Importance: Undecided
       Status: New

** Changed in: mysql-5.7 (Ubuntu)
       Status: New => Fix Released

-- 
You received this bug notification because you are a member of नेपाली
भाषा समायोजकहरुको समूह, which is subscribed to Xenial.
Matching subscriptions: Ubuntu 16.04 Bugs
https://bugs.launchpad.net/bugs/1914695

Title:
  mysqldump --all-databases not dumping any databases with 5.7.33

Status in mysql-5.7 package in Ubuntu:
  Fix Released
Status in mysql-5.7 source package in Xenial:
  New

Bug 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.

  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

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1914695/+subscriptions