SAP Knowledge Base Article - Preview

2279496 - Frequent deadlocks in Job Scheduler - SAP ASE

Symptom

  • Frequent deadlocks can be seen from ASE errorlog:

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' .

  •  JSAgent.log file shows the following error:

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

  • Restarting the Job scheduler process does not help.

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) - All versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

"js stop", "js start", "reorg rebuild", sp_js_agent, js_history, SQL1205, 1205 , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.