Connection issue with diffrent database machine

Openfire Openfire Support
1

hi

i’'m facing some problem when connecting to diffrent database machine. sometimes i can connect to wildfire, and sometime cannot. i think my configuration during the setup database have no problem, because i can register a new user. after idle for a while. user cannot login again. and on my admin database page have this error :

Exception: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) at com.mysql.jdbc.Connection.execSQL(Connection.java:2917) at com.mysql.jdbc.Statement.executeQuery(Statement.java:824) at com.mysql.jdbc.DatabaseMetaData.getUserName(DatabaseMetaData.java:5982) at org.jivesoftware.wildfire.admin.server_002ddb_jsp._jspService(server_002ddb_jsp .java:106) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:822) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813) at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:43) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813) at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813) at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:494) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624) at org.mortbay.http.HttpContext.handle(HttpContext.java:1434) at org.mortbay.http.HttpServer.service(HttpServer.java:896) at org.mortbay.http.HttpConnection.service(HttpConnection.java:814) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) ** END NESTED EXCEPTION ** Last packet sent to the server was 1 ms ago. at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) at com.mysql.jdbc.Connection.execSQL(Connection.java:2917) at com.mysql.jdbc.Statement.executeQuery(Statement.java:824) at com.mysql.jdbc.DatabaseMetaData.getUserName(DatabaseMetaData.java:5982) at org.jivesoftware.wildfire.admin.server_002ddb_jsp._jspService(server_002ddb_jsp .java:106) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:822)

OS/Dist: RedHat Enterprise Linux 3 (U7)

MySQL: 4.0.20

Fresh installation.

my connection to database : jdbc:mysql://192.156.56:3306/JABBERDB

JDBC Driver: MySQL-AB JDBC Driver

Not sure what else to say. ;D Plenty of memory, disk space, processing power, that sort of stuff.

can anyone plz help…

2

Hi,

do you have a firewall between both servers which is closing more or less active connections? Or which limits the maximum connection life time?

LG

3

this is my problem to… did you get a solution?

thanks,

-eric

4

I had a quick look on mySql forums, and it seems this is a fairly frequent issue, heres a link with a similiar problem.

Perhaps its time to try another database driver or upgrade the driver if possible!

Not much good I know, but I wonder if its really a Wildfire specific issue. Anyways it might be worth a more detailed look on the mysql site.

Conor

Message was edited by: Conor

5

Hi Conor,

it really seems to be a common MySQL problem. I did post a link to a possible solution in http://www.jivesoftware.org/community/thread.jspa?threadID=20017 but this requires building the driver from source.

I wonder if you want to patch your MySQL 3.1.12 driver as described in:

http://bugs.mysql.com/bug.php?id=14938 and http://lists.mysql.com/commits/1884

Maybe the 5.0.0-beta driver solves this problem.

Both options should be tested on a test server and not in production.

LG

6

Some changes on the mysql forum really helped:

http://forums.mysql.com/read.php?39,16257,90746#msg-90746

suggests changing my.cnf

wait_timeout=500

and ?autoReconnect=true to the JDBC driver url

Now I’'m only having an issue about 1% of the time, much better than 50%

Thanks,

-Eric