Symptom
- Here's a long running spid in the output of "select * from syslogshold "
- Such spid doe not exist in "sp_who", but exists in "sp_lock"
- Error messages in ASE server log file:
-- the process was killed with force--
00:0020:00000:02199:2024/02/15 00:21:29.23 server Process id 2461 killed by Hostname sclfmxdblnprd01.usi.mizuho-sc., Host process id 277660.
00:0002:00000:02199:2024/02/15 00:21:50.50 server Process id 2461 killed with force by Hostname sclfmxdblnprd01.usi.mizuho-sc., Host process id 277660.--stack trace--
..terminate_process
..upsleepgeneric
..bufread+0x308
..getpage_with_validation
..apl_getnext
..xsc__syslogs_getnext
..xls_getnext
..rec_undo_session
..abort__all--Error 613--
00:0033:00000:02461:2024/02/15 00:21:57.12 server WARNING - Fatal Error 613 occurred at Feb 15 2024 12:21AM. Please note the error and time, and contact a user with System Administrator (SA) authorization.
00:0033:00000:02461:2024/02/15 00:21:57.12 server Error: 613, Severity: 20, State: 0
00:0033:00000:02461:2024/02/15 00:21:57.12 server Request made to retrieve more rows from an already completed scan of object 'syslogs' in database 'tempdb'.
00:0033:00000:02461:2024/02/15 00:21:57.13 server Error while undoing log row in database 'tempdb'. Rid pageid = 0; row num = 0.--Error 6103
00:0033:00000:02461:2024/02/15 00:21:57.13 server Error: 6103, Severity: 17, State: 1
00:0033:00000:02461:2024/02/15 00:21:57.13 server Unable to do cleanup for the killed process; received Msg 3300.
00:0033:00000:02461:2024/02/15 00:21:57.14 server WARNING: spid 2461 with suid 4 and curdbid 4 has an active transaction in dbid 2 with xactid (140738418, 36).
Read more...
Environment
SAP ASE 16.0
Product
Keywords
hang, zombie process, process hold log, kill command failed , kill with force , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.