*CLI> [New Thread 0x407a0950 (LWP 5628)]
[New Thread 0x421bc950 (LWP 5629)]
[2010-05-11 12:38:41] WARNING[5628]: res_odbc.c:106 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: [MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-24+lenny2-log]FUNCTION gntel_app_live_test.ASTERISK_ESCAPE does not exist (114)
[2010-05-11 12:38:41] WARNING[5628]: res_odbc.c:114 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect...

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x420c4950 (LWP 5615)]
0x00007f7db60e8ced in SQLDescribeCol () from /usr/lib/libodbc.so.1
(gdb) back
#0  0x00007f7db60e8ced in SQLDescribeCol () from /usr/lib/libodbc.so.1
#1  0x00007f7db44d2535 in realtime_odbc (database=<value optimized out>, table=<value optimized out>, ap=<value optimized out>) at res_config_odbc.c:181
#2  0x000000000044d304 in ast_load_realtime (family=<value optimized out>) at config.c:1435
#3  0x00007f7da14f37a0 in realtime_peer (newpeername=0x420c3b80 "040055001", sin=0x0, devstate_only=1) at chan_sip.c:2660
#4  0x00007f7da14f9527 in sip_devicestate (data=<value optimized out>) at chan_sip.c:17270
#5  0x000000000045291a in ast_device_state (device=0x9dc3f8 "SIP/040055001") at devicestate.c:170
#6  0x0000000000452d7e in do_devstate_changes (data=<value optimized out>) at devicestate.c:285
#7  0x00000000004b6edc in dummy_start (data=<value optimized out>) at utils.c:856
#8  0x00007f7dbb105fc7 in start_thread () from /lib/libpthread.so.0
#9  0x00007f7db81485ad in clone () from /lib/libc.so.6
#10 0x0000000000000000 in ?? ()
(gdb) info threads
  12 Thread 0x421bc950 (LWP 5629)  0x00007f7db813fb66 in poll () from /lib/libc.so.6
  11 Thread 0x407a0950 (LWP 5628)  0x00007f7dbb10c384 in __lll_lock_wait () from /lib/libpthread.so.0
  10 Thread 0x4172b950 (LWP 5625)  0x00007f7db813fb66 in poll () from /lib/libc.so.6
  9 Thread 0x40c8e950 (LWP 5624)  0x00007f7dbb10d0e1 in nanosleep () from /lib/libpthread.so.0
  8 Thread 0x413bc950 (LWP 5623)  0x00007f7db813fb66 in poll () from /lib/libc.so.6
  7 Thread 0x4120d950 (LWP 5620)  0x00007f7db8141ce2 in select () from /lib/libc.so.6
  6 Thread 0x40edf950 (LWP 5619)  0x00007f7dbb109d29 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  5 Thread 0x42140950 (LWP 5618)  0x00007f7db813fb66 in poll () from /lib/libc.so.6
* 4 Thread 0x420c4950 (LWP 5615)  0x00007f7db60e8ced in SQLDescribeCol () from /usr/lib/libodbc.so.1
  2 Thread 0x41847950 (LWP 5613)  0x00007f7db813fb66 in poll () from /lib/libc.so.6
  1 Thread 0x7f7dbb8226f0 (LWP 5610)  0x00007f7dbb10c7db in read () from /lib/libpthread.so.0
(gdb) thread 4
[Switching to thread 4 (Thread 0x420c4950 (LWP 5615))]#0  0x00007f7db60e8ced in SQLDescribeCol () from /usr/lib/libodbc.so.1
(gdb) bt full
#0  0x00007f7db60e8ced in SQLDescribeCol () from /usr/lib/libodbc.so.1
No symbol table info available.
#1  0x00007f7db44d2535 in realtime_odbc (database=<value optimized out>, table=<value optimized out>, ap=<value optimized out>) at res_config_odbc.c:181
	obj = (struct odbc_obj *) 0x9a2820
	stmt = (SQLHSTMT) 0x9d9f40
	sql = "SELECT * FROM asterisk_sip_peers WHERE name = ?\000AND host = ?", '\0' <repeats 963 times>
	coltitle = "ipaddr", '\0' <repeats 249 times>
	rowdata = "\0001.194.225.4\0000", '\0' <repeats 2033 times>
	op = 0x0
	newparam = <value optimized out>
	stringp = 0x0
	collen = 256
	res = <value optimized out>
	x = <value optimized out>
	var = (struct ast_variable *) 0x9d9560
	prev = (struct ast_variable *) 0x9e1800
	colsize = 45
	colcount = 24
	datatype = 12
	decimaldigits = 0
	nullable = 0
	indicator = 12
	aq = {{gp_offset = 32, fp_offset = 48, overflow_arg_area = 0x420c36f0, reg_save_area = 0x420c3620}}
	cps = {sql = 0x420c2e50 "SELECT * FROM asterisk_sip_peers WHERE name = ?", extra = 0x0, ap = {{gp_offset = 8, fp_offset = 48, overflow_arg_area = 0x420c36f0, reg_save_area = 0x420c3620}}}
	__PRETTY_FUNCTION__ = "realtime_odbc"
#2  0x000000000044d304 in ast_load_realtime (family=<value optimized out>) at config.c:1435
	eng = <value optimized out>
	db = "pi_database", '\0' <repeats 244 times>
	table = "asterisk_sip_peers", '\0' <repeats 237 times>
	res = <value optimized out>
	ap = {{gp_offset = 8, fp_offset = 48, overflow_arg_area = 0x420c36f0, reg_save_area = 0x420c3620}}
#3  0x00007f7da14f37a0 in realtime_peer (newpeername=0x420c3b80 "040055001", sin=0x0, devstate_only=1) at chan_sip.c:2660
	peer = <value optimized out>
	var = (struct ast_variable *) 0x0
	peerlist = <value optimized out>
	tmp = <value optimized out>
	flags = {flags = 0}
	iabuf = <value optimized out>
	portstring = "\000@\fB\000"
	insecure = <value optimized out>
	cat = <value optimized out>
	__PRETTY_FUNCTION__ = "realtime_peer"
#4  0x00007f7da14f9527 in sip_devicestate (data=<value optimized out>) at chan_sip.c:17270
	host = 0x420c3b80 "040055001"
	hp = <value optimized out>
	ahp = {hp = {h_name = 0x0, h_aliases = 0x0, h_addrtype = 0, h_length = 0, h_addr_list = 0x0}, 
  buf = '\0' <repeats 456 times>, "��r�}\177\000\000\000\000\000\000\000\000\000\000�$\232\000\000\000\000\000\003\000\000\000\000\000\000\000$\000\000\000\000\000\000\000�r\210�\000\000\000\000d�r�}\177\000\000T�\017�}\177\000\000\004\000\000\000\000\000\000\000�!�\003\000\000\000\000�=\fB\000\000\000\000x?\fB\000\000\000\000��\017�}\177\000\000\000\000\000\000\000\000\000\000\030T\202�}\177\000\000\000 \223�}\177\000\000W�@\000\000\000\000\000(\033\020�}\177\000\000PH@\000\000\000\000\000\000\000\000\000\005\000\000\000�\000\000\000\001", '\0' <repeats 11 times>, "X�\223�}\177\000\000�?\fB\000\000\000"...}
	p = <value optimized out>
	res = <value optimized out>
	__PRETTY_FUNCTION__ = "sip_devicestate"
#5  0x000000000045291a in ast_device_state (device=0x9dc3f8 "SIP/040055001") at devicestate.c:170
	chan_tech = <value optimized out>
	res = 4
	tech = <value optimized out>
	__PRETTY_FUNCTION__ = "ast_device_state"
#6  0x0000000000452d7e in do_devstate_changes (data=<value optimized out>) at devicestate.c:285
No locals.
#7  0x00000000004b6edc in dummy_start (data=<value optimized out>) at utils.c:856
	__cancel_buf = {__cancel_jmp_buf = {{__cancel_jmp_buf = {10299776, -8218211444059800263, 140736474638880, 140177986051840, 0, 4096, -8218075209859334855, -8218210957478331079}, __mask_was_saved = 0}}, __pad = {0x420c41d0, 0x0, 
    0x0, 0x0}}
---Type <return> to continue, or q <return> to quit---
	not_first_call = <value optimized out>
	ret = <value optimized out>
#8  0x00007f7dbb105fc7 in start_thread () from /lib/libpthread.so.0
No symbol table info available.
#9  0x00007f7db81485ad in clone () from /lib/libc.so.6
No symbol table info available.
#10 0x0000000000000000 in ?? ()
No symbol table info available.
(gdb) thread 11
[Switching to thread 11 (Thread 0x407a0950 (LWP 5628))]#0  0x00007f7dbb10c384 in __lll_lock_wait () from /lib/libpthread.so.0
(gdb) bt full
#0  0x00007f7dbb10c384 in __lll_lock_wait () from /lib/libpthread.so.0
No symbol table info available.
#1  0x00007f7dbb107bf0 in _L_lock_102 () from /lib/libpthread.so.0
No symbol table info available.
#2  0x00007f7dbb1074fe in pthread_mutex_lock () from /lib/libpthread.so.0
No symbol table info available.
#3  0x00007f7db60ee76f in ?? () from /usr/lib/libodbc.so.1
No symbol table info available.
#4  0x00007f7db60eedec in SQLFreeHandle () from /usr/lib/libodbc.so.1
No symbol table info available.
#5  0x00007f7db63355a2 in odbc_obj_disconnect (obj=0x9a2820) at res_odbc.c:509
	res = <value optimized out>
	err = <value optimized out>
	mlen = 0
	msg = "P\tz@\000\000\000\000�{\020�}\177\000\000�3�K\000\000\000\000`b\023�}\177\000\000\003\000\000\000\000\000\000\000�\200\031�}\177\000\000H�\020�}\177\000\000\000\000\000\000\000\000\000\000�\217\020�}\177\000\000 \000\000�}\177\000\0005610\000\000\000\000 \000\000�}\177\000\000\000\000\000\000\000\000\000\0000\207\031�}\177\000\000\001\000\000\000\000\000\000\000 \000\000�}\177\000\000�\200\031�}\177\000\000P2\232\000\000\000\000\000\003", '\0' <repeats 15 times>, "�\200\031�}\177\000\000P2\232", '\0' <repeats 13 times>, "�\200\031�}\177\000\000P2\232\000\000\000\000"
	stat = "�\200\031�}\177\000\000��"
	__PRETTY_FUNCTION__ = "odbc_obj_disconnect"
#6  0x00007f7db63371e2 in ast_odbc_prepare_and_execute (obj=0x9a2820, prepare_cb=0x7f7daaf53400 <generic_prepare>, data=0x40797c20) at res_odbc.c:124
	res = -1
	nativeerror = 1305
	numfields = 1
	diagbytes = 114
	state = "HY000\000\000\000\000"
	diagnostic = "[MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-24+lenny2-log]FUNCTION gntel_app_live_test.ASTERISK_ESCAPE does not exist\000@\000\000\000\000�\225\235\000\000\000\000\0000N\003�}\177\000\000Cm\f�}\177\000\000 \000\000\0000\000\000\000�{y@\000\000\000\000\000{y@\000\000\000\000�RH\000\000\000\000\000�\200\031�}\177\000\000a?\000\000\000\000\000\000�\210y@\000\000\000\000"...
	stmt = (SQLHSTMT) 0x7f7db01980b0
	__PRETTY_FUNCTION__ = "ast_odbc_prepare_and_execute"
#7  0x00007f7daaf5368f in acf_odbc_read (chan=0x9d95b0, cmd=<value optimized out>, s=0x40798430 "", buf=0x407988d0 "", len=4096) at func_odbc.c:278
	obj = (struct odbc_obj *) 0x9a2820
	query = <value optimized out>
	sql = "SELECT customercode, enable_callerid, ASTERISK_ESCAPE(callerid_name), callerid_num, call_permissions, spy_permissions, emergency_region FROM asterisk_account_settings_by_account WHERE accountcode = '0"...
	varname = "ARG1\000\000\000\000�\210y@\000\000"
	res = <value optimized out>
	x = 1
	buflen = <value optimized out>
	bogus_chan = 0
	args = {argc = 1, argv = 0x40798428, field = {0x407998f4 "040055001", 0x0 <repeats 99 times>}}
	stmt = <value optimized out>
	colcount = 0
	indicator = <value optimized out>
	__PRETTY_FUNCTION__ = "acf_odbc_read"
