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

[Anthony Minessale]

This is a bug in the latest wanpipe.

you can wait for the next release of wanpipe/openzap or you can downgrade to
wanpipe 4.1 and rebuild FS


On Wed, Jun 10, 2009 at 12:32 PM, Helmut Kuper <helmut.kuper at ewetel.de>wrote:

> -----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-----
>
> _______________________________________________
> Freeswitch-users mailing list
> Freeswitch-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>



-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/

AIM: anthm
MSN:anthony_minessale at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
iax:guest at conference.freeswitch.org/888
googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
pstn:213-799-1400
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20090610/a8983233/attachment-0001.html