Hi Nashry, did you enable the autoReconnect to true by defining connection string in master datasource xml in following way?
jdbc:mysql://10.3.24.96:3306/master?autoReconnect=true Thanks On Tue, Aug 4, 2015 at 11:26 AM, Aaquibah Nashry <nas...@wso2.com> wrote: > Hi, > > i get the following error logs when I am trying to run a scheduled task in > the ESB. > What could be the reason? What can i do to overcome this? > > TID: [0] [ESB] [2015-08-04 00:00:36,958] INFO > {org.apache.synapse.mediators.builtin.LogMediator} - To: > http://www.w3.org/2005/08/addressing/anonymous, WSAction: , SOAPAction: , > MessageID: urn:uuid:6cba9ade-1456-42bf-bca9-e0c2110fed2c, Direction: > request, STATE = LEADQ {org.apache.synapse.mediators.builtin.LogMediator} > TID: [0] [ESB] [2015-08-04 00:00:38,318] ERROR > {org.apache.synapse.mediators.db.DBReportMediator} - Error execuring > insert statement : > INSERT INTO quarterlyleads > (Region, count, RecordDate) VALUES (?, ?, ?) against DataSource : > jdbc:mysql://localhost:3306/sf > {org.apache.synapse.mediators.db.DBReportMediator} > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet > successfully received from the server was 62,995,899 milliseconds ago. The > last packet sent successfully to the server was 62,995,908 milliseconds > ago. is longer than the server configured value of 'wait_timeout'. You > should consider either expiring and/or testing connection validity before > use in your application, increasing the server configured values for client > timeouts, or using the Connector/J connection property 'autoReconnect=true' > to avoid this problem. > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:534) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:408) > at > com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1137) > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3965) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2578) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2826) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) > at > org.apache.synapse.mediators.db.DBReportMediator.processStatement(DBReportMediator.java:55) > at > org.apache.synapse.mediators.db.AbstractDBMediator.mediate(AbstractDBMediator.java:143) > at > org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77) > at > org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:47) > at > org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:131) > at org.apache.synapse.mediators.eip.Target.mediate(Target.java:106) > at > org.apache.synapse.mediators.eip.splitter.IterateMediator.mediate(IterateMediator.java:146) > at > org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77) > at > org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:255) > at > org.apache.synapse.core.axis2.Axis2SynapseEnvironment.mediateFromContinuationStateStack(Axis2SynapseEnvironment.java:556) > at > org.apache.synapse.core.axis2.Axis2SynapseEnvironment.injectMessage(Axis2SynapseEnvironment.java:198) > at > org.apache.synapse.core.axis2.SynapseCallbackReceiver.handleMessage(SynapseCallbackReceiver.java:488) > at > org.apache.synapse.core.axis2.SynapseCallbackReceiver.receive(SynapseCallbackReceiver.java:170) > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) > at > org.apache.synapse.transport.passthru.ClientWorker.run(ClientWorker.java:225) > at > org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:701) > Caused by: java.net.SocketException: Broken pipe > at java.net.SocketOutputStream.socketWrite0(Native Method) > at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109) > at java.net.SocketOutputStream.write(SocketOutputStream.java:153) > at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) > at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) > at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3946) > ... 29 more > TID: [0] [ESB] [2015-08-04 00:00:38,331] ERROR > {org.apache.synapse.core.axis2.SynapseCallbackReceiver} - Synapse > encountered an exception, No error handlers found - [Message Dropped] > Error execuring insert statement : > INSERT INTO quarterlyleads > (Region, count, RecordDate) VALUES (?, ?, ?) against DataSource : > jdbc:mysql://localhost:3306/sf > {org.apache.synapse.core.axis2.SynapseCallbackReceiver} > > > Thanks in advance > > Regards, > > M.R.Aaquibah Nashry > *Intern, Engineering**| **WSO2, Inc.* > Mobile : +94 773946123 > Tel : +94 112662541 > Email : nas...@wso2.com <nas...@wso2.com> > > _______________________________________________ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Lakshman Udayakantha WSO2 Inc. www.wso2.com lean.enterprise.middleware Mobile: *0711241005*
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev