Pq: split failed while applying backpressure: could not find valid split key

(yeriahn) #1

The DDL is not performed after the just insert load test.
There are error that I met.

root@000.000.000.17:26260/postgres> create table ms_box(
-> romm_id string(6)
-> ,timeuuid bigint
-> ,message string
-> ,PRIMARY KEY (romm_id, timeuuid)
-> );
pq: split failed while applying backpressure: could not find valid split key

so, I find the github.
I did an investigation at Githerb. There were many issues like this.

SET CLUSTER SETTING kv.snapshot_rebalance.max_rate=‘32MiB’
SET CLUSTER SETTING kv.snapshot_recovery.max_rate=‘32MiB’
ALTER RANGE default CONFIGURE ZONE USING gc.ttlseconds =

but there were no solutions.
I think it’s a problem caused by a lot of MVCC due to gc.ttlsecond, but is it solved over time?
Or do you have the solution?

0 Likes

(Ron Arévalo) #2

Hey @yeri,

Yes, this usually happens when you are updating the same row over and over. It would be solved over time, however the default for gc.ttlseconds is 25 hours.

You could change this to a lower value by configuring your replication zones, we have examples on how to change that here.

Let me know if you have any questions.

Thanks,

Ron

0 Likes