Indexing fails with split failed while applying backpressure error from CDB [fix]

[urtho]

If anyone encounters split failed while applying backpressure error that halts indexing then this CDB setting seems to solve the problem:

SET CLUSTER SETTING kv.range.backpressure_range_size_multiplier=0

Full error:

Exiting with error:     exporter cockroachdb handler (exporter cancelled) after round 21012215: aborting after failing to export round 21012215: cockroachdb: giving up after 10 retries: AddBlock() err: TxWithRetry() err: attemptTx() err: AddBlock() err: MakeWriter() prepare statement for name 'upsert_app' err: ERROR: prepared statement "upsert_app" already exists (SQLSTATE 42P05).
{"__type":"Conduit","_name":"main","level":"info","msg":"cockroachdb: retry number 0/10 with err: AddBlock() err: TxWithRetry() err: attemptTx() err: AddBlock() err: AddBlock() exec err: ERROR: split failed while applying backpressure to Put [/Table/125/1/465818260/0,/Min), [txn: 1c17b91c] on range r2377:/Table/125/1/46581{8260-9029} [(n1,s1):1, next=2, gen=58]: could not find valid split key (SQLSTATE XXUUU)","time":"2024-01-19T23:26:29.358814756Z"}