Freeradius 3.0.8 Can't create UNIX socket and Too many open files

[Aleš Rygl]

Hello, 

I am playing with 3.0.8 version processing just Accounting
Requests.The goal is get over more than 1.600 req/s. Up to 1000/req it
is fine. MySQL DB has max_connections = 2048. It can run for half of a
day and then it crashes accidentally: 

Tue Apr 28 12:52:06 2015 : Info:
rlm_sql (sql_instance_mobile_direct): 665 of 696 connections in use.
Need more spares
Tue Apr 28 12:52:06 2015 : Info: rlm_sql
(sql_instance_mobile_direct): Opening additional connection (1645), 192
of 304 pending slots used
Tue Apr 28 12:52:06 2015 : Error:
rlm_sql_mysql: Couldn't connect to MySQL server
radius at localhost:gprscalls
Tue Apr 28 12:52:06 2015 : Error:
rlm_sql_mysql: MySQL error: Can't create UNIX socket (24)
Tue Apr 28
12:52:06 2015 : Error: rlm_sql (sql_instance_mobile_direct): Opening
connection failed (1624)
Tue Apr 28 12:52:06 2015 : Error:
rlm_sql_mysql: Couldn't connect to MySQL server
radius at localhost:gprscalls
Tue Apr 28 12:52:06 2015 : Error:
rlm_sql_mysql: MySQL error: Can't create UNIX socket (24) 

and later on
in the log: 

Tue Apr 28 12:52:06 2015 : ERROR: (1086382) detail.mobile:
ERROR: Couldn't open file
/var/log/freeradius/radacct/detail.mobile/queue-11/detail-2015042812:
Failed calling dup(): Too many open files
Tue Apr 28 12:52:06 2015 :
ERROR: (1086380) detail.mobile: ERROR: Couldn't open file
/var/log/freeradius/radacct/detail.mobile/queue-9/detail-2015042812:
Failed calling dup(): Too many open files
Tue Apr 28 12:52:06 2015 :
ERROR: (1086383) detail.mobile: ERROR: Couldn't open file
/var/log/freeradius/radacct/detail.mobile/queue-9/detail-2015042812:
Failed to open file
/var/log/freeradius/radacct/detail.mobile/queue-9/detail-2015042812: Too
many open files

Config: 

listen {
 ipaddr = *
 port = 1813
 type =
acct
 limit {
 }
}
preacct {
 preprocess

acct_unique_mobile
}
accounting {
 redundant {

sql_instance_mobile_direct
 group {
 linelog
 detail.mobile
 }
 }
 if
(noop) {
 ok
 }
 }
} 

sql sql_instance_mobile_direct {
 query_timeout =
1
 driver = "rlm_sql_mysql"
 dialect = "mysql"
 server = "localhost"

port = 3306
 login = "radius"
 password = "xxxxxxxxxxx"
 radius_db =
"gprscalls"
 acct_table1 = "radacct"
 acct_table2 = "radacct"

postauth_table = "radpostauth"
 authcheck_table = "radcheck"

groupcheck_table = "radgroupcheck"
 authreply_table = "radreply"

groupreply_table = "radgroupreply"
 usergroup_table = "radusergroup"

delete_stale_sessions = yes
 logfile = ${logdir}/sqllog_dslres.sql
 pool
{
 start = 200
 min = 20
 max = ${thread[pool].max_servers}
 spare = 80

uses = 0
 lifetime = 0
 idle_timeout = 120
 }
 client_table = "nas"

$INCLUDE ${modconfdir}/${.:name}/main/${dialect}/queries_mobile.conf
}


It is a test system so far. I can provide all debugs if needed.


Thanks 

Ales