[jira] [Commented] (CASSANDRA-10587) sstablemetadata NPE on cassandra 2.2

2016-02-16 Thread Roman Skvazh (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-10587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15150067#comment-15150067
 ] 

Roman Skvazh commented on CASSANDRA-10587:
--

[~yukim], yeah, with absolute path it works! Thanks.

> sstablemetadata NPE on cassandra 2.2
> 
>
> Key: CASSANDRA-10587
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10587
> Project: Cassandra
>  Issue Type: Bug
>  Components: Tools
>Reporter: Tiago Batista
>Assignee: Yuki Morishita
>Priority: Minor
> Fix For: 2.2.x, 3.x
>
>
> I have recently upgraded my cassandra cluster to 2.2, currently running 
> 2.2.3. After running the first repair, cassandra renames the sstables to the 
> new naming schema that does not contain the keyspace name.
>  This causes sstablemetadata to fail with the following stack trace:
> {noformat}
> Exception in thread "main" java.lang.NullPointerException
> at 
> org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:275)
> at 
> org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:172)
> at 
> org.apache.cassandra.tools.SSTableMetadataViewer.main(SSTableMetadataViewer.java:52)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Comment Edited] (CASSANDRA-10587) sstablemetadata NPE on cassandra 2.2

2016-02-16 Thread Roman Skvazh (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-10587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15148877#comment-15148877
 ] 

Roman Skvazh edited comment on CASSANDRA-10587 at 2/16/16 4:47 PM:
---

Same problem here on 2.2.5 after upgrading from 2.1.13 on all nodes on new 
upgraded "short-named"-files.
{noformat}
Exception in thread "main" java.lang.NullPointerException
at 
org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:271)
at 
org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:172)
at 
org.apache.cassandra.tools.SSTableMetadataViewer.main(SSTableMetadataViewer.java:52)
{noformat}


was (Author: rskvazh):
Same problem here on 2.2.5 after upgrading from 2.1.13 on all nodes.
{noformat}
Exception in thread "main" java.lang.NullPointerException
at 
org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:271)
at 
org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:172)
at 
org.apache.cassandra.tools.SSTableMetadataViewer.main(SSTableMetadataViewer.java:52)
{noformat}

> sstablemetadata NPE on cassandra 2.2
> 
>
> Key: CASSANDRA-10587
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10587
> Project: Cassandra
>  Issue Type: Bug
>  Components: Tools
>Reporter: Tiago Batista
>Assignee: Paulo Motta
> Fix For: 2.2.x, 3.x
>
>
> I have recently upgraded my cassandra cluster to 2.2, currently running 
> 2.2.3. After running the first repair, cassandra renames the sstables to the 
> new naming schema that does not contain the keyspace name.
>  This causes sstablemetadata to fail with the following stack trace:
> {noformat}
> Exception in thread "main" java.lang.NullPointerException
> at 
> org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:275)
> at 
> org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:172)
> at 
> org.apache.cassandra.tools.SSTableMetadataViewer.main(SSTableMetadataViewer.java:52)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-10587) sstablemetadata NPE on cassandra 2.2

2016-02-16 Thread Roman Skvazh (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-10587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15148877#comment-15148877
 ] 

Roman Skvazh commented on CASSANDRA-10587:
--

Same problem here on 2.2.5 after upgrading from 2.1.13 on all nodes.
{noformat}
Exception in thread "main" java.lang.NullPointerException
at 
org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:271)
at 
org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:172)
at 
org.apache.cassandra.tools.SSTableMetadataViewer.main(SSTableMetadataViewer.java:52)
{noformat}

