Clearing lock of taskexecutionhistory table - 7.3

Talend Installation Guide

Version
7.3
Language
English
Operating system
Linux
Subscription type
Subscription
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend ESB
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend LogServer
Talend MDM Server
Talend MDM Web UI
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
Installation and Upgrade
Last publication date
2022-10-30

About this task

If you encounter lock issue of the taskexecutionhistory table in the database, follow these steps to resolve it.

Procedure

  1. Open the configuration.properties file to edit it.
  2. Set lockTimeout for connection pool by URL, for example:
     jdbc:sqlserver://localhost:1433/tac801;lockTimeout=1800
    In cluster mode, change this connection URL on all instances of Talend Administration Center.
    It is also recommended to enable the READ_COMMITTED_SNAPSHOT option:
    ALTER DATABASE <database name>
     SET READ_COMMITTED_SNAPSHOT ON
     WITH ROLLBACK IMMEDIATE;
  3. Save your changes and close the file.