Site 2 Site VPN on VPC not working after upgrading ACS from 4.2 to 4.8.1.1

Hi, Another issue we noted after upgrading ACS from 4.2 to 4.8.1.1 is that site-to-site VPN is not working. From GUI, I cannot even go to Home > Network > Select view: VPN customer gateway with below error messages shown on the GUI: Caught: com.mysql.jdbc.JDBC4PreparedStatement@45ae1e69:

Re: Site 2 Site VPN on VPC not working after upgrading ACS from 4.2 to 4.8.1.1

Hi, [RESOLVED] Would like to share that I managed to find the workaround to the problem by emptying the password ipsec_psk field on the entry inside s2s_customer_gateway table, delete the VPN connection, modify the VPN customer gateway with the new password (we will notice that the encrypted

Re: Long delay in listDomains API response

Dear all, After researching further, I found out that our problem is exactly the one reported on this JIRA bug: https://issues.apache.org/jira/browse/CLOUDSTACK-9405 I am cc-ing dsclose and Wei Zhou on this email. Anyone know if there's any resolution to the above problem/bug? On the bug

Re: Long delay in listDomains API response

Can you grep for this line ‘ctx-3f3ff343’ in your log and post it here? On 11/5/16, 11:01 PM, "Cloud List" wrote: Dear all, After researching further, I found out that our problem is exactly the one reported on this JIRA bug:

Re: Long delay in listDomains API response

I cannot say it is unnecessary or not for now. There are indeed many db connections when get resource limtiation/count of domains. A workaound is (1) listDomainChildren gets id of domain and sub-domains, then (2) listDomains with specified id. -Wei 2016-11-06 17:23 GMT+01:00 Cloud List

Re: Long delay in listDomains API response

Hi Sergey, Thanks for your reply. The grep result is a bit long, total 64K lines, so I have uploaded it here: https://dl.dropboxusercontent.com/u/24788636/ctx-3f3ff343.txt It seems there are a lot of unnecessary creating and closing of connections to the DB, causing the delay? Looking forward

Re: Long delay in listDomains API response

Hi Wei, Thanks for your reply. Is it possible for us to remove the resource limitation feature -- any global settings that we can set to turn this off? If not, would you be able to let us know where on the source code this is being set, so that we can try changing it and recompile ACS to turn off

Re: Long delay in listDomains API response

What essentially happens here that for each domain, you have access with your key, ACS executes 12 queries to get domain limits. Even if such query for each resource limit takes 0.03 sec it translates into 0.4 sec for each domain. If you have more than few domains, you will see rather lengthy