> sstablemetadata NPE on cassandra 2.2
> 
>
> Key: CASSANDRA-10587
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10587
> Project: Cassandra
>  Issue Type: Bug
>  Components: Tools
>Reporter: Tiago Batista
>Assignee: Paulo Motta
> Fix For: 2.2.x, 3.x
>
>
> I have recently upgraded my cassandra cluster to 2.2, currently running 
> 2.2.3. After running the first repair, cassandra renames the sstables to the 
> new naming schema that does not contain the keyspace name.
>  This causes sstablemetadata to fail with the following stack trace:
> {noformat}
> Exception in thread "main" java.lang.NullPointerException
> at 
> org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:275)
> at 
> org.apache.cassandra.io.sstable.Descriptor.fromFilename(Descriptor.java:172)
> at 
> org.apache.cassandra.tools.SSTableMetadataViewer.main(SSTableMetadataViewer.java:52)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (CASSANDRA-6698) Many too small SSTables when full repair

2014-02-12 Thread Roman Skvazh (JIRA)

 [ 
https://issues.apache.org/jira/browse/CASSANDRA-6698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Roman Skvazh updated CASSANDRA-6698:


Reproduced In: 2.0.5, 2.0.4  (was: 2.0.5)

 Many too small SSTables when full repair
 

 Key: CASSANDRA-6698
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6698
 Project: Cassandra
  Issue Type: Bug
Reporter: Roman Skvazh
Priority: Critical

 We are have troubles when cassandra drops messages because there is too many 
 (over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
 too) and many pending compactions (over 700).
 PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to 
 be finished. Because this, we can not run full repair for about a month :(



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Created] (CASSANDRA-6698) Many too small SSTables when full repair

2014-02-12 Thread Roman Skvazh (JIRA)
Roman Skvazh created CASSANDRA-6698:
---

 Summary: Many too small SSTables when full repair
 Key: CASSANDRA-6698
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6698
 Project: Cassandra
  Issue Type: Bug
Reporter: Roman Skvazh
Priority: Critical


We are have troubles when cassandra drops messages because there is too many 
(over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
too) and many pending compactions (over 700).

PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to be 
finished. Because this, we can not run full repair for about a month :(



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Comment Edited] (CASSANDRA-6698) Many too small SSTables when full repair

2014-02-12 Thread Roman Skvazh (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13899737#comment-13899737
 ] 

Roman Skvazh edited comment on CASSANDRA-6698 at 2/12/14 11:11 PM:
---

Some of files in attached file


was (Author: rskvazh):
Some of files

 Many too small SSTables when full repair
 

 Key: CASSANDRA-6698
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6698
 Project: Cassandra
  Issue Type: Bug
Reporter: Roman Skvazh
Priority: Critical
 Attachments: cassa-many-small-sstables.txt


 We are have troubles when cassandra drops messages because there is too many 
 (over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
 too) and many pending compactions (over 700).
 PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to 
 be finished. Because this, we can not run full repair for about a month :(



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (CASSANDRA-6698) Many too small SSTables when full repair

2014-02-12 Thread Roman Skvazh (JIRA)

 [ 
https://issues.apache.org/jira/browse/CASSANDRA-6698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Roman Skvazh updated CASSANDRA-6698:


Attachment: cassa-many-small-sstables.txt

Some of files

 Many too small SSTables when full repair
 

 Key: CASSANDRA-6698
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6698
 Project: Cassandra
  Issue Type: Bug
Reporter: Roman Skvazh
Priority: Critical
 Attachments: cassa-many-small-sstables.txt


 We are have troubles when cassandra drops messages because there is too many 
 (over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
 too) and many pending compactions (over 700).
 PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to 
 be finished. Because this, we can not run full repair for about a month :(



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (CASSANDRA-6698) Many too small SSTables when full repair

2014-02-12 Thread Roman Skvazh (JIRA)

 [ 
https://issues.apache.org/jira/browse/CASSANDRA-6698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Roman Skvazh updated CASSANDRA-6698:


Description: 
We are have troubles when cassandra drops messages because there is too many 
(over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
too) and many pending compactions (over 700).

We are using Leveled compaction with 165Mb sstable size.
PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to be 
finished. Because this, we can not run full repair for about a month :(

  was:
We are have troubles when cassandra drops messages because there is too many 
(over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
too) and many pending compactions (over 700).

We are using Leveled compaction with 160Mb sstable size.
PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to be 
finished. Because this, we can not run full repair for about a month :(


 Many too small SSTables when full repair
 

 Key: CASSANDRA-6698
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6698
 Project: Cassandra
  Issue Type: Bug
Reporter: Roman Skvazh
Priority: Critical
 Attachments: cassa-many-small-sstables.txt


 We are have troubles when cassandra drops messages because there is too many 
 (over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
 too) and many pending compactions (over 700).
 We are using Leveled compaction with 165Mb sstable size.
 PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to 
 be finished. Because this, we can not run full repair for about a month :(



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (CASSANDRA-6698) Many too small SSTables when full repair

2014-02-12 Thread Roman Skvazh (JIRA)

 [ 
https://issues.apache.org/jira/browse/CASSANDRA-6698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Roman Skvazh updated CASSANDRA-6698:


Description: 
We are have troubles when cassandra drops messages because there is too many 
(over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
too) and many pending compactions (over 700).

We are using Leveled compaction with 160Mb sstable size.
PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to be 
finished. Because this, we can not run full repair for about a month :(

  was:
We are have troubles when cassandra drops messages because there is too many 
(over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
too) and many pending compactions (over 700).

PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to be 
finished. Because this, we can not run full repair for about a month :(


 Many too small SSTables when full repair
 

 Key: CASSANDRA-6698
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6698
 Project: Cassandra
  Issue Type: Bug
Reporter: Roman Skvazh
Priority: Critical
 Attachments: cassa-many-small-sstables.txt


 We are have troubles when cassandra drops messages because there is too many 
 (over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
 too) and many pending compactions (over 700).
 We are using Leveled compaction with 160Mb sstable size.
 PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to 
 be finished. Because this, we can not run full repair for about a month :(



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (CASSANDRA-6698) Many too small SSTables when full repair

2014-02-12 Thread Roman Skvazh (JIRA)

 [ 
https://issues.apache.org/jira/browse/CASSANDRA-6698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Roman Skvazh updated CASSANDRA-6698:


Description: 
We are have troubles when cassandra drops messages because there is too many 
(over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
too) and many pending compactions (over 700).

We are using Leveled compaction with 160Mb sstable size.
PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to be 
finished. Because this, we can not run full repair for about a month :(

  was:
We are have troubles when cassandra drops messages because there is too many 
(over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
too) and many pending compactions (over 700).

We are using Leveled compaction with 165Mb sstable size.
PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to be 
finished. Because this, we can not run full repair for about a month :(


 Many too small SSTables when full repair
 

 Key: CASSANDRA-6698
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6698
 Project: Cassandra
  Issue Type: Bug
Reporter: Roman Skvazh
Priority: Critical
 Attachments: cassa-many-small-sstables.txt


 We are have troubles when cassandra drops messages because there is too many 
 (over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
 too) and many pending compactions (over 700).
 We are using Leveled compaction with 160Mb sstable size.
 PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to 
 be finished. Because this, we can not run full repair for about a month :(



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (CASSANDRA-6698) Many too small SSTables when full repair

2014-02-12 Thread Roman Skvazh (JIRA)

 [ 
https://issues.apache.org/jira/browse/CASSANDRA-6698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Roman Skvazh updated CASSANDRA-6698:


Description: 
We have troubles when cassandra drops messages because there is too many (over 
10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes too) 
and many pending compactions (over 700).

We are using Leveled compaction with 160Mb sstable size.
PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to be 
finished. Because this, we can not run full repair for about a month :(

  was:
We are have troubles when cassandra drops messages because there is too many 
(over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
too) and many pending compactions (over 700).

We are using Leveled compaction with 160Mb sstable size.
PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to be 
finished. Because this, we can not run full repair for about a month :(


 Many too small SSTables when full repair
 

 Key: CASSANDRA-6698
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6698
 Project: Cassandra
  Issue Type: Bug
Reporter: Roman Skvazh
Priority: Critical
 Attachments: cassa-many-small-sstables.txt


 We have troubles when cassandra drops messages because there is too many 
 (over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
 too) and many pending compactions (over 700).
 We are using Leveled compaction with 160Mb sstable size.
 PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to 
 be finished. Because this, we can not run full repair for about a month :(



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6698) Many too small SSTables when full repair

2014-02-12 Thread Roman Skvazh (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13899769#comment-13899769
 ] 

Roman Skvazh commented on CASSANDRA-6698:
-

We can not use STCS because we have wide-rows and heavy inserts/deletes

 Many too small SSTables when full repair
 

 Key: CASSANDRA-6698
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6698
 Project: Cassandra
  Issue Type: Improvement
Reporter: Roman Skvazh
Priority: Minor
 Attachments: cassa-many-small-sstables.txt


 We have troubles when cassandra drops messages because there is too many 
 (over 10,000 on one column family) small (from 1Kb to 200Kb, and normal sizes 
 too) and many pending compactions (over 700).
 We are using Leveled compaction with 160Mb sstable size.
 PS. Temp fix: stop repair, disable thrift,gossip and wait for compactions to 
 be finished. Because this, we can not run full repair for about a month :(



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6629) Coordinator's java.lang.ArrayIndexOutOfBoundsException: -1 with CL 1

2014-01-29 Thread Roman Skvazh (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13885183#comment-13885183
 ] 

Roman Skvazh commented on CASSANDRA-6629:
-

Guys, what about scrub and read repair problem?

 Coordinator's java.lang.ArrayIndexOutOfBoundsException: -1 with CL  1
 

 Key: CASSANDRA-6629
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6629
 Project: Cassandra
  Issue Type: Bug
  Components: API
 Environment: 15 nodes, 2.0.4, RF=3
Reporter: Roman Skvazh
Assignee: Mikhail Stepura
 Fix For: 1.2.14, 2.0.5

 Attachments: CASSANDRA-1.2-6629-v2.patch, CASSANDRA-2.0-6629-v2.patch


 I've got this error in system.log on all coordinators
 {noformat}
 ERROR [Thrift:37555] 2014-01-28 19:53:51,547 CustomTThreadPoolServer.java 
 (line 212) Error occurred during processing of message.
 java.lang.ArrayIndexOutOfBoundsException: -1
 at java.util.ArrayList.elementData(ArrayList.java:400)
 at java.util.ArrayList.remove(ArrayList.java:477)
 at 
 org.apache.cassandra.db.ArrayBackedSortedColumns$ReverseSortedCollection$1.remove(ArrayBackedSortedColumns.java:373)
 at 
 org.apache.cassandra.db.filter.SliceQueryFilter.trim(SliceQueryFilter.java:249)
 at 
 org.apache.cassandra.db.SliceFromReadCommand.maybeTrim(SliceFromReadCommand.java:101)
 at 
 org.apache.cassandra.service.StorageProxy.fetchRows(StorageProxy.java:1370)
 at 
 org.apache.cassandra.service.StorageProxy.read(StorageProxy.java:1189)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:188)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:163)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:58)
 at 
 org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:188)
 at 
 org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:222)
 at 
 org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:212)
 at 
 org.apache.cassandra.thrift.CassandraServer.execute_cql3_query(CassandraServer.java:1958)
 at 
 org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4486)
 at 
 org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4470)
 at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
 at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
 at 
 org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:194)
 at 
 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
 at java.lang.Thread.run(Thread.java:744)
 {noformat}
 It's occurred on coordinator (not always primary or secondary of this uid-PK) 
 when I execute query (PHP or Python client got TSocket read 0 bytes 
 exception):
 {code:sql}SELECT * FROM home_timeline WHERE uid = 0x52dcbc794989a6ea2c8b4569 
 ORDER BY tuuid DESC LIMIT 32{code}
 If limit  32, then its ok. When ORDER ... ASC its ok. When ConsistencyLevel 
 1 its ok.
 On one node data is inconsistent with two others, and read repair won't work 
 (32-nd element is odd).
 Our RF = 3
 Cassandra version 2.0.4



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Created] (CASSANDRA-6629) Coordinator's java.lang.ArrayIndexOutOfBoundsException: -1 with CL 1

2014-01-28 Thread Roman Skvazh (JIRA)
Roman Skvazh created CASSANDRA-6629:
---

 Summary: Coordinator's java.lang.ArrayIndexOutOfBoundsException: 
-1 with CL  1
 Key: CASSANDRA-6629
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6629
 Project: Cassandra
  Issue Type: Bug
 Environment: 15 nodes, 2.0.4, RF=3
Reporter: Roman Skvazh


I've got this error in system.log on all coordinators
{noformat}
ERROR [Thrift:37555] 2014-01-28 19:53:51,547 CustomTThreadPoolServer.java (line 
212) Error occurred during processing of message.
java.lang.ArrayIndexOutOfBoundsException: -1
at java.util.ArrayList.elementData(ArrayList.java:400)
at java.util.ArrayList.remove(ArrayList.java:477)
at 
org.apache.cassandra.db.ArrayBackedSortedColumns$ReverseSortedCollection$1.remove(ArrayBackedSortedColumns.java:373)
at 
org.apache.cassandra.db.filter.SliceQueryFilter.trim(SliceQueryFilter.java:249)
at 
org.apache.cassandra.db.SliceFromReadCommand.maybeTrim(SliceFromReadCommand.java:101)
at 
org.apache.cassandra.service.StorageProxy.fetchRows(StorageProxy.java:1370)
at 
org.apache.cassandra.service.StorageProxy.read(StorageProxy.java:1189)
at 
org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:188)
at 
org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:163)
at 
org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:58)
at 
org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:188)
at 
org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:222)
at 
org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:212)
at 
org.apache.cassandra.thrift.CassandraServer.execute_cql3_query(CassandraServer.java:1958)
at 
org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4486)
at 
org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4470)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
at 
org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:194)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
{noformat}

