Hi I'm using SequoiaERP 0.83 -----Message d'origine----- De : David E Jones [mailto:[EMAIL PROTECTED] Envoyé : vendredi 25 août 2006 10:29 À : [email protected] 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 > > >
