Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 417B2CE86 for ; Thu, 25 Jul 2013 17:13:50 +0000 (UTC) Received: (qmail 17375 invoked by uid 500); 25 Jul 2013 17:13:50 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 17336 invoked by uid 500); 25 Jul 2013 17:13:49 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 17314 invoked by uid 500); 25 Jul 2013 17:13:49 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 17304 invoked by uid 99); 25 Jul 2013 17:13:48 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Jul 2013 17:13:48 +0000 Date: Thu, 25 Jul 2013 17:13:48 +0000 (UTC) From: "Sailaja Mada (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CLOUDSTACK-3534) SQL Exception while updating Async job status when trying to put cluster level primary storage into maintenance mode MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CLOUDSTACK-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13719785#comment-13719785 ] Sailaja Mada commented on CLOUDSTACK-3534: ------------------------------------------ Hi Alena, Issue was found in a different QA setup and details are provided by Talluri. log file size must be huge (>10 MB) . I guess that would be the reason he would have uploaded in a sharefile. Thanks. Sailaja.M > SQL Exception while updating Async job status when trying to put cluster level primary storage into maintenance mode > --------------------------------------------------------------------------------------------------------------------- > > Key: CLOUDSTACK-3534 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3534 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the default.) > Components: Management Server > Affects Versions: 4.2.0 > Reporter: Sailaja Mada > Assignee: Alena Prokharchyk > Priority: Critical > Fix For: 4.2.0 > > Attachments: apilog.log, management-server.log > > > Steps: > 1. Configure Advance Zone configuration using VMWARE > 2. Add two primary storages (1 - Cluster level during zone config 2 - Zone level PS ) > 3. Deploy VM and add one volume using User account on to the cluster level PS > 4. Tried to put the cluster level PS into maintenance state > Observation: > SQL Exception while updating Async job status when trying to put the host into maintenance mode > 2013-07-15 20:23:48,277 DEBUG [agent.manager.DirectAgentAttache] (DirectAgent-158:null) Seq 1-1271202483: Response Received: > 2013-07-15 20:23:48,277 DEBUG [agent.manager.ClusteredAgentManagerImpl] (DirectAgent-158:null) Seq 1-1271202483: MgmtId 94838926819810: Resp: Routing to peer > 2013-07-15 20:23:50,272 DEBUG [storage.secondary.SecondaryStorageManagerImpl] (secstorage-1:null) Zone 1 is ready to launch secondary storage VM > 2013-07-15 20:23:51,284 DEBUG [cloud.consoleproxy.ConsoleProxyManagerImpl] (consoleproxy-1:null) Skip capacity scan due to there is no Primary Storage UPintenance mode > 2013-07-15 20:23:52,370 DEBUG [db.Transaction.Transaction] (catalina-exec-3:null) Rolling back the transaction: Time = 50962 Name = queryAsyncJobResult; called by -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-TransactionContextBuilder.interceptException:63-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:133-GenericDaoBase.update:775-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:125-GenericDaoBase.update:1256-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:125-AsyncJobManagerImpl.queryAsyncJobResult:441-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:125-AsyncJobManagerImpl.queryAsyncJobResult:401 > 2013-07-15 20:23:52,370 ERROR [cloud.async.AsyncJobManagerImpl] (catalina-exec-3:null) Unexpected exception while querying async job-54 = [ 375a5b3d-ad76-4367-a04b-7b2a94668cb1 ] status: > com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.PreparedStatement@3f71962d: UPDATE async_job SET async_job.last_polled='2013-07-15 14:53:01' WHERE async_job.id = 54 > at com.cloud.utils.db.GenericDaoBase.update(GenericDaoBase.java:822) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.utils.db.GenericDaoBase.update(GenericDaoBase.java:775) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.utils.db.GenericDaoBase.update(GenericDaoBase.java:1256) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.async.AsyncJobManagerImpl.queryAsyncJobResult(AsyncJobManagerImpl.java:441) > at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125) > at com.cloud.async.AsyncJobManagerImpl.queryAsyncJobResult(AsyncJobManagerImpl.java:401) > at com.cloud.api.ApiResponseHelper.queryJobResult(ApiResponseHelper.java:1929) > at org.apache.cloudstack.api.command.user.job.QueryAsyncJobResultCmd.execute(QueryAsyncJobResultCmd.java:66) > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:158) > at com.cloud.api.ApiServer.queueCommand(ApiServer.java:529) > at com.cloud.api.ApiServer.handleRequest(ApiServer.java:371) > at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:304) > at com.cloud.api.ApiServlet.doGet(ApiServlet.java:66) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555) > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > at org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:889) > at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:721) > at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2268) > 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: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) > at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) > at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450) > at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371) > at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) > at com.cloud.utils.db.GenericDaoBase.update(GenericDaoBase.java:814) > ... 48 more > 2013-07-15 20:23:52,379 DEBUG [cloud.api.ApiServlet] (catalina-exec-3:null) ===END=== 10.104.255.13 -- GET command=queryAsyncJobResult&jobId=375a5b3d-ad76-4367-a04b-7b2a94668cb1&response=json&sessionkey=Qao%2FstRUJUp6xhAbIH5OSE5XRNw%3D&_=1373900159912 > 2013-07-15 20:23:52,693 DEBUG [cloud.api.ApiServlet] (catalina-exec-6:null) ===START=== 10.104.255.13 -- GET command=queryAsyncJobResult&jobId=375a5b3d-ad76-4367-a04b-7b2a94668cb1&response=json&sessionkey=Qao%2FstRUJUp6xhAbIH5OSE5XRNw%3D&_=1373900210676 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira