Ofbiz Users, We upgraded our version of OFBiz a few months ago and are running through some performance tests. We are seeing errors in the SequenceUtil.getNextSeqId() method when we run load tests with multiple application servers. Note: We normally run multiple instances of OFBiz against the same database in production, but that version of OFBiz is a couple years old.
In reviewing the code we are seeing a property called "clustered" that looks like a possible solution for us. In the SequenceUtil.getNextSeqId() method it uses a "SELECT ... FOR UPDATE" statement to prevent other processes from modifying the record until the transaction is complete. We have set this property to 'Y' and it has resolved our error, but we want to make sure we are using the "clustered: property correctly. Here are my questions: 1. In general.properties the property is called "cluster" and its set to "N". I can't see any reference to a property "cluster" only to the property "clustered". I'm assuming this is a typo in the general.properties file. Is that correct? 2. Does the "clustered" property simply mean that multiple OFBiz application servers are running or does it mean that we need to configure our catalina container as a true cluster? For example, in the framework/catalina/ofbiz-component.xml file there is a configuration to run tomcat in a true container cluster. Thanks in advance for your help on these questions. Brett
