[asterisk-bugs] [JIRA] (ASTERISK-25686) Problem with contacts in pjsip realtime

[Marcelo Terres (JIRA)]

Marcelo Terres created ASTERISK-25686:
-----------------------------------------

             Summary: Problem with contacts in pjsip realtime
                 Key: ASTERISK-25686
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25686
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: pjproject/pjsip
    Affects Versions: 13.6.0
         Environment: Asterisk 13.6.0 - Ubuntu 14.04.3 LTS - Linux rtc 4.1.5-x86_64-linode61 #7 SMP Mon Aug 24 13:46:31 EDT 2015 x86_64 x86_64 x86_64 GNU/Linux
            Reporter: Marcelo Terres


Using pjsip realtime, after extension is registered, Asterisk try to add contact record in table (ps_contacts) but operation fails.

Postgres logs:
2016-01-11 18:03:39 UTC LOG:  statement: select pg_client_encoding()
2016-01-11 18:03:39 UTC LOG:  statement: INSERT INTO ps_contacts (id, qualify_timeout, outbound_proxy, expiration_time, path, qualify_frequency, user_agent, uri) VALUES (E'10^3B at 4baedafd08a7b062bb5e911f2d75c0c9', E'3.000000', E'', E'1452536319', E'', E'0', E'CSipSimple_titan_udstv-21/r2457', E'sip:10 at 179.224.243.192:51373^3Bob')
2016-01-11 18:03:39 UTC ERROR:  invalid input syntax for integer: "3.000000" at character 173
2016-01-11 18:03:39 UTC STATEMENT:  INSERT INTO ps_contacts (id, qualify_timeout, outbound_proxy, expiration_time, path, qualify_frequency, user_agent, uri) VALUES (E'10^3B at 4baedafd08a7b062bb5e911f2d75c0c9', E'3.000000', E'', E'1452536319', E'', E'0', E'CSipSimple_titan_udstv-21/r2457', E'sip:10 at 179.224.243.192:51373^3Bob')


Asterisk logs:
*CLI> [Jan 11 16:03:39] WARNING[32014]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: ERROR:  invalid input syntax for integer: "3.000000" at character 173;
Error while executing the query (102)
[Jan 11 16:03:39] WARNING[32014]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk]...
[Jan 11 16:03:39] WARNING[32014]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Jan 11 16:03:39] NOTICE[32014]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Jan 11 16:03:39] NOTICE[32014]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
[Jan 11 16:03:39] WARNING[32014]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: ERROR:  invalid input syntax for integer: "3.000000" at character 173;
Error while executing the query (102)
[Jan 11 16:03:39] WARNING[32014]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk]...
[Jan 11 16:03:39] WARNING[32014]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Jan 11 16:03:39] NOTICE[32014]: res_odbc.c:1528 odbc_obj_connect: Connecting asterisk
[Jan 11 16:03:39] NOTICE[32014]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
[Jan 11 16:03:39] ERROR[32014]: res_pjsip_registrar.c:504 rx_task: Unable to bind contact 'sip:10 at 179.224.243.192:51373;ob' to AOR '10'
[Jan 11 16:03:40] NOTICE[32013]: res_pjsip_mwi.c:717 mwi_new_subscribe: AOR 10 has no configured mailboxes. MWI subscription failed.

If I change qualify_timeout column value from 3.00000 to 3, the record can be manually added in table (using 3.0000 fails).





--
This message was sent by Atlassian JIRA
(v6.2#6252)