On our Tableau Server v2021.3.22, single-node setup with 2 VizQLServer processes, we observed the following fatal error in the vizqlserver logs:
"Resource Manager: Process is above memory threshold. Requesting termination."
Error Code: 0xC5B537A4
We are running with 32 GB of RAM. Does anyone have an idea why this error is occurring?
This occurs when refreshing live dashboards every 5 minutes via browser extension using the
?refresh=yes to refresh the datasource.
URL parameter. The dashboards are live-connected to Oracle DB.
Questions:
- What is the likely cause of this memory overload?
- Are there recommended settings for VizQL concurrency or memory limits to avoid this?
Appreciate any insights or similar experiences.
Hi @Chandra Sekaran Chidambaram,
your vizqlserver process instance was recycled by the SRM (Tableau Server Resource Manager) because the overall (I assume here RAM but could be CPU) has exceeded 95% of usage.
That doesn't mean here that vizqlserver is guilty, it could be other processes involved like flows and backgrounder or other softwares, as we are talking about cumulative RAM or CPU values at one point in time.
You have too analyze yourself to understand what happened. The classics are VizQLServer competing with Backgrounder, a huge Extract refresh, or a wrongly designed Dashboard that is taking a lot of resources...
You can use the Tableau utility Logshark to analyze your Logs. There will be a lot of useful pre-built workbooks generated: https://tableau.github.io/Logshark/
And when you ask "settings for VizQL concurrency or memory limits to avoid this" :
By "avoid this" you mean the crash of VizQL process or an error message on the dasbhoard ? Because setting config limits or safety nets, will protect your instance and VizQLServer process but may cause error message on the dashboards or backgrounder tasks that are causing problems. If you cannot afford to make the end users "unhappy", you can also add more RAMs...
