The major outstanding bug in Sightings.biz is a database connection pooling problem that causes the following message to be displayed:
javax.servlet.ServletException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream ** BEGIN NESTED EXCEPTION ** java.io.IOException MESSAGE: Unexpected end of input stream STACKTRACE: java.io.IOException: Unexpected end of input stream at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1405) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1775) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1070) <snip/>
The problem isn’t usually serious. Repeating whatever you were doing a couple more times will usually get through the problem. I have been trying to fix this for ages, but it is an absolute bastard to track. Occasionally, this problem will cause the site to run out of database connections and the site will hang :(. If you suspect this has happened, email matt at madeye dot com.
Just as a postscript to this report, this problem is related to database connections going stale. If enough people use the site, the connections will not go stale, and this problems will just go away :D