Can you post the query you executed? On Wed, Nov 15, 2017 at 4:22 PM, Alessandro Caviglione < [email protected]> wrote:
> Sorry... I forgot to select cloud database and Rafael query returns an > error.... > I've fixed and 0 rows returned! > > On Wed, Nov 15, 2017 at 7:19 PM, Alessandro Caviglione < > [email protected]> 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 < > [email protected]> > > 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" <[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 > >> > >> > >> > >> > > > -- Rafael Weingärtner
