I can see now that id 3 refers to a primary storage that I had to remove a while ago. It’s still in the DB, though, and seems to be causing the error. What steps should I take to remove this reference completely from the DB? Asai
> On Aug 24, 2017, at 11:20 AM, Gabriel Beims Bräscher <gabrasc...@gmail.com> > wrote: > > Just adding to Rafael's comment. Constant database backup is also a great > idea. > > 2017-08-24 15:19 GMT-03:00 Rafael Weingärtner <rafaelweingart...@gmail.com>: > >> 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 <a...@globalchangemusic.org> wrote: >> >>> Thank you very much for the assistance. I will try that. >>> Asai >>>> On Aug 24, 2017, at 11:12 AM, Rafael Weingärtner < >>> rafaelweingart...@gmail.com> wrote: >>>> >>>> Yes, quite easily. >>>> I do not know if your problem is the same (you need a human not paying >>> much >>>> attention to cause this type of problem), but basically, you can check >> in >>>> the database what is the data store with id = 3, and then the volumes >> 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 <a...@globalchangemusic.org> >>> wrote: >>>> >>>>> Do you recall if it was able to be fixed? >>>>> Asai >>>>> >>>>> >>>>>> On Aug 24, 2017, at 11:03 AM, Rafael Weingärtner < >>>>> rafaelweingart...@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 <a...@globalchangemusic.org> >>>>> wrote: >>>>>> >>>>>>> Greetings, >>>>>>> >>>>>>> I was browsing to the Snapshots section under “Storage” 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. Can >>>>> someone >>>>>>> please assist me on how to troubleshoot this problem? >>>>>>> Asai >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Rafael Weingärtner >>>>> >>>>> >>>> >>>> >>>> -- >>>> Rafael Weingärtner >>> >>> >> >> >> -- >> Rafael Weingärtner >>