ERPNext v15 - Request Timeout and MariaDB Too Many Connections Error on Frappe Cloud

ERPNext Accounting
1

ERPNext Version: 15.x
Hosting: Frappe Cloud

Issue:
Intermittent delays while opening and creating invoices.

Error:
pymysql.err.OperationalError: (1040, ‘Too many connections’)

Traceback occurs while:
frappe.desk.reportview.get_count

Please help check:

  • MariaDB max_connections
  • Connection usage
  • Long running queries
  • Worker resource usage
  • Database saturation
2

Hi @gayatriK

Search in the awesome bar for these two tools from Frappe which can maybe give you a clue: -

  1. Recorder

  2. System Health

Best of luck in your ERPNext journey

3

@gayatriK you can check in these things in mariadb
1. Check maximum allowed connections
SHOW VARIABLES LIKE ‘max_connections’;

2. Current active connections
SHOW STATUS LIKE ‘Threads_connected’;

3. Maximum connections used since server start
SHOW STATUS LIKE ‘Max_used_connections’;

4. Currently running threads
SHOW STATUS LIKE ‘Threads_running’;

5. Total connections since startup
SHOW STATUS LIKE ‘Connections’;

6. Failed connection attempts
SHOW STATUS LIKE ‘Aborted_connects’;

7. Current process list
SHOW FULL PROCESSLIST;

4

We are hosted in Frappe cloud and Our plan doesn’t allow to access MariaDB.

5

@gayatriK you can simply explore frappe cloud dashboard and can see the things which slowing your instance like slow queries, api requests taking more time and if you can access SSH on your instance do it and in bench –site <site_name> mariadb you can check for above queries.

6

@gayatriK