Ubuntu
automysqlbackup package

mysqldump: Got error: 1044: Access denied ... when using LOCAL TABLES

Bug #574202 reported by Markus Voss
44
This bug affects 6 people
Affects Status Importance Assigned to Milestone
automysqlbackup (Debian)
Fix Released
Unknown
automysqlbackup (Ubuntu)
Fix Released
Medium
Unassigned
Lucid
Fix Released
Medium
Unassigned

Bug Description

Binary package hint: automysqlbackup

Distribution: Lucix Lynx (all packages updated)
Mysql Version: MySQL 5.1.41-3ubuntu12

The following error is thrown each run of automysqlbackup script:

mysqldump: Got error: 1044: Access denied for user 'debian-sys-maint'@'localhost' to database 'information_schema' when using LOCK TABLES

run-parts: /etc/cron.daily/automysqlbackup exited with return code 1

Fix in maverick by merging the package from debian.

TEST CASE:
1) install automysqlbackup
2) try to run it and verify that it errors out with exit status 1
3) install automysqlbackup from lucid-proposed
4) verify that it now backups the database fine and exits with exit status 0

See original description

Related branches

lp:~yofel/ubuntu/lucid/automysqlbackup/lp-574202
Ubuntu Sponsors: Pending requested
Diff: 46 lines (+16/-3)
2 files modified
automysqlbackup (+9/-3)
debian/changelog (+7/-0)
lp:ubuntu/lucid-proposed/automysqlbackup
Revision history for this message
Brian Mercer (brianmercer) wrote :

I'm receiving this error message also since the upgrade from karmic to lucid.

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=550037

Revision history for this message
Anil Somayaji (asomayaji) wrote :

The Debian bug report also reports that 2.5-6 fixes this issue; it seems that lucid's version is 2.5-5ubuntu1, so the bug hasn't been fixed. I installed Debian's 2.5-6 on my system with no problems and it seems to work fine - I now have a proper backup of the information_schema table.

Note that debian-sys-maint has all the privileges it needs for this option; however, in this case it is trying to lock a table that can't be locked. Replacing --opt with --skip-opt as an argument to mysqlbackup (for this table only) fixes the problem.

Revision history for this message
Philip Muškovac (yofel) wrote :

This should be fixed in debian soon as the patch was confirmed to work.

Changed in automysqlbackup (Ubuntu):
importance: Undecided → Medium
status: New → Triaged
Revision history for this message
Thomas Goirand (thomas-goirand) wrote :

Hi,

Fixed in version 2.5-6 that I just uploaded, please sync from Debian SID.

The maintainer,

Thomas Goirand

Revision history for this message
Stefan Lasiewski (stefanlasiewski) wrote :

This problem still happens in Ubuntu 10.04/Lucid as of June 21, 2010. Thomas Goirand (The maintainer of automysqlbackup) says this is fixed. Can this fix please be ported to 10.04?

Revision history for this message
Laurent Dinclaux (dreadlox) wrote :

When will it be solve please?

 July 27th and the bug is still there whereas the author fixed it.

Changed in automysqlbackup (Ubuntu):
status: Triaged → Confirmed
Revision history for this message
Philip Muškovac (yofel) wrote :

Fixed in maverick.

automysqlbackup (2.5-6ubuntu1) maverick; urgency=low

  * Merge from debian unstable. (LP: #593106) Remaining changes:
    - debian/control: Dont depend on mysql-client-5.0.

 -- Jean-Louis Dupond <email address hidden> Mon, 17 May 2010 15:50:29 +0100

automysqlbackup (2.5-6) unstable; urgency=low

  * Fixes the --opt issue with the information_schema that needs --skip-opt
    instead of --opt (Closes: #550037).
  * Added ${misc:Depends}.
  * Added patch to purge the rotated weekly backups that are older than 5
    weeks, if you selected SEPDIR (Separate backup for each DB), thanks to
    Gregor Hoffleit <email address hidden> (Closes: #572642).
  * Removes verbosivity when doing rm when LATEST is in use, as suggested
    by Frédéric Brière <email address hidden> (Closes: #574479).

 -- Thomas Goirand <email address hidden> Tue, 23 Mar 2010 20:54:27 +0800

Changed in automysqlbackup (Ubuntu):
status: Confirmed → Fix Released
Revision history for this message
Philip Muškovac (yofel) wrote :

Filed a merge request for lucid and package can be tested once that's uploaded and accepted.

description: updated
tags: added: lucid
Revision history for this message
Stefano Rivera (stefanor) wrote :

Uploaded and pending ubuntu-sru approval.

Changed in automysqlbackup (Ubuntu Lucid):
importance: Undecided → Medium
status: New → Fix Committed
Revision history for this message
Martin Pitt (pitti) wrote : Please test proposed package

Accepted automysqlbackup into lucid-proposed, the package will build now and be available in a few hours. Please test and give feedback here. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Thank you in advance!

tags: added: verification-needed
Revision history for this message
Stefan Lasiewski (stefanlasiewski) wrote :

Looks like it's working so far.

    stefanl@host:~ $ sudo /etc/cron.daily/automysqlbackup ; echo $?
    0

I'll let this run from cron.daily for a few more days and see how it looks.

Thanks for the fix!

Revision history for this message
Jean-Baptiste Lallement (jibel) wrote :

Thank you for testing, that's much appreciated. Marking as 'verification-done'

tags: added: verification-done
removed: verification-needed
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package automysqlbackup - 2.5-5ubuntu1.1

---------------
automysqlbackup (2.5-5ubuntu1.1) lucid-proposed; urgency=low

  * Fixes the --opt issue with the information_schema that needs --skip-opt
    instead of --opt (LP: #574202).
 -- Philip Muskovac <email address hidden> Sun, 05 Sep 2010 22:58:29 +0200

Changed in automysqlbackup (Ubuntu Lucid):
status: Fix Committed → Fix Released
Bug Watch Updater (bug-watch-updater)
Changed in automysqlbackup (Debian):
status: Unknown → Fix Released
Ubuntu Foundations Team Bug Bot (crichton)
tags: added: testcase
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.