[OpenSIPS-Users] MySQL Prepared Error
Bogdan-Andrei Iancu
bogdan at voice-system.ro
Thu Feb 5 13:25:00 CET 2009
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 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