So, I shall stop the Cloudstack-Usage services and delete all record where success is NULL , and start back the usage service ?
On Sat, Jun 19, 2021 at 11:00 PM Daan Hoogland <daan.hoogl...@gmail.com> wrote: > Heanm, > > On Sat, Jun 19, 2021 at 5:27 AM Hean Seng <heans...@gmail.com> wrote: > > > i have no unprocess job , but still have this issue: > > > > 2021-06-19 10:09:57,657 DEBUG [cloud.usage.UsageManagerImpl] > > (Usage-HB-1:null) (logid:) Scheduling Usage job... > > > > 2021-06-19 10:09:57,657 INFO [cloud.usage.UsageManagerImpl] > > (Usage-Job-1:null) (logid:) starting usage job... > > > > 2021-06-19 10:09:57,661 DEBUG [cloud.usage.UsageManagerImpl] > > (Usage-Job-1:null) (logid:) Not owner of usage job, skipping... > > > this line ^^ means there is a unprocessed job owned by another proccess > ... > > > > 2021-06-19 10:09:57,661 INFO [cloud.usage.UsageManagerImpl] > > (Usage-Job-1:null) (logid:) usage job complete > > > > > > mysql> select id, pid, start_date ,end_date , success, heartbeat from > > usage_job where success=0 order by start_date desc limit 100; > > > you should search for `where success is null` > > > > Empty set (0.00 sec) > > > > > > > > > > On Fri, Jun 18, 2021 at 11:01 PM Hean Seng <heans...@gmail.com> wrote: > > > > > yes, I restarted the mgmt server, wait till can login web interface . > > > then only restart usage . > > > > > > I did follwoig also : > > > > > > * stop usage server > > > > > > * remove the record from usage_job for the unprocessed job > > > > > > * start usage server again > > > > > > > > > > > > Still same thing. Not sure where the Cloudstack keep the Usage server > > PID > > > id , and keep getting wrong id. > > > > > > > > > > > > > > > > > > > > > On Fri, Jun 18, 2021 at 4:31 PM Boris Stoyanov < > > > boris.stoya...@shapeblue.com> wrote: > > > > > >> Hi Hean Seng, > > >> > > >> Have you waited the management service to come up and then restarted > > >> usage service? It might be some race condition? > > >> > > >> Bobby. > > >> > > >> From: Hean Seng <heans...@gmail.com> > > >> Date: Friday, 18 June 2021, 7:31 > > >> To: users@cloudstack.apache.org <users@cloudstack.apache.org> > > >> Subject: Cloudstack Usage --- not owner > > >> Hi > > >> > > >> I have mysql hang, and restarted mysql, restarted cloudstack mgmt, and > > >> usage. > > >> > > >> After that facing issue of following: > > >> > > >> duration is 120 minutes) > > >> > > >> 2021-06-18 04:25:49,656 DEBUG [cloud.usage.UsageManagerImpl] > > >> (Usage-HB-1:null) (logid:) Scheduling Usage job... > > >> > > >> 2021-06-18 04:25:49,657 INFO [cloud.usage.UsageManagerImpl] > > >> (Usage-Job-1:null) (logid:) starting usage job... > > >> > > >> 2021-06-18 04:25:49,669 DEBUG [cloud.usage.UsageManagerImpl] > > >> (Usage-Job-1:null) (logid:) Not owner of usage job, skipping... > > >> > > >> 2021-06-18 04:25:49,669 INFO [cloud.usage.UsageManagerImpl] > > >> (Usage-Job-1:null) (logid:) usage job complete > > >> > > >> > > >> > > >> Seems usage pid is not updated to db . > > >> > > >> Andybody know how to fix this ? > > >> > > >> -- > > >> Regards, > > >> Hean Seng > > >> > > >> > > >> > > >> > > > > > > -- > > > Regards, > > > Hean Seng > > > > > > > > > -- > > Regards, > > Hean Seng > > > > > -- > Daan > -- Regards, Hean Seng