Do not remove (delete), to remove you can mark the flags. First set the removed date flag and then the state as Destroyed.
On Thu, Aug 24, 2017 at 1:10 PM, Asai <a...@globalchangemusic.org> wrote: > 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 > >>> > > > > -- Rafael Weingärtner