MySQL Prepared Error

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

MySQL Prepared Error

itunali
Hello,

I got below DB error when re-registering with SVN build Opensips. I
would appreciate if you could check this issue

Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:usrloc:update_ucontact: exists callback for type=
UL_CONTACT_UPDATE
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
set expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
where username=? AND contact=? AND callid=? AND domain=?|
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
successfully prepared
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
successfully set...
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
run
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
buf=2009-01-30 14:17:18; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
buf=0.00      ; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5;
buf=35581; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21;
buf=Linksys/SPA2100-3.3.6; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
buf=sip:193.192.116.18:64314; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
buf=NULL; is_null=1
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22;
buf=udp:81.21.166.171:5060; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
buf=5183; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
buf=2009-01-30 13:17:18; is_null=0
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
DBG:db_mysql:db_mysql_val2str_nq: unknown data type
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
(1)
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
ERROR:usrloc:db_update_ucontact: updating database failed
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
ERROR:usrloc:update_ucontact: failed to update database

Regards,
Ibrahim TUNALI

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

Re: MySQL Prepared Error

Bogdan-Andrei Iancu
Hi,

This is because of the newly introduced prepared statements in mysql.
But the error is in other place:

DBG:db_mysql:db_mysql_val2str_nq: unknown data type
Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]: ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 (1)

I enhanced the err reporting, so please update from SVN and do get the log again.

Thanks and regards,
Bogdan



ibrahim tunali wrote:

> Hello,
>
> I got below DB error when re-registering with SVN build Opensips. I
> would appreciate if you could check this issue
>
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:usrloc:update_ucontact: exists callback for type=
> UL_CONTACT_UPDATE
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
> set expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
> where username=? AND contact=? AND callid=? AND domain=?|
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
> successfully prepared
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
> successfully set...
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
> run
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
> buf=2009-01-30 14:17:18; is_null=0
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
> buf=0.00      ; is_null=0
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5;
> buf=35581; is_null=0
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
> is_null=0
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
> is_null=0
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21;
> buf=Linksys/SPA2100-3.3.6; is_null=0
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
> buf=sip:193.192.116.18:64314; is_null=0
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
> buf=NULL; is_null=1
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22;
> buf=udp:81.21.166.171:5060; is_null=0
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
> buf=5183; is_null=0
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
> buf=2009-01-30 13:17:18; is_null=0
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
> (1)
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> ERROR:usrloc:db_update_ucontact: updating database failed
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> ERROR:usrloc:update_ucontact: failed to update database
>
> Regards,
> Ibrahim TUNALI
>
> _______________________________________________
> 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: MySQL Prepared Error

itunali
Hi Bogdan,

Thank you for quick reply. Detailed error;

Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233329982)
Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
(1)

Best regards,

Ibrahim TUNALI




On Fri, Jan 30, 2009 at 16:09, Bogdan-Andrei Iancu
<[hidden email]> wrote:

> Hi,
>
> This is because of the newly introduced prepared statements in mysql. But
> the error is in other place:
>
> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 (1)
>
> I enhanced the err reporting, so please update from SVN and do get the log
> again.
>
> Thanks and regards,
> Bogdan
>
>
>
> ibrahim tunali wrote:
>>
>> Hello,
>>
>> I got below DB error when re-registering with SVN build Opensips. I
>> would appreciate if you could check this issue
>>
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:usrloc:update_ucontact: exists callback for type=
>> UL_CONTACT_UPDATE
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
>> set
>> expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
>> where username=? AND contact=? AND callid=? AND domain=?|
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>> successfully prepared
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>> successfully set...
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
>> run
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
>> buf=2009-01-30 14:17:18; is_null=0
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
>> buf=0.00      ; is_null=0
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5;
>> buf=35581; is_null=0
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
>> is_null=0
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
>> is_null=0
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21;
>> buf=Linksys/SPA2100-3.3.6; is_null=0
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
>> buf=sip:193.192.116.18:64314; is_null=0
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
>> buf=NULL; is_null=1
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22;
>> buf=udp:81.21.166.171:5060; is_null=0
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
>> buf=5183; is_null=0
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
>> buf=2009-01-30 13:17:18; is_null=0
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>> (1)
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> ERROR:usrloc:db_update_ucontact: updating database failed
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> ERROR:usrloc:update_ucontact: failed to update database
>>
>> Regards,
>> Ibrahim TUNALI
>>
>> _______________________________________________
>> 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: MySQL Prepared Error

Bogdan-Andrei Iancu
Hi Ibrahim ,

It might be a stupid question, but are you 100% sure you did a complete
update (for all modules and core files) from SVN ?

Regards,
Bogdan

ibrahim tunali wrote:

> Hi Bogdan,
>
> Thank you for quick reply. Detailed error;
>
> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233329982)
> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
> (1)
>
> Best regards,
>
> Ibrahim TUNALI
>
>
>
>
> On Fri, Jan 30, 2009 at 16:09, Bogdan-Andrei Iancu
> <[hidden email]> wrote:
>  
>> Hi,
>>
>> This is because of the newly introduced prepared statements in mysql. But
>> the error is in other place:
>>
>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 (1)
>>
>> I enhanced the err reporting, so please update from SVN and do get the log
>> again.
>>
>> Thanks and regards,
>> Bogdan
>>
>>
>>
>> ibrahim tunali wrote:
>>    
>>> Hello,
>>>
>>> I got below DB error when re-registering with SVN build Opensips. I
>>> would appreciate if you could check this issue
>>>
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:usrloc:update_ucontact: exists callback for type=
>>> UL_CONTACT_UPDATE
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
>>> set
>>> expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
>>> where username=? AND contact=? AND callid=? AND domain=?|
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>> successfully prepared
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>> successfully set...
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
>>> run
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
>>> buf=2009-01-30 14:17:18; is_null=0
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
>>> buf=0.00      ; is_null=0
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5;
>>> buf=35581; is_null=0
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
>>> is_null=0
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
>>> is_null=0
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21;
>>> buf=Linksys/SPA2100-3.3.6; is_null=0
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
>>> buf=sip:193.192.116.18:64314; is_null=0
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
>>> buf=NULL; is_null=1
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22;
>>> buf=udp:81.21.166.171:5060; is_null=0
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
>>> buf=5183; is_null=0
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
>>> buf=2009-01-30 13:17:18; is_null=0
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>>> (1)
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> ERROR:usrloc:db_update_ucontact: updating database failed
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> ERROR:usrloc:update_ucontact: failed to update database
>>>
>>> Regards,
>>> Ibrahim TUNALI
>>>
>>> _______________________________________________
>>> 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: MySQL Prepared Error

itunali
Hi Bogdan,

Sorry for the late response. The error occurs when RE-register.

I already register and location table row is ;
+----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
| id | username   | domain         | contact
| received                 | path | expires             | q    |
callid                          | cseq  | last_modified       | flags
| cflags | user_agent            | socket                 | methods |
+----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
| 92 | 5559050777 | sip.nexalo.com | sip:5559050777@192.168.2.240:5466
| sip:195.174.30.145:61129 | NULL | 2009-02-03 16:15:28 | 0.00 |
9c49ba35-6abd360f@192.168.2.240 | 23551 | 2009-02-03 15:15:28 |     0
|     64 | Linksys/SPA2100-3.3.6 | udp:81.21.166.171:5060 |    5183 |
+----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+

Error log;

Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233674286)
Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
(1)
Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
ERROR:usrloc:db_update_ucontact: updating database failed
Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
ERROR:usrloc:update_ucontact: failed to update database

Best Regards,

Ibrahim TUNALI




On Sat, Jan 31, 2009 at 08:00, Bogdan-Andrei Iancu
<[hidden email]> wrote:

