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.