Hi,

I have not faced problem while creating template from ISO, with 20GB Disk.
Today i was trying to create template with 40GB Disk CentOS . Then I tried
with 20GB Disk same error.
Tomorrow once i will be office i will check with connection_timeout=28800.

wait_timeout=200
connect_timeout=150
interactive_timeout=200


Regards,
Tejas










On Wed, Jul 2, 2014 at 7:10 PM, Jeff Hair <j...@greenqloud.com> wrote:

> 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
>

Reply via email to