While executing one of my scripts with 20 concurrent users, The transactions are getting failed and throwing error
Action.c(11992): Error: Server error msg (Number=1205, Severity=13, State=45, Function=dbsqlexec, Server="XXXXX", Procedure="rsp_ProcedureName", Line=33): Due to deadlock.
If i increase think time to 20 sec (multiply think time by 20; The script has a think time of 1 sec after each transaction and none inside it) the dead lock error is not thrown.
Is this a development issue or i need to handle this at script. The procedure is just selecting identity column from a table with where conditions. Thus i am a bit spectacle over here