For anyone else having the same issue, here’s how to fix it.
While my local php.ini memory_limit was changed to 512M the application was still using value from master php limit which was set as 32M. After my hosting provider increased this value to 128M, things started working. I also do not see memory exhausted error anymore.