cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Mehta <Nitin.Me...@citrix.com>
Subject Re: Templates and ISOs are shown twice after upgrade to 4.2
Date Fri, 25 Oct 2013 18:38:03 GMT
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" <andrei@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.Mehta@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" <andrei@arhont.com> wrote:
>
>>Nitin, here you go: http://ur1.ca/fxe1h
>> 
>>Thanks for your help
>> 
>>Andrei ----- Original Message -----
>> 
>>From: "Nitin Mehta" <Nitin.Mehta@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" <andrei@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.Mehta@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" <andrei@arhont.com> wrote:
>>> 
>>>>Yeah, the cross_zones column has 1 for all of my templates.
>>>> 
>>>>Thanks 
>>>> 
>>>> 
>>>>----- Original Message -----
>>>> 
>>>>From: "Nitin Mehta" <Nitin.Mehta@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" <andrei@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 
>>>> 
>>>> 
>>> 
>>> 
>> 
>> 
>
>

Mime
View raw message