Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

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


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users
View previous topic :: View next topic  
Author Message
anthony.minessale at g...
Guest
PostPosted: Wed Jun 10, 2009 4:17 pm    Post subject: [Freeswitch-users] Database and "Too many open files&qu Reply with quote
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@ewetel.de (helmut.kuper@ewetel.de)> wrote:
Quote:
-----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@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@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400
Back to top
helmut.kuper at ewetel.de
Guest
PostPosted: Fri Jun 12, 2009 7:48 am    Post subject: [Freeswitch-users] Database and "Too many open files&qu Reply with quote
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Anthony,

yes, that's true. Works well now.

Thanks a lot!

regards
Helmut

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

iD8DBQFKMk1W4tZeNddg3dwRAhzrAJ45OpGkPkpLEPRw17HUpR3CTaxVVwCcD4/0
TJpI0jZez6uOdETu3OtDbc8=
=yWhz
-----END PGP SIGNATURE-----

_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services