backup/backup

Error dumping tablespaces

danielristic opened this issue · 4 comments

danielristic commented

Hello,

My backups seem to work but the log show the following error:

mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

I'm wondering it it actually impacts the dumps or it can be ignored? (I'm using the default config for myslq).

  • Operating system: Ubuntu Server 16.04.1
  • Ruby version: 2.7.3
  • Tools or services used by backup: MySQL 5.7.33
elthariel commented

I think it likely breaks the backup, according to a very quick google research. What's inside the resulting backup ? Does it seems to contain the right output ?

danielristic commented

As far as I can tell the dump contains the expected stuff and the file size looks about right. It even loads fine on a test database. If something's wrong with the dump as a result of this error, it's not obvious.

elthariel commented

I'm not entirely sure, but it seems in recent mysql versions, the general purpose tablespaces feature allow to configure how the data is stored in disk, i.e. not having all the innodb tables in the ibdata1 files like previously.
My current understanding of this is that you might not have the same layout on disk after re-importing the dump, since you didn't have the privilege to dump this tablespace configuration.

Anyway, this is not really a backup error, but more a mysql rights thing, in the sense that there's nothing to fix here.
I'll then close this issue :)

danielristic commented

Hello @elthariel, since it's an error that's thrown using the default configuration (when using mysql 5.7.31 or newer), it should at least be mentioned in the documentation or part of the example configuration to have db.additional_options = ["--no-tablespaces"] (or instruct to grant PROCESS privilege to the mysqldump user).