Postgres : Lost connexion with my Postgres Database while an EntitySync

[Zaoui Bruno]

Hello,

 

When I synchronize lot of data by EntitySync, the remote server after a
while, lost his connexion to the database (see logs at the end of the
mail).

 

I've tried to increase the pool-maxsize of the entityengine.xml file but
I keep my problem.

 

Could you please explain me what could happen?

 

Should I change the postgres configuration?

 

My config :

Postgres 8.0.1 under Linux Debian

 

I use

org.ofbiz.service.rmi.socket.zip.CompressionClientSocketFactory and
org.ofbiz.service.rmi.socket.zip.CompressionServerSocketFactory

 

entityengine.xml :

        <inline-jdbc

                jdbc-driver="org.postgresql.Driver"

                jdbc-uri="jdbc:postgresql://xxx.xxx.xxx.xxx:5432/TOTO"

                jdbc-username="toto"

                jdbc-password="toto"

                isolation-level="ReadCommitted"

                pool-minsize="2"

                pool-maxsize="100"/>

 

 

1036559051[  ConnectionFactory.java:54 :ERROR] ******* ERROR: No
database connection found for helperName "localpostgres"

1036559052[       SequenceUtil.java:283:ERROR]

---- exception report
----------------------------------------------------------

General error in getting a sequenced ID

Exception: org.ofbiz.entity.GenericEntityException

Message: [SequenceUtil.SequenceBank.fillBank]: Unable to esablish a
connection with the database, connection was null...

---- stack trace
---------------------------------------------------------------

org.ofbiz.entity.GenericEntityException:
[SequenceUtil.SequenceBank.fillBank]: Unable to esablish a connection
with the database, connection was null...

org.ofbiz.entity.util.SequenceUtil$SequenceBank.fillBank(SequenceUtil.ja
va:187)

org.ofbiz.entity.util.SequenceUtil$SequenceBank.getNextSeqId(SequenceUti
l.java:135)

org.ofbiz.entity.util.SequenceUtil.getNextSeqId(SequenceUtil.java:99)

org.ofbiz.entity.GenericDelegator.getNextSeqIdLong(GenericDelegator.java
:2643)

org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:257
9)

org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:256
3)

org.ofbiz.entity.GenericDelegator.saveEntitySyncRemoveInfo(GenericDelega
tor.java:687)

org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:841)

org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:808)

org.ofbiz.entityext.synchronization.EntitySyncServices.storeEntitySyncDa
ta(EntitySyncServices.java:359)

sun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

java.lang.reflect.Method.invoke(Method.java:324)

org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaE
ngine.java:101)

org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.j
ava:63)

org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:339)

org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)

org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)

org.ofbiz.service.rmi.RemoteDispatcherImpl.runSync(RemoteDispatcherImpl.
java:62)

sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

java.lang.reflect.Method.invoke(Method.java:324)

sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)

sun.rmi.transport.Transport$1.run(Transport.java:148)

java.security.AccessController.doPrivileged(Native Method)

sun.rmi.transport.Transport.serviceCall(Transport.java:144)

sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)

sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.ja
va:701)

java.lang.Thread.run(Thread.java:534)

------------------------------------------------------------------------
--------

 

 

Thanks

 

Bruno

 

[David E Jones-2]

Which version/revision of OFBiz are you using?

-David


On Aug 24, 2006, at 2:25 AM, Zaoui Bruno wrote:

> Hello,
>
>
>
> When I synchronize lot of data by EntitySync, the remote server  
> after a
> while, lost his connexion to the database (see logs at the end of the
> mail).
>
>
>
> I've tried to increase the pool-maxsize of the entityengine.xml  
> file but
> I keep my problem.
>
>
>
> Could you please explain me what could happen?
>
>
>
> Should I change the postgres configuration?
>
>
>
> My config :
>
> Postgres 8.0.1 under Linux Debian
>
>
>
> I use
>
> org.ofbiz.service.rmi.socket.zip.CompressionClientSocketFactory and
> org.ofbiz.service.rmi.socket.zip.CompressionServerSocketFactory
>
>
>
> entityengine.xml :
>
>         <inline-jdbc
>
>                 jdbc-driver="org.postgresql.Driver"
>
>                 jdbc-uri="jdbc:postgresql://xxx.xxx.xxx.xxx:5432/TOTO"
>
>                 jdbc-username="toto"
>
>                 jdbc-password="toto"
>
>                 isolation-level="ReadCommitted"
>
>                 pool-minsize="2"
>
>                 pool-maxsize="100"/>
>
>
>
>
>
> 1036559051[  ConnectionFactory.java:54 :ERROR] ******* ERROR: No
> database connection found for helperName "localpostgres"
>
> 1036559052[       SequenceUtil.java:283:ERROR]
>
> ---- exception report
> ----------------------------------------------------------
>
> General error in getting a sequenced ID
>
> Exception: org.ofbiz.entity.GenericEntityException
>
> Message: [SequenceUtil.SequenceBank.fillBank]: Unable to esablish a
> connection with the database, connection was null...
>
> ---- stack trace
> ---------------------------------------------------------------
>
> org.ofbiz.entity.GenericEntityException:
> [SequenceUtil.SequenceBank.fillBank]: Unable to esablish a connection
> with the database, connection was null...
>
> org.ofbiz.entity.util.SequenceUtil$SequenceBank.fillBank
> (SequenceUtil.ja
> va:187)
>
> org.ofbiz.entity.util.SequenceUtil$SequenceBank.getNextSeqId
> (SequenceUti
> l.java:135)
>
> org.ofbiz.entity.util.SequenceUtil.getNextSeqId(SequenceUtil.java:99)
>
> org.ofbiz.entity.GenericDelegator.getNextSeqIdLong
> (GenericDelegator.java
> :2643)
>
> org.ofbiz.entity.GenericDelegator.getNextSeqId
> (GenericDelegator.java:257
> 9)
>
> org.ofbiz.entity.GenericDelegator.getNextSeqId
> (GenericDelegator.java:256
> 3)
>
> org.ofbiz.entity.GenericDelegator.saveEntitySyncRemoveInfo
> (GenericDelega
> tor.java:687)
>
> org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:
> 841)
>
> org.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:
> 808)
>
> org.ofbiz.entityext.synchronization.EntitySyncServices.storeEntitySync
> Da
> ta(EntitySyncServices.java:359)
>
> sun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source)
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessor
> Impl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
>
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker
> (StandardJavaE
> ngine.java:101)
>
> org.ofbiz.service.engine.StandardJavaEngine.runSync
> (StandardJavaEngine.j
> ava:63)
>
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
> 339)
>
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
> 213)
>
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
> 110)
>
> org.ofbiz.service.rmi.RemoteDispatcherImpl.runSync
> (RemoteDispatcherImpl.
> java:62)
>
> sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source)
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessor
> Impl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
>
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
>
> sun.rmi.transport.Transport$1.run(Transport.java:148)
>
> java.security.AccessController.doPrivileged(Native Method)
>
> sun.rmi.transport.Transport.serviceCall(Transport.java:144)
>
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:
> 460)
>
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run
> (TCPTransport.ja
> va:701)
>
> java.lang.Thread.run(Thread.java:534)
>
> ----------------------------------------------------------------------
> --
> --------
>
>
>
>
>
> Thanks
>
>
>
> Bruno
>
>
>