From cassandra-user-return-114-apmail-incubator-cassandra-user-archive=incubator.apache.org@incubator.apache.org Sun Jun 28 19:59:13 2009 Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 47917 invoked from network); 28 Jun 2009 19:59:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 28 Jun 2009 19:59:13 -0000 Received: (qmail 88842 invoked by uid 500); 28 Jun 2009 19:59:24 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 88796 invoked by uid 500); 28 Jun 2009 19:59:23 -0000 Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-user@incubator.apache.org Delivered-To: mailing list cassandra-user@incubator.apache.org Received: (qmail 88787 invoked by uid 99); 28 Jun 2009 19:59:23 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 28 Jun 2009 19:59:23 +0000 X-ASF-Spam-Status: No, hits=4.9 required=10.0 tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,SPF_NEUTRAL,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [74.125.92.147] (HELO qw-out-1920.google.com) (74.125.92.147) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 28 Jun 2009 19:59:13 +0000 Received: by qw-out-1920.google.com with SMTP id 5so1545590qwf.54 for ; Sun, 28 Jun 2009 12:58:51 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.100.14 with SMTP id w14mr1452116qcn.48.1246219131426; Sun, 28 Jun 2009 12:58:51 -0700 (PDT) Date: Sun, 28 Jun 2009 15:58:51 -0400 Message-ID: <70cd74010906281258s4f74c97eoe62877127589cb97@mail.gmail.com> Subject: A few issues with the latest code From: Ivan Chang To: cassandra-user@incubator.apache.org Content-Type: multipart/alternative; boundary=0016363109bba41a9f046d6e008e X-Virus-Checked: Checked by ClamAV on apache.org --0016363109bba41a9f046d6e008e Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Jonathan, I have checked out the latest version of Cassandra and noticed a few things not working. Here's the sequence of steps I conducted: 1. Start up cassandra successfully (listener bind to 192.168.216.162) ichang@ubuntu:~/workspace/Cassandra2$ bin/cassandra ichang@ubuntu:~/workspace/Cassandra2$ Listening for transport dt_socket at address: 8888 DEBUG - Loading settings from bin/../conf/storage-conf.xml DEBUG - adding Super1 as 0 DEBUG - adding Standard2 as 1 DEBUG - adding Standard1 as 2 DEBUG - adding StandardByTime1 as 3 DEBUG - adding LocationInfo as 4 DEBUG - adding HintsColumnFamily as 5 DEBUG - Starting to listen on 192.168.216.162:7001 2. http://192.168.216.162:7002 NOT working, older versions of code is working 3. Smoke test through cassandra-cli is successful, but the syntax get Table1.Standard1['jsmith'] isn't working, the system.log indicated the error DEBUG [pool-1-thread-1] 2009-06-28 15:46:25,621 CqlDriver.java (line 40) Compiling CQL query ... DEBUG [pool-1-thread-1] 2009-06-28 15:46:25,621 SemanticPhase.java (line 67) AST: (A_GET (A_COLUMN_ACCESS Table1 Standard1 'j smith')) DEBUG [pool-1-thread-1] 2009-06-28 15:46:25,621 CqlDriver.java (line 44) Executing CQL query ... DEBUG [pool-1-thread-1] 2009-06-28 15:46:25,621 StorageProxy.java (line 593) weakreadlocal reading SliceFromReadCommand(table ='Table1', key='jsmith', columnFamily='Standard1', isAscending='true', count='2147483647') ERROR [pool-1-thread-1] 2009-06-28 15:46:25,621 ColumnRangeQueryRSD.java (line 105) Exception was generated at : 06/28/2009 1 5:46:25 on thread pool-1-thread-1 1 java.lang.ArrayIndexOutOfBoundsException: 1 at org.apache.cassandra.db.Table.getSliceFrom(Table.java:613) at org.apache.cassandra.db.SliceFromReadCommand.getRow(SliceFromReadCommand.java:55) at org.apache.cassandra.service.StorageProxy.weakReadLocal(StorageProxy.java:600) at org.apache.cassandra.service.StorageProxy.readProtocol(StorageProxy.java:303) at org.apache.cassandra.cql.common.ColumnRangeQueryRSD.getRows(ColumnRangeQueryRSD.java:101) at org.apache.cassandra.cql.common.QueryPlan.execute(QueryPlan.java:41) at org.apache.cassandra.cql.driver.CqlDriver.executeQuery(CqlDriver.java:45) at org.apache.cassandra.service.CassandraServer.executeQuery(CassandraServer.java:513) at org.apache.cassandra.service.Cassandra$Processor$executeQuery.process(Cassandra.java:1321) at org.apache.cassandra.service.Cassandra$Processor.process(Cassandra.java:837) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:252) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) ichang@ubuntu:~/workspace/Cassandra2$ bin/cassandra-cli --host 192.168.216.162 --port 9160 Connected to 192.168.216.162/9160 Welcome to cassandra CLI. Type 'help' or '?' for help. Type 'quit' or 'exit' to quit. cassandra> set Table1.Standard1['jsmith']['first'] = 'John' Statement processed. cassandra> get Table1.Standard1['jsmith'] Error: CQL Execution Error cassandra> set Table1.Standard1['jsmith']['last'] = 'Smith' Statement processed. cassandra> set Table1.Standard1['jsmith']['age'] = '42' Statement processed. cassandra> get Table1.Standard1['jsmith'] Error: CQL Execution Error cassandra> get Table1.Standard1['jsmith']['first'] COLUMN_TIMESTAMP = 1246217984436; COLUMN_VALUE = John; COLUMN_KEY = first; Statement processed. cassandra> get Table1.Standard1['jsmith']['*'] Error: No data found cassandra> get Table1.Standard1['jsmith'][] Error: line 1:31 mismatched input ']' expecting set null cassandra> get Table1.Standard1['jsmith'] Error: CQL Execution Error cassandra> So smoke test using cassandra-cli works (except for the wildcard query get Table1.Standard1['jsmith'] i), but http://192.168.216.162:7002 isn't working anymore. I am wondering if the port has changed in the latest code. -Ivan --0016363109bba41a9f046d6e008e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Jonathan,

