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

[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:                   normal
Status:                     new
Asterisk Version:           1.8.2.3 
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-28 19:35 CDT
====================================================================== 
Summary:                    Voicemail messages (ODBC), incorrect sequence,
msgnum=0 missing!
Description: 
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.
====================================================================== 

---------------------------------------------------------------------- 
 (0133150) alecdavis (manager) - 2011-03-28 19:35
 https://issues.asterisk.org/view.php?id=19032#c133150 
---------------------------------------------------------------------- 
repeatable, just did it in trunk Asterisk SVN-trunk-r309300M 

Lets cause the problem:
Phone A: Ring Voicemail, and listen to my 1 and only message, but stay on
voicemail.
Phone B: ring myself from another phone leave another message.
Phone B: Finish leaving 2nd message and hangup.
Phone A: Pressed 5 to delete the original message I was listening to then
hangup.

While leaving message;<pre>

mysql> select id,dir,msgnum,mailboxuser,origtime from voicemessages where
mailboxuser = '8612' order by msgnum;
+----+--------------------------------------------------+--------+-------------+------------+
| id | dir                                              | msgnum |
mailboxuser | origtime   |
+----+--------------------------------------------------+--------+-------------+------------+
|  1 | /var/spool/asterisk/voicemail/default/8612/INBOX |      0 | 8612   
    | 1301357097 |
|  2 | /var/spool/asterisk/voicemail/default/8612/INBOX |      1 | 8612   
    | 1301357209 |
+----+--------------------------------------------------+--------+-------------+------------+
2 rows in set (0.00 sec)

After Deleting orignal message.
mysql> select id,dir,msgnum,mailboxuser,origtime from voicemessages where
mailboxuser = '8612' order by msgnum;
+----+--------------------------------------------------+--------+-------------+------------+
| id | dir                                              | msgnum |
mailboxuser | origtime   |
+----+--------------------------------------------------+--------+-------------+------------+
|  2 | /var/spool/asterisk/voicemail/default/8612/INBOX |      1 | 8612   
    | 1301357209 |
+----+--------------------------------------------------+--------+-------------+------------+

After leaving another message, notice id+=1
mysql> select id,dir,msgnum,mailboxuser,origtime from voicemessages where
mailboxuser = '8612' order by msgnum;
+----+--------------------------------------------------+--------+-------------+------------+
| id | dir                                              | msgnum |
mailboxuser | origtime   |
+----+--------------------------------------------------+--------+-------------+------------+
|  3 | /var/spool/asterisk/voicemail/default/8612/INBOX |      1 | 8612   
    | 1301357470 |
+----+--------------------------------------------------+--------+-------------+------------+

And anotehr message:
mysql> select id,dir,msgnum,mailboxuser,origtime from voicemessages where
mailboxuser = '8612' order by msgnum;
+----+--------------------------------------------------+--------+-------------+------------+
| id | dir                                              | msgnum |
mailboxuser | origtime   |
+----+--------------------------------------------------+--------+-------------+------------+
|  4 | /var/spool/asterisk/voicemail/default/8612/INBOX |      1 | 8612   
    | 1301357585 |
+----+--------------------------------------------------+--------+-------------+------------+
1 row in set (0.00 sec)</pre>

The only message that is being saved is the last message, and

When playing the supposed 1 message, Allison says 1st message, press 3 for
advanced options, with out playing the message. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-03-28 19:35 alecdavis      Note Added: 0133150                          
======================================================================