Alireza,
Can you share your db.properties file (you may replace password/ips with dummy ones)? - Rohit ________________________________ From: Ivan Kudryavtsev <kudryavtsev...@bw-sw.com> Sent: Tuesday, November 21, 2017 2:32:50 PM To: dev@cloudstack.apache.org Subject: Re: No database selected for the transaction Also, have seen that with 4.10 with two management servers on one of them. 21 нояб. 2017 г. 3:36 ПП пользователь "Alireza Eskandari" < astro.alir...@gmail.com> написал: > Hi all, > I'm using a cluster of CS 4.9.3 with 2 nodes. > After couple of weeks, I get "No database selected for the > transaction" error in logs and I have to restart the CS services to > resolve the issue. > Could you help me about it? > > Here is the logs: > > 2017-11-21 10:37:35,641 WARN [c.c.c.d.ManagementServerHostDaoImpl] > (Cluster-Heartbeat-1:ctx-a32c78be) (logid:c9227f75) Unexpected > exception, > com.cloud.utils.exception.CloudRuntimeException: No database selected > for the transaction > at com.cloud.utils.db.TransactionLegacy.getConnection( > TransactionLegacy.java:580) > at com.cloud.utils.db.TransactionLegacy.prepareStatement( > TransactionLegacy.java:467) > at com.cloud.utils.db.TransactionLegacy.prepareAutoCloseStatement( > TransactionLegacy.java:460) > at com.cloud.cluster.dao.ManagementServerHostDaoImpl.update( > ManagementServerHostDaoImpl.java:134) > at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.springframework.aop.support.AopUtils. > invokeJoinpointUsingReflection(AopUtils.java:317) > at org.springframework.aop.framework.ReflectiveMethodInvocation. > invokeJoinpoint(ReflectiveMethodInvocation.java:183) > at org.springframework.aop.framework.ReflectiveMethodInvocation. > proceed(ReflectiveMethodInvocation.java:150) > at com.cloud.utils.db.TransactionContextInterceptor.invoke( > TransactionContextInterceptor.java:34) > at org.springframework.aop.framework.ReflectiveMethodInvocation. > proceed(ReflectiveMethodInvocation.java:161) > at org.springframework.aop.interceptor. > ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) > at org.springframework.aop.framework.ReflectiveMethodInvocation. > proceed(ReflectiveMethodInvocation.java:172) > at org.springframework.aop.framework.JdkDynamicAopProxy. > invoke(JdkDynamicAopProxy.java:204) > at com.sun.proxy.$Proxy201.update(Unknown Source) > at com.cloud.cluster.ClusterManagerImpl$4.runInContext( > ClusterManagerImpl.java:554) > at org.apache.cloudstack.managed.context. > ManagedContextRunnable$1.run(ManagedContextRunnable.java:49) > at org.apache.cloudstack.managed.context.impl. > DefaultManagedContext$1.call(DefaultManagedContext.java:56) > at org.apache.cloudstack.managed.context.impl. > DefaultManagedContext.callWithContext(DefaultManagedContext.java:103) > at org.apache.cloudstack.managed.context.impl. > DefaultManagedContext.runWithContext(DefaultManagedContext.java:53) > at org.apache.cloudstack.managed.context. > ManagedContextRunnable.run(ManagedContextRunnable.java:46) > at java.util.concurrent.Executors$RunnableAdapter. > call(Executors.java:473) > at java.util.concurrent.FutureTask.runAndReset( > FutureTask.java:304) > at java.util.concurrent.ScheduledThreadPoolExecutor$ > ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) > at java.util.concurrent.ScheduledThreadPoolExecutor$ > ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) > at java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1152) > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:622) > at java.lang.Thread.run(Thread.java:748) > 2017-11-21 10:37:35,641 ERROR [c.c.c.ClusterManagerImpl] > (Cluster-Heartbeat-1:ctx-a32c78be) (logid:c9227f75) Unexpected > exception in cluster heartbeat > java.lang.RuntimeException: No database selected for the transaction > at com.cloud.cluster.dao.ManagementServerHostDaoImpl.update( > ManagementServerHostDaoImpl.java:148) > at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.springframework.aop.support.AopUtils. > invokeJoinpointUsingReflection(AopUtils.java:317) > at org.springframework.aop.framework.ReflectiveMethodInvocation. > invokeJoinpoint(ReflectiveMethodInvocation.java:183) > at org.springframework.aop.framework.ReflectiveMethodInvocation. > proceed(ReflectiveMethodInvocation.java:150) > at com.cloud.utils.db.TransactionContextInterceptor.invoke( > TransactionContextInterceptor.java:34) > at org.springframework.aop.framework.ReflectiveMethodInvocation. > proceed(ReflectiveMethodInvocation.java:161) > at org.springframework.aop.interceptor. > ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) > at org.springframework.aop.framework.ReflectiveMethodInvocation. > proceed(ReflectiveMethodInvocation.java:172) > at org.springframework.aop.framework.JdkDynamicAopProxy. > invoke(JdkDynamicAopProxy.java:204) > at com.sun.proxy.$Proxy201.update(Unknown Source) > at com.cloud.cluster.ClusterManagerImpl$4.runInContext( > ClusterManagerImpl.java:554) > at org.apache.cloudstack.managed.context. > ManagedContextRunnable$1.run(ManagedContextRunnable.java:49) > at org.apache.cloudstack.managed.context.impl. > DefaultManagedContext$1.call(DefaultManagedContext.java:56) > at org.apache.cloudstack.managed.context.impl. > DefaultManagedContext.callWithContext(DefaultManagedContext.java:103) > at org.apache.cloudstack.managed.context.impl. > DefaultManagedContext.runWithContext(DefaultManagedContext.java:53) > at org.apache.cloudstack.managed.context. > ManagedContextRunnable.run(ManagedContextRunnable.java:46) > at java.util.concurrent.Executors$RunnableAdapter. > call(Executors.java:473) > at java.util.concurrent.FutureTask.runAndReset( > FutureTask.java:304) > at java.util.concurrent.ScheduledThreadPoolExecutor$ > ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) > at java.util.concurrent.ScheduledThreadPoolExecutor$ > ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) > at java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1152) > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:622) > at java.lang.Thread.run(Thread.java:748) > Caused by: com.cloud.utils.exception.CloudRuntimeException: No > database selected for the transaction > at com.cloud.utils.db.TransactionLegacy.getConnection( > TransactionLegacy.java:580) > at com.cloud.utils.db.TransactionLegacy.prepareStatement( > TransactionLegacy.java:467) > at com.cloud.utils.db.TransactionLegacy.prepareAutoCloseStatement( > TransactionLegacy.java:460) > ... 26 more > rohit.ya...@shapeblue.com www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue
