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

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
Tagged:
0
Answers
Could you please share me your stored procedure definition and analysis performed to confirm memory is not released.
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.