[OpenSIPS-Users] Errors in OpenSIPS

Alex Ionescu alex at opensips.org
Thu Nov 15 12:32:13 CET 2012


Hi,

Most probably not. OpenSIPS usually does updates/inserts on this table. 
Only if OpenSIPS is configured to restore it's dialogs from DB in case 
of restart then you might want to make a test just to be sure it won't 
complain.

Regards,
Alex Ionescu
On 11/15/2012 01:20 PM, Jorge Ortea wrote:
> Hello,
>
> can someone said me if really modify dialog table and allow 
> callee_contract field to be NULL on DB could break anything??
>
> Thanks.
> Regards.
>
> ------------------------------------------------------------------------
> Date: Tue, 13 Nov 2012 14:48:51 +0100
> From: shaheryarkh at googlemail.com
> To: users at lists.opensips.org
> Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS
>
> Its db schema problem. The field dialog.callee_contact is set as "NOT 
> NULL", while you are getting NULL contact from upstream (most likely 
> in BYE from callee side, as some old PSTN gateways running at many 
> termination providers do not add "Contact" header in BYE request). 
> Please check SIP trace and confirm or attach that here for our review.
>
> For a workaround you can modify dialog table and allow callee_contract 
> field to be NULL. However i am not sure if this won't break anything else.
>
> Thank you.
>
>
> On Mon, Nov 12, 2012 at 1:52 PM, Jorge Ortea <darham at hotmail.com 
> <mailto:darham at hotmail.com>> wrote:
>
>     Hello,
>
>     I keep getting these errors.
>
>     My opensips version is 1.6.4-2-tls and my mysql version is 5.1.34
>
>     Would it be better to change the version of opensips?
>
>     What can mean  "Column 'callee_contact' cannot be null" ??
>
>     Thanks.
>     Regards.
>
>     ------------------------------------------------------------------------
>     From: darham at hotmail.com <mailto:darham at hotmail.com>
>     To: users at lists.opensips.org <mailto:users at lists.opensips.org>
>     Date: Fri, 9 Nov 2012 08:30:03 +0100
>
>     Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS
>
>     Hello Vlad,
>
>     You are right, I had searched for ERROR, but before each Error
>     message I got this:
>
>     Nov  5 10:24:19 hgt-tero45
>     /usr/local/opensips/sbin/opensips[12562]:
>     CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error
>     (1048): Column 'callee_contact' cannot be null
>     Nov  5 10:24:19 hgt-tero45
>     /usr/local/opensips/sbin/opensips[12562]:
>     ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db
>
>     Why could this be happening?
>
>     Thanks.
>     Regards.
>
>
>
>
>     ------------------------------------------------------------------------
>     Date: Thu, 8 Nov 2012 19:21:45 +0200
>     From: vladpaiu at opensips.org <mailto:vladpaiu at opensips.org>
>     To: users at lists.opensips.org <mailto:users at lists.opensips.org>
>     Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS
>
>     Hello Jorge,
>
>     Do you see any other errors from the DB level in the OpenSIPS logs
>     ? What DB backend are you using ?
>     It seems that for some reason, the dialog DB inserts are failing,
>     but more ERROR messages should appear in such a case from the
>     db_mysql module..
>
>     Regards,
>
>     Vlad Paiu
>     OpenSIPS Developer
>     http://www.opensips-solutions.com  
>
>
>     On 11/08/2012 07:10 PM, Ali Pey wrote:
>
>         I think it's telling you it can't add another dialog to db. I
>         am almost certain that's what's happening.
>
>         Regards,
>         Ali Pey
>
>
>
>         On Thu, Nov 8, 2012 at 4:22 AM, Jorge Ortea
>         <darham at hotmail.com <mailto:darham at hotmail.com>> wrote:
>
>             Hi all,
>
>             I am getting the following errors:
>
>
>             Nov  7 11:47:19 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12582]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 11:47:19 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12548]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 11:47:20 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12558]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 11:57:32 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12554]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 11:57:32 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12578]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 11:59:07 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12556]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 11:59:07 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12574]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:23:23 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12580]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:23:24 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12544]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:23:25 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12572]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:24:47 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12558]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:24:47 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12562]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:26:45 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12550]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:26:45 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12556]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:26:46 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12570]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:28:20 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12558]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:28:20 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12564]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:28:21 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12568]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:30:23 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12550]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:30:23 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12572]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 12:30:25 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12576]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 13:12:13 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12548]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 13:12:13 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12546]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 13:12:13 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12576]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 13:23:34 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12582]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 13:23:34 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12566]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 13:23:34 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12580]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 13:33:09 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12572]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 13:33:09 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12578]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 13:33:09 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12574]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 14:10:19 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12556]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 14:10:19 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12564]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 14:10:21 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12558]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 17:58:43 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12572]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 17:58:43 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12548]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 17:58:44 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12578]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 19:08:33 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12558]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 19:08:33 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12578]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>             Nov  7 19:08:34 hgt-tero45
>             /usr/local/opensips/sbin/opensips[12572]:
>             ERROR:dialog:update_dialog_dbinfo: could not add another
>             dialog to db
>
>
>             What is happening?
>
>
>             Thanks.
>             Regards.
>
>
>             _______________________________________________
>             Users mailing list
>             Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>             http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>         _______________________________________________
>         Users mailing list
>         Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>         http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>     _______________________________________________ Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>     _______________________________________________ Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>
> -- 
> Muhammad Shahzad
> -----------------------------------
> CISCO Rich Media Communication Specialist (CRMCS)
> CISCO Certified Network Associate (CCNA)
> Cell: +49 176 99 83 10 85
> MSN: shari_786pk at hotmail.com <mailto:shari_786pk at hotmail.com>
> Email: shaheryarkh at googlemail.com <mailto:shaheryarkh at googlemail.com>
>
> _______________________________________________ Users mailing list 
> Users at lists.opensips.org 
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121115/48ce4134/attachment-0001.htm>


More information about the Users mailing list