cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alessandro Caviglione <c.alessan...@gmail.com>
Subject Re: Unable to locate datastore
Date Wed, 15 Nov 2017 18:19:55 GMT
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
>
>
>
>

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