I have checked out the latest version of Cassandra and not= iced a few things not working.

Here's the sequence of steps I co= nducted:

1. Start up cassandra successfully (listener bind to 192.16= 8.216.162)

ichang@ubuntu:~/workspace/Cassandra2$ bin/cassandra
ichang@ubuntu:~/= workspace/Cassandra2$ Listening for transport dt_socket at address: 8888DEBUG - Loading settings from bin/../conf/storage-conf.xml
DEBUG - addi= ng Super1 as 0
DEBUG - adding Standard2 as 1
DEBUG - adding Standard1 as 2
DEBUG - a= dding StandardByTime1 as 3
DEBUG - adding LocationInfo as 4
DEBUG - a= dding HintsColumnFamily as 5
DEBUG - Starting to listen on 192.168.216.162:7001

2. http://192.168.216.162:7002<= /a> NOT working, older versions of code is working

3. Smoke test thr= ough cassandra-cli is successful, but the syntax get Table1.Standard1['= jsmith'] isn't working, the system.log indicated the error

DEBUG [pool-1-thread-1] 2009-06-28 15:46:25,621 CqlDriver.java (line 40= ) Compiling CQL query ...
DEBUG [pool-1-thread-1] 2009-06-28 15:46:25,62= 1 SemanticPhase.java (line 67) AST: (A_GET (A_COLUMN_ACCESS Table1 Standard= 1 'j
smith'))
DEBUG [pool-1-thread-1] 2009-06-28 15:46:25,621 CqlDriver.j= ava (line 44) Executing CQL query ...
DEBUG [pool-1-thread-1] 2009-06-28= 15:46:25,621 StorageProxy.java (line 593) weakreadlocal reading SliceFromR= eadCommand(table
=3D'Table1', key=3D'jsmith', columnFamily=3D'Standard1&= #39;, isAscending=3D'true', count=3D'2147483647')
ERROR = [pool-1-thread-1] 2009-06-28 15:46:25,621 ColumnRangeQueryRSD.java (line 10= 5) Exception was generated at : 06/28/2009 1
5:46:25 on thread pool-1-thread-1
1
java.lang.ArrayIndexOutOfBoundsEx= ception: 1
=A0=A0=A0 at org.apache.cassandra.db.Table.getSliceFrom(Table= .java:613)
=A0=A0=A0 at org.apache.cassandra.db.SliceFromReadCommand.get= Row(SliceFromReadCommand.java:55)
=A0=A0=A0 at org.apache.cassandra.service.StorageProxy.weakReadLocal(Storag= eProxy.java:600)
=A0=A0=A0 at org.apache.cassandra.service.StorageProxy.= readProtocol(StorageProxy.java:303)
=A0=A0=A0 at org.apache.cassandra.cq= l.common.ColumnRangeQueryRSD.getRows(ColumnRangeQueryRSD.java:101)
=A0=A0=A0 at org.apache.cassandra.cql.common.QueryPlan.execute(QueryPlan.ja= va:41)
=A0=A0=A0 at org.apache.cassandra.cql.driver.CqlDriver.executeQue= ry(CqlDriver.java:45)
=A0=A0=A0 at org.apache.cassandra.service.Cassandr= aServer.executeQuery(CassandraServer.java:513)
=A0=A0=A0 at org.apache.cassandra.service.Cassandra$Processor$executeQuery.= process(Cassandra.java:1321)
=A0=A0=A0 at org.apache.cassandra.service.C= assandra$Processor.process(Cassandra.java:837)
=A0=A0=A0 at org.apache.t= hrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:252= )
=A0=A0=A0 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadP= oolExecutor.java:886)
=A0=A0=A0 at java.util.concurrent.ThreadPoolExecut= or$Worker.run(ThreadPoolExecutor.java:908)
=A0=A0=A0 at java.lang.Thread= .run(Thread.java:619)


ichang@ubuntu:~/workspace/Cassandra2$ bin/cassandra-cli --host 192.= 168.216.162 --port 9160
Connected to 192.168.216.162/9160
Welcome to cassandra CLI.

Type '= ;help' or '?' for help. Type 'quit' or 'exit' t= o quit.
cassandra> set Table1.Standard1['jsmith']['first'] =3D &= #39;John'
Statement processed.
cassandra> get Table1.Standard1= ['jsmith']
Error: CQL Execution Error
cassandra> set Table= 1.Standard1['jsmith']['last'] =3D 'Smith'
Statement processed.
cassandra> set Table1.Standard1['jsmith'= ]['age'] =3D '42'=A0=A0=A0
Statement processed.
cass= andra> get Table1.Standard1['jsmith']
Error: CQL Execution Er= ror
cassandra> get Table1.Standard1['jsmith']['first']
CO= LUMN_TIMESTAMP =3D 1246217984436; COLUMN_VALUE =3D John; COLUMN_KEY =3D fir= st;
Statement processed.
cassandra> get Table1.Standard1['jsm= ith']['*']
Error: No data found
cassandra> get Table1.Standard1['jsmith'= ][]
Error: line 1:31 mismatched input ']' expecting set null
=
cassandra> get Table1.Standard1['jsmith']
Error: CQL Exec= ution Error
cassandra>

So smoke test using cassandra-cli works (except for t= he wildcard query get Table1.Standard1['jsmith'] i), but http://192.168.216.162:7002 isn't wor= king anymore.=A0 I am wondering if the port has changed in the latest code.=

-Ivan
--0016363109bba41a9f046d6e008e--