Hi,
I'm currently wracking my brains trying to deduce where an application hang can be
coming from.
I have ported the PostGres schema to be compatible with MS Sql Server and have had no
issues getting a working dev environment working. However when I try and use SQL Azure as
the backend db as opposed to SQL Server 2012 (running locally on my dev machine) Kamailio
will seem to hang after about 10 - 15 mins of flawless operation. I have recreated the
SQL Azure schema from the working schema running on my dev machine and copied all data in
a 1:1 manner so I can be certain it's not a data quality issue. I am using the same
FreeTDS/UnixODBC config that I am using for Asterisk realtime (which doesn't exhibit
this behaviour). The really strange thing is that I can see the queries being sent by
Kmailio in the freetds trace log, and the response from SQL Azure, however its as if the
db response handler is deadlocked/hung. The kamailio process continues to work fine, and
as long as its not required to commiunicate with the DB all appears well i.e. no error
messages in the log file.
This behaviour only happens when im using SQL Azure as opposed to SQL Server, so there
must be something causing the issue, that's unique to SQL azure as opposed to SQL
Server. As far as I can tell this is not something I can create a backtrace for as no
core dumps are produced, as far as I can tell there is no easy way debug what the lock is.
If anyone has any suggestions I would be very grateful to hear them.
One thing that occurs to me is that the db_unixodbc module doesn't have half as many
parameters as its equilent in Asterisk, and that connection pooling may be in use, this
could be a bit of a show stopper AFAIK you have to disable connection pooling with SQL
server, certainly any of the guides I have come across configuring Asterisk to work with
SQL server suggests that.
Tim Chubb
Developer
[VS-logo-email]
The Coach House, Heywood House, Park Lane, Heywood, Westbury, BA13 4NA
Direct: +44 (0)333 0110164
Email: tim.chubb@voicesimplified.com<mailto:tim.chubb@voicesimplified.com>
Web:
www.VoiceSimplified.com<http://www.voicesimplified.com/>
Voice Simplified Ltd (registered in England & Wales: 07171825) registered office:
Curzon House, 2nd Floor, 24 High Street, Banstead, Surrey. SM7 2LJ.
The information in this email is confidential and may be legally privileged. It is
intended solely for the addressee. Access to this email by anyone else
is unauthorised. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it,
is prohibited and may be unlawful. If you are not the intended recipient, please return
the message to the sender and delete it from your records.