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.l...@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! > > > >
