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" <[email protected]> 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 < [email protected]> 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 [email protected] www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue
