You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Stefan Häck (JIRA)" <ji...@apache.org> on 2012/06/28 14:01:45 UTC
[jira] [Created] (CASSANDRA-4390) Query with WHERE statement
delivers wrong results
Stefan Häck created CASSANDRA-4390:
--------------------------------------
Summary: 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
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);
--
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
[jira] [Resolved] (CASSANDRA-4390) Query with WHERE statement
delivers wrong results
Posted by "Stefan Häck (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefan Häck resolved CASSANDRA-4390.
------------------------------------
Resolution: Fixed
> 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
[jira] [Commented] (CASSANDRA-4390) Query with WHERE statement
delivers wrong results
Posted by "Sylvain Lebresne (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13403080#comment-13403080 ]
Sylvain Lebresne commented on CASSANDRA-4390:
---------------------------------------------
Do you also get wrong result when using cassandra-cli or when using phpcassa to fetch the results, or is that a CQL thing only?
> 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
[jira] [Closed] (CASSANDRA-4390) Query with WHERE statement
delivers wrong results
Posted by "Stefan Häck (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefan Häck closed CASSANDRA-4390.
----------------------------------
> 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
[jira] [Commented] (CASSANDRA-4390) Query with WHERE statement
delivers wrong results
Posted by "Sylvain Lebresne (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13403084#comment-13403084 ]
Sylvain Lebresne commented on CASSANDRA-4390:
---------------------------------------------
Have you tried a 'nodetool rebuild_index'?
> 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
[jira] [Commented] (CASSANDRA-4390) Query with WHERE statement
delivers wrong results
Posted by "Stefan Häck (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13403109#comment-13403109 ]
Stefan Häck commented on CASSANDRA-4390:
----------------------------------------
That's it! It works. Thanks a lot for your support.
(Now I also found this thread: http://comments.gmane.org/gmane.comp.db.cassandra.user/26569 )
> 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
[jira] [Updated] (CASSANDRA-4390) Query with WHERE statement
delivers wrong results
Posted by "Stefan Häck (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefan Häck updated CASSANDRA-4390:
-----------------------------------
Attachment: Cassandra_Query_Issue.png
> 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.
> 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);
--
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
[jira] [Commented] (CASSANDRA-4390) Query with WHERE statement
delivers wrong results
Posted by "Stefan Häck (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13403081#comment-13403081 ]
Stefan Häck commented on CASSANDRA-4390:
----------------------------------------
I get the wrong results even with cassandra-cli also as with phpcassa.
> 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
[jira] [Updated] (CASSANDRA-4390) Query with WHERE statement
delivers wrong results
Posted by "Stefan Häck (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Commented] (CASSANDRA-4390) Query with WHERE statement
delivers wrong results
Posted by "Sylvain Lebresne (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13403113#comment-13403113 ]
Sylvain Lebresne commented on CASSANDRA-4390:
---------------------------------------------
I guess that doesn't explain why the 2ndary index was not up to date in the first place but glad that fixed it for you.
> 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