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

Fri Apr 1 04:03:13 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 04:03 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...
====================================================================== 

---------------------------------------------------------------------- 
 (0133260) svnbot (reporter) - 2011-04-01 04:03
 https://issues.asterisk.org/view.php?id=19032#c133260 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 312211

_U  branches/1.8/
U   branches/1.8/apps/app_voicemail.c

------------------------------------------------------------------------
r312211 | alecdavis | 2011-04-01 04:03:12 -0500 (Fri, 01 Apr 2011) | 36
lines

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

................
  r312210 | alecdavis | 2011-04-01 21:47:29 +1300 (Fri, 01 Apr 2011) | 29
lines

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

  ........
    r312174 | alecdavis | 2011-04-01 21:29:49 +1300 (Fri, 01 Apr 2011) |
23 lines

    voicemail: get real last_message_index and count_messages, ODBC
resequence

    change last_message_index to read the max msgnum stored in the
database
    change count_messages to actually count the number of messages.

    last_message_index change:
      This fixed overwriting of the last message if msgnum=0 was missing.
      Previously every incoming message would overwrite msgnum=1.
    count_messages change:
      allows us to detect when requencing is required in opneA_mailbox.
    resequence enabled for ODBC storage:
      Assists with fixing up corrupt databases with gaps, but only when
      a user actively opens there mailboxes.

    (closes issue
https://issues.asterisk.org/view.php?id=18692,https://issues.asterisk.org/view.php?id=18582,https://issues.asterisk.org/view.php?id=19032)
    Reported by: elguero
    Patches: 
          based on odbc_resequence_mailbox2.1.diff uploaded by elguero
(license 37)
    Tested by: elguero, nivek, alecdavis

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

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

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

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-04-01 04:03 svnbot         Checkin                                      
2011-04-01 04:03 svnbot         Note Added: 0133260                          
======================================================================