[asterisk-bugs] [Asterisk 0019032]: [patch] Voicemail messages (ODBC), incorrect sequence, msgnum=0 missing! Messages Over written

Fri Apr 1 02:43:02 CDT 2011

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=19032 
====================================================================== 
Reported By:                alecdavis
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   19032
Category:                   Applications/app_voicemail/ODBC
Reproducibility:            random
Severity:                   major
Priority:                   high
Status:                     new
Asterisk Version:           SVN 
JIRA:                        
Regression:                 No 
Reviewboard Link:           https://reviewboard.asterisk.org/r/1153/ 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2011-03-28 18:53 CDT
Last Modified:              2011-04-01 02:43 CDT
====================================================================== 
Summary:                    [patch] Voicemail messages (ODBC), incorrect
sequence, msgnum=0 missing! Messages Over written
Description: 
Repeatble: Asterisk 1.8.2.3 and Trunk

Users are unable to receive any further messages, until I have updated the
database, so that the msgnum is 0.

Users are unable to clear mailbox, Voicemail reports 1 new message, but
they are unable to clear it.

When trying to clear it, we get console message
2011-03-29 09:57:19.780] WARNING[22841]: app_voicemail.c:7570
play_message: No origtime?!

This seems exacltly like https://issues.asterisk.org/view.php?id=18740 but the
fix there only covers file based
storage.
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
related to          0018582 Problem reading a message which was pre...
related to          0018692 [patch] Compile Error - odbc_storage en...
====================================================================== 

---------------------------------------------------------------------- 
 (0133249) svnbot (reporter) - 2011-04-01 02:43
 https://issues.asterisk.org/view.php?id=19032#c133249 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 312118

_U  trunk/
U   trunk/apps/app_voicemail.c

------------------------------------------------------------------------
r312118 | alecdavis | 2011-04-01 02:43:00 -0500 (Fri, 01 Apr 2011) | 36
lines

Merged revisions 312117 via svnmerge from 
https://origsvn.digium.com/svn/asterisk/branches/1.8

................
  r312117 | alecdavis | 2011-04-01 20:32:12 +1300 (Fri, 01 Apr 2011) | 29
lines

  Merged revisions 312103 via svnmerge from 
  https://origsvn.digium.com/svn/asterisk/branches/1.6.2

  ................
    r312103 | alecdavis | 2011-04-01 20:25:54 +1300 (Fri, 01 Apr 2011) |
22 lines

    Merged revisions 312070 via svnmerge from 
    https://origsvn.digium.com/svn/asterisk/branches/1.4

    ........
      r312070 | alecdavis | 2011-04-01 19:46:56 +1300 (Fri, 01 Apr 2011) |
16 lines

      app_voicemail: close_mailbox needs to respect additional messages
while mailbox is open.

      close_mailbox leave gaps in message sequence if messages are deleted
and new messages
      arrive during this time, this is because the shuffle down to slot 0,
only shuffles
      the number of pre-existing messages when mailbox is opened, ignoring
new arrivals.

      Fix: in close_mailbox re-evaluate number of messages before the
shuffle, this then includes new arrivals.

      Happens on filebased or ODBC storage.

      (issues
https://issues.asterisk.org/view.php?id=19032,https://issues.asterisk.org/view.php?id=18582,https://issues.asterisk.org/view.php?id=18692,https://issues.asterisk.org/view.php?id=18998)
      Reported by: alecdavis,tootai,afosorio

      Review: https://reviewboard.asterisk.org/r/1153/
    ........
  ................
................

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=312118 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-04-01 02:43 svnbot         Checkin                                      
2011-04-01 02:43 svnbot         Note Added: 0133249                          
======================================================================