Postgres continuously reports "transaction already in progress" when DBT runs

[dianabarsan]

I'm seeing this every time DBT runs:

dbt-1       | 14:07:14  Running with dbt=1.8.1
dbt-1       | 14:07:14  Registered adapter: postgres=1.8.1
dbt-1       | 14:07:14  Found 9 models, 28 data tests, 1 source, 528 macros
dbt-1       | 14:07:14  
postgres-1  | 2024-06-06 14:07:15.016 UTC [11875] WARNING:  there is already a transaction in progress
postgres-1  | 2024-06-06 14:07:15.033 UTC [11876] WARNING:  there is already a transaction in progress
postgres-1  | 2024-06-06 14:07:15.059 UTC [11876] WARNING:  there is already a transaction in progress
dbt-1       | 14:07:15  Concurrency: 1 threads (target='default')
dbt-1       | 14:07:15  
dbt-1       | 14:07:15  1 of 5 START sql table model dbt.chws .......................................... [RUN]
postgres-1  | 2024-06-06 14:07:15.147 UTC [11877] WARNING:  there is already a transaction in progress
dbt-1       | 14:07:16  1 of 5 OK created sql table model dbt.chws ..................................... [SELECT 0 in 1.15s]
dbt-1       | 14:07:16  2 of 5 START sql incremental model dbt.data_record ............................. [RUN]
postgres-1  | 2024-06-06 14:07:17.382 UTC [11880] WARNING:  there is already a transaction in progress
dbt-1       | 14:07:17  2 of 5 OK created sql incremental model dbt.data_record ........................ [INSERT 0 0 in 1.21s]
dbt-1       | 14:07:17  3 of 5 START sql incremental model dbt.person .................................. [RUN]
postgres-1  | 2024-06-06 14:07:18.597 UTC [11883] WARNING:  there is already a transaction in progress
dbt-1       | 14:07:18  3 of 5 OK created sql incremental model dbt.person ............................. [INSERT 0 0 in 1.18s]
dbt-1       | 14:07:18  4 of 5 START sql table model dbt.reports ....................................... [RUN]
postgres-1  | 2024-06-06 14:07:18.639 UTC [11887] WARNING:  there is already a transaction in progress
dbt-1       | 14:07:19  4 of 5 OK created sql table model dbt.reports .................................. [SELECT 0 in 1.06s]
postgres-1  | 2024-06-06 14:07:20.751 UTC [11893] WARNING:  there is already a transaction in progress
dbt-1       | 14:07:20  Finished running 3 table models, 2 incremental models in 0 hours 0 minutes and 5.81 seconds (5.81s).

Investigate why postgres would report this warning .

[dianabarsan]

possibly related dbt-labs/dbt-core#9434