Not sure about the port issue. You should be able to find all the defined ports in conf/storage-conf.xml
I filed https://issues.apache.org/jira/browse/CASSANDRA-260 a couple days ago about the Cli/Cql problem. In a recent check-in, the API for reading all columns changed, and the Cli/Cql wasn't updated to reflect this. I'm still only a casual reader of the Cassandra code, but I presented two possible solutions. Maybe others have thoughts? Michael On Sun, Jun 28, 2009 at 2:58 PM, Ivan Chang<ivan.ch...@medigy.com> wrote: > 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) > > ich...@ubuntu:~/workspace/Cassandra2$ bin/cassandra > ich...@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) > > > ich...@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 >