Disk usage incorrect

[JacksonY]

I find it surprising that disk usage in Plesk 10 for accounts is actually hugely incorrect. It is only showing 3mb+ when my client has uploaded more than 200mb onto the account.

Can someone advise?

 

[IgorG]

Try to recalculate statistics for this domain with

# /usr/local/psa/admin/sbin/statistics --calculate-one --domain-name=<domain_name>

Or recalculate all statistics with

# /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/DailyMaintainance/script.php >/dev/null 2>&1

 

[JacksonY]

I tried running both, but it just got stuck, I have to cancel the process.

 

[IgorG]

Note that statistics recalculation can take a lot of time.

 

[JacksonY]

Thanks.

How can I ensure it is running but not stuck?

 

[IgorG]

You can check statistics proccess, for example:

# ps ax | grep statistics

 

[JacksonY]

Thanks. It's running:

14195 pts/0 S+ 0:00 grep statistics
21913 ? S 0:00 /usr/local/psa/admin/sbin/statistics
23951 pts/0 T 0:00 /usr/local/psa/admin/sbin/statistics
24147 pts/0 T 0:00 /usr/bin/perl /usr/share/awstats/awstats_buildstaticpages.pl -awstatsprog=/var/www/cgi-bin/awstats/awstats.pl -configdir=/usr/local/psa/etc/awstats -config=xxx.com-ftp -dir=/var/www/vhosts/xxx.com/statistics/ftpstat/2011-05 -month=5 -year=2011
24211 pts/0 T 0:00 /usr/local/psa/admin/sbin/statistics
24240 pts/0 T 0:00 /usr/local/psa/admin/sbin/statistics --calculate-one --domain-name=xxx.com

but still showing no usage in disk space. What could be wrong?

 

[IgorG]

Wait when


# /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/DailyMaintainance/script.php >/dev/null 2>&1

will be completed and check results after that.

 

[JacksonY]

It's still showing 0 usage after the command is run. It is on Linux Virtuozzo. Any issue with that?

 

[IgorG]

Look at following KB articles:

http://kb.odin.com/en/752
http://kb.odin.com/en/9443

Contact Parallels Support Team if it not help.

 

[egmco]

Disk usage is not calculated for some domains

---------------------------------------------------------------
PRODUCT, VERSION, OPERATING SYSTEM
Parallels Plesk Panel psa v10.2.0_build1011110331.11 os_CentOS 5

ARCHITECTURE
Linux 2.6.18-194.26.1.el5xen

PROBLEM DESCRIPTION AND STEPS TO REPRODUCE
The statistics are now display for some domains after server migration.
The statistics for all domains are inacurated.

I try to update manually the statics by domain using:
/usr/local/psa/admin/sbin/statistics --calculate-one --domain-name=DOMAINNAME.com

I get the following result
statistics: MySQL error 1049: Unknown database 'mysql754aefbcdb1f4c04b6758b5066644914' executing query: SHOW TABLE STATUS FROM `mysql754aefbcdb1f4c04b6758b5066644914`
statistics: MySQL error 1049: Unknown database 'mysql754aefbcdb1f4c04b6758b5066644914' executing query: SHOW TABLE STATUS FROM `mysql754aefbcdb1f4c04b6758b5066644914`

Also if I try to update all statistics:
/usr/local/psa/admin/sbin/statistics --calculate-all

I get the same result:
statistics: MySQL error 1049: Unknown database 'mysql754aefbcdb1f4c04b6758b5066644914' executing query: SHOW TABLE STATUS FROM `mysql754aefbcdb1f4c04b6758b5066644914`
statistics: MySQL error 1049: Unknown database 'mysql754aefbcdb1f4c04b6758b5066644914' executing query: SHOW TABLE STATUS FROM `mysql754aefbcdb1f4c04b6758b5066644914`


ACTUAL RESULT
No statistics are calculated for all domains.
The command line statistics fail.

EXPECTED RESULT
To calculate the space used and all the statistics for domains

ANY ADDITIONAL INFORMATION
I do a mysql check no errors in databases.
I need information to solve it.
--------------------------------------------------------------

 

[egmco]

---------------------------------------------------------------
PRODUCT, VERSION, OPERATING SYSTEM
Parallels Plesk Panel psa v10.2.0_build1011110331.11 os_CentOS 5

ARCHITECTURE
Linux 2.6.18-194.26.1.el5xen

PROBLEM DESCRIPTION AND STEPS TO REPRODUCE
The statistics are now display for some domains after server migration.
The statistics for all domains are inacurated.

I try to update manually the statics by domain using:
/usr/local/psa/admin/sbin/statistics --calculate-one --domain-name=DOMAINNAME.com

I get the following result
statistics: MySQL error 1049: Unknown database 'mysql754aefbcdb1f4c04b6758b5066644914' executing query: SHOW TABLE STATUS FROM `mysql754aefbcdb1f4c04b6758b5066644914`
statistics: MySQL error 1049: Unknown database 'mysql754aefbcdb1f4c04b6758b5066644914' executing query: SHOW TABLE STATUS FROM `mysql754aefbcdb1f4c04b6758b5066644914`

Also if I try to update all statistics:
/usr/local/psa/admin/sbin/statistics --calculate-all

I get the same result:
statistics: MySQL error 1049: Unknown database 'mysql754aefbcdb1f4c04b6758b5066644914' executing query: SHOW TABLE STATUS FROM `mysql754aefbcdb1f4c04b6758b5066644914`
statistics: MySQL error 1049: Unknown database 'mysql754aefbcdb1f4c04b6758b5066644914' executing query: SHOW TABLE STATUS FROM `mysql754aefbcdb1f4c04b6758b5066644914`


ACTUAL RESULT
No statistics are calculated for all domains.
The command line statistics fail.

EXPECTED RESULT
To calculate the space used and all the statistics for domains

ANY ADDITIONAL INFORMATION
I do a mysql check no errors in databases.
I need information to solve it.
--------------------------------------------------------------

After search for a while, I found the problem and how to solve.

Problem:
Some database related in the psa.data_bases with users in psa.db_users and passwords in psa.accounts doesn't exists in mysql database catalog.

So I get the info to recreate the database:
select db.name, login, password from data_bases db inner join db_users u on db.id = u.db_id inner join accounts a on a.id = u.account_id where name = 'mysql754aefbcdb1f4c04b6758b5066644914'

Go to the plesk panel, remove the db users, remove the db. Then recreate the db and users.

After that run the command to recreate statistics, and all works.