[OpenSIPS-Users] Dialog module - db error

[Bogdan-Andrei Iancu]

Hi Anton,

The dialog module writes dialogs in DB only when they are established, 
so to-tag is present all the time in DB - this is why the table has the 
"not null" constraint ...

I see you have full debug - can you post the full debug of the call ?

Regards,
Bogdan

Anton Zagorskiy wrote:
> Hi.
>
> On latest svn stable time after time dialog module writes an error to the
> log:
>
> [46968]: DBG:dialog:dialog_update_db: inserting new dialog 0x8041572e8
> [46968]: DBG:db_mysql:has_stmt_ctx: ctx found for dialog
> [46968]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x722930
> (tail=7470400) MC=0x71fda0
> [46968]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the
> statement run
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=4; type=3;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=4; type=3;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=46; type=254;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=28; type=254;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (4): len=10; type=254;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (5): len=29; type=254;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (7): len=22; type=254;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (9): len=4; type=3;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (12): len=28; type=254;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (14): len=4; type=3;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (15): len=4; type=3;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (16): len=3; type=254;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_val2bind: added val (20): len=4; type=3;
> is_null=0
> [46968]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
> [46968]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error
> (1048): Column 'to_tag' cannot be null
> [46968]: ERROR:dialog:dialog_update_db: could not add another dialog to db
>
>
> Is it normal?
>
>
>
>
> WBR, Anton Zagorskiy
> VoIP Developer, Oyster Telecom
> Phone.: +7 812 601-0666
> Fax: +7 812 601-0593
> a.zagorskiy at oyster-telecom.ru
> www.oyster-telecom.ru
>
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
OpenSIPS eBootcamp - 28th February 2011
OpenSIPS solutions and "know-how"