Nitin, here you go: http://ur1.ca/fxe1h
Thanks for your help Andrei ----- Original Message ----- From: "Nitin Mehta" <nitin.me...@citrix.com> To: users@cloudstack.apache.org Sent: Wednesday, 23 October, 2013 5:47:24 AM Subject: Re: Templates and ISOs are shown twice after upgrade to 4.2 Hi Andrei - its hard to read the sql output. Can you run them with \G at the end ? select * from vm_template where uuid='b9dc8160-3052-4fdb-9beb-da02be0922df' or uuid='0c5064cd-db17-46cf-8cf0-d6f5d98ae2b0'\G; I would also suggest to dump corresponding template_store_ref entries / API response(get it from api.log) as well. Put all this and anything else you think might be useful on paste bin. Thanks, -Nitin On 22/10/13 10:21 AM, "Andrei Mikhailovsky" <and...@arhont.com> wrote: >I can't comment on the Templates as every single template is shown twice. >However, i do have several ISOs which are shown once. For example below, >the iso id 203 is shown twice, but the iso with id 326 is shown once. > >>select * from vm_template where >>uuid='b9dc8160-3052-4fdb-9beb-da02be0922df' or >>uuid='0c5064cd-db17-46cf-8cf0-d6f5d98ae2b0'; >+-----+--------------------------------------------+---------------------- >-----+--------------------------------------+--------+----------+------+-- >---+------+--------------------------------------------------------------- >--------------------------------------+--------+---------------------+---- >-----+------------+----------------------------------+-------------------- >-------+-----------------+---------------+-------------+----------+------- >------+-------------+-------------+-----------------+--------------------+ >--------------+----------+-----------+-----------+--------------+--------- >+----------------------+ >| id | unique_name | name | uuid | public | featured | type | hvm | bits >| url | format | created | removed | account_id | checksum | display_text >| enable_password | enable_sshkey | guest_os_id | bootable | prepopulate >| cross_zones | extractable | hypervisor_type | source_template_id | >template_tag | sort_key | size | state | update_count | updated | >dynamically_scalable | >+-----+--------------------------------------------+---------------------- >-----+--------------------------------------+--------+----------+------+-- >---+------+--------------------------------------------------------------- >--------------------------------------+--------+---------------------+---- >-----+------------+----------------------------------+-------------------- >-------+-----------------+---------------+-------------+----------+------- >------+-------------+-------------+-----------------+--------------------+ >--------------+----------+-----------+-----------+--------------+--------- >+----------------------+ >| 203 | 203-2-11fab458-0170-3d8d-bdac-979c0ca80399 | Ubuntu 12.10 64bit >Server | 0c5064cd-db17-46cf-8cf0-d6f5d98ae2b0 | 1 | 0 | USER | 1 | 64 | >http://mirror.ox.ac.uk/sites/releases.ubuntu.com/releases/quantal/ubuntu-1 >2.10-server-amd64+mac.iso | ISO | 2012-10-30 15:20:04 | NULL | 2 | >b8a4d9513ed53dc1be05576113b113e8 | Ubuntu 12.10 64bit Server | 0 | 0 | >157 | 1 | 0 | 1 | 0 | None | NULL | NULL | 0 | 723517440 | Allocated | 0 >| NULL | 0 | >| 326 | 326-2-c2a59a20-80a9-3e63-9466-3a1172db0a8f | Ubuntu Server >10.04.4 LTS | b9dc8160-3052-4fdb-9beb-da02be0922df | 1 | 0 | USER | 1 | >64 | >http://mirror.ox.ac.uk/sites/releases.ubuntu.com/releases/10.04/ubuntu-10. >04.4-server-amd64.iso | ISO | 2013-05-29 10:30:51 | NULL | 2 | >9b218654cdcdf9722171648c52f8a088 | Ubuntu Server 10.04.4 LTS | 0 | 0 | >126 | 1 | 0 | 1 | 0 | None | NULL | NULL | 0 | 714567680 | Allocated | 0 >| NULL | 0 | >+-----+--------------------------------------------+---------------------- >-----+--------------------------------------+--------+----------+------+-- >---+------+--------------------------------------------------------------- >--------------------------------------+--------+---------------------+---- >-----+------------+----------------------------------+-------------------- >-------+-----------------+---------------+-------------+----------+------- >------+-------------+-------------+-----------------+--------------------+ >--------------+----------+-----------+-----------+--------------+--------- >+----------------------+ >2 rows in set (0.00 sec) > >I would be happy to produce some more information. Please let me know you >need to investigate this further. > >Thanks > > >----- Original Message ----- > >From: "Nitin Mehta" <nitin.me...@citrix.com> >To: users@cloudstack.apache.org >Sent: Tuesday, 22 October, 2013 5:41:59 PM >Subject: Re: Templates and ISOs are shown twice after upgrade to 4.2 > >This is strange Andrei. Do you see any attribute different in the >duplicate entries ? >Why donĀ¹t u paste the logs/DB/snapshots of UI somewhere so that we can >help you further. > >On 22/10/13 8:15 AM, "Andrei Mikhailovsky" <and...@arhont.com> wrote: > >>Yeah, the cross_zones column has 1 for all of my templates. >> >>Thanks >> >> >>----- Original Message ----- >> >>From: "Nitin Mehta" <nitin.me...@citrix.com> >>To: users@cloudstack.apache.org >>Sent: Tuesday, 22 October, 2013 4:01:06 PM >>Subject: Re: Templates and ISOs are shown twice after upgrade to 4.2 >> >>Did you add a new zone or have multiple zones ? Are they showing up for >>different zones ? Is the cross zone flag on ? >> >>On 22/10/13 6:57 AM, "Andrei Mikhailovsky" <and...@arhont.com> wrote: >> >>>I was wondering if anyone else have noticed that the Templates and ISOs >>>are shown twice in the ACS 4.2.0 GUI. I've looked at the duplicates and >>>they have the same id/uuid and when I look in db, the templates which >>>are >>>shown twice have only a single entrance in the database. >>> >>>Any idea what is causing this? >>> >>>Cheers >> >> > >