Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 59253 invoked from network); 21 Dec 2010 23:02:04 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 21 Dec 2010 23:02:04 -0000 Received: (qmail 88208 invoked by uid 500); 21 Dec 2010 23:02:01 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 88160 invoked by uid 500); 21 Dec 2010 23:02:00 -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 88152 invoked by uid 99); 21 Dec 2010 23:02:00 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Dec 2010 23:02:00 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of dooley@apple.com designates 17.254.13.23 as permitted sender) Received: from [17.254.13.23] (HELO mail-out4.apple.com) (17.254.13.23) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Dec 2010 23:01:50 +0000 Received: from relay11.apple.com (relay11.apple.com [17.128.113.48]) by mail-out4.apple.com (Postfix) with ESMTP id C0C35C5FECDB for ; Tue, 21 Dec 2010 15:01:28 -0800 (PST) X-AuditID: 11807130-b7cb4ae000001037-b4-4d1131c8e573 Received: from belize1.apple.com (belize1.apple.com [17.224.36.17]) (using TLS with cipher AES128-SHA (AES128-SHA/128 bits)) (Client did not present a certificate) by relay11.apple.com (Apple SCV relay) with SMTP id D7.23.04151.8C1311D4; Tue, 21 Dec 2010 15:01:28 -0800 (PST) From: mike dooley Content-Type: multipart/alternative; boundary=Apple-Mail-44--1014808066 Subject: cli 'list' command not returning all data, get_range_slices bug? Date: Tue, 21 Dec 2010 15:01:28 -0800 Message-Id: To: user@cassandra.apache.org Mime-Version: 1.0 (Apple Message framework v1082) X-Mailer: Apple Mail (2.1082) X-Brightmail-Tracker: AAAAAA== X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-44--1014808066 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii hi, i am using version 0.7-rc2 and pelops-c642967 from java. when i try to export all the data in a column family i don't get all of the data = that was inserted. i suspect that this points to an underlying problem with=20= the get_range_slices method. i can reproduce the problem just using the command line interface as follows: 1) create a 2 node cluster using the default cassandra.yml with these=20 changes:=20 * set the initial token for the 1st node: initial_token: 0 * set the initial token for the 2nd node: initial_token: 85070591730234615865843651857942052864 *comment out: #listen_address: localhost #rpc_address: localhost *set the seeds (change ip's) seeds: - 17.224.109.80 - 17.224.109.81 2) start both nodes 3) put these commands in a file called schema.txt=20 create keyspace Test with replication_factor =3D 1 and = placement_strategy =3D 'org.apache.cassandra.locator.SimpleStrategy'; use Test; create column family Configs with column_type =3D 'Standard' and = comparator =3D 'UTF8Type'; and load them with the command line tool like this: ./bin/cassandra-cli --host 17.224.109.80 < schema.txt 4) put these commands in a file called config.txt use Test; set Configs['row-a']['key-a'] =3D '1'; set Configs['row-a']['key-b'] =3D '2'; =20 set Configs['row-a']['key-c'] =3D '3'; set Configs['row-b']['key-a'] =3D '4'; set Configs['row-b']['key-b'] =3D '5'; set Configs['row-b']['key-c'] =3D '6'; set Configs['row-c']['key-a'] =3D '7'; set Configs['row-c']['key-b'] =3D '8'; set Configs['row-c']['key-c'] =3D '9'; and load them with the command line tool like this: ./bin/cassandra-cli --host 17.224.109.80 < config.txt 5) now start the command line tool and try to list the Configs column = family: ./bin/cassandra-cli --host 17.224.109.80 Connected to: "Test Cluster" on 17.224.109.80/9160 Welcome to cassandra CLI. Type 'help;' or '?' for help. Type 'quit;' or 'exit;' to quit. [default@unknown] use Test; Authenticated to keyspace: Test [default@Test] list Configs; Using default limit of 100 0 Row Returned. [default@Test] get Configs['row-a']; =3D> (column=3Dkey-a, value=3D31, timestamp=3D1292970451049000) =3D> (column=3Dkey-b, value=3D32, timestamp=3D1292970451099000) =3D> (column=3Dkey-c, value=3D33, timestamp=3D1292970451104000) Returned 3 results. [default@Test] get Configs['row-b']; =3D> (column=3Dkey-a, value=3D34, timestamp=3D1292970451108000) =3D> (column=3Dkey-b, value=3D35, timestamp=3D1292970451111000) =3D> (column=3Dkey-c, value=3D36, timestamp=3D1292970451116000) Returned 3 results. [default@Test] get Configs['row-c']; =3D> (column=3Dkey-a, value=3D37, timestamp=3D1292970451120000) =3D> (column=3Dkey-b, value=3D38, timestamp=3D1292970451123000) =3D> (column=3Dkey-c, value=3D39, timestamp=3D1292970451128000) Returned 3 results. note: that the 'list Configs' command doesn't return any results, but when you 'get' a particular row the data is there. note: when only using a single node everything works as=20 expected note: that if you try to combine schema.txt and config.txt and load all at once the first data point fails to load and the following error shows up in the 2nd node's logs: INFO [FlushWriter:1] 2010-12-21 12:30:25,701 Memtable.java (line 155) = Writing Memtable-Schema@390276053(2184 bytes, 3 operations) ERROR [MutationStage:1] 2010-12-21 12:30:25,718 = RowMutationVerbHandler.java (line 83) Error in row mutation org.apache.cassandra.db.UnserializableColumnFamilyException: Couldn't = find cfId=3D1000 at = org.apache.cassandra.db.ColumnFamilySerializer.deserialize(ColumnFamilySer= ializer.java:117) at = org.apache.cassandra.db.RowMutationSerializer.defreezeTheMaps(RowMutation.= java:383) at = org.apache.cassandra.db.RowMutationSerializer.deserialize(RowMutation.java= :393) at = org.apache.cassandra.db.RowMutationSerializer.deserialize(RowMutation.java= :351) at = org.apache.cassandra.db.RowMutationVerbHandler.doVerb(RowMutationVerbHandl= er.java:52) at = org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:= 63) at = java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:= 1110) at = java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java= :603) at java.lang.Thread.run(Thread.java:636) INFO [FlushWriter:1] 2010-12-21 12:30:25,925 Memtable.java (line 162) = Completed flushing /var/lib/cassandra/data/system/Schema-e-1-Data.db = (2472 byte has anyone else seen anything similar or is there something that i'm = missing? thanks, -mike --Apple-Mail-44--1014808066 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
Welcome to cassandra = CLI.

