Search Engine: Elastic

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

f213b9fa8759d57bee5d547445806fe7 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF