An application which uses K2 Blackperl encountered an error and received time out erros on front end too.
Below was the error (from event log) at a point in time:
1 24129 A database error occurred : Cannot insert duplicate key row in object 'dbo._ProcInst' with unique index 'Cl_ProcInst'. Violation of PRIMARY KEY constraint 'PK__ProcInstRevision'. Cannot insert duplicate key in object 'dbo._ProcInstRevision'. Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0. The statement has been terminated. The statement has been terminated.
After some time another error was logged as below:
1 Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
During this whole process the CPU usage was 100 % and the application hence was unavailable for quite some time. It worked fine only after the server with K2 blackperl was rebooted.
Could someone please let me know the possible cause of this and possible resolutions too? Thanks.