Symptom
- ASE error log ($SYBASE/$SYBASE_ASE/install/<SID>.log) it is reporting frequent deadlocks involving the js_history table from the Job Scheduler database (sybmgmtdb), i.e.:
Deadlock Id 2902 detected. 1 deadlock chain(s) involved.
Deadlock Id 2902: Process (Familyid 0, Spid 61, Suid 3) was executing a SELECT command in the procedure 'sp_writejoboutput' at line 54 at nested level 1.
Deadlock Id 2902: Process 61 was involved in application 'JS Agent'.
Deadlock Id 2902: Process 61 was involved on host name ''.
Deadlock Id 2902: Process 61 was involved in transaction 'sp_writejoboutput'.
SQL Text: sp_writejoboutput '829687', 'Changed database context to ''saptools''.
(return status = 0)
Executing procedure: sp_writejoboutput
Subordinate SQL Text:
select @user_name=jsh_user_req, @tot_size=jsh_size from sybmgmtdb..js_history where jsh_exid=@run_id
Deadlock Id 2902: Process (Familyid 0, Spid 63, Suid 3) was executing a UPDATE command in the procedure 'sp_js_agent' at line 272 at nested level 1.
Deadlock Id 2902: Process 63 was involved in application 'JS Agent'.
Deadlock Id 2902: Process 63 was involved on host name ''.
Deadlock Id 2902: Process 63 was involved in transaction '$upd'.
SQL Text: sp_js_agent 'setstate=C1,id=829697'
Executing procedure: sp_js_agent
Subordinate SQL Text:
update sybmgmtdb..js_history set jsh_state=@state where jsh_exid = @id
Deadlock Id 2902: Process (Familyid 0, Spid 63) was waiting for a 'update row' lock on row 20 page 1896 of the 'js_history' table in database 'sybmgmtdb' but process (Familyid 0, Spid 61) already held a 'exclusive row' lock on it.
Deadlock Id 2902: Process (Familyid 0, Spid 61) was waiting for a 'shared row' lock on row 17 page 1896 of the 'js_history' table in database 'sybmgmtdb' but process (Familyid 0, Spid 63) already held a 'exclusive row' lock on it.
Deadlock Id 2902: Process (Familyid 0, Spid 61) was chosen as the victim.
Victim process host = `', user = `jstask' program name = `JS Agent' host processes = `30998778' .
- Checking the Job Scheduler Agent log ($SYBASE/$SYBASE_ASE/install/JSAGENT.log) several errors 1205 (deadlocks) are reported.
worker Server message: Your server command (family id #0, process id #61) encountered a deadlock situation. Please re-run your command.
worker jso_FlushBuffer: jsd_GetResults() failed for xid 829687
- As result, from DBACockpit of SAP Systems, the Planning Calendar is showing tasks with red traffic light.
- For the DUMP DATABASE tasks, when checking the backup filesystem you can see the DUMP DATABASE files are correctly generated despiste that red traffic light for the task in Planning Calendar.
- Restarting the Job scheduler process does not help.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
"js stop", "js start", "reorg rebuild", sp_js_agent, js_history, SQL1205, 1205, deadlock , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.