The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.
Too many open files issue
Getting an error "Too many open files issue" error messages. This can occur when some of the tables being referenced in the analyze_constraints(), had a large number of delete vector containers. It can also occur when an update is trying to run Insufficient resources to execute plan on pool general [Request Too Large:File Handles Exceeded: Requested = 54262, Free = 54227 (Limit = 54227, Used = 0)]