Toad World® Forums

Error in our production

We used the free edition on our production and DBA caught an error. He said:
“The job failed at that time. In normal condition there wouldn’t be problem with the proc, but executing from third party tool is not guaranteed sometimes.”

Here is the log from DB side:

01:00000:00138:2011/07/26 11:01:21.72 kernel Current process (0x5c3d0321) infected with signal 11 (SIGSEGV)
01:00000:00138:2011/07/26 11:01:21.72 kernel Address 0x00000000806301d0 (void OptGlobal::_GblSearchEngine(int*)+0x48),
siginfo (code, address) = (1, 0x0000000000000004)
01:00000:00138:2011/07/26 11:01:21.72 kernel Saved signal context address 0x0000010009d5f160
01:00000:00138:2011/07/26 11:01:21.72 kernel pc=0x00000000806301d0 npc=0x00000000806301d4
01:00000:00138:2011/07/26 11:01:21.72 kernel g0-g2 0x0000000000000000 0x0000000018180000 0x0000000000001807
01:00000:00138:2011/07/26 11:01:21.72 kernel g3-g5 0x0000010074ab6060 0x0000000000001800 0x0000000000007d54
01:00000:00138:2011/07/26 11:01:21.72 kernel g6-g7 0x0000000000000000 0xffffffff7eb00200
01:00000:00138:2011/07/26 11:01:21.72 kernel o0-o2 0x0000000000000000 0x0000000000000000 0x0000000000000001
01:00000:00138:2011/07/26 11:01:21.72 kernel o3-o5 0x0000010074ab66e0 0x0000000000000000 0x0000010074ac56e0
01:00000:00138:2011/07/26 11:01:21.72 kernel o6-o7 0x0000010009d5ed41 0x0000000000000000
01:00000:00138:2011/07/26 11:01:21.72 kernel l0-l2 0x0000010043030ec8 0x0000010074abc978 0x00000000000095c8
01:00000:00138:2011/07/26 11:01:21.72 kernel l3-l5 0x00000000826d4000 0x000001004303a490 0x0000010043030ec8
01:00000:00138:2011/07/26 11:01:21.72 kernel l6-l7 0x000001004303a490 0x0000000000007c00
01:00000:00138:2011/07/26 11:01:21.72 kernel i0-i2 0x0000010074ac1170 0x0000010009d5fe5c 0x0000010043030ec8
01:00000:00138:2011/07/26 11:01:21.72 kernel i3-i5 0x00000000826d4000 0x0000000000009400 0x0000010074ac4d48
01:00000:00138:2011/07/26 11:01:21.72 kernel i6-i7 0x0000010009d5f321 0x000000008062e7f0
01:00000:00138:2011/07/26 11:01:21.72 kernel ************************************
01:00000:00138:2011/07/26 11:01:21.72 kernel SQL causing error : select
TABLE_CATALOG=db_name(), – table_catalog
TABLE_SCHEMA=user_name(o.uid), – table_schema
TABLE_NAME=o.name, – table_name

