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
