[report] Plesk 10.4.4 statistics are never updated

[Ihno1]

After 10 Minutes : --calculate-all

MySQL query failed: Unknown column '2228type' in 'field list'

/usr/local/psa/admin/sbin/statistics --calculate-one --domain-name=<DOMAIN.TLD>

WARNING during statistics_collector execution: : error: error accessing /usr/share/tomcat5.5/logs: No such file or directory
error: tomcat:2 glob failed for /usr/share/tomcat5.5/logs/*.log


Plesk 10.4.4 on Debian 5 x64

 

[Kelos]

You shouldn't run this patch directly! You should replace file /usr/local/psa/admin/sbin/statistics_collector and run /usr/local/psa/admin/sbin/statistics as previously or wait cron daily running.

I did replace the file. Sorry for calling it "running the patch". The main problem on my server was, that there where a lot of processes with statistics_collector still running. After a reboot (or killing that processes), the daily cronjob worked fine and created the statistics. The patch worked for me.

Is the problem with the backup also fixed with that patch?

 

[H.W.B]

I have replaced the file and excecuted the calculate one command.

After 30 minutes no visual result.
After 60 minutes i canceled the command. Nothing happend.

I used a domain with almost no action so this should not taken so long.

This is not working

Parallels Plesk Panel v10.4.4_build1013111102.18 os_CentOS 5

 

[IgorG]

Ok. Thank you for reporting. Developers will check it and provide solution soon.

 

[LoïcA]

Works like a charm (dist-deb-Debian-5.0-x86_64).
Thanks : my webstats are now up to date (and I no longer have tons of stats processes "running")

Nevertheless:
- my PLESK admin panel won't update domain statistics (URL/admin/domain/list?context=domains). For example, newly-created domains (2 days ago) are still displaying 0 for traffic and space disk usage.
- healthmonitor still displays 0 values for everything.

Is this linked to this issue ?
Do you also have these problems ?

 

[Shoto11]

You should replace file /usr/local/psa/admin/sbin/statistics_collector and run /usr/local/psa/admin/sbin/statistics as previously or wait cron daily running.

Don't work. Same as before on Debian 6.

 

[Mickael Salfati]

Custom fix is here for 10.4 and all OSes - http://download1.sw-soft.com/Plesk/Autoupdate/statistics_collector.tar.bz2

Thank you very much IgorG. I confirm that issue is fixed for debian 5.0/6.0 x64

Edit: Issue is not fixed at all !
http://forum.parallels.com/showpost.php?p=561541&postcount=31

 

[Mickael Salfati]

Just one note. Once the file is replaced, I advice everyone to restart the server to cut off (completely) statistics_collector. Then you can run statistics binary to update manually your stats.
Patch applied on 8 Plesk Panel servers (debian 5/6 x64) and statistics updated as already said

Edit: Issue is not fixed at all !
http://forum.parallels.com/showpost.php?p=561541&postcount=31

 

[Shoto11]

After replace I restarted sw-collectd of course - I must restart the hole server?

 

[Mickael Salfati]

After replace I restarted sw-collectd of course - I must restart the hole server?

As already said:

Once the file is replaced, I advice everyone to restart the server to cut off (completely) statistics_collector

 

[Mickael Salfati]

I confirm also these affirmations:

Nevertheless:
- my PLESK admin panel won't update domain statistics (URL/admin/domain/list?context=domains). For example, newly-created domains (2 days ago) are still displaying 0 for traffic and space disk usage.
- healthmonitor still displays 0 values for everything.

Is this linked to this issue ?
Do you also have these problems ?

patch only fix webstat/awstat statistics but quota information (disk space, traffic, etc.) aren't updated !

After 10 Minutes : --calculate-all

MySQL query failed: Unknown column '2228type' in 'field list'

Finally, i have also this output on 3 servers:

MySQL query failed: Unknown column '2260type' in 'field list'

MySQL query failed: Unknown column '46051type' in 'field list'

MySQL query failed: Unknown column '2260type' in 'field list'

 

[EderWagner]

I applied the patch ..
I rebooted the server and went to work ...

Only worked after restarting the server ...

 

[IgorG]

I applied the patch ..
I rebooted the server and went to work ...

Only worked after restarting the server ...

Yes, it may be related to killing duplicated and hanged statistics processes after server reboot...

 

[NicolaA]

Patch applied on Plesk 10.4.4 CentOS 6 x64, server rebooted but usage statistics not working.
Please help!

 

[Shoto11]

Confirm - stats are running after complete reboot.

 

[Mickael Salfati]

Confirm - stats are running after complete reboot.

It's only awstats/webstat that are updated, all quota informations (disk space, traffic, etc.) are never updated !!!
This issue is urgent as I already said because I can't re-enable domains previsouly disabled for quota exceedance ...

 

[Shoto11]

all quota informations (disk space, traffic, etc.) are never updated

you are right... *sigh*

 

[Mickael Salfati]

It's really a headache and I think that module statistics is completely lost.
Let's imagine a domain called "domain.com" for "dupont" user.

/opt/psa/admin/sbin/statistics --calculate-all
Result: No update and I have sometimes this output

MySQL query failed: Unknown column '2260type' in 'field list'

/opt/psa/admin/sbin/statistics --calculate-one --domain-name=domain.com
Result: Quota are updated and I have this output:

statistics_collector: other-user: cannot find domain for user

You can remark that "other-user" has no connection with the domain calculated of this user "dupont".

Then i update a big file on domain.com FTP (15 MB) and I launch again:
/opt/psa/admin/sbin/statistics --calculate-one --domain-name=domain.com
Result: No update.

 

[H.W.B]

Hello IgorG,

Yesterday i told you that the fix didn't work.
I figured out why.
I extracted the wrong version. I replaced it with the correct version and now the stats are working!!!

Only the Log rotation is stil not working but i will enter that in the appropriate discussion.

 

[Mickael Salfati]

I extracted the wrong version. I replaced it with the correct version and now the stats are working!!!

Are you sure that your quota information are well updated (disk space, traffic, etc.) ?
It's not the case for me. Otherwise, Awstats/Webstats are well updated.