On 3/4/06, Vincent <[EMAIL PROTECTED]> wrote:
> Just wanted to give you guys some feedback.
> Tomcat 5.5.9 (Sun) jdk 1.5 on redhat linux.
> I moved from 2.01 to 2.1.
> First the install script had problems:
>
>
>
> mysql> source 200-to-210-migration.sql
>
> ERROR 1067 (42000): Invalid default value for 'approved'
> ERROR 1067 (42000): Invalid default value for 'pending'
> ERROR 1054 (42S22): Unknown column 'approved' in 'field list'
> ERROR 1067 (42000): Invalid default value for 'commentmod'
> ERROR 1067 (42000): Invalid default value for 'defaultallowcomments'
> Query OK, 2 rows affected (0.01 sec)
> Records: 2 Duplicates: 0 Warnings: 0
>
> Query OK, 2 rows affected (0.01 sec)
> Records: 2 Duplicates: 0 Warnings: 0
>
> ERROR 1054 (42S22): Unknown column 'commentmod' in 'field list'
> ERROR 1061 (42000): Duplicate key name 'we_status_idx'
> Query OK, 2 rows affected (0.00 sec)
> Records: 2 Duplicates: 0 Warnings: 0
>
> mysql> quit
>
>
>
>
>
>
> this are some tomcat logs with traces I got starting up roller before I
> fell asleep
> last night:
>
>
>
> INFO 2006-03-04 10:10:38,559 IndexManagerImpl:<init> - search enabled: true
> INFO 2006-03-04 10:10:38,560 IndexManagerImpl:<init> - index dir:
> /web/java/roller_data/search-index
>
> ==> /usr/local/tomcat/logs/catalina.2006-03-04.log <==
> Mar 4, 2006 10:10:39 AM org.apache.catalina.core.StandardContext filterStart
> SEVERE: Exception starting filter securityFilter
> java.lang.IllegalStateException: No WebApplicationContext found: no
> ContextLoaderListener registered?
This seems to imply that Spring's ContextLoaderListener is not loading
- probably because of all the other database issues.
Matt
> at
> org.springframework.web.context.support.WebApplicationContextUtils.getRequiredWebApplicationContext(WebApplicationContextUtils.java:84)
> at
> org.acegisecurity.util.FilterToBeanProxy.getContext(FilterToBeanProxy.java:144)
> at
> org.acegisecurity.util.FilterToBeanProxy.doInit(FilterToBeanProxy.java:165)
> at
> org.acegisecurity.util.FilterToBeanProxy.init(FilterToBeanProxy.java:132)
> at
> org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:225)
> at
> org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:308)
> at
> org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:79)
> at
> org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3540)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4110)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
> at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
> at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536)
> at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471)
> at
> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
> at
> org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:450)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
> Mar 4, 2006 10:10:39 AM org.apache.catalina.core.StandardContext start
> SEVERE: Error filterStart
> Mar 4, 2006 10:10:39 AM org.apache.catalina.core.StandardContext start
> SEVERE: Context [/roller] startup failed due to previous errors
> Mar 4, 2006 10:10:39 AM org.apache.catalina.startup.HostConfig deployWAR
> INFO: Deploying web application archive ROOT.war
>
> ==> /usr/local/tomcat/logs/roller.log <==
> INFO 2006-03-04 10:10:38,680 IndexManagerImpl:<init> - Index was
> inconsistent. Rebuilding index in the background...
> INFO 2006-03-04 10:10:38,746 WriteToIndexOperation:run - Starting
> search index operation
> WARN 2006-03-04 10:10:38,894 JDBCExceptionReporter:logExceptions - SQL
> Error: 1054, SQLState: 42S22
> ERROR 2006-03-04 10:10:38,896 JDBCExceptionReporter:logExceptions -
> Unknown column 'websitedat2_.defaultallowcomments' in 'field list'
> FATAL 2006-03-04 10:10:38,910 RollerContext:contextInitialized -
> RollerContext initialization failed
> org.roller.RollerException
> at
> org.roller.business.hibernate.HibernatePingTargetManagerImpl.getCommonPingTargets(HibernatePingTargetManagerImpl.java:50)
> at
> org.roller.config.PingConfig.initializeCommonTargets(PingConfig.java:175)
> at
> org.roller.presentation.RollerContext.initializePingFeatures(RollerContext.java:228)
> at
> org.roller.presentation.RollerContext.contextInitialized(RollerContext.java:159)
> at
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4104)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
> at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
> at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536)
> at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471)
> at
> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
> at
> org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:450)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
> --- ROOT CAUSE ---
> org.hibernate.exception.SQLGrammarException: could not execute query
> at
> org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.loader.Loader.doList(Loader.java:1596)
> at org.hibernate.loader.Loader.list(Loader.java:1577)
> at
> org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
> at
> org.roller.business.hibernate.HibernatePingTargetManagerImpl.getCommonPingTargets(HibernatePingTargetManagerImpl.java:46)
> at
> org.roller.config.PingConfig.initializeCommonTargets(PingConfig.java:175)
> at
> org.roller.presentation.RollerContext.initializePingFeatures(RollerContext.java:228)
> at
> org.roller.presentation.RollerContext.contextInitialized(RollerContext.java:159)
> at
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4104)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
> at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
> at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536)
> at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471)
> at
> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
> at
> org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:450)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
> Caused by: java.sql.SQLException: Unknown column
> 'websitedat2_.defaultallowcomments' in 'field list'
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
> at
> org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> at
> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
> at org.hibernate.loader.Loader.doQuery(Loader.java:391)
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
> at org.hibernate.loader.Loader.doList(Loader.java:1593)
> ... 32 more
> WARN 2006-03-04 10:10:39,020 JDBCExceptionReporter:logExceptions - SQL
> Error: 1054, SQLState: 42S22
> ERROR 2006-03-04 10:10:39,021 JDBCExceptionReporter:logExceptions -
> Unknown column 'websitedat4_.defaultallowcomments' in 'field list'
> ERROR 2006-03-04 10:10:39,022
> HibernateWeblogManagerImpl:getWeblogEntries -
> org.hibernate.exception.SQLGrammarException: could not execute query
> ERROR 2006-03-04 10:10:39,023 RebuildWebsiteIndexOperation:doRun - ERROR
> adding doc to index
> org.roller.RollerException
> at
> org.roller.business.hibernate.HibernateWeblogManagerImpl.getWeblogEntries(HibernateWeblogManagerImpl.java:253)
> at
> org.roller.business.WeblogManagerImpl.getWeblogEntries(WeblogManagerImpl.java:301)
> at
> org.roller.business.search.operations.RebuildWebsiteIndexOperation.doRun(RebuildWebsiteIndexOperation.java:112)
> at
> org.roller.business.search.operations.WriteToIndexOperation.run(WriteToIndexOperation.java:41)
> at
> EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
> at java.lang.Thread.run(Thread.java:595)
> --- ROOT CAUSE ---
> org.hibernate.exception.SQLGrammarException: could not execute query
> at
> org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.loader.Loader.doList(Loader.java:1596)
> at org.hibernate.loader.Loader.list(Loader.java:1577)
> at
> org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
> at
> org.roller.business.hibernate.HibernateWeblogManagerImpl.getWeblogEntries(HibernateWeblogManagerImpl.java:248)
> at
> org.roller.business.WeblogManagerImpl.getWeblogEntries(WeblogManagerImpl.java:301)
> at
> org.roller.business.search.operations.RebuildWebsiteIndexOperation.doRun(RebuildWebsiteIndexOperation.java:112)
> at
> org.roller.business.search.operations.WriteToIndexOperation.run(WriteToIndexOperation.java:41)
> at
> EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.SQLException: Unknown column
> 'websitedat4_.defaultallowcomments' in 'field list'
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
> at
> org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> at
> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
> at org.hibernate.loader.Loader.doQuery(Loader.java:391)
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
> at org.hibernate.loader.Loader.doList(Loader.java:1593)
> ... 10 more
> INFO 2006-03-04 10:10:39,055 BreadCrumbFilter:init - set breadcrumb
> stack size to 3
> INFO 2006-03-04 10:10:39,079 FeedCacheFilter:init - Initializing feed cache
> INFO 2006-03-04 10:10:39,081 FeedCacheFilter:init - {timeout=3600,
> size=200}
> INFO 2006-03-04 10:10:39,090 RebuildWebsiteIndexOperation:doRun -
> Completed rebuilding index for all users in '0.343' secs
> INFO 2006-03-04 10:10:39,091 WriteToIndexOperation:run - Search index
> operation complete
> INFO 2006-03-04 10:10:39,095 CacheManager:<clinit> - Cache Manager
> Initialized.
> INFO 2006-03-04 10:10:39,096 CacheManager:<clinit> - Default cache
> factory = org.roller.presentation.cache.ExpiringLRUCacheFactoryImpl
> INFO 2006-03-04 10:10:39,112 MainPageCacheFilter:init - Initializing
> main page cache
> INFO 2006-03-04 10:10:39,114 MainPageCacheFilter:init - {timeout=1800,
> excludeOwnerEditPages=false, size=10}
> INFO 2006-03-04 10:10:39,118 IfPlanetModifiedFilter:init - Initializing
> if-modified planet filter
> INFO 2006-03-04 10:10:39,124 RefererFilter:init - Referrer processing
> enabled = true
> INFO 2006-03-04 10:10:39,129 WeblogPageCacheFilter:init - Initializing
> weblog page cache
> INFO 2006-03-04 10:10:39,131 WeblogPageCacheFilter:init -
> {timeout=3600, excludeOwnerEditPages=false, size=400}
> INFO 2006-03-04 10:10:39,136 IfModifiedWeblogPageCacheFilter:init -
> Initializing if-modified cache
> INFO 2006-03-04 10:10:39,137 IfModifiedWeblogPageCacheFilter:init -
> {timeout=14400, size=1000}
> INFO 2006-03-04 10:10:39,144 IfModifiedFeedCacheFilter:init -
> Initializing if-modified feed cache
> INFO 2006-03-04 10:10:39,146 IfModifiedFeedCacheFilter:init -
> {timeout=14400, size=200}
> INFO 2006-03-04 10:10:39,150 PlanetCacheFilter:init - Initializing
> planet cache
> INFO 2006-03-04 10:10:39,152 PlanetCacheFilter:init - {timeout=1800,
> excludeOwnerEditPages=false, size=10}
> INFO 2006-03-04 10:10:39,176 ReferrerQueueManagerImpl:<init> -
> Initializing Referrer Queue Manager
> INFO 2006-03-04 10:10:39,177 ReferrerQueueManagerImpl:<init> -
> Asynchronous referrer processing = false
> WARN 2006-03-04 10:10:39,178 RollerImpl:shutdown -
> java.lang.NullPointerException
> INFO 2006-03-04 10:10:39,180 SessionFactoryImpl:close - closing
>
>
>
>
> --
> Kings are Earth's Gods: in vice their laws their will
> And if Jove stray, who dares say Jove doth ill? -Shakespeare
>
