[OpenSIPS-Users] MySQL Prepared Error

ibrahim tunali ibrahimtunali at gmail.com
Thu Feb 5 12:50:37 CET 2009


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 at 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
<bogdan at voice-system.ro> 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 at 192.168.2.240:5466
>> | sip:195.174.30.145:61129 | NULL | 2009-02-03 16:15:28 | 0.00 |
>> 9c49ba35-6abd360f at 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
>> <bogdan at voice-system.ro> 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
>>>> <bogdan at voice-system.ro> 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
>>>>>> Users at lists.opensips.org
>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>



More information about the Users mailing list