nntp//rss fails to start, in a different way

General discussion about nntp//rss.

nntp//rss fails to start, in a different way

Postby mk on Tue Dec 09, 2003 7:07 am

I've been using (and promoting!) nntp//rss along with JNT for a few months, but now it won't start, either as a service or from the command-line. The main thing that has changed is that I backed up my old system and restored it onto another disk. The rest of my applications are working but now I get this in the nntp//rss log.

Code: Select all
22:40:37,843 [main] INFO  Main - Starting nntp//rss v0.3
22:40:44,312 [main] ERROR Main - Exception thrown during startup
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: User not found: SA
   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: User not found: SA
   at org.hsqldb.Trace.getError(Unknown Source)
   at org.hsqldb.Trace.error(Unknown Source)
   at org.hsqldb.UserManager.get(Unknown Source)
   at org.hsqldb.UserManager.getUser(Unknown Source)
   at org.hsqldb.Database.connect(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


Can anyone help?
mk
 
Posts: 2
Joined: Tue Dec 09, 2003 6:53 am

Postby jason on Tue Dec 09, 2003 3:33 pm

It looks like something has happened to the hsqldb database used by nntp//rss (contained within the nntprssdb.* files). Let me check with that project to see what workarounds exist.

Jason
jason
Site Admin
 
Posts: 114
Joined: Sat May 03, 2003 10:44 pm
Location: West Orange, NJ

follow-up question about backups and database corruption

Postby mk on Fri Dec 12, 2003 6:41 am

I looked at the HSQL forum on Sourceforge myself, and this thread looked like it discussed my problem.
http://sourceforge.net/forum/forum.php?thread_id=980501&forum_id=73674

That made me think that my database must have gotten corrupted, and I started thinking how it could have happened. After all, I had been using nntprss for months without a problem. Then it hit me, nntprss runs as a service, and I didn't stop the service when I did the backup, so the database files must have been saved in an inconsistent state when I did my backup.

Does my hypothesis make sense to you?

If so, then I would think anyone running nntprss should stop it before doing a backup, and restart it once the backup has completed. True?
mk
 
Posts: 2
Joined: Tue Dec 09, 2003 6:53 am

Postby jason on Fri Dec 12, 2003 12:29 pm

mk - I think that is a good hypothesis. I've had some trouble before with hsqldb after an OS crash. It left the nntprssdb.script file corrupted and prevented nntp//rss from restarting. This required me to manually truncate the script file.

I would definitely recommend, when backing up nntp//rss, that you stop the process before saving a copy of the files.
jason
Site Admin
 
Posts: 114
Joined: Sat May 03, 2003 10:44 pm
Location: West Orange, NJ


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron