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

[Asterisk Bug Tracker]

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:            
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-03-29 05:55 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...
====================================================================== 

---------------------------------------------------------------------- 
 (0133160) alecdavis (manager) - 2011-03-29 05:55
 https://issues.asterisk.org/view.php?id=19032#c133160 
---------------------------------------------------------------------- 
uploaded bug19032.part2.diff.txt

Both bug19032.diff.txt and bug19032.part2.diff.txt can be applied.

If next msgnum already exists, then prevent loss, increment msgnum until
one isn't found.

Ideally, the next msgnum should always be available. But let's not loose a
message. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-03-29 05:55 alecdavis      Note Added: 0133160                          
======================================================================