It's occurred on coordinator (not always primary or secondary of this uid-PK) 
when I execute query (PHP or Python client got TSocket read 0 bytes 
exception):

{code:sql}SELECT * FROM home_timeline WHERE uid = 0x52dcbc794989a6ea2c8b4569 
ORDER BY tuuid DESC LIMIT 32{code}

If limit  32, then its ok. When ORDER ... ASC its ok. When ConsistencyLevel 1 
its ok.
On one node data is inconsistent with two others, and read repair won't work 
(32-nd element is odd).

Our RF = 3
Cassandra version 2.0.4



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6629) Coordinator's java.lang.ArrayIndexOutOfBoundsException: -1 with CL 1

2014-01-28 Thread Roman Skvazh (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13884560#comment-13884560
 ] 

Roman Skvazh commented on CASSANDRA-6629:
-

Does this linked with CASSANDRA-6333?

 Coordinator's java.lang.ArrayIndexOutOfBoundsException: -1 with CL  1
 

 Key: CASSANDRA-6629
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6629
 Project: Cassandra
  Issue Type: Bug
 Environment: 15 nodes, 2.0.4, RF=3
Reporter: Roman Skvazh

 I've got this error in system.log on all coordinators
 {noformat}
 ERROR [Thrift:37555] 2014-01-28 19:53:51,547 CustomTThreadPoolServer.java 
 (line 212) Error occurred during processing of message.
 java.lang.ArrayIndexOutOfBoundsException: -1
 at java.util.ArrayList.elementData(ArrayList.java:400)
 at java.util.ArrayList.remove(ArrayList.java:477)
 at 
 org.apache.cassandra.db.ArrayBackedSortedColumns$ReverseSortedCollection$1.remove(ArrayBackedSortedColumns.java:373)
 at 
 org.apache.cassandra.db.filter.SliceQueryFilter.trim(SliceQueryFilter.java:249)
 at 
 org.apache.cassandra.db.SliceFromReadCommand.maybeTrim(SliceFromReadCommand.java:101)
 at 
 org.apache.cassandra.service.StorageProxy.fetchRows(StorageProxy.java:1370)
 at 
 org.apache.cassandra.service.StorageProxy.read(StorageProxy.java:1189)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:188)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:163)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:58)
 at 
 org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:188)
 at 
 org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:222)
 at 
 org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:212)
 at 
 org.apache.cassandra.thrift.CassandraServer.execute_cql3_query(CassandraServer.java:1958)
 at 
 org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4486)
 at 
 org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4470)
 at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
 at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
 at 
 org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:194)
 at 
 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
 at java.lang.Thread.run(Thread.java:744)
 {noformat}
 It's occurred on coordinator (not always primary or secondary of this uid-PK) 
 when I execute query (PHP or Python client got TSocket read 0 bytes 
 exception):
 {code:sql}SELECT * FROM home_timeline WHERE uid = 0x52dcbc794989a6ea2c8b4569 
 ORDER BY tuuid DESC LIMIT 32{code}
 If limit  32, then its ok. When ORDER ... ASC its ok. When ConsistencyLevel 
 1 its ok.
 On one node data is inconsistent with two others, and read repair won't work 
 (32-nd element is odd).
 Our RF = 3
 Cassandra version 2.0.4



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6629) Coordinator's java.lang.ArrayIndexOutOfBoundsException: -1 with CL 1

