<span class="postbody">Hi ALL,
<br>
<br>
When i was accessing the voice message it suddenly goes dead and after
that i couldn't able to retrieve the voicemessage again from my mailbox
. This happens once in a while for any configured mailboxes <br>
<br>
I am using the following system configuration.
<br>
<br>
asterisk 1.4.22.1
<br>
odbc storage of voicemail messages
<br>
centos 5.2 64bit
<br>
unixODBC-2.2.11-7.1
<br>
mysql-connector-odbc-3.51.12-2.2
<br>
mysql-server-5.0.45-7.el5
<br>
<br>
Following are the traces i found while troubleshooting the issue.
<br>
<br>
1) I found a .lock file created in the INBOX folder of my mailbox
<br>
2) The following core dump gets created during the first time the voicemessage access got failed.
<br>
<br><b>
(gdb) bt
<br><br></b>#0 0x000000322b417649 in SQLFreeEnv () from /usr/lib64/libodbc.so.1<br>#1 0x000000322b417b5c in SQLFreeHandle () from /usr/lib64/libodbc.so.1<br>#2 0x00002aaac132ccdd in message_exists (dir=<value optimized out>, msgnum=<value optimized out>)<br>
from /usr/lib/asterisk/modules/app_voicemail.so<br>#3 0x00002aaac132dab2 in save_to_folder (vmu=0x41751e80, vms=<value optimized out>, msg=0, box=<value optimized out>)<br> from /usr/lib/asterisk/modules/app_voicemail.so<br>
#4 0x00002aaac132dc77 in close_mailbox (vms=0x4174bd60, vmu=0x41751e80) from /usr/lib/asterisk/modules/app_voicemail.so<br>#5 0x00002aaac1341b43 in vm_execmain (chan=0x2aaab42abe30, data=<value optimized out>)<br>
from /usr/lib/asterisk/modules/app_voicemail.so<br>#6 0x0000000000481e2d in pbx_extension_helper (c=0x2aaab42abe30, con=<value optimized out>,<br> context=0x2aaab42ac080 "staff-international", exten=0x2aaab42ac0d0 "*97", priority=106, label=<value optimized out>,<br>
callerid=0xbff51d0 "1369", action=E_SPAWN) at pbx.c:537<br>#7 0x0000000000483b66 in __ast_pbx_run (c=0x2aaab42abe30) at pbx.c:2317<br>#8 0x0000000000484849 in pbx_thread (data=0x322b663b40) at pbx.c:2621<br>
#9 0x00000000004aef5c in dummy_start (data=<value optimized out>) at utils.c:912<br>#10 0x000000322b006307 in start_thread () from /lib64/libpthread.so.0<br>#11 0x000000322a4d1ded in clone () from /lib64/libc.so.6<br>
<br>-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
<b>(gdb)bt full<br></b><br>#0 0x000000322b417649 in SQLFreeEnv () from /usr/lib64/libodbc.so.1<br>#1 0x000000322b417b5c in SQLFreeHandle () from /usr/lib64/libodbc.so.1<br>#2 0x00002aaac132ccdd in message_exists (dir=<value optimized out>, msgnum=<value optimized out>)<br>
from /usr/lib/asterisk/modules/app_voicemail.so<br>#3 0x00002aaac132dab2 in save_to_folder (vmu=0x41751e80, vms=<value optimized out>, msg=0, box=<value optimized out>)<br> from /usr/lib/asterisk/modules/app_voicemail.so<br>
#4 0x00002aaac132dc77 in close_mailbox (vms=0x4174bd60, vmu=0x41751e80) from /usr/lib/asterisk/modules/app_voicemail.so<br>#5 0x00002aaac1341b43 in vm_execmain (chan=0x2aaab42abe30, data=<value optimized out>)<br>
from /usr/lib/asterisk/modules/app_voicemail.so<br>#6 0x0000000000481e2d in pbx_extension_helper (c=0x2aaab42abe30, con=<value optimized out>,<br> context=0x2aaab42ac080 "staff-international", exten=0x2aaab42ac0d0 "*97", priority=106, label=<value optimized out>,<br>
callerid=0xbff51d0 "1369", action=E_SPAWN) at pbx.c:537<br>#7 0x0000000000483b66 in __ast_pbx_run (c=0x2aaab42abe30) at pbx.c:2317<br>#8 0x0000000000484849 in pbx_thread (data=0x322b663b40) at pbx.c:2621<br>
#9 0x00000000004aef5c in dummy_start (data=<value optimized out>) at utils.c:912<br>#10 0x000000322b006307 in start_thread () from /lib64/libpthread.so.0<br>#11 0x000000322a4d1ded in clone () from /lib64/libc.so.6<br>
(gdb) bt full<br>#0 0x000000322b417649 in SQLFreeEnv () from /usr/lib64/libodbc.so.1<br>No symbol table info available.<br>#1 0x000000322b417b5c in SQLFreeHandle () from /usr/lib64/libodbc.so.1<br>No symbol table info available.<br>
#2 0x00002aaac132ccdd in message_exists (dir=<value optimized out>, msgnum=<value optimized out>)<br> from /usr/lib/asterisk/modules/app_voicemail.so<br> x = 1<br> stmt = (SQLHSTMT) 0xbf45620<br>
sql = "SELECT COUNT(*) FROM voicemessages WHERE dir=? AND msgnum=?\000\000\000\000\000`}tA\000\000\000\000\225-N\000\000\000\000\000(\000\000\0000\000\000\000ТtA\000\000\000\000à¡tA\000\000\000\000\032\224F*2\000\000\000\001\200û\000\000\000\000Ø\226#\f\000\000\000\000Ø\226#\f\000\000\000\000Ø\226#\f\000\000\000\000Ø\226#\f\000\000\000\000\003\227#\f\000\000\000\000\212\227#\f\000\000\000\000Ø\226#\f\000\000\000\000\212\227#\f", '\0' <repeats 52 times>, "¨þH*2\000\000\000@Þ"...<br>
rowdata = "1\000k/voicemail/admin/"<br> msgnums = "31\000\000\000\000\000\000¦-N\000\000\000\000\000/var"<br> argv = {0x41748c10 "/var/spool/asterisk/voicemail/admin/1369/Delete", 0x41748b70 "31"}<br>
gps = {sql = 0x41747b50 "SELECT COUNT(*) FROM voicemessages WHERE dir=? AND msgnum=?", argc = 2, argv = 0x41748bb0}<br> obj = (struct odbc_obj *) 0xbc0a860<br> __PRETTY_FUNCTION__ = "message_exists"<br>
#3 0x00002aaac132dab2 in save_to_folder (vmu=0x41751e80, vms=<value optimized out>, msg=0, box=<value optimized out>)<br> from /usr/lib/asterisk/modules/app_voicemail.so<br> dir = 0x4174be50 "/var/spool/asterisk/voicemail/admin/1369/INBOX"<br>
username = 0x4174bdb0 "1369"<br> context = <value optimized out><br> sfn = "/var/spool/asterisk/voicemail/admin/1369/INBOX/msg0000\000\000°tA\000\000\000\000æ®tA\000\000\000\000\006¯tA\000\000\000\000À®tA\000\000\000\000\020í\004\f\000\000\000\000Í\000\024\003[\000\027ÿB\000P\000ìÿóÿ·ÿº\000\003\000a\000\001\000ýÿËÿÕÿ\016\000@\000e\000ôÿ\231\000\\\000\004\000\002\000éÿÈÿ$\000¯\000U\000;\000¤ÿ»ÿ.\000Ûÿ·ÿ»ÿkÿ\231ÿüÿ½þ\214þ\033ÿ6ÿ¶þ'\000\201\0003ÿÍ\000\024\003\203\000\027ÿB\000"...<br>
dfn = "/var/spool/asterisk/voicemail/admin/1369/Delete/msg0031\000æ\224ÿ\v\000\000\000\000è\224ÿ\v\000\000\000\000ê\224ÿ\v\000\000\000\000ì\224ÿ\v\000\000\000\000î\224ÿ\v\000\000\000\000ð\224ÿ\v\000\000\000\000ò\224ÿ\v\000\000\000\0003\2133[Ì,h& \237\a´ª*\000\0000¾*´ª*\000\000\000\000\000\000\000\000\000\000Ð6#\f\000\000\000\000\b(,\f\000\000\000\000\b(,\f\000\000\000\000\037½§¾ª*\000\000.\237tA\000\000\000\000iú+¿ª*\000\000P³)´ª*\000\000"...<br>
ddir = "/var/spool/asterisk/voicemail/admin/1369/Delete\000@\000\000\000\000\000\000\000\0371D*2\000\000\000°\222tA\000\000\000\000DÞF*2\000\000\000Ð\215tA\000\000\000\0000\223tA\000\000\000\000LVN\000\000\000\000\000LVN\000\000\000\000\000ð·tA\000\000\000\000JVN\000\000\000\000\000\000\223tA\000\000\000\000\002\000\000\000\000\000\000\000\020\216tA\000\000\000\000\000\000\000\000@", '\0' <repeats 11 times>, "ÿÿÿÿÿÿÿÿKVN\000\000\000\000\000JVN", '\0' <repeats 13 times>, "¸\221tA"...<br>
x = 31<br> __PRETTY_FUNCTION__ = "save_to_folder"<br>#4 0x00002aaac132dc77 in close_mailbox (vms=0x4174bd60, vmu=0x41751e80) from /usr/lib/asterisk/modules/app_voicemail.so<br> x = 0<br> res = <value optimized out><br>
__PRETTY_FUNCTION__ = "close_mailbox"<br>#5 0x00002aaac1341b43 in vm_execmain (chan=0x2aaab42abe30, data=<value optimized out>)<br> from /usr/lib/asterisk/modules/app_voicemail.so<br> opts = {0xbe5a108 "VoiceMailMain", 0x1b <Address 0x1b out of bounds>}<br>
---Type <return> to continue, or q <return> to quit---<br> args = {argc = 1, argv = 0x41752928, argv0 = 0x4174bcc0 "1369", argv1 = 0x0}<br> res = -1<br> cmd = 0<br> valid = 1<br>
u = (struct ast_module_user *) 0xbfcfcf0<br> prefixstr = '\0' <repeats 79 times><br> ext_context = '\0' <repeats 255 times><br> useadsi = 0<br> skipuser = 1098195280<br>
vms = {curbox = "INBOX", '\0' <repeats 74 times>, username = "1369", '\0' <repeats 75 times>,<br> context = '\0' <repeats 79 times>, curdir = "/var/spool/asterisk/voicemail/admin/1369/INBOX", '\0' <repeats 4049 times>,<br>
vmbox = "vm-INBOX", '\0' <repeats 4087 times>,<br> fn = "/var/spool/asterisk/voicemail/admin/1369/INBOX/msg0000", '\0' <repeats 4041 times>,<br> fn2 = "/var/spool/asterisk/voicemail/admin/1369/INBOX/msg0000", '\0' <repeats 4041 times>, deleted = 0xbf44770,<br>
heard = 0xc16d6a0, curmsg = -1, lastmsg = 0, newmessages = 0, oldmessages = 23, starting = 0, repeats = 0}<br> vmu = (struct ast_vm_user *) 0x41751e80<br> vmus = {context = "admin", '\0' <repeats 74 times>, mailbox = "1369", '\0' <repeats 75 times>,<br>
password = "1234", '\0' <repeats 75 times>, fullname = "HR Temp", '\0' <repeats 72 times>,<br> email = '\0' <repeats 79 times>, pager = '\0' <repeats 79 times>, serveremail = '\0' <repeats 79 times>,<br>
mailcmd = '\0' <repeats 159 times>, language = '\0' <repeats 19 times>, zonetag = '\0' <repeats 79 times>,<br> callback = '\0' <repeats 79 times>, dialout = '\0' <repeats 79 times>, uniqueid = '\0' <repeats 79 times>,<br>
exit = '\0' <repeats 79 times>, attachfmt = '\0' <repeats 19 times>, flags = 608, saydurationm = 2, maxmsg = 100,<br> volgain = 0, list = {next = 0x0}}<br> context = 0x4174bcc5 "admin"<br>
silentexit = 0<br> flags = {flags = 0}<br> record_gain = 0 '\0'<br> play_auto = 0<br> play_folder = 0<br> __PRETTY_FUNCTION__ = "vm_execmain"<br>#6 0x0000000000481e2d in pbx_extension_helper (c=0x2aaab42abe30, con=<value optimized out>,<br>
context=0x2aaab42ac080 "staff-international", exten=0x2aaab42ac0d0 "*97", priority=106, label=<value optimized out>,<br> callerid=0xbff51d0 "1369", action=E_SPAWN) at pbx.c:537<br>
e = <value optimized out><br> app = (struct ast_app *) 0xbe5a0e0<br> res = <value optimized out><br> q = {incstack = {0xc46cc48 "", 0xc3467e8 "", 0xc475fd8 "", 0xc34a768 "", 0xbddfad8 "", 0xc316828 "broadcast",<br>
0xc360928 "", 0xc361028 "", 0xc3619a8 "", 0xc362178 "", 0xc362ae8 "", 0xc362fb8 "", 0xc363e48 "", 0xc348338 "",<br> 0xc349a08 "", 0xc4f4478 "", 0x0 <repeats 112 times>}, stacklen = 16, status = 5, swo = 0x0, data = 0x0,<br>
foundcontext = 0xc46d423 ""}<br> passdata = "1369@admin", '\0' <repeats 8181 times><br> matching_action = <value optimized out><br> __PRETTY_FUNCTION__ = "pbx_extension_helper"<br>
#7 0x0000000000483b66 in __ast_pbx_run (c=0x2aaab42abe30) at pbx.c:2317<br>---Type <return> to continue, or q <return> to quit---<br> waittime = <value optimized out><br> dst_exten = "\000\000\000\000\000\000\000\000HpuA", '\0' <repeats 20 times>, "ppuA", '\0' <repeats 28 times>, "\030", '\0' <repeats 15 times>, "PpuA\000\000\000\000XpuA\000\000\000\000`puA\000\000\000\000hpuA\000\000\000\000xpuA", '\0' <repeats 12 times>, "\200puA\000\000\000\000$Ç\000+2", '\0' <repeats 27 times>, " ét*2", '\0' <repeats 11 times>, "@/n\f\000\000\000\000À\000\002\000\000\000\000\000\030\000\000\000\000\000\000\000 ét*2\000\000\000³+G*2", '\0' <repeats 11 times>, "°Õþ\v\000\000\000\000PD\"´ª*\000\000\000\000\000\000\000\000"...<br>
pos = 1098215488<br> digit = 0<br> found = 1<br> res = 0<br> error = <value optimized out><br> __PRETTY_FUNCTION__ = "__ast_pbx_run"<br>#8 0x0000000000484849 in pbx_thread (data=0x322b663b40) at pbx.c:2621<br>
No locals.<br>#9 0x00000000004aef5c in dummy_start (data=<value optimized out>) at utils.c:912<br> __cancel_buf = {__cancel_jmp_buf = {{__cancel_jmp_buf = {46912654951504, 1544153348009866706, 0, 1098217792,<br>
4910848, 4096, 1544153346949956930, 1544153348004993680}, __mask_was_saved = 0}}, __pad = {0x417571d0, 0x0,<br> 0x322a749880, 0x322a749888}}<br> __cancel_arg = (void *) 0x41757940<br> not_first_call = <value optimized out><br>
ret = <value optimized out><br>#10 0x000000322b006307 in start_thread () from /lib64/libpthread.so.0<br>No symbol table info available.<br>#11 0x000000322a4d1ded in clone () from /lib64/libc.so.6<br>No symbol table info available.<br>
<br><br>
<br>
Can any one please help me to trace down the issue using the core dump.
<br>
<br>
Thanks in advance.
<br>
<br>
vimurli</span><br clear="all"><br>-- <br>always with smile<br>