On 5/23/12 12:54 PM, "Jason Davis" wrote: >Would it be better to include these dumps on the original bug submission >in >Jira or replying here in the mailing list? Replying here. > >On Wed, May 23, 2012 at 2:15 PM, Alena Prokharchyk < >Alena.Prokharchyk@citrix.com> wrote: > >> On 5/23/12 8:55 AM, "Jason Davis" wrote: >> >> >I've tried the upgrade in my development environment and this has >>largely >> >worked other than the fact that the API command "listHosts" seems to >>now >> >be >> >broken. I've also tried doing a clean install of 3.0.2 and then >>restoring >> >a >> >backup copy of my MySQL DB of the 2.2.14-3.0.2 upgrade and still >>encounter >> >the same issue. >> > >> > >> >I've opened a bug report >>here:http://bugs.cloudstack.org/browse/CS-14846 >> > >> >Just curious if anyone else has tried this and have had this work >> >successfully. >> > >> >> >> >> The bug indicates that there are some references in >> "cloud.storage_pool_host_ref" table to the removed Local Storage >>instance >> ("cloud.storage_pool" table). The references were supposed to be removed >> along with the storage removal, but due to some bug they were left >>around. >> >> To debug the problem, I need the mysql db dumps of following cloudStack >> tables (2 versions - before and after upgrade): >> >> * host >> * storage_pool_host_ref >> * storage_pool; >> >> >> Thanks, >> Alena. >> >> >> >> >> >