cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rafael Weingärtner <rafaelweingart...@gmail.com>
Subject Re: Unable to locate datastore
Date Wed, 15 Nov 2017 18:22:24 GMT
What query does not work?
Can you post the SQL result of your storage_pool table filtering by ID=11
(do not remove the metadata fields).

On Wed, Nov 15, 2017 at 4:19 PM, Alessandro Caviglione <
c.alessandro@gmail.com> wrote:

> Maybe I tried to delete storage 11 but it still here with id 12!
> Rafael query does not work, SELECT * FROM cloud.storage_pool_host_ref where
> pool_id=11 returns no result.
>
> On Wed, Nov 15, 2017 at 5:53 PM, Dag Sonstebo <Dag.Sonstebo@shapeblue.com>
> wrote:
>
> > As Rafael says – it looks like primary store 11 is already deleted – you
> > have a removed date of 2016-08-29 12:26:26 (just check that this is
> indeed
> > the removed date and not the “update_time” – the two columns follow each
> > other).
> >
> > 11 CH1-PRI-SATA-2 NetworkFilesystem 2049 1 1 2 171773001728 7672016928768
> > 192.168.200.25 /volume2/CH1-PRI-SATA-2 2016-08-24 20:57:42 2016-08-29
> > 12:26:26 Maintenance DefaultPrimary CLUSTER 0
> > 12 CH1-PRI-SATA-2 d4349999-8c54-3efa-a90a-98a35fdfbdec NetworkFilesystem
> > 2049 1 1 2 4085454602240 7672016928768 192.168.200.25
> > /volume2/CH1-PRI-SATA-2 2016-08-29 12:28:06 Up DefaultPrimary CLUSTER 0
> >
> > Also check your host to pool config:
> >
> > SELECT * FROM cloud.storage_pool_host_ref where pool_id=11;
> >
> > This will show you if pool 11 is attached to any hosts. Apart from that
> > check the volumes and snapshots as Rafael suggests to make sure
> CloudStack
> > doesn’t think pool 11 is still in use.
> >
> > (and appreciate you want to delete another pool – not sure why it would
> > complain about 11, but if you get to the bottom of the above hopefully
> the
> > other deletion will work)
> >
> > Regards,
> > Dag Sonstebo
> > Cloud Architect
> > ShapeBlue
> >
> > On 15/11/2017, 16:31, "Rafael Weingärtner" <rafaelweingartner@gmail.com>
> > wrote:
> >
> >     Was this storage with ID 11 deleted?
> >     You can check everything allocated in it by issue the following SQLs:
> >
> >     To find all snapshots:
> >     select s.* from snapshots s join
> >         volumes v on v.id = s.volume_id
> >         where
> >         pool_id = ?
> >
> >     To find all volumes:
> >     select v.* from snapshots s join
> >         volumes v on v.id = s.volume_id
> >         where
> >         pool_id = ?
> >
> >
> >     On Wed, Nov 15, 2017 at 2:23 PM, Alessandro Caviglione <
> >     c.alessandro@gmail.com> wrote:
> >
> >     > Hi guys,
> >     > I'm trying to delete a Primary datastore, but when I try to delete
> > it I got
> >     > this error:
> >     >
> >     > Unable to locate datastore with id 11
> >     >
> >     > In the database, I see:
> >     >
> >     > 11 CH1-PRI-SATA-2 NetworkFilesystem 2049 1 1 2 171773001728
> > 7672016928768
> >     > 192.168.200.25 /volume2/CH1-PRI-SATA-2 2016-08-24 20:57:42
> 2016-08-29
> >     > 12:26:26 Maintenance DefaultPrimary CLUSTER 0
> >     > 12 CH1-PRI-SATA-2 d4349999-8c54-3efa-a90a-98a35fdfbdec
> > NetworkFilesystem
> >     > 2049 1 1 2 4085454602240 7672016928768 192.168.200.25
> >     > /volume2/CH1-PRI-SATA-2 2016-08-29 12:28:06 Up DefaultPrimary
> > CLUSTER 0
> >     >
> >     > In fact, 11 and 12 are the same primary storage but for a strange
> > reason,
> >     > 11 is in maintenance and does not have an ID....
> >     >
> >     > How can I solve?
> >     > Could I copy all the data from 12 to 11 and delete the primary
> > storage I
> >     > want to delete?
> >     > Keep in mind that the storage I need to delete is another one, not
> >     > CH1-PRI-SATA-2
> >     >
> >     > Thank you.
> >     >
> >
> >
> >
> >     --
> >     Rafael Weingärtner
> >
> >
> >
> > Dag.Sonstebo@shapeblue.com
> > www.shapeblue.com
> > 53 Chandos Place, Covent Garden, London  WC2N 4HSUK
> > @shapeblue
> >
> >
> >
> >
>



-- 
Rafael Weingärtner

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message