Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
WLawton
Contributor
Contributor

TAC database taskexecutionhistory excessive blocking

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

Labels (2)
4 Replies
Anonymous
Not applicable

Hello,

Could you please clarify in which Talend version/edition you are? It looks there are some conflict/dead lock issue with transaction and thread. Is it possible to clear old taskexecutionhistory to see if it is OK with you.

You can create a support case on talend support portal so that our colleagues from support team will deliver a patch to you if needed through support cycle with priority.

Best regards

Sabrina

 

 

WLawton
Contributor
Contributor
Author

Talend Data Integration 7.1.1.20181026_1147

> Is it possible to clear old taskexecutionhistory?

Yes, we already did so. We are only tracking the current month of history. That is only 179,985 as of today.

I will open up a support ticket also.

 

Thank you

Wayne

WLawton
Contributor
Contributor
Author

Ok, after 30 minutes of trying, I give up. How do I get from this screwed up community site to the real site where I can log a ticket? Yes, I am a paying customer with a three year subscription.

 

Anonymous
Not applicable

@Wayne Lawton​ ,  To open a ticket on Talend Support Portal, you will need to click on the “Contact Support” button which is next to the search bar in the Community home page. If you have any issue to access Talend Support Portal, please email to community_help@talend.com

 

Regards

Shong