Symptom
After deadlock information, 'Error: 4846 State: 3' in ASE errorlog
00:0004:00000:03418:2022/06/14 06:43:43.67 server Deadlock Id 6 detected
Deadlock Id 6 detected. 1 deadlock chain(s) involved.
Deadlock Id 6: Process (Familyid 0, Spid 3592, Suid 10) was executing a UPDATE command in the procedure 'objid 306' at line 1 at nested level 2.
Deadlock Id 6: Process 3592 was involved in application 'KFSQL'.
Deadlock Id 6: Process 3592 was involved on host name 'ivapp1182198.iadvantage.ms.com'.
Deadlock Id 6: Process 3592 was involved in transaction '$upd'.
SQL Text: UPDATE
Deadlock Id 6: Process (Familyid 0, Spid 3418, Suid 10) was executing a BULK INSERT command at line 1.
Deadlock Id 6: Process 3418 was involved in application 'genericDataLoad.pl'.
Deadlock Id 6: Process 3418 was involved on host name 'ivapp1182201.ggateway.ms.com'.
Deadlock Id 6: Process 3418 was involved in transaction 'equityDerivativeStress'.
Deadlock Id 6: Process 3418 was doing a bulk copy.
SQL Text: BULK INSERT
Deadlock Id 6: Process (Familyid 0, Spid 3418) was waiting for a 'exclusive page' lock on page 7612997 of table 'equityDerivativeStress' in database 'staging' but process (Familyid 0, Spid 3592) already held a 'exclusive page' lock on it.
Deadlock Id 6: Process (Familyid 0, Spid 3592) was waiting for a 'exclusive page' lock on page 3275850 of table 'equityDerivativeStress' , indid 4 in database 'staging' but process (Familyid 0, Spid 3418) already held a 'exclusive page' lock on it.
Deadlock Id 6: Process (Familyid 0, Spid 3418) was chosen as the victim.
Victim process host = `ivapp1182201.ggateway.ms.com', user = `bkpbs' program name = `genericDataLoad.pl' host processes = `27592' .
End of deadlock information.
00:0004:00000:03418:2022/06/14 06:43:43.68 server Error: 4846, Severity: 20, State: 3
00:0004:00000:03418:2022/06/14 06:43:43.68 server Bulk copy failed. Error occurred while updating the last page of the table.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
Product
Keywords
CR826714 , CR#826714 , 826714, State: 4, State4, Error: 4864 State: 4, Error 4864 State 4, Error 4864 State 3, , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.