Unbelievably huge overnight traffic for a domain

[rihad]

We received this email today:

Subject: <our.domain.com> Notification: Domain has exceeded its limits and was suspended.

The following resource limits were exceeded on domain 'some.domain.com', owned by user account 'Main':

Traffic: 5 936 572.79 MB/month used / 20 000.00 MB/month limit

The domain was suspended.

That's almost 6 TB! It's totally wrong because for one thing it doesn't correspond to the SNMP data for that Plesk box, which is 1000+ times less.

Any suggestions?
Plesk .9.2.3 on Debian GNU/Linux 3.1

 

[rihad]

How can I clear this traffic usage? Which database column is it?

 

[rihad]

OK, I got it. This MySQL query cleared the ~6TB of traffic and did the trick:

update DomainsTraffic set http_out=0 where dom_id=142 and date='2010-09-20';

p.s.: please fix this bug

 

[IgorG]

http://kb.odin.com/8642

 

[rihad]

Thank you, IgorG! I downloaded update.tar.gz, but we're still running Debian 3.1. Don't you support it any more?

# tar -tvzf update.tar.gz |fgrep -i debian
drwxr-xr-x skylex/wheel 0 2010-06-21 09:21:50 update/dist-deb-Debian-4.0-i386/
drwxr-xr-x skylex/wheel 0 2010-06-21 09:22:21 update/dist-deb-Debian-4.0-x86_64/
drwxr-xr-x skylex/wheel 0 2010-06-21 09:22:25 update/dist-deb-Debian-5.0-i386/
drwxr-xr-x skylex/wheel 0 2010-06-21 09:22:32 update/dist-deb-Debian-5.0-x86_64/
-rwxr-xr-x skylex/wheel 143247 2010-06-21 09:22:32 update/dist-deb-Debian-5.0-x86_64/statistics
-rwxr-xr-x skylex/wheel 132216 2010-06-21 09:22:25 update/dist-deb-Debian-5.0-i386/statistics
-rwxr-xr-x skylex/wheel 142982 2010-06-21 09:22:21 update/dist-deb-Debian-4.0-x86_64/statistics
-rwxr-xr-x skylex/wheel 130708 2010-06-21 09:22:19 update/dist-deb-Debian-4.0-i386/statistics

Maybe the Debian-4.0-i386 version would work fine?

 

[rihad]

Unforunately Debian-4.0-i386 uses new libs which Debian 3.1 doesn't have.

# ldd update/dist-deb-Debian-4.0-i386/statistics
libpq.so.4 => not found
libcrypt.so.1 => /lib/libcrypt.so.1 (0x4001d000)
libidn.so.11 => /usr/lib/libidn.so.11 (0x4004a000)
libssl.so.0.9.8 => not found
libcrypto.so.0.9.8 => not found
libmysqlclient.so.15 => not found
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x4007b000)
libm.so.6 => /lib/libm.so.6 (0x4014a000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x4016c000)
libc.so.6 => /lib/libc.so.6 (0x40175000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

What else can we do instead of upgrading everything? Maybe you have updates for the older Debian releases? Plesk 9.2.* supported it less than a year ago.

 

[rihad]

So?.. How can we overcome this problem on Debian Sarge (3.1)? The problem has occurred once again on a different domain

 

[IgorG]

So?.. How can we fix this bug on Debian Sarge (3.1)? The problem has occurred once again on a different domain

According to http://kb.odin.com/8642

The problem has been fixed in Parallels Plesk Panel since version 9.5.1.

What about upgrade to latest Plesk version?

 

[rihad]

Can't do that. Please see my post #5. Do you have updates for Debian 3.1 (Sarge)?

 

[IgorG]

You shouldn't install patch on your Debian 3.1 if you perform upgrade to 9.5.2 version because fix for this issue is already included to Plesk since 9.5.1 version.
According to Release Notes for 9.5.2 http://download1.parallels.com/Plesk/PPP9/rn/en-US/plesk-9.5.2-for-deb-based-os.html#3 Debian 3.1 is supported OS.

 

[rihad]

Thanks so much. I thought the update.tar.gz file mentioned in http://kb.odin.com/8642 was the only way

Right now I'm following the instructions at http://download1.parallels.com/Plesk/PPP9/rn/en-US/plesk-9.5.2-for-deb-based-os.html#7
for a command-line install.