3652196 - Connection terminated when executing certain DBCC commands with no parameters - SAP ASE

• Connection is terminated by executing DBCC addextendedproc, dropextendedproc, or findstranded
• No parameters were passed to DBCC command.
• Example:
  

  1> dbcc addextendedproc
  2> go
  ASE is terminating this process.
  1> go
  CT-LIBRARY error:
          ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read.
  CT-LIBRARY error:
          ct_cancel(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

• Errorlog contains a stacktrace containing function exec_dbcc():
  

  -- stack trace in errorlog --
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  ************************************
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  SQL causing error : dbcc addextendedproc
  
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  ************************************
  00:0008:00000:00014:2023/05/10 03:20:14.72 server  SQL Text: dbcc addextendedproc
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  curdb = 1 tempdb = 2 pstat = 0x10000 p2stat = 0x101000
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x10 p7stat = 0x10000
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  p8stat = 0x100 p9stat = 0x4000 p10stat = 0x0
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  lasterror = 0 preverror = 0 transtate = 1
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  isolation = 1 tranmode = 0 xactcnt = 0 attn = 0 extattn = 0 memusage = 5
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  curcmd = 317 program = isql
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  extended error information: hostname: lnxpw01 login: sa
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x000000000134c6bf pcstkwalk+0x28()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x000000000134c354 ucstkgentrace+0x3b0()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x0000000001348e27 ucbacktrace+0xba()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x00000000018d5d80 terminate_process+0x550()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x0000000001376cfc kisignal+0xa90()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x0000000001e5257e add_brackets+0x1e()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x0000000000b04b50 addextendedproc+0xd9()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  [Handler pc: 0x0x0000000000f632d7 hdl_backout_msg installed by the following function:-]
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x0000000001c2ee08 exec_dbcc+0x1c58()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x00000000018677c0 s_execute+0x5ad0()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  [Handler pc: 0x0x0000000001ebb0a0 hdl_stack installed by the following function:-]
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  [Handler pc: 0x0x0000000001e8b8e0 s_handle installed by the following function:-]
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x00000000018870f6 sequencer+0xba6()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x00000000018f22b7 tdsrecv_language+0x257()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  [Handler pc: 0x0x0000000002075830 ut_handle installed by the following function:-]
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  pc: 0x00000000015de279 conn_hdlr+0xec9()
  00:0008:00000:00014:2023/05/10 03:20:14.72 kernel  end of stack trace, spid 14, kpid 3473435, suid 1

Adaptive Server Enterprise (ASE) 16.x

• DBCC connection terminated.
• Sybase ASE Database Platform.
• DBCC commands without parameters.
• Connection terminated error.
• CT-LIBRARY error.
• Network packet layer error.
• Internal Client Library error.
• State error.
• Errorlog stack trace.
• exec_dbcc function.
• DBCC dropextendedprocr.
• DBCC findstranded.