avamingli commented on issue #1494: URL: https://github.com/apache/cloudberry/issues/1494#issuecomment-3985329730
The most possible reason： this error happens when too many concurrent sessions try to insert into the same AO (Append-Optimized) table on the same segment. Each AO table has 127 segment files available per segment node. In version 2.0, the GUC `gp_appendonly_insert_files` defaulted to 4, meaning each inserting session could hold up to 4 segment files. So with just 32 concurrent insert processes, you could exhaust all 127 files on a single segment node and hit this error. To reproduce: start more than 32 concurrent sessions inserting into the same AO table with enough data and duration, and you'll eventually see this on one of the segment nodes. The fix: in newer versions, `gp_appendonly_insert_files` defaults to 0. If you're staying on 2.0, you can work around it by setting: gp_appendonly_insert_files = 0 globally. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
