We ran into this with a too low MySQL connection timeout. It was set to 3
minutes, which was not enough for template copying to finish. Putting it to
the default 8 hours (which might be just a wee bit overkill) gave it plenty
of time to finish.
On Wed, Jul 2, 2014 at 1:34 PM, Wei ZHOU <ustcweiz...@gmail.com> wrote:
> what's the setting of mysql?
>
>
> show global variables like 'wait_timeout';
> show global variables like 'interactive_timeout';
>
>
>
> -Wei
>
>
> 2014-07-02 14:09 GMT+02:00 Tejas Gadaria <refond.g...@gmail.com>:
>
> > Hi,
> >
> > While trying to create template i am receiving this errors ..
> > running mysql 5.1
> >
> > need help on tthis
> >
> > 2014-07-02 15:22:47,240 DEBUG [o.a.c.s.i.s.TemplateObject]
> > (Job-Executor-4:ctx-563bed9d ctx-ad0d1b9e) failed to process event and
> > answer
> > com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
> > com.mysql.jdbc.JDBC4PreparedStatement@1f323ef6: SELECT
> > template_store_ref.id,
> > template_store_ref.store_id, template_store_ref.template_id,
> > template_store_ref.store_role, template_store_ref.created,
> > template_store_ref.last_updated, template_store_ref.download_pct,
> > template_store_ref.size, template_store_ref.physical_size,
> > template_store_ref.download_state, template_store_ref.local_path,
> > template_store_ref.error_str, template_store_ref.job_id,
> > template_store_ref.install_path, template_store_ref.url,
> > template_store_ref.is_copy, template_store_ref.destroyed,
> > template_store_ref.update_count, template_store_ref.updated,
> > template_store_ref.state, template_store_ref.ref_cnt FROM
> > template_store_ref WHERE template_store_ref.store_id = 1 AND
> > template_store_ref.template_id = 232 AND template_store_ref.destroyed =
> 0
> > ORDER BY RAND() LIMIT 1
> > at
> >
> >
> com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:421)
> > at
> >
> >
> com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:356)
> > at
> >
> >
> com.cloud.utils.db.GenericDaoBase.findOneIncludingRemovedBy(GenericDaoBase.java:869)
> > at
> >
> >
> org.apache.cloudstack.storage.image.db.TemplateDataStoreDaoImpl.findByStoreTemplate(TemplateDataStoreDaoImpl.java:320)
> > at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source)
> > at
> >
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:616)
> > 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:33)
> > 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 $Proxy108.findByStoreTemplate(Unknown Source)
> > at
> >
> >
> org.apache.cloudstack.storage.image.store.TemplateObject.processEvent(TemplateObject.java:202)
> > at
> >
> >
> org.apache.cloudstack.storage.image.TemplateServiceImpl.copyTemplateCallBack(TemplateServiceImpl.java:853)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> >
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > at
> >
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:616)
> > at
> >
> >
> org.apache.cloudstack.framework.async.AsyncCallbackDispatcher.dispatch(AsyncCallbackDispatcher.java:144)
> > at
> >
> >
> org.apache.cloudstack.framework.async.InplaceAsyncCallbackDriver.performCompletionCallback(InplaceAsyncCallbackDriver.java:26)
> > at
> >
> >
> org.apache.cloudstack.framework.async.AsyncCallbackDispatcher.complete(AsyncCallbackDispatcher.java:122)
> > at
> >
> >
> org.apache.cloudstack.storage.motion.AncientDataMotionStrategy.copyAsync(AncientDataMotionStrategy.java:440)
> > at
> >
> >
> org.apache.cloudstack.storage.motion.DataMotionServiceImpl.copyAsync(DataMotionServiceImpl.java:70)
> > at
> >
> >
> org.apache.cloudstack.storage.image.TemplateServiceImpl.copyAsync(TemplateServiceImpl.java:646)
> > at
> >
> >
> org.apache.cloudstack.storage.image.TemplateServiceImpl.createTemplateFromVolumeAsync(TemplateServiceImpl.java:659)
> > at
> >
> >
> com.cloud.template.TemplateManagerImpl.createPrivateTemplate(TemplateManagerImpl.java:1394)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> >
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > at
> >
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:616)
> > 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.event.ActionEventInterceptor.invoke(ActionEventInterceptor.java:50)
> > 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 $Proxy158.createPrivateTemplate(Unknown Source)
> > at
> >
> >
> org.apache.cloudstack.api.command.user.template.CreateTemplateCmd.execute(CreateTemplateCmd.java:265)
> > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:161)
> > at
> >
> >
> com.cloud.api.ApiAsyncJobDispatcher.runJobInContext(ApiAsyncJobDispatcher.java:109)
> > at
> > com.cloud.api.ApiAsyncJobDispatcher$1.run(ApiAsyncJobDispatcher.java:66)
> > 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
> > com.cloud.api.ApiAsyncJobDispatcher.runJob(ApiAsyncJobDispatcher.java:63)
> > at
> >
> >
> org.apache.cloudstack.framework.jobs.impl.AsyncJobManagerImpl$5.runInContext(AsyncJobManagerImpl.java:509)
> > 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:471)
> > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> > at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> > at
> >
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> > at
> >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> > at java.lang.Thread.run(Thread.java:679)
> > Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
> > Communications link failure
> >
> > The last packet successfully received from the server was 83,127
> > milliseconds ago. The last packet sent successfully to the server was 0
> > milliseconds ago.
> > at sun.reflect.GeneratedConstructorAccessor110.newInstance(Unknown
> > Source)
> > at
> >
> >
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> > at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
> > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> > at
> > com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
> > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
> > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
> > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
> > at
> >
> >
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
> > at
> >
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2283)
> > at
> >
> >
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> > at
> >
> >
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> > at
> >
> >
> com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:415)
> > ... 62 more
> > Caused by: java.io.EOFException: Can not read response from server.
> > Expected to read 4 bytes, read 0 bytes before connection was unexpectedly
> > lost.
> > ... 77 more
> > 2014-07-02 15:22:47,319 DEBUG [o.a.c.s.i.TemplateServiceImpl]
> > (Job-Executor-4:ctx-563bed9d ctx-ad0d1b9e) Failed to process copy
> template
> > callback
> > com.cloud.utils.exception.CloudRuntimeException: Failed to process event
> > at
> >
> >
> org.apache.cloudstack.storage.image.store.TemplateObject.processEvent(TemplateObject.java:232)
> > at
> >
> >
> org.apache.cloudstack.storage.image.TemplateServiceImpl.copyTemplateCallBack(TemplateServiceImpl.java:853)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> >
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > at
> >
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:616)
> > at
> >
> >
> org.apache.cloudstack.framework.async.AsyncCallbackDispatcher.dispatch(AsyncCallbackDispatcher.java:144)
> > at
> >
> >
> org.apache.cloudstack.framework.async.InplaceAsyncCallbackDriver.performCompletionCallback(InplaceAsyncCallbackDriver.java:26)
> > at
> >
> >
> org.apache.cloudstack.framework.async.AsyncCallbackDispatcher.complete(AsyncCallbackDispatcher.java:122)
> > at
> >
> >
> org.apache.cloudstack.storage.motion.AncientDataMotionStrategy.copyAsync(AncientDataMotionStrategy.java:440)
> > at
> >
> >
> org.apache.cloudstack.storage.motion.DataMotionServiceImpl.copyAsync(DataMotionServiceImpl.java:70)
> > at
> >
> >
> org.apache.cloudstack.storage.image.TemplateServiceImpl.copyAsync(TemplateServiceImpl.java:646)
> > at
> >
> >
> org.apache.cloudstack.storage.image.TemplateServiceImpl.createTemplateFromVolumeAsync(TemplateServiceImpl.java:659)
> > at
> >
> >
> com.cloud.template.TemplateManagerImpl.createPrivateTemplate(TemplateManagerImpl.java:1394)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> >
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > at
> >
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:616)
> > 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.event.ActionEventInterceptor.invoke(ActionEventInterceptor.java:50)
> > 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 $Proxy158.createPrivateTemplate(Unknown Source)
> > at
> >
> >
> org.apache.cloudstack.api.command.user.template.CreateTemplateCmd.execute(CreateTemplateCmd.java:265)
> > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:161)
> > at
> >
> >
> com.cloud.api.ApiAsyncJobDispatcher.runJobInContext(ApiAsyncJobDispatcher.java:109)
> > at
> > com.cloud.api.ApiAsyncJobDispatcher$1.run(ApiAsyncJobDispatcher.java:66)
> > 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
> > com.cloud.api.ApiAsyncJobDispatcher.runJob(ApiAsyncJobDispatcher.java:63)
> > at
> >
> >
> org.apache.cloudstack.framework.jobs.impl.AsyncJobManagerImpl$5.runInContext(AsyncJobManagerImpl.java:509)
> > 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:471)
> > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> > at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> > at
> >
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> > at
> >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> > at java.lang.Thread.run(Thread.java:679)
> > Caused by: com.cloud.utils.exception.CloudRuntimeException: DB Exception
> > on: com.mysql.jdbc.JDBC4PreparedStatement@1f323ef6: SELECT
> > template_store_ref.id, template_store_ref.store_id,
> > template_store_ref.template_id, template_store_ref.store_role,
> > template_store_ref.created, template_store_ref.last_updated,
> > template_store_ref.download_pct, template_store_ref.size,
> > template_store_ref.physical_size, template_store_ref.download_state,
> > template_store_ref.local_path, template_store_ref.error_str,
> > template_store_ref.job_id, template_store_ref.install_path,
> > template_store_ref.url, template_store_ref.is_copy,
> > template_store_ref.destroyed, template_store_ref.update_count,
> > template_store_ref.updated, template_store_ref.state,
> > template_store_ref.ref_cnt FROM template_store_ref WHERE
> > template_store_ref.store_id = 1 AND template_store_ref.template_id = 232
> > AND template_store_ref.destroyed = 0 ORDER BY RAND() LIMIT 1
> > at
> >
> >
> com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:421)
> > at
> >
> >
> com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:356)
> > at
> >
> >
> com.cloud.utils.db.GenericDaoBase.findOneIncludingRemovedBy(GenericDaoBase.java:869)
> > at
> >
> >
> org.apache.cloudstack.storage.image.db.TemplateDataStoreDaoImpl.findByStoreTemplate(TemplateDataStoreDaoImpl.java:320)
> > at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source)
> > at
> >
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:616)
> > 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:33)
> > 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 $Proxy108.findByStoreTemplate(Unknown Source)
> > at
> >
> >
> org.apache.cloudstack.storage.image.store.TemplateObject.processEvent(TemplateObject.java:202)
> > ... 46 more
> > Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
> > Communications link failure
> >
> > The last packet successfully received from the server was 83,127
> > milliseconds ago. The last packet sent successfully to the server was 0
> > milliseconds ago.
> > at sun.reflect.GeneratedConstructorAccessor110.newInstance(Unknown
> > Source)
> > at
> >
> >
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> > at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
> > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> > at
> > com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
> > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090)
> > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520)
> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
> > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
> > at
> >
> >
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
> > at
> >
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2283)
> > at
> >
> >
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> > at
> >
> >
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> > at
> >
> >
> com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:415)
> > ... 62 more
> > Caused by: java.io.EOFException: Can not read response from server.
> > Expected to read 4 bytes, read 0 bytes before connection was unexpectedly
> > lost.
> > ... 77 more
> > 2014-07-02 15:22:47,323 DEBUG [c.c.t.TemplateManagerImpl]
> > (Job-Executor-4:ctx-563bed9d ctx-ad0d1b9e) Failed to create
> > templatecom.cloud.utils.exception.CloudRuntimeException: Failed to
> process
> > event
> > edStatement.java:2119)
> > at
> >
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2283)
> > at
> >
> >
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> > at
> >
> >
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> > at
> >
> >
> com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:415)
> > ... 62 more
> > Caused by: java.io.EOFException: Can not read response from server.
> > Expected to read 4 bytes, read 0 bytes before connection was unexpectedly
> > lost.
> > ... 77 more
> > 2014-07-02 15:22:47,323 DEBUG [c.c.t.TemplateManagerImpl]
> > (Job-Executor-4:ctx-563bed9d ctx-ad0d1b9e) Failed to create
> > templatecom.cloud.utils.exception.CloudRuntimeException: Failed to
> process
> > event
> > 2014-07-02 15:22:47,460 ERROR [c.c.a.ApiAsyncJobDispatcher]
> > (Job-Executor-4:ctx-563bed9d) Unexpected exception while executing
> > org.apache.cloudstack.api.command.user.template.CreateTemplateCmd
> > com.cloud.utils.exception.CloudRuntimeException: Failed to create
> > templatecom.cloud.utils.exception.CloudRuntimeException: Failed to
> process
> > event
> > at
> >
> >
> com.cloud.template.TemplateManagerImpl.createPrivateTemplate(TemplateManagerImpl.java:1405)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> >
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > at
> >
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:616)
> > 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.event.ActionEventInterceptor.invoke(ActionEventInterceptor.java:50)
> > 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 $Proxy158.createPrivateTemplate(Unknown Source)
> > at
> >
> >
> org.apache.cloudstack.api.command.user.template.CreateTemplateCmd.execute(CreateTemplateCmd.java:265)
> > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:161)
> > at
> >
> >
> com.cloud.api.ApiAsyncJobDispatcher.runJobInContext(ApiAsyncJobDispatcher.java:109)
> > at
> > com.cloud.api.ApiAsyncJobDispatcher$1.run(ApiAsyncJobDispatcher.java:66)
> > 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
> > com.cloud.api.ApiAsyncJobDispatcher.runJob(ApiAsyncJobDispatcher.java:63)
> > at
> >
> >
> org.apache.cloudstack.framework.jobs.impl.AsyncJobManagerImpl$5.runInContext(AsyncJobManagerImpl.java:509)
> > 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:471)
> > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> > at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> > at
> >
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> > at
> >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> > at java.lang.Thread.run(Thread.java:679)
> > 2014-07-02 15:22:47,464 DEBUG [o.a.c.f.j.i.AsyncJobManagerImpl]
> > (Job-Executor-4:ctx-563bed9d) Complete async job-439, jobStatus: FAILED,
> > resultCode: 530, result:
> >
> >
> org.apache.cloudstack.api.response.ExceptionResponse/null/{"uuidList":[],"errorcode":530,"errortext":"Failed
> > to create templatecom.cloud.utils.exception.CloudRuntimeException: Failed
> > to process event"}
> > 2014-07-02 15:22:47,543 DEBUG [o.a.c.f.j.i.AsyncJobManagerImpl]
> > (Job-Executor-4:ctx-563bed9d) Done executing
> > org.apache.cloudstack.api.command.user.template.CreateTemplateCmd for
> > job-439
> > 2014-07-02 15:22:47,594 INFO [o.a.c.f.j.i.AsyncJobMonitor]
> > (Job-Executor-4:ctx-563bed9d) Remove job-439 from job monitoring
> > 2014-07-02 15:22:47,839 DEBUG [c.c.a.ApiServlet]
> > (catalina-exec-10:ctx-9fe4fa22) ===START=== 192.168.160.191 -- GET
> >
> >
> command=queryAsyncJobResult&jobId=4b904973-4cfb-4aa9-bcc9-16428d2d02e0&response=json&sessionkey=xoO20Yi%2B%2FGoLCRCprdi4C9Bpcto%3D&_=1404294767825
> > 2014-07-02 15:22:47,970 DEBUG [c.c.a.ApiServlet]
> > (catalina-exec-10:ctx-9fe4fa22 ctx-c8470a57) ===END=== 192.168.160.191
> --
> > GET
> >
> >
> command=queryAsyncJobResult&jobId=4b904973-4cfb-4aa9-bcc9-16428d2d02e0&response=json&sessionkey=xoO20Yi%2B%2FGoLCRCprdi4C9Bpcto
> >
> >
> >
> > Regards,
> > Tejas
> >
>
--
*Jeff Hair*
Core Systems Developer
Tel: (+354) 415 0200
j...@greenqloud.com
www.greenqloud.com
