cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jin Lei <jehovah.l...@gmail.com>
Subject Re: problem of inserting columns of a great amount
Date Fri, 10 Aug 2012 07:04:03 GMT
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 <jehovah.love@gmail.com>

> 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!
>
>
>
>

Mime
View raw message