Alek,

Thanks for the heads-up.

Jason

----- Original Message -----
From: "Aleksander Slominski" <aslom@...>
To: <nntprss@yahoogroups.com>
Sent: Wednesday, April 07, 2004 3:19 PM
Subject: MySQL errno: 145 [Re: release scheduled for next month [Re:
[nntprss] Atom?]


> after 2 weeks it worked very very well weith MySQL however if you see
> this strange message:
> java.lang.RuntimeException: java.sql.SQLException: General error,
> message from server: "Can't open file: 'channels.MYI'. (errno: 145)"
>
> and in logs you have something like that:
>
> 14:00:18,154 [Channel Poll Worker #1] WARN Channel -
> Channel=ws.darkwolf - Exception while polling channel
> java.lang.RuntimeException: java.sql.SQLException: General error,
> message from server: "Can't open file: 'channels.MYI'. (errno: 145)"
> at
>
org.methodize.nntprss.feed.db.JdbcChannelDAO.updateChannel(JdbcChannelDAO.ja
va:669)
> at org.methodize.nntprss.feed.Channel.poll(Channel.java:467)
> at org.methodize.nntprss.feed.Channel.run(Channel.java:755)
> at
>
org.methodize.nntprss.util.FixedThreadPool$WorkerThread.run(FixedThreadPool.
java:92)
> Caused by: java.sql.SQLException: General error, message from server:
> "Can't open file: 'channels.MYI'. (errno: 145)"
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1876)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1098)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1192)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2051)
> at
>
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680)
> at
>
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527)
> at
>
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:207)
> at
>
org.methodize.nntprss.feed.db.JdbcChannelDAO.updateChannel(JdbcChannelDAO.ja
va:666)
> ... 3 more
> 14:00:18,154 [Channel Poll Worker #1] INFO Channel - Finished polling
> channel ws.darkwolf
>
> then it means that one of MySQL tables got corrupted - simply way to fix
> it is to use MySQL Control Center and right click on table (in this case
> channels) and select Repair.
>
> HTH,
>
> alek
>
> Aleksander Slominski wrote:
>
> >Jason Brome wrote:
> >
> >
> >
> >>otherwise it will be part of a formal (long overdue!) nntp//rss
> >>release scheduled for next month.
> >>
> >>
> >>
> >>
> >i am using version form cvs (with some minor tweaks that i think Jason
> >is about to add to CVS) and it works just great with MySQL storage
> >engine. i have over 150 feeds monitored and in 0.3 (when using HSQLDB)
> >it required 250M of memory no in 0.4 it is just 30M for whole java
process!
> >
> >i think that current nttprss version is almost ready to be released (as
> >1.0?) with current feature set after having few weeks for beta period to
> >stabilized and harden it.
> >
> >thanks,
> >
> >alek
> >
> >
> >
>
>
> --
> The best way to predict the future is to invent it - Alan Kay
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>