2 Replies Latest reply on Jun 18, 2015 2:14 AM by xiejian xie

    deadlock when update data into sybase database.

    xiejian xie Seasoned Veteran

      Will show us session logs as below:

       

      WRT_8299 Database errors occurred:

       

           Thu Jun 18 xxxxx SQL Server Message 1205: Your server command (family id #0, process id #86) encountered a deadlock situation. Please      re-run your command.

       

           Database driver error...

           Function Name: Execute

           SQL Stmt: UPDATE XXX  SET XXXXXXXXXX

       

      WRT_8425 ERROR: Writer execution failed

      WRT_8220 Error: get deadlock when reading/writing database

       

       

      We use bulk insert it work fine, but if change to normal, sometimes will pop up above issue. I don't know why?