Hi Thanks for the reply,
Some record is well calculated, but many of them is not. I try to compare records for those populated vs non populated, but some not much significant difference . I not sure what suppose to be a healthy even vs non-heathy event. The always issue happen is Network Usage, other of usage record no issue, likeVm power on time etc. is well populated.ontime. On Tue, Apr 13, 2021 at 6:57 PM Daan Hoogland <[email protected]> wrote: > Hean, > > if you purge usage_job you'll need to stop/start the usage server. > usage_event are repopulated from the cloud-database, don't purger them > there and the cloud_usage.cloud_event table will get repopulated. > usage_network is an intermediary table, you can truncate it and it will be > filled again. It does not contain a final result however. > > On Thu, Mar 18, 2021 at 11:31 AM Hean Seng <[email protected]> wrote: > > > Hi Abhishek, > > > > The timezone is correct , now is on GMT . > > > > Can I know if this table, usage_job, usage_events , and usage_network > > table are able to manual purge it ? > > > > I am thinking to puge it and let he repopulate again see > > > > > > > > > > > > > > On Thu, Mar 18, 2021 at 6:24 PM Abhishek Kumar < > > [email protected]> > > wrote: > > > > > Hi, > > > > > > You may check usage aggregation and execution timezone values (global > > > configs - usage.aggregation.timezone, usage.execution.timezone). > > > Go through this blog if it helps > > > https://www.shapeblue.com/cloudstack-usage-service-deep-dive/ > > > [https://www.shapeblue.com/wp-content/uploads/2013/05/blog1.png]< > > > https://www.shapeblue.com/cloudstack-usage-service-deep-dive/> > > > CloudStack Usage Service | CloudStack Feature Deep Dive - The > CloudStack > > > Company<https://www.shapeblue.com/cloudstack-usage-service-deep-dive/> > > > Introduction CloudStack usage is a complimentary service which tracks > end > > > user consumption of CloudStack resources and summarises this in a > > separate > > > database for reporting or billing. The usage database can be queried > > > directly, through the CloudStack API, or it can be integrated into > > external > > > billing or reporting systems. For background information on the usage > > > service […] > > > www.shapeblue.com > > > Regards, > > > Abhishek > > > ________________________________ > > > From: Hean Seng <[email protected]> > > > Sent: 16 March 2021 12:38 > > > To: [email protected] <[email protected]> > > > Subject: Strange Behaviour of Usage Job > > > > > > Hi > > > > > > I am facing strange behaviour of Usage Job , > > > > > > table usage_job > > > > > > id : 8998 > > > > > > Host: xxxx > > > > > > pid : 964941 > > > > > > job_type : 1 > > > > > > scheduled: 0 > > > > > > start_millis : 1615870800000 > > > > > > end_millis: 1615870799999 > > > > > > exec_time 2 > > > > > > start_date 2021-03-16 05:00:00 > > > > > > end_date: 2021-03-16 04:59:59 > > > > > > success: 0 > > > > > > heartbeat: 2021-03-16 05:02:57 > > > > > > And this job record fail due to end_date before start date . > > > > > > Anybody caa help me on what issue, there is many of this fail job > over > > > the db record of usage_job table . > > > > > > -- > > > Regards, > > > Hean Seng > > > > > > [email protected] > > > www.shapeblue.com > > > 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK > > > @shapeblue > > > > > > > > > > > > > > > > -- > > Regards, > > Hean Seng > > > > > -- > Daan > -- Regards, Hean Seng
