Re: Install feedback/errors

Tue, 07 Mar 2006 13:40:19 -0800 

This one is now ROL-1076, marked fix-for 2.2.
http://opensource2.atlassian.com/projects/roller/browse/ROL-1076

- Dave



On Mar 4, 2006, at 1:08 PM, Matt Raible wrote:


Dave - I doubt I'll be bitten by this since I'm running a 3.x version
of MySQL.  However, it seems like a good reason to repackage and
re-release.

Matt

On 3/4/06, Vincent <[EMAIL PROTECTED]> wrote:

Figured it out, long story short : don't use quotes when defining a
default value for a Mysql BIT field (in version 5.0.18 anyway).

I put a corrected script on my wiki:

http://www.ghettojava.com/JSPWiki/Wiki.jsp?page=MysqlUpgradeScript

Matt Raible wrote:

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.getCom monPingTargets(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.getCom monPingTargets(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.executeQuer y(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.getWeblogE ntries(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.getWeblogE ntries(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.executeQuer y(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




--
Kings are Earth's Gods: in vice their laws their will
And if Jove stray, who dares say Jove doth ill? -Shakespeare

Reply via email to