Hi Francois, I thought it related to upgrade db scheme bug.[1] and 4.2 require to insert some rows after upgrade from earlier version about resource_count if you upgrade it.
[1] http://apache.markmail.org/message/yq4fzuotsmizyetc On Tue, Oct 8, 2013 at 1:54 AM, Francois Gaudreault < fgaudrea...@cloudops.com> wrote: > Hi, > > I am seeing a DB failure in our logs after an upgrade from 4.1.1 to > 4.2.0... Maybe this is already reported, but I couldn't find anything. Any > Ideas? See the trace below. > > 2013-10-07 12:52:56,537 ERROR [agent.manager.**AgentManagerImpl] > (AgentConnectTaskPool-26:null) Monitor DownloadListener says there is an > error in the connect process for 35 due to DB Exception on: com.mysql.jdbc. > **JDBC4PreparedStatement@**5b03fd6d: SELECT resource_count.id, > resource_count.type, resource_count.account_id, resource_count.domain_id, > resource_count.count FROM resource_count WHERE resource_count.id IN ) > FOR UPDATE > com.cloud.utils.exception.**CloudRuntimeException: DB Exception on: > com.mysql.jdbc.**JDBC4PreparedStatement@**5b03fd6d: SELECT > resource_count.id, resource_count.type, resource_count.account_id, > resource_count.domain_id, resource_count.count FROM resource_count WHERE > resource_count.id IN ) FOR UPDATE > at com.cloud.utils.db.**GenericDaoBase.**searchIncludingRemoved(** > GenericDaoBase.java:414) > at com.cloud.utils.component.**ComponentInstantiationPostProc** > essor$InterceptorDispatcher.**intercept(**ComponentInstantiationPostProc** > essor.java:125) > at com.cloud.utils.db.**GenericDaoBase.**searchIncludingRemoved(** > GenericDaoBase.java:349) > at com.cloud.utils.component.**ComponentInstantiationPostProc** > essor$InterceptorDispatcher.**intercept(**ComponentInstantiationPostProc** > essor.java:125) > at com.cloud.utils.db.**GenericDaoBase.search(** > GenericDaoBase.java:333) > at com.cloud.utils.component.**ComponentInstantiationPostProc** > essor$InterceptorDispatcher.**intercept(**ComponentInstantiationPostProc** > essor.java:125) > at com.cloud.utils.db.**GenericDaoBase.lockRows(** > GenericDaoBase.java:315) > at com.cloud.utils.component.**ComponentInstantiationPostProc** > essor$InterceptorDispatcher.**intercept(**ComponentInstantiationPostProc** > essor.java:125) > at com.cloud.resourcelimit.**ResourceLimitManagerImpl.** > checkResourceLimit(**ResourceLimitManagerImpl.java:**383) > at com.cloud.utils.component.**ComponentInstantiationPostProc** > essor$InterceptorDispatcher.**intercept(**ComponentInstantiationPostProc** > essor.java:125) > at org.apache.cloudstack.storage.**image.TemplateServiceImpl.** > handleTemplateSync(**TemplateServiceImpl.java:348) > at com.cloud.storage.download.**DownloadListener.**processConnect(** > DownloadListener.java:309) > at com.cloud.agent.manager.**AgentManagerImpl.** > notifyMonitorsOfConnection(**AgentManagerImpl.java:587) > at com.cloud.agent.manager.**AgentManagerImpl.**handleConnectedAgent(* > *AgentManagerImpl.java:1085) > at com.cloud.agent.manager.**AgentManagerImpl.access$100(** > AgentManagerImpl.java:144) > at com.cloud.agent.manager.**AgentManagerImpl$** > HandleAgentConnectTask.run(**AgentManagerImpl.java:1160) > at java.util.concurrent.**ThreadPoolExecutor.runWorker(** > ThreadPoolExecutor.java:1146) > at java.util.concurrent.**ThreadPoolExecutor$Worker.run(** > ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.**java:679) > Caused by: com.mysql.jdbc.exceptions.**jdbc4.**MySQLSyntaxErrorException: > You have an error in your SQL syntax; check the manual that corresponds to > your MySQL server version for the right syntax to use near ') FOR UPDATE' > at line 1 > at sun.reflect.**GeneratedConstructorAccessor28**0.newInstance(Unknown > Source) > at sun.reflect.**DelegatingConstructorAccessorI**mpl.newInstance(** > DelegatingConstructorAccessorI**mpl.java:45) > at java.lang.reflect.Constructor.**newInstance(Constructor.java:**532) > at com.mysql.jdbc.Util.**handleNewInstance(Util.java:**411) > at com.mysql.jdbc.Util.**getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.**createSQLException(SQLError.**java:1053) > 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.**executeQuery(** > PreparedStatement.java:2318) > 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:408) > ... 38 more > > -- > Francois Gaudreault > Architecte de Solution Cloud | Cloud Solutions Architect > fgaudrea...@cloudops.com > 514-629-6775 > - - - > CloudOps > 420 rue Guy > Montréal QC H3J 1S6 > www.cloudops.com > @CloudOps_ > > -- 千葉 豪 Go Chiba E-mail:go.ch...@gmail.com