01:00000:00138:2011/07/26 11:01:21.72 kernel ************************************
01:00000:00138:2011/07/26 11:01:21.72 server SQL Text: select TABLE_CATALOG=db_name(), – table_catalog
TABLE_SCHEMA=user_name(o.uid), – table_schema
TABLE_NAME=o.name, – table_name
INDEX_CATALOG=db_name(), – index_catalog
INDEX_SCHEMA=o.name, – index_schema
INDEX_NAME=x.name, – index_name
PRIMARY_KEY= case when x.status&2048 = 2048 then convert(bit,1) else convert(bit,0) end, – primary_key
‘UNIQUE’ = case when x.status&2 != 2 then convert(bit,0) else convert(bit,1) end, – uniqueval
‘CLUSTERED’
01:00000:00138:2011/07/26 11:01:21.72 server SQL Text: = case when x.status2&512 = 512 then convert(bit,1) else convert
(bit,1) end, – clusteredval
TYPE= case when x.indid > 1 then 4 when x.status2&512 = 512 then 1 else 1 end, – type
FILL_FACTOR=x.fill_factor, – fill_factor
INITIAL_SIZE=null, – initial_size
NULLS=4, – nulls
SORT_BOOKMARKS=convert(bit,0), – sort_bookmarks
AUTO_UPDATE=convert(bit,1), – auto_update
NULL_COLLATION=4, – null_collation
ORDINAL_POSITION=convert(int,colid), – ordinal_p
01:00000:00138:2011/07/26 11:01:21.72 server SQL Text: osition
COLUMN_NAME=INDEX_COL(‘dbo.CrTransRefObligInfoPatch’,indid,colid), – column name
COLUMN_GUID = convert(varchar(36), null), COLUMN_PROPID=null, – column propid
COLLATION=case when index_colorder(‘dbo.CrTransRefObligInfoPatch’,indid,colid) = ‘ASC’ then convert(smallint, 1) when in
dex_colorder(‘dbo.CrTransRefObligInfoPatch’,indid,colid) = ‘DESC’ then convert(smallint, 2) else convert(smallint, 0) en
d, – collation
CARDINALITY=case when x.ind
01:00000:00138:2011/07/26 11:01:21.72 server SQL Text: id > 1 then NULL else – rowcnt(x.doampg)
row_count(db_id(), x.id) end, – cardinality
PAGES=case when x.indid > 1 then NULL else – data_pgs(x.id,doampg)
data_pages(db_id(), x.id, case when x.indid = 1 then 0 else x.indid end) end, – pages
FILTER_CONDITION=null, – filter condition
INTEGRATED=convert(bit,1) – integrated
from sysindexes x, syscolumns c, sysobjects o where x.id = object_id(‘dbo.CrTransRefObligInfoPatch’) and x.id = o.id and
x.id
01:00000:00138:2011/07/26 11:01:21.72 server SQL Text: = c.id and c.colid < keycnt+(x.status&16)/16 and (x.indid > 0 a
nd x.indid < 255) and db_name() like ‘boss_prod’ and user_name(o.uid) like ‘dbo’ and (x.name like ‘%’ or x.name is null)
order by TABLE_CATALOG, TABLE_SCHEMA, INDEX_NAME, TYPE, TABLE_NAME
01:00000:00138:2011/07/26 11:01:21.72 kernel curdb = 5 tempdb = 2 pstat = 0x10000
01:00000:00138:2011/07/26 11:01:21.72 kernel lasterror = 0 preverror = 0 transtate = 3
01:00000:00138:2011/07/26 11:01:21.72 kernel curcmd = 269 program = Toad for Sybase
01:00000:00138:2011/07/26 11:01:21.72 kernel extended error information: hostname: TAG-IFENG login: dps_guest
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x0000000080f58cc0 pcstkwalk+0x24(0x0000010009d5de80, 0x0000010009d5bc
f8, 0x000000000000270f, 0x0000000000000002, 0x0000000000000000)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x0000000080f58b08 ucstkgentrace+0x1d0(0x0000010043030ec8, 0x000000000
0000002, 0x000000000000270f, 0x0000000000000000, 0x0000000000000000)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x0000000080ee3450 ucbacktrace+0xb4(0x0000000000000000, 0x000000000000
0001, 0x0000000000007c00, 0x0000010043030ec8, 0x00000100537e0b30)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x000000008059afdc terminate_process+0x1324(0x0000000000007710, 0xffff
ffffffffffff, 0x0000010043030ec8, 0x0000000000008000, 0x0000000081c31df8)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x0000000080f1cc2c kisignal+0x27c(0x0000000000000058, 0x0000010009d5f4
40, 0x0000010009d5f160, 0x000000005c3d0321, 0x0000000000000000)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x00000000806301d0 void OptGlobal::_GblSearchEngine(int*)+0x48(0x00000
10074ac1170, 0x0000010009d5fe5c, 0x0000010043030ec8, 0x00000000826d4000, 0x0000000000009400)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x000000008062e7f0 PopBaseOptGlobal::GblOptimize(int)+0x88(0x0000010
074ac1170, 0x0000010009d5fe5c, 0x0000000000009400, 0x00000000000826d4, 0x0000000000007c00)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x000000008062d304 Optimize+0xbc(0x0000010074abc978, 0x0000010074a8bb9
8, 0x0000010074ac1170, 0x0000010009d5fe5c, 0x0000010009d5fe58)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x0000000080c23424 s_compile_stmt+0x5a4(0x0000000000008c00, 0x00000000
00000000, 0x0000000000009400, 0x0000010043030ec8, 0x0000010074a89800)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x0000000080c212f4 s_compile+0x3c4(0x0000000000007800, 0x0000000081e65
f6c, 0x0000010043030ec8, 0x0000000000008000, 0x0000010074a22000)
01:00000:00138:2011/07/26 11:01:21.73 kernel [Handler pc: 0x0000000080c9f9b0 hdl_stack installed by the following funct
ion:-]
01:00000:00138:2011/07/26 11:01:21.73 kernel [Handler pc: 0x0000000080c50368 s_handle installed by the following functi
on:-]
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x00000000803c7cc8 _$o1cexkP0.sequencer+0x128(0x0000000000000000, 0x00
00000000007b58, 0x0000010043030ec8, 0x00000100430386c0, 0x0000000081e65f6c)
01:00000:00138:2011/07/26 11:01:21.73 kernel [Handler pc: 0x0000000080db70f8 intsql__handle installed by the following
function:-]
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x0000000080db6938 internal_sql+0x4b4(0x0000000000000001, 0x0000000000
000000, 0x0000010043030ec8, 0x0000000000000012, 0x0000000000009108)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x0000000080417694 _$o1cexoT0.s_execute+0x4894(0x0000000000000001, 0x0
000010043030ec8, 0x0000000000000000, 0x0000000000000000, 0x000000000000010d)
01:00000:00138:2011/07/26 11:01:21.73 kernel [Handler pc: 0x0000000080c9f9b0 hdl_stack installed by the following funct
ion:-]
01:00000:00138:2011/07/26 11:01:21.73 kernel [Handler pc: 0x0000000080c50368 s_handle installed by the following functi
on:-]
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x00000000803bf634 sequencer+0x254(0x0000000000007800, 0x0000000000000
002, 0xffffffffffffffff, 0x0000000000000000, 0x0000000082710000)
01:00000:00138:2011/07/26 11:01:21.73 kernel [Handler pc: 0x0000000080c9f9a0 hdl_backout installed by the following fun
ction:-]
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x00000000803be350 execproc+0x410(0x0000000000001000, 0x0000010074a229
c8, 0x00000000000092f0, 0x0000000000000000, 0x000001002a25db90)
01:00000:00138:2011/07/26 11:01:21.73 kernel [Handler pc: 0x0000000080beeacc execrpc_handle installed by the following
function:-]
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x00000000803a8f94 execrpc+0x23c(0x0000010074a229f0, 0x0000000081e65f6
c, 0x0000000081d2a928, 0x0000000000009000, 0x0000000000009400)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x00000000803c1aac tdsrecv_rpc+0xc(0x00000000000000e6, 0x0000010043030
ec8, 0x0000000000000000, 0x0000000000000027, 0x0000000000009800)
01:00000:00138:2011/07/26 11:01:21.73 kernel [Handler pc: 0x0000000080e78898 ut_handle installed by the following funct
ion:-]
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x00000000803bd5c4 _$o1cexjW0.conn_hdlr+0x4(0x000000000000003e, 0x0000
000000000000, 0x00000000827a7800, 0xffffffffffffffff, 0x0000000000009b14)
01:00000:00138:2011/07/26 11:01:21.73 kernel pc: 0x0000000080f6fae4 _coldstart(0x000000000000027d, 0x00000000803cca8c,
0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
01:00000:00138:2011/07/26 11:01:21.73 kernel end of stack trace, spid 138, kpid 1547502369, suid 5

Hello orientphoebus,

It seems odd that running a select statement from Toad would cause this sort of crash.

Just clarify, this SQL executes normally under isql but not Toad for Sybase?

Would it be possible to get the @@version string from you?

Thanks.

I will try the query again later. But the DBA meant it might be unstable for using some tool running some query.

Here it is:
Adaptive Server Enterprise/15.0.3/EBF 17156 ESD#3/P/Sun_svr4/OS 5.8/ase1503/272
6/64-bit/FBO/Fri Feb 5 05:26:23 2010

Ok, just as an FYI, the drivers that we use are provided by Sybase so it should not be unstable. However, if you run across this issue on a regular basis please let us know so we can investigate further.

Thanks.