When connecting Spotlight on Sybase against Adaptive Server Enterprise/15.0.2/EBF 15651 ESD#4, an error occurs after a while.
Spotlight on Sybase client shows:
ct_cmd_alloc: user api layer:external error: The connection has been marked dead.
The stacktrace dump file shows an this statement:
00:00000:00029:2008/09/15 10:10:15.29 kernel SQL causing error : sID and e.WaitEventID=w.WaitEventID and w.SPID=p.spid and p.enginenum=@engine
order by c.WaitClassID
00:00000:00029:2008/09/15 10:10:15.31 kernel extended error information: hostname: syddb12d-old.aus.nsroot.net login: dbadmin
The result of exec sp_sls_E_waits_by_engine_m 0 when execute against ASE 15 yields:
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
This is the result of BugID 532645 Sybase ASE 15. A 3rd Party issue contributed to this error.
The bug is described as a join containing an MDA table may stacktrace with a signal 10 if a Nested Loop Join is used.
Please refer to this URL for details http://search.sybase.com/kbx/changerequests?bug_id=532645.
Spotlight on Sybase hits this bug when it makes join query against MDA table.
This bug will be fixed in ESD #6 and should be released within October/November 2008. Below is the Sybase CR release schedule URL.
http://www.sybase.com/detail?id=1038641
Do note that this Sybase ASE bug is not found in Windows version ASE 15.
