Hello all,
We are seeing excessive blocking in the TAC admin database. Specifically, we are seeing insert statements going to into a sleeping state and blocking many other statements. The impact is that the job scheduler stops responding and scheduled jobs are failing because the insert statement is blocking. Eventually, TAC stops responding completely. We have set up a script to automatically clear the sleeping statemtn after a short wait period but we all know this should not be happening at all.
Has anybody seen this before? What is the root cause? What is the solution?
HEAD - 216 (@P0 int,@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 nvarchar(4000),@P5 nvarchar(4000),@P6 nvarchar(4000),@P7 nvarchar(4000),@P8 nvarchar(4000),@P9 nvarchar(4000),@P10 nvarchar(4000),@P11 nvarchar(4000),@P12 nvarchar(4000),@P13 int,@P14 int,@P15 int,@P16 bit,@P17 nvarchar(4000),@P18 nvarchar(4000),@P19 nvarchar(4000),@P20 nvarchar(4000),@P21 nvarchar(4000),@P22 int,@P23 int,@P24 datetime,@P25 nvarchar(4000),@P26 nvarchar(4000),@P27 nvarchar(4000),@P28 nvarchar(4000),@P29 nvarchar(4000),@P30 datetime,@P31 datetime,@P32 datetime,@P33 datetime,@P34 datetime,@P35 nvarchar(4000),@P36 nvarchar(4000),@P37 nvarchar(4000),@P38 bit,@P39 nvarchar(4000),@P40 nvarchar(4000),@P41 nvarchar(4000),@P42 int,@P43 int,@P44 nvarchar(4000),@P45 nvarchar(4000),@P46 nvarchar(4000),@P47 int,@P48 int,@P49 nvarchar(4000))insert into [taskexecutionhistory] (e_version, [basicstatus], [detailedstatus], [tasklabel], [taskdescription], [projectname], [talendjobname], [talendjobid], [talendjobversion], [contextname], [virtualservername], [executionservername], [executionserverhost], [executionservercmdport], [executionserverfileport], [executionservermonitoringport], [applycontexttochildren], [triggeredby], [triggertype], [triggername], [triggerdescription], [taskerrorstacktrace], [idquartzjob], [idquartztrigger], [lastjobgenerationdate], [jobarchivefilename], [filetriggerfilemask], [filetriggerfilename], [filetriggerfolderpath], [filetriggertriggeredfilepath], [expectedtriggeringdate], [taskstartdate], [taskenddate], [serverjobstartdate], [serverjobenddate], [idremotejob], [idremotejobexecution], [requestid], [resumingmode], [contextvalues], [contexttypes], [jvmvalues], [parenttaskexecid], [parentplanexecid], [jobexecutionlogs], [log4jlevel], [executionserverversion], [timesecsincepreviousexec], [exitcode], [runasuser], [dtype]) values ( @P0 , @P1 , @P2 , @P3 , @P4 , @P5 , @P6 , @P7 , @P8 , @P9 , @P10 , @P11 , @P12 , @P13 , @P14 , @P15 , @P16 , @P17 , @P18 , @P19 , @P20 , @P21 , @P22 , @P23 , @P24 , @P25 , @P26 , @P27 , @P28 , @P29 , @P30 , @P31 , @P32 , @P33 , @P34 , @P35 , @P36 , @P37 , @P38 , @P39 , @P40 , @P41 , @P42 , @P43 , @P44 , @P45 , @P46 , @P47 , @P48 , @P49 , 'TaskExecutionHistory') SELECT SCOPE_IDENTITY() AS _JTDS_GENE_R_ATED_KEYS_
Thank you
Wayne
