Issue plesk sbin statistics fails for database on a non-standard database server

[JoeShmoe]

Server operating system version

CentOS 7.9.2009

Plesk version and microupdate number

Obsidian v18.0.51

After running

plesk sbin statistics --calculate-one --domain-name=example.com

I get

WARN: WARNING during statistics_collector execution: statistics_collector[17429]: Failed to process database 'example' from domain 'example.com': MySQL error 1049: Unknown database 'example' executing query: SHOW TABLE STATUS FROM `example`
statistics_collector[17429]: Unable to get dir size of /var/lib/mysql/example

I assume it's because the website is using secondary MySQL server, running on a different port and with databases stored in /var/lib/mysql2
However is it correctly added to Plesk and even set as the default Database server.
The website's database is correctly assigned to the secondary Database server, as shown in Plesk in /smb/database/list/domainId/10

Is the statistics program able to use non-standard database server?

 

[Peter Debik]

It could be a product issue. Such configuration may not be popular among users so it is possible that the scenario has not been tested. Please file a report here if you like: Reports