1960890 - Errors 940 and 6103 reported when parallel query uses a shared worktable - ASE

• A Parallel query that uses a shared worktable does result in Error: 940, Severity: 26, State 11 "Dbtable in wrong state for Operation" followed by a stacktrace and the process being terminated.

server  Error: 940, Severity: 26, State: 11
server  Dbtable in wrong state for operation: DBTABLE pointer = 0x0x19ecfa280, dbid = 10, state = 0x2, status= 0xc, keep = 0, system task keep = 0, name = 'tempdb_2'.
kernel  ************************************
kernel  SQL causing error : 
kernel  Current Procedure: XXXXXXXXX
kernel  Current statement number: 6 Current line number: 32
kernel  ************************************
server  SQL Text:
server  SQL Text: SELECT @id_source = id_source

  FROM...

kernel  curdb = 10 tempdb = 10 pstat = 0x10000 p2stat = 0x101000
kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x10000
kernel  lasterror = 940 preverror = 0 transtate = 1
kernel  curcmd = 193 program = isql                         
kernel  extended error information: hostname: XXX login: XXX
kernel  pc: 0x00000000014ccabb pcstkwalk+0x3a3()
kernel  pc: 0x00000000014cc593 ucstkgentrace+0x263()
kernel  pc: 0x00000000014c850e ucbacktrace+0x50()
kernel  pc: 0x000000000077a5ac terminate_process+0x130c()
kernel  pc: 0x0000000001196fd6 hdl_default+0x3b()
kernel  pc: 0x00000000011337e7 s_handle+0x3c7()
kernel  pc: 0x00000000011960bf ex_raise+0x23f()
kernel  pc: 0x0000000000d500de dbt_unkeep+0x52e()
kernel  pc: 0x0000000000d38dc8 closedb+0xa8()
kernel  pc: 0x0000000000aadca3 sdes_hookup+0x573()
kernel  pc: 0x0000000000fb4bd1 run_crtable+0x1f1()
kernel  pc: 0x0000000000842b7a LeWkTbl::crtWkTbl(int, short, int)+0x14a()
kernel  pc: 0x0000000001748491 LeStoreOp::_LeOpAcquire(ExeCtxt&)+0x26f()
kernel  pc: 0x00000000007ff4a9 LeEmitXchgOp::LeOpFinishCG(CgPhase2*, LeBufferNeeded)+0x279()
kernel  pc: 0x00000000017432fa LeSequencerOp::_LeOpAcquire(ExeCtxt&)+0x8a()
kernel  pc: 0x00000000007f571a LeEmittOp::_LeOpAcquire(ExeCtxt&)+0x5a()
kernel  pc: 0x00000000007eb4ab LePlanAcquire+0x5bb()
kernel  pc: 0x0000000000f74b11 exec_lava+0x221()
kernel  pc: 0x00000000010f6c1e s_execute+0x129e()
kernel  pc: 0x0000000001136fcb sequencer+0x17cb()
kernel  pc: 0x0000000001104f29 execproc+0x709()
kernel  pc: 0x00000000010f8b56 s_execute+0x31d6()
kernel  pc: 0x0000000001136fcb sequencer+0x17cb()
kernel  pc: 0x0000000001104f29 execproc+0x709()
kernel  pc: 0x00000000010f8b56 s_execute+0x31d6()
kernel  pc: 0x0000000001136fcb sequencer+0x17cb()
kernel  pc: 0x00000000007bae1c tdsrecv_language+0x1ec()
kernel  pc: 0x00000000007db028 conn_hdlr+0x1078()
kernel  end of stack trace, spid 216, kpid 270468020, suid 3

• Subsequent 6103 error is also reported:

Error: 6103, Severity: 17, State: 1
server  Unable to do cleanup for the killed process

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.0

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed