2056289 - Error 702 with cpynodes - SAP ASE

• Running the following select statement in ASE:

SELECT col1,col2,col3,col4,col5,col6,col7 from db.tbl1 WHERE (col1 = 11)

• The following error is reported in the error log:

server Error: 702, Severity:20, State: 1
server Memory request for 1079483768 bytes exceeds the size of single page of 16384 bytes.

• The following stack trace is also reported:

kernel curdb = 14 tempdb = 76 pstat = 0x10000 p2stat = 0x40101000
.....removed from stack
kernel lasterror = 702 preverror = 0 transtate = 1
.....removed from stack
kernel pc: 0x0000000000dae8b6 memalloc+0x576()
kernel pc: 0x0000000001203a79 cpymemalloc+0x89()
kernel pc: 0x0000000001205347 cpynodes+0x147()
kernel pc: 0x00000000012057f2 treecpy_withroot+0xc2()
kernel pc: 0x000000000116c0c9 tmp__copy+0xb9()
kernel pc: 0x000000000116bfee tmp_copy_list+0x5e()

• The following errors may also appears in the error log:
  
  
• 724, Severity: 20, State: 1
  Internal Error: Function 'memalloc' was passed an illegal size value (-2095895210).
  
• Error: 6103, Severity: 17, State: 1
  Unable to do cleanup for the killed process; received Msg 707.
  
• Error: 707, Severity: 20, State: 11
  System error detected during attempt to free memory at address xxxxx
  
  
• As a result of error 6103, a phantom spid may be left behind that can only be cleared by rebooting ASE.

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

batch_loopend, s_copytmps, tmp_actual_copy, treecpynames, cpyresdom, cpynodes, mp_actual_copy , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed