Forum: Building VoltDB Clients

Post: Reading data a node crash!

Reading data a node crash!
dl_zhenglp
May 23, 2012
Hi,

When i try to read a lot of data, then one node crashed. By the way, i have two nodes.

My project and the log in the attachment.

Zheng
Attachment
dl_zhenglp
May 23, 2012
Attachment
Log file
rbetts
May 23, 2012
The attached log file is only 22 bytes in size. Can you attach the log file again? Or email it to me at
rbetts@voltdb.com
Nondeterministic SQL statement
nshi
May 23, 2012
Hi,
The SQL statement in the procedure is not deterministic. It does a limit and offset without an order by clause. The same SQL statement executed on different replicas of the same partition could get different result. That's why you saw the mismatch.
If you order the results so that the results are always in the same order on different replicas, then it will work. For example, in this case, you can ORDER BY JSHBS.
For why determinism matters, you can see section 3.2.2
Ning