[OpenSIPS-Users] Errors in OpenSIPS

Tue Nov 13 14:48:51 CET 2012

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> 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
> To: 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
> To: 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 Developerhttp://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> 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
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing listUsers at lists.opensips.orghttp://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
>
> _______________________________________________ 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
>
>

-- 
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
Email: shaheryarkh at googlemail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121113/6548e0d0/attachment-0001.htm>