Article ID: 121459, created on May 5, 2014, last review on Sep 30, 2014

  • Applies to:
  • H-Sphere

Symptoms

Client's account has been charged with Millions of dollars.

Cause

Statistics logs has been corrupted. H-sphere read corrupted value which is about 10e+15.

Resolution

1) Check H-sphere database if such huge values are present there.

hsphere=> select * from trans_log where xfer > 9.0072e+13;
 p_server_id | account_id | resource_id | tt_type |   cdate    |           name           |    xfer    | flag | in_traffic | out_traffic
-------------+------------+-------------+---------+------------+--------------------------+------------+------+------------+-------------
         141 |   10373049 |    10373056 |       1 | 2014-03-21 | domain.tld       | 9.0072e+15 |      |         53 |  9.0072e+15
(1 row)

2) Delete these record from Database.

hsphere=> delete from trans_log where xfer > 9.0072e+13;

3) Check that the file C:\Program Files\HSphere\data\HsWeb\Stats\stats.zip is up to date, if no, replace it to another location and restart hsphere service.

    >net stop hsphere
    >net start hsphere

Search Words

Statistics

few user have complain they have charge for high traffic

found transfer traffic is not calculated correctly one off windows server

Wrong transfer traffic

Millions of dollars

Millions

f213b9fa8759d57bee5d547445806fe7 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF