Symptom
- 'Error: 4846 State: 3' reported in ASE errorlog for a connection which is a deadlock victim when performing BULK INSERT.
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 'app'.
Deadlock Id 6: Process 3592 was involved on host name 'hostname'.
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 'app.pl'.
Deadlock Id 6: Process 3418 was involved on host name 'hostname'.
Deadlock Id 6: Process 3418 was involved in transaction 'app'.
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 'tab' in database 'db' 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 'tab' , indid 4 in database 'db' 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 = `hostname', user = `user1' program name = `app.pl' host processes = `27592' .
End of deadlock information.
- Error: 4846, Severity: 20, State: 3
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 , Known Error
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.