[
https://issues.apache.org/jira/browse/CASSANDRA-6137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13795562#comment-13795562
]
Constance Eustace edited comment on CASSANDRA-6137 at 10/15/13 9:49 PM:
------------------------------------------------------------------------
This has been reproduced in Cassandra 1.2.8 locally on SSD single-node.
- we have data that is both separated by @s and separated by :s. We have
failures for both separators. We have failures that don't SEEM to involve the
word "count" in the columns, but most seem to involve queries with the string
"count" in them.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ID: 924d6742-31fd-11e3-97f7-001c42000009-CJOB !!NOMATCH!!:
[__CPSYS_name, subPropA:filttest:sdf, urn:bby:pcm:ingest:status,
urn@bby@pcm@job@ingest@content@complete@count] to
[__CPSYS_name, subPropA:filttest:sdf, urn:bby:pcm:ingest:status]
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select * from wyfr_submission.entity_job where e_entid =
'924d6742-31fd-11e3-97f7-001c42000009-CJOB' ;
RESULT:
e_entid | p_prop
| describes | dndcondition | e_entlinks
| e_entname | e_enttype |
ingeststatus | ingeststatusdetail | p_flags | p_propid
| p_proplinks | p_storage | p_subents | p_val | p_vallang |
p_vallinks | p_valtype | p_valunit | p_vars
| partnerid |
referenceid | size | sourceip | submitdate |
submitevent | userid | version
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
__CPSYS_links | null | null |
[{"content":null,"href":"http://cupcake/wyfr/entities/id/9222fbe1-31fd-11e3-97f7-001c42000009-CJOB","rel":"parent-entity","type":"application/vnd.BUB.content.entity","hreflang":null,"title":"Up
to Parent
Entity","length":null,"otherAttributes":{}},{"content":null,"href":"http://cupcake/wyfr/entities/id/9222fbe1-31fd-11e3-97f7-001c42000009-CJOB/properties/type/DYNApropAA%3Asdjlk%3Asdfklj%3Afiltertest","rel":"up","type":"application/vnd.BUB.content.property","hreflang":null,"title":"Up
to Parent Entity Property","length":null,"otherAttributes":{}}] | null |
null | null | null | null |
null | null | null | null |
null | null | null | null | null |
null
| null | null | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
__CPSYS_name | null | null |
null | SUBENT-100 | null
| null | null | null |
null | null | null | null | null | null
| null | null | null |
null | null |
null | null | null | null | null |
null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
__CPSYS_type | null | null |
null | null | urn:bby:pcm:job
| null | null | null |
null | null | null | null | null | null
| null | null | null |
null | null |
null | null | null | null | null |
null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
subPropA:filttest:sdf | null | null |
null | null |
null | null | null | DVM |
924d6743-31fd-11e3-97f7-001c42000009 | [] | null | [] |
["subE","subI","subH"] | en_us | [] | text | m |
[{"type":"text","lang":"en_us","uom":"m","datas":["subE","subI","subH"],"links":[]}]
| null | null | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
urn:bby:pcm:ingest:status | null | null |
null | null |
null | subC | null | S00 |
924d6744-31fd-11e3-97f7-001c42000009 | [] | null | [] |
null | null | [] | null | null |
[{"type":"text","lang":"en_us","uom":"m","datas":["subC"],"links":[]}] |
null | null | null | null | null |
null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
urn:bby:pcm:job:sourceparty:reference:id | null | null |
null |
null | null | null | null | S00 |
924d6745-31fd-11e3-97f7-001c42000009 | [] | null | [] |
null | null | [] | null | null |
[{"type":"text","lang":"en_us","uom":"m","datas":["cdc8911c-7092-4c71-a7a6-935331ff2c5c"],"links":[]}]
| null | cdc8911c-7092-4c71-a7a6-935331ff2c5c | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
urn@bby@pcm@job@ingest@content@complete@count | null | null |
null | null | null | null | null |
null | null | [] | null |
null | null | null | null | null | null
|
null | null | null |
null | null | null | null | null | null
TRACE:
DEBUG [Thrift:1] 2013-10-15 14:45:26,841 CassandraServer.java (line 1699)
execute_cql3_query
TRACE [Thrift:1] 2013-10-15 14:45:26,842 QueryProcessor.java (line 100) Process
org.apache.cassandra.cql3.statements.SelectStatement@7aacaaae @CL.ONE
TRACE [Thrift:1] 2013-10-15 14:45:26,843 ReadCallback.java (line 67) Blockfor
is 1; setting up requests to /127.0.0.1
TRACE [ReadStage:3] 2013-10-15 14:45:26,851 SSTableReader.java (line 756)
Adding cache entry for
KeyCacheKey(/Users/a999166/aaa-projects/apache-cassandra-1.2.8/z-serverfiles/data/wyfr_submission/entity_job/wyfr_submission-entity_job-ic-2,
39323464363734322d333166642d313165332d393766372d3030316334323030303030392d434a4f42)
-> org.apache.cassandra.db.RowIndexEntry@4017415d
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 0 of 10000: __CPSYS_links::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 1 of 10000: __CPSYS_links:e_entlinks:false:566@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 1 of 10000: __CPSYS_name::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 2 of 10000: __CPSYS_name:e_entname:false:10@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 2 of 10000: __CPSYS_type::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 3 of 10000: __CPSYS_type:e_enttype:false:15@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 3 of 10000: subPropA\:filttest\:sdf::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000: subPropA\:filttest\:sdf:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000: subPropA\:filttest\:sdf:p_val:false:22@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_vallang:false:5@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_valtype:false:4@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_valunit:false:1@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000: subPropA\:filttest\:sdf:p_vars:false:84@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000: urn\:bby\:pcm\:ingest\:status::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:ingeststatus:false:4@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vars:false:70@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_vars:false:102@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:referenceid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn@bby@pcm@job@ingest@content@complete@count::false:0@1381860857189000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 7 of 10000:
urn@bby@pcm@job@ingest@content@complete@count:p_proplinks:false:2@1381860857189000
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT * FROM wyfr_submission.entity_job WHERE e_entid =
'924d6742-31fd-11e3-97f7-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','urn:bby:pcm:ingest:status','subPropA:filttest:sdf','urn@bby@pcm@job@ingest@content@complete@count')
RESULT:
e_entid | p_prop |
describes | dndcondition | e_entlinks | e_entname | e_enttype | ingeststatus |
ingeststatusdetail | p_flags | p_propid |
p_proplinks | p_storage | p_subents | p_val | p_vallang |
p_vallinks | p_valtype | p_valunit | p_vars
| partnerid | referenceid | size |
sourceip | submitdate | submitevent | userid | version
924d6742-31fd-11e3-97f7-001c42000009-CJOB | __CPSYS_name |
null | null | null | SUBENT-100 | null | null |
null | null | null | null |
null | null | null | null | null |
null | null |
null | null | null | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB | subPropA:filttest:sdf |
null | null | null | null | null | null |
null | DVM | 924d6743-31fd-11e3-97f7-001c42000009 | [] |
null | [] | ["subE","subI","subH"] | en_us | [] |
text | m |
[{"type":"text","lang":"en_us","uom":"m","datas":["subE","subI","subH"],"links":[]}]
| null | null | null | null | null | null |
null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB | urn:bby:pcm:ingest:status |
null | null | null | null | null | subC |
null | S00 | 924d6744-31fd-11e3-97f7-001c42000009 | [] |
null | [] | null | null | [] |
null | null |
[{"type":"text","lang":"en_us","uom":"m","datas":["subC"],"links":[]}] |
null | null | null | null | null | null | null |
null
TRACE:
DEBUG [Thrift:1] 2013-10-15 14:48:39,115 CassandraServer.java (line 1699)
execute_cql3_query
TRACE [Thrift:1] 2013-10-15 14:48:39,116 QueryProcessor.java (line 100) Process
org.apache.cassandra.cql3.statements.SelectStatement@58053ef7 @CL.ONE
TRACE [Thrift:1] 2013-10-15 14:48:39,116 ReadCallback.java (line 67) Blockfor
is 1; setting up requests to /127.0.0.1
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161)
collecting 0 of 10000: __CPSYS_name::false:0@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161)
collecting 1 of 10000: __CPSYS_name:e_entname:false:10@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161)
collecting 1 of 10000: subPropA\:filttest\:sdf::false:0@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000: subPropA\:filttest\:sdf:p_flags:false:3@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_propid:false:36@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_subents:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000: subPropA\:filttest\:sdf:p_val:false:22@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_vallang:false:5@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_valtype:false:4@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_valunit:false:1@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 2 of 10000: subPropA\:filttest\:sdf:p_vars:false:84@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
urn\:bby\:pcm\:ingest\:status:ingeststatus:false:4@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_flags:false:3@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_propid:false:36@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_subents:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vars:false:70@1381445090517000
DEBUG [Thrift:1] 2013-10-15 14:48:39,120 Tracing.java (line 167) request
complete
was (Author: cowardlydragon):
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ID: 924d6742-31fd-11e3-97f7-001c42000009-CJOB !!NOMATCH!!:
[__CPSYS_name, subPropA:filttest:sdf, urn:bby:pcm:ingest:status,
urn@bby@pcm@job@ingest@content@complete@count] to
[__CPSYS_name, subPropA:filttest:sdf, urn:bby:pcm:ingest:status]
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select * from wyfr_submission.entity_job where e_entid =
'924d6742-31fd-11e3-97f7-001c42000009-CJOB' ;
RESULT:
e_entid | p_prop
| describes | dndcondition | e_entlinks
| e_entname | e_enttype |
ingeststatus | ingeststatusdetail | p_flags | p_propid
| p_proplinks | p_storage | p_subents | p_val | p_vallang |
p_vallinks | p_valtype | p_valunit | p_vars
| partnerid |
referenceid | size | sourceip | submitdate |
submitevent | userid | version
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
__CPSYS_links | null | null |
[{"content":null,"href":"http://cupcake/wyfr/entities/id/9222fbe1-31fd-11e3-97f7-001c42000009-CJOB","rel":"parent-entity","type":"application/vnd.BUB.content.entity","hreflang":null,"title":"Up
to Parent
Entity","length":null,"otherAttributes":{}},{"content":null,"href":"http://cupcake/wyfr/entities/id/9222fbe1-31fd-11e3-97f7-001c42000009-CJOB/properties/type/DYNApropAA%3Asdjlk%3Asdfklj%3Afiltertest","rel":"up","type":"application/vnd.BUB.content.property","hreflang":null,"title":"Up
to Parent Entity Property","length":null,"otherAttributes":{}}] | null |
null | null | null | null |
null | null | null | null |
null | null | null | null | null |
null
| null | null | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
__CPSYS_name | null | null |
null | SUBENT-100 | null
| null | null | null |
null | null | null | null | null | null
| null | null | null |
null | null |
null | null | null | null | null |
null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
__CPSYS_type | null | null |
null | null | urn:bby:pcm:job
| null | null | null |
null | null | null | null | null | null
| null | null | null |
null | null |
null | null | null | null | null |
null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
subPropA:filttest:sdf | null | null |
null | null |
null | null | null | DVM |
924d6743-31fd-11e3-97f7-001c42000009 | [] | null | [] |
["subE","subI","subH"] | en_us | [] | text | m |
[{"type":"text","lang":"en_us","uom":"m","datas":["subE","subI","subH"],"links":[]}]
| null | null | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
urn:bby:pcm:ingest:status | null | null |
null | null |
null | subC | null | S00 |
924d6744-31fd-11e3-97f7-001c42000009 | [] | null | [] |
null | null | [] | null | null |
[{"type":"text","lang":"en_us","uom":"m","datas":["subC"],"links":[]}] |
null | null | null | null | null |
null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
urn:bby:pcm:job:sourceparty:reference:id | null | null |
null |
null | null | null | null | S00 |
924d6745-31fd-11e3-97f7-001c42000009 | [] | null | [] |
null | null | [] | null | null |
[{"type":"text","lang":"en_us","uom":"m","datas":["cdc8911c-7092-4c71-a7a6-935331ff2c5c"],"links":[]}]
| null | cdc8911c-7092-4c71-a7a6-935331ff2c5c | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
urn@bby@pcm@job@ingest@content@complete@count | null | null |
null | null | null | null | null |
null | null | [] | null |
null | null | null | null | null | null
|
null | null | null |
null | null | null | null | null | null
TRACE:
DEBUG [Thrift:1] 2013-10-15 14:45:26,841 CassandraServer.java (line 1699)
execute_cql3_query
TRACE [Thrift:1] 2013-10-15 14:45:26,842 QueryProcessor.java (line 100) Process
org.apache.cassandra.cql3.statements.SelectStatement@7aacaaae @CL.ONE
TRACE [Thrift:1] 2013-10-15 14:45:26,843 ReadCallback.java (line 67) Blockfor
is 1; setting up requests to /127.0.0.1
TRACE [ReadStage:3] 2013-10-15 14:45:26,851 SSTableReader.java (line 756)
Adding cache entry for
KeyCacheKey(/Users/a999166/aaa-projects/apache-cassandra-1.2.8/z-serverfiles/data/wyfr_submission/entity_job/wyfr_submission-entity_job-ic-2,
39323464363734322d333166642d313165332d393766372d3030316334323030303030392d434a4f42)
-> org.apache.cassandra.db.RowIndexEntry@4017415d
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 0 of 10000: __CPSYS_links::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 1 of 10000: __CPSYS_links:e_entlinks:false:566@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 1 of 10000: __CPSYS_name::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 2 of 10000: __CPSYS_name:e_entname:false:10@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 2 of 10000: __CPSYS_type::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 3 of 10000: __CPSYS_type:e_enttype:false:15@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 3 of 10000: subPropA\:filttest\:sdf::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000: subPropA\:filttest\:sdf:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000: subPropA\:filttest\:sdf:p_val:false:22@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_vallang:false:5@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_valtype:false:4@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_valunit:false:1@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000: subPropA\:filttest\:sdf:p_vars:false:84@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000: urn\:bby\:pcm\:ingest\:status::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:ingeststatus:false:4@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vars:false:70@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_vars:false:102@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:referenceid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn@bby@pcm@job@ingest@content@complete@count::false:0@1381860857189000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 7 of 10000:
urn@bby@pcm@job@ingest@content@complete@count:p_proplinks:false:2@1381860857189000
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT * FROM wyfr_submission.entity_job WHERE e_entid =
'924d6742-31fd-11e3-97f7-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','urn:bby:pcm:ingest:status','subPropA:filttest:sdf','urn@bby@pcm@job@ingest@content@complete@count')
RESULT:
e_entid | p_prop |
describes | dndcondition | e_entlinks | e_entname | e_enttype | ingeststatus |
ingeststatusdetail | p_flags | p_propid |
p_proplinks | p_storage | p_subents | p_val | p_vallang |
p_vallinks | p_valtype | p_valunit | p_vars
| partnerid | referenceid | size |
sourceip | submitdate | submitevent | userid | version
924d6742-31fd-11e3-97f7-001c42000009-CJOB | __CPSYS_name |
null | null | null | SUBENT-100 | null | null |
null | null | null | null |
null | null | null | null | null |
null | null |
null | null | null | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB | subPropA:filttest:sdf |
null | null | null | null | null | null |
null | DVM | 924d6743-31fd-11e3-97f7-001c42000009 | [] |
null | [] | ["subE","subI","subH"] | en_us | [] |
text | m |
[{"type":"text","lang":"en_us","uom":"m","datas":["subE","subI","subH"],"links":[]}]
| null | null | null | null | null | null |
null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB | urn:bby:pcm:ingest:status |
null | null | null | null | null | subC |
null | S00 | 924d6744-31fd-11e3-97f7-001c42000009 | [] |
null | [] | null | null | [] |
null | null |
[{"type":"text","lang":"en_us","uom":"m","datas":["subC"],"links":[]}] |
null | null | null | null | null | null | null |
null
TRACE:
DEBUG [Thrift:1] 2013-10-15 14:48:39,115 CassandraServer.java (line 1699)
execute_cql3_query
TRACE [Thrift:1] 2013-10-15 14:48:39,116 QueryProcessor.java (line 100) Process
org.apache.cassandra.cql3.statements.SelectStatement@58053ef7 @CL.ONE
TRACE [Thrift:1] 2013-10-15 14:48:39,116 ReadCallback.java (line 67) Blockfor
is 1; setting up requests to /127.0.0.1
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161)
collecting 0 of 10000: __CPSYS_name::false:0@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161)
collecting 1 of 10000: __CPSYS_name:e_entname:false:10@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161)
collecting 1 of 10000: subPropA\:filttest\:sdf::false:0@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000: subPropA\:filttest\:sdf:p_flags:false:3@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_propid:false:36@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_subents:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000: subPropA\:filttest\:sdf:p_val:false:22@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_vallang:false:5@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_valtype:false:4@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_valunit:false:1@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 2 of 10000: subPropA\:filttest\:sdf:p_vars:false:84@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
urn\:bby\:pcm\:ingest\:status:ingeststatus:false:4@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_flags:false:3@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_propid:false:36@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_subents:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vars:false:70@1381445090517000
DEBUG [Thrift:1] 2013-10-15 14:48:39,120 Tracing.java (line 167) request
complete
> CQL3 SELECT IN CLAUSE inconsistent
> ----------------------------------
>
> Key: CASSANDRA-6137
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6137
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Ubuntu AWS Cassandra 2.0.1 SINGLE NODE
> Reporter: Constance Eustace
> Fix For: 2.0.1
>
>
> We are encountering inconsistent results from CQL3 queries with column keys
> using IN clause in WHERE. This has been reproduced in cqlsh and the jdbc
> driver.
> Rowkey is e_entid
> Column key is p_prop
> This returns roughly 21 rows for 21 column keys that match p_prop.
> cqlsh> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB';
> These three queries each return one row for the requested single column key
> in the IN clause:
> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:complete:count');
> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:all:count');
> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:fail:count');
> This query returns ONLY ONE ROW (one column key), not three as I would expect
> from the three-column-key IN clause:
> cqlsh> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:complete:count','urn:bby:pcm:job:ingest:content:all:count','urn:bby:pcm:job:ingest:content:fail:count');
> This query does return two rows however for the requested two column keys:
> cqlsh> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in (
>
> 'urn:bby:pcm:job:ingest:content:all:count','urn:bby:pcm:job:ingest:content:fail:count');
> cqlsh> describe table internal_submission.entity_job;
> CREATE TABLE entity_job (
> e_entid text,
> p_prop text,
> describes text,
> dndcondition text,
> e_entlinks text,
> e_entname text,
> e_enttype text,
> ingeststatus text,
> ingeststatusdetail text,
> p_flags text,
> p_propid text,
> p_proplinks text,
> p_storage text,
> p_subents text,
> p_val text,
> p_vallang text,
> p_vallinks text,
> p_valtype text,
> p_valunit text,
> p_vars text,
> partnerid text,
> referenceid text,
> size int,
> sourceip text,
> submitdate bigint,
> submitevent text,
> userid text,
> version text,
> PRIMARY KEY (e_entid, p_prop)
> ) WITH
> bloom_filter_fp_chance=0.010000 AND
> caching='KEYS_ONLY' AND
> comment='' AND
> dclocal_read_repair_chance=0.000000 AND
> gc_grace_seconds=864000 AND
> index_interval=128 AND
> read_repair_chance=0.100000 AND
> replicate_on_write='true' AND
> populate_io_cache_on_flush='false' AND
> default_time_to_live=0 AND
> speculative_retry='NONE' AND
> memtable_flush_period_in_ms=0 AND
> compaction={'class': 'SizeTieredCompactionStrategy'} AND
> compression={'sstable_compression': 'LZ4Compressor'};
> CREATE INDEX internal_submission__JobDescribesIDX ON entity_job (describes);
> CREATE INDEX internal_submission__JobDNDConditionIDX ON entity_job
> (dndcondition);
> CREATE INDEX internal_submission__JobIngestStatusIDX ON entity_job
> (ingeststatus);
> CREATE INDEX internal_submission__JobIngestStatusDetailIDX ON entity_job
> (ingeststatusdetail);
> CREATE INDEX internal_submission__JobReferenceIDIDX ON entity_job
> (referenceid);
> CREATE INDEX internal_submission__JobUserIDX ON entity_job (userid);
> CREATE INDEX internal_submission__JobVersionIDX ON entity_job (version);
> -------------------------------
> My suspicion is that the three-column-key IN Clause is translated (improperly
> or not) to a two-column key range with the assumption that the third column
> key is present in that range, but it isn't...
--
This message was sent by Atlassian JIRA
(v6.1#6144)
