RE: Cloud Stack 4.2.1 issue (Unable to start instance due to DB Exception)

2014-04-06 Thread Amin Samir 
Hi Yitao,

Thanks for your response, we managed to solve it, the issue was with the 
user_statistics the id was not set to auto increment, we removed the records 
and altered the table to have the id column to auto increment and it worked.

Kind Regards
Amin 

-Original Message-
From: Yitao Jiang [mailto:willier...@gmail.com] 
Sent: Friday, 4 April 2014 6:42 PM
To: dev@cloudstack.apache.org
Subject: RE: Cloud Stack 4.2.1 issue (Unable to start instance due to DB 
Exception)

Hi, Amin
Can u make sure that the vrouter of new network created ?never saw this 
exception before. More related logs will be helpful.
On Apr 3, 2014 9:13 AM, "Amin Samir"  wrote:

> Hello,
>
> Can anyone please help with the below issue?
>
> Kind Regards
> Amin
>
>
>
>
> -Original Message-
> From: Amin Samir
> Sent: Tuesday, 1 April 2014 4:18 PM
> To: dev@cloudstack.apache.org
> Subject: Cloud Stack 4.2.1 issue (Unable to start instance due to DB
> Exception)
>
> Hello,
>
>
> We are facing an issue when we spin up a new instance with a new 
> network (router VM), it gives the following error:
>
> "Resource [Host:59] is unreachable: Host 59: Unable to start instance 
> due to DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@5126808a com.mysql.jdbc.JDBC4PreparedStatement@5126808a> : INSERT INTO 
> user_statistics (user_statistics.data_center_id, 
> user_statistics.account_id, user_statistics.public_ip_address,
> user_statistics.device_id, user_statistics.device_type, 
> user_statistics.network_id, user_statistics.net_bytes_received,
> user_statistics.net_bytes_sent, 
> user_statistics.current_bytes_received,
> user_statistics.current_bytes_sent, 
> user_statistics.agg_bytes_received,
> user_statistics.agg_bytes_sent) VALUES (1, 28, null, 360, 
> _binary'DomainRouter', 237, 0, 0, 0, 0, 0, 0)"
>
>
> Also we are facing this error every now and then:
>
> "(DirectAgent-93:null) GetStorageStats 
> Exception:SR_BACKEND_FAILURE_40The
> SR scan failed
>  
> [opterr=uuid=870ed96e-d62b-428a-88dc-41afc75d311a]host:13944281-3f7e-4065-8580-1dc5b64cfdb1storageid:
> 098d4f7a-a040-3462-add1-d618d6ec53c1"
>
>
>
> However when spinning a new instance with an existing network (router 
> VM) it works fine!! Has anyone faced this issue, your help would be 
> much appreciated.
>
>
> Thanks
>
>
> Kind Regards
>
> Amin
>
>
>
>

RE: Cloud Stack 4.2.1 issue (Unable to start instance due to DB Exception)

2014-04-04 Thread Yitao Jiang 
Hi, Amin
Can u make sure that the vrouter of new network created ?never saw this
exception before. More related logs will be helpful.
On Apr 3, 2014 9:13 AM, "Amin Samir"  wrote:

> Hello,
>
> Can anyone please help with the below issue?
>
> Kind Regards
> Amin
>
>
>
>
> -Original Message-
> From: Amin Samir
> Sent: Tuesday, 1 April 2014 4:18 PM
> To: dev@cloudstack.apache.org
> Subject: Cloud Stack 4.2.1 issue (Unable to start instance due to DB
> Exception)
>
> Hello,
>
>
> We are facing an issue when we spin up a new instance with a new network
> (router VM), it gives the following error:
>
> "Resource [Host:59] is unreachable: Host 59: Unable to start instance due
> to DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@5126808a com.mysql.jdbc.JDBC4PreparedStatement@5126808a> : INSERT INTO
> user_statistics (user_statistics.data_center_id,
> user_statistics.account_id, user_statistics.public_ip_address,
> user_statistics.device_id, user_statistics.device_type,
> user_statistics.network_id, user_statistics.net_bytes_received,
> user_statistics.net_bytes_sent, user_statistics.current_bytes_received,
> user_statistics.current_bytes_sent, user_statistics.agg_bytes_received,
> user_statistics.agg_bytes_sent) VALUES (1, 28, null, 360,
> _binary'DomainRouter', 237, 0, 0, 0, 0, 0, 0)"
>
>
> Also we are facing this error every now and then:
>
> "(DirectAgent-93:null) GetStorageStats Exception:SR_BACKEND_FAILURE_40The
> SR scan failed
>  
> [opterr=uuid=870ed96e-d62b-428a-88dc-41afc75d311a]host:13944281-3f7e-4065-8580-1dc5b64cfdb1storageid:
> 098d4f7a-a040-3462-add1-d618d6ec53c1"
>
>
>
> However when spinning a new instance with an existing network (router VM)
> it works fine!! Has anyone faced this issue, your help would be much
> appreciated.
>
>
> Thanks
>
>
> Kind Regards
>
> Amin
>
>
>
>

RE: Cloud Stack 4.2.1 issue (Unable to start instance due to DB Exception)

2014-04-02 Thread Amin Samir 
Hello,

Can anyone please help with the below issue?

Kind Regards
Amin 




-Original Message-
From: Amin Samir 
Sent: Tuesday, 1 April 2014 4:18 PM
To: dev@cloudstack.apache.org
Subject: Cloud Stack 4.2.1 issue (Unable to start instance due to DB Exception)

Hello,

 
We are facing an issue when we spin up a new instance with a new network 
(router VM), it gives the following error:

"Resource [Host:59] is unreachable: Host 59: Unable to start instance due to DB 
Exception on: com.mysql.jdbc.JDBC4PreparedStatement@5126808a 
 : INSERT INTO 
user_statistics (user_statistics.data_center_id, user_statistics.account_id, 
user_statistics.public_ip_address, user_statistics.device_id, 
user_statistics.device_type, user_statistics.network_id, 
user_statistics.net_bytes_received, user_statistics.net_bytes_sent, 
user_statistics.current_bytes_received, user_statistics.current_bytes_sent, 
user_statistics.agg_bytes_received, user_statistics.agg_bytes_sent) VALUES (1, 
28, null, 360, _binary'DomainRouter', 237, 0, 0, 0, 0, 0, 0)"

 
Also we are facing this error every now and then:

"(DirectAgent-93:null) GetStorageStats Exception:SR_BACKEND_FAILURE_40The SR 
scan failed  
[opterr=uuid=870ed96e-d62b-428a-88dc-41afc75d311a]host:13944281-3f7e-4065-8580-1dc5b64cfdb1storageid:
 098d4f7a-a040-3462-add1-d618d6ec53c1"

 
 
However when spinning a new instance with an existing network (router VM) it 
works fine!! Has anyone faced this issue, your help would be much appreciated.

 
Thanks

 
Kind Regards

Amin