Re: Help! Jobs stuck in pending state

2019-01-24 Thread Suresh Kumar Anaparti
related jobs on a > > host > > > server which is currently running a snapshot process, that job will not > > be > > > executed until the snapshot process is done. I've tested this countless > > > number of times and it's still the case. Again, this issu

Re: Help! Jobs stuck in pending state

2019-01-23 Thread Alireza Eskandari
t; be > > executed until the snapshot process is done. I've tested this countless > > number of times and it's still the case. Again, this issued appeared in > one > > of the 2018 releases as I've never seen between 2012 - 2017. > > > > Both issues are annoying as hell! >

Re: Help! Jobs stuck in pending state

2019-01-23 Thread Suresh Kumar Anaparti
l the case. Again, this issued appeared in one > of the 2018 releases as I've never seen between 2012 - 2017. > > Both issues are annoying as hell! > > Cheers > > - Original Message ----- > > From: "Alireza Eskandari" > > To: "dev" > >

Re: Help! Jobs stuck in pending state

2019-01-23 Thread Andrei Mikhailovsky
appeared in one of the 2018 releases as I've never seen between 2012 - 2017. Both issues are annoying as hell! Cheers - Original Message - > From: "Alireza Eskandari" > To: "dev" > Sent: Wednesday, 23 January, 2019 12:40:48 > Subject: Re: Help! Jo

Re: Help! Jobs stuck in pending state

2019-01-23 Thread Alireza Eskandari
I'm following this issue in github: https://github.com/apache/cloudstack/issues/3104 Please leave your comments Thanks On Wed, Jan 23, 2019 at 12:39 PM Wei ZHOU wrote: > Hi Alireza, > > could you try again after restarting mgt server ? > > -Wei > > Alireza Eskandari 于2019年1月23日周三 上午6:22写道: > >

Re: Help! Jobs stuck in pending state

2019-01-23 Thread Wei ZHOU
Hi Alireza, could you try again after restarting mgt server ? -Wei Alireza Eskandari 于2019年1月23日周三 上午6:22写道: > First I deleted two jobs which was existed in vm_work_job table and its > related entry in sync_queue table but it doesn't help. > Then I delete all the entries in sync_queue

Re: Help! Jobs stuck in pending state

2019-01-22 Thread Anurag Awasthi
Hi Alireza, Could you elaborate on how you instantiated the jobs and any thing specific that went wrong in between? Usually deleting directly through SQL statements is very risky and first try should be through any API support. Also, you might want to use github page

Re: Help! Jobs stuck in pending state

2019-01-22 Thread Alireza Eskandari
First I deleted two jobs which was existed in vm_work_job table and its related entry in sync_queue table but it doesn't help. Then I delete all the entries in sync_queue tables and again no success. Any idea? On Wed, Jan 23, 2019 at 1:50 AM Wei ZHOU wrote: > If you know the instance id and

Re: Help! Jobs stuck in pending state

2019-01-22 Thread Alireza Eskandari
Here is my query on those tables: MySQL [cloud]> select * from vm_work_job; +---+--+--++ | id| step | vm_type | vm_instance_id | +---+--+--++ | 57262 | Prepare | Instance |691 | | 57268 | Starting |

Re: Help! Jobs stuck in pending state

2019-01-22 Thread Wei ZHOU
If you know the instance id and mysql password, it should work after removing some records in mysql. ``` set @id=X; delete from vm_work_job where vm_instance_id=@id; delete from sync_queue where sync_objid=@id; ``` Alireza Eskandari 于2019年1月22日周二 下午10:59写道: > Hi guys > I have opened a bug

Help! Jobs stuck in pending state

2019-01-22 Thread Alireza Eskandari
Hi guys I have opened a bug in jira about my problem in CS: https://issues.apache.org/jira/browse/CLOUDSTACK-10401 CloudStack doesn't process jobs! My cloud in totally unusable. Thanks in advance for you help.