Re: Duplicate records returned

2015-10-08 Thread Robert Wille
If anyone is following this, I also logged the bug at https://datastax-oss.atlassian.net/browse/JAVA-943. I suspect that its a driver bug, so I anticipate CASSANDRA-10442 being closed, and hopefully the folks at datastax can get this fixed. This bug must affect a whole lot of people. On Oct 3,

Re: Duplicate records returned

2015-10-03 Thread Robert Wille
It's a paging bug. I ALWAYS get a duplicated record every fetchSize records. Easily duplicated 100% of the time. I’ve logged a bug: https://issues.apache.org/jira/browse/CASSANDRA-10442 Robert On Oct 3, 2015, at 10:59 AM, Robert Wille mailto:rwi...@fold3.com>> wrote: Oops, I was trimming out

Re: Duplicate records returned

2015-10-03 Thread Robert Wille
Oops, I was trimming out some irrelevant stuff, and trimmed out too much. The second snippet should be this: ResultSet rs = cassandraUtil.executeNamedQuery(Q_LIST_IMAGES, rollId); int total = 0; long lastImageId = -1; for (Row row : rs) { long imageId = row.getLong(PARAM_IMAGE_ID); if (imageI

Re: Duplicate records returned

2015-10-03 Thread Robert Wille
I don’t think its an application problem. The following simple snippets produce different totals: ResultSet rs = cassandraUtil.executeNamedQuery(Q_LIST_IMAGES, rollId); int total = 0; for (Row row : rs) { total++; } - ResultSet rs = cassandraUtil.executeNamedQuery(Q_LIST_IM

Re: Duplicate records returned

2015-10-03 Thread Eric Stevens
Can you give us an example of the duplicate records that comes back? How reliable is it (i.e. is it every record, is it one record per read, etc)? By any chance is it just the `data` field that duplicates while the other fields change per row? > I don’t see duplicates in cqlsh. I've never seen t

Duplicate records returned

2015-10-02 Thread Robert Wille
When I run the query "SELECT image FROM roll WHERE roll = :roll“ against this table CREATE TABLE roll ( roll INT, image BIGINT, data VARCHAR static, mid VARCHAR, imp_st VARCHAR, PRIMARY KEY ((roll), image) ) WITH gc_grace_seconds = 3456000 AND compaction = { 'class' : 'LeveledCompactionStrategy'