2.7.2 has a huge impact on latency

[SebC99]

Issue Description

When updating parse-server from 2.7.1 to 2.7.2 there's a huge impact on server latency (observed on AWS ELB)

The chart below presents the increase (at the exact minute of the update) and the decrease one week later when coming back to 2.7.1 (no other changes)

Environment Setup

• Server

  • parse-server version: Upgrading 2.7.1 to 2.7.2
  • Operating System: Nodejs with AWS ElasticBeanstalk on t2.large

• Database

  • MongoDB version: 3.6
  • Storage engine: WiredTiger
  • Localhost or remote server? Mongo Atlas

[steven-supersolid]

There's a bug in mongodb-core 3.0.x that was fixed in 3.0.4 https://github.com/mongodb-js/mongodb-core/blob/v3.0.4/HISTORY.md which is fixed in the corresponding 3.0.4 node.js driver https://github.com/mongodb/node-mongodb-native/blob/v3.0.4/HISTORY.md

The bug is increased latency (about double) on mongodb SSL connections.

parse-server 2.7.2 upgraded the driver from 2.1.17 in 2.7.1 to 3.0.1 so likely had the bug introduced there

#4603 updates the driver to 3.0.4 so will fix this in the next release

[JacobJT]

Could this affect CPU usage on EC2 as well? I.e. longer requests results in more requests staying active and waiting for their results?

[flovilmart]

@JacobJT it’s unlikely that waiting for something spiked CPU usage. The SSL bug may have caused the CPU spike

[JacobJT]

Still this same issue with Mongo, or are you referring to a different issue with SSL?

I suppose a more to the point question: Does 2.7.2 also affect CPU spikes, and reverting to 2.7.1 would reduce / eliminate them until 2.7.3 is released?

[SebC99]

@JacobJT in my case, there could be a 10% CPU increase linked to 2.7.2 but that's not that clear.

[JacobJT]

@SebC99 Thanks for the info. We had a CPU spike + massive latency, but it doesn't look like it matched up with our deployment of 2.7.2, I think it was related to some marketing e-mails causing a user spike and EB not spinning up a new server instance fast enough to handle it.

[flovilmart]

2.7.4 has been released, please update and reopen the issue if it persists.

[SebC99]

I confirm 2.7.4 fixes the issues, no more latency increase, just perfect :)