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