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.sonst...@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" <rafaelweingart...@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.alessan...@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.sonst...@shapeblue.com > www.shapeblue.com > 53 Chandos Place, Covent Garden, London WC2N 4HSUK > @shapeblue > > > >