> Hi Ibrahim ,
>
> It might be a stupid question, but are you 100% sure you did a complete
> update (for all modules and core files) from SVN ?
>
> Regards,
> Bogdan
>
> ibrahim tunali wrote:
>>
>> Hi Bogdan,
>>
>> Thank you for quick reply. Detailed error;
>>
>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
>> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233329982)
>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>> (1)
>>
>> Best regards,
>>
>> Ibrahim TUNALI
>>
>>
>>
>>
>> On Fri, Jan 30, 2009 at 16:09, Bogdan-Andrei Iancu
>> <[hidden email]> wrote:
>>
>>>
>>> Hi,
>>>
>>> This is because of the newly introduced prepared statements in mysql. But
>>> the error is in other place:
>>>
>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 (1)
>>>
>>> I enhanced the err reporting, so please update from SVN and do get the
>>> log
>>> again.
>>>
>>> Thanks and regards,
>>> Bogdan
>>>
>>>
>>>
>>> ibrahim tunali wrote:
>>>
>>>>
>>>> Hello,
>>>>
>>>> I got below DB error when re-registering with SVN build Opensips. I
>>>> would appreciate if you could check this issue
>>>>
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:usrloc:update_ucontact: exists callback for type=
>>>> UL_CONTACT_UPDATE
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
>>>> set
>>>>
>>>> expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
>>>> where username=? AND contact=? AND callid=? AND domain=?|
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>>> successfully prepared
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>>> successfully set...
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
>>>> run
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
>>>> buf=2009-01-30 14:17:18; is_null=0
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
>>>> buf=0.00      ; is_null=0
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5;
>>>> buf=35581; is_null=0
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
>>>> is_null=0
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
>>>> is_null=0
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21;
>>>> buf=Linksys/SPA2100-3.3.6; is_null=0
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
>>>> buf=sip:193.192.116.18:64314; is_null=0
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
>>>> buf=NULL; is_null=1
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22;
>>>> buf=udp:81.21.166.171:5060; is_null=0
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
>>>> buf=5183; is_null=0
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
>>>> buf=2009-01-30 13:17:18; is_null=0
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>>>> (1)
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> ERROR:usrloc:db_update_ucontact: updating database failed
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> ERROR:usrloc:update_ucontact: failed to update database
>>>>
>>>> Regards,
>>>> Ibrahim TUNALI
>>>>
>>>> _______________________________________________
>>>> 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: MySQL Prepared Error

Bogdan-Andrei Iancu
Hi Ibrahim,

Could you post (or send privately) the entire opensips log, please?

Again, have you fully updated from SVN (complete tree?)

Thanks and regards,
Bogdan

ibrahim tunali wrote:

