23 Sep
2005
23 Sep
'05
11:03 p.m.
While trying to upgrade an XWiki installation from 0.9.793 to 0.9.840 I
face a MySQL connection problem.
My server config:
=======
MySQL 4.1.12
Tomcat 5.5.9
JDK 1.5
Mandrake Linux virtual server kernel 2.6.9-vs1.9.3
XWiki runs in non virtual mode
URL: http://www.edos-project.org
======
XWiki 0.9.793 works perfectly on that server since a while. When trying
to run the 0.9.840 version with the same Hibernate and XWiki
configuration files, I get the exception below. MySQL "skip-networking"
option is correctly set in /etc/my.cnf. I noticed that the error appears
in some of previous XWiki build reports such as this one:
http://build.xpertnet.biz/cc/buildresults/xwiki?log=log20050628171819Lbuild…
Any hint is welcome!
Note: getting a simple connection to MySQL with the lines below works
perfectly fine on the server.
======================
String url = "jdbc:mysql://localhost/xwiki";
String username = "xwiki";
String password = "passwd";
Connection conn = DriverManager.getConnection(url, username, password);
======================
Exception when running XWiki webapp:
21:32:16,675 WARN http-80-Processor25 http://www.edos-project.org/xwiki/
Configurator:configure:126 - No configuration found. Configuring ehcache
from ehcache-failsafe.xml found in the classpath:
jar:file:/usr/local/tomcat/jakarta-tomcat-5.5.9/webapps/xwiki/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
21:32:21,112 WARN http-80-Processor25 http://www.edos-project.org/xwiki/
JDBCExceptionReporter:logExceptions:71 - SQL Error: 0, SQLState: 08S01
21:32:21,113 ERROR http-80-Processor25
http://www.edos-project.org/xwiki/
JDBCExceptionReporter:logExceptions:72 - 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:1842)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1347)
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:958)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1239)
at org.hibernate.loader.Loader.doQuery(Loader.java:374)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
at org.hibernate.loader.Loader.doList(Loader.java:1562)
at org.hibernate.loader.Loader.list(Loader.java:1545)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
============================
--
Stéphane Laurière
slauriere(a)mandriva.com
Mandriva Club - http://club.mandriva.com
Mandrakesoft becomes Mandriva!