Error: Transaction Is Aborted Due to Concurrent Update Against Table

Issue

The following error appears in the destination:

Transaction Is Aborted Due to Concurrent Update Against Table <table_name>

Environment

Destination: BigQuery

Resolution

To resolve this error, do the following:

1. Pause the relevant connector.

   i. In Fivetran, go to the relevant connector page.

   ii. In the top right, set the ENABLED toggle to OFF.

2. In BigQuery, terminate active sessions related to the affected table using the following query. Replace the placeholders , <gserviceaccount_email>, <schema_name>, and <table_name> with the appropriate values:

   FOR session in 
   (SELECT session_info.session_id, sessions.creation_time FROM region-<US/EU>.INFORMATION_SCHEMA.JOBS_BY_PROJECT jobs INNER JOIN
     region-<US/EU>.INFORMATION_SCHEMA.SESSIONS_BY_PROJECT sessions ON jobs.session_info.session_id = sessions.session_id
     WHERE jobs.creation_time > TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 DAY)
     AND jobs.user_email = '<gserviceaccount_email>'
     AND jobs.transaction_id IS NOT NULL
     AND jobs.destination_table.dataset_id LIKE '<schema_name>'
     AND jobs.destination_table.table_id LIKE '<table_name>'
     AND sessions.session_id IS NOT NULL AND sessions.is_active = true)
   DO
   CALL BQ.ABORT_SESSION(session.session_id);
   END FOR;
   

3. In Fivetran, resume the connector by setting the ENABLED toggle to ON.

If the issue persists, contact our support team.