[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:40 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.
====================================================================== 

---------------------------------------------------------------------- 
 (0133151) alecdavis (manager) - 2011-03-28 19:40
 https://issues.asterisk.org/view.php?id=19032#c133151 
---------------------------------------------------------------------- 
how to fix the database:<pre>mysql> update voicemessages set msgnum='0'
where mailboxuser = '8612' and origtime='1301357585';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

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 |      0 | 8612   
    | 1301357585 |
+----+--------------------------------------------------+--------+-------------+------------+
1 row in set (0.00 sec)</pre> 

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