The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

How to interrupt a refresh operation?

A background refresh operation is in progress, started used "select start_refresh()". You would like to interrupt it.

Comments

  • Use "select cancel_refresh()". The cancel_refresh() function was omitted from the 4.0 and 4.1 documentation and will be restored in the 5.0 documentation. Notes: Refresh tasks run in a background thread in an internal session, so you cannot use INTERRUPT_STATEMENT to cancel those statements. Instead, use CANCEL_REFRESH to cancel statements that are run by refresh-related internal sessions. Run CANCEL_REFRESH() on the same node on which START_REFRESH() was initiated. CANCEL_REFRESH() cancels the refresh operation running on a node, waits for the cancelation to complete, and returns SUCCESS. Only one set of refresh operations runs on a node at any time.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.