I increased the amount of the allowed file descriptors to "unlimted". Now, I get exactly the same exception after 3.500000 rows :
*CustomTThreadPoolServer.java (line 104) Transport error occurred during acceptance of message.* *org.apache.thrift.transport.TTransportException: java.net.SocketException: Too many open files* * * What worries me is this / by zero exception when I try to restart cassandra ! At least, I want to backup the 3.500000 rows to continue then my insertion, is there a way to do this? * Exception encountered during startup. java.lang.ArithmeticException: / by zero at org.apache.cassandra.io.sstable.SSTable.estimateRowsFromIndex(SSTable.java:233) * Thanks. * * 2010/12/15 Jake Luciani <jak...@gmail.com> > > http://www.riptano.com/docs/0.6/troubleshooting/index#java-reports-an-error-saying-there-are-too-many-open-files > > > > On Wed, Dec 15, 2010 at 11: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 SAKKA Research and Development Engineer 32 rue de Paradis, 75010 Paris *Tel:* +33 (0)6 34 14 19 25 *Mail:* amin.sa...@novapost.fr *Web:* www.novapost.fr / www.novapost-rh.fr