[asterisk-bugs] [JIRA] (ASTERISK-25686) PJSIP: qualify_timeout is a double, database schema is an integer

[Daniel Journo (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-25686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=229002#comment-229002 ] 

Daniel Journo commented on ASTERISK-25686:
------------------------------------------

I have added a fix to alembic to change it to Decimal. I've checked the Asterisk source and confirmed with the author. The correct type is Decimal for the quality_timeout. You are correct with what you did to resolve the issue.

> PJSIP: qualify_timeout is a double, database schema is an integer
> -----------------------------------------------------------------
>
>                 Key: ASTERISK-25686
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25686
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_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 Postgresql
>            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:
> {noformat}
> 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')
> {noformat}
> Asterisk logs:
> {noformat}
> *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.
> {noformat}
> 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)