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 <[email protected]> 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 <[email protected]> 于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.
> >
>
