[asterisk-bugs] [JIRA] (ASTERISK-20717) Voicemail access "SQL Get Data error! coltitle=msg_id"

[Jonathan Rose (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-20717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=201076#comment-201076 ] 

Jonathan Rose commented on ASTERISK-20717:
------------------------------------------

Hey Alec, I've updated the patch for this issue currently on reviewboard: https://reviewboard.asterisk.org/r/2220

The patch does the following:

* Fixes the warning messages you were receiving. Now when retrieving a message if Asterisk gets a NULL field when checking the msg_id field, it just silently updates the msg_id field using the new generate_msg_id function.
* msg_ids should now have a somewhat better guarantee for uniqueness. Multiple systems running Asterisk while using the same database could break this functionality, but that is a separate issue that we have identified and are considering fixing in trunk with UUID spport.
* Copying messages now supplies copies with an msg_id.

If you could verify whether or not this fix addresses your concerns, I'd appreciate it.
                
> Voicemail access "SQL Get Data error! coltitle=msg_id"
> ------------------------------------------------------
>
>                 Key: ASTERISK-20717
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-20717
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_voicemail/ODBC
>    Affects Versions: 11.0.1
>         Environment: Voicemail Build:= ODBC Storage
> MySQL backend
>            Reporter: Alec Davis
>            Assignee: Jonathan Rose
>            Severity: Minor
>
> Updraded from 1.8 to 11 and added in the extra msg_id field in MySQL,
> as noted in https://wiki.asterisk.org/wiki/display/AST/ODBC+Voicemail+Storage
> The message "SQL Get Data error! coltitle=msg_id" is emitted on console under the following events:
>  1) When using app_directory/app_voicemail when playing the username.
>  2) When playing, unheard previous 1.8 recordings.
>  3) When playing, 'OLD' meessages, whether recorded on 1.8 or 11
> As messages are listened to, and then moved to 'Old' they loose there msg_id - see tables below.
> {code}
> mysql> select id,msgnum,dir,msg_id,mailboxuser from voicemessages where mailboxuser=8512;
> +--------+--------+--------------------------------------------------+----------------------+-------------+
> | id     | msgnum | dir                                              | msg_id               | mailboxuser |
> +--------+--------+--------------------------------------------------+----------------------+-------------+
> |   2331 |      0 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL                 | 8512        |
> |  26321 |     -1 | /var/spool/asterisk/voicemail/default/8512/greet | NULL                 | 8512        |
> |  80021 |      1 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL                 | 8512        |
> | 127731 |      2 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL                 | 8512        |
> | 127751 |      3 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL                 | 8512        |
> | 127761 |      0 | /var/spool/asterisk/voicemail/default/8512/INBOX | 1353539236-128701767 | 8512        |
> +--------+--------+--------------------------------------------------+----------------------+-------------+
> 6 rows in set (0.00 sec)
> mysql> select id,msgnum,dir,msg_id,mailboxuser from voicemessages where mailboxuser=8512;
> +--------+--------+--------------------------------------------------+--------+-------------+
> | id     | msgnum | dir                                              | msg_id | mailboxuser |
> +--------+--------+--------------------------------------------------+--------+-------------+
> |   2331 |      0 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL   | 8512        |
> |  26321 |     -1 | /var/spool/asterisk/voicemail/default/8512/greet | NULL   | 8512        |
> |  80021 |      1 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL   | 8512        |
> | 127731 |      2 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL   | 8512        |
> | 127751 |      3 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL   | 8512        |
> | 127771 |      4 | /var/spool/asterisk/voicemail/default/8512/Old   | NULL   | 8512        |
> +--------+--------+--------------------------------------------------+--------+-------------+
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira