Errors in OpenSIPS

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Errors in OpenSIPS

Jorge Ortea
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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Errors in OpenSIPS

Ali Pey
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Errors in OpenSIPS

Vlad Paiu
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Errors in OpenSIPS

Jorge Ortea
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: [hidden email]
To: [hidden email]
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Errors in OpenSIPS

Jorge Ortea
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: [hidden email]
To: [hidden email]
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: [hidden email]
To: [hidden email]
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Errors in OpenSIPS

Muhammad Shahzad
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 <[hidden email]> 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: [hidden email]
To: [hidden email]
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: [hidden email]
To: [hidden email]
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
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: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Errors in OpenSIPS

Jorge Ortea
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: [hidden email]
To: [hidden email]
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 <[hidden email]> 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: [hidden email]
To: [hidden email]
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: [hidden email]
To: [hidden email]
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
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: [hidden email]
Email: [hidden email]

_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Errors in OpenSIPS

Alex Ionescu-2
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: [hidden email]
To: [hidden email]
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 <[hidden email]> 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: [hidden email]
To: [hidden email]
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: [hidden email]
To: [hidden email]
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 <[hidden email]> 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
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: [hidden email]
Email: [hidden email]

_______________________________________________ Users mailing list [hidden email] http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users