Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D57C310AA3 for ; Thu, 5 Sep 2013 13:53:13 +0000 (UTC) Received: (qmail 51936 invoked by uid 500); 5 Sep 2013 13:53:11 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 51872 invoked by uid 500); 5 Sep 2013 13:53:07 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 51864 invoked by uid 99); 5 Sep 2013 13:53:06 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Sep 2013 13:53:06 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of janecek@avast.com designates 74.125.83.51 as permitted sender) Received: from [74.125.83.51] (HELO mail-ee0-f51.google.com) (74.125.83.51) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Sep 2013 13:52:59 +0000 Received: by mail-ee0-f51.google.com with SMTP id c1so907430eek.24 for ; Thu, 05 Sep 2013 06:52:39 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:date:from:to:message-id:subject:mime-version :content-type; bh=fHsZIos7X0kEuMW9WNYIEuZAo1gX2rUJQXtFWrv97xc=; b=k2Dh/pVPl1VGvN1EgG2zvNBS2rf5gDNnABbOreEBnqqUSBb7eErbHHfBXcKMJSQ0Hv hOtyuRTWfSbE1lvyaj+dvYUeWBCUfPqCzmgTClGIwkK7x+C9V8RUKeq0dQFZhBMG0JtQ kuM3DCBUdcF36epmQsRFaHjN0EKCVencqS9E9cDYp/uTB8omHr/61dSZvF1O+ETelfqi k8td15ur/EW6It1CyK1IQsZic/TOGIlYX6oco0DMe4UvF7YCuxjagaIcqE40iJUa3k9L s6/EisDspw+jqhT5qHqKDSj2Ymf19hfCKUVd8uIvv/TIFylIY+T4VB7NS8TcyewxeQsv GYwQ== X-Gm-Message-State: ALoCoQnI/EBgoegstjo8cDqzt3lw7SBRhQfc8+uk+09bwREyURMfpU53i515155hhOWQMtSjZQc1 X-Received: by 10.14.175.2 with SMTP id y2mr1032432eel.83.1378389159047; Thu, 05 Sep 2013 06:52:39 -0700 (PDT) Received: from [2001:67c:284:14:56fd:246d:e05e:332d] ([2001:67c:284:14:e478:5766:e8ca:2502]) by mx.google.com with ESMTPSA id f49sm48864484eec.7.1969.12.31.16.00.00 (version=TLSv1 cipher=RC4-SHA bits=128/128); Thu, 05 Sep 2013 06:52:38 -0700 (PDT) Date: Thu, 5 Sep 2013 15:52:36 +0200 From: =?utf-8?Q?Jakub_Jane=C4=8Dek?= To: user@cassandra.apache.org Message-ID: <7D5C8703F12C4D5892577A2D045DFD5D@avast.com> Subject: Is CAS working in Cassandra 2.0? X-Mailer: sparrow 1.6.4 (build 1178) MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="52288ca4_13916f2d_fc" X-Virus-Checked: Checked by ClamAV on apache.org --52288ca4_13916f2d_fc Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hello, =20 I wanted to use the new CAS functionality in Cassandra 2.0 and for some r= eason it does not work when I try to update or insert a row when CAS fail= s. Let me show: I have a fresh installation of Cassandra 2.0 on my Mac OS filled with a k= eyspace and this column family: CREATE TABLE cardinality ( key blob, column1 blob, value blob, PRIMARY KEY (key, column1) ) WITH COMPACT STORAGE AND bloom=5Ffilter=5Ffp=5Fchance=3D0.010000 AND caching=3D'KEYS=5FONLY' AND comment=3D'' AND dclocal=5Fread=5Frepair=5Fchance=3D0.000000 AND gc=5Fgrace=5Fseconds=3D864000 AND index=5Finterval=3D128 AND read=5Frepair=5Fchance=3D1.000000 AND replicate=5Fon=5Fwrite=3D'true' AND populate=5Fio=5Fcache=5Fon=5Fflush=3D'false' AND default=5Ftime=5Fto=5Flive=3D0 AND speculative=5Fretry=3D'NONE' AND memtable=5Fflush=5Fperiod=5Fin=5Fms=3D0 AND compaction=3D=7B'class': 'SizeTieredCompactionStrategy'=7D AND compression=3D=7B'sstable=5Fcompression': 'LZ4Compressor'=7D; Using CQL shell: cqlsh:keyspace> select * from cardinality; (0 rows) cqlsh:keyspace> insert into cardinality (key, column1, value) values (0x0= 001, 0x0002, 0x0003) if not exists; cqlsh:keyspace> insert into cardinality (key, column1, value) values (0x0= 001, 0x0002, 0x0003) if not exists; Request did not complete within rpc=5Ftimeout. cqlsh:keyspace> select * from cardinality; key =7C column1 =7C value --------+---------+-------- 0x0001 =7C 0x0002 =7C 0x0003 (1 rows) cqlsh:keyspace> update cardinality set value =3D 0x0004 where key =3D 0x0= 001 and column1 =3D 0x0002 if value =3D 0x0003; cqlsh:keyspace> select * from cardinality; key =7C column1 =7C value --------+---------+-------- 0x0001 =7C 0x0002 =7C 0x0004 (1 rows) cqlsh:keyspace> update cardinality set value =3D 0x0005 where key =3D 0x0= 001 and column1 =3D 0x0002 if value =3D 0x9999; Internal application error cqlsh:keyspace> select * from cardinality; key =7C column1 =7C value --------+---------+-------- 0x0001 =7C 0x0002 =7C 0x0004 (1 rows) Can someone explain why I get the =22rpc=5Ftimeout=22 and =22Internal app= lication error=22 errors=3F In my opinion this should work and only give = me the result that insert/update failed because of CAS condtion. =20 The Cassandra outputs these stacktraces: ERROR 15:47:42,072 Exception in thread Thread=5BReadStage:82,5,main=5D java.lang.RuntimeException: java.lang.ClassCastException: org.apache.cass= andra.db.marshal.BytesType cannot be cast to org.apache.cassandra.db.mars= hal.CompositeType at org.apache.cassandra.service.StorageProxy=24DroppableRunnable.run(Stor= ageProxy.java:1867) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.j= ava:1145) at java.util.concurrent.ThreadPoolExecutor=24Worker.run(ThreadPoolExecuto= r.java:615) at java.lang.Thread.run(Thread.java:724) Caused by: java.lang.ClassCastException: org.apache.cassandra.db.marshal.= BytesType cannot be cast to org.apache.cassandra.db.marshal.CompositeType= at org.apache.cassandra.db.filter.SliceQuery=46ilter.columnCounter(SliceQ= uery=46ilter.java:219) at org.apache.cassandra.db.filter.SliceQuery=46ilter.collectReducedColumn= s(SliceQuery=46ilter.java:186) at org.apache.cassandra.db.filter.Query=46ilter.collateColumns(Query=46il= ter.java:122) at org.apache.cassandra.db.filter.Query=46ilter.collateOnDiskAtom(Query=46= ilter.java:80) at org.apache.cassandra.db.filter.Query=46ilter.collateOnDiskAtom(Query=46= ilter.java:72) at org.apache.cassandra.db.CollationController.collectAllData(CollationCo= ntroller.java:314) at org.apache.cassandra.db.CollationController.getTopLevelColumns(Collati= onController.java:53) at org.apache.cassandra.db.Column=46amilyStore.getTopLevelColumns(Column=46= amilyStore.java:1469) at org.apache.cassandra.db.Column=46amilyStore.getColumn=46amily(Column=46= amilyStore.java:1295) at org.apache.cassandra.db.Keyspace.getRow(Keyspace.java:332) at org.apache.cassandra.db.Slice=46romReadCommand.getRow(Slice=46romReadC= ommand.java:65) at org.apache.cassandra.service.StorageProxy=24LocalReadRunnable.runMayTh= row(StorageProxy.java:1336) at org.apache.cassandra.service.StorageProxy=24DroppableRunnable.run(Stor= ageProxy.java:1863) ... 3 more ERROR 15:48:50,811 Internal error processing execute=5Fcql3=5Fquery java.lang.NullPointerException at org.apache.cassandra.cql3.C=46Definition.get(C=46Definition.java:119) at org.apache.cassandra.cql3.statements.ModificationStatement.buildCas=46= ailureResultSet(ModificationStatement.java:441) at org.apache.cassandra.cql3.statements.ModificationStatement.buildCasRes= ultSet(ModificationStatement.java:407) at org.apache.cassandra.cql3.statements.ModificationStatement.executeWith= Condition(ModificationStatement.java:395) at org.apache.cassandra.cql3.statements.ModificationStatement.execute(Mod= ificationStatement.java:344) at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcess= or.java:101) at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:1= 17) at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:1= 08) at org.apache.cassandra.thrift.CassandraServer.execute=5Fcql3=5Fquery(Cas= sandraServer.java:1920) at org.apache.cassandra.thrift.Cassandra=24Processor=24execute=5Fcql3=5Fq= uery.getResult(Cassandra.java:4372) at org.apache.cassandra.thrift.Cassandra=24Processor=24execute=5Fcql3=5Fq= uery.getResult(Cassandra.java:4356) at org.apache.thrift.Process=46unction.process(Process=46unction.java:39)= at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.cassandra.thrift.CustomTThreadPoolServer=24WorkerProcess.ru= n(CustomTThreadPoolServer.java:194) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.j= ava:1145) at java.util.concurrent.ThreadPoolExecutor=24Worker.run(ThreadPoolExecuto= r.java:615) at java.lang.Thread.run(Thread.java:724) Thanks for any help. -- =20 Jakub Jane=C4=8Dek --52288ca4_13916f2d_fc Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Hello,