#8  0x0000000000485578 in pbx_substitute_variables_helper_full (c=0x9d95b0, headp=0x9d99e8, cp1=<value optimized out>, cp2=0x4079da3b "", count=8132) at pbx.c:1691
	cp4 = 0x7f7d9f017b20 "��\021�}\177"
	whereweare = 0x7f7db00fdf81 ""
	length = <value optimized out>
	offset = 0
	offset2 = 2147483647
	isfunction = 1
	workspace = 0x407988d0 ""
	ltmp = 0x407998e0 "PI_ACCOUNT_SETTINGS"
	var = 0x4079a8f0 "PI_ACCOUNT_SETTINGS(${accountcode})"
	nextvar = <value optimized out>
	nextexp = <value optimized out>
	vars = 0x407998e0 "PI_ACCOUNT_SETTINGS"
	vare = 0x7f7db00fdf5d "PI_ACCOUNT_SETTINGS(${accountcode})}"
	pos = <value optimized out>
	brackets = <value optimized out>
	needsub = 1
	len = <value optimized out>
	__PRETTY_FUNCTION__ = "pbx_substitute_variables_helper_full"
---Type <return> to continue, or q <return> to quit---
#9  0x00000000004875cf in pbx_extension_helper (c=0x9d95b0, con=<value optimized out>, context=0x9d9800 "pi_phone_account_cont", exten=0x9d9850 "333", priority=2, label=0x0, callerid=0x9dc530 "040055001", action=E_SPAWN) at pbx.c:1786
	e = <value optimized out>
	app = (struct ast_app *) 0x7f7db00013f0
	res = <value optimized out>
	q = {incstack = {0x0 <repeats 128 times>}, stacklen = 0, status = 5, swo = 0x0, data = 0x0, foundcontext = 0x9d9800 "pi_phone_account_cont"}
	passdata = "ARRAY(customercode|_|CALLERID(name)|_|_|spy_permissions|_)=", '\0' <repeats 8132 times>
	matching_action = <value optimized out>
	__PRETTY_FUNCTION__ = "pbx_extension_helper"
#10 0x000000000048856a in __ast_pbx_run (c=0x9d95b0) at pbx.c:2300
	dst_exten = '\0' <repeats 120 times>, "@\000\000\000\000\000\000\000\030", '\0' <repeats 43 times>, "\002", '\0' <repeats 11 times>, "�y<�}\177\000\000\000\000\000\000\000\000\000\000\030\000\000\000\000\000\000\000\220\031\236\000\000\000\000\000q&\000\000\000\000\000\000\000\020\000\000\000\000\000\000 \224\235\000\000\000\000\000��\022�}\177\000\000\220�;A\000\000\000"
	pos = -1156555008
	digit = 1081737392
	found = 1
	res = 0
	error = <value optimized out>
	emc = <value optimized out>
	__PRETTY_FUNCTION__ = "__ast_pbx_run"
#11 0x0000000000489ea9 in pbx_thread (data=0x7f7db6333d60) at pbx.c:2621
No locals.
#12 0x00000000004b6edc in dummy_start (data=<value optimized out>) at utils.c:856
	__cancel_buf = {__cancel_jmp_buf = {{__cancel_jmp_buf = {140177801674672, -8218211444059800263, 1094427024, 140177986051840, 1081739600, 4096, -8218070070930965191, -8218210957478331079}, __mask_was_saved = 0}}, __pad = {
    0x407a01d0, 0x0, 0x0, 0x0}}
	not_first_call = <value optimized out>
	ret = <value optimized out>
#13 0x00007f7dbb105fc7 in start_thread () from /lib/libpthread.so.0
No symbol table info available.
#14 0x00007f7db81485ad in clone () from /lib/libc.so.6
No symbol table info available.
#15 0x0000000000000000 in ?? ()
No symbol table info available.