RE: [Serusers] SER hung - Log Information?

Interesting, we also use an external process to connect to a DB and retrieve URI replacement. We were thinking that it's running "too slow" and thus hanging SER, even though the logs make it appear as if the process(es) was hanging at random points. We're in the process of eliminating this script and switching over to ENUM or similar. When we restarted our MySQL server it improved the query time (it was running for 180 days heheh) and seems to have made SER hang less. How long does your external script take to run on average? If it's more than a second then that seems to be unnacceptable for SER.. P.S. The crappy thing is this happens over a period of time, when I load tested the server it ran flawlessly. Pushed 30000 calls through it in less than an hour with no problems. The MySQL server in question is in the same switch segment/subnet as well. Matt -----Original Message----- From: Ricardo Martinez [mailto:rmartinez@redvoiss.net] Sent: Thursday, April 14, 2005 4:32 PM To: Matt Schulte; serusers(a)lists.iptel.org Subject: RE: [Serusers] SER hung - Log Information? Hello Matt. Thanks for your answer, i checked the post "exec_dset fork limit?" (http://lists.iptel.org/pipermail/serusers/2004-December/014150.html) and i think i have the same problem. I'm using the exec_dset command to manipulate the RURI, we need to do this in order to add prefixes according to certain user profiles. route { if (method=="INVITE" || method=="CANCEL") { exec_dset("/usr/local/etc/ser/translate"); }; As you can see i'm using it for every INVITE and CANCEL, the "translate" file is a C program that connects to a DB and returns the desired RURI. Could this be the cause of SER freeze?. Can we have an opinion from the developers? Is there a way to do the same thing with maybe another module?. For the record i'm using : OS : Linux Red Hat 9.0 SER : 0.8.14 Mediaproxy : 1.2.1 I would really appreciate any help here. Thanks!! Best Regards, Ricardo.- A