Jun Zhou
09/14/2022, 7:53 AM'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]
Andrey Pechkurov
09/14/2022, 9:08 AMJun Zhou
09/15/2022, 10:10 AM6.5.2
.Andrey Pechkurov
09/15/2022, 10:17 AM