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" <a...@opencloud.net.au> 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<mailto: > 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 > > > >
