ISSUE: MySQL/MariaDB server (Windows 2022 Server GCP VM) CPU maxed out by flurry of Retool connections.
- None of my Retool workflows recorded a log or were running at the time the issue began.
- The issue has been temporarily resolved by disabling the MySQL resource on Retool; however, I rely heavily on this resource with several apps and workflows connected.
- The resource connection and workflows have been tested and working prior to this issue. No changes to the server or GCP have been made.
Additional Details:
- Last week I started to get CPU alerts from GCP and last Friday the server effectively went down.
- GCP and MySQL logs confirmed a flurry of connections from Retool before ultimately CPU usage maxed and the MySQL service had to be manually stopped and restarted.
- Each time the issue would crop back up within minutes with another flurry of Retool connections.
SQL Log entries that started at 2023-06-23 15:06:25 and continued until I disabled the resource in Retool
2023-06-23 15:06:25 11478 [Warning] Aborted connection 11478 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (Got an error reading communication packets)
2023-06-23 15:06:25 11478 [Warning] Aborted connection 11478 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
2023-06-23 15:06:25 11479 [Warning] Aborted connection 11479 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (Got an error reading communication packets)
2023-06-23 15:06:25 11479 [Warning] Aborted connection 11479 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
2023-06-23 15:06:26 11480 [Warning] Aborted connection 11480 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (Got an error reading communication packets)
2023-06-23 15:06:26 11480 [Warning] Aborted connection 11480 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
GCP log (redacted):
I have pages of logs like this. My workflows/apps are not this active so the server/CPU issue notwithstanding, I'm not sure why I have so connections from Retool.