<div>K, it crashed again. Here is the Backtrace.</div><div><br></div><div>-Chris</div><div><br></div><div><br></div><div>(gdb) bt</div><div>#0 0x00000008016546cf in SQLFreeEnv () from /usr/local/lib/libodbc.so.1</div><div>
#1 0x0000000801654dec in SQLFreeHandle () from /usr/local/lib/libodbc.so.1</div><div>#2 0x00000008076259af in acf_odbc_write () from /usr/local/lib/asterisk/modules/func_odbc.so</div><div>#3 0x000000000046bbeb in pbx_builtin_setvar_helper (chan=0x80672a000, </div>
<div> name=0x7fffff2311e0 "ODBC_WRITE_LOCAL(insert into call_log (clid,phone_number_id,uniqueid,duration,action,arrangement,date) values ('18453562190','7189775916','1266467353.1659','0','Original Call 7189775916','1',now()))", value=0x7fffff2312a7 "confirmed") at pbx.c:5884</div>
<div>#4 0x000000000046bfb2 in pbx_builtin_setvar (chan=0x80672a000, data=Variable "data" is not available.</div><div>) at pbx.c:5957</div><div>#5 0x0000000000467e2a in pbx_exec (c=0x80672a000, app=0x8010500d0, data=0x7fffff233470) at pbx.c:536</div>
<div>#6 0x000000000046a9b5 in pbx_extension_helper (c=0x80672a000, con=0x7fffff231470, context=0x80672a230 "macro-podlinez-stat", exten=0x80672a280 "s", priority=1, label=Variable "label" is not available.</div>
<div>) at pbx.c:1863</div><div>#7 0x000000000046ae03 in ast_spawn_extension (c=Variable "c" is not available.</div><div>) at pbx.c:2283</div><div>#8 0x0000000803bc8a0b in _macro_exec () from /usr/local/lib/asterisk/modules/app_macro.so</div>
<div>#9 0x0000000000467e2a in pbx_exec (c=0x80672a000, app=0x8026760a0, data=0x7fffff2388e0) at pbx.c:536</div><div>#10 0x000000000046a9b5 in pbx_extension_helper (c=0x80672a000, con=0x7fffff2368e0, context=0x80672a230 "macro-podlinez-stat", exten=0x80672a280 "s", priority=4, label=Variable "label" is not available.</div>
<div>) at pbx.c:1863</div><div>#11 0x000000000046ae03 in ast_spawn_extension (c=Variable "c" is not available.</div><div>) at pbx.c:2283</div><div>#12 0x000000000046e021 in __ast_pbx_run (c=0x80672a000) at pbx.c:2373</div>
<div>#13 0x000000000046f4d9 in pbx_thread (data=Variable "data" is not available.</div><div>) at pbx.c:2599</div><div>#14 0x00000000004968b3 in dummy_start (data=Variable "data" is not available.</div>
<div>) at utils.c:856</div><div>#15 0x0000000800c054d1 in pthread_getprio () from /lib/libthr.so.3</div><div>#16 0x00007fffff1bf000 in ?? ()</div><div>Cannot access memory at address 0x7fffff23b000</div><div><br></div><div>
<br></div><div>(gdb) bt full</div><div>#0 0x00000008016546cf in SQLFreeEnv () from /usr/local/lib/libodbc.so.1</div><div>No symbol table info available.</div><div>#1 0x0000000801654dec in SQLFreeHandle () from /usr/local/lib/libodbc.so.1</div>
<div>No symbol table info available.</div><div>#2 0x00000008076259af in acf_odbc_write () from /usr/local/lib/asterisk/modules/func_odbc.so</div><div>No symbol table info available.</div><div>#3 0x000000000046bbeb in pbx_builtin_setvar_helper (chan=0x80672a000, </div>
<div> name=0x7fffff2311e0 "ODBC_WRITE_LOCAL(insert into call_log (clid,phone_number_id,uniqueid,duration,action,arrangement,date) values ('18453562190','7189775916','1266467353.1659','0','Original Call 7189775916','1',now()))", value=0x7fffff2312a7 "confirmed") at pbx.c:5884</div>
<div> curelm = Variable "curelm" is not available.</div><div>(gdb) </div><div><br></div><div><br></div><div><br></div><br><div class="gmail_quote">On Mon, Feb 15, 2010 at 9:52 PM, Max Khon <span dir="ltr"><<a href="mailto:fjoe@samodelkin.net">fjoe@samodelkin.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hello, Chris!<br><br><div class="gmail_quote"><div><div></div><div class="h5">On Tue, Feb 16, 2010 at 5:12 AM, Chris Coleman <span dir="ltr"><<a href="mailto:chrisc@vmunix.com" target="_blank">chrisc@vmunix.com</a>></span> wrote:<br>
<div> </div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse"><div>I'm running Asterisk on FBSD 7.2 using only SIP incoming DIDs. I'm also using unixODBC to connect to a postgres DB. I'm running asterisk from ports.</div>
<div><br></div><div>Here is my system info:</div><div><br></div><div>Asterisk 1.4.26.2, Copyright (C) 1999 - 2008 Digium, Inc. and others.</div><div><br></div><div><div>FreeBSD kvm10.podlinez.lan 7.2-RELEASE-p4 FreeBSD 7.2-RELEASE-p4 #0: Fri Oct 2 08:22:32 UTC 2009 root@amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC amd64</div>
<div><br></div><div><br></div><div>I'm getting very frequent core dumps, so I've rebuilt asterisk with -g3 to enable debug. I've also ran it with valgrind and attached it to the e-mail.</div></div><div><br></div>
Here is the Summary:<div><br></div><div><div>==30746== definitely lost: 28,597 bytes in 75 blocks</div><div>==30746== indirectly lost: 143,559 bytes in 308 blocks</div><div>==30746== possibly lost: 6,119,992 bytes in 98,335 blocks</div>
<div>==30746== still reachable: 3,169,594 bytes in 37,091 blocks</div><div>==30746== suppressed: 0 bytes in 0 blocks</div><div><br></div><div>It seems like it has a memory leak that is causing the problem.</div>
<div><br></div><div>In my experience, it dies trying to do a DB call.</div></div></span></blockquote></div></div><div><br>The leak does not seem to be big enough to cause any problems. Do you have a core files and can you show the stack trace?<br>
<br>Max <br><br></div></div>
</blockquote></div><br><br clear="all"><br>-- <br>Chris Coleman -- http://Podlinez.com<br>