List:General Discussion« Previous MessageNext Message »
From:agd85 Date:June 5 2011 8:20pm
Subject:upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:
SELECT,LOCK TABL command denied to user 'root'@'localhost' for table
'cond_instances' ...
View as plain text  
i use ZRM to do backups of my databases.

with v5.1.x, this works fine,

  mysql-zrm-scheduler --now --backup-set manual --backup-level 0

to execute a manual backup.

i recently upgraded from v5.1.x -> v5.5.12,

 mysqladmin -V
  mysqladmin  Ver 8.42 Distrib 5.5.12, for Linux on i686

now, at exec of that backup cmd, i see an ERROR @ console,

	...
	manual:backup:INFO: PHASE START: Creating raw backup
	manual:backup:INFO: Command used for raw backup is
	/usr/share/mysql-zrm/plugins/socket-copy.pl
	--mysqlhotcopy=/usr/bin --host="localhost" --port="3306"
	--socket="/var/cache/mysql/mysql.sock" --quiet  mysql 
	"/var/mysql-bkup/manual/20110605131003" >
	/var/cache/tmp/bZvaQFwQY2 2>&1
	manual:backup:INFO: raw-databases=mysql
	manual:backup:INFO: PHASE END: Creating raw backup
	manual:backup:INFO: PHASE START: Creating logical backup
	manual:backup:WARNING: The database(s) drupal6
	performance_schema will be backed up in logical mode since they
	contain tables that use a transactional engine.
	manual:backup:INFO: Command used for logical backup is
	"/usr/bin"/mysqldump --opt --extended-insert --create-options
	--default-character-set=utf8 --routines --host="localhost"
	--port="3306" --socket="/var/cache/mysql/mysql.sock" --databases
	drupal6 performance_schema  >
	"/var/mysql-bkup/manual/20110605131003/backup.sql"
	mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to
	user 'root'@'localhost' for table 'cond_instances' when using
	LOCK TABLES
-->     manual:backup:ERROR: mysqldump did not succeed.
	 Command used is "/usr/bin"/mysqldump --opt --extended-insert
	 --create-options --default-character-set=utf8 --routines
	 --host="localhost" --port="3306"
	 --socket="/var/cache/mysql/mysql.sock" --databases drupal6
	 performance_schema  >
	 "/var/mysql-bkup/manual/20110605131003/backup.sql"manual:backup:INFO:
	 PHASE START: Cleanup
	manual:backup:INFO: backup-status=Backup failed
	...


reading up on the error at,

 http://bugs.mysql.com/bug.php?id=33762
 http://bugs.mysql.com/bug.php?id=49633

it looks to do with mysqldump itself.  i modified in /etc/my.cnf

	...
	[mysqldump]
	quick
	quote-names
	max_allowed_packet = 8M
+       skip-lock-tables
	...

but that doesn't seem to make any difference.

something's changed between 5.1.x & 5.5.x.

what do i need to modify to get past this error?
Thread
upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table'cond_instances' when...agd855 Jun
  • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances'...Reindl Harald5 Jun
    • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table'cond_instances' ...agd855 Jun
      • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances'...Reindl Harald5 Jun
        • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table'cond_instances' ...agd855 Jun
          • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances'...Reindl Harald5 Jun
            • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table'cond_instances' ...agd855 Jun
              • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances'...Reindl Harald5 Jun
                • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table'cond_instances' ...agd855 Jun
                  • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances'...Reindl Harald6 Jun
                  • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances...Johan De Meersman6 Jun
                    • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table'cond_instances' ...agd856 Jun
                      • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances...Johan De Meersman6 Jun
                        • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table'cond_instances' ...agd856 Jun
          • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances'...Reindl Harald5 Jun
            • Re: upgraded from 5.1->5.5. now getting a mysqldump ERROR "1142:SELECT,LOCK TABL command denied to user 'root'@'localhost' for table'cond_instances' ...agd855 Jun
              • HowTo using mailing-listsReindl Harald5 Jun
                • Re: HowTo using mailing-listsagd855 Jun
                  • Re: HowTo using mailing-listsReindl Harald5 Jun
            • Re: to the list AND the authorhsv6 Jun