You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Andrei Mikhailovsky <an...@arhont.com> on 2013/10/22 15:57:45 UTC
Templates and ISOs are shown twice after upgrade to 4.2
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
Re: Templates and ISOs are shown twice after upgrade to 4.2
Posted by Andrei Mikhailovsky <an...@arhont.com>.
Nope, I only have a single zone and i've not added anything. I've simply upgraded from 4.1.1 to 4.2 and found it like that.
Let me check the cross zone flag and come back
Andrei
----- Original Message -----
From: "Nitin Mehta" <Ni...@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" <an...@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
Re: Templates and ISOs are shown twice after upgrade to 4.2
Posted by Nitin Mehta <Ni...@citrix.com>.
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" <an...@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" <Ni...@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" <an...@arhont.com> wrote:
>
>>Nitin, here you go: http://ur1.ca/fxe1h
>>
>>Thanks for your help
>>
>>Andrei ----- Original Message -----
>>
>>From: "Nitin Mehta" <Ni...@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" <an...@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" <Ni...@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" <an...@arhont.com> wrote:
>>>
>>>>Yeah, the cross_zones column has 1 for all of my templates.
>>>>
>>>>Thanks
>>>>
>>>>
>>>>----- Original Message -----
>>>>
>>>>From: "Nitin Mehta" <Ni...@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" <an...@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
>>>>
>>>>
>>>
>>>
>>
>>
>
>
Re: Templates and ISOs are shown twice after upgrade to 4.2
Posted by Andrei Mikhailovsky <an...@arhont.com>.
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" <Ni...@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" <an...@arhont.com> wrote:
>Nitin, here you go: http://ur1.ca/fxe1h
>
>Thanks for your help
>
>Andrei ----- Original Message -----
>
>From: "Nitin Mehta" <Ni...@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" <an...@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" <Ni...@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" <an...@arhont.com> wrote:
>>
>>>Yeah, the cross_zones column has 1 for all of my templates.
>>>
>>>Thanks
>>>
>>>
>>>----- Original Message -----
>>>
>>>From: "Nitin Mehta" <Ni...@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" <an...@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
>>>
>>>
>>
>>
>
>
Re: Templates and ISOs are shown twice after upgrade to 4.2
Posted by Nitin Mehta <Ni...@citrix.com>.
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" <an...@arhont.com> wrote:
>Nitin, here you go: http://ur1.ca/fxe1h
>
>Thanks for your help
>
>Andrei ----- Original Message -----
>
>From: "Nitin Mehta" <Ni...@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" <an...@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" <Ni...@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" <an...@arhont.com> wrote:
>>
>>>Yeah, the cross_zones column has 1 for all of my templates.
>>>
>>>Thanks
>>>
>>>
>>>----- Original Message -----
>>>
>>>From: "Nitin Mehta" <Ni...@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" <an...@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
>>>
>>>
>>
>>
>
>
Re: Templates and ISOs are shown twice after upgrade to 4.2
Posted by Andrei Mikhailovsky <an...@arhont.com>.
Nitin, here you go: http://ur1.ca/fxe1h
Thanks for your help
Andrei ----- Original Message -----
From: "Nitin Mehta" <Ni...@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" <an...@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" <Ni...@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" <an...@arhont.com> wrote:
>
>>Yeah, the cross_zones column has 1 for all of my templates.
>>
>>Thanks
>>
>>
>>----- Original Message -----
>>
>>From: "Nitin Mehta" <Ni...@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" <an...@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
>>
>>
>
>
Re: Templates and ISOs are shown twice after upgrade to 4.2
Posted by Nitin Mehta <Ni...@citrix.com>.
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" <an...@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" <Ni...@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" <an...@arhont.com> wrote:
>
>>Yeah, the cross_zones column has 1 for all of my templates.
>>
>>Thanks
>>
>>
>>----- Original Message -----
>>
>>From: "Nitin Mehta" <Ni...@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" <an...@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
>>
>>
>
>
Re: Templates and ISOs are shown twice after upgrade to 4.2
Posted by Andrei Mikhailovsky <an...@arhont.com>.
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-12.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" <Ni...@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" <an...@arhont.com> wrote:
>Yeah, the cross_zones column has 1 for all of my templates.
>
>Thanks
>
>
>----- Original Message -----
>
>From: "Nitin Mehta" <Ni...@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" <an...@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
>
>
Re: Templates and ISOs are shown twice after upgrade to 4.2
Posted by Nitin Mehta <Ni...@citrix.com>.
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" <an...@arhont.com> wrote:
>Yeah, the cross_zones column has 1 for all of my templates.
>
>Thanks
>
>
>----- Original Message -----
>
>From: "Nitin Mehta" <Ni...@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" <an...@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
>
>
Re: Templates and ISOs are shown twice after upgrade to 4.2
Posted by Andrei Mikhailovsky <an...@arhont.com>.
Yeah, the cross_zones column has 1 for all of my templates.
Thanks
----- Original Message -----
From: "Nitin Mehta" <Ni...@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" <an...@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
Re: Templates and ISOs are shown twice after upgrade to 4.2
Posted by Nitin Mehta <Ni...@citrix.com>.
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" <an...@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