innobackupex does not catch error correctly

Bug #1206874 reported by shinguz
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
New
Undecided
Unassigned

Bug Description

innobackupex does not catch error correctly when user is not specified or privileges are not correct and starts to hang in log scan loop forever.

IMHO we should do a proper exit there with a bit more verbose error message there: which user was tried where were we looking for:

xtrabackup v2.1.3

shell> innobackupex --defaults-file=/home/mysql/data/mysql-5.5.31/my.cnf /tmp
...
[01] Copying ./test/Test.ibd to /tmp/2013-07-30_20-01-31/test/Test.ibd
[01] ...done
>> log scanned up to (334321678)

130730 20:01:46 innobackupex: Continuing after ibbackup has suspended
130730 20:01:46 innobackupex: Starting to lock all tables...
DBD::mysql::db do failed: Access denied; you need (at least one of) the RELOAD privilege(s) for this operation at /home/mysql/product/xtrabackup/bin/innobackupex line 1443.
innobackupex: Error:
Error executing 'FLUSH TABLES WITH READ LOCK': DBD::mysql::db do failed: Access denied; you need (at least one of) the RELOAD privilege(s) for this operation at /home/mysql/product/xtrabackup/bin/innobackupex line 1443.
>> log scanned up to (334321678)
>> log scanned up to (334321678)
>> log scanned up to (334321678)
>> log scanned up to (334321678)
>> log scanned up to (334321678)
>> log scanned up to (334321678)
>> log scanned up to (334321678)
>> log scanned up to (334321678)
>> log scanned up to (334321678)
>> log scanned up to (334321678)
...
hangs in endless loop?

Revision history for this message
Alexey Kopytov (akopytov) wrote :

Oli,

Yes, that's a known problem also reported and discussed in bug #1135441. Closing this one as a duplicate.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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