nntp//rss fails to start

[cpminga]

hello all,

I'm having a problem getting nntp//rss to stay running. It'll start up and then just die after a few moments.

this is what i have in my log

Code: Select all

14:05:26,897 [main] INFO  Main - Starting nntp//rss v0.3
14:06:15,707 [main] ERROR Main - Exception thrown during startup
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Unexpected token: Unexpected token:  in statement
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:101)
   at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)
   at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
   at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:146)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at org.methodize.nntprss.rss.db.ChannelManagerDAO.initialize(ChannelManagerDAO.java:311)
   at org.methodize.nntprss.db.DBManager.configure(DBManager.java:125)
   at org.methodize.nntprss.Main.startNntpRss(Main.java:106)
   at org.methodize.nntprss.Main.main(Main.java:172)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.methodize.nntprss.Startup.run(Startup.java:104)
   at org.methodize.nntprss.Startup.main(Startup.java:66)

Caused by: java.sql.SQLException: Unexpected token: Unexpected token: in statement

at org.hsqldb.Trace.getError(Unknown Source)
   at org.hsqldb.Log.runScript(Unknown Source)
   at org.hsqldb.Log.open(Unknown Source)
   at org.hsqldb.Database$Logger.openLog(Unknown Source)
   at org.hsqldb.Database.open(Unknown Source)
   at org.hsqldb.Database.<init>(Unknown Source)
   at org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
   at org.hsqldb.jdbcConnection.<init>(Unknown Source)
   at org.hsqldb.jdbcDriver.connect(Unknown Source)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:95)
   ... 15 more

after that it just closes. It was running fine for at least a couple of weeks and then all of a sudden it started doing this. The only thing different about my system, that i can think of, is i just installed Red Hat on a partition of my hard drive. But that's on a different hard drive (i have two) and i can't remember if this started happening before or after i mounted the second drive where nntp//rss lives.

I'm running WinXP / Java 1.3.1 / nntp//rss 0.3

Any thoughts as to the source of the problem would be greatly appreciated. Thanks!

[jason]

Hi,

This problem is caused by a corrupt HSQLDB database - this is a very occasional scenario that can happen if nntp//rss is uncleanly terminated (e.g. machine powered off without clean shutdown).

To recover, perform the following steps:

1. Ensure that nntp//rss is not running
2. Take a backup of your database files - these are the files named nntprssdb.* within your nntp//rss directory.
3. Open the nntprssdb.script file within a text editor. You'll note that this is a series of SQL database instructions. Scroll to the bottom of this file - you'll see that the contents of the file is corrupt at point.
4. Remove the corrupt data from the bottom of the file back to the last valid SQL command.
5. Save the updated nntprssdb.script file
6. Restart nntp//rss - it will initialize the database, and should commence repolling.

Sorry for the inconvience - this is a known issue with the current release of HSQLDB, and I hope that the next release of HSQLDB will resolve this problem. In the interim, I have also added MySQL support to the forthcoming 0.4 release of nntp//rss, to other a greater range of database support.

[cpminga]

Excellent! Worked like a charm. Thanks so much!