You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@openjpa.apache.org by "seba.wagner@gmail.com" <se...@gmail.com> on 2012/06/12 16:38:11 UTC

MySQL Broken Pipe and timeout issue

Hi,

after checking some of our logs I did found some Exception like:
Operation Broken Pipe, last Packet send 52.xxx seconds ....

Is there a Ping that you can configure in OpenJPA so that OpenJPA
keeps the DB connection active?

We are using OpenJPA integrated into Spring with:
org.springframework.orm.jpa.JpaTransactionManager

This is our openJPA/Spring configuration:
https://svn.apache.org/viewvc/incubator/openmeetings/trunk/singlewebapp/WebContent/WEB-INF/openmeetings-applicationContext.xml?view=markup

Is there are way either in the persistence.xml or Spring config for
the transactionManager?
Something like "keepAlivePingTime" or comparable?

Thanks!
Sebastian
-- 
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com

Re: MySQL Broken Pipe and timeout issue

Posted by "seba.wagner@gmail.com" <se...@gmail.com>.

Hi Rick,

we are not actively setting tcpKeepAlive to false so it should be
already true by default.
But we will try out.

Thanks!
Sebastian

2012/6/12 Rick Curtis <cu...@gmail.com>:
> Sebastian -
>
> I'm not aware of anything from an OpenJPA configuration point of view. Have
> you looked at the MySQL driver documentation[1]? Perhaps the
> tcpKeepAlive property
> will solve your problem.
>
> [1]
> http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
>
> Thanks,
> Rick
>
> On Tue, Jun 12, 2012 at 9:38 AM, seba.wagner@gmail.com <
> seba.wagner@gmail.com> wrote:
>
>> Hi,
>>
>> after checking some of our logs I did found some Exception like:
>> Operation Broken Pipe, last Packet send 52.xxx seconds ....
>>
>> Is there a Ping that you can configure in OpenJPA so that OpenJPA
>> keeps the DB connection active?
>>
>> We are using OpenJPA integrated into Spring with:
>> org.springframework.orm.jpa.JpaTransactionManager
>>
>> This is our openJPA/Spring configuration:
>>
>> https://svn.apache.org/viewvc/incubator/openmeetings/trunk/singlewebapp/WebContent/WEB-INF/openmeetings-applicationContext.xml?view=markup
>>
>> Is there are way either in the persistence.xml or Spring config for
>> the transactionManager?
>> Something like "keepAlivePingTime" or comparable?
>>
>> Thanks!
>> Sebastian
>> --
>> Sebastian Wagner
>> https://twitter.com/#!/dead_lock
>> http://www.openmeetings.de
>> http://www.webbase-design.de
>> http://www.wagner-sebastian.com
>> seba.wagner@gmail.com
>>
>
>
>
> --
> *Rick Curtis*



-- 
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com

Re: MySQL Broken Pipe and timeout issue

Posted by Rick Curtis <cu...@gmail.com>.

Sebastian -

I'm not aware of anything from an OpenJPA configuration point of view. Have
you looked at the MySQL driver documentation[1]? Perhaps the
tcpKeepAlive property
will solve your problem.

[1]
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html

Thanks,
Rick

On Tue, Jun 12, 2012 at 9:38 AM, seba.wagner@gmail.com <
seba.wagner@gmail.com> wrote:

> Hi,
>
> after checking some of our logs I did found some Exception like:
> Operation Broken Pipe, last Packet send 52.xxx seconds ....
>
> Is there a Ping that you can configure in OpenJPA so that OpenJPA
> keeps the DB connection active?
>
> We are using OpenJPA integrated into Spring with:
> org.springframework.orm.jpa.JpaTransactionManager
>
> This is our openJPA/Spring configuration:
>
> https://svn.apache.org/viewvc/incubator/openmeetings/trunk/singlewebapp/WebContent/WEB-INF/openmeetings-applicationContext.xml?view=markup
>
> Is there are way either in the persistence.xml or Spring config for
> the transactionManager?
> Something like "keepAlivePingTime" or comparable?
>
> Thanks!
> Sebastian
> --
> Sebastian Wagner
> https://twitter.com/#!/dead_lock
> http://www.openmeetings.de
> http://www.webbase-design.de
> http://www.wagner-sebastian.com
> seba.wagner@gmail.com
>



-- 
*Rick Curtis*