[jira] [Commented] (CASSANDRA-5501) Missing data on SELECT on secondary index
[
https://issues.apache.org/jira/browse/CASSANDRA-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13642659#comment-13642659
]
Marco Matarazzo commented on CASSANDRA-5501:
CREATE TABLE agents (
agent_id ascii PRIMARY KEY,
character_points ascii,
component_id ascii,
corporation_id ascii,
entity_id ascii,
manufacturing ascii,
model ascii,
name ascii,
name_check ascii,
station_id ascii,
stats_intellect ascii,
stats_reflexes ascii,
stats_stamina ascii,
stats_technology ascii,
trading ascii
) WITH
bloom_filter_fp_chance=0.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
read_repair_chance=0.10 AND
replicate_on_write='true' AND
compaction={'class': 'SizeTieredCompactionStrategy'} AND
compression={'sstable_compression': 'SnappyCompressor'};
CREATE INDEX agents_corporation_id ON agents (corporation_id);
CREATE INDEX agents_entity_id ON agents (entity_id);
CREATE INDEX agents_name_idx_1 ON agents (name);
CREATE INDEX agents_name_check ON agents (name_check);
CREATE INDEX agents_station_id ON agents (station_id);
CREATE INDEX agents_trading ON agents (trading);
Missing data on SELECT on secondary index
--
Key: CASSANDRA-5501
URL: https://issues.apache.org/jira/browse/CASSANDRA-5501
Project: Cassandra
Issue Type: Bug
Affects Versions: 1.2.4
Environment: linux ubuntu 12.04
Reporter: Marco Matarazzo
Attachments: query_log.txt
We have a 3 nodes cluster, and a keyspace with RF = 3.
From cassandra-cli everything is fine (we actually never use it, I just
launched it for a check in this particular case).
[default@goh_master] get agents where station_id = ascii(1110129);
---
RowKey: 6c8efeb6-7209-11e2-890a-aacc0216
= (column=, value=, timestamp=1364580868176000)
= (column=character_points, value=, timestamp=136103068689)
= (column=component_id, value=0, timestamp=1364580868176000)
= (column=corporation_id, value=3efc729e-7209-11e2-890a-aacc0216,
timestamp=136103068689)
= (column=entity_id, value=0, timestamp=1364580868176000)
= (column=manufacturing, value=, timestamp=136103068689)
= (column=model, value=55, timestamp=136103068689)
= (column=name, value=Jenny Olifield, timestamp=136103068689)
= (column=name_check, value=jenny_olifield, timestamp=136103068689)
= (column=station_id, value=1110129, timestamp=1364580868176000)
= (column=stats_intellect, value=8, timestamp=136103068689)
= (column=stats_reflexes, value=8, timestamp=136103068689)
= (column=stats_stamina, value=7, timestamp=136103068689)
= (column=stats_technology, value=7, timestamp=136103068689)
= (column=trading, value=, timestamp=136103068689)
---
RowKey: dc413373-6b06-11e2-8943-aacc0216
= (column=, value=, timestamp=136656818522)
= (column=character_points, value=100, timestamp=1364580381651000)
= (column=component_id, value=, timestamp=1364580381651000)
= (column=corporation_id, value=574934cc-6b06-11e2-a512-aacc0200,
timestamp=1364580381651000)
= (column=entity_id, value=0, timestamp=1364580381651000)
= (column=manufacturing, value=, timestamp=1364580381651000)
= (column=model, value=500018, timestamp=1364580381651000)
= (column=name, value=Darren Matar, timestamp=1364580381651000)
= (column=name_check, value=darren_matar, timestamp=1364580381651000)
= (column=station_id, value=1110129, timestamp=1364580381651000)
= (column=stats_intellect, value=10, timestamp=1364580381651000)
= (column=stats_reflexes, value=10, timestamp=1364580381651000)
= (column=stats_stamina, value=10, timestamp=1364580381651000)
= (column=stats_technology, value=10, timestamp=1364580381651000)
= (column=trading, value=1, timestamp=136656818522)
---
RowKey: 0e7074ac-64bd-11e2-8c38-aacc0201
= (column=, value=, timestamp=1364828039093000)
= (column=character_points, value=, timestamp=136103068676)
= (column=component_id, value=0, timestamp=1364828039093000)
= (column=corporation_id, value=e398294e-64bc-11e2-8c38-aacc0201,
timestamp=136103068676)
= (column=entity_id, value=0, timestamp=1364828039093000)
= (column=manufacturing, value=1, timestamp=1362517535613000)
= (column=model, value=58, timestamp=136103068676)
= (column=name, value=Tom Bishop, timestamp=136103068676)
= (column=name_check, value=tom_bishop, timestamp=136103068676)
= (column=station_id, value=1110129, timestamp=1364828039093000)
= (column=stats_intellect, value=9, timestamp=136103068676)
= (column=stats_reflexes, value=7, timestamp=136103068676)
= (column=stats_stamina, value=5, timestamp=136103068676)
=
[jira] [Commented] (CASSANDRA-5501) Missing data on SELECT on secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13643037#comment-13643037 ] Marco Matarazzo commented on CASSANDRA-5501: Alas, we had to update (and add) data in rows and now the query is correctly returning everything. I didn't know about the TRACING ON command, it's a great tool :-) I'm going to still post the result of the command, hoping that, apart from the result being correct, it will give you some clues anyway. cqlsh:goh_master select agent_id,name,station_id,trading from agents where station_id='1110129'; agent_id | name | station_id | trading --+++- 6c8efeb6-7209-11e2-890a-aacc0216 | Jenny Olifield |1110129 |null b653d8c4-5fca-11e2-bd3a-aacc0216 |mammolo |1110129 |null cf9df102-7394-11e2-890a-aacc0216 | riolla |1110129 |null f9c0278b-aa5f-11e2-a860-aacc0216 | Terrinon |1110129 |null cf03e58b-6d6a-11e2-890a-aacc0216 | Fichte |1110129 |null 7e5d9601-70b5-11e2-a512-aacc0200 | miao |1110129 |null 8e50ab8c-63e7-11e2-8c38-aacc0201 | Reaper |1110129 | 0 bba46192-6c63-11e2-8c38-aacc0201 | crafter1 |1110129 |null 5521cda0-7394-11e2-890a-aacc0216 | olea |1110129 |null dc413373-6b06-11e2-8943-aacc0216 | Darren Matar |1110129 | 1 0e7074ac-64bd-11e2-8c38-aacc0201 | Tom Bishop |1110129 |null 02238149-717a-11e2-890a-aacc0216 | Capt. Andrew |1110129 |null d4e5a014-72ac-11e2-890a-aacc0216 | pluto |1110129 |null 2a483b11-70b5-11e2-8c38-aacc0201 | alexey |1110129 |null 1b462f09-65f3-4148-a1a6-536b52b3bcfa | Andrea Len |1110129 | 1 9a96615a-7a72-11e2-a513-aacc0216 | padme |1110129 |null 58670d03-70b6-11e2-8c38-aacc0201 | trilly |1110129 |null Tracing session: 1bd92f60-ae93-11e2-a990-2f5b109ee83c activity | timestamp| source | source_elapsed ---+--+--+ execute_cql3_query | 19:02:42,519 | 10.10.30.169 | 0 Message received from /10.10.30.169 | 19:02:42,516 | 10.10.30.170 | 21 Executing indexed scan for [min(-9223372036854775808), min(-9223372036854775808)] | 19:02:42,518 | 10.10.30.170 | 1866 Executing single-partition query on agents.agents_station_id | 19:02:42,518 | 10.10.30.170 | 2244 Parsing statement | 19:02:42,519 | 10.10.30.169 | 42 Acquiring sstable references | 19:02:42,519 | 10.10.30.170 | 2787 Peparing statement | 19:02:42,519 | 10.10.30.169 |122 Merging memtable contents | 19:02:42,519 | 10.10.30.170 | 3107 Determining replicas to query | 19:02:42,519 | 10.10.30.169 |216 Key cache hit for sstable 620 | 19:02:42,520 | 10.10.30.170 | 3806 Merging data from memtables and 1 sstables | 19:02:42,520 | 10.10.30.170 | 4135 Read 17 live cells and 0 tombstoned | 19:02:42,521 | 10.10.30.170 | 4826 Sending message to /10.10.30.170 | 19:02:42,522 | 10.10.30.169 | 2761 Executing single-partition query on agents | 19:02:42,522 | 10.10.30.170 | 5490 Acquiring sstable references | 19:02:42,522 | 10.10.30.170 | 5782 Merging memtable contents | 19:02:42,522 | 10.10.30.170 | 6062 Key cache hit for sstable 443 | 19:02:42,523 | 10.10.30.170 | 6350 Merging data from memtables and 1 sstables | 19:02:42,523 | 10.10.30.170 | 6628 Read 1 live cells and 3 tombstoned | 19:02:42,523 | 10.10.30.170 | 6991
[jira] [Updated] (CASSANDRA-5501) Missing data on SELECT on secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-5501: --- Attachment: tracing.txt (well-formatted tracing) Missing data on SELECT on secondary index -- Key: CASSANDRA-5501 URL: https://issues.apache.org/jira/browse/CASSANDRA-5501 Project: Cassandra Issue Type: Bug Affects Versions: 1.2.4 Environment: linux ubuntu 12.04 Reporter: Marco Matarazzo Attachments: query_log.txt, tracing.txt We have a 3 nodes cluster, and a keyspace with RF = 3. From cassandra-cli everything is fine (we actually never use it, I just launched it for a check in this particular case). [default@goh_master] get agents where station_id = ascii(1110129); --- RowKey: 6c8efeb6-7209-11e2-890a-aacc0216 = (column=, value=, timestamp=1364580868176000) = (column=character_points, value=, timestamp=136103068689) = (column=component_id, value=0, timestamp=1364580868176000) = (column=corporation_id, value=3efc729e-7209-11e2-890a-aacc0216, timestamp=136103068689) = (column=entity_id, value=0, timestamp=1364580868176000) = (column=manufacturing, value=, timestamp=136103068689) = (column=model, value=55, timestamp=136103068689) = (column=name, value=Jenny Olifield, timestamp=136103068689) = (column=name_check, value=jenny_olifield, timestamp=136103068689) = (column=station_id, value=1110129, timestamp=1364580868176000) = (column=stats_intellect, value=8, timestamp=136103068689) = (column=stats_reflexes, value=8, timestamp=136103068689) = (column=stats_stamina, value=7, timestamp=136103068689) = (column=stats_technology, value=7, timestamp=136103068689) = (column=trading, value=, timestamp=136103068689) --- RowKey: dc413373-6b06-11e2-8943-aacc0216 = (column=, value=, timestamp=136656818522) = (column=character_points, value=100, timestamp=1364580381651000) = (column=component_id, value=, timestamp=1364580381651000) = (column=corporation_id, value=574934cc-6b06-11e2-a512-aacc0200, timestamp=1364580381651000) = (column=entity_id, value=0, timestamp=1364580381651000) = (column=manufacturing, value=, timestamp=1364580381651000) = (column=model, value=500018, timestamp=1364580381651000) = (column=name, value=Darren Matar, timestamp=1364580381651000) = (column=name_check, value=darren_matar, timestamp=1364580381651000) = (column=station_id, value=1110129, timestamp=1364580381651000) = (column=stats_intellect, value=10, timestamp=1364580381651000) = (column=stats_reflexes, value=10, timestamp=1364580381651000) = (column=stats_stamina, value=10, timestamp=1364580381651000) = (column=stats_technology, value=10, timestamp=1364580381651000) = (column=trading, value=1, timestamp=136656818522) --- RowKey: 0e7074ac-64bd-11e2-8c38-aacc0201 = (column=, value=, timestamp=1364828039093000) = (column=character_points, value=, timestamp=136103068676) = (column=component_id, value=0, timestamp=1364828039093000) = (column=corporation_id, value=e398294e-64bc-11e2-8c38-aacc0201, timestamp=136103068676) = (column=entity_id, value=0, timestamp=1364828039093000) = (column=manufacturing, value=1, timestamp=1362517535613000) = (column=model, value=58, timestamp=136103068676) = (column=name, value=Tom Bishop, timestamp=136103068676) = (column=name_check, value=tom_bishop, timestamp=136103068676) = (column=station_id, value=1110129, timestamp=1364828039093000) = (column=stats_intellect, value=9, timestamp=136103068676) = (column=stats_reflexes, value=7, timestamp=136103068676) = (column=stats_stamina, value=5, timestamp=136103068676) = (column=stats_technology, value=9, timestamp=136103068676) = (column=trading, value=, timestamp=136103068676) --- RowKey: 1b462f09-65f3-4148-a1a6-536b52b3bcfa = (column=, value=, timestamp=1366568185096000) = (column=character_points, value=100, timestamp=1364580381537000) = (column=component_id, value=, timestamp=1364580381537000) = (column=corporation_id, value=1d2a8803-d139-4b50-85eb-92cb1082de2e, timestamp=1364580381537000) = (column=entity_id, value=0, timestamp=1364580381537000) = (column=manufacturing, value=, timestamp=1364580381537000) = (column=model, value=53, timestamp=1364580381537000) = (column=name, value=Andrea Len, timestamp=1364580381537000) = (column=name_check, value=andrea_len, timestamp=1364580381537000) = (column=station_id, value=1110129, timestamp=1364580381537000) = (column=stats_intellect, value=10, timestamp=1364580381537000) = (column=stats_reflexes, value=10, timestamp=1364580381537000) = (column=stats_stamina, value=10,
[jira] [Updated] (CASSANDRA-5501) Missing data on SELECT on secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-5501: --- Description: We have a 3 nodes cluster, and a keyspace with RF = 3. From cassandra-cli everything is fine (we actually never use it, I just launched it for a check in this particular case). [default@goh_master] get agents where station_id = ascii(1110129); --- RowKey: 6c8efeb6-7209-11e2-890a-aacc0216 = (column=, value=, timestamp=1364580868176000) = (column=character_points, value=, timestamp=136103068689) = (column=component_id, value=0, timestamp=1364580868176000) = (column=corporation_id, value=3efc729e-7209-11e2-890a-aacc0216, timestamp=136103068689) = (column=entity_id, value=0, timestamp=1364580868176000) = (column=manufacturing, value=, timestamp=136103068689) = (column=model, value=55, timestamp=136103068689) = (column=name, value=Jenny Olifield, timestamp=136103068689) = (column=name_check, value=jenny_olifield, timestamp=136103068689) = (column=station_id, value=1110129, timestamp=1364580868176000) = (column=stats_intellect, value=8, timestamp=136103068689) = (column=stats_reflexes, value=8, timestamp=136103068689) = (column=stats_stamina, value=7, timestamp=136103068689) = (column=stats_technology, value=7, timestamp=136103068689) = (column=trading, value=, timestamp=136103068689) --- RowKey: dc413373-6b06-11e2-8943-aacc0216 = (column=, value=, timestamp=136656818522) = (column=character_points, value=100, timestamp=1364580381651000) = (column=component_id, value=, timestamp=1364580381651000) = (column=corporation_id, value=574934cc-6b06-11e2-a512-aacc0200, timestamp=1364580381651000) = (column=entity_id, value=0, timestamp=1364580381651000) = (column=manufacturing, value=, timestamp=1364580381651000) = (column=model, value=500018, timestamp=1364580381651000) = (column=name, value=Darren Matar, timestamp=1364580381651000) = (column=name_check, value=darren_matar, timestamp=1364580381651000) = (column=station_id, value=1110129, timestamp=1364580381651000) = (column=stats_intellect, value=10, timestamp=1364580381651000) = (column=stats_reflexes, value=10, timestamp=1364580381651000) = (column=stats_stamina, value=10, timestamp=1364580381651000) = (column=stats_technology, value=10, timestamp=1364580381651000) = (column=trading, value=1, timestamp=136656818522) --- RowKey: 0e7074ac-64bd-11e2-8c38-aacc0201 = (column=, value=, timestamp=1364828039093000) = (column=character_points, value=, timestamp=136103068676) = (column=component_id, value=0, timestamp=1364828039093000) = (column=corporation_id, value=e398294e-64bc-11e2-8c38-aacc0201, timestamp=136103068676) = (column=entity_id, value=0, timestamp=1364828039093000) = (column=manufacturing, value=1, timestamp=1362517535613000) = (column=model, value=58, timestamp=136103068676) = (column=name, value=Tom Bishop, timestamp=136103068676) = (column=name_check, value=tom_bishop, timestamp=136103068676) = (column=station_id, value=1110129, timestamp=1364828039093000) = (column=stats_intellect, value=9, timestamp=136103068676) = (column=stats_reflexes, value=7, timestamp=136103068676) = (column=stats_stamina, value=5, timestamp=136103068676) = (column=stats_technology, value=9, timestamp=136103068676) = (column=trading, value=, timestamp=136103068676) --- RowKey: 1b462f09-65f3-4148-a1a6-536b52b3bcfa = (column=, value=, timestamp=1366568185096000) = (column=character_points, value=100, timestamp=1364580381537000) = (column=component_id, value=, timestamp=1364580381537000) = (column=corporation_id, value=1d2a8803-d139-4b50-85eb-92cb1082de2e, timestamp=1364580381537000) = (column=entity_id, value=0, timestamp=1364580381537000) = (column=manufacturing, value=, timestamp=1364580381537000) = (column=model, value=53, timestamp=1364580381537000) = (column=name, value=Andrea Len, timestamp=1364580381537000) = (column=name_check, value=andrea_len, timestamp=1364580381537000) = (column=station_id, value=1110129, timestamp=1364580381537000) = (column=stats_intellect, value=10, timestamp=1364580381537000) = (column=stats_reflexes, value=10, timestamp=1364580381537000) = (column=stats_stamina, value=10, timestamp=1364580381537000) = (column=stats_technology, value=10, timestamp=1364580381537000) = (column=trading, value=1, timestamp=1366568185096000) 4 Rows Returned. From CQLSH, hovewer, the result is different, and 2 rows are missing. cqlsh:goh_master select agent_id,name,station_id from agents where station_id='1110129'; agent_id | name | station_id --++ 6c8efeb6-7209-11e2-890a-aacc0216 | Jenny Olifield |1110129
[jira] [Commented] (CASSANDRA-5501) Missing data on SELECT on secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13637869#comment-13637869 ] Marco Matarazzo commented on CASSANDRA-5501: I don't know how the internal mechanism of Cassandra works, so this could absolutely be no related, but the two columns that are not coming out have a more recent timestamp as it can be seen from cassandra-cli, and this CF has two sstables on disk, ...-435 and ...-436 . Trying to rebuild the index with nodetool and with log level lowered to trace, it seems to me that -436 get skipped due to bloom filter, and i find it strange during an index rebuild phase. I repeat, I have just a very vague sense of how the internal mechanism works, so it could be perfectly fine and I could be completely wrong, that's why I'm writing this as a comment :-) Sensitive (to me) parts of the logs follows: INFO [RMI TCP Connection(6)-194.116.72.170] 2013-04-22 11:21:31,491 ColumnFamilyStore.java (line 552) User Requested secondary index re-build for goh_master/agents indexes INFO [RMI TCP Connection(6)-194.116.72.170] 2013-04-22 11:21:31,491 SecondaryIndexManager.java (line 136) Submitting index build of [agents_station_id] for data in SSTableReader(path='/var/lib/cassandra/data/goh_master/agents/goh_master-agents-ib-435-Data.db'), SSTableReader(path='/var/lib/cassandra/data/goh_master/agents/goh_master-agents-ib-436-Data.db') DEBUG [CompactionExecutor:4] 2013-04-22 11:21:31,493 Table.java (line 412) Indexing row a4a0c7d4-a1e9-11e2-a860-aacc0216 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,493 CollationController.java (line 233) collectAllData TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,493 SSTableReader.java (line 748) Cache hit for KeyCacheKey(/var/lib/cassandra/data/goh_master/agents/goh_master-agents-ib-435, 61346130633764342d613165392d313165322d613836302d616163633030303030323136) - org.apache.cassandra.db.RowIndexEntry@39b0595c TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,493 SliceQueryFilter.java (line 161) collecting 0 of 1: :false:0@136604087967 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,493 SliceQueryFilter.java (line 161) collecting 1 of 1: component_id:false:3@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,494 SliceQueryFilter.java (line 161) collecting 2 of 1: corporation_id:false:36@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,494 SliceQueryFilter.java (line 161) collecting 3 of 1: entity_id:false:1@136604087967 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,494 SliceQueryFilter.java (line 161) collecting 4 of 1: name:false:6@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,494 SliceQueryFilter.java (line 161) collecting 5 of 1: name_check:false:6@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,495 SliceQueryFilter.java (line 161) collecting 6 of 1: station_id:false:36@136604087967 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,495 SliceQueryFilter.java (line 161) collecting 7 of 1: stats_intellect:false:1@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,495 SliceQueryFilter.java (line 161) collecting 8 of 1: stats_reflexes:false:1@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,495 SliceQueryFilter.java (line 161) collecting 9 of 1: stats_stamina:false:1@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,495 SliceQueryFilter.java (line 161) collecting 10 of 1: stats_technology:false:1@136560356360 DEBUG [CompactionExecutor:4] 2013-04-22 11:21:31,496 Table.java (line 412) Indexing row 5315b187-bc33-4747-997a-dcc7bd60d768 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,496 CollationController.java (line 233) collectAllData TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,496 SSTableReader.java (line 748) Cache hit for KeyCacheKey(/var/lib/cassandra/data/goh_master/agents/goh_master-agents-ib-435, 35333135623138372d62632d343734372d393937612d646363376264363064373638) - org.apache.cassandra.db.RowIndexEntry@6ee09a07 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,496 SliceQueryFilter.java (line 161) collecting 0 of 1: :false:0@1366568185181000 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,496 SliceQueryFilter.java (line 161) collecting 1 of 1: character_points:false:3@1364580381572000 [...lots of these repeated until...] DEBUG [CompactionExecutor:4] 2013-04-22 11:21:31,642 Table.java (line 412) Indexing row 7b594dc0-a901-11e2-80b4-aacc0201 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,642 CollationController.java (line 233) collectAllData TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,642 SSTableReader.java (line 748) Cache hit for KeyCacheKey(/var/lib/cassandra/data/goh_master/agents/goh_master-agents-ib-436,
[jira] [Updated] (CASSANDRA-5501) Missing data on SELECT on secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-5501: --- Description: We have a 3 nodes cluster, and a keyspace with RF = 3. From cassandra-cli everything is fine (we actually never use it, I just launched it for a check in this particular case). [default@goh_master] get agents where station_id = ascii(1110129); --- RowKey: 6c8efeb6-7209-11e2-890a-aacc0216 = (column=, value=, timestamp=1364580868176000) = (column=character_points, value=, timestamp=136103068689) = (column=component_id, value=0, timestamp=1364580868176000) = (column=corporation_id, value=3efc729e-7209-11e2-890a-aacc0216, timestamp=136103068689) = (column=entity_id, value=0, timestamp=1364580868176000) = (column=manufacturing, value=, timestamp=136103068689) = (column=model, value=55, timestamp=136103068689) = (column=name, value=Jenny Olifield, timestamp=136103068689) = (column=name_check, value=jenny_olifield, timestamp=136103068689) = (column=station_id, value=1110129, timestamp=1364580868176000) = (column=stats_intellect, value=8, timestamp=136103068689) = (column=stats_reflexes, value=8, timestamp=136103068689) = (column=stats_stamina, value=7, timestamp=136103068689) = (column=stats_technology, value=7, timestamp=136103068689) = (column=trading, value=, timestamp=136103068689) --- RowKey: dc413373-6b06-11e2-8943-aacc0216 = (column=, value=, timestamp=136656818522) = (column=character_points, value=100, timestamp=1364580381651000) = (column=component_id, value=, timestamp=1364580381651000) = (column=corporation_id, value=574934cc-6b06-11e2-a512-aacc0200, timestamp=1364580381651000) = (column=entity_id, value=0, timestamp=1364580381651000) = (column=manufacturing, value=, timestamp=1364580381651000) = (column=model, value=500018, timestamp=1364580381651000) = (column=name, value=Darren Matar, timestamp=1364580381651000) = (column=name_check, value=darren_matar, timestamp=1364580381651000) = (column=station_id, value=1110129, timestamp=1364580381651000) = (column=stats_intellect, value=10, timestamp=1364580381651000) = (column=stats_reflexes, value=10, timestamp=1364580381651000) = (column=stats_stamina, value=10, timestamp=1364580381651000) = (column=stats_technology, value=10, timestamp=1364580381651000) = (column=trading, value=1, timestamp=136656818522) --- RowKey: 0e7074ac-64bd-11e2-8c38-aacc0201 = (column=, value=, timestamp=1364828039093000) = (column=character_points, value=, timestamp=136103068676) = (column=component_id, value=0, timestamp=1364828039093000) = (column=corporation_id, value=e398294e-64bc-11e2-8c38-aacc0201, timestamp=136103068676) = (column=entity_id, value=0, timestamp=1364828039093000) = (column=manufacturing, value=1, timestamp=1362517535613000) = (column=model, value=58, timestamp=136103068676) = (column=name, value=Tom Bishop, timestamp=136103068676) = (column=name_check, value=tom_bishop, timestamp=136103068676) = (column=station_id, value=1110129, timestamp=1364828039093000) = (column=stats_intellect, value=9, timestamp=136103068676) = (column=stats_reflexes, value=7, timestamp=136103068676) = (column=stats_stamina, value=5, timestamp=136103068676) = (column=stats_technology, value=9, timestamp=136103068676) = (column=trading, value=, timestamp=136103068676) --- RowKey: 1b462f09-65f3-4148-a1a6-536b52b3bcfa = (column=, value=, timestamp=1366568185096000) = (column=character_points, value=100, timestamp=1364580381537000) = (column=component_id, value=, timestamp=1364580381537000) = (column=corporation_id, value=1d2a8803-d139-4b50-85eb-92cb1082de2e, timestamp=1364580381537000) = (column=entity_id, value=0, timestamp=1364580381537000) = (column=manufacturing, value=, timestamp=1364580381537000) = (column=model, value=53, timestamp=1364580381537000) = (column=name, value=Andrea Len, timestamp=1364580381537000) = (column=name_check, value=andrea_len, timestamp=1364580381537000) = (column=station_id, value=1110129, timestamp=1364580381537000) = (column=stats_intellect, value=10, timestamp=1364580381537000) = (column=stats_reflexes, value=10, timestamp=1364580381537000) = (column=stats_stamina, value=10, timestamp=1364580381537000) = (column=stats_technology, value=10, timestamp=1364580381537000) = (column=trading, value=1, timestamp=1366568185096000) 4 Rows Returned. From CQLSH, hovewer, the result is different, and 2 rows are missing. cqlsh:goh_master select agent_id,name,station_id from agents where station_id='1110129'; agent_id | name | station_id --++ 6c8efeb6-7209-11e2-890a-aacc0216 | Jenny Olifield |1110129
[jira] [Issue Comment Deleted] (CASSANDRA-5501) Missing data on SELECT on secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-5501: --- Comment: was deleted (was: I don't know how the internal mechanism of Cassandra works, so this could absolutely be no related, but the two columns that are not coming out have a more recent timestamp as it can be seen from cassandra-cli, and this CF has two sstables on disk, ...-435 and ...-436 . Trying to rebuild the index with nodetool and with log level lowered to trace, it seems to me that -436 get skipped due to bloom filter, and i find it strange during an index rebuild phase. I repeat, I have just a very vague sense of how the internal mechanism works, so it could be perfectly fine and I could be completely wrong, that's why I'm writing this as a comment :-) Sensitive (to me) parts of the logs follows: INFO [RMI TCP Connection(6)-194.116.72.170] 2013-04-22 11:21:31,491 ColumnFamilyStore.java (line 552) User Requested secondary index re-build for goh_master/agents indexes INFO [RMI TCP Connection(6)-194.116.72.170] 2013-04-22 11:21:31,491 SecondaryIndexManager.java (line 136) Submitting index build of [agents_station_id] for data in SSTableReader(path='/var/lib/cassandra/data/goh_master/agents/goh_master-agents-ib-435-Data.db'), SSTableReader(path='/var/lib/cassandra/data/goh_master/agents/goh_master-agents-ib-436-Data.db') DEBUG [CompactionExecutor:4] 2013-04-22 11:21:31,493 Table.java (line 412) Indexing row a4a0c7d4-a1e9-11e2-a860-aacc0216 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,493 CollationController.java (line 233) collectAllData TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,493 SSTableReader.java (line 748) Cache hit for KeyCacheKey(/var/lib/cassandra/data/goh_master/agents/goh_master-agents-ib-435, 61346130633764342d613165392d313165322d613836302d616163633030303030323136) - org.apache.cassandra.db.RowIndexEntry@39b0595c TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,493 SliceQueryFilter.java (line 161) collecting 0 of 1: :false:0@136604087967 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,493 SliceQueryFilter.java (line 161) collecting 1 of 1: component_id:false:3@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,494 SliceQueryFilter.java (line 161) collecting 2 of 1: corporation_id:false:36@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,494 SliceQueryFilter.java (line 161) collecting 3 of 1: entity_id:false:1@136604087967 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,494 SliceQueryFilter.java (line 161) collecting 4 of 1: name:false:6@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,494 SliceQueryFilter.java (line 161) collecting 5 of 1: name_check:false:6@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,495 SliceQueryFilter.java (line 161) collecting 6 of 1: station_id:false:36@136604087967 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,495 SliceQueryFilter.java (line 161) collecting 7 of 1: stats_intellect:false:1@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,495 SliceQueryFilter.java (line 161) collecting 8 of 1: stats_reflexes:false:1@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,495 SliceQueryFilter.java (line 161) collecting 9 of 1: stats_stamina:false:1@136560356360 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,495 SliceQueryFilter.java (line 161) collecting 10 of 1: stats_technology:false:1@136560356360 DEBUG [CompactionExecutor:4] 2013-04-22 11:21:31,496 Table.java (line 412) Indexing row 5315b187-bc33-4747-997a-dcc7bd60d768 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,496 CollationController.java (line 233) collectAllData TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,496 SSTableReader.java (line 748) Cache hit for KeyCacheKey(/var/lib/cassandra/data/goh_master/agents/goh_master-agents-ib-435, 35333135623138372d62632d343734372d393937612d646363376264363064373638) - org.apache.cassandra.db.RowIndexEntry@6ee09a07 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,496 SliceQueryFilter.java (line 161) collecting 0 of 1: :false:0@1366568185181000 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,496 SliceQueryFilter.java (line 161) collecting 1 of 1: character_points:false:3@1364580381572000 [...lots of these repeated until...] DEBUG [CompactionExecutor:4] 2013-04-22 11:21:31,642 Table.java (line 412) Indexing row 7b594dc0-a901-11e2-80b4-aacc0201 TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,642 CollationController.java (line 233) collectAllData TRACE [CompactionExecutor:4] 2013-04-22 11:21:31,642 SSTableReader.java (line 748) Cache hit for KeyCacheKey(/var/lib/cassandra/data/goh_master/agents/goh_master-agents-ib-436, 37623539346463302d613930312d313165322d383062342d616163633030303030323031) -
[jira] [Updated] (CASSANDRA-5501) Missing data on SELECT on secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-5501: --- Description: We have a 3 nodes cluster, and a keyspace with RF = 3. From cassandra-cli everything is fine (we actually never use it, I just launched it for a check in this particular case). [default@goh_master] get agents where station_id = ascii(1110129); --- RowKey: 6c8efeb6-7209-11e2-890a-aacc0216 = (column=, value=, timestamp=1364580868176000) = (column=character_points, value=, timestamp=136103068689) = (column=component_id, value=0, timestamp=1364580868176000) = (column=corporation_id, value=3efc729e-7209-11e2-890a-aacc0216, timestamp=136103068689) = (column=entity_id, value=0, timestamp=1364580868176000) = (column=manufacturing, value=, timestamp=136103068689) = (column=model, value=55, timestamp=136103068689) = (column=name, value=Jenny Olifield, timestamp=136103068689) = (column=name_check, value=jenny_olifield, timestamp=136103068689) = (column=station_id, value=1110129, timestamp=1364580868176000) = (column=stats_intellect, value=8, timestamp=136103068689) = (column=stats_reflexes, value=8, timestamp=136103068689) = (column=stats_stamina, value=7, timestamp=136103068689) = (column=stats_technology, value=7, timestamp=136103068689) = (column=trading, value=, timestamp=136103068689) --- RowKey: dc413373-6b06-11e2-8943-aacc0216 = (column=, value=, timestamp=136656818522) = (column=character_points, value=100, timestamp=1364580381651000) = (column=component_id, value=, timestamp=1364580381651000) = (column=corporation_id, value=574934cc-6b06-11e2-a512-aacc0200, timestamp=1364580381651000) = (column=entity_id, value=0, timestamp=1364580381651000) = (column=manufacturing, value=, timestamp=1364580381651000) = (column=model, value=500018, timestamp=1364580381651000) = (column=name, value=Darren Matar, timestamp=1364580381651000) = (column=name_check, value=darren_matar, timestamp=1364580381651000) = (column=station_id, value=1110129, timestamp=1364580381651000) = (column=stats_intellect, value=10, timestamp=1364580381651000) = (column=stats_reflexes, value=10, timestamp=1364580381651000) = (column=stats_stamina, value=10, timestamp=1364580381651000) = (column=stats_technology, value=10, timestamp=1364580381651000) = (column=trading, value=1, timestamp=136656818522) --- RowKey: 0e7074ac-64bd-11e2-8c38-aacc0201 = (column=, value=, timestamp=1364828039093000) = (column=character_points, value=, timestamp=136103068676) = (column=component_id, value=0, timestamp=1364828039093000) = (column=corporation_id, value=e398294e-64bc-11e2-8c38-aacc0201, timestamp=136103068676) = (column=entity_id, value=0, timestamp=1364828039093000) = (column=manufacturing, value=1, timestamp=1362517535613000) = (column=model, value=58, timestamp=136103068676) = (column=name, value=Tom Bishop, timestamp=136103068676) = (column=name_check, value=tom_bishop, timestamp=136103068676) = (column=station_id, value=1110129, timestamp=1364828039093000) = (column=stats_intellect, value=9, timestamp=136103068676) = (column=stats_reflexes, value=7, timestamp=136103068676) = (column=stats_stamina, value=5, timestamp=136103068676) = (column=stats_technology, value=9, timestamp=136103068676) = (column=trading, value=, timestamp=136103068676) --- RowKey: 1b462f09-65f3-4148-a1a6-536b52b3bcfa = (column=, value=, timestamp=1366568185096000) = (column=character_points, value=100, timestamp=1364580381537000) = (column=component_id, value=, timestamp=1364580381537000) = (column=corporation_id, value=1d2a8803-d139-4b50-85eb-92cb1082de2e, timestamp=1364580381537000) = (column=entity_id, value=0, timestamp=1364580381537000) = (column=manufacturing, value=, timestamp=1364580381537000) = (column=model, value=53, timestamp=1364580381537000) = (column=name, value=Andrea Len, timestamp=1364580381537000) = (column=name_check, value=andrea_len, timestamp=1364580381537000) = (column=station_id, value=1110129, timestamp=1364580381537000) = (column=stats_intellect, value=10, timestamp=1364580381537000) = (column=stats_reflexes, value=10, timestamp=1364580381537000) = (column=stats_stamina, value=10, timestamp=1364580381537000) = (column=stats_technology, value=10, timestamp=1364580381537000) = (column=trading, value=1, timestamp=1366568185096000) 4 Rows Returned. From CQLSH, hovewer, the result is different, and 2 rows are missing. cqlsh:goh_master select agent_id,name,station_id from agents where station_id='1110129'; agent_id | name | station_id --++ 6c8efeb6-7209-11e2-890a-aacc0216 | Jenny Olifield |1110129
[jira] [Updated] (CASSANDRA-5501) Missing data on SELECT on secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-5501: --- Attachment: query_log.txt Missing data on SELECT on secondary index -- Key: CASSANDRA-5501 URL: https://issues.apache.org/jira/browse/CASSANDRA-5501 Project: Cassandra Issue Type: Bug Affects Versions: 1.2.4 Environment: linux ubuntu 12.04 Reporter: Marco Matarazzo Attachments: query_log.txt We have a 3 nodes cluster, and a keyspace with RF = 3. From cassandra-cli everything is fine (we actually never use it, I just launched it for a check in this particular case). [default@goh_master] get agents where station_id = ascii(1110129); --- RowKey: 6c8efeb6-7209-11e2-890a-aacc0216 = (column=, value=, timestamp=1364580868176000) = (column=character_points, value=, timestamp=136103068689) = (column=component_id, value=0, timestamp=1364580868176000) = (column=corporation_id, value=3efc729e-7209-11e2-890a-aacc0216, timestamp=136103068689) = (column=entity_id, value=0, timestamp=1364580868176000) = (column=manufacturing, value=, timestamp=136103068689) = (column=model, value=55, timestamp=136103068689) = (column=name, value=Jenny Olifield, timestamp=136103068689) = (column=name_check, value=jenny_olifield, timestamp=136103068689) = (column=station_id, value=1110129, timestamp=1364580868176000) = (column=stats_intellect, value=8, timestamp=136103068689) = (column=stats_reflexes, value=8, timestamp=136103068689) = (column=stats_stamina, value=7, timestamp=136103068689) = (column=stats_technology, value=7, timestamp=136103068689) = (column=trading, value=, timestamp=136103068689) --- RowKey: dc413373-6b06-11e2-8943-aacc0216 = (column=, value=, timestamp=136656818522) = (column=character_points, value=100, timestamp=1364580381651000) = (column=component_id, value=, timestamp=1364580381651000) = (column=corporation_id, value=574934cc-6b06-11e2-a512-aacc0200, timestamp=1364580381651000) = (column=entity_id, value=0, timestamp=1364580381651000) = (column=manufacturing, value=, timestamp=1364580381651000) = (column=model, value=500018, timestamp=1364580381651000) = (column=name, value=Darren Matar, timestamp=1364580381651000) = (column=name_check, value=darren_matar, timestamp=1364580381651000) = (column=station_id, value=1110129, timestamp=1364580381651000) = (column=stats_intellect, value=10, timestamp=1364580381651000) = (column=stats_reflexes, value=10, timestamp=1364580381651000) = (column=stats_stamina, value=10, timestamp=1364580381651000) = (column=stats_technology, value=10, timestamp=1364580381651000) = (column=trading, value=1, timestamp=136656818522) --- RowKey: 0e7074ac-64bd-11e2-8c38-aacc0201 = (column=, value=, timestamp=1364828039093000) = (column=character_points, value=, timestamp=136103068676) = (column=component_id, value=0, timestamp=1364828039093000) = (column=corporation_id, value=e398294e-64bc-11e2-8c38-aacc0201, timestamp=136103068676) = (column=entity_id, value=0, timestamp=1364828039093000) = (column=manufacturing, value=1, timestamp=1362517535613000) = (column=model, value=58, timestamp=136103068676) = (column=name, value=Tom Bishop, timestamp=136103068676) = (column=name_check, value=tom_bishop, timestamp=136103068676) = (column=station_id, value=1110129, timestamp=1364828039093000) = (column=stats_intellect, value=9, timestamp=136103068676) = (column=stats_reflexes, value=7, timestamp=136103068676) = (column=stats_stamina, value=5, timestamp=136103068676) = (column=stats_technology, value=9, timestamp=136103068676) = (column=trading, value=, timestamp=136103068676) --- RowKey: 1b462f09-65f3-4148-a1a6-536b52b3bcfa = (column=, value=, timestamp=1366568185096000) = (column=character_points, value=100, timestamp=1364580381537000) = (column=component_id, value=, timestamp=1364580381537000) = (column=corporation_id, value=1d2a8803-d139-4b50-85eb-92cb1082de2e, timestamp=1364580381537000) = (column=entity_id, value=0, timestamp=1364580381537000) = (column=manufacturing, value=, timestamp=1364580381537000) = (column=model, value=53, timestamp=1364580381537000) = (column=name, value=Andrea Len, timestamp=1364580381537000) = (column=name_check, value=andrea_len, timestamp=1364580381537000) = (column=station_id, value=1110129, timestamp=1364580381537000) = (column=stats_intellect, value=10, timestamp=1364580381537000) = (column=stats_reflexes, value=10, timestamp=1364580381537000) = (column=stats_stamina, value=10, timestamp=1364580381537000) = (column=stats_technology, value=10,
[jira] [Updated] (CASSANDRA-5501) Missing data on SELECT on secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-5501: --- Description: We have a 3 nodes cluster, and a keyspace with RF = 3. From cassandra-cli everything is fine (we actually never use it, I just launched it for a check in this particular case). [default@goh_master] get agents where station_id = ascii(1110129); --- RowKey: 6c8efeb6-7209-11e2-890a-aacc0216 = (column=, value=, timestamp=1364580868176000) = (column=character_points, value=, timestamp=136103068689) = (column=component_id, value=0, timestamp=1364580868176000) = (column=corporation_id, value=3efc729e-7209-11e2-890a-aacc0216, timestamp=136103068689) = (column=entity_id, value=0, timestamp=1364580868176000) = (column=manufacturing, value=, timestamp=136103068689) = (column=model, value=55, timestamp=136103068689) = (column=name, value=Jenny Olifield, timestamp=136103068689) = (column=name_check, value=jenny_olifield, timestamp=136103068689) = (column=station_id, value=1110129, timestamp=1364580868176000) = (column=stats_intellect, value=8, timestamp=136103068689) = (column=stats_reflexes, value=8, timestamp=136103068689) = (column=stats_stamina, value=7, timestamp=136103068689) = (column=stats_technology, value=7, timestamp=136103068689) = (column=trading, value=, timestamp=136103068689) --- RowKey: dc413373-6b06-11e2-8943-aacc0216 = (column=, value=, timestamp=136656818522) = (column=character_points, value=100, timestamp=1364580381651000) = (column=component_id, value=, timestamp=1364580381651000) = (column=corporation_id, value=574934cc-6b06-11e2-a512-aacc0200, timestamp=1364580381651000) = (column=entity_id, value=0, timestamp=1364580381651000) = (column=manufacturing, value=, timestamp=1364580381651000) = (column=model, value=500018, timestamp=1364580381651000) = (column=name, value=Darren Matar, timestamp=1364580381651000) = (column=name_check, value=darren_matar, timestamp=1364580381651000) = (column=station_id, value=1110129, timestamp=1364580381651000) = (column=stats_intellect, value=10, timestamp=1364580381651000) = (column=stats_reflexes, value=10, timestamp=1364580381651000) = (column=stats_stamina, value=10, timestamp=1364580381651000) = (column=stats_technology, value=10, timestamp=1364580381651000) = (column=trading, value=1, timestamp=136656818522) --- RowKey: 0e7074ac-64bd-11e2-8c38-aacc0201 = (column=, value=, timestamp=1364828039093000) = (column=character_points, value=, timestamp=136103068676) = (column=component_id, value=0, timestamp=1364828039093000) = (column=corporation_id, value=e398294e-64bc-11e2-8c38-aacc0201, timestamp=136103068676) = (column=entity_id, value=0, timestamp=1364828039093000) = (column=manufacturing, value=1, timestamp=1362517535613000) = (column=model, value=58, timestamp=136103068676) = (column=name, value=Tom Bishop, timestamp=136103068676) = (column=name_check, value=tom_bishop, timestamp=136103068676) = (column=station_id, value=1110129, timestamp=1364828039093000) = (column=stats_intellect, value=9, timestamp=136103068676) = (column=stats_reflexes, value=7, timestamp=136103068676) = (column=stats_stamina, value=5, timestamp=136103068676) = (column=stats_technology, value=9, timestamp=136103068676) = (column=trading, value=, timestamp=136103068676) --- RowKey: 1b462f09-65f3-4148-a1a6-536b52b3bcfa = (column=, value=, timestamp=1366568185096000) = (column=character_points, value=100, timestamp=1364580381537000) = (column=component_id, value=, timestamp=1364580381537000) = (column=corporation_id, value=1d2a8803-d139-4b50-85eb-92cb1082de2e, timestamp=1364580381537000) = (column=entity_id, value=0, timestamp=1364580381537000) = (column=manufacturing, value=, timestamp=1364580381537000) = (column=model, value=53, timestamp=1364580381537000) = (column=name, value=Andrea Len, timestamp=1364580381537000) = (column=name_check, value=andrea_len, timestamp=1364580381537000) = (column=station_id, value=1110129, timestamp=1364580381537000) = (column=stats_intellect, value=10, timestamp=1364580381537000) = (column=stats_reflexes, value=10, timestamp=1364580381537000) = (column=stats_stamina, value=10, timestamp=1364580381537000) = (column=stats_technology, value=10, timestamp=1364580381537000) = (column=trading, value=1, timestamp=1366568185096000) 4 Rows Returned. From CQLSH, hovewer, the result is different, and 2 rows are missing. cqlsh:goh_master select agent_id,name,station_id from agents where station_id='1110129'; agent_id | name | station_id --++ 6c8efeb6-7209-11e2-890a-aacc0216 | Jenny Olifield |1110129
[jira] [Updated] (CASSANDRA-5501) Missing data on SELECT on secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-5501: --- Description: We have a 3 nodes cluster, and a keyspace with RF = 3. From cassandra-cli everything is fine (we actually never use it, I just launched it for a check in this particular case). [default@goh_master] get agents where station_id = ascii(1110129); --- RowKey: 6c8efeb6-7209-11e2-890a-aacc0216 = (column=, value=, timestamp=1364580868176000) = (column=character_points, value=, timestamp=136103068689) = (column=component_id, value=0, timestamp=1364580868176000) = (column=corporation_id, value=3efc729e-7209-11e2-890a-aacc0216, timestamp=136103068689) = (column=entity_id, value=0, timestamp=1364580868176000) = (column=manufacturing, value=, timestamp=136103068689) = (column=model, value=55, timestamp=136103068689) = (column=name, value=Jenny Olifield, timestamp=136103068689) = (column=name_check, value=jenny_olifield, timestamp=136103068689) = (column=station_id, value=1110129, timestamp=1364580868176000) = (column=stats_intellect, value=8, timestamp=136103068689) = (column=stats_reflexes, value=8, timestamp=136103068689) = (column=stats_stamina, value=7, timestamp=136103068689) = (column=stats_technology, value=7, timestamp=136103068689) = (column=trading, value=, timestamp=136103068689) --- RowKey: dc413373-6b06-11e2-8943-aacc0216 = (column=, value=, timestamp=136656818522) = (column=character_points, value=100, timestamp=1364580381651000) = (column=component_id, value=, timestamp=1364580381651000) = (column=corporation_id, value=574934cc-6b06-11e2-a512-aacc0200, timestamp=1364580381651000) = (column=entity_id, value=0, timestamp=1364580381651000) = (column=manufacturing, value=, timestamp=1364580381651000) = (column=model, value=500018, timestamp=1364580381651000) = (column=name, value=Darren Matar, timestamp=1364580381651000) = (column=name_check, value=darren_matar, timestamp=1364580381651000) = (column=station_id, value=1110129, timestamp=1364580381651000) = (column=stats_intellect, value=10, timestamp=1364580381651000) = (column=stats_reflexes, value=10, timestamp=1364580381651000) = (column=stats_stamina, value=10, timestamp=1364580381651000) = (column=stats_technology, value=10, timestamp=1364580381651000) = (column=trading, value=1, timestamp=136656818522) --- RowKey: 0e7074ac-64bd-11e2-8c38-aacc0201 = (column=, value=, timestamp=1364828039093000) = (column=character_points, value=, timestamp=136103068676) = (column=component_id, value=0, timestamp=1364828039093000) = (column=corporation_id, value=e398294e-64bc-11e2-8c38-aacc0201, timestamp=136103068676) = (column=entity_id, value=0, timestamp=1364828039093000) = (column=manufacturing, value=1, timestamp=1362517535613000) = (column=model, value=58, timestamp=136103068676) = (column=name, value=Tom Bishop, timestamp=136103068676) = (column=name_check, value=tom_bishop, timestamp=136103068676) = (column=station_id, value=1110129, timestamp=1364828039093000) = (column=stats_intellect, value=9, timestamp=136103068676) = (column=stats_reflexes, value=7, timestamp=136103068676) = (column=stats_stamina, value=5, timestamp=136103068676) = (column=stats_technology, value=9, timestamp=136103068676) = (column=trading, value=, timestamp=136103068676) --- RowKey: 1b462f09-65f3-4148-a1a6-536b52b3bcfa = (column=, value=, timestamp=1366568185096000) = (column=character_points, value=100, timestamp=1364580381537000) = (column=component_id, value=, timestamp=1364580381537000) = (column=corporation_id, value=1d2a8803-d139-4b50-85eb-92cb1082de2e, timestamp=1364580381537000) = (column=entity_id, value=0, timestamp=1364580381537000) = (column=manufacturing, value=, timestamp=1364580381537000) = (column=model, value=53, timestamp=1364580381537000) = (column=name, value=Andrea Len, timestamp=1364580381537000) = (column=name_check, value=andrea_len, timestamp=1364580381537000) = (column=station_id, value=1110129, timestamp=1364580381537000) = (column=stats_intellect, value=10, timestamp=1364580381537000) = (column=stats_reflexes, value=10, timestamp=1364580381537000) = (column=stats_stamina, value=10, timestamp=1364580381537000) = (column=stats_technology, value=10, timestamp=1364580381537000) = (column=trading, value=1, timestamp=1366568185096000) 4 Rows Returned. From CQLSH, hovewer, the result is different, and 2 rows are missing. cqlsh:goh_master select agent_id,name,station_id from agents where station_id='1110129'; agent_id | name | station_id --++ 6c8efeb6-7209-11e2-890a-aacc0216 | Jenny Olifield |1110129
[jira] [Created] (CASSANDRA-5501) Missing data on SELECT on secondary index
Marco Matarazzo created CASSANDRA-5501: -- Summary: Missing data on SELECT on secondary index Key: CASSANDRA-5501 URL: https://issues.apache.org/jira/browse/CASSANDRA-5501 Project: Cassandra Issue Type: Bug Affects Versions: 1.2.4 Environment: linux ubuntu 12.04 Reporter: Marco Matarazzo We have a 3 nodes cluster, and a keyspace with RF = 3. From cassandra-cli everything is fine (we actually never use it, I just launched it for a check in this particular case). [default@goh_master] get agents where station_id = ascii(1110129); --- RowKey: 6c8efeb6-7209-11e2-890a-aacc0216 = (column=, value=, timestamp=1364580868176000) = (column=character_points, value=, timestamp=136103068689) = (column=component_id, value=0, timestamp=1364580868176000) = (column=corporation_id, value=3efc729e-7209-11e2-890a-aacc0216, timestamp=136103068689) = (column=entity_id, value=0, timestamp=1364580868176000) = (column=manufacturing, value=, timestamp=136103068689) = (column=model, value=55, timestamp=136103068689) = (column=name, value=Jenny Olifield, timestamp=136103068689) = (column=name_check, value=jenny_olifield, timestamp=136103068689) = (column=station_id, value=1110129, timestamp=1364580868176000) = (column=stats_intellect, value=8, timestamp=136103068689) = (column=stats_reflexes, value=8, timestamp=136103068689) = (column=stats_stamina, value=7, timestamp=136103068689) = (column=stats_technology, value=7, timestamp=136103068689) = (column=trading, value=, timestamp=136103068689) --- RowKey: dc413373-6b06-11e2-8943-aacc0216 = (column=, value=, timestamp=136656818522) = (column=character_points, value=100, timestamp=1364580381651000) = (column=component_id, value=, timestamp=1364580381651000) = (column=corporation_id, value=574934cc-6b06-11e2-a512-aacc0200, timestamp=1364580381651000) = (column=entity_id, value=0, timestamp=1364580381651000) = (column=manufacturing, value=, timestamp=1364580381651000) = (column=model, value=500018, timestamp=1364580381651000) = (column=name, value=Darren Matar, timestamp=1364580381651000) = (column=name_check, value=darren_matar, timestamp=1364580381651000) = (column=station_id, value=1110129, timestamp=1364580381651000) = (column=stats_intellect, value=10, timestamp=1364580381651000) = (column=stats_reflexes, value=10, timestamp=1364580381651000) = (column=stats_stamina, value=10, timestamp=1364580381651000) = (column=stats_technology, value=10, timestamp=1364580381651000) = (column=trading, value=1, timestamp=136656818522) --- RowKey: 0e7074ac-64bd-11e2-8c38-aacc0201 = (column=, value=, timestamp=1364828039093000) = (column=character_points, value=, timestamp=136103068676) = (column=component_id, value=0, timestamp=1364828039093000) = (column=corporation_id, value=e398294e-64bc-11e2-8c38-aacc0201, timestamp=136103068676) = (column=entity_id, value=0, timestamp=1364828039093000) = (column=manufacturing, value=1, timestamp=1362517535613000) = (column=model, value=58, timestamp=136103068676) = (column=name, value=Tom Bishop, timestamp=136103068676) = (column=name_check, value=tom_bishop, timestamp=136103068676) = (column=station_id, value=1110129, timestamp=1364828039093000) = (column=stats_intellect, value=9, timestamp=136103068676) = (column=stats_reflexes, value=7, timestamp=136103068676) = (column=stats_stamina, value=5, timestamp=136103068676) = (column=stats_technology, value=9, timestamp=136103068676) = (column=trading, value=, timestamp=136103068676) --- RowKey: 1b462f09-65f3-4148-a1a6-536b52b3bcfa = (column=, value=, timestamp=1366568185096000) = (column=character_points, value=100, timestamp=1364580381537000) = (column=component_id, value=, timestamp=1364580381537000) = (column=corporation_id, value=1d2a8803-d139-4b50-85eb-92cb1082de2e, timestamp=1364580381537000) = (column=entity_id, value=0, timestamp=1364580381537000) = (column=manufacturing, value=, timestamp=1364580381537000) = (column=model, value=53, timestamp=1364580381537000) = (column=name, value=Andrea Len, timestamp=1364580381537000) = (column=name_check, value=andrea_len, timestamp=1364580381537000) = (column=station_id, value=1110129, timestamp=1364580381537000) = (column=stats_intellect, value=10, timestamp=1364580381537000) = (column=stats_reflexes, value=10, timestamp=1364580381537000) = (column=stats_stamina, value=10, timestamp=1364580381537000) = (column=stats_technology, value=10, timestamp=1364580381537000) = (column=trading, value=1, timestamp=1366568185096000) 4 Rows Returned. From CQLSH, hovewer, the result is different, and 2 rows are missing. cqlsh:goh_master select agent_id,name,station_id from agents where station_id='1110129'; agent_id
[jira] [Commented] (CASSANDRA-5329) Repair -pr with vnodes incompatibilty
[ https://issues.apache.org/jira/browse/CASSANDRA-5329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13598853#comment-13598853 ] Marco Matarazzo commented on CASSANDRA-5329: I second this, we see exactly the same behaviour. Repair -pr with vnodes incompatibilty - Key: CASSANDRA-5329 URL: https://issues.apache.org/jira/browse/CASSANDRA-5329 Project: Cassandra Issue Type: Bug Affects Versions: 1.2.2 Reporter: julien campan Hi, I have a cluster on 1.2.2 . This cluster is composed of 16 nodes in two datacenters (8 and 8) with an RF 3 :3. I used virtual nodes, 256 on each node. When I do “repair –pr on a node, I can see that it’s doing repair only on the first vnode : [2013-03-07 14:42:56,922] Starting repair command #7, repairing 1 ranges for keyspace pns_fr [2013-03-07 14:42:57,835] Repair session eb38dfa0-872c-11e2-af2d-f36fae36bab1 for range (-9064588501660224828,-9063047458265491057] finished [2013-03-07 14:42:57,835] Repair command #7 finished [2013-03-07 14:42:57,852] Starting repair command #8, repairing 1 ranges for keyspace hbxtest [2013-03-07 14:42:59,307] Repair session ebc6c7c0-872c-11e2-af2d-f36fae36bab1 for range (-9064588501660224828,-9063047458265491057] finished So if I understand well, when I do a repair –pr on each node, I will repair only the first vnode on each node. (16 token ranges on 4096 ranges). This method doesn’t guarantee the consistency of the dataset. It seems to me that the repair –pr is not compatible with vnode cluster. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-5300) Insufficient validation of UPDATE queries against counter cfs
[
https://issues.apache.org/jira/browse/CASSANDRA-5300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13590389#comment-13590389
]
Marco Matarazzo commented on CASSANDRA-5300:
I was hoping this was a feature, and was about to be extended to INSERT too, it
can be very useful during table initialization/import using COPY FROM on cqlsh
or just a bunch of saved CQL.
Insufficient validation of UPDATE queries against counter cfs
-
Key: CASSANDRA-5300
URL: https://issues.apache.org/jira/browse/CASSANDRA-5300
Project: Cassandra
Issue Type: Bug
Components: Core
Affects Versions: 1.2.0
Reporter: Aleksey Yeschenko
Assignee: Aleksey Yeschenko
Fix For: 1.2.3
Attachments: 5300.txt
{noformat}
CREATE TABLE demo (
id int PRIMARY KEY,
c counter
)
{noformat}
This is expected:
{noformat}
insert into demo (id, c) VALUES ( 0, 20);
Bad Request: INSERT statement are not allowed on counter tables, use UPDATE
instead
{noformat}
This should also be forbidden, but it is not:
{noformat}
update demo set c = 20 where id = 0;
select * from demo;
id | c
+
0 | 20
{noformat}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4674) cqlsh COPY TO and COPY FROM don't work with cql3
[ https://issues.apache.org/jira/browse/CASSANDRA-4674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13476079#comment-13476079 ] Marco Matarazzo commented on CASSANDRA-4674: Well, We would love to have it fixed. cqlsh COPY TO and COPY FROM don't work with cql3 Key: CASSANDRA-4674 URL: https://issues.apache.org/jira/browse/CASSANDRA-4674 Project: Cassandra Issue Type: Bug Affects Versions: 1.2.0 Reporter: Aleksey Yeschenko Assignee: Aleksey Yeschenko Labels: cqlsh cqlsh COPY TO and COPY FROM don't work with cql3 due to previous cql3 changes. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4674) cqlsh COPY TO and COPY FROM don't work with cql3
[ https://issues.apache.org/jira/browse/CASSANDRA-4674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13476239#comment-13476239 ] Marco Matarazzo commented on CASSANDRA-4674: I realized I hijacked another ticket thinking that mine was a well-known problem, when it's obvious it's not. I'm very sorry about that. I have some specific column families on which COPY FROM does not work from cqlsh -3, and works perfectly with cqlsh -2. If it's ok with you, I'll hunt down the condition that makes it not work and, as soon as I have them pinned down, I will open a new bug. Again, I'm sorry about that. cqlsh COPY TO and COPY FROM don't work with cql3 Key: CASSANDRA-4674 URL: https://issues.apache.org/jira/browse/CASSANDRA-4674 Project: Cassandra Issue Type: Bug Affects Versions: 1.2.0 Reporter: Aleksey Yeschenko Assignee: Aleksey Yeschenko Labels: cqlsh cqlsh COPY TO and COPY FROM don't work with cql3 due to previous cql3 changes. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4472) Can't add secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13431000#comment-13431000 ] Marco Matarazzo commented on CASSANDRA-4472: It's sure we was reading and writing from various CF, maybe even the same we was trying to modify. Surely no one else was modifying the schema. Alas, I don't know more than this. I tried creating the index both with and without specifying the index name, and either way it didn't work. What I did is trying to snapshot the problem: I made a .tgz of /var/lib/cassandra directory, and it seems that moving it on a clean cassandra 1.1.2 node does make the problem appear again. I could try to pass you this archive. I didn't have time to try with 1.1.3, tough. Maybe the first thing to do is to see if the problem solves upgrading to 1.1.3. Can't add secondary index - Key: CASSANDRA-4472 URL: https://issues.apache.org/jira/browse/CASSANDRA-4472 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Environment: Ubuntu LTS 12.04 Reporter: Marco Matarazzo Assignee: Pavel Yaskevich Fix For: 1.1.4 Attachments: system.log It seems connected to CASSANDRA-4461 (and CASSANDRA-4471), but symptoms are different so I open a separate bug. It may be the same problem, though. Applying CASSANDRA-4432 seems not to solve the issue. It seems I can't create secondary indexes on any CF. Reading and wrting data works, creating and dropping tables works. Adding new indexes, no longer works, and I get no errors and nothing in logs that (to me) seems an error. This happens on a single node cassandra installation, on Ubuntu LTS 12.04. cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); cqlsh:goh_master create index on users (admin); cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); Interestingly enough, I can create new columnfamilies and add indexes to them: cqlsh:goh_master create table test (id ascii, value ascii, PRIMARY KEY(id)); cqlsh:goh_master DESCRIBE TABLE test; CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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'; cqlsh:goh_master create index test_value ON test (value); ^[[A^[[Acqlsh:goh_DESCRIBE TABLE test;(value); CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 test_value ON test (value); cqlsh:goh_master -- 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-4472) Can't add secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13431157#comment-13431157 ] Marco Matarazzo commented on CASSANDRA-4472: Pavel, updating to 1.1.3 did solve the problem. Thank you. Can't add secondary index - Key: CASSANDRA-4472 URL: https://issues.apache.org/jira/browse/CASSANDRA-4472 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Environment: Ubuntu LTS 12.04 Reporter: Marco Matarazzo Assignee: Pavel Yaskevich Fix For: 1.1.4 Attachments: system.log It seems connected to CASSANDRA-4461 (and CASSANDRA-4471), but symptoms are different so I open a separate bug. It may be the same problem, though. Applying CASSANDRA-4432 seems not to solve the issue. It seems I can't create secondary indexes on any CF. Reading and wrting data works, creating and dropping tables works. Adding new indexes, no longer works, and I get no errors and nothing in logs that (to me) seems an error. This happens on a single node cassandra installation, on Ubuntu LTS 12.04. cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); cqlsh:goh_master create index on users (admin); cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); Interestingly enough, I can create new columnfamilies and add indexes to them: cqlsh:goh_master create table test (id ascii, value ascii, PRIMARY KEY(id)); cqlsh:goh_master DESCRIBE TABLE test; CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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'; cqlsh:goh_master create index test_value ON test (value); ^[[A^[[Acqlsh:goh_DESCRIBE TABLE test;(value); CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 test_value ON test (value); cqlsh:goh_master -- 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-4471) Unable to drop keyspace
[ https://issues.apache.org/jira/browse/CASSANDRA-4471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13424962#comment-13424962 ] Marco Matarazzo commented on CASSANDRA-4471: Exactly the same problem we got. I had to close the bug as I can't reproduce it (we had to move forward, zap the db and start over with a dump) but if you can nail it down, it would be wonderful. And I confirm that, when it happens, it's a keyspace-specific problem. Unable to drop keyspace --- Key: CASSANDRA-4471 URL: https://issues.apache.org/jira/browse/CASSANDRA-4471 Project: Cassandra Issue Type: Bug Components: Core Affects Versions: 1.1.2 Environment: Debian 6, cassandra.apache.org binary package Reporter: Tuure Laurinolli Drop keyspace command completes without error but the keyspace is not removed. Reproduced both using cassandra-cli and pycassa. Drop as observed from command line: [default@unknown] show keyspaces; Keyspace: system: Replication Strategy: org.apache.cassandra.locator.LocalStrategy Durable Writes: true Options: [] Column Families: ColumnFamily: HintsColumnFamily (Super) hinted handoff data Key Validation Class: org.apache.cassandra.db.marshal.BytesType Default column value validator: org.apache.cassandra.db.marshal.BytesType Columns sorted by: org.apache.cassandra.db.marshal.BytesType/org.apache.cassandra.db.marshal.BytesType GC grace seconds: 0 Compaction min/max thresholds: 4/32 Read repair chance: 0.0 DC Local Read repair chance: 0.0 Replicate on write: true Caching: KEYS_ONLY Bloom Filter FP chance: default Built indexes: [] Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy ColumnFamily: IndexInfo indexes that have been completed Key Validation Class: org.apache.cassandra.db.marshal.BytesType Default column value validator: org.apache.cassandra.db.marshal.BytesType Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type GC grace seconds: 0 Compaction min/max thresholds: 4/32 Read repair chance: 0.0 DC Local Read repair chance: 0.0 Replicate on write: true Caching: KEYS_ONLY Bloom Filter FP chance: default Built indexes: [] Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy ColumnFamily: LocationInfo persistent metadata for the local node Key Validation Class: org.apache.cassandra.db.marshal.BytesType Default column value validator: org.apache.cassandra.db.marshal.BytesType Columns sorted by: org.apache.cassandra.db.marshal.BytesType GC grace seconds: 0 Compaction min/max thresholds: 4/32 Read repair chance: 0.0 DC Local Read repair chance: 0.0 Replicate on write: true Caching: KEYS_ONLY Bloom Filter FP chance: default Built indexes: [] Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy ColumnFamily: Migrations individual schema mutations Key Validation Class: org.apache.cassandra.db.marshal.BytesType Default column value validator: org.apache.cassandra.db.marshal.BytesType Columns sorted by: org.apache.cassandra.db.marshal.TimeUUIDType GC grace seconds: 0 Compaction min/max thresholds: 4/32 Read repair chance: 0.0 DC Local Read repair chance: 0.0 Replicate on write: true Caching: KEYS_ONLY Bloom Filter FP chance: default Built indexes: [] Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy ColumnFamily: NodeIdInfo nodeId and their metadata Key Validation Class: org.apache.cassandra.db.marshal.BytesType Default column value validator: org.apache.cassandra.db.marshal.BytesType Columns sorted by: org.apache.cassandra.db.marshal.TimeUUIDType GC grace seconds: 0 Compaction min/max thresholds: 4/32 Read repair chance: 0.0 DC Local Read repair chance: 0.0 Replicate on write: true Caching: KEYS_ONLY Bloom Filter FP chance: default Built indexes: [] Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy ColumnFamily: Schema current state of the schema Key Validation Class: org.apache.cassandra.db.marshal.BytesType Default column value validator: org.apache.cassandra.db.marshal.BytesType Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type GC grace seconds: 0 Compaction min/max thresholds: 4/32 Read repair chance: 0.0 DC Local Read repair
[jira] [Created] (CASSANDRA-4472) Can't add secondary index
Marco Matarazzo created CASSANDRA-4472: -- Summary: Can't add secondary index Key: CASSANDRA-4472 URL: https://issues.apache.org/jira/browse/CASSANDRA-4472 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Environment: Ubuntu LTS 12.04 Reporter: Marco Matarazzo It seems connected to [CASSANDRA-4461|https://issues.apache.org/jira/browse/CASSANDRA-4461] (and [CASSANDRA-4471|https://issues.apache.org/jira/browse/CASSANDRA-4471]), but symptoms are different so I open a separate bug. It may be the same problem, though. Applying [CASSANDRA-4432|https://issues.apache.org/jira/browse/CASSANDRA-4432] seems not to solve the issue. It seems I can't create secondary indexes on any CF. Reading and wrting data works, creating and dropping tables works. Adding new indexes, no longer works, and I get no errors and nothing in logs that (to me) seems an error. This happens on a single node cassandra installation, on Ubuntu LTS 12.04. cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); cqlsh:goh_master create index on users (admin); cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); Interestingly enough, I can create new columnfamilies and add indexes to them: cqlsh:goh_master create table test (id ascii, value ascii, PRIMARY KEY(id)); cqlsh:goh_master DESCRIBE TABLE test; CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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'; cqlsh:goh_master create index test_value ON test (value); ^[[A^[[Acqlsh:goh_DESCRIBE TABLE test;(value); CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 test_value ON test (value); cqlsh:goh_master -- 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-4472) Can't add secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-4472: --- Attachment: system.log Can't add secondary index - Key: CASSANDRA-4472 URL: https://issues.apache.org/jira/browse/CASSANDRA-4472 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Environment: Ubuntu LTS 12.04 Reporter: Marco Matarazzo Attachments: system.log It seems connected to [CASSANDRA-4461|https://issues.apache.org/jira/browse/CASSANDRA-4461] (and [CASSANDRA-4471|https://issues.apache.org/jira/browse/CASSANDRA-4471]), but symptoms are different so I open a separate bug. It may be the same problem, though. Applying [CASSANDRA-4432|https://issues.apache.org/jira/browse/CASSANDRA-4432] seems not to solve the issue. It seems I can't create secondary indexes on any CF. Reading and wrting data works, creating and dropping tables works. Adding new indexes, no longer works, and I get no errors and nothing in logs that (to me) seems an error. This happens on a single node cassandra installation, on Ubuntu LTS 12.04. cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); cqlsh:goh_master create index on users (admin); cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); Interestingly enough, I can create new columnfamilies and add indexes to them: cqlsh:goh_master create table test (id ascii, value ascii, PRIMARY KEY(id)); cqlsh:goh_master DESCRIBE TABLE test; CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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'; cqlsh:goh_master create index test_value ON test (value); ^[[A^[[Acqlsh:goh_DESCRIBE TABLE test;(value); CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 test_value ON test (value); cqlsh:goh_master -- 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-4472) Can't add secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-4472: --- Description: It seems connected to CASSANDRA-4461 (and CASSANDRA-4471), but symptoms are different so I open a separate bug. It may be the same problem, though. Applying CASSANDRA-4432 seems not to solve the issue. It seems I can't create secondary indexes on any CF. Reading and wrting data works, creating and dropping tables works. Adding new indexes, no longer works, and I get no errors and nothing in logs that (to me) seems an error. This happens on a single node cassandra installation, on Ubuntu LTS 12.04. cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); cqlsh:goh_master create index on users (admin); cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); Interestingly enough, I can create new columnfamilies and add indexes to them: cqlsh:goh_master create table test (id ascii, value ascii, PRIMARY KEY(id)); cqlsh:goh_master DESCRIBE TABLE test; CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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'; cqlsh:goh_master create index test_value ON test (value); ^[[A^[[Acqlsh:goh_DESCRIBE TABLE test;(value); CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 test_value ON test (value); cqlsh:goh_master was: It seems connected to [CASSANDRA-4461|https://issues.apache.org/jira/browse/CASSANDRA-4461] (and [CASSANDRA-4471|https://issues.apache.org/jira/browse/CASSANDRA-4471]), but symptoms are different so I open a separate bug. It may be the same problem, though. Applying [CASSANDRA-4432|https://issues.apache.org/jira/browse/CASSANDRA-4432] seems not to solve the issue. It seems I can't create secondary indexes on any CF. Reading and wrting data works, creating and dropping tables works. Adding new indexes, no longer works, and I get no errors and nothing in logs that (to me) seems an error. This happens on a single node cassandra installation, on Ubuntu LTS 12.04. cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); cqlsh:goh_master create index on users (admin); cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 AND gc_grace_seconds=864000 AND default_validation=text AND min_compaction_threshold=4 AND max_compaction_threshold=32 AND
[jira] [Updated] (CASSANDRA-4472) Can't add secondary index
[ https://issues.apache.org/jira/browse/CASSANDRA-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-4472: --- Description: It seems connected to CASSANDRA-4461 (and CASSANDRA-4471), but symptoms are different so I open a separate bug. It may be the same problem, though. Applying CASSANDRA-4432 seems not to solve the issue. It seems I can't create secondary indexes on any CF. Reading and wrting data works, creating and dropping tables works. Adding new indexes, no longer works, and I get no errors and nothing in logs that (to me) seems an error. This happens on a single node cassandra installation, on Ubuntu LTS 12.04. cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); cqlsh:goh_master create index on users (admin); cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); Interestingly enough, I can create new columnfamilies and add indexes to them: cqlsh:goh_master create table test (id ascii, value ascii, PRIMARY KEY(id)); cqlsh:goh_master DESCRIBE TABLE test; CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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'; cqlsh:goh_master create index test_value ON test (value); ^[[A^[[Acqlsh:goh_DESCRIBE TABLE test;(value); CREATE TABLE test ( id ascii PRIMARY KEY, value ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 test_value ON test (value); cqlsh:goh_master was: It seems connected to CASSANDRA-4461 (and CASSANDRA-4471), but symptoms are different so I open a separate bug. It may be the same problem, though. Applying CASSANDRA-4432 seems not to solve the issue. It seems I can't create secondary indexes on any CF. Reading and wrting data works, creating and dropping tables works. Adding new indexes, no longer works, and I get no errors and nothing in logs that (to me) seems an error. This happens on a single node cassandra installation, on Ubuntu LTS 12.04. cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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 users_username ON users (username); cqlsh:goh_master create index on users (admin); cqlsh:goh_master DESCRIBE TABLE users; CREATE TABLE users ( corporation_id ascii PRIMARY KEY, mail_token ascii, admin ascii, sysd ascii, username ascii, password ascii, dockd ascii ) WITH comment='' AND comparator=text AND read_repair_chance=0.10 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
[jira] [Commented] (CASSANDRA-4461) Schema no longer modifiable
[ https://issues.apache.org/jira/browse/CASSANDRA-4461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13424985#comment-13424985 ] Marco Matarazzo commented on CASSANDRA-4461: Pavel, maybe you want to look at CASSANDRA-4472. Schema no longer modifiable --- Key: CASSANDRA-4461 URL: https://issues.apache.org/jira/browse/CASSANDRA-4461 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Environment: Ubuntu LTS 12.04, Java Sun Oracle 6 (jre1.6.0_33) Reporter: Marco Matarazzo Assignee: Pavel Yaskevich Fix For: 1.1.3 Attachments: system.log It seems that after a while, our keyspaces can't be modified. They accept data, read and write works, truncate works, just keyspace and every column family inside it can't be dropped, created or altered. This happens both on our 3 nodes test cluster and on our single-node dev cluster. With 1.1.1, a rolling restart of the cluster seemed to solve the issue. This no longer happens with 1.1.2 . user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master drop columnfamily agents_blueprints; cqlsh:goh_master user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master DESCRIBE COLUMNFAMILY agents_blueprints CREATE TABLE agents_blueprints ( agent_id ascii, archetype ascii, proto_id ascii, PRIMARY KEY (agent_id, archetype) ) WITH COMPACT STORAGE AND comment='' AND caching='KEYS_ONLY' AND read_repair_chance=0.10 AND gc_grace_seconds=864000 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'; cqlsh:goh_master -- 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] [Created] (CASSANDRA-4461) Schema no longer modifiable
Marco Matarazzo created CASSANDRA-4461: -- Summary: Schema no longer modifiable Key: CASSANDRA-4461 URL: https://issues.apache.org/jira/browse/CASSANDRA-4461 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Environment: Ubuntu LTS 12.04, Java Sun Oracle 6 (jre1.6.0_33) Reporter: Marco Matarazzo It seems that after a while, our keyspaces can't be modified. They accept data, read and write works, truncate works, just keyspace and every column family inside it can't be dropped, created or altered. This happens both on our 3 nodes test cluster and on our single-node dev cluster. With 1.1.1, a rolling restart of the cluster seemed to solve the issue. This no longer happens with 1.1.2 . user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master drop columnfamily agents_blueprints; cqlsh:goh_master user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master DESCRIBE COLUMNFAMILY agents_blueprints CREATE TABLE agents_blueprints ( agent_id ascii, archetype ascii, proto_id ascii, PRIMARY KEY (agent_id, archetype) ) WITH COMPACT STORAGE AND comment='' AND caching='KEYS_ONLY' AND read_repair_chance=0.10 AND gc_grace_seconds=864000 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'; cqlsh:goh_master -- 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-4461) Schema no longer modifiable
[ https://issues.apache.org/jira/browse/CASSANDRA-4461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Matarazzo updated CASSANDRA-4461: --- Attachment: system.log Schema no longer modifiable --- Key: CASSANDRA-4461 URL: https://issues.apache.org/jira/browse/CASSANDRA-4461 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Environment: Ubuntu LTS 12.04, Java Sun Oracle 6 (jre1.6.0_33) Reporter: Marco Matarazzo Attachments: system.log It seems that after a while, our keyspaces can't be modified. They accept data, read and write works, truncate works, just keyspace and every column family inside it can't be dropped, created or altered. This happens both on our 3 nodes test cluster and on our single-node dev cluster. With 1.1.1, a rolling restart of the cluster seemed to solve the issue. This no longer happens with 1.1.2 . user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master drop columnfamily agents_blueprints; cqlsh:goh_master user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master DESCRIBE COLUMNFAMILY agents_blueprints CREATE TABLE agents_blueprints ( agent_id ascii, archetype ascii, proto_id ascii, PRIMARY KEY (agent_id, archetype) ) WITH COMPACT STORAGE AND comment='' AND caching='KEYS_ONLY' AND read_repair_chance=0.10 AND gc_grace_seconds=864000 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'; cqlsh:goh_master -- 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-4461) Schema no longer modifiable
[ https://issues.apache.org/jira/browse/CASSANDRA-4461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13421332#comment-13421332 ] Marco Matarazzo commented on CASSANDRA-4461: Update: on the 3-nodes cluster, executing the same DROP on a second node, does the magic. It works with CREATE and ALTER too. It can be useful to know that the keyspace has a replication factor of 3. Schema no longer modifiable --- Key: CASSANDRA-4461 URL: https://issues.apache.org/jira/browse/CASSANDRA-4461 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Environment: Ubuntu LTS 12.04, Java Sun Oracle 6 (jre1.6.0_33) Reporter: Marco Matarazzo Attachments: system.log It seems that after a while, our keyspaces can't be modified. They accept data, read and write works, truncate works, just keyspace and every column family inside it can't be dropped, created or altered. This happens both on our 3 nodes test cluster and on our single-node dev cluster. With 1.1.1, a rolling restart of the cluster seemed to solve the issue. This no longer happens with 1.1.2 . user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master drop columnfamily agents_blueprints; cqlsh:goh_master user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master DESCRIBE COLUMNFAMILY agents_blueprints CREATE TABLE agents_blueprints ( agent_id ascii, archetype ascii, proto_id ascii, PRIMARY KEY (agent_id, archetype) ) WITH COMPACT STORAGE AND comment='' AND caching='KEYS_ONLY' AND read_repair_chance=0.10 AND gc_grace_seconds=864000 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'; cqlsh:goh_master -- 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-4461) Schema no longer modifiable
[ https://issues.apache.org/jira/browse/CASSANDRA-4461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13421462#comment-13421462 ] Marco Matarazzo commented on CASSANDRA-4461: It seems that updating the schema from a second node (and maybe the millions of nodetool repair/cleanup/everything) unlocked everything. As soon as the problem happens again (and I expect it soon), I will more than happily try to apply the patch and see if it solves the problem. Schema no longer modifiable --- Key: CASSANDRA-4461 URL: https://issues.apache.org/jira/browse/CASSANDRA-4461 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Environment: Ubuntu LTS 12.04, Java Sun Oracle 6 (jre1.6.0_33) Reporter: Marco Matarazzo Assignee: Pavel Yaskevich Fix For: 1.1.3 Attachments: system.log It seems that after a while, our keyspaces can't be modified. They accept data, read and write works, truncate works, just keyspace and every column family inside it can't be dropped, created or altered. This happens both on our 3 nodes test cluster and on our single-node dev cluster. With 1.1.1, a rolling restart of the cluster seemed to solve the issue. This no longer happens with 1.1.2 . user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master drop columnfamily agents_blueprints; cqlsh:goh_master user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master DESCRIBE COLUMNFAMILY agents_blueprints CREATE TABLE agents_blueprints ( agent_id ascii, archetype ascii, proto_id ascii, PRIMARY KEY (agent_id, archetype) ) WITH COMPACT STORAGE AND comment='' AND caching='KEYS_ONLY' AND read_repair_chance=0.10 AND gc_grace_seconds=864000 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'; cqlsh:goh_master -- 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-4461) Schema no longer modifiable
[ https://issues.apache.org/jira/browse/CASSANDRA-4461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13421472#comment-13421472 ] Marco Matarazzo commented on CASSANDRA-4461: Absolutely OK for me. Schema no longer modifiable --- Key: CASSANDRA-4461 URL: https://issues.apache.org/jira/browse/CASSANDRA-4461 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Environment: Ubuntu LTS 12.04, Java Sun Oracle 6 (jre1.6.0_33) Reporter: Marco Matarazzo Assignee: Pavel Yaskevich Fix For: 1.1.3 Attachments: system.log It seems that after a while, our keyspaces can't be modified. They accept data, read and write works, truncate works, just keyspace and every column family inside it can't be dropped, created or altered. This happens both on our 3 nodes test cluster and on our single-node dev cluster. With 1.1.1, a rolling restart of the cluster seemed to solve the issue. This no longer happens with 1.1.2 . user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master drop columnfamily agents_blueprints; cqlsh:goh_master user@server:~$ cqlsh -3 -k goh_master cassandra1 Connected to GOH Cluster at cassandra1:9160. [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0] Use HELP for help. cqlsh:goh_master DESCRIBE COLUMNFAMILY agents_blueprints CREATE TABLE agents_blueprints ( agent_id ascii, archetype ascii, proto_id ascii, PRIMARY KEY (agent_id, archetype) ) WITH COMPACT STORAGE AND comment='' AND caching='KEYS_ONLY' AND read_repair_chance=0.10 AND gc_grace_seconds=864000 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'; cqlsh:goh_master -- 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-4426) CQL error on query prepare
[
https://issues.apache.org/jira/browse/CASSANDRA-4426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1343#comment-1343
]
Marco Matarazzo commented on CASSANDRA-4426:
Paul, it turned out to be a problem of my code. Explicitly instancing a new
connection and immediately setting cql version for every single query solved
the problem.
Thanks for the help :-)
CQL error on query prepare
--
Key: CASSANDRA-4426
URL: https://issues.apache.org/jira/browse/CASSANDRA-4426
Project: Cassandra
Issue Type: Bug
Affects Versions: 1.1.2
Reporter: Marco Matarazzo
We're using (packaged) cassandra 1.1.2 on Ubuntu LTS 12.04 .
This is a CF on a KS with replica_factor 3, on a cluster with 3 nodes:
cqlsh:goh_release DESCRIBE COLUMNFAMILY agents_skill
CREATE TABLE agents_skill (
agent_id ascii,
skill ascii,
value ascii,
PRIMARY KEY (agent_id, skill)
) WITH COMPACT STORAGE AND
comment='' AND
caching='KEYS_ONLY' AND
read_repair_chance=0.10 AND
gc_grace_seconds=864000 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';
cqlsh:goh_release
On this query :
UPDATE agents_skill USING CONSISTENCY QUORUM SET value = ? WHERE agent_id
= ? and skill = ?
...sometimes we get this error on cql_prepare_query():
Error : line 1:78 mismatched input 'and' expecting EOF
The error happens randomly (or with a pattern that I can't understand) and it
does not make any sense to me. Normally the query works, as I would expect.
I am using PHPCassa, and I was not sure where the error could be. I somewhat
remembered that CQL should be passed to cassandra as is, but not knowing
Cassandra internal too well, I took a very low-level approach... I hope is
not too low :-)
I see this on tcpdump when i receive the error:
18:49:51.800398 IP 10.0.3.177.42205 10.0.3.170.9160: Flags [P.], seq
840:979, ack 766, win 1047, options [nop,nop,TS val 130357758 ecr 135322260],
length 139
0x: aacc 0208 aacc 020f 0800 4500 ..E.
0x0010: 00bf c2d9 4000 4006 5c05 0a00 03b1 0a00 @.@.\...
0x0020: 03aa a4dd 23c8 16b9 de71 a9db 9466 8018 #q...f..
0x0030: 0417 ad09 0101 080a 07c5 19fe 0810
0x0040: da94 0087 8001 0001 0011 7072 ..pr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000b 0001 005b 5550 4441 5445 .[UPDATE
0x0070: 2061 6765 6e74 735f 736b 696c 6c20 5553 .agents_skill.US
0x0080: 494e 4720 434f 4e53 4953 5445 4e43 5920 ING.CONSISTENCY.
0x0090: 5155 4f52 554d 2053 4554 2076 616c 7565 QUORUM.SET.value
0x00a0: 203d 203f 2057 4845 5245 2061 6765 6e74 .=.?.WHERE.agent
0x00b0: 5f69 6420 3d20 3f20 616e 6420 736b 696c _id.=.?.and.skil
0x00c0: 6c20 3d20 3f08 0002 0002 00 l.=.?
18:49:51.817323 IP 10.0.3.170.9160 10.0.3.177.42205: Flags [P.], seq
766:857, ack 979, win 587, options [nop,nop,TS val 135322264 ecr 130357758],
length 91
0x: aacc 020f aacc 0208 0800 4500 ..E.
0x0010: 008f 4b1d 4000 4006 d3f1 0a00 03aa 0a00 ..K.@.@.
0x0020: 03b1 23c8 a4dd a9db 9466 16b9 defc 8018 ..#..f..
0x0030: 024b 1bdc 0101 080a 0810 da98 07c5 .K..
0x0040: 19fe 0057 8001 0002 0011 7072 .Wpr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000c 0001 0b00 0100 2e6c 696e .lin
0x0070: 6520 313a 3738 206d 6973 6d61 7463 6865 e.1:78.mismatche
0x0080: 6420 696e 7075 7420 2761 6e64 2720 6578 d.input.'and'.ex
0x0090: 7065 6374 696e 6720 454f 4600 00 pecting.EOF..
Same query, some minutes later, worked (as I would expect) and I see this:
19:11:26.471750 IP 10.0.3.177.42283 10.0.3.170.9160: Flags [P.], seq
906:1045, ack 1181, win 1114, options [nop,nop,TS val 130681426 ecr
135645928], length 139
0x: aacc 0208 aacc 020f 0800 4500 ..E.
0x0010: 00bf 352a 4000 4006 e9b4 0a00 03b1 0a00 ..5*@.@.
0x0020: 03aa a52b 23c8 232a 42f7 c47b cf1e 8018 ...+#.#*B..{
0x0030: 045a 0578 0101 080a 07ca 0a52 0815 .Z.x.R..
0x0040: cae8 0087 8001 0001 0011 7072 ..pr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000b 0001 005b 5550 4441 5445 .[UPDATE
[jira] [Resolved] (CASSANDRA-4426) CQL error on query prepare
[
https://issues.apache.org/jira/browse/CASSANDRA-4426?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marco Matarazzo resolved CASSANDRA-4426.
Resolution: Not A Problem
CQL error on query prepare
--
Key: CASSANDRA-4426
URL: https://issues.apache.org/jira/browse/CASSANDRA-4426
Project: Cassandra
Issue Type: Bug
Affects Versions: 1.1.2
Reporter: Marco Matarazzo
We're using (packaged) cassandra 1.1.2 on Ubuntu LTS 12.04 .
This is a CF on a KS with replica_factor 3, on a cluster with 3 nodes:
cqlsh:goh_release DESCRIBE COLUMNFAMILY agents_skill
CREATE TABLE agents_skill (
agent_id ascii,
skill ascii,
value ascii,
PRIMARY KEY (agent_id, skill)
) WITH COMPACT STORAGE AND
comment='' AND
caching='KEYS_ONLY' AND
read_repair_chance=0.10 AND
gc_grace_seconds=864000 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';
cqlsh:goh_release
On this query :
UPDATE agents_skill USING CONSISTENCY QUORUM SET value = ? WHERE agent_id
= ? and skill = ?
...sometimes we get this error on cql_prepare_query():
Error : line 1:78 mismatched input 'and' expecting EOF
The error happens randomly (or with a pattern that I can't understand) and it
does not make any sense to me. Normally the query works, as I would expect.
I am using PHPCassa, and I was not sure where the error could be. I somewhat
remembered that CQL should be passed to cassandra as is, but not knowing
Cassandra internal too well, I took a very low-level approach... I hope is
not too low :-)
I see this on tcpdump when i receive the error:
18:49:51.800398 IP 10.0.3.177.42205 10.0.3.170.9160: Flags [P.], seq
840:979, ack 766, win 1047, options [nop,nop,TS val 130357758 ecr 135322260],
length 139
0x: aacc 0208 aacc 020f 0800 4500 ..E.
0x0010: 00bf c2d9 4000 4006 5c05 0a00 03b1 0a00 @.@.\...
0x0020: 03aa a4dd 23c8 16b9 de71 a9db 9466 8018 #q...f..
0x0030: 0417 ad09 0101 080a 07c5 19fe 0810
0x0040: da94 0087 8001 0001 0011 7072 ..pr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000b 0001 005b 5550 4441 5445 .[UPDATE
0x0070: 2061 6765 6e74 735f 736b 696c 6c20 5553 .agents_skill.US
0x0080: 494e 4720 434f 4e53 4953 5445 4e43 5920 ING.CONSISTENCY.
0x0090: 5155 4f52 554d 2053 4554 2076 616c 7565 QUORUM.SET.value
0x00a0: 203d 203f 2057 4845 5245 2061 6765 6e74 .=.?.WHERE.agent
0x00b0: 5f69 6420 3d20 3f20 616e 6420 736b 696c _id.=.?.and.skil
0x00c0: 6c20 3d20 3f08 0002 0002 00 l.=.?
18:49:51.817323 IP 10.0.3.170.9160 10.0.3.177.42205: Flags [P.], seq
766:857, ack 979, win 587, options [nop,nop,TS val 135322264 ecr 130357758],
length 91
0x: aacc 020f aacc 0208 0800 4500 ..E.
0x0010: 008f 4b1d 4000 4006 d3f1 0a00 03aa 0a00 ..K.@.@.
0x0020: 03b1 23c8 a4dd a9db 9466 16b9 defc 8018 ..#..f..
0x0030: 024b 1bdc 0101 080a 0810 da98 07c5 .K..
0x0040: 19fe 0057 8001 0002 0011 7072 .Wpr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000c 0001 0b00 0100 2e6c 696e .lin
0x0070: 6520 313a 3738 206d 6973 6d61 7463 6865 e.1:78.mismatche
0x0080: 6420 696e 7075 7420 2761 6e64 2720 6578 d.input.'and'.ex
0x0090: 7065 6374 696e 6720 454f 4600 00 pecting.EOF..
Same query, some minutes later, worked (as I would expect) and I see this:
19:11:26.471750 IP 10.0.3.177.42283 10.0.3.170.9160: Flags [P.], seq
906:1045, ack 1181, win 1114, options [nop,nop,TS val 130681426 ecr
135645928], length 139
0x: aacc 0208 aacc 020f 0800 4500 ..E.
0x0010: 00bf 352a 4000 4006 e9b4 0a00 03b1 0a00 ..5*@.@.
0x0020: 03aa a52b 23c8 232a 42f7 c47b cf1e 8018 ...+#.#*B..{
0x0030: 045a 0578 0101 080a 07ca 0a52 0815 .Z.x.R..
0x0040: cae8 0087 8001 0001 0011 7072 ..pr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000b 0001 005b 5550 4441 5445 .[UPDATE
0x0070: 2061 6765 6e74 735f 736b 696c 6c20 5553 .agents_skill.US
0x0080: 494e 4720 434f 4e53 4953 5445 4e43 5920 ING.CONSISTENCY.
0x0090: 5155 4f52 554d 2053 4554 2076 616c 7565 QUORUM.SET.value
0x00a0: 203d
[jira] [Commented] (CASSANDRA-4426) CQL error on query prepare
[ https://issues.apache.org/jira/browse/CASSANDRA-4426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13409805#comment-13409805 ] Marco Matarazzo commented on CASSANDRA-4426: Paul: It's pretty high, I would say around 1 in 100, maybe more. The strangest part that we noticed between yesterday and today is that it seems it happens almost always when a new IP connect to the webserver and load the page. With a new IP I mean an IP that the webserver hasn't seen for a while, let's say many hours. That makes no sense to me: I'm sure the IP does not get pushed in any way through the webserver, and the connection is always done by the webserver itself. Maybe is something related to the connection getting reused... I'm completely lost here. I am willing to collect any data I can, I just don't know what to look for. CQL error on query prepare -- Key: CASSANDRA-4426 URL: https://issues.apache.org/jira/browse/CASSANDRA-4426 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Reporter: Marco Matarazzo We're using (packaged) cassandra 1.1.2 on Ubuntu LTS 12.04 . This is a CF on a KS with replica_factor 3, on a cluster with 3 nodes: cqlsh:goh_release DESCRIBE COLUMNFAMILY agents_skill CREATE TABLE agents_skill ( agent_id ascii, skill ascii, value ascii, PRIMARY KEY (agent_id, skill) ) WITH COMPACT STORAGE AND comment='' AND caching='KEYS_ONLY' AND read_repair_chance=0.10 AND gc_grace_seconds=864000 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'; cqlsh:goh_release On this query : UPDATE agents_skill USING CONSISTENCY QUORUM SET value = ? WHERE agent_id = ? and skill = ? ...sometimes we get this error on cql_prepare_query(): Error : line 1:78 mismatched input 'and' expecting EOF The error happens randomly (or with a pattern that I can't understand) and it does not make any sense to me. Normally the query works, as I would expect. I am using PHPCassa, and I was not sure where the error could be. I somewhat remembered that CQL should be passed to cassandra as is, but not knowing Cassandra internal too well, I took a very low-level approach... I hope is not too low :-) I see this on tcpdump when i receive the error: 18:49:51.800398 IP 10.0.3.177.42205 10.0.3.170.9160: Flags [P.], seq 840:979, ack 766, win 1047, options [nop,nop,TS val 130357758 ecr 135322260], length 139 0x: aacc 0208 aacc 020f 0800 4500 ..E. 0x0010: 00bf c2d9 4000 4006 5c05 0a00 03b1 0a00 @.@.\... 0x0020: 03aa a4dd 23c8 16b9 de71 a9db 9466 8018 #q...f.. 0x0030: 0417 ad09 0101 080a 07c5 19fe 0810 0x0040: da94 0087 8001 0001 0011 7072 ..pr 0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query. 0x0060: 000b 0001 005b 5550 4441 5445 .[UPDATE 0x0070: 2061 6765 6e74 735f 736b 696c 6c20 5553 .agents_skill.US 0x0080: 494e 4720 434f 4e53 4953 5445 4e43 5920 ING.CONSISTENCY. 0x0090: 5155 4f52 554d 2053 4554 2076 616c 7565 QUORUM.SET.value 0x00a0: 203d 203f 2057 4845 5245 2061 6765 6e74 .=.?.WHERE.agent 0x00b0: 5f69 6420 3d20 3f20 616e 6420 736b 696c _id.=.?.and.skil 0x00c0: 6c20 3d20 3f08 0002 0002 00 l.=.? 18:49:51.817323 IP 10.0.3.170.9160 10.0.3.177.42205: Flags [P.], seq 766:857, ack 979, win 587, options [nop,nop,TS val 135322264 ecr 130357758], length 91 0x: aacc 020f aacc 0208 0800 4500 ..E. 0x0010: 008f 4b1d 4000 4006 d3f1 0a00 03aa 0a00 ..K.@.@. 0x0020: 03b1 23c8 a4dd a9db 9466 16b9 defc 8018 ..#..f.. 0x0030: 024b 1bdc 0101 080a 0810 da98 07c5 .K.. 0x0040: 19fe 0057 8001 0002 0011 7072 .Wpr 0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query. 0x0060: 000c 0001 0b00 0100 2e6c 696e .lin 0x0070: 6520 313a 3738 206d 6973 6d61 7463 6865 e.1:78.mismatche 0x0080: 6420 696e 7075 7420 2761 6e64 2720 6578 d.input.'and'.ex 0x0090: 7065 6374 696e 6720 454f 4600 00 pecting.EOF.. Same query, some minutes later, worked (as I would expect) and I see this: 19:11:26.471750 IP 10.0.3.177.42283 10.0.3.170.9160: Flags [P.], seq 906:1045, ack 1181, win 1114, options [nop,nop,TS val 130681426 ecr 135645928], length 139 0x: aacc 0208 aacc 020f 0800 4500 ..E.
[jira] [Commented] (CASSANDRA-4426) CQL error on query prepare
[
https://issues.apache.org/jira/browse/CASSANDRA-4426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13409911#comment-13409911
]
Marco Matarazzo commented on CASSANDRA-4426:
We're using cassandra in a test environment, so there should be no problem.
CQL error on query prepare
--
Key: CASSANDRA-4426
URL: https://issues.apache.org/jira/browse/CASSANDRA-4426
Project: Cassandra
Issue Type: Bug
Affects Versions: 1.1.2
Reporter: Marco Matarazzo
We're using (packaged) cassandra 1.1.2 on Ubuntu LTS 12.04 .
This is a CF on a KS with replica_factor 3, on a cluster with 3 nodes:
cqlsh:goh_release DESCRIBE COLUMNFAMILY agents_skill
CREATE TABLE agents_skill (
agent_id ascii,
skill ascii,
value ascii,
PRIMARY KEY (agent_id, skill)
) WITH COMPACT STORAGE AND
comment='' AND
caching='KEYS_ONLY' AND
read_repair_chance=0.10 AND
gc_grace_seconds=864000 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';
cqlsh:goh_release
On this query :
UPDATE agents_skill USING CONSISTENCY QUORUM SET value = ? WHERE agent_id
= ? and skill = ?
...sometimes we get this error on cql_prepare_query():
Error : line 1:78 mismatched input 'and' expecting EOF
The error happens randomly (or with a pattern that I can't understand) and it
does not make any sense to me. Normally the query works, as I would expect.
I am using PHPCassa, and I was not sure where the error could be. I somewhat
remembered that CQL should be passed to cassandra as is, but not knowing
Cassandra internal too well, I took a very low-level approach... I hope is
not too low :-)
I see this on tcpdump when i receive the error:
18:49:51.800398 IP 10.0.3.177.42205 10.0.3.170.9160: Flags [P.], seq
840:979, ack 766, win 1047, options [nop,nop,TS val 130357758 ecr 135322260],
length 139
0x: aacc 0208 aacc 020f 0800 4500 ..E.
0x0010: 00bf c2d9 4000 4006 5c05 0a00 03b1 0a00 @.@.\...
0x0020: 03aa a4dd 23c8 16b9 de71 a9db 9466 8018 #q...f..
0x0030: 0417 ad09 0101 080a 07c5 19fe 0810
0x0040: da94 0087 8001 0001 0011 7072 ..pr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000b 0001 005b 5550 4441 5445 .[UPDATE
0x0070: 2061 6765 6e74 735f 736b 696c 6c20 5553 .agents_skill.US
0x0080: 494e 4720 434f 4e53 4953 5445 4e43 5920 ING.CONSISTENCY.
0x0090: 5155 4f52 554d 2053 4554 2076 616c 7565 QUORUM.SET.value
0x00a0: 203d 203f 2057 4845 5245 2061 6765 6e74 .=.?.WHERE.agent
0x00b0: 5f69 6420 3d20 3f20 616e 6420 736b 696c _id.=.?.and.skil
0x00c0: 6c20 3d20 3f08 0002 0002 00 l.=.?
18:49:51.817323 IP 10.0.3.170.9160 10.0.3.177.42205: Flags [P.], seq
766:857, ack 979, win 587, options [nop,nop,TS val 135322264 ecr 130357758],
length 91
0x: aacc 020f aacc 0208 0800 4500 ..E.
0x0010: 008f 4b1d 4000 4006 d3f1 0a00 03aa 0a00 ..K.@.@.
0x0020: 03b1 23c8 a4dd a9db 9466 16b9 defc 8018 ..#..f..
0x0030: 024b 1bdc 0101 080a 0810 da98 07c5 .K..
0x0040: 19fe 0057 8001 0002 0011 7072 .Wpr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000c 0001 0b00 0100 2e6c 696e .lin
0x0070: 6520 313a 3738 206d 6973 6d61 7463 6865 e.1:78.mismatche
0x0080: 6420 696e 7075 7420 2761 6e64 2720 6578 d.input.'and'.ex
0x0090: 7065 6374 696e 6720 454f 4600 00 pecting.EOF..
Same query, some minutes later, worked (as I would expect) and I see this:
19:11:26.471750 IP 10.0.3.177.42283 10.0.3.170.9160: Flags [P.], seq
906:1045, ack 1181, win 1114, options [nop,nop,TS val 130681426 ecr
135645928], length 139
0x: aacc 0208 aacc 020f 0800 4500 ..E.
0x0010: 00bf 352a 4000 4006 e9b4 0a00 03b1 0a00 ..5*@.@.
0x0020: 03aa a52b 23c8 232a 42f7 c47b cf1e 8018 ...+#.#*B..{
0x0030: 045a 0578 0101 080a 07ca 0a52 0815 .Z.x.R..
0x0040: cae8 0087 8001 0001 0011 7072 ..pr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000b 0001 005b 5550 4441 5445 .[UPDATE
0x0070: 2061 6765 6e74 735f 736b 696c 6c20 5553 .agents_skill.US
0x0080: 494e 4720 434f 4e53 4953 5445 4e43
[jira] [Commented] (CASSANDRA-4426) CQL error on query prepare
[ https://issues.apache.org/jira/browse/CASSANDRA-4426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13409990#comment-13409990 ] Marco Matarazzo commented on CASSANDRA-4426: It is absolutely possible that I made some error and I'm setting the CQL version in the wrong point or in the wrong way. It surprises me a bit, as I would expect to see all my query call to fail with the same errors, but maybe I misunderstood something. Or maybe is something internal to phpcassa. Anyway, if the problem it's me (or the client) not setting the correct CQL version, at least I know what to look for and I can fix it. And definitely it's not cassandra's fault. Thanks for the direction, I'll look into it right now. CQL error on query prepare -- Key: CASSANDRA-4426 URL: https://issues.apache.org/jira/browse/CASSANDRA-4426 Project: Cassandra Issue Type: Bug Affects Versions: 1.1.2 Reporter: Marco Matarazzo We're using (packaged) cassandra 1.1.2 on Ubuntu LTS 12.04 . This is a CF on a KS with replica_factor 3, on a cluster with 3 nodes: cqlsh:goh_release DESCRIBE COLUMNFAMILY agents_skill CREATE TABLE agents_skill ( agent_id ascii, skill ascii, value ascii, PRIMARY KEY (agent_id, skill) ) WITH COMPACT STORAGE AND comment='' AND caching='KEYS_ONLY' AND read_repair_chance=0.10 AND gc_grace_seconds=864000 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'; cqlsh:goh_release On this query : UPDATE agents_skill USING CONSISTENCY QUORUM SET value = ? WHERE agent_id = ? and skill = ? ...sometimes we get this error on cql_prepare_query(): Error : line 1:78 mismatched input 'and' expecting EOF The error happens randomly (or with a pattern that I can't understand) and it does not make any sense to me. Normally the query works, as I would expect. I am using PHPCassa, and I was not sure where the error could be. I somewhat remembered that CQL should be passed to cassandra as is, but not knowing Cassandra internal too well, I took a very low-level approach... I hope is not too low :-) I see this on tcpdump when i receive the error: 18:49:51.800398 IP 10.0.3.177.42205 10.0.3.170.9160: Flags [P.], seq 840:979, ack 766, win 1047, options [nop,nop,TS val 130357758 ecr 135322260], length 139 0x: aacc 0208 aacc 020f 0800 4500 ..E. 0x0010: 00bf c2d9 4000 4006 5c05 0a00 03b1 0a00 @.@.\... 0x0020: 03aa a4dd 23c8 16b9 de71 a9db 9466 8018 #q...f.. 0x0030: 0417 ad09 0101 080a 07c5 19fe 0810 0x0040: da94 0087 8001 0001 0011 7072 ..pr 0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query. 0x0060: 000b 0001 005b 5550 4441 5445 .[UPDATE 0x0070: 2061 6765 6e74 735f 736b 696c 6c20 5553 .agents_skill.US 0x0080: 494e 4720 434f 4e53 4953 5445 4e43 5920 ING.CONSISTENCY. 0x0090: 5155 4f52 554d 2053 4554 2076 616c 7565 QUORUM.SET.value 0x00a0: 203d 203f 2057 4845 5245 2061 6765 6e74 .=.?.WHERE.agent 0x00b0: 5f69 6420 3d20 3f20 616e 6420 736b 696c _id.=.?.and.skil 0x00c0: 6c20 3d20 3f08 0002 0002 00 l.=.? 18:49:51.817323 IP 10.0.3.170.9160 10.0.3.177.42205: Flags [P.], seq 766:857, ack 979, win 587, options [nop,nop,TS val 135322264 ecr 130357758], length 91 0x: aacc 020f aacc 0208 0800 4500 ..E. 0x0010: 008f 4b1d 4000 4006 d3f1 0a00 03aa 0a00 ..K.@.@. 0x0020: 03b1 23c8 a4dd a9db 9466 16b9 defc 8018 ..#..f.. 0x0030: 024b 1bdc 0101 080a 0810 da98 07c5 .K.. 0x0040: 19fe 0057 8001 0002 0011 7072 .Wpr 0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query. 0x0060: 000c 0001 0b00 0100 2e6c 696e .lin 0x0070: 6520 313a 3738 206d 6973 6d61 7463 6865 e.1:78.mismatche 0x0080: 6420 696e 7075 7420 2761 6e64 2720 6578 d.input.'and'.ex 0x0090: 7065 6374 696e 6720 454f 4600 00 pecting.EOF.. Same query, some minutes later, worked (as I would expect) and I see this: 19:11:26.471750 IP 10.0.3.177.42283 10.0.3.170.9160: Flags [P.], seq 906:1045, ack 1181, win 1114, options [nop,nop,TS val 130681426 ecr 135645928], length 139 0x: aacc 0208 aacc 020f 0800 4500 ..E. 0x0010: 00bf 352a 4000 4006 e9b4 0a00 03b1 0a00 ..5*@.@. 0x0020: 03aa a52b 23c8
[jira] [Created] (CASSANDRA-4426) CQL error on query prepare
Marco Matarazzo created CASSANDRA-4426:
--
Summary: CQL error on query prepare
Key: CASSANDRA-4426
URL: https://issues.apache.org/jira/browse/CASSANDRA-4426
Project: Cassandra
Issue Type: Bug
Affects Versions: 1.1.2
Reporter: Marco Matarazzo
We're using (packaged) cassandra 1.1.2 on Ubuntu LTS 12.04 .
This is a CF on a KS with replica_factor 3, on a cluster with 3 nodes:
cqlsh:goh_release DESCRIBE COLUMNFAMILY agents_skill
CREATE TABLE agents_skill (
agent_id ascii,
skill ascii,
value ascii,
PRIMARY KEY (agent_id, skill)
) WITH COMPACT STORAGE AND
comment='' AND
caching='KEYS_ONLY' AND
read_repair_chance=0.10 AND
gc_grace_seconds=864000 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';
cqlsh:goh_release
On this query :
UPDATE agents_skill USING CONSISTENCY QUORUM SET value = ? WHERE agent_id =
? and skill = ?
...sometimes we get this error on cql_prepare_query():
Error : line 1:78 mismatched input 'and' expecting EOF
The error happens randomly (or with a pattern that I can't understand) and it
does not make any sense to me. Normally the query works, as I would expect.
I am using PHPCassa, and I was not sure where the error could be. I somewhat
remembered that CQL should be passed to cassandra as is, but not knowing
Cassandra internal too well, I took a very low-level approach... I hope is not
too low :-)
I see this on tcpdump when i receive the error:
18:49:51.800398 IP 10.0.3.177.42205 10.0.3.170.9160: Flags [P.], seq 840:979,
ack 766, win 1047, options [nop,nop,TS val 130357758 ecr 135322260], length 139
0x: aacc 0208 aacc 020f 0800 4500 ..E.
0x0010: 00bf c2d9 4000 4006 5c05 0a00 03b1 0a00 @.@.\...
0x0020: 03aa a4dd 23c8 16b9 de71 a9db 9466 8018 #q...f..
0x0030: 0417 ad09 0101 080a 07c5 19fe 0810
0x0040: da94 0087 8001 0001 0011 7072 ..pr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000b 0001 005b 5550 4441 5445 .[UPDATE
0x0070: 2061 6765 6e74 735f 736b 696c 6c20 5553 .agents_skill.US
0x0080: 494e 4720 434f 4e53 4953 5445 4e43 5920 ING.CONSISTENCY.
0x0090: 5155 4f52 554d 2053 4554 2076 616c 7565 QUORUM.SET.value
0x00a0: 203d 203f 2057 4845 5245 2061 6765 6e74 .=.?.WHERE.agent
0x00b0: 5f69 6420 3d20 3f20 616e 6420 736b 696c _id.=.?.and.skil
0x00c0: 6c20 3d20 3f08 0002 0002 00 l.=.?
18:49:51.817323 IP 10.0.3.170.9160 10.0.3.177.42205: Flags [P.], seq 766:857,
ack 979, win 587, options [nop,nop,TS val 135322264 ecr 130357758], length 91
0x: aacc 020f aacc 0208 0800 4500 ..E.
0x0010: 008f 4b1d 4000 4006 d3f1 0a00 03aa 0a00 ..K.@.@.
0x0020: 03b1 23c8 a4dd a9db 9466 16b9 defc 8018 ..#..f..
0x0030: 024b 1bdc 0101 080a 0810 da98 07c5 .K..
0x0040: 19fe 0057 8001 0002 0011 7072 .Wpr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000c 0001 0b00 0100 2e6c 696e .lin
0x0070: 6520 313a 3738 206d 6973 6d61 7463 6865 e.1:78.mismatche
0x0080: 6420 696e 7075 7420 2761 6e64 2720 6578 d.input.'and'.ex
0x0090: 7065 6374 696e 6720 454f 4600 00 pecting.EOF..
Same query, some minutes later, worked (as I would expect) and I see this:
19:11:26.471750 IP 10.0.3.177.42283 10.0.3.170.9160: Flags [P.], seq
906:1045, ack 1181, win 1114, options [nop,nop,TS val 130681426 ecr 135645928],
length 139
0x: aacc 0208 aacc 020f 0800 4500 ..E.
0x0010: 00bf 352a 4000 4006 e9b4 0a00 03b1 0a00 ..5*@.@.
0x0020: 03aa a52b 23c8 232a 42f7 c47b cf1e 8018 ...+#.#*B..{
0x0030: 045a 0578 0101 080a 07ca 0a52 0815 .Z.x.R..
0x0040: cae8 0087 8001 0001 0011 7072 ..pr
0x0050: 6570 6172 655f 6371 6c5f 7175 6572 7900 epare_cql_query.
0x0060: 000b 0001 005b 5550 4441 5445 .[UPDATE
0x0070: 2061 6765 6e74 735f 736b 696c 6c20 5553 .agents_skill.US
0x0080: 494e 4720 434f 4e53 4953 5445 4e43 5920 ING.CONSISTENCY.
0x0090: 5155 4f52 554d 2053 4554 2076 616c 7565 QUORUM.SET.value
0x00a0: 203d 203f 2057 4845 5245 2061 6765 6e74 .=.?.WHERE.agent
0x00b0: 5f69 6420 3d20 3f20 616e 6420 736b 696c _id.=.?.and.skil
0x00c0: 6c20 3d20 3f08 0002 0002 00 l.=.?