> Hi Bogdan,
>
> Sorry for the late response. The error occurs when RE-register.
>
> I already register and location table row is ;
> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
> | id | username   | domain         | contact
> | received                 | path | expires             | q    |
> callid                          | cseq  | last_modified       | flags
> | cflags | user_agent            | socket                 | methods |
> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
> | 92 | 5559050777 | sip.nexalo.com | sip:5559050777@192.168.2.240:5466
> | sip:195.174.30.145:61129 | NULL | 2009-02-03 16:15:28 | 0.00 |
> 9c49ba35-6abd360f@192.168.2.240 | 23551 | 2009-02-03 15:15:28 |     0
> |     64 | Linksys/SPA2100-3.3.6 | udp:81.21.166.171:5060 |    5183 |
> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
>
> Error log;
>
> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233674286)
> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
> (1)
> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
> ERROR:usrloc:db_update_ucontact: updating database failed
> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
> ERROR:usrloc:update_ucontact: failed to update database
>
> Best Regards,
>
> Ibrahim TUNALI
>
>
>
>
> On Sat, Jan 31, 2009 at 08:00, Bogdan-Andrei Iancu
> <[hidden email]> wrote:
>  
>> Hi Ibrahim ,
>>
>> It might be a stupid question, but are you 100% sure you did a complete
>> update (for all modules and core files) from SVN ?
>>
>> Regards,
>> Bogdan
>>
>> ibrahim tunali wrote:
>>    
>>> Hi Bogdan,
>>>
>>> Thank you for quick reply. Detailed error;
>>>
>>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
>>> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233329982)
>>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>>> (1)
>>>
>>> Best regards,
>>>
>>> Ibrahim TUNALI
>>>
>>>
>>>
>>>
>>> On Fri, Jan 30, 2009 at 16:09, Bogdan-Andrei Iancu
>>> <[hidden email]> wrote:
>>>
>>>      
>>>> Hi,
>>>>
>>>> This is because of the newly introduced prepared statements in mysql. But
>>>> the error is in other place:
>>>>
>>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 (1)
>>>>
>>>> I enhanced the err reporting, so please update from SVN and do get the
>>>> log
>>>> again.
>>>>
>>>> Thanks and regards,
>>>> Bogdan
>>>>
>>>>
>>>>
>>>> ibrahim tunali wrote:
>>>>
>>>>        
>>>>> Hello,
>>>>>
>>>>> I got below DB error when re-registering with SVN build Opensips. I
>>>>> would appreciate if you could check this issue
>>>>>
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:usrloc:update_ucontact: exists callback for type=
>>>>> UL_CONTACT_UPDATE
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
>>>>> set
>>>>>
>>>>> expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
>>>>> where username=? AND contact=? AND callid=? AND domain=?|
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>>>> successfully prepared
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>>>> successfully set...
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
>>>>> run
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
>>>>> buf=2009-01-30 14:17:18; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
>>>>> buf=0.00      ; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5;
>>>>> buf=35581; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
>>>>> is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
>>>>> is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21;
>>>>> buf=Linksys/SPA2100-3.3.6; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
>>>>> buf=sip:193.192.116.18:64314; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
>>>>> buf=NULL; is_null=1
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22;
>>>>> buf=udp:81.21.166.171:5060; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
>>>>> buf=5183; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
>>>>> buf=2009-01-30 13:17:18; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>>>>> (1)
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> ERROR:usrloc:db_update_ucontact: updating database failed
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> ERROR:usrloc:update_ucontact: failed to update database
>>>>>
>>>>> Regards,
>>>>> Ibrahim TUNALI
>>>>>
>>>>> _______________________________________________
>>>>> 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: MySQL Prepared Error

itunali
Hi Bogdan,

I just have rebuild from SVN  and previous mentioned problem seems to
solved. but this time it do not update correctly location table with
new expire timestamp. You can find detailed dump log at below. I
guess, it is not fill the "where" clause values on update query.

Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
set expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
where username=? AND contact=? AND callid=? AND domain=?|
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
successfully prepared
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
successfully set...
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
run
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
buf=2009-02-05 12:35:13; is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
buf=0.00      ; is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=1; buf=2;
is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=25;
buf=Sipura/SPA1001-3.1.8(SEc); is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
buf=sip:195.174.30.145:57009; is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
buf=NULL; is_null=1
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=23;
buf=udp:70.232.148.122:5060; is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
buf=5183; is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
buf=2009-02-05 11:35:13; is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (11): len=19;
buf=NULL; is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (12): len=10;
buf=NULL; is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (13): len=1;
buf=NULL; is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (14): len=1;
buf=NULL; is_null=0
Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
DBG:registrar:build_contact: created Contact HF: Contact:
<sip:5559050777@192.168.2.242:5466>;q=0;expires=3600;received="sip:195.174.30.145:57009"

Best regards,

Ibrahim TUNALI



On Thu, Feb 5, 2009 at 11:06, Bogdan-Andrei Iancu
<[hidden email]> wrote:

