Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How to interrupt a refresh operation?

[Deleted User][Deleted User]
in General Discussion
A background refresh operation is in progress, started used "select start_refresh()". You would like to interrupt it.

Comments

  • [Deleted User][Deleted User]
    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
Format
Heading 1Heading 2
QuoteCodeSpoiler
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...

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