The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Drop partition failed
The drop_partition() failed with the following error: "Cannot drop the partition ... concurrent load running .. HINT: Try the operation again". Unfortunately, I do not have the exact error statement available. I could not find anything in the vertica.log file, but the dc_errors table reported the following message approx at the same time: "A mergeout operation (operating on the same set of miniROSs) is already in progress on projection dbadmin.session_resource_usage_nodeX". I am not sure if this is related to the error message I encountered when trying to drop the partition. 2nd issue: We often run into this warning message on Vertica: "event_code_description | Timer Service Task Error event_problem_description | threadShim: A DDL statement interfered with this statement" How can we fix this?