Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Any way to make a space's partitions fill sequentially instead of in parallel

I have a space made of 4 partitions. When I start up the space, I get these error messages: org.hibernate.exception.SQLGrammarException: could not advance using next() and com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -210: User 'another user' has the row in 'AtTradeBrokerClientAggregate' locked

My theory is that the 4 partitions are trying to read from a database at the same time, so they are locking rows in the database and preventing each other from reading the rows. Is there any way to get those partitions to fill one after another instead of in parallel, so that only when one is full, does the next partition start getting its data? I'm not sure if this is even possible to do.

This problem didn't happen with Gigaspaces 9, it's just happening now that we are upgrading to Gigaspaces 10 and Hibernate 4.