XtraBackup 2.4 manual missed PROCESS among minimal privileges required for full backups

Bug #1594990 reported by vaniachine@gmail.com
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Status tracked in 2.4
2.3
Fix Released
Medium
Hrvoje Matijakovic
2.4
Fix Released
Medium
Hrvoje Matijakovic

Bug Description

The manual section at
https://www.percona.com/doc/percona-xtrabackup/2.4/using_xtrabackup/privileges.html

says

An SQL example of creating a database user with the minimum privileges required to full backups would be:
...
mysql> GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'bkpuser'@'localhost';
...

With these minimum privileges the xtrabackup --prepare command works for version 2.3.4 but fails for version 2.4.3 with
Error: failed to execute query SHOW ENGINE INNODB STATUS: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

Tags: doc
Revision history for this message
Sergei Glushchenko (sergei.glushchenko) wrote :
tags: added: doc
Changed in percona-xtrabackup:
assignee: nobody → Hrvoje Matijakovic (hrvojem)
status: New → Triaged
importance: Undecided → Medium
Revision history for this message
vaniachine@gmail.com (vaniachine) wrote :

Other minor improvements for the manual:

1) The end of the Section
https://www.percona.com/doc/percona-xtrabackup/2.4/manual.html

has

After Percona XtraBackup 2.3 release the recommend way to take the backup is using the xtrabackup script. More information on script options can be found in...

The word "script" above could be replaced with "binary" to reduce potential confusion.

2) The Section

https://www.percona.com/doc/percona-xtrabackup/2.4/xtrabackup_bin/creating_a_backup.html

starts with

To create a backup, run xtrabackup with the –backup option.

It should be: --backup (somehow the -- was converted to long dash).

Revision history for this message
vaniachine@gmail.com (vaniachine) wrote :

The start of Section 3.1 The innobackupex Script in the manual is now obsolete:
The innobackupex tool is a Perl script that acts as a wrapper for the xtrabackup C program. It is a patched version of the innobackup Perl script that Oracle distributes with the InnoDB Hot Backup tool. It enables more functionality by integrating xtrabackup and other functions such as file copying and streaming, and adds some convenience.

Revision history for this message
Hrvoje Matijakovic (hrvojem) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-758

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.