dbloopup gives com.mysql.jdbc.CommunicationsException  after idling a night
---------------------------------------------------------------------------

                 Key: SYNAPSE-456
                 URL: https://issues.apache.org/jira/browse/SYNAPSE-456
             Project: Synapse
          Issue Type: Bug
    Affects Versions: 1.2
         Environment: debian on xen VM, mysql running on same host as wso2esb.

versions:
wso2esb v1.7.1
mysql 5.0
libmysql-java 5.0.4+dfsg-2 
            Reporter: harm verhagen


I have a wso2 sequence  with dblookup/dbreport mediators.
Basically every soap call is stored in the database.

Every morning, the wso2esb bus is in a state it doesn't process any messages 
anymore due to database access problems.
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


During the night the bus is typically idle (zero messages).
The database is _not_ down. mysql query browser is working just fine.


full report & error on
http://wso2.org/mailarchive/esb-java-user/2008-September/000897.html



-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to