I wanted to use the new CAS fun= ctionality in Cassandra 2.0 and for some reason it does not work when I t= ry to update or insert a row when CAS fails. Let me show:

<= /div>
I have a fresh installation of Cassandra 2.0 on my Mac OS fille= d with a keyspace and this column family:

C= REATE TABLE cardinality (
  key blob,
  col= umn1 blob,
  value blob,
  PRIMARY KEY (key= , column1)
) WITH COMPACT STORAGE AND
  bloom=5F= filter=5Ffp=5Fchance=3D0.010000 AND
  caching=3D'KEYS=5FON= LY' AND
  comment=3D'' AND
  dclocal=5Fread= =5Frepair=5Fchance=3D0.000000 AND
  gc=5Fgrace=5Fseconds=3D= 864000 AND
  index=5Finterval=3D128 AND
  r= ead=5Frepair=5Fchance=3D1.000000 AND
  replicate=5Fon=5Fwr= ite=3D'true' AND
  populate=5Fio=5Fcache=5Fon=5Fflush=3D'f= alse' AND
  default=5Ftime=5Fto=5Flive=3D0 AND
&= nbsp; speculative=5Fretry=3D'NONE' AND
  memtable=5Fflush=5F= period=5Fin=5Fms=3D0 AND
  compaction=3D=7B'class': 'SizeT= ieredCompactionStrategy'=7D AND
  compression=3D=7B'sstabl= e=5Fcompression': 'LZ4Compressor'=7D;

