For the two ISOs one of them has two entries in template store ref, the other one doesn't. Were/Are there multiple secondary storages ?
On 23/10/13 4:22 AM, "Andrei Mikhailovsky" <and...@arhont.com> wrote: >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 >>> >>> >> >> > >
