Subject Re: [firebird-support] Re: Time out network after 436 connections on data base employee
Author Philippe Makowski
2010/10/19 Danguelle Mickael <mickael.danguelle@...>
> my sysctl.conf for tcp_max_syn_backlog and somaxconn
> net.core.somaxconn = 262144
> net.ipv4.tcp_max_syn_backlog = 262144
yes and ?
without a real test case explaining exactly what your are doing, and
the availables ressources of the box, what don't you want us to to
tell you ?

giving small pieces like that or only
> I have a time out network, after 436 connections on data base employee in the directory firebird
is not enough information to help you

but I insist, to deal with more than some hundred of connections, what
ever the os and the Firebird version, it is better to have a
connection pooling system IMHO

but may be other Firebird users here can share their experience with you

for your information on my MacOsX box the following simple bad written
code have no problem to run and create 1000 connections :

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import kinterbasdb
from kinterbasdb import services
svcCon = services.connect(host='',user='sysdba',

l = []
for i in range(1000):
con = kinterbasdb.connect(dsn='',
user='sysdba', password='masterkey')
cur = con.cursor()
cur.execute("select FIRST 1 * from COUNTRY")
print 'Nb connexions :', svcCon.getConnectionCount()

Nb connexions : 1000

if I run it on my small Atom laptop (Fedora 13 without changes) it
fails at 508 connections, because of too many open files
not really a surprise !