Database... Problems

Maykel · January 12, 2008, 7:08am

Exception:

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error: ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException
MESSAGE: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. STACKTRACE: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997)
     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411)
     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)
     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
     at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
     at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
     at org.jivesoftware.database.ProfiledConnection$TimedPreparedStatement.executeQuery(ProfiledConnection.java:780)
     at com.jivesoftware.xmpp.workgroup.search.ChatSearchManager.rebuildIndex(ChatSearchManager.java:711)
     at com.jivesoftware.xmpp.workgroup.search.ChatSearchManager.rebuildIndex(ChatSearchManager.java:444)
     at com.jivesoftware.xmpp.workgroup.search.ChatSearchManager.updateIndex(ChatSearchManager.java:462)
     at com.jivesoftware.xmpp.workgroup.WorkgroupManager$5.run(WorkgroupManager.java:532)
     at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
     at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
     at java.util.concurrent.FutureTask.run(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. STACKTRACE: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException
MESSAGE: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. STACKTRACE: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997)
     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411)
     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)
     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
     at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
     at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
     at org.jivesoftware.database.ProfiledConnection$TimedPreparedStatement.executeQuery(ProfiledConnection.java:780)
     at com.jivesoftware.xmpp.workgroup.search.ChatSearchManager.rebuildIndex(ChatSearchManager.java:711)
     at com.jivesoftware.xmpp.workgroup.search.ChatSearchManager.rebuildIndex(ChatSearchManager.java:444)
     at com.jivesoftware.xmpp.workgroup.search.ChatSearchManager.updateIndex(ChatSearchManager.java:462)
     at com.jivesoftware.xmpp.workgroup.WorkgroupManager$5.run(WorkgroupManager.java:532)
     at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
     at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
     at java.util.concurrent.FutureTask.run(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago.
     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2622)
     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)
     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
     at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
     at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
     at org.jivesoftware.database.ProfiledConnection$TimedPreparedStatement.executeQuery(ProfiledConnection.java:780)
     at com.jivesoftware.xmpp.workgroup.search.ChatSearchManager.rebuildIndex(ChatSearchManager.java:711)
     at com.jivesoftware.xmpp.workgroup.search.ChatSearchManager.rebuildIndex(ChatSearchManager.java:444)
     at com.jivesoftware.xmpp.workgroup.search.ChatSearchManager.updateIndex(ChatSearchManager.java:462)
     at com.jivesoftware.xmpp.workgroup.WorkgroupManager$5.run(WorkgroupManager.java:532)
     at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
     at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
     at java.util.concurrent.FutureTask.run(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION **      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
     at com.mysql.jdbc.Connection.checkClosed(Connection.java:1932)
     at com.mysql.jdbc.Connection.getMetaData(Connection.java:3724)
     at org.jivesoftware.database.AbstractConnection.getMetaData(AbstractConnection.java:72)
     at org.jivesoftware.database.AbstractConnection.getMetaData(AbstractConnection.java:72)
     at org.jivesoftware.openfire.admin.server_002ddb_jsp._jspService(server_002ddb_jsp.java:72)
     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
     at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
     at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
     at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:65)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:41)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)
     at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
     at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
     at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
     at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
     at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
     at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
     at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:211)
     at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
     at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
     at org.mortbay.jetty.Server.handle(Server.java:313)
     at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
     at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:830)
     at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)
     at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
     at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
     at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
     at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)

that happend some time when i click Server - Server Manager - Database… and some time when I click the users/group i don’t see no users i

have to click like 4 time to see… how can i fix this problem…

Database Informations:

Database and Version:

MySQL

5.0.45

JDBC Driver:

MySQL-AB JDBC Driver

JDBC Driver Version:

mysql-connector-java-5.0.8 ( Revision: ${svn.Revision} )

DB Connection URL:

jdbc:mysql://localhost:3306/messenger

DB User:

msn@localhost

Transaction Support:

Yes

Transaction Isolation Level:

TRANSACTION_READ_COMMITTED

Supports multiple connections

open at once:

Yes

In read-only mode:

No

|

LG1 · January 14, 2008, 9:59pm

Hi,

are you using the current Openfire version?

It may help to downgrade the mysql driver to an older version or to set mysql timeout parameters.

Openfire allows to set the “database.defaultProvider.connectionTimeout” parameter but I wonder if you need to set it or to which value.

LG