> Hi Ibrahim,
>
> Could you post (or send privately) the entire opensips log, please?
> Again, have you fully updated from SVN (complete tree?)
>
> Thanks and regards,
> Bogdan
>
> ibrahim tunali wrote:
>>
>> Hi Bogdan,
>>
>> Sorry for the late response. The error occurs when RE-register.
>>
>> I already register and location table row is ;
>>
>> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
>> | id | username   | domain         | contact
>> | received                 | path | expires             | q    |
>> callid                          | cseq  | last_modified       | flags
>> | cflags | user_agent            | socket                 | methods |
>>
>> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
>> | 92 | 5559050777 | sip.nexalo.com | sip:5559050777@192.168.2.240:5466
>> | sip:195.174.30.145:61129 | NULL | 2009-02-03 16:15:28 | 0.00 |
>> 9c49ba35-6abd360f@192.168.2.240 | 23551 | 2009-02-03 15:15:28 |     0
>> |     64 | Linksys/SPA2100-3.3.6 | udp:81.21.166.171:5060 |    5183 |
>>
>> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
>>
>> Error log;
>>
>> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
>> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233674286)
>> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>> (1)
>> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
>> ERROR:usrloc:db_update_ucontact: updating database failed
>> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
>> ERROR:usrloc:update_ucontact: failed to update database
>>
>> Best Regards,
>>
>> Ibrahim TUNALI
>>
>>
>>
>>
>> On Sat, Jan 31, 2009 at 08:00, Bogdan-Andrei Iancu
>> <[hidden email]> wrote:
>>
>>>
>>> Hi Ibrahim ,
>>>
>>> It might be a stupid question, but are you 100% sure you did a complete
>>> update (for all modules and core files) from SVN ?
>>>
>>> Regards,
>>> Bogdan
>>>
>>> ibrahim tunali wrote:
>>>
>>>>
>>>> Hi Bogdan,
>>>>
>>>> Thank you for quick reply. Detailed error;
>>>>
>>>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
>>>> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233329982)
>>>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>>>> (1)
>>>>
>>>> Best regards,
>>>>
>>>> Ibrahim TUNALI
>>>>
>>>>
>>>>
>>>>
>>>> On Fri, Jan 30, 2009 at 16:09, Bogdan-Andrei Iancu
>>>> <[hidden email]> wrote:
>>>>
>>>>
>>>>>
>>>>> Hi,
>>>>>
>>>>> This is because of the newly introduced prepared statements in mysql.
>>>>> But
>>>>> the error is in other place:
>>>>>
>>>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 (1)
>>>>>
>>>>> I enhanced the err reporting, so please update from SVN and do get the
>>>>> log
>>>>> again.
>>>>>
>>>>> Thanks and regards,
>>>>> Bogdan
>>>>>
>>>>>
>>>>>
>>>>> ibrahim tunali wrote:
>>>>>
>>>>>
>>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> I got below DB error when re-registering with SVN build Opensips. I
>>>>>> would appreciate if you could check this issue
>>>>>>
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:usrloc:update_ucontact: exists callback for type=
>>>>>> UL_CONTACT_UPDATE
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
>>>>>> set
>>>>>>
>>>>>>
>>>>>> expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
>>>>>> where username=? AND contact=? AND callid=? AND domain=?|
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>>>>> successfully prepared
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>>>>> successfully set...
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
>>>>>> run
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
>>>>>> buf=2009-01-30 14:17:18; is_null=0
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
>>>>>> buf=0.00      ; is_null=0
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5;
>>>>>> buf=35581; is_null=0
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
>>>>>> is_null=0
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
>>>>>> is_null=0
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21;
>>>>>> buf=Linksys/SPA2100-3.3.6; is_null=0
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
>>>>>> buf=sip:193.192.116.18:64314; is_null=0
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
>>>>>> buf=NULL; is_null=1
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22;
>>>>>> buf=udp:81.21.166.171:5060; is_null=0
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
>>>>>> buf=5183; is_null=0
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
>>>>>> buf=2009-01-30 13:17:18; is_null=0
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>>>>>> (1)
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> ERROR:usrloc:db_update_ucontact: updating database failed
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> ERROR:usrloc:update_ucontact: failed to update database
>>>>>>
>>>>>> Regards,
>>>>>> Ibrahim TUNALI
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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: MySQL Prepared Error

