Re: DB error after upgrade to 4.2 (from 4.1.1)

Mon, 07 Oct 2013 13:22:41 -0700 

Thanks! That fixed it ;)

I guess my google skills lack a little :p

Franoic

On 10/7/2013, 2:44 PM, Go Chiba wrote:

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 <mailto: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 <http://resource_count.id>, resource_count.type,
    resource_count.account_id, resource_count.domain_id,
    resource_count.count FROM resource_count WHERE resource_count.id
    <http://resource_count.id> IN )  FOR UPDATE
    com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
    com.mysql.jdbc.JDBC4PreparedStatement@5b03fd6d: SELECT
    resource_count.id <http://resource_count.id>, resource_count.type,
    resource_count.account_id, resource_count.domain_id,
    resource_count.count FROM resource_count WHERE resource_count.id
    <http://resource_count.id> IN )  FOR UPDATE
        at
    
com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:414)
        at
    
com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
        at
    
com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:349)
        at
    
com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
        at
    com.cloud.utils.db.GenericDaoBase.search(GenericDaoBase.java:333)
        at
    
com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
        at
    com.cloud.utils.db.GenericDaoBase.lockRows(GenericDaoBase.java:315)
        at
    
com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
        at
    
com.cloud.resourcelimit.ResourceLimitManagerImpl.checkResourceLimit(ResourceLimitManagerImpl.java:383)
        at
    
com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.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.GeneratedConstructorAccessor280.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.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 <mailto:fgaudrea...@cloudops.com>
    514-629-6775 <tel:514-629-6775>
    - - -
    CloudOps
    420 rue Guy
    Montréal QC  H3J 1S6
    www.cloudops.com <http://www.cloudops.com>
    @CloudOps_




--
千葉 豪  Go Chiba
E-mail:go.ch...@gmail.com <mailto:e-mail%3ago.ch...@gmail.com>



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

Reply via email to