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 | Instance | 748 | +-------+----------+----------+----------------+ 2 rows in set (0.00 sec)
MySQL [cloud]> SELECT * FROM cloud.sync_queue; +-------+----------------+------------+-------------------+---------------------+---------------------+------------+------------------+ | id | sync_objtype | sync_objid | queue_proc_number | created | last_updated | queue_size | queue_size_limit | +-------+----------------+------------+-------------------+---------------------+---------------------+------------+------------------+ | 4 | VmWorkJobQueue | 1 | 3 | 2017-08-28 12:24:09 | 2017-08-28 12:24:42 | 0 | 1 | | 7 | VmWorkJobQueue | 2 | 4 | 2017-08-28 12:24:10 | 2017-08-28 13:18:54 | 0 | 1 | | 19 | VmWorkJobQueue | 3 | 4 | 2017-08-28 12:44:09 | 2017-08-29 11:31:09 | 0 | 1 | | 34 | VmWorkJobQueue | 4 | 2 | 2017-08-29 11:03:28 | 2017-08-29 11:24:59 | 0 | 1 | . . . | 16360 | VmWorkJobQueue | 745 | 2 | 2019-01-22 07:06:48 | 2019-01-22 08:06:56 | 0 | 1 | | 16369 | VmWorkJobQueue | 746 | 2 | 2019-01-22 11:01:45 | 2019-01-22 12:03:54 | 0 | 1 | | 16378 | VmWorkJobQueue | 747 | 2 | 2019-01-22 13:30:48 | 2019-01-22 14:32:54 | 0 | 1 | | 16390 | VmWorkJobQueue | 748 | 1 | 2019-01-22 15:48:53 | 2019-01-22 16:12:53 | 0 | 1 | +-------+----------------+------------+-------------------+---------------------+---------------------+------------+------------------+ 740 rows in set (0.01 sec) On Wed, Jan 23, 2019 at 1:50 AM Wei ZHOU <ustcweiz...@gmail.com> wrote: > If you know the instance id and mysql password, it should work after > removing some records in mysql. > > ``` > set @id=XXXXX; > > delete from vm_work_job where vm_instance_id=@id; > delete from sync_queue where sync_objid=@id; > ``` > > Alireza Eskandari <astro.alir...@gmail.com> 于2019年1月22日周二 下午10:59写道: > > > 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. > > >