That was the trouble!

I just ran <code> REPAIR TABLE: referer; <code> in MySQL and everything
is good again.

Brian



On Sat, 2006-04-01 at 18:32 -0500, Brian Blakeley wrote:
> I think I may have found something that could be causing my troubles.
> 
> It seems that my referer.MYI table me have been corrupted during my
> resent crash.
> 
> When I try to access it directly as follows:
> 
> SELECT * FROM referer;
> 
> I get the following response:
> 
> ERROR 1016 (HY000): Can't open file: "referer.MYI" (errno: 145)
> 
> I am going to try to reset the refers and see what happens.
> 
> 
> Brian
>  
> 
> On Sat, 2006-04-01 at 18:15 -0500, Brian Blakeley wrote:
> > Thanks Anil!
> > 
> > I am still having trouble and I am wondering if the <Realm
> > className="org.apache.catalina.realm..JDBCRealm: ... /> stuff is still
> > necessary for Roller 2.1?
> > 
> > Any thoughts?
> > 
> > 
> > brian
> > 
> > 
> > 
> > On Sat, 2006-04-01 at 12:48 -0800, Anil Gangolli wrote:
> > > For that stack trace, try the suggestions here:
> > > 
> > > http://rollerweblogger.org/wiki/Wiki.jsp?page=TomcatJDBCEmptyNull
> > > 
> > > --a.
> > > 
> > > 
> > > Brian Blakeley wrote:
> > > > Hi,
> > > >
> > > > Cheblogs.com has been experiencing the "blank page issue" all day and I
> > > > can not get things back to normal doing the following:
> > > >
> > > > cleared caches
> > > > removed the work directory
> > > > several restarts
> > > >
> > > > However the following is notable:
> > > >
> > > > the site rss feed is available and looks good
> > > > I can login into individual weblogs without issue
> > > >
> > > > Also when I hit http://www.cheblogs.com/ I get the page upto and
> > > > including the tabbedmenu.
> > > >
> > > > If I select either Che Blogs(recent entries) or Planet Che (Planet) I
> > > > get a completely white screen.
> > > >
> > > >
> > > > My backend system is Roller 2.1, Fedora 3 and Java 1.4.2_06-b03 with
> > > > Tomcat 5.0.30
> > > >
> > > > Thanks for any feedback.
> > > >
> > > >
> > > > Brian
> > > > ________________________________________________________________
> > > >
> > > > Roller.log stack:
> > > >
> > > >
> > > > ERROR 2006-04-01 10:28:20,846 JDBCException:<init> - Cannot open
> > > > connection
> > > > org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of
> > > > class '' for connect URL 'null'
> > > >         at org.apache.commons.dbcp.BasicDataSource.createDataSource
> > > > (BasicDataSource.java:780)
> > > >         at org.apache.commons.dbcp.BasicDataSource.getConnection
> > > > (BasicDataSource.java:540)
> > > >         at
> > > > net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection
> > > > (DatasourceConnectionProvider.java:59)
> > > >         at net.sf.hibernate.impl.BatcherImpl.openConnection
> > > > (BatcherImpl.java:278)
> > > >         at net.sf.hibernate.impl.SessionImpl.connect
> > > > (SessionImpl.java:3302)
> > > >         at net.sf.hibernate.impl.SessionImpl.connection
> > > > (SessionImpl.java:3282)
> > > >         at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement
> > > > (BatcherImpl.java:65)
> > > >         at net.sf.hibernate.loader.Loader.prepareQueryStatement
> > > > (Loader.java:704)
> > > >         at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
> > > >         at
> > > > net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections
> > > > (Loader.java:133)
> > > >         at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
> > > >         at net.sf.hibernate.loader.Loader.list(Loader.java:946)
> > > >         at net.sf.hibernate.loader.CriteriaLoader.list
> > > > (CriteriaLoader.java:121)
> > > >         at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3609)
> > > >         at net.sf.hibernate.impl.CriteriaImpl.list
> > > > (CriteriaImpl.java:238)
> > > >         at
> > > > org.roller.business.hibernate.HibernateConfigManagerImpl.getRollerConfig
> > > > (HibernateConfigManagerImpl.java:46)
> > > >         at org.roller.presentation.RollerContext.setupRollerConfig
> > > > (RollerContext.java:502)
> > > >         at org.roller.presentation.RollerContext.contextInitialized
> > > > (RollerContext.java:158)
> > > >         at org.apache.catalina.core.StandardContext.listenerStart
> > > > (StandardContext.java:3831)
> > > >         at org.apache.catalina.core.StandardContext.start
> > > > (StandardContext.java:4323)
> > > >         at org.apache.catalina.core.ContainerBase.addChildInternal
> > > > (ContainerBase.java:823)
> > > >         at org.apache.catalina.core.ContainerBase.addChild
> > > > (ContainerBase.java:807)
> > > >         at org.apache.catalina.core.StandardHost.addChild
> > > > (StandardHost.java:595)
> > > >         at org.apache.catalina.core.StandardHostDeployer.install
> > > > (StandardHostDeployer.java:277)
> > > >         at org.apache.catalina.core.StandardHost.install
> > > > (StandardHost.java:832)
> > > >         at org.apache.catalina.startup.HostConfig.deployDirectories
> > > > (HostConfig.java:701)
> > > >         at org.apache.catalina.startup.HostConfig.deployApps
> > > > (HostConfig.java:432)
> > > >         at org.apache.catalina.startup.HostConfig.start
> > > > (HostConfig.java:983)
> > > >         at org.apache.catalina.startup.HostConfig.lifecycleEvent
> > > > (HostConfig.java:349)
> > > >         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent
> > > > (LifecycleSupport.java:119)
> > > >         at org.apache.catalina.core.ContainerBase.start
> > > > (ContainerBase.java:1091)
> > > >         at org.apache.catalina.core.StandardHost.start
> > > > (StandardHost.java:789)
> > > >         at org.apache.catalina.core.ContainerBase.start
> > > > (ContainerBase.java:1083)
> > > >         at org.apache.catalina.core.StandardEngine.start
> > > > (StandardEngine.java:478)
> > > >         at org.apache.catalina.core.StandardService.start
> > > > (StandardService.java:480)
> > > >         at org.apache.catalina.core.StandardServer.start
> > > > (StandardServer.java:2313)
> > > >         at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
> > > >         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:324)
> > > >         at org.apache.catalina.startup.Bootstrap.start
> > > > (Bootstrap.java:287)
> > > >         at org.apache.catalina.startup.Bootstrap.main
> > > > (Bootstrap.java:425)
> > > > Caused by: java.sql.SQLException: No suitable driver
> > > >         at java.sql.DriverManager.getDriver(DriverManager.java:243)
> > > >         at org.apache.commons.dbcp.BasicDataSource.createDataSource
> > > > (BasicDataSource.java:773)
> > > >         ... 42 more
> > > > FATAL 2006-04-01 10:28:20,856 RollerContext:contextInitialized -
> > > > RollerContext initialization failed
> > > > org.roller.RollerException
> > > >         at
> > > > org.roller.business.hibernate.HibernateConfigManagerImpl.getRollerConfig
> > > > (HibernateConfigManagerImpl.java:51)
> > > >         at org.roller.presentation.RollerContext.setupRollerConfig
> > > > (RollerContext.java:502)
> > > >         at org.roller.presentation.RollerContext.contextInitialized
> > > > (RollerContext.java:158)
> > > >         at org.apache.catalina.core.StandardContext.listenerStart
> > > > (StandardContext.java:3831)
> > > >         at org.apache.catalina.core.StandardContext.start
> > > > (StandardContext.java:4323)
> > > >         at org.apache.catalina.core.ContainerBase.addChildInternal
> > > > (ContainerBase.java:823)
> > > >         at org.apache.catalina.core.ContainerBase.addChild
> > > > (ContainerBase.java:807)
> > > >         at org.apache.catalina.core.StandardHost.addChild
> > > > (StandardHost.java:595)
> > > >         at org.apache.catalina.core.StandardHostDeployer.install
> > > > (StandardHostDeployer.java:277)
> > > >         at org.apache.catalina.core.StandardHost.install
> > > > (StandardHost.java:832)
> > > >         at org.apache.catalina.startup.HostConfig.deployDirectories
> > > > (HostConfig.java:701)
> > > >         at org.apache.catalina.startup.HostConfig.deployApps
> > > > (HostConfig.java:432)
> > > >         at org.apache.catalina.startup.HostConfig.start
> > > > (HostConfig.java:983)
> > > >         at org.apache.catalina.startup.HostConfig.lifecycleEvent
> > > > (HostConfig.java:349)
> > > >         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent
> > > > (LifecycleSupport.java:119)
> > > >         at org.apache.catalina.core.ContainerBase.start
> > > > (ContainerBase.java:1091)
> > > >         at org.apache.catalina.core.StandardHost.start
> > > > (StandardHost.java:789)
> > > >         at org.apache.catalina.core.ContainerBase.start
> > > > (ContainerBase.java:1083)
> > > >         at org.apache.catalina.core.StandardEngine.start
> > > > (StandardEngine.java:478)
> > > >         at org.apache.catalina.core.StandardService.start
> > > > (StandardService.java:480)
> > > >         at org.apache.catalina.core.StandardServer.start
> > > > (StandardServer.java:2313)
> > > >         at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
> > > >         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:324)
> > > >         at org.apache.catalina.startup.Bootstrap.start
> > > > (Bootstrap.java:287)
> > > >         at org.apache.catalina.startup.Bootstrap.main
> > > > (Bootstrap.java:425)
> > > > --- ROOT CAUSE ---
> > > > net.sf.hibernate.JDBCException: Cannot open connection
> > > >         at net.sf.hibernate.impl.BatcherImpl.openConnection
> > > > (BatcherImpl.java:281)
> > > >         at net.sf.hibernate.impl.SessionImpl.connect
> > > > (SessionImpl.java:3302)
> > > >         at net.sf.hibernate.impl.SessionImpl.connection
> > > > (SessionImpl.java:3282)
> > > >         at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement
> > > > (BatcherImpl.java:65)
> > > >         at net.sf.hibernate.loader.Loader.prepareQueryStatement
> > > > (Loader.java:704)
> > > >         at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
> > > >         at
> > > > net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections
> > > > (Loader.java:133)
> > > >         at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
> > > >         at net.sf.hibernate.loader.Loader.list(Loader.java:946)
> > > >         at net.sf.hibernate.loader.CriteriaLoader.list
> > > > (CriteriaLoader.java:121)
> > > >         at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3609)
> > > >         at net.sf.hibernate.impl.CriteriaImpl.list
> > > > (CriteriaImpl.java:238)
> > > >         at
> > > > org.roller.business.hibernate.HibernateConfigManagerImpl.getRollerConfig
> > > > (HibernateConfigManagerImpl.java:46)
> > > >         at org.roller.presentation.RollerContext.setupRollerConfig
> > > > (RollerContext.java:502)
> > > >         at org.roller.presentation.RollerContext.contextInitialized
> > > > (RollerContext.java:158)
> > > >         at org.apache.catalina.core.StandardContext.listenerStart
> > > > (StandardContext.java:3831)
> > > >         at org.apache.catalina.core.StandardContext.start
> > > > (StandardContext.java:4323)
> > > >         at org.apache.catalina.core.ContainerBase.addChildInternal
> > > > (ContainerBase.java:823)
> > > >         at org.apache.catalina.core.ContainerBase.addChild
> > > > (ContainerBase.java:807)
> > > >         at org.apache.catalina.core.StandardHost.addChild
> > > > (StandardHost.java:595)
> > > >         at org.apache.catalina.core.StandardHostDeployer.install
> > > > (StandardHostDeployer.java:277)
> > > >         at org.apache.catalina.core.StandardHost.install
> > > > (StandardHost.java:832)
> > > >         at org.apache.catalina.startup.HostConfig.deployDirectories
> > > > (HostConfig.java:701)
> > > >         at org.apache.catalina.startup.HostConfig.deployApps
> > > > (HostConfig.java:432)
> > > >         at org.apache.catalina.startup.HostConfig.start
> > > > (HostConfig.java:983)
> > > >         at org.apache.catalina.startup.HostConfig.lifecycleEvent
> > > > (HostConfig.java:349)
> > > >         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent
> > > > (LifecycleSupport.java:119)
> > > >         at org.apache.catalina.core.ContainerBase.start
> > > > (ContainerBase.java:1091)
> > > >         at org.apache.catalina.core.StandardHost.start
> > > > (StandardHost.java:789)
> > > >         at org.apache.catalina.core.ContainerBase.start
> > > > (ContainerBase.java:1083)
> > > >         at org.apache.catalina.core.StandardEngine.start
> > > > (StandardEngine.java:478)
> > > >         at org.apache.catalina.core.StandardService.start
> > > > (StandardService.java:480)
> > > >         at org.apache.catalina.core.StandardServer.start
> > > > (StandardServer.java:2313)
> > > >         at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
> > > >         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:324)
> > > >         at org.apache.catalina.startup.Bootstrap.start
> > > > (Bootstrap.java:287)
> > > >         at org.apache.catalina.startup.Bootstrap.main
> > > > (Bootstrap.java:425)
> > > > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
> > > > JDBC driver of class '' for connect URL 'null'
> > > >         at org.apache.commons.dbcp.BasicDataSource.createDataSource
> > > > (BasicDataSource.java:780)
> > > >         at org.apache.commons.dbcp.BasicDataSource.getConnection
> > > > (BasicDataSource.java:540)
> > > >         at
> > > > net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection
> > > > (DatasourceConnectionProvider.java:59)
> > > >         at net.sf.hibernate.impl.BatcherImpl.openConnection
> > > > (BatcherImpl.java:278)
> > > >         ... 39 more
> > > > Caused by: java.sql.SQLException: No suitable driver
> > > >         at java.sql.DriverManager.getDriver(DriverManager.java:243)
> > > >         at org.apache.commons.dbcp.BasicDataSource.createDataSource
> > > > (BasicDataSource.java:773)
> > > >         ... 42 more
> > > > (END)
> > > >
> > > >
> > > >
> > > >   
> > > 
> > 
> 

Reply via email to