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
