[asterisk-bugs] [JIRA] (ASTERISK-28166) app_voicemail: Asterisk unresponsive after changing voicemail password with ODBC

[Michael (JIRA)]

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

Michael edited comment on ASTERISK-28166 at 12/17/18 7:09 PM:
--------------------------------------------------------------

tried asterisk...
v15.7.0 fail
v13.21-cert3 fail
even tried v16.1.0 installed in debian jessie.  Fail.

I noticed just by chance that it is failing after i reload asterisk config.  If i just start up asterisk from a stopped state, it does NOT lock up.  It's only after asterisk has been reloaded ie. 'core reload' that causes these failures.

this behaviour doesn't happen when using realtime sql through the mysql driver and res_config_mysql.conf.  Only when using through the odbc driver and res_odbc.conf.



was (Author: ringo):

tried asterisk...
v15.7.0 fail
v13.21-cert3 fail
even tried v16.1.0 installed in debian jessie.  Fail.

I noticed just by chance that it is failing after i reload asterisk config.  If i just start up asterisk from a stopped state, it does NOT lock up.  It's only after asterisk has been reloaded ie. 'core reload' that causes these failures.



> app_voicemail: Asterisk unresponsive after changing voicemail password with ODBC
> --------------------------------------------------------------------------------
>
>                 Key: ASTERISK-28166
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28166
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_voicemail, Resources/res_config_odbc, Resources/res_odbc
>    Affects Versions: 16.0.0
>         Environment: debian 9 amd64
> asterisk v16 LTS
> using pjsip
> mysql ODBC
>            Reporter: Michael
>            Assignee: Unassigned
>            Severity: Minor
>              Labels: pjsip
>         Attachments: asterisk.tar.gz, extconfig.conf, res_odbc.conf
>
>
> i have 2 fresh installs of the latest v16 LTS on debian 9 using pjsip config setup in mysql through odbc driver mysql-connector-odbc-8.0.11.
> When I change voicemail password, at the time the new password would get writen into sql table, asterisk stops responding and must be killed -9 and restarted in order to resume normal opteration.
> This happens 100% of the time on 2 identical fresh installs.
> when using voicemail config in plain text file, this doesn't seem to happen.
> {noformat}
> [Nov 15 21:46:14] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating BEGIN DTMF Frame: 53 (5), at #.#.#.#:16408
> [Nov 15 21:46:14] DEBUG[20748] threadpool.c: Increasing threadpool stasis-core's size by 1
> [Nov 15 21:46:14] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating END DTMF Frame: 53 (5), at #.#.#.#:16408
> [Nov 15 21:46:14] DEBUG[16091][C-00000004] channel.c: Scheduling timer at (0 requested / 0 actual) timer ticks per second
> [Nov 15 21:46:14] DEBUG[16091][C-00000004] channel.c: Scheduling timer at (0 requested / 0 actual) timer ticks per second
> [Nov 15 21:46:14] DEBUG[16091][C-00000004] channel.c: Channel PJSIP/XXXXX-00000003 setting write format path: g722 -> g722
> [Nov 15 21:46:14] DEBUG[16091][C-00000004] media_cache.c: Failed to obtain media at 'vm-newpassword'
> [Nov 15 21:46:14] DEBUG[16091][C-00000004] channel.c: Channel PJSIP/XXXXX-00000003 setting write format path: g722 -> g722
> [Nov 15 21:46:14] DEBUG[16091][C-00000004] channel.c: Scheduling timer at (50 requested / 50 actual) timer ticks per second
> [Nov 15 21:46:14] VERBOSE[16091][C-00000004] file.c: <PJSIP/XXXXX-00000003> Playing 'vm-newpassword.g722' (language 'en')
> [Nov 15 21:46:18] DEBUG[16091][C-00000004] channel.c: Scheduling timer at (82 requested / 82 actual) timer ticks per second
> [Nov 15 21:46:18] DEBUG[16091][C-00000004] channel.c: Scheduling timer at (0 requested / 0 actual) timer ticks per second
> [Nov 15 21:46:18] DEBUG[16091][C-00000004] channel.c: Scheduling timer at (0 requested / 0 actual) timer ticks per second
> [Nov 15 21:46:18] DEBUG[16091][C-00000004] channel.c: Scheduling timer at (0 requested / 0 actual) timer ticks per second
> [Nov 15 21:46:18] DEBUG[16091][C-00000004] channel.c: Channel PJSIP/XXXXX-00000003 setting write format path: g722 -> g722
> [Nov 15 21:46:19] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating BEGIN DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:19] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating END DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:19] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating BEGIN DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:19] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating END DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:19] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating BEGIN DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:19] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating END DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:20] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating BEGIN DTMF Frame: 35 (#), at #.#.#.#:16408
> [Nov 15 21:46:20] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating END DTMF Frame: 35 (#), at #.#.#.#:16408
> [Nov 15 21:46:20] DEBUG[16091][C-00000004] media_cache.c: Failed to obtain media at 'vm-reenterpassword'
> [Nov 15 21:46:20] DEBUG[16091][C-00000004] channel.c: Channel PJSIP/XXXXX-00000003 setting write format path: g722 -> g722
> [Nov 15 21:46:20] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Difference is 22248, ms is 2801
> [Nov 15 21:46:20] DEBUG[16091][C-00000004] channel.c: Scheduling timer at (50 requested / 50 actual) timer ticks per second
> [Nov 15 21:46:20] VERBOSE[16091][C-00000004] file.c: <PJSIP/XXXXX-00000003> Playing 'vm-reenterpassword.g722' (language 'en')
> [Nov 15 21:46:21] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating BEGIN DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:21] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating END DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:21] DEBUG[16091][C-00000004] channel.c: Scheduling timer at (0 requested / 0 actual) timer ticks per second
> [Nov 15 21:46:21] DEBUG[16091][C-00000004] channel.c: Scheduling timer at (0 requested / 0 actual) timer ticks per second
> [Nov 15 21:46:21] DEBUG[16091][C-00000004] channel.c: Channel PJSIP/XXXXX-00000003 setting write format path: g722 -> g722
> [Nov 15 21:46:22] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating BEGIN DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:22] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating END DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:22] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating BEGIN DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:22] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating END DTMF Frame: 52 (4), at #.#.#.#:16408
> [Nov 15 21:46:22] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating BEGIN DTMF Frame: 35 (#), at #.#.#.#:16408
> [Nov 15 21:46:22] DEBUG[16091][C-00000004] res_rtp_asterisk.c: Creating END DTMF Frame: 35 (#), at #.#.#.#:16408
> [Nov 15 21:46:22] DEBUG[16091][C-00000004] res_odbc.c: Reusing ODBC handle 0x7f8c50003388 from class 'sqlP'
> {noformat}



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