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 32523DD6C for ; Fri, 10 Aug 2012 07:05:12 +0000 (UTC) Received: (qmail 84458 invoked by uid 500); 10 Aug 2012 07:05:10 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 83820 invoked by uid 500); 10 Aug 2012 07:05:03 -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 83772 invoked by uid 99); 10 Aug 2012 07:05:01 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Aug 2012 07:05:01 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jehovah.love@gmail.com designates 209.85.212.44 as permitted sender) Received: from [209.85.212.44] (HELO mail-vb0-f44.google.com) (209.85.212.44) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Aug 2012 07:04:54 +0000 Received: by vbbez10 with SMTP id ez10so1310192vbb.31 for ; Fri, 10 Aug 2012 00:04:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=VyxA1zQbaqrBMzYKIGC/RjdwrtLpdqo/D63wVUjXqtc=; b=FwWo6lf1KRGNe5siSen7anyGdN5KTRyZvAoKLgwlrCaSIBRGP3+NukBel4yE47qmLT IqhiAzeHYWTkvsnMOjGDvyJ6ODfaUV9blHa7JVbbM62t3k5bGkMJ3SchOokbRc14dUz4 bcQASRfgz1hELW9lrFhXCBDpodvqHO2cuUqbBxgRNtv7e1f0ouq/DIpyhlw674RsSWX2 n8l/8u9ji/CkNDUIQBFmQMu9E1PziW+4dijxj/95Q9kG1fJeSSkCnTfV7zvIN13TSWtI kONmXNtIQzC+0R1lVmMYll6fJfiaRbSiM/tDtyZ4VKjeI9k1Ge5xsDDzE+wFardc/0sX heLQ== Received: by 10.52.35.15 with SMTP id d15mr1462915vdj.128.1344582273548; Fri, 10 Aug 2012 00:04:33 -0700 (PDT) MIME-Version: 1.0 Received: by 10.58.70.7 with HTTP; Fri, 10 Aug 2012 00:04:03 -0700 (PDT) In-Reply-To: References: From: Jin Lei Date: Fri, 10 Aug 2012 15:04:03 +0800 Message-ID: Subject: Re: problem of inserting columns of a great amount To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=20cf307ac79bc941d504c6e3f4f5 --20cf307ac79bc941d504c6e3f4f5 Content-Type: text/plain; charset=ISO-8859-1 Sorry, something is wrong with my previous problem description. The fact is that the cassandra deny my requests when I try to insert 50k rows (rather than 50k columns) into a column family at one time. Each row with 1 column. 2012/8/10 Jin Lei > Hello everyone, > I'm a novice to cassandra and meet a problem recently. > I want to insert over 50k columns into cassandra at one time, total size > of which doesn't exceed 16MB, but the database return an exception as > follows. > > [E 120809 15:37:31 service:1251] error in write to database > Traceback (most recent call last): > File "/home/stoneiii/mycode/src/user/service.py", line 1248, in > flush_mutator > self.mutator.send() > > File "/home/stoneiii/mycode/pylib/pycassa/batch.py", line 127, in > send > > conn.batch_mutate(mutations, write_consistency_level) > File "/home/stoneiii/gaia2/pylib/pycassa/pool.py", line 145, in new_f > return new_f(self, *args, **kwargs) > File "/home/stoneiii/mycode/pylib/pycassa/pool.py", line 145, in > new_f > return new_f(self, *args, **kwargs) > File "/home/stoneiii/mycode/pylib/pycassa/pool.py", line 145, in > new_f > return new_f(self, *args, **kwargs) > File "/home/stoneiii/mycode/pylib/pycassa/pool.py", line 145, in > new_f > return new_f(self, *args, **kwargs) > File "/home/stoneiii/mycode/pylib/pycassa/pool.py", line 145, in > new_f > return new_f(self, *args, **kwargs) > File "/home/stoneiii/mycode/pylib/pycassa/pool.py", line 140, in > new_f > (self._retry_count, exc.__class__.__name__, exc)) > MaximumRetryException: Retried 6 times. Last failure was error: [Errno > 104] Connection reset by peer > > Since cassandra supports 2 billion of columns in one table, why can't I > insert 50k columns in this way? Or what settings should I adjust to break > this limit? > Thanks for any hint in advance! > > > > --20cf307ac79bc941d504c6e3f4f5 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Sorry, something is wrong with my previous problem de= scription. The fact is that the cassandra deny my requests when I try to in= sert 50k rows (rather than 50k columns) into a column family at one time. E= ach row with 1 column.

2012/8/10 Jin Lei <jehovah.= love@gmail.com>
Hell= o everyone,
I'm= a novice to cassandra and meet a problem recently.=A0
I want to insert over 50k columns into cassandra at one= time, total size of which doesn't exceed 16MB, but the database return= an exception as follows.

[E 120809 15:37:31 service:1251] e= rror in write to database
=A0=A0=A0 Traceback (most r= ecent call last):
=A0=A0=A0=A0=A0 File = "/home/stoneiii/mycode/src/user/service.py", line 1248, in flush_= mutator
=A0=A0=A0=A0=A0=A0=A0 self.mutator.send()<= /span>

=
=A0=A0=A0=A0=A0 File &= quot;/home/stoneiii/mycode/pylib/pycassa/batch.py", line 127, in send<= /span>

=A0=A0=A0=A0=A0=A0=A0 conn.= batch_mutate(mutations, write_consistency_level)
= =A0=A0=A0=A0=A0 File "/home/stoneiii/gaia2/pylib/pycassa/pool.py"= , line 145, in new_f
=A0=A0=A0=A0=A0=A0=A0 retur= n new_f(self, *args, **kwargs)
=A0=A0=A0=A0= =A0 File "/home/stoneiii/mycode/pylib/pycassa/pool.py", line 145,= in new_f
=A0=A0=A0=A0=A0=A0=A0 retur= n new_f(self, *args, **kwargs)
=A0=A0=A0=A0=A0 Fil= e "/home/stoneiii/mycode/pylib/pycassa/pool.py", line 145, in new= _f
=A0=A0=A0=A0=A0=A0=A0 retur= n new_f(self, *args, **kwargs)
=A0=A0=A0=A0=A0 Fil= e "/home/stoneiii/mycode/pylib/pycassa/pool.py", line 145, in new= _f
=A0=A0=A0=A0=A0=A0=A0 retur= n new_f(self, *args, **kwargs)
=A0=A0=A0=A0=A0 Fil= e "/home/stoneiii/mycode/pylib/pycassa/pool.py", line 145, in new= _f
=A0=A0=A0=A0=A0=A0=A0 retur= n new_f(self, *args, **kwargs)
=A0=A0=A0=A0=A0 Fil= e "/home/stoneiii/mycode/pylib/pycassa/pool.py", line 140, in new= _f
=A0=A0=A0=A0=A0=A0=A0 (self= ._retry_count, exc.__class__.__name__, exc))
=A0=A0=A0 MaximumRetryException: Retried 6 times. Last f= ailure was error: [Errno 104] Connection reset by peer

Since cassandr= a supports 2 billion of columns in one table, why can't I insert 50k co= lumns in this way? Or what settings should I adjust to break this limit?
Thanks for any hint in advance!
=A0 =A0 =A0 =A0 =A0 =A0 =A0



--20cf307ac79bc941d504c6e3f4f5--