Forwarded to devs Statistics calculation error for mysql databases with dash in name

[ChristophRo]

TITLE:

Statistics calculation error for mysql databases with dash in name
​

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE:

17.8.11 Update #1, ‪Debian 9.4‬, x64
​

PROBLEM DESCRIPTION:

Plesk tries to calculate the size of mysql databases according to their names.
That does not work for database names with dashes, as mysql does replace the dash with "@002d" in the directory name under /var/lib/mysql
​

STEPS TO REPRODUCE:

• create database with a name that contains a dash, like "test-database"
• run command "/usr/local/psa/admin/sbin/statistics --calculate-all"

ACTUAL RESULT:

root@plesksrv:/# /usr/local/psa/admin/sbin/statistics --calculate-all

WARNING during statistics_collector execution: : statistics_collector[16898]: Unable to get dir size of /var/lib/mysql/test-database
statistics_collector[16898]: Unable to get dir size of /var/lib/mysql/test-database
​

EXPECTED RESULT:

no warning/error message, but correct calculation of the mysql database size
​

ANY ADDITIONAL INFORMATION:

​

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM:

Confirm bug​

 

[IgorG]

Thank you.
Bug was confirmed and submitted as PPPM-8134.