Bogdan-Andrei Iancu
In reply to this post by itunali
Hi Ibrahim,

I found the bug - please update and test again.

Regards,
Bogdan

ibrahim tunali wrote:

> Hi Bogdan,
>
> Sorry for the late response. The error occurs when RE-register.
>
> I already register and location table row is ;
> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
> | id | username   | domain         | contact
> | received                 | path | expires             | q    |
> callid                          | cseq  | last_modified       | flags
> | cflags | user_agent            | socket                 | methods |
> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
> | 92 | 5559050777 | sip.nexalo.com | sip:5559050777@192.168.2.240:5466
> | sip:195.174.30.145:61129 | NULL | 2009-02-03 16:15:28 | 0.00 |
> 9c49ba35-6abd360f@192.168.2.240 | 23551 | 2009-02-03 15:15:28 |     0
> |     64 | Linksys/SPA2100-3.3.6 | udp:81.21.166.171:5060 |    5183 |
> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
>
> Error log;
>
> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233674286)
> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
> (1)
> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
> ERROR:usrloc:db_update_ucontact: updating database failed
> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
> ERROR:usrloc:update_ucontact: failed to update database
>
> Best Regards,
>
> Ibrahim TUNALI
>
>
>
>
> On Sat, Jan 31, 2009 at 08:00, Bogdan-Andrei Iancu
> <[hidden email]> wrote:
>  
>> Hi Ibrahim ,
>>
>> It might be a stupid question, but are you 100% sure you did a complete
>> update (for all modules and core files) from SVN ?
>>
>> Regards,
>> Bogdan
>>
>> ibrahim tunali wrote:
>>    
>>> Hi Bogdan,
>>>
>>> Thank you for quick reply. Detailed error;
>>>
>>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
>>> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233329982)
>>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>>> (1)
>>>
>>> Best regards,
>>>
>>> Ibrahim TUNALI
>>>
>>>
>>>
>>>
>>> On Fri, Jan 30, 2009 at 16:09, Bogdan-Andrei Iancu
>>> <[hidden email]> wrote:
>>>
>>>      
>>>> Hi,
>>>>
>>>> This is because of the newly introduced prepared statements in mysql. But
>>>> the error is in other place:
>>>>
>>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 (1)
>>>>
>>>> I enhanced the err reporting, so please update from SVN and do get the
>>>> log
>>>> again.
>>>>
>>>> Thanks and regards,
>>>> Bogdan
>>>>
>>>>
>>>>
>>>> ibrahim tunali wrote:
>>>>
>>>>        
>>>>> Hello,
>>>>>
>>>>> I got below DB error when re-registering with SVN build Opensips. I
>>>>> would appreciate if you could check this issue
>>>>>
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:usrloc:update_ucontact: exists callback for type=
>>>>> UL_CONTACT_UPDATE
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
>>>>> set
>>>>>
>>>>> expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
>>>>> where username=? AND contact=? AND callid=? AND domain=?|
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>>>> successfully prepared
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>>>> successfully set...
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
>>>>> run
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
>>>>> buf=2009-01-30 14:17:18; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
>>>>> buf=0.00      ; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5;
>>>>> buf=35581; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
>>>>> is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
>>>>> is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21;
>>>>> buf=Linksys/SPA2100-3.3.6; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
>>>>> buf=sip:193.192.116.18:64314; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
>>>>> buf=NULL; is_null=1
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22;
>>>>> buf=udp:81.21.166.171:5060; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
>>>>> buf=5183; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
>>>>> buf=2009-01-30 13:17:18; is_null=0
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>>>>> (1)
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> ERROR:usrloc:db_update_ucontact: updating database failed
>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>> ERROR:usrloc:update_ucontact: failed to update database
>>>>>
>>>>> Regards,
>>>>> Ibrahim TUNALI
>>>>>
>>>>> _______________________________________________
>>>>> 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: MySQL Prepared Error

