I'm using a unique client instance (using Hector) and a unique connection to cassandra. For each insertion I'm using a new mutator and then I release it. I have 473 sstable "Data.db", the average size of each is 30Mo.
2010/12/16 Ryan King <r...@twitter.com> > Are you creating a new connection for each row you insert (and if so > are you closing it)? > > -ryan > > On Wed, Dec 15, 2010 at 8:13 AM, Amin Sakka, Novapost > <amin.sa...@novapost.fr> wrote: > > Hello, > > I'm using cassandra 0.7.0 rc1, a single node configuration, replication > > factor 1, random partitioner, 2 GO heap size. > > I ran my hector client to insert 5.000.000 rows but after a couple of > hours, > > the following Exception occurs : > > > > WARN [main] 2010-12-15 16:38:53,335 CustomTThreadPoolServer.java (line > 104) > > Transport error occurred during acceptance of message. > > org.apache.thrift.transport.TTransportException: > java.net.SocketException: > > Too many open files > > at > > > org.apache.thrift.transport.TServerSocket.acceptImpl(TServerSocket.java:124) > > at > > > org.apache.cassandra.thrift.TCustomServerSocket.acceptImpl(TCustomServerSocket.java:67) > > at > > > org.apache.cassandra.thrift.TCustomServerSocket.acceptImpl(TCustomServerSocket.java:38) > > at > > > org.apache.thrift.transport.TServerTransport.accept(TServerTransport.java:31) > > at > > > org.apache.cassandra.thrift.CustomTThreadPoolServer.serve(CustomTThreadPoolServer.java:98) > > at > > > org.apache.cassandra.thrift.CassandraDaemon.start(CassandraDaemon.java:120) > > at > > > org.apache.cassandra.service.AbstractCassandraDaemon.activate(AbstractCassandraDaemon.java:229) > > at > > > org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:134) > > Caused by: java.net.SocketException: Too many open files > > at java.net.PlainSocketImpl.socketAccept(Native Method) > > at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:384) > > at java.net.ServerSocket.implAccept(ServerSocket.java:453) > > at java.net.ServerSocket.accept(ServerSocket.java:421) > > at > > > org.apache.thrift.transport.TServerSocket.acceptImpl(TServerSocket.java:119) > > > > When I try to restart Cassandra, I have the following exception : > > > > ERROR 16:42:26,573 Exception encountered during startup. > > java.lang.ArithmeticException: / by zero > > at > > > org.apache.cassandra.io.sstable.SSTable.estimateRowsFromIndex(SSTable.java:233) > > at > > > org.apache.cassandra.io.sstable.SSTableReader.load(SSTableReader.java:284) > > at > > > org.apache.cassandra.io.sstable.SSTableReader.open(SSTableReader.java:200) > > at > > > org.apache.cassandra.db.ColumnFamilyStore.<init>(ColumnFamilyStore.java:225) > > at > > > org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:449) > > at > > > org.apache.cassandra.db.ColumnFamilyStore.addIndex(ColumnFamilyStore.java:306) > > at > > > org.apache.cassandra.db.ColumnFamilyStore.<init>(ColumnFamilyStore.java:246) > > at > > > org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:449) > > at > > > org.apache.cassandra.db.ColumnFamilyStore.createColumnFamilyStore(ColumnFamilyStore.java:437) > > at org.apache.cassandra.db.Table.initCf(Table.java:341) > > at org.apache.cassandra.db.Table.<init>(Table.java:283) > > at org.apache.cassandra.db.Table.open(Table.java:114) > > at > > > org.apache.cassandra.service.AbstractCassandraDaemon.setup(AbstractCassandraDaemon.java:138) > > at > > > org.apache.cassandra.thrift.CassandraDaemon.setup(CassandraDaemon.java:55) > > at > > > org.apache.cassandra.service.AbstractCassandraDaemon.activate(AbstractCassandraDaemon.java:216) > > at > > > org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:134) > > > > I am looking for advice on how to debug this. > > > > Thanks, > > -- > > > > Amin > > > > > > > > > > > -- *Amin *
