Return-Path: X-Original-To: apmail-cloudstack-dev-archive@www.apache.org Delivered-To: apmail-cloudstack-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0368318D7F for ; Tue, 18 Aug 2015 06:20:09 +0000 (UTC) Received: (qmail 30414 invoked by uid 500); 18 Aug 2015 06:20:08 -0000 Delivered-To: apmail-cloudstack-dev-archive@cloudstack.apache.org Received: (qmail 30354 invoked by uid 500); 18 Aug 2015 06:20:08 -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 30332 invoked by uid 99); 18 Aug 2015 06:20:08 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Aug 2015 06:20:08 +0000 Received: from mail-ob0-f179.google.com (mail-ob0-f179.google.com [209.85.214.179]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 19F7A1A0361; Tue, 18 Aug 2015 06:20:07 +0000 (UTC) Received: by obkg7 with SMTP id g7so1187651obk.3; Mon, 17 Aug 2015 23:20:07 -0700 (PDT) X-Received: by 10.182.142.202 with SMTP id ry10mr4364734obb.27.1439878807219; Mon, 17 Aug 2015 23:20:07 -0700 (PDT) MIME-Version: 1.0 Received: by 10.202.195.213 with HTTP; Mon, 17 Aug 2015 23:19:47 -0700 (PDT) In-Reply-To: References: From: Rajani Karuturi Date: Tue, 18 Aug 2015 11:49:47 +0530 Message-ID: Subject: Re: Usage Records are still generating even VM removed. To: "dev@cloudstack.apache.org" Cc: "users@cloudstack.apache.org" Content-Type: multipart/alternative; boundary=001a1130caead2f423051d8fe829 --001a1130caead2f423051d8fe829 Content-Type: text/plain; charset=UTF-8 update the usage_event table with VM.DESTROY event for this vm. I would say create a vm, destroy it and observer the entries in usage_event table. create a similar entry for the manually destroyed vm. ~Rajani On Tue, Aug 18, 2015 at 12:12 AM, raja sekhar wrote: > Hi All, > > The usage records are still generating even if the vm is removed from > cloudstack. > The actual scenario is: > The xenserver host went to alert state and the vms in it are not > accessible. > we have removed the vms from backend by updating vm_instance,volume table. > can any one help me what is the exact table to update? > i am using cloudstack 4.2 > > waiting for your valuable suggestions. > > > regards, > rajasekhar. > --001a1130caead2f423051d8fe829--