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