-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello all,
Just a quick question to see if anyone else has had this problem. I can't find
anything about it on
the web at all.
I have been trying to use func_odbc to do realtime routing from a database.
Everything worked great
on the test machine, but when I take it to production I get stuck channels.
When I look at the channels, they always seem to get stuck on a line that has
an ODBC function in
it. Below is an example of the most common line it gets stuck on:
exten => s,n,Set(DID_CONTEXT=${DB_DID(context)})
Here's the bit in func_odbc.conf that runs the query. It should be pretty
straight forward.
[DID]
prefix=DB
dsn=asterisk
read=SELECT ${ARG1} from DID where DID='${SQL_ESC(${DBDID})}'
The database server is local. I haven't had any problems with connectivity
that I am aware of. I
used to use app_mysql and did the whole connection and query on the dialplan.
I didn't have any
problems, but went to ODBC to eliminate the overhead of connecting and
disconnecting 3 times each call.
The only way to clear the channel is to restart. I can't soft hangup the
channels that stick.
I'm passing a few thousand calls per day, and I usually get 1 or two stuck
channels. I can't find a
pattern to it.
Asterisk 1.4.19.2
FreeBSD 6.2
MySQL 5.0
Any suggestions? Is there a way to debug why this application is getting stuck?
Let me know if there is any other information I should provide.
Thanks,
- -Tim
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJre/QI1xz6nMGzusRArctAKCZ9Lz6dOtkTlDex4XGOFfElQKBngCdE6er
qbuVdzzmExad6eYlu7ZBLQs=
=oNcA
-----END PGP SIGNATURE-----
_______________________________________________
--Bandwidth and Colocation Provided by http://www.api-digital.com--
Asterisk-BSD mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-bsd