Using CQL = shell:

cqlsh:keyspace> select * from car= dinality;

(0 rows)

cqls= h:keyspace> insert into cardinality (key, column1, value) values (0x00= 01, 0x0002, 0x0003) if not exists;
cqlsh:keyspace> insert in= to cardinality (key, column1, value) values (0x0001, 0x0002, 0x0003) if n= ot exists;
Request did not complete within rpc=5Ftimeout.
=
cqlsh:keyspace> select * from cardinality;

 key    =7C column1 =7C value
--------+------= ---+--------
 0x0001 =7C  0x0002 =7C 0x0003

(1 rows)

cqlsh:keyspace> upda= te cardinality set value =3D 0x0004 where key =3D 0x0001 and column1 =3D = 0x0002 if value =3D 0x0003;
cqlsh:keyspace> select * from ca= rdinality;

 key    =7C column1 =7C= value
--------+---------+--------
 0x0001 =7C &= nbsp;0x0002 =7C 0x0004

(1 rows)

cqlsh:keyspace> update cardinality set value =3D 0x0005 where= key =3D 0x0001 and column1 =3D 0x0002 if value =3D 0x9999;
Int= ernal application error
cqlsh:keyspace> select * from cardin= ality;

 key    =7C column1 =7C va= lue
--------+---------+--------
 0x0001 =7C &nbs= p;0x0002 =7C 0x0004

(1 rows)

Can someone explain why I get the =22rpc=5Ftimeout=22 and =22Intern= al application error=22 errors=3F In my opinion this should work and only= give me the result that insert/update failed because of CAS condtion.

