[asterisk-bugs] [JIRA] (ASTERISK-28992) app_voicemail: Deadlock in ODBC when retrieving file

[Schneur Rosenberg (JIRA)]

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

Schneur Rosenberg edited comment on ASTERISK-28992 at 12/3/20 12:08 PM:
------------------------------------------------------------------------

system hanging for 5 minutes when trying to leave or retrieve a messsage, messages getting deleted when system is trying to reorder, mailboxes being locked with the .lock file isnt called fixed, the system should know how to reorder the msgnum without all the above problems, the only thing that is fixed is that I dont need to restart asterisk after everytime it hangs, it releases itself after a few minutes. 

You're correct that the problem is that I manipulated the DB directly, but Asterisk should  be able to handle issues like this, not all our customers listen to the VM's through asterisk, my portal pulls the messages directly from the DB and the customers can delete messages from the portal.

I will reorder the msgnum from now on after a delete, but its still a bug that the system gets locked for a few minutes while trying to reorder.


was (Author: thesipguy):
system hanging for 5 minutes when trying to leave or retrieve a messsage, messages getting deleted when system is trying to reorder, mailboxes being locked with the .lock file isnt called fixed, the system should know how to reorder the msgnum without all the above problems, the only thing that is fixed is that I dont need to restart asterisk after everytime it hangs, it releases itself after a few minutes. 

> app_voicemail: Deadlock in ODBC when retrieving file
> ----------------------------------------------------
>
>                 Key: ASTERISK-28992
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28992
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_voicemail/ODBC
>    Affects Versions: 17.5.1
>         Environment: Debian 9
>            Reporter: Schneur Rosenberg
>            Assignee: Unassigned
>              Labels: patch
>         Attachments: 0001-app_voicemail-Prevent-deadlocks-when-out-of-ODBC-dat.patch, locks.zip
>
>
> I'm having a major issue since I upgraded from Asterisk 11 that both voicemail and voicemailmain ocasionally crash, the call remains connected but there is silence, and the channel cannot be killed, hanging up wont help and neither would  "hangup request" and the every few seconds there would be a message in the CLI like WARNING[31353]: chan_sip.c:4410 __sip_autodestruct: Autodestruct on dialog '1216767442-5060-95 at BJC.BGI.A.BA' with owner SIP/9174342412-0000016a in place (Method: BYE). Rescheduling destruction for 10000 ms.
> Usually once it crashes no other users can get into their voicemail boxes and no new voicemails can be left until i restart asterisk



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