You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Zaoui Bruno <bz...@prosodie.com> on 2006/08/24 10:25:41 UTC
Postgres : Lost connexion with my Postgres Database while an EntitySync
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
Re: Postgres : Lost connexion with my Postgres Database while an EntitySync
Posted by David E Jones <jo...@undersunconsulting.com>.
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
>
>
>