Database Error " could not complete because of conflict with concurrent transaction compiled"

Help
, ,
1

I’ve been trying to increase the number of threads of my dbt, but the process always gets this error if the thread number is set to be more than 1:

Database Error in model model_name (path_to_model.sql) could not complete because of conflict with concurrent transaction compiled Code at target/run/path_to_model.sql

My current dbt (dbt-core) version: 1.8.3
Plugins:

  • redshift: 1.8.1
  • postgres 1.8.2

Instance: PostgreSQL 8.0.2 (Amazon Redshift)

Does anyone know why this error possibly occurred and how to mitigate it? Thanks.