The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Every CALL to stored procedure allocates memory to Vertica process which never released

rajuk99rajuk99 Community Edition User
edited September 2022 in General Discussion

Hi Vertica support,
I created a stored procedure which inserts data from one table to another. Vertica server started to crash due to lack of memory periodically. I started analyzing query inside store procedure and eventually remove everything except BEGIN...END but still see each CALL to stored procedure allocate more memory to Vertica which never gets released.

I checked the resource pool and the configuration looks ok. Issue only happens when calling stored procedure.

Is there a known issue with stored procedure memory leak? What are my options.

Thanks
Raju

Answers

  • SruthiASruthiA Vertica Employee Employee

    Could you please share me your stored procedure definition and analysis performed to confirm memory is not released.

  • VValdarVValdar Vertica Employee Employee

    Hi Raju,

    Thanks for bringing this up; this definitely needs to be followed with a support case, could you open one?
    Can you also provide the Vertica version you're using?
    Thanks.

Leave a Comment

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