Replicas will be in template_store_ref (stores template and corresponding image store its downloaded to) and not vm_template table (stores templates attributes such as public,private, format etc.) You might want to file a bug as well for this with all the info you have.
Thanks, -Nitin On 23/10/13 9:35 AM, "Andrei Mikhailovsky" <and...@arhont.com> wrote: >Nitin, > >They were a few months back, but i've removed all of them and left just >the one. Prior to upgrading to 4.2 i've not seen the double >templates/isos. They appeared after the upgrade. Is there a way for me to >remove them? If so, what tables should I look at? I've tried to find the >replicas in the database table vm_template, but they all seems to have a >single entry. Am I looking in the wrong place? > >Thanks >----- Original Message ----- > >From: "Nitin Mehta" <nitin.me...@citrix.com> >To: users@cloudstack.apache.org >Sent: Wednesday, 23 October, 2013 5:24:04 PM >Subject: Re: Templates and ISOs are shown twice after upgrade to 4.2 > >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-1 >>>0 >>>. >>>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 >>>> >>>> >>> >>> >> >> > >
