Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 80010 invoked from network); 12 Apr 2010 15:46:36 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 12 Apr 2010 15:46:36 -0000 Received: (qmail 37317 invoked by uid 500); 12 Apr 2010 15:46:35 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 37297 invoked by uid 500); 12 Apr 2010 15:46:35 -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 37289 invoked by uid 99); 12 Apr 2010 15:46:35 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Apr 2010 15:46:35 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates 74.125.82.172 as permitted sender) Received: from [74.125.82.172] (HELO mail-wy0-f172.google.com) (74.125.82.172) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Apr 2010 15:46:28 +0000 Received: by wyb35 with SMTP id 35so873961wyb.31 for ; Mon, 12 Apr 2010 08:46:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:received:message-id:subject:to:content-type :content-transfer-encoding; bh=9nicWY+hx0oWSdG2Mnfq72yFOpHhaOnFvCKYwsSkH+o=; b=Lgd9yc/m9GAIR96v0SDa9Q9I3Pj/5wC0bsdKoXxAdX7CvnCp7BzAnYJYYY9C0vQs2r 9+Blt3ygoWBwnTOWpgxiZbUv/G+SDQ85XUbzXxXAJILmUAaKUxgz21eeBFpgdGxnz7un yHP5cl4xt7XUj1yzRqZvQzxgq0dxXQghDd9Iw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; b=p2hcCx1yGb2zqQq4Z3MaTfQioVGqEsp1ngr7EpUM/rIMMn1X06YCFnIGWjz2Xzlkwj 5VH082vcTE0ybLXGORp8hvT/P6filDL/ga1Pft+RaVGlvYK7dv3j98JWd5PPcr9IbfEs uUP+cgLIyYVMFRQ9D2LxJQOGYPH2Gy6m4PB70= MIME-Version: 1.0 Received: by 10.216.17.147 with HTTP; Mon, 12 Apr 2010 08:45:48 -0700 (PDT) In-Reply-To: References: From: Jonathan Ellis Date: Mon, 12 Apr 2010 10:45:48 -0500 Received: by 10.216.90.208 with SMTP id e58mr2450501wef.57.1271087168311; Mon, 12 Apr 2010 08:46:08 -0700 (PDT) Message-ID: Subject: Re: frequent "unknown result" errors To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Pandra is probably targetting 0.6. If you're just starting, there's no reason for you not to use 0.6 over 0.5 = now. On Mon, Apr 12, 2010 at 10:42 AM, Lee Parker wrote: > I'm using the thrift client which is packaged with Pandra and my cassandr= a > version is 0.5.0 which is in the debian packages. =A0How can i tell which > version of Thrift i'm using? > Lee > > On Mon, Apr 12, 2010 at 10:30 AM, Jonathan Ellis wrot= e: >> >> Then you're probably using a client incompatible with the server >> version you're using. >> >> On Mon, Apr 12, 2010 at 10:24 AM, Lee Parker wrot= e: >> > If the connections are being made by individual PHP processes running >> > from >> > the command line, they shouldn't be using the same connection. =A0Shou= ld >> > my >> > code close the connections after each query and open a new one? >> > Here is the flow of what is happening when we get the error: >> > 1. Get a set of items from remote API >> > 2. Insert all of the items into the items CF. (usually anywhere from 2= - >> > 200 >> > items) >> > 3. Query the correct index for all entries within a particular time >> > frame >> > (which is determined by the timeframe of the results of step 1) >> > 4. Compare keys in index to keys of items inserted in step 2. >> > 5. Insert new index columns for items which aren't already in the inde= x. >> > I am getting the "unknown result" error during step 3. >> > Lee >> > >> > On Mon, Apr 12, 2010 at 10:05 AM, Jonathan Ellis >> > wrote: >> >> >> >> unknown result means thrift is badly confused. =A0You will get this w= hen >> >> using the same thrift connection from multiple threads, for instance. >> >> >> >> On Mon, Apr 12, 2010 at 10:02 AM, Lee Parker >> >> wrote: >> >> > I am a newbie with Cassandra. =A0We are currently migrating a large >> >> > amount >> >> > of >> >> > data out of MySQL into Cassandra. =A0I have two ColumnFamilies. =A0= One >> >> > contains >> >> > one row per item and each item has roughly 12 columns. =A0These are >> >> > items >> >> > from >> >> > REST APIs like the Twitter API. =A0Then I have a second ColumnFamil= y >> >> > with >> >> > very >> >> > large rows and TimeUUID column names which contain the key of the >> >> > items >> >> > in >> >> > the other ColumnFamily. =A0So one ColumnFamily has lots of rows wit= h a >> >> > low >> >> > number of columns per row, and the other has relatively few rows wi= th >> >> > a >> >> > large (~500k) columns per row. >> >> > I am getting rather frequent errors with "unknown result" from >> >> > get_slice >> >> > and >> >> > multiget_slice calls from the index ColumnFamily. =A0I am using Pan= dra >> >> > for >> >> > the >> >> > calls. =A0I can see that this is a generic exception thrown by the >> >> > Cassandra >> >> > Thrift package when it doesn't know what else to say. =A0Is there a= way >> >> > to >> >> > actually see what the result was in a more raw form from the Thrift >> >> > protocol? >> >> > One thought I had on why this is happening is that my results might >> >> > be >> >> > larger than the configuration settings. =A0Does anyone have any goo= d >> >> > ideas >> >> > on >> >> > how to calculate what the ideal values of=A0SlicedBufferSizeInKB >> >> > and=A0ColumnIndexSizeInKB should be? =A0If these are too low, would= i get >> >> > a >> >> > more >> >> > descriptive error? >> >> > Lee Parker >> > >> > > >