• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: mysql access exception after a long time
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: mysql access exception after a long time

  • Subject: Re: mysql access exception after a long time
  • From: Minh Thao Hoang <email@hidden>
  • Date: Fri, 19 Jul 2013 21:00:38 +0700

Hi,
This is a well known bug in MySQL driver. It happens after 8 hours of being idle.  Try not to use the driver 's default connection pool, use some altetnatives such as C3po.

Best of luck!

On 19 Jul 2013 20:33, "Pierre Gilquin" <email@hidden> wrote:
Hi

If mysql is not accessed by my app for a long period of time (around 8h), an exception is throwned.


Is there a setting that I can apply to my wonder-WO app or mysql to prevent this ?


Thanks in advance


Pierre


Jul 18 08:31:29 PSF[2016] DEBUG NSLog  - 1 row(s) processed
Jul 18 08:31:29 PSF[2016] DEBUG NSLog  -  === Commit Internal Transaction
JavaClient
Jul 18 18:36:35 PSF[2016] INFO  NSLog  - Welcome to session FOMXO0ymbVGulVBtCM4YvM
Jul 18 18:36:43 PSF[2016] DEBUG NSLog  -  === Begin Internal Transaction
Jul 18 18:36:43 PSF[2016] DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT t0.id, RTRIM(t0.nom), t0.ordre FROM psf_domaine t0" withBindings: >
Jul 18 18:36:43 PSF[2016] DEBUG NSLog  -  === Rollback Internal Transaction
Jul 18 18:36:43 PSF[2016] INFO  er.transaction.adaptor.Exceptions  - Database Exception occured: 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:1903)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2349)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2860)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
        at com.mysql.jdbc.Statement.execute(Statement.java:529)
        at com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:272)
        at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
        at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296)
        at com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.java:220)
        at com.webobjects.eoaccess.EODatabaseChannel._selectWithFetchSpecificationEditingContext(EODatabaseChannel.java:897)
        at com.webobjects.eoaccess.EODatabaseChannel.selectObjectsWithFetchSpecification(EODatabaseChannel.java:234)
        at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3055)
        at com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195)
        at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488)
        at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069)
        at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1215)
...


** END NESTED EXCEPTION **



Last packet sent to the server was 15 ms ago.at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2561)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2860)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.Statement.execute(Statement.java:529)
at com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:272)
at com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
at com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296)
at com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.java:220)
at com.webobjects.eoaccess.EODatabaseChannel._selectWithFetchSpecificationEditingContext(EODatabaseChannel.java:897)
at com.webobjects.eoaccess.EODatabaseChannel.selectObjectsWithFetchSpecification(EODatabaseChannel.java:234)
at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3055)
at com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195)
at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488)
at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069)
at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1215)
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden.com)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: mysql access exception after a long time
      • From: Ramsey Gurley <email@hidden>
    • Re: mysql access exception after a long time
      • From: Pierre Gilquin <email@hidden>
References: 
 >mysql access exception after a long time (From: Pierre Gilquin <email@hidden>)

  • Prev by Date: How to make entity properties unique?
  • Next by Date: Re: mysql access exception after a long time
  • Previous by thread: mysql access exception after a long time
  • Next by thread: Re: mysql access exception after a long time
  • Index(es):
    • Date
    • Thread