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

Ask Your Question
0

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.

Thanks

asked 2017-03-31 15:11:33 -0500

LexLuthor gravatar image
edit retag flag offensive close merge delete

Comments

You can deploy without any GSCs running , and add GSCs one by one. This will make sure initial load won't be called in parallel. Make sure service limit is set to 1.

shay hassidim gravatar imageshay hassidim ( 2017-04-02 05:15:16 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

You should consider checking the database lock / connection config.

Somehow the first database connection locking the other ones preventing concurrent read.

What's hibernate config?

answered 2017-04-04 14:49:28 -0500

shay hassidim gravatar image
edit flag offensive delete link more

Comments

<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.SybaseAnywhereDialect</prop>



<prop key="hibernate.cache.use_second_level_cache">false</prop>
<prop key="hibernate.cache.use_query_cache">false</prop>


<prop key="hibernate.jdbc.batch_size">5000</prop>
<prop key="hibernate.show_sql">${attrade.hibernate.show_sql}</prop>
<prop key="hibernate.connection.autocommit">false</prop>
</props>
</property>

LexLuthor gravatar imageLexLuthor ( 2017-04-04 14:53:15 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2017-03-31 15:11:33 -0500

Seen: 37 times

Last updated: Apr 04