I wrote that article, it was for DB cleanup for 3.x version. I have updated it here for latest versions and added more tables - http://support.citrix.com/article/CTX200918.
I believe the error suggests that duplicate entries found when parsing records in table user_statistics for network usage. '2-1-228-1441177199999' - this translates to account_id 2, zone 1, network_id 228 and date Sep 03 2015 19:59:59 GMT-0400. Look at the usage logs for log messages "creating networkHelperEntry..." for account id 2 having multiple entries matching the above. Regards, Somesh -----Original Message----- From: mvs babu [mailto:mvsbabu0...@outlook.com] Sent: Friday, September 04, 2015 12:35 AM To: us...@cloudstack.apache.org Cc: dev@cloudstack.apache.org Subject: Re: Usage Job failed Thank you Abhinandan, I will try this. Thank you, Suneel Mallela From: Abhinandan Prateek Sent: Thursday, September 3, 2015 9:42 PM To: us...@cloudstack.apache.org Cc: dev@cloudstack.apache.org This support article may help: http://support.citrix.com/article/CTX139043 > On 03-Sep-2015, at 5:16 pm, mvs babu <mvsbabu0...@outlook.com> wrote: > > Hi All, > > > > > We are getting usage job failed alert in CloudStack UI and found below error > message in usage.log, > > > > > "ERROR [usage.dao.UsageVMInstanceDaoImpl] (Usage-Job-1:null) error saving > usage_network to cloud_usage db > java.sql.BatchUpdateException: Duplicate entry '2-1-228-1441177199999' for > key 'PRIMARY'" > > > > > > We are using ACS4.3.1. on top of CentOS6.2. > > > > > Please help to solve this issue. > > > > > Thank you, > Suneel Mallela Find out more about ShapeBlue and our range of CloudStack related services IaaS Cloud Design & Build<http://shapeblue.com/iaas-cloud-design-and-build//> CSForge – rapid IaaS deployment framework<http://shapeblue.com/csforge/> CloudStack Consulting<http://shapeblue.com/cloudstack-consultancy/> CloudStack Software Engineering<http://shapeblue.com/cloudstack-software-engineering/> CloudStack Infrastructure Support<http://shapeblue.com/cloudstack-infrastructure-support/> CloudStack Bootcamp Training Courses<http://shapeblue.com/cloudstack-training/> This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd or related companies. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales. ShapeBlue Services India LLP is a company incorporated in India and is operated under license from Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is operated under license from Shape Blue Ltd. ShapeBlue SA Pty Ltd is a company registered by The Republic of South Africa and is traded under license from Shape Blue Ltd. ShapeBlue is a registered trademark.
