In my ETL processes, I have a few lines like:
select move_partitions_to_table ('stg.A', 0, 24, 'tmp_table.A')erroring out with
ERROR: A Moveout operation is already in progress on projection stg.B_all_nodes_b0 [txnid 45035996338570033 session fqdn-25466:0xd053]In short, a moveout on table A fails because a moveout on table B is currently happening. On a sidenote, the error happens instantly, not after a timeout expired.
Does that make sense? One moveout per table I can understand, but one moveout only at a time for the whole cluster surely cannot be correct?
I did look at the tm pool, and the planned and max concurrency are 4 and 6 respectively. I upgrade the max concurrency to 20 but this made no difference at all.
This error happens only on Vertica 7.1.0-1. I upgraded yesterday from 6.3, and this is the only issue I get from the upgrade.
Would anybody have any idea how I could fix this short of downgrading?
Thanks,
