Hi,
I'm experimenting with wso2 and mysql.
I suspect I found a bug in wso2 regarding db connection management.
I have a sequence with dblookup and dbreport mediators talking to an mysql
server.
I have a setup that kindof works. I proxy an inter face, log stuff in the
database etc.. all fine.
I notice that every night I leave the bus running, (processing _zero_
messages) the wso2 esb looses the connection to the mysql server... and in
the morning _no_ successfull dabase access can be done anymore.
wso2esb keeps giving exceptions. *Only restarting wso2esb helps.*
mysql is not down. running mysql query browser just works ok.
Its reproducible. I'm not sure after how much time this occurs.
( I saw it last week after runnign 1 day, saw it now where wso2 is idling
for about 48 hours).
*setup.*
wso2ewb on debian, mysql on localhost.
*version*
wso2web v1.7.1.
*error logs
*2008-09-28 20:14:33,476 [127.0.0.1-vloeki_v01] [HttpServerWorker-3] DEBUG
DBLookupMediator Start : DBLookup mediator
2008-09-28 20:14:33,476 [127.0.0.1-vloeki_v01] [HttpServerWorker-3] DEBUG
DBLookupMediator Getting a connection from DataSour
ce jdbc:mysql://localhost:3306/esb and preparing statement : select * from
customer c where token = '00000000-00';
2008-09-28 20:14:33,478 [127.0.0.1-vloeki_v01] [HttpServerWorker-3] DEBUG
DBLookupMediator Successfully prepared statement :
select * from customer c where token = '00000000-00'; against DataSource :
jdbc:mysql://localhost:3306/esb
2008-09-28 20:14:33,480 [127.0.0.1-vloeki_v01] [HttpServerWorker-3] ERROR
DBLookupMediator Error executing statement : select
* from customer c where token = '00000000-00'; against DataSource :
jdbc:mysql://localhost:3306/esb
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Broken pipe
STACKTRACE:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2637)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)
at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1268)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at
org.apache.synapse.mediators.db.DBLookupMediator.processStatement(DBLookupMediator.java:46)
at
org.apache.synapse.mediators.db.AbstractDBMediator.mediate(AbstractDBMediator.java:96)
at
org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:58)
at
org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:125)
at
org.apache.synapse.core.axis2.ProxyServiceMessageReceiver.receive(ProxyServiceMessageReceiver.java:149)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at
org.apache.synapse.transport.nhttp.ServerWorker.processPost(ServerWorker.java:253)
at
org.apache.synapse.transport.nhttp.ServerWorker.run(ServerWorker.java:194)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
** END NESTED EXCEPTION **
Last packet sent to the server was 1 ms ago.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2652)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)
at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1268)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at
org.apache.synapse.mediators.db.DBLookupMediator.processStatement(DBLookupMediator.java:46)
at
org.apache.synapse.mediators.db.AbstractDBMediator.mediate(AbstractDBMediator.java:96)
at
org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:58)
at
org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:125)
at
org.apache.synapse.core.axis2.ProxyServiceMessageReceiver.receive(ProxyServiceMessageReceiver.java:149)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
at
org.apache.synapse.transport.nhttp.ServerWorker.processPost(ServerWorker.java:253)
at
org.apache.synapse.transport.nhttp.ServerWorker.run(ServerWorker.java:194)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
2008-09-28 20:14:33,482 [127.0.0.1-vloeki_v01] [HttpServerWorker-3] WARN
ProxyServiceMessageReceiver Executing fault handler
due to exception encountered
*
*
_______________________________________________
Esb-java-user mailing list
[email protected]
http://mailman.wso2.org/cgi-bin/mailman/listinfo/esb-java-user
