Title
j

Jun Zhou

09/14/2022, 7:53 AM
Hi all, I encounter an error
'ERROR: max txn-inflight limit reached'
when inserting records into questdb by using postgres protocol, what's the cause of this and how to resolve it? Thanks in advance for any help. The quesdb version is
6.5.0
.
Routing to failure.: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO gpdb_session_level_memory_consumption (sample_time, datname, pid, sess_id, state, waiting, waiting_reason, usename, segid, vmem_mb, is_runaway, qe_count, active_qe_count, dirty_qe_count, runaway_vmem_mb, runaway_command_cnt, idle_start, query_start, total_time, query) VALUES ('54672-11-10 02:32:13.513+08','gpdb_df',154221,17474468,'idle','FALSE',NULL,'df_admin',-1,16,'FALSE',1,0,-1,0,0,'54672-11-10 02:25:35.983+08','54672-11-10 02:23:26.085+08',1,'COMMIT') was aborted: ERROR: max txn-inflight limit reached [txn=17039, min=647, size=16384] Call getNextException to see other errors in the batch. - Caused by: org.postgresql.util.PSQLException: ERROR: max txn-inflight limit reached [txn=17039, min=647, size=16384]
a

Andrey Pechkurov

09/14/2022, 9:08 AM
Hi Jun, There is a very good chance that this bug was fixed in 6.5.2. Please try upgrading.
j

Jun Zhou

09/15/2022, 10:10 AM
Hi @Andrey Pechkurov , thanks a lot, the issue is resolved after upgrading to the
6.5.2
.
a

Andrey Pechkurov

09/15/2022, 10:17 AM
Awesome to hear that. Thanks for the confirmation!