• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Dash in DB name causes plesk exception when viewing full resource statistics

Mshaker

Basic Pleskian
OS: centos 5 x64
Plesk version: 9.5.2 CentOS 5 95100504.10

When you create a database containing the '-' character it creates the database as expected however on disk the database directory path '-' gets created as '@002d'.

Eg. create database name called example-database
Database name: example-database
On disk: /var/lib/mysql/example@002ddatabase/

After the database is created you can no longer view the domains "Full Summary" report as it now throws a "PleskUtilException"

get_dir_size: Error: unable to get dir size for /var/lib/mysql/example-database

System error 2: No such file or directory

0: DatabaseManagerMySQL.php:284
DatabaseManagerMySQL->getDatabaseSizeImpl(string 'example-database', resource)
1: DatabaseManager.php:323
DatabaseManager->getDatabaseSize(object of type Database)
2: class.DomainReport.php:673
DomainReport->make_report_full_databases_()
3: class.Report.php:277
Report->make_report(integer '61')
4: ReportUIPointer.php:40
ReportUIPointer->accessItem(string 'POST', NULL null)
5: UIPointer.php:596
UIPointer->access(string 'POST')
6: plesk.php:38

Just a note that dumping the database and recreating it without the '-' will fix the exception.
 
Right, it is known issue. I hope it will be fixed soon. Now we can recommend you do not use any special symbols for database names.
 
Hi,

We have experienced this problem in version 9.5.3 CentOS 5 95101022.06 - do you know when this will finally be resolved?

Thanks
 
Back
Top