2014-01-28 Thread Roman Skvazh (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13884743#comment-13884743
 ] 

Roman Skvazh commented on CASSANDRA-6629:
-

Does this fix (idx--) solve problem with read repair?

 Coordinator's java.lang.ArrayIndexOutOfBoundsException: -1 with CL  1
 

 Key: CASSANDRA-6629
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6629
 Project: Cassandra
  Issue Type: Bug
  Components: API
 Environment: 15 nodes, 2.0.4, RF=3
Reporter: Roman Skvazh
Assignee: Mikhail Stepura
 Fix For: 2.0.5


 I've got this error in system.log on all coordinators
 {noformat}
 ERROR [Thrift:37555] 2014-01-28 19:53:51,547 CustomTThreadPoolServer.java 
 (line 212) Error occurred during processing of message.
 java.lang.ArrayIndexOutOfBoundsException: -1
 at java.util.ArrayList.elementData(ArrayList.java:400)
 at java.util.ArrayList.remove(ArrayList.java:477)
 at 
 org.apache.cassandra.db.ArrayBackedSortedColumns$ReverseSortedCollection$1.remove(ArrayBackedSortedColumns.java:373)
 at 
 org.apache.cassandra.db.filter.SliceQueryFilter.trim(SliceQueryFilter.java:249)
 at 
 org.apache.cassandra.db.SliceFromReadCommand.maybeTrim(SliceFromReadCommand.java:101)
 at 
 org.apache.cassandra.service.StorageProxy.fetchRows(StorageProxy.java:1370)
 at 
 org.apache.cassandra.service.StorageProxy.read(StorageProxy.java:1189)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:188)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:163)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:58)
 at 
 org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:188)
 at 
 org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:222)
 at 
 org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:212)
 at 
 org.apache.cassandra.thrift.CassandraServer.execute_cql3_query(CassandraServer.java:1958)
 at 
 org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4486)
 at 
 org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4470)
 at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
 at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
 at 
 org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:194)
 at 
 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
 at java.lang.Thread.run(Thread.java:744)
 {noformat}
 It's occurred on coordinator (not always primary or secondary of this uid-PK) 
 when I execute query (PHP or Python client got TSocket read 0 bytes 
 exception):
 {code:sql}SELECT * FROM home_timeline WHERE uid = 0x52dcbc794989a6ea2c8b4569 
 ORDER BY tuuid DESC LIMIT 32{code}
 If limit  32, then its ok. When ORDER ... ASC its ok. When ConsistencyLevel 
 1 its ok.
 On one node data is inconsistent with two others, and read repair won't work 
 (32-nd element is odd).
 Our RF = 3
 Cassandra version 2.0.4



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6629) Coordinator's java.lang.ArrayIndexOutOfBoundsException: -1 with CL 1