Type 'help;' or '?' for help. Type 'quit;' = or 'exit;' to quit.
[default@unknown] use = Test;
Authenticated to keyspace: = Test
[default@Test] list Configs;
Using = default limit of 100

0 Row = Returned.

[default@Test] get = Configs['row-a'];
=3D> (column=3Dkey-a, value=3D31, = timestamp=3D1292970451049000)
=3D> (column=3Dkey-b, = value=3D32, timestamp=3D1292970451099000)
=3D> = (column=3Dkey-c, value=3D33, = timestamp=3D1292970451104000)
Returned 3 = results.
[default@Test] get = Configs['row-b'];
=3D> (column=3Dkey-a, value=3D34, = timestamp=3D1292970451108000)
=3D> (column=3Dkey-b, = value=3D35, timestamp=3D1292970451111000)
=3D> = (column=3Dkey-c, value=3D36, = timestamp=3D1292970451116000)
Returned 3 = results.
[default@Test] get = Configs['row-c'];
=3D> (column=3Dkey-a, value=3D37, = timestamp=3D1292970451120000)
=3D> (column=3Dkey-b, = value=3D38, timestamp=3D1292970451123000)
=3D> = (column=3Dkey-c, value=3D39, = timestamp=3D1292970451128000)
Returned 3 = results.

note: that the 'list = Configs' command doesn't return any results,
but when you = 'get' a particular row the data is = there.

note: when only using a single = node everything works = as 
expected

note: that = if you try to combine schema.txt and config.txt and
load all = at once the first data point fails to load and the = following
error shows up in the 2nd node's = logs:

 INFO [FlushWriter:1] = 2010-12-21 12:30:25,701 Memtable.java (line 155) Writing = Memtable-Schema@390276053(2184 bytes, 3 operations)
ERROR = [MutationStage:1] 2010-12-21 12:30:25,718 RowMutationVerbHandler.java = (line 83) Error in row = mutation
org.apache.cassandra.db.UnserializableColumnFamilyExcep= tion: Couldn't find cfId=3D1000
       =  at = org.apache.cassandra.db.ColumnFamilySerializer.deserialize(ColumnFamilySer= ializer.java:117)
        at = org.apache.cassandra.db.RowMutationSerializer.defreezeTheMaps(RowMutation.= java:383)
        at = org.apache.cassandra.db.RowMutationSerializer.deserialize(RowMutation.java= :393)
        at = org.apache.cassandra.db.RowMutationSerializer.deserialize(RowMutation.java= :351)
        at = org.apache.cassandra.db.RowMutationVerbHandler.doVerb(RowMutationVerbHandl= er.java:52)
        at = org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:= 63)
        at = java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:= 1110)
        at = java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java= :603)
        at = java.lang.Thread.run(Thread.java:636)
 INFO = [FlushWriter:1] 2010-12-21 12:30:25,925 Memtable.java (line 162) = Completed flushing /var/lib/cassandra/data/system/Schema-e-1-Data.db = (2472 byte

has anyone else = seen anything similar or is there something that i'm = missing?

thanks,
-mike

= --Apple-Mail-44--1014808066--