I the DB table snapshot_store_ref I see two snapshots listed with store_id 3. Can I safely remove those rows? Asai Network and Systems Administrator GLOBAL CHANGE MEDIA office: 520.398.2542 http://globalchange.media Tucson, AZ
> On Aug 24, 2017, at 1:06 PM, Asai <a...@globalchangemusic.org> wrote: > > 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 >>> >