2014-01-28 Thread Roman Skvazh (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13884775#comment-13884775
 ] 

Roman Skvazh commented on CASSANDRA-6629:
-

Wow. It seems nodetool scrub on node with odd row helped to me. Read repair 
restore that 32-nd row on other replicas, this CQL query worked properly and 
without exception now...

 Coordinator's java.lang.ArrayIndexOutOfBoundsException: -1 with CL  1
 

 Key: CASSANDRA-6629
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6629
 Project: Cassandra
  Issue Type: Bug
  Components: API
 Environment: 15 nodes, 2.0.4, RF=3
Reporter: Roman Skvazh
Assignee: Mikhail Stepura
 Fix For: 2.0.5


 I've got this error in system.log on all coordinators
 {noformat}
 ERROR [Thrift:37555] 2014-01-28 19:53:51,547 CustomTThreadPoolServer.java 
 (line 212) Error occurred during processing of message.
 java.lang.ArrayIndexOutOfBoundsException: -1
 at java.util.ArrayList.elementData(ArrayList.java:400)
 at java.util.ArrayList.remove(ArrayList.java:477)
 at 
 org.apache.cassandra.db.ArrayBackedSortedColumns$ReverseSortedCollection$1.remove(ArrayBackedSortedColumns.java:373)
 at 
 org.apache.cassandra.db.filter.SliceQueryFilter.trim(SliceQueryFilter.java:249)
 at 
 org.apache.cassandra.db.SliceFromReadCommand.maybeTrim(SliceFromReadCommand.java:101)
 at 
 org.apache.cassandra.service.StorageProxy.fetchRows(StorageProxy.java:1370)
 at 
 org.apache.cassandra.service.StorageProxy.read(StorageProxy.java:1189)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:188)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:163)
 at 
 org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:58)
 at 
 org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:188)
 at 
 org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:222)
 at 
 org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:212)
 at 
 org.apache.cassandra.thrift.CassandraServer.execute_cql3_query(CassandraServer.java:1958)
 at 
 org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4486)
 at 
 org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4470)
 at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
 at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
 at 
 org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:194)
 at 
 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
 at 
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
 at java.lang.Thread.run(Thread.java:744)
 {noformat}
 It's occurred on coordinator (not always primary or secondary of this uid-PK) 
 when I execute query (PHP or Python client got TSocket read 0 bytes 
 exception):
 {code:sql}SELECT * FROM home_timeline WHERE uid = 0x52dcbc794989a6ea2c8b4569 
 ORDER BY tuuid DESC LIMIT 32{code}
 If limit  32, then its ok. When ORDER ... ASC its ok. When ConsistencyLevel 
 1 its ok.
 On one node data is inconsistent with two others, and read repair won't work 
 (32-nd element is odd).
 Our RF = 3
 Cassandra version 2.0.4



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Commented] (CASSANDRA-6055) 'Bad Request: Invalid null value for partition key part' on SELECT .. WHERE key IN (val,NULL)

2013-10-07 Thread Roman Skvazh (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-6055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13787994#comment-13787994
 ] 

Roman Skvazh commented on CASSANDRA-6055:
-

I agree with Sylvain Lebresne. CQL is not SQL and there is no need for this 
hack (ignore NULL values in queries).

 'Bad Request: Invalid null value for partition key part' on SELECT .. WHERE 
 key IN (val,NULL)
 -

 Key: CASSANDRA-6055
 URL: https://issues.apache.org/jira/browse/CASSANDRA-6055
 Project: Cassandra
  Issue Type: Bug
 Environment: cqlsh, pdo_cassandra
Reporter: Sergey Nagaytsev
Priority: Minor
  Labels: cql3

 Query: SELECT * FROM user WHERE key IN(uuid,NULL);
 Table:
 CREATE COLUMNFAMILY user (
  KEY uuid PRIMARY KEY,
  name text,
  note text,
  avatar text,
  email text,
  phone text,
  login text,
  pw text,
  st text
 );
 Logs: Nothing, last message hours ago.
 This query is good in SQL and so is generated by DB abstraction library. Fix 
 on applications sides is multiplying of work.



--
This message was sent by Atlassian JIRA
(v6.1#6144)