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/25 10:31:25 UTC
RE: [Spam][Spam]Re: Postgres : Lost connexion with my Postgres Database while an EntitySync
Hi
I'm using SequoiaERP 0.83
-----Message d'origine-----
De : David E Jones [mailto:jonesde@undersunconsulting.com]
Envoyé : vendredi 25 août 2006 10:29
À : ofbiz-user@incubator.apache.org
Objet : [Spam][Spam]Re: Postgres : Lost connexion with my Postgres Database while an EntitySync
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
>
>
>
Re: Postgres : Lost connexion with my Postgres Database while an EntitySync
Posted by David E Jones <jo...@undersunconsulting.com>.
That version of SequoiaERP is based on a revision of OFBiz that is a
fair bit older. Is it an option to try a newer version of OFBiz?
Based on the limited information here you might be able to solve this
problem by increasing the JDBC connection pool size. In other words,
it may be running out of connections.
There were some problems a while back with the key sequencing, but I
don't know if those were in the S-ERP 0.8.3 release (my memory isn't
that good).
-David
On Aug 25, 2006, at 2:31 AM, Zaoui Bruno wrote:
> Hi
>
> I'm using SequoiaERP 0.83
>
> -----Message d'origine-----
> De : David E Jones [mailto:jonesde@undersunconsulting.com]
> Envoyé : vendredi 25 août 2006 10:29
> À : ofbiz-user@incubator.apache.org
> Objet : [Spam][Spam]Re: Postgres : Lost connexion with my Postgres
> Database while an EntitySync
>
>
> 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.storeEntitySyn
>> c
>> 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
>>
>>
>>
>
Re: [Spam][Spam]Re: Postgres : Lost connexion with my Postgres Database while an EntitySync
Posted by Si Chen <si...@opensourcestrategies.com>.
That's approximately OFBIZ SVN r 5560
On Aug 25, 2006, at 1:31 AM, Zaoui Bruno wrote:
> Hi
>
> I'm using SequoiaERP 0.83
>
> -----Message d'origine-----
> De : David E Jones [mailto:jonesde@undersunconsulting.com]
> Envoyé : vendredi 25 août 2006 10:29
> À : ofbiz-user@incubator.apache.org
> Objet : [Spam][Spam]Re: Postgres : Lost connexion with my Postgres
> Database while an EntitySync
>
>
> 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.storeEntitySyn
>> c
>> 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
>>
>>
>>
>