[ https://issues.apache.org/jira/browse/CASSANDRA-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefan Häck updated CASSANDRA-4390: ----------------------------------- Description: Data is written to cassandra via phpcassa ( https://github.com/thobbs/phpcassa v1.0). Inspection the records via cqlsh,the query with a WHERE statement doesn't deliver all records. https://issues.apache.org/jira/secure/attachment/12533818/Cassandra_Query_Issue.png I'am working with a 2 node cluster and the effect is the same on both nodes. Furthermore a nodetool repair, nodetool rebuild has no positive effect. The data type for this column is varint. ****** DESCRIBE COLUMNFAMILY rm_advertisements CREATE TABLE rm_advertisements ( KEY text PRIMARY KEY, css text, form text, custom_field2 text, vacancy_type text, custom_field3 text, active boolean, vacancy_responsibles text, job_site text, vacancy_email_notification text, custom_field4 text, vacancy_name text, startdate text, vacancy_id varint, custom_field5 text, html text, company_id varint, ctime text, title text, expires text, atime text, custom_field1 text, vacancy_language text, tags text, mtime text, mailapply boolean, vacancy_description text, vacancy_function text, shorthash text ) WITH comment='Advertisements' AND comparator=text AND read_repair_chance=1.000000 AND gc_grace_seconds=864000 AND default_validation=text AND min_compaction_threshold=4 AND max_compaction_threshold=32 AND replicate_on_write='true' AND compaction_strategy_class='SizeTieredCompactionStrategy' AND compression_parameters:sstable_compression='SnappyCompressor'; CREATE INDEX rm_advertisements_active ON rm_advertisements (active); CREATE INDEX rm_advertisements_job_site ON rm_advertisements (job_site); CREATE INDEX rm_advertisements_vacancy_id ON rm_advertisements (vacancy_id); CREATE INDEX rm_advertisements_company_id ON rm_advertisements (company_id); CREATE INDEX rm_advertisements_title ON rm_advertisements (title); CREATE INDEX rm_advertisements_expires ON rm_advertisements (expires); CREATE INDEX rm_advertisements_vacancy_language ON rm_advertisements (vacancy_language); CREATE INDEX rm_advertisements_mailapply ON rm_advertisements (mailapply); CREATE INDEX rm_advertisements_shorthash ON rm_advertisements (shorthash); was: Data is written to cassandra via phpcassa ( https://github.com/thobbs/phpcassa v1.0). Inspection the records via cqlsh,the query with a WHERE statement doesn't deliver all records. http://imageshack.us/photo/my-images/820/cassandraqueryissue.png/ I'am working with a 2 node cluster and the effect is the same on both nodes. Furthermore a nodetool repair, nodetool rebuild has no positive effect. The data type for this column is varint. ****** DESCRIBE COLUMNFAMILY rm_advertisements CREATE TABLE rm_advertisements ( KEY text PRIMARY KEY, css text, form text, custom_field2 text, vacancy_type text, custom_field3 text, active boolean, vacancy_responsibles text, job_site text, vacancy_email_notification text, custom_field4 text, vacancy_name text, startdate text, vacancy_id varint, custom_field5 text, html text, company_id varint, ctime text, title text, expires text, atime text, custom_field1 text, vacancy_language text, tags text, mtime text, mailapply boolean, vacancy_description text, vacancy_function text, shorthash text ) WITH comment='Advertisements' AND comparator=text AND read_repair_chance=1.000000 AND gc_grace_seconds=864000 AND default_validation=text AND min_compaction_threshold=4 AND max_compaction_threshold=32 AND replicate_on_write='true' AND compaction_strategy_class='SizeTieredCompactionStrategy' AND compression_parameters:sstable_compression='SnappyCompressor'; CREATE INDEX rm_advertisements_active ON rm_advertisements (active); CREATE INDEX rm_advertisements_job_site ON rm_advertisements (job_site); CREATE INDEX rm_advertisements_vacancy_id ON rm_advertisements (vacancy_id); CREATE INDEX rm_advertisements_company_id ON rm_advertisements (company_id); CREATE INDEX rm_advertisements_title ON rm_advertisements (title); CREATE INDEX rm_advertisements_expires ON rm_advertisements (expires); CREATE INDEX rm_advertisements_vacancy_language ON rm_advertisements (vacancy_language); CREATE INDEX rm_advertisements_mailapply ON rm_advertisements (mailapply); CREATE INDEX rm_advertisements_shorthash ON rm_advertisements (shorthash); > Query with WHERE statement delivers wrong results > ------------------------------------------------- > > Key: CASSANDRA-4390 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4390 > Project: Cassandra > Issue Type: Bug > Affects Versions: 1.1.1 > Environment: Linux version 2.6.32-5-amd64 (Debian 2.6.32-45) |cqlsh > 2.2.0 | Cassandra 1.1.1 | CQL spec 2.0.0 | Thrift protocol 19.32.0] > Reporter: Stefan Häck > Attachments: Cassandra_Query_Issue.png > > > Data is written to cassandra via phpcassa ( > https://github.com/thobbs/phpcassa v1.0). > Inspection the records via cqlsh,the query with a WHERE statement doesn't > deliver all records. > https://issues.apache.org/jira/secure/attachment/12533818/Cassandra_Query_Issue.png > I'am working with a 2 node cluster and the effect is the same on both nodes. > Furthermore a nodetool repair, nodetool rebuild has no positive effect. The > data type for this column is varint. > ****** > DESCRIBE COLUMNFAMILY rm_advertisements > CREATE TABLE rm_advertisements ( > KEY text PRIMARY KEY, > css text, > form text, > custom_field2 text, > vacancy_type text, > custom_field3 text, > active boolean, > vacancy_responsibles text, > job_site text, > vacancy_email_notification text, > custom_field4 text, > vacancy_name text, > startdate text, > vacancy_id varint, > custom_field5 text, > html text, > company_id varint, > ctime text, > title text, > expires text, > atime text, > custom_field1 text, > vacancy_language text, > tags text, > mtime text, > mailapply boolean, > vacancy_description text, > vacancy_function text, > shorthash text > ) WITH > comment='Advertisements' AND > comparator=text AND > read_repair_chance=1.000000 AND > gc_grace_seconds=864000 AND > default_validation=text AND > min_compaction_threshold=4 AND > max_compaction_threshold=32 AND > replicate_on_write='true' AND > compaction_strategy_class='SizeTieredCompactionStrategy' AND > compression_parameters:sstable_compression='SnappyCompressor'; > CREATE INDEX rm_advertisements_active ON rm_advertisements (active); > CREATE INDEX rm_advertisements_job_site ON rm_advertisements (job_site); > CREATE INDEX rm_advertisements_vacancy_id ON rm_advertisements (vacancy_id); > CREATE INDEX rm_advertisements_company_id ON rm_advertisements (company_id); > CREATE INDEX rm_advertisements_title ON rm_advertisements (title); > CREATE INDEX rm_advertisements_expires ON rm_advertisements (expires); > CREATE INDEX rm_advertisements_vacancy_language ON rm_advertisements > (vacancy_language); > CREATE INDEX rm_advertisements_mailapply ON rm_advertisements (mailapply); > CREATE INDEX rm_advertisements_shorthash ON rm_advertisements (shorthash); -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira