Heavy CPU load on only one of the server behind ALB

Get Help
1

Hi,

We have 2 server behind the ALB as part of horizontal scaling. But One of the server have high CPU and one have low. If we replace the higher CPU server then again load goes on only one of the server.

Is that metabase run any specific type of load on single server and not on others.

Stickiness is disabled on ALB.

Thanks,
Prayag Patel

2

Hi @prayag.p
Please post "Diagnostic Info" from Admin > Troubleshooting.
The load balancer should distribute the load, but each instance also does some internal processes like sync and scan, though these are also shared between the instances.
Check the logs to see what each instance is doing - Admin > Troubleshooting > Logs.

3

Please find the Diagnostic Info as below.

{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9-Ubuntu-0ubuntu2.20.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9-Ubuntu-0ubuntu2.20.04",
"os.name": "Linux",
"os.version": "5.4.0-1048-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"mysql",
"mongo",
"bigquery",
"h2",
"redshift"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.34-log"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2021-05-17",
"tag": "v0.39.2",
"branch": "release-x.39.x",
"hash": "b0d9436"
},
"settings": {
"report-timezone": "Asia/Calcutta"
}
}
}

4

@prayag.p Can you try downgrading to 0.39.1 and see if the problem still happens there?
We're investing a problem, which seems to have started from 0.39.2, but we have no idea on how to reproduce the problem, which seems to be causing high CPU for some.

5

@flamber Facing the same issue on version 0.39.1 also.

6

@prayag.p Okay, check the logs to see what Metabase is doing - Admin > Troubleshooting > Logs.