cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alireza Eskandari <astro.alir...@gmail.com>
Subject Re: Help! Jobs stuck in pending state
Date Tue, 22 Jan 2019 22:30:53 GMT
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 <ustcweizhou@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.alireza@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.
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message