Bug #115025 mysqldump: Error: 'Access denied; need PROCESS privileges for Tablespaces
Submitted: 16 May 2024 5:56 Modified: 16 May 2024 9:58
Reporter: Sagar Kandekar Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: mysqlpump Command-line Client Severity:S2 (Serious)
Version: OS:Linux (Rocky)
Assigned to: CPU Architecture:Any

[16 May 2024 5:56] Sagar Kandekar 
Description:
The mysqldump command-line aborting with following error:

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

mysqldump: Couldn't execute 'SHOW FIELDS FROM `CIRCUIT2UNIQOWNER`': View 'CramerData4SyncReports.CIRCUIT2UNIQOWNER' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)

How to repeat:
Our suspect is this issue is because  the temp tables or because of table spaces.
[16 May 2024 6:06] Sagar Kandekar 
MySQL data, binlog and table spaces are on different volumes
[16 May 2024 9:58] MySQL Verification Team 
HI Mr. Kandekar,

Thank you for your bug report.

Let us inform you that this is a forum for the reports with a fully repeatable test cases. A test case should consist of the set of SQL statements that always leads to the bug that you are reporting.

We can not repeat your problem without a described test case.

Can't repeat.