Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id C98302004A1 for ; Thu, 24 Aug 2017 20:21:09 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id C4CE816B53B; Thu, 24 Aug 2017 18:21:09 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 1A0D316B538 for ; Thu, 24 Aug 2017 20:21:08 +0200 (CEST) Received: (qmail 21218 invoked by uid 500); 24 Aug 2017 18:21:06 -0000 Mailing-List: contact users-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@cloudstack.apache.org Delivered-To: mailing list users@cloudstack.apache.org Received: (qmail 21206 invoked by uid 99); 24 Aug 2017 18:21:06 -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; Thu, 24 Aug 2017 18:21:06 +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 27D01C0169 for ; Thu, 24 Aug 2017 18:21:06 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.879 X-Spam-Level: * X-Spam-Status: No, score=1.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, 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-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 0Ad45fQLw6y6 for ; Thu, 24 Aug 2017 18:21:04 +0000 (UTC) Received: from mail-oi0-f41.google.com (mail-oi0-f41.google.com [209.85.218.41]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id BD88C61A58 for ; Thu, 24 Aug 2017 18:21:03 +0000 (UTC) Received: by mail-oi0-f41.google.com with SMTP id j144so2446510oib.1 for ; Thu, 24 Aug 2017 11:21:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=hxXvhcSb3TjiwtiD9AEcVybCZh71WMI9SwbjPney5UQ=; b=TG3Rs9O63G/iUn9uW6jYtqA2hob4j+cepKJa0eCoQd2d1oG1M0YFEYQbHZJM62gTAs 5DQQnwXmdjcFF4lgbqWo0yfKu+qZw6XjewmIE9TCKNDZOF8PBcHaICiFP67CyanhRgJj R9KCPK57/0FeT2sSqRnZdeHAZsvIqW8HPo0x0uMmRDF22xhGeXK8u4M00SDtaZRtnMQx JNL9VnuE5bQkXTd0pn84j+/S41R/fiwsFuZ1Rt74QhL8OglfnIZtRYWa7P3T8iRyetQ1 1zDwAwsI38Nw1Pmip70OuvSXbl6HWsINo41P3D0gCbPgbIuYf9UtI/CozrZgc4vFY9Yv h/SA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=hxXvhcSb3TjiwtiD9AEcVybCZh71WMI9SwbjPney5UQ=; b=edgkP4x2LKIRcJhC0RAQUq3jFxborvXGOYDSlcMsQnZKEAtazXOAf74uYsxoFv62xe L5AZ+bLQnl1D3ofbfqpPXTenJC6nHGT6MtkJHGTHvLv8BCCahturn7+5kRMKePcX/OZU OvuY40DlNEIjvwLkYU8YRhMDealoJbiyQaOlRxkJJYg3VGGlX7cE8x3GFckBQPirvZog 5mIV24bVWNGJXQ1WkCUpk1DbIIV67RgwYuEFtNimXmOUbYsS0raLmtmmBPSbWp0JTV++ ZDoucngJ+35jpouQDdj0PkvogVDMS0Y6Bla8PfnYayXkKl5dVUEv1MH6Pg/DiF+BStIq 7LYg== X-Gm-Message-State: AHYfb5jK2o8E/W7jADkKPzYJWjoc7+rhOoa3bQtrKX7BRVsGyryWauLf WRTjwdhnuZWcW4MDtusKvODbjA9ewkv5 X-Received: by 10.202.231.133 with SMTP id e127mr8794658oih.197.1503598856983; Thu, 24 Aug 2017 11:20:56 -0700 (PDT) MIME-Version: 1.0 Received: by 10.74.89.9 with HTTP; Thu, 24 Aug 2017 11:20:56 -0700 (PDT) In-Reply-To: References: <809B3F09-3782-40EF-88AF-8151B86F775D@globalchangemusic.org> From: =?UTF-8?Q?Gabriel_Beims_Br=C3=A4scher?= Date: Thu, 24 Aug 2017 15:20:56 -0300 Message-ID: Subject: Re: Unable to locate datastore with id To: users@cloudstack.apache.org Content-Type: multipart/alternative; boundary="001a1141bce2c15ba2055783e340" archived-at: Thu, 24 Aug 2017 18:21:10 -0000 --001a1141bce2c15ba2055783e340 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Just adding to Rafael's comment. Constant database backup is also a great idea. 2017-08-24 15:19 GMT-03:00 Rafael Weing=C3=A4rtner : > I would suggest you taking quite a lot of care before executing anything = in > the database. > Please, do not hesitate to ask for further assistance here. > > On Thu, Aug 24, 2017 at 2:15 PM, Asai wrote: > > > Thank you very much for the assistance. I will try that. > > Asai > > > On Aug 24, 2017, at 11:12 AM, Rafael Weing=C3=A4rtner < > > rafaelweingartner@gmail.com> wrote: > > > > > > Yes, quite easily. > > > I do not know if your problem is the same (you need a human not payin= g > > much > > > attention to cause this type of problem), but basically, you can chec= k > in > > > the database what is the data store with id =3D 3, and then the volum= es > of > > > snapshots that are allocated in this data store, and then you can > remove > > > them manually setting the flags. > > > > > > > > > On Thu, Aug 24, 2017 at 2:09 PM, Asai > > wrote: > > > > > >> Do you recall if it was able to be fixed? > > >> Asai > > >> > > >> > > >>> On Aug 24, 2017, at 11:03 AM, Rafael Weing=C3=A4rtner < > > >> rafaelweingartner@gmail.com> wrote: > > >>> > > >>> I have seen this issue before. In the environment I noticed it, it > was > > >>> caused by someone that manually deleted a volume in the database in > > order > > >>> to remove a data store, but the snapshot that was using that volume > was > > >> not > > >>> removed. Then, the data store was removed. By delete here I mean > > setting > > >>> the flag "removed" in the database to some data and the "state" to > > >>> destroyed. > > >>> > > >>> On Thu, Aug 24, 2017 at 1:45 PM, Asai > > >> wrote: > > >>> > > >>>> Greetings, > > >>>> > > >>>> I was browsing to the Snapshots section under =E2=80=9CStorage=E2= =80=9D today and > came > > >> up > > >>>> with this error: > > >>>> > > >>>> Unable to locate datastore with id 3 > > >>>> > > >>>> I am unable to figure this out. I went to the Secondary Storage > > server > > >>>> and it looks like all the snapshots are there from 2 days ago. Ca= n > > >> someone > > >>>> please assist me on how to troubleshoot this problem? > > >>>> Asai > > >>>> > > >>>> > > >>>> > > >>> > > >>> > > >>> -- > > >>> Rafael Weing=C3=A4rtner > > >> > > >> > > > > > > > > > -- > > > Rafael Weing=C3=A4rtner > > > > > > > -- > Rafael Weing=C3=A4rtner > --001a1141bce2c15ba2055783e340--