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.
SAP Knowledge Base Article - Preview