The Cassandra outputs these stac= ktraces:
ERROR 15:47:42,072 Exception in thread Thread=5BR= eadStage:82,5,main=5D
java.lang.RuntimeException: java.lang.Cla= ssCastException: org.apache.cassandra.db.marshal.BytesType cannot be cast= to org.apache.cassandra.db.marshal.CompositeType
at org.apache.= cassandra.service.StorageProxy=24DroppableRunnable.run(StorageProxy.java:= 1867)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Thre= adPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExe= cutor=24Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thre= ad.run(Thread.java:724)
Caused by: java.lang.ClassCastException= : org.apache.cassandra.db.marshal.BytesType cannot be cast to org.apache.= cassandra.db.marshal.CompositeType
at org.apache.cassandra.db.f= ilter.SliceQuery=46ilter.columnCounter(SliceQuery=46ilter.java:219)
=
at org.apache.cassandra.db.filter.SliceQuery=46ilter.collectReducedC= olumns(SliceQuery=46ilter.java:186)
at org.apache.cassandra.db.= filter.Query=46ilter.collateColumns(Query=46ilter.java:122)
at = org.apache.cassandra.db.filter.Query=46ilter.collateOnDiskAtom(Query=46il= ter.java:80)
at org.apache.cassandra.db.filter.Query=46ilter.co= llateOnDiskAtom(Query=46ilter.java:72)
at org.apache.cassandra.= db.CollationController.collectAllData(CollationController.java:314)
=
at org.apache.cassandra.db.CollationController.getTopLevelColumns(Co= llationController.java:53)
at org.apache.cassandra.db.Column=46= amilyStore.getTopLevelColumns(Column=46amilyStore.java:1469)
at= org.apache.cassandra.db.Column=46amilyStore.getColumn=46amily(Column=46a= milyStore.java:1295)
at org.apache.cassandra.db.Keyspace.getRow(= Keyspace.java:332)
at org.apache.cassandra.db.Slice=46romReadComm= and.getRow(Slice=46romReadCommand.java:65)
at org.apache.cassan= dra.service.StorageProxy=24LocalReadRunnable.runMayThrow(StorageProxy.jav= a:1336)
at org.apache.cassandra.service.StorageProxy=24Droppabl= eRunnable.run(StorageProxy.java:1863)
... 3 more
ERRO= R 15:48:50,811 Internal error processing execute=5Fcql3=5Fquery
java.lang.NullPointerException
at org.apache.cassandra.cql3.C=46= Definition.get(C=46Definition.java:119)
at org.apache.cassandra= .cql3.statements.ModificationStatement.buildCas=46ailureResultSet(Modific= ationStatement.java:441)
at org.apache.cassandra.cql3.statement= s.ModificationStatement.buildCasResultSet(ModificationStatement.java:407)=
at org.apache.cassandra.cql3.statements.ModificationStatement.ex= ecuteWithCondition(ModificationStatement.java:395)
at org.apache.= cassandra.cql3.statements.ModificationStatement.execute(ModificationState= ment.java:344)
at org.apache.cassandra.cql3.QueryProcessor.proc= essStatement(QueryProcessor.java:101)
at org.apache.cassandra.c= ql3.QueryProcessor.process(QueryProcessor.java:117)
at org.apac= he.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:108)
at org.apache.cassandra.thrift.CassandraServer.execute=5Fcql3=5Fquery(= CassandraServer.java:1920)
at org.apache.cassandra.thrift.Cassa= ndra=24Processor=24execute=5Fcql3=5Fquery.getResult(Cassandra.java:4372)<= /div>
at org.apache.cassandra.thrift.Cassandra=24Processor=24execute=5F= cql3=5Fquery.getResult(Cassandra.java:4356)
at org.apache.thrif= t.Process=46unction.process(Process=46unction.java:39)
at org.a= pache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
at = org.apache.cassandra.thrift.CustomTThreadPoolServer=24WorkerProcess.run(C= ustomTThreadPoolServer.java:194)
at java.util.concurrent.Thread= PoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.ut= il.concurrent.ThreadPoolExecutor=24Worker.run(ThreadPoolExecutor.java:615= )
at java.lang.Thread.run(Thread.java:724)

=
Thanks for any help.
-- 
Jakub Jane=C4= =8Dek

--52288ca4_13916f2d_fc--