Bogdan-Andrei Iancu
In reply to this post by itunali
Hi Ibrahim,

I know, there was bug which is now fixed on the SVN....please update and
test.

Regards,
Bogdan

ibrahim tunali wrote:

> Hi Bogdan,
>
> I just have rebuild from SVN  and previous mentioned problem seems to
> solved. but this time it do not update correctly location table with
> new expire timestamp. You can find detailed dump log at below. I
> guess, it is not fill the "where" clause values on update query.
>
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
> set expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
> where username=? AND contact=? AND callid=? AND domain=?|
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
> successfully prepared
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
> successfully set...
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
> run
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
> buf=2009-02-05 12:35:13; is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
> buf=0.00      ; is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=1; buf=2;
> is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
> is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
> is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=25;
> buf=Sipura/SPA1001-3.1.8(SEc); is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
> buf=sip:195.174.30.145:57009; is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
> buf=NULL; is_null=1
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=23;
> buf=udp:70.232.148.122:5060; is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
> buf=5183; is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
> buf=2009-02-05 11:35:13; is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (11): len=19;
> buf=NULL; is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (12): len=10;
> buf=NULL; is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (13): len=1;
> buf=NULL; is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:db_mysql:db_mysql_do_prepared_query: added val 2 (14): len=1;
> buf=NULL; is_null=0
> Feb  5 11:35:13 sip1 /usr/sbin/opensips[29557]:
> DBG:registrar:build_contact: created Contact HF: Contact:
> <sip:5559050777@192.168.2.242:5466>;q=0;expires=3600;received="sip:195.174.30.145:57009"
>
> Best regards,
>
> Ibrahim TUNALI
>
>
>
> On Thu, Feb 5, 2009 at 11:06, Bogdan-Andrei Iancu
> <[hidden email]> wrote:
>  
>> Hi Ibrahim,
>>
>> Could you post (or send privately) the entire opensips log, please?
>> Again, have you fully updated from SVN (complete tree?)
>>
>> Thanks and regards,
>> Bogdan
>>
>> ibrahim tunali wrote:
>>    
>>> Hi Bogdan,
>>>
>>> Sorry for the late response. The error occurs when RE-register.
>>>
>>> I already register and location table row is ;
>>>
>>> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
>>> | id | username   | domain         | contact
>>> | received                 | path | expires             | q    |
>>> callid                          | cseq  | last_modified       | flags
>>> | cflags | user_agent            | socket                 | methods |
>>>
>>> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
>>> | 92 | 5559050777 | sip.nexalo.com | sip:5559050777@192.168.2.240:5466
>>> | sip:195.174.30.145:61129 | NULL | 2009-02-03 16:15:28 | 0.00 |
>>> 9c49ba35-6abd360f@192.168.2.240 | 23551 | 2009-02-03 15:15:28 |     0
>>> |     64 | Linksys/SPA2100-3.3.6 | udp:81.21.166.171:5060 |    5183 |
>>>
>>> +----+------------+----------------+-----------------------------------+--------------------------+------+---------------------+------+---------------------------------+-------+---------------------+-------+--------+-----------------------+------------------------+---------+
>>>
>>> Error log;
>>>
>>> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
>>> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233674286)
>>> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>>> (1)
>>> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
>>> ERROR:usrloc:db_update_ucontact: updating database failed
>>> Feb  3 15:18:06 voipvserver /usr/sbin/opensips[2009]:
>>> ERROR:usrloc:update_ucontact: failed to update database
>>>
>>> Best Regards,
>>>
>>> Ibrahim TUNALI
>>>
>>>
>>>
>>>
>>> On Sat, Jan 31, 2009 at 08:00, Bogdan-Andrei Iancu
>>> <[hidden email]> wrote:
>>>
>>>      
>>>> Hi Ibrahim ,
>>>>
>>>> It might be a stupid question, but are you 100% sure you did a complete
>>>> update (for all modules and core files) from SVN ?
>>>>
>>>> Regards,
>>>> Bogdan
>>>>
>>>> ibrahim tunali wrote:
>>>>
>>>>        
>>>>> Hi Bogdan,
>>>>>
>>>>> Thank you for quick reply. Detailed error;
>>>>>
>>>>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
>>>>> ERROR:db_mysql:db_mysql_val2str_nq: unknown data type (1233329982)
>>>>> Jan 30 15:39:42 voipvserver /usr/sbin/opensips[27892]:
>>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>>>>> (1)
>>>>>
>>>>> Best regards,
>>>>>
>>>>> Ibrahim TUNALI
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Fri, Jan 30, 2009 at 16:09, Bogdan-Andrei Iancu
>>>>> <[hidden email]> wrote:
>>>>>
>>>>>
>>>>>          
>>>>>> Hi,
>>>>>>
>>>>>> This is because of the newly introduced prepared statements in mysql.
>>>>>> But
>>>>>> the error is in other place:
>>>>>>
>>>>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0 (1)
>>>>>>
>>>>>> I enhanced the err reporting, so please update from SVN and do get the
>>>>>> log
>>>>>> again.
>>>>>>
>>>>>> Thanks and regards,
>>>>>> Bogdan
>>>>>>
>>>>>>
>>>>>>
>>>>>> ibrahim tunali wrote:
>>>>>>
>>>>>>
>>>>>>            
>>>>>>> Hello,
>>>>>>>
>>>>>>> I got below DB error when re-registering with SVN build Opensips. I
>>>>>>> would appreciate if you could check this issue
>>>>>>>
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:usrloc:update_ucontact: exists callback for type=
>>>>>>> UL_CONTACT_UPDATE
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: new query=|update location
>>>>>>> set
>>>>>>>
>>>>>>>
>>>>>>> expires=?,q=?,cseq=?,flags=?,cflags=?,user_agent=?,received=?,path=?,socket=?,methods=?,last_modified=?
>>>>>>> where username=? AND contact=? AND callid=? AND domain=?|
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>>>>>> successfully prepared
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: prepared statement
>>>>>>> successfully set...
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement
>>>>>>> run
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (0): len=19;
>>>>>>> buf=2009-01-30 14:17:18; is_null=0
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (1): len=10;
>>>>>>> buf=0.00      ; is_null=0
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (2): len=5;
>>>>>>> buf=35581; is_null=0
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (3): len=1; buf=0;
>>>>>>> is_null=0
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (4): len=2; buf=64;
>>>>>>> is_null=0
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (5): len=21;
>>>>>>> buf=Linksys/SPA2100-3.3.6; is_null=0
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (6): len=24;
>>>>>>> buf=sip:193.192.116.18:64314; is_null=0
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (7): len=4;
>>>>>>> buf=NULL; is_null=1
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (8): len=22;
>>>>>>> buf=udp:81.21.166.171:5060; is_null=0
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (9): len=4;
>>>>>>> buf=5183; is_null=0
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_do_prepared_query: added val (10): len=19;
>>>>>>> buf=2009-01-30 13:17:18; is_null=0
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> DBG:db_mysql:db_mysql_val2str_nq: unknown data type
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> ERROR:db_mysql:db_mysql_do_prepared_query: val2str() failed for i=0
>>>>>>> (1)
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> ERROR:usrloc:db_update_ucontact: updating database failed
>>>>>>> Jan 30 13:17:18 voipvserver /usr/sbin/opensips[15594]:
>>>>>>> ERROR:usrloc:update_ucontact: failed to update database
>>>>>>>
>>>>>>> Regards,
>>>>>>> Ibrahim TUNALI
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> 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