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" <fgaudrea...@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 >fgaudrea...@cloudops.com >514-629-6775 >- - - >CloudOps >420 rue Guy >Montréal QC H3J 1S6 >www.cloudops.com >@CloudOps_ > >
