From dev-return-112396-archive-asf-public=cust-asf.ponee.io@cloudstack.apache.org Tue Jan 22 23:31:11 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 81395180634 for ; Tue, 22 Jan 2019 23:31:10 +0100 (CET) Received: (qmail 2009 invoked by uid 500); 22 Jan 2019 22:31:09 -0000 Mailing-List: contact dev-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list dev@cloudstack.apache.org Received: (qmail 1997 invoked by uid 99); 22 Jan 2019 22:31:08 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Jan 2019 22:31:08 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 474EBC0568 for ; Tue, 22 Jan 2019 22:31:08 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.797 X-Spam-Level: * X-Spam-Status: No, score=1.797 tagged_above=-999 required=6.31 tests=[DKIMWL_WL_MED=-0.001, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id MMm9in6LpHZ1 for ; Tue, 22 Jan 2019 22:31:07 +0000 (UTC) Received: from mail-it1-f196.google.com (mail-it1-f196.google.com [209.85.166.196]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id D7B1B610CE for ; Tue, 22 Jan 2019 22:31:06 +0000 (UTC) Received: by mail-it1-f196.google.com with SMTP id i145so347683ita.4 for ; Tue, 22 Jan 2019 14:31:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=Ot+fPJ6Fv4+q4epSVZq7myk0+KLgdEmUhCVBNyFwRWg=; b=c2s7Yzdp1FXgIRhUV/0WHEmrwBxs/qe+nPrGMez0iNRqmfZOkl9euTGeVtqqI8XEe+ F4iqi4MTfwE4W5Zmrf1XNLYK0wPSECCTnMHmKUobjAcDK5KA4wzbLxZvPq21HPWphk60 l0EDLzjPJwNQvNXzebSRDXTsbdYpExesCPvP9Pt+go7VkyZfRvDuTXbEnWlOoY9FNHN8 Olh92p9EH5DD0Dd0NHlTsbfuFStTnzgnhq8fNO+eFIcwKKLYdEmtxuESoEgy3Gxg7MIc ABG/9bxpr5uKqu1KWkgWPdAPSS4TM8RKoB5rdG8QBr2CGx5Q9qLDrvvAR7ISHusTb019 F+zQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=Ot+fPJ6Fv4+q4epSVZq7myk0+KLgdEmUhCVBNyFwRWg=; b=h0aS1ZFsDZnPhhn8mzOseksQLoOJYBrRIQIUgOsZRE212s9JJkDk2N2V56/jaIRVJf jM+kLesue6ShDMh9nh3doTvRT9ikHMvjMKcNnnxkm0zWrPJgRTxHch4um17LtfX7NGNK LmjAEOxqrh+YbMoQRMk4Sk6+5ZJe7aqI5B9z1xfROOSNMVfy8srIoLkm8Rinw8KO60T2 s3OvYIFJlEJQwh1loCkHzfQiaATEULwoBofP4mdEYSuG2gf5ybu+pXA9vLVslibW9Scg 0As5V1yWxSxsAxRV8gRtrroFRyPNEdRfUDujC39lJBiXlQZ6dFEkiO2NJVDbNVnh7gXG lTqA== X-Gm-Message-State: AJcUukeZIsoX7Tlub8odwtlwtmKrxtlGW6kSJFUic9Ug5Kut/UUOmlWx uZSlceqY4sU83UZkYX3VcOR6JHVMiayS5ueA3tMNXZex5Ek= X-Google-Smtp-Source: ALg8bN7SjKd/mas+hIwTtlmSByqAAYRi9OmLza54XEW6RTHcRmQvyNTyNM5HsXTOQ2d4lqsseb8SeP4roPqi7CxGYFI= X-Received: by 2002:a24:c2c1:: with SMTP id i184mr239089itg.117.1548196265919; Tue, 22 Jan 2019 14:31:05 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Alireza Eskandari Date: Wed, 23 Jan 2019 02:00:53 +0330 Message-ID: Subject: Re: Help! Jobs stuck in pending state To: dev@cloudstack.apache.org Content-Type: multipart/alternative; boundary="0000000000007909dd05801388c5" --0000000000007909dd05801388c5 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 wrote: > If you know the instance id and mysql password, it should work after > removing some records in mysql. > > ``` > set @id=3DXXXXX; > > delete from vm_work_job where vm_instance_id=3D@id; > delete from sync_queue where sync_objid=3D@id; > ``` > > Alireza Eskandari =E4=BA=8E2019=E5=B9=B41=E6=9C= =8822=E6=97=A5=E5=91=A8=E4=BA=8C =E4=B8=8B=E5=8D=8810:59=E5=86=99=E9=81=93= =EF=BC=9A > > > 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. > > > --0000000000007909dd05801388c5--