OFBiz › OFBiz - User

RE: [Spam][Spam]Re: Postgres : Lost connexion with my Postgres Database while an EntitySync

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Zaoui Bruno

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:[hidden email]]
Envoyé : vendredi 25 août 2006 10:29
À : [hidden email]
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
>
>
>

Si Chen-2

Re: [Spam][Spam]Re: Postgres : Lost connexion with my Postgres Database while an EntitySync

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:[hidden email]]
> Envoyé : vendredi 25 août 2006 10:29
> À : [hidden email]
> 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
>>
>>
>>
>

David E Jones-2

Re: Postgres : Lost connexion with my Postgres Database while an EntitySync

In reply to this post by Zaoui Bruno

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: