Error with database conversion

What? There's a problem? Post a message here and we'll try to get it resolved!

Error with database conversion

Postby DasFreak on Sun Mar 13, 2005 5:01 am

Using version v0.5-beta-1 using Fedora FC3 and Java 1.4.2. Followed instructions for upgrading from 0.3. I copied over the nntprssdb.* files as per instructions from README.TXT.
Most of it goes OK until a certain article. Restarting nntp-rss resolved the issue but I have a feeling not all the posts were correctly imported.

Code: Select all
15:48:50,898 [main] FATAL ChannelDAO - Migration failed: Exception thrown while trying to save item {Item articleNumber=737 signature=BXXrrdQDJ4Q0ZQa9YVyBog== title=Monday, Obviously link=http://the.taoofmac.com/space/blog/2005-01-31 date=2005-02-01 12:40:22.032 comments= creator=null channel=com.taoofmac guid=null guidIsPermaLink=true description=<h2>Monday, Obviously</h2>
<p>Some medical issues. Managed to notice the <a href <length=3103>} in channel {Channel author=The Tao of Mac url=http://the.taoofmac.com/space/RecentChanges?format=rss id=15 title=The Tao of Mac link=http://the.taoofmac.com/space description=Tech Made Simple lastPolled=null lastCleaned=null lastModified=0 (Thu Jan 01 10:00:00 EST 1970) lastETag=null rssVersion=2.0 managingEditor=null lastArticleNumber=915 expiration=-1 enabled=true parseAtAllCost=false}
java.lang.RuntimeException: SQL Exception: Java exception: ': java.lang.OutOfMemoryError'.
        at org.methodize.nntprss.feed.db.JdbcChannelDAO.saveItem(JdbcChannelDAO.java:1133)
        at org.methodize.nntprss.feed.db.ChannelDAO.migrateHsql(ChannelDAO.java:345)
        at org.methodize.nntprss.feed.db.DerbyChannelDAO.populateInitialChannels(DerbyChannelDAO.java:214)
        at org.methodize.nntprss.feed.db.JdbcChannelDAO.initialize(JdbcChannelDAO.java:506)
        at org.methodize.nntprss.db.DBManager.configure(DBManager.java:56)
        at org.methodize.nntprss.Main.startNntpRss(Main.java:132)
        at org.methodize.nntprss.Main.main(Main.java:201)
        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.methodize.nntprss.Startup.run(Startup.java:116)
        at org.methodize.nntprss.Startup.main(Startup.java:74)

Caused by: SQL Exception: Java exception: ': java.lang.OutOfMemoryError'.
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
        at org.apache.derby.impl.jdbc.Util.javaException(Util.java)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:207)
        at org.methodize.nntprss.feed.db.JdbcChannelDAO.saveItem(JdbcChannelDAO.java:1110)
        ... 12 more
[/code]
DasFreak
 
Posts: 3
Joined: Sun Mar 13, 2005 4:53 am

Re: Error with database conversion

Postby jason on Tue Mar 15, 2005 3:46 am

DasFreak wrote:Using version v0.5-beta-1 using Fedora FC3 and Java 1.4.2. Followed instructions for upgrading from 0.3. I copied over the nntprssdb.* files as per instructions from README.TXT.
Most of it goes OK until a certain article. Restarting nntp-rss resolved the issue but I have a feeling not all the posts were correctly imported.


Here's the key message:

DasFreak wrote:
Code: Select all
java.lang.RuntimeException: SQL Exception: Java exception: ': java.lang.OutOfMemoryError'.


It looks like the Java process ran out of memory during the database conversion. You're correct in your assumption that, after restarting nntp//rss, you probably only got a subset of the articles from your original database.

Try this:

1. Unpack a new copy of nntp//rss v0.5b1 - copy over the old database files (as described instructions in the readme).
2. Use the following command to run nntp//rss the first time, instead of that in the docs:

java -Xmx128M -jar nntprss-start.jar

The -Xmx128M will tell the Java Virtual Machine to use up to 128MB of memory. By default it uses up to a maximum of 64MB. This should allow the migration process to complete without the OutOfMemoryException. In the odd case that it still throws the exception, try increasing the value of the -Xmx parameter.

After the migration process has completed, shutdown and restart nntp//rss.
jason
Site Admin
 
Posts: 114
Joined: Sat May 03, 2003 10:44 pm
Location: West Orange, NJ

Re: Error with database conversion

Postby DasFreak on Wed Mar 16, 2005 1:52 am

Thanks that seemed to do the job. I've another issue which wil come in seperate post
DasFreak
 
Posts: 3
Joined: Sun Mar 13, 2005 4:53 am


Return to Bug Reports

Who is online

Users browsing this forum: No registered users and 1 guest

cron