RE: Update for those having database upgrade issues recently

2020-01-23 Thread Sean Lair
Yep, see this Issue:

https://github.com/apache/cloudstack/issues/3826


-Original Message-
From: Robert Ward  
Sent: Wednesday, January 22, 2020 9:42 PM
To: users@cloudstack.apache.org
Subject: Update for those having database upgrade issues recently

Hello,

If you have been one of the unfortunate ones with the recent database upgrade 
problem I have stumbled across a possible solution...at least in my case.

Looking a little closer at the logs it seems there was some sort of java 
disconnect triggering the DB upgrade issue so I decided to downgrade the 
mysql-connector-java module. In my case that did the trick! Everything seems to 
working ok so far.

BTW - I am running mysql-connector-python-8.0.19 so that may have not been the 
culprit after all.

Robert


Re: new primary storage

2020-01-23 Thread Charlie Holeowsky
I still don't understand
why com.cloud.hypervisor.kvm.storage.LibvirtStoragePool don't find the
volume d93d3c0a-3859-4473-951d-9b5c5912c76 that exists as file
39148fe1-842b-433a-8a7f-85e90f316e04...

It's the only anomaly I have found. Where can I look again?

Il giorno lun 20 gen 2020 alle ore 16:27 Daan Hoogland <
daan.hoogl...@gmail.com> ha scritto:

> but the record you send earlier also says that is should be looking for
> 39148fe1-842b-433a-8a7f-85e90f316e04, in the path field. the message might
> be just that, a message.
>
> On Mon, Jan 20, 2020 at 3:35 PM Charlie Holeowsky <
> charlie.holeow...@gmail.com> wrote:
>
>> I think that's the problem because in the logs that I have forwarded it
>> reads:
>> Can't find volume: d93d3c0a-3859-4473-951d-9b5c5912c767
>>
>> This is the volume ID of migrated file but it do not exist on primary
>> storage (new or old one) but it exist
>> as 39148fe1-842b-433a-8a7f-85e90f316e04.
>>
>> Il giorno lun 20 gen 2020 alle ore 12:35 Daan Hoogland <
>> daan.hoogl...@gmail.com> ha scritto:
>>
>>> also, can you see the primary storage being mounted?
>>>
>>>
>>> On Mon, Jan 20, 2020 at 12:33 PM Daan Hoogland 
>>> wrote:
>>>
 Why do you think that Charlie? Is it in the logs like that somewhere?

 On Mon, Jan 20, 2020 at 9:52 AM Charlie Holeowsky <
 charlie.holeow...@gmail.com> wrote:

> Hi Daan,
> in fact I find the volume file (39148fe1-842b-433a-8a7f-85e90f316e04)
> in the repositry id = 3 (the new one) but it seems to me that the
> cloudstack system goes looking for the volume with its "old" name
> (path) that doesn't exist...
>
> Il giorno sab 18 gen 2020 alle ore 21:41 Daan Hoogland <
> daan.hoogl...@gmail.com> ha scritto:
>
>> Charlie,
>> forgive my not replying in a timely manner. This might happen if the
>> disk was migrated. In this case probably from primary storage with id 1 
>> to
>> the one with id 3. the second record (pool_id 1) is removed, so you can
>> ignore that one. The first seems legit. You should be able to find that
>> disks on your primary storage with id 3.
>> hope this helps.
>>
>> On Thu, Jan 16, 2020 at 2:07 PM Charlie Holeowsky <
>> charlie.holeow...@gmail.com> wrote:
>>
>>> Hi Daan and users,
>>> to better explain I show you the two records related to the disk
>>> that generates the error message.
>>>
>>> In the first query there are the data of the disk currently in use
>>> which has the "uuid" equal to the name searched by the procedure
>>> com.cloud.hypervisor.kvm.storage.LibvirtStoragePool.getPhysicalDiskand a
>>> has a different "path" field.
>>>
>>> In the second one we note that the "path" field is equal to the
>>> "uuid" of the volume in use but has null "uuid" (and state=Expunged).
>>>
>>>
>>> mysql> select * from volumes where
>>> uuid='d93d3c0a-3859-4473-951d-9b5c5912c767';
>>>
>>> +-++---+-+--+-+---+--+--+-+-+--++++-+-+---+--+-++-+-+--+-+-+---++--+---+++++--+--+---+---+
>>> | id  | account_id | domain_id | pool_id | last_pool_id |
>>> instance_id | device_id | name | uuid   
>>>   |
>>> size| folder  | path
>>>  |
>>> pod_id | data_center_id | iscsi_name | host_ip | volume_type | 
>>> pool_type |
>>> disk_offering_id | template_id | first_snapshot_backup_uuid | 
>>> recreatable |
>>> created | attached | updated | removed | state |
>>> chain_info | update_count | disk_type | vm_snapshot_chain_size | iso_id 
>>> |
>>> display_volume | format | min_iops | max_iops | hv_ss_reserve |
>>> provisioning_type |
>>>
>>> +-++---+-+--+-+---+--+--+-+-+--++++-+-+---+--+-++-+-+--+-+-+---++--+---+++++--+--+---+---+
>>> | 213 |  2 | 1 |   3 |1 |
>>> 148 | 1 | DATA-148 | 

Cloudstack Collaboration Conference - CFP open

2020-01-23 Thread Giles Sirett
All

This years CloudStack Collaboration Conference (CCC) will be co-located with 
Apachecon North America, which is running September 28th - October 2nd at the 
Sheraton, New Orleans. https://apachecon.com/acna2020

We have got commitment from the Apachecon organisers to have two rooms for 3 
days - so CCC will be a 3 day event.  This will allow us to run 2 x talk tracks 
for the first 2 days and a hackathon for the 3rd  day. This was the format we 
used this year in Las Vegas, which was very successful. We are waiting for 
confirmation on which days we will have rooms


Submit your Cloudstack talks/presentations

Last year, CCC was so successful primarily because of the excellent & varied 
talk content from this community

The CFP for CCC is run via the ApacheCon CFP, which is now open at 
https://apachecon.com/acna2020/cfp
Talks will then be selected by a panel selected by the Cloudstack PMC.

The CFP will close on Friday 1 May 2020 8am (UTC-5). As per last year, I 
apologise that this date is so far ahead of the actual conference. Personally I 
find it very difficult to even think of suitable subjects 5 months ahead  - but 
it is a framework that we have agreed to work with.


These conferences only work if we all are prepared to share our experiences, 
the work we've been doing and our ideas around Cloudstack - so I ask everybody 
in our community to think about submitting a talk.  Yes, that is difficult 5 
months ahead, but please do try. Speakers get a free pass to the conference.


The CFP is at https://apachecon.com/acna2020/cfp and remember to choose 
Cloudstack in the track.







Kind regards
Giles

giles.sir...@shapeblue.comĀ 
www.shapeblue.com
Amadeus House, Floral Street, London  WC2E 9DPUK
@shapeblue
  
 



systemvm

2020-01-23 Thread Piotr Pisz
Hi,

I have a very strange error, all system machines are no deployed properly. 
For example, the virtual router starts, receives the ip address in the link 
local but is not configured. 
The probable reason is that ssh does not work on the machine. After checking it 
turns out that I get a message: /usr/sbin/sshd cannot execute binary file: exec 
format error 
At the same time, haproxy ntpd services are working properly. CS verison is 4.13

Regards,
Piotr 





Update for those having database upgrade issues recently

2020-01-23 Thread Robert Ward
Hello,

If you have been one of the unfortunate ones with the recent database upgrade 
problem I have stumbled across a possible solution...at least in my case.

Looking a little closer at the logs it seems there was some sort of java 
disconnect triggering the DB upgrade issue so I decided to downgrade the 
mysql-connector-java module. In my case that did the trick! Everything seems to 
working ok so far.

BTW - I am running mysql-connector-python-8.0.19 so that may have not been the 
culprit after all.

Robert