[Freeswitch-users] Database and "Too many open files" Problem

[Helmut Kuper]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

today I updated to latest trunk. Everything compiled well. FS starts up
without errors. Calls are executed successfully.

But after a few minutes with very few call activity I get this lines on
console:


2009-06-10 18:21:16.52527 [ERR] switch_core_sqldb.c:95 SQL ERR [unable
to open database file] (update tasks set task_sql_manager='' where
task_id=1;
)
2009-06-10 18:21:16.152501 [ERR] switch_core_sqldb.c:95 SQL ERR [unable
to open database file] (update tasks set task_sql_manager='' where
task_id=1;
)
2009-06-10 18:21:16.252481 [ERR] switch_core_sqldb.c:95 SQL ERR [unable
to open database file] (update tasks set task_sql_manager='' where
task_id=1;
)

...

2009-06-10 18:22:37.121405 [CRIT] switch_core_sqldb.c:209 SQL thread
unable to commit transaction, records lost!

I modified switch_core_sqldb.c to output the actual sql statement as
well to get an idea which database is affected. It's the core-db.



Mixed with that lines above I got lines like this:

2009-06-10 18:21:32.656605 [ERR] mod_sndfile.c:194 Error Opening File
[/opt/app/voip/ippbx/sounds/music/32000/partita-no-3-in-e-major-bwv-1006-1-preludio.wav]
[System error : Too many open files in system.]


This may points to the ulimit thing, cause I run FS as non root (on
centos 5.3).

ulimit -a shows:
[ippbx at ippbx-test-node0 ~]$ ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) unlimited
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 999999
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) unlimited
real-time priority              (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) unlimited
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited


/etc/security/limits.conf contains:
ippbx            -       nofile          999999
ippbx            -       core            unlimited
ippbx            -       data            unlimited
ippbx            -       fsize           unlimited
ippbx            -       sigpending      unlimited
ippbx            -       msgqueue        unlimited
ippbx            -       nproc           unlimited
ippbx            -       locks           unlimited


So has anyone an idea what's wrong?

regards
Helmut
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)

iD8DBQFKL+454tZeNddg3dwRAqcCAJsFSEWuI2X1fvOF2rmIFoSmRdBZzQCggD8B
MQiS7RZkOoL9lhV8LV+pL7s=
=v7QY
-----END PGP SIGNATURE-----