cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alena Prokharchyk <Alena.Prokharc...@citrix.com>
Subject Re: Latest Master DB issue
Date Tue, 08 Oct 2013 16:40:16 GMT
It is not a small issue. is_default filed was added to the table as a part
of the 41-42 db upgrade. Looks like the code tries to retrieve system user
before the db upgrade is completed.

DB upgrade is a major part of system integrity check; no queries to the DB
should be made before its completed. Francois, did you start seeing this
problem just recently?

-Alena.

On 10/8/13 8:04 AM, "Francois Gaudreault" <fgaudreault@cloudops.com> wrote:

>Hi,
>
>I compiled Master this morning, and there is a small DB issue. One field
>is missing in the account table (field default). CS will not start
>because of that.
>
>2013-10-08 11:01:42,623 FATAL [o.a.c.c.CallContext] (Timer-2:null)
>Exiting the system because we're unable to register the system call
>context.
>com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
>com.mysql.jdbc.JDBC4PreparedStatement@4c1aa2e9: SELECT account.id,
>account.account_name, account.type, account.domain_id, account.state,
>account.removed, account.cleanup_needed, account.network_domain,
>account.uuid, account.default_zone_id, account.default FROM account
>WHERE account.id = 1  AND account.removed IS NULL
>     at 
>com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:986)
>     at 
>com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorD
>ispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
>     at com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:963)
>     at 
>com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorD
>ispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
>     at 
>com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:926)
>     at 
>com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorD
>ispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
>     at 
>com.cloud.dao.EntityManagerImpl.findById(EntityManagerImpl.java:45)
>     at 
>org.apache.cloudstack.context.CallContext.register(CallContext.java:166)
>     at 
>org.apache.cloudstack.context.CallContext.registerSystemCallContextOnceOnl
>y(CallContext.java:141)
>     at 
>org.apache.cloudstack.context.CallContextListener.onEnterContext(CallConte
>xtListener.java:36)
>     at 
>org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithC
>ontext(DefaultManagedContext.java:83)
>     at 
>org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithCo
>ntext(DefaultManagedContext.java:53)
>     at 
>org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedCo
>ntextRunnable.java:46)
>     at 
>org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedC
>ontextTimerTask.java:27)
>     at java.util.TimerThread.mainLoop(Timer.java:534)
>     at java.util.TimerThread.run(Timer.java:484)
>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>Unknown column 'account.default' in 'field list'
>     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>Method)
>     at 
>sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcc
>essorImpl.java:57)
>     at 
>sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstr
>uctorAccessorImpl.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:21
>55)
>     at 
>com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
>     at 
>org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegatin
>gPreparedStatement.java:96)
>     at 
>org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegatin
>gPreparedStatement.java:96)
>     at 
>com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:983)
>     ... 27 more
>
>
>-- 
>Francois Gaudreault
>Architecte de Solution Cloud | Cloud Solutions Architect
>fgaudreault@cloudops.com
>514-629-6775
>- - -
>CloudOps
>420 rue Guy
>Montréal QC  H3J 1S6
>www.cloudops.com
>@CloudOps_
>
>



Mime
View raw message