[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