Symptom
- ASE 15.0.3 or above may hit a stacktrace on signal 11 on bt__gc_cmtdelonly and contains most of the following modules:
bt__gc_cmtdelonly+0x13c()
bt__traverseandinsert+0x68()
bt_insert+0x174()
dol__ncinsert+0x3d4()
obj_newrow+0x3b4()
crt_main__fdpr_8+0x7fc()
s__crtinto+0x164() - 00:04:00000:01998:2013/03/14 02:30:47.98 kernel Address 0x0x0000000000af37b7 (bt__gc_cmtdelonly+0x287), siginfo (code, address) = (1, 0x(nil))
00:04:00000:01998:2013/03/14 02:30:47.98 server Maxdumps (5) reached for signal 11. Not performing shared memory dump.
00:04:00000:01998:2013/03/14 02:30:47.98 kernel ************************************
00:04:00000:01998:2013/03/14 02:30:47.98 kernel SQL causing error : sel_AnyProductComplete @num_tr=@p1 , @typ_op=@p2, @with_contract=@p3ì
00:04:00000:01998:2013/03/14 02:30:47.98 kernel Current Procedure: sel_opt_flex_1_Complete
00:04:00000:01998:2013/03/14 02:30:47.98 kernel Current statement number: 7 Current line number: 82
00:04:00000:01998:2013/03/14 02:30:47.98 kernel ************************************
00:04:00000:01998:2013/03/14 02:30:47.98 server SQL Text: sel_AnyProductComplete @num_tr=@p1 , @typ_op=@p2, @with_contract=@p3ì
00:04:00000:01998:2013/03/14 02:30:47.98 server SQL Text: select * into #tmp_sel_complement from tmp_sel_complement where 1=2
00:04:00000:01998:2013/03/14 02:30:47.98 kernel curdb = 27 tempdb = 27 pstat = 0x10000 p2stat = 0x101002
00:04:00000:01998:2013/03/14 02:30:47.98 kernel p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x10000
00:04:00000:01998:2013/03/14 02:30:47.98 kernel lasterror = 0 preverror = 0 transtate = 0
00:04:00000:01998:2013/03/14 02:30:47.98 kernel curcmd = 195 program =
00:04:00000:01998:2013/03/14 02:30:47.98 kernel extended error information: hostname: login:
00:04:00000:01998:2013/03/14 02:30:47.98 kernel pc: 0x000000000176740f pcstkwalk+0x30()
00:04:00000:01998:2013/03/14 02:30:47.98 kernel pc: 0x0000000001767205 ucstkgentrace+0x1a5()
00:04:00000:01998:2013/03/14 02:30:47.98 kernel pc: 0x0000000001706771 ucbacktrace+0x43()
00:04:00000:01998:2013/03/14 02:30:47.98 kernel pc: 0x000000000074360e terminate_process+0xd5e()
00:04:00000:01998:2013/03/14 02:30:47.98 kernel pc: 0x0000000001733d03 kisignal+0x3b3()
00:04:00000:01998:2013/03/14 02:30:47.98 kernel pc: 0x0000000000af37b7 bt__gc_cmtdelonly+0x287()
00:04:00000:01998:2013/03/14 02:30:47.99 kernel pc: 0x000000000198c307 bt__insert_into_leaf+0x177()
00:04:00000:01998:2013/03/14 02:30:47.99 kernel pc: 0x000000000198bef0 bt__traverseandinsert+0x50()
00:04:00000:01998:2013/03/14 02:30:47.99 kernel pc: 0x0000000000af5168 bt_insert+0x1a8()
00:04:00000:01998:2013/03/14 02:30:47.99 kernel pc: 0x0000000000ad406b dol__ncinsert+0x24b()
00:04:00000:01998:2013/03/14 02:30:47.99 kernel pc: 0x0000000001950acf dol_insert+0xeef()
00:04:00000:01998:2013/03/14 02:30:47.99 kernel pc: 0x000000000195f0f5 ins_insert+0x2a5() - Error 644 can also be seen at the time of the issue.
Read more...
Environment
-
SAP Adaptive Server Enterprise (ASE) 15.0.3
- SAP Adaptive Server Enterprise (ASE)
- Dataserver
- Solaris on Sparc 64bit
- Solaris on x86_64 64bit
Product
SAP Adaptive Server Enterprise 16.0
Keywords
signal 11, error 614, function, bt_gc_cmtdelonly(), stacktrace, CR612661, CR#612661, 612661 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview