Deployment error: SQLSTATE[HY000]

Last update: July 27, 2023

CREATED FOR:

  • Developer

This article provides a solution for the issue where deployment fails because of the SQLSTATE[HY000] error.

Affected products and versions

Issue

An SQLSTATE error occurs during deployment.

Updating modules:
SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_565c_0.MAD' (Errcode: 24 "Too many open files"),

Cause

Cron running during deployment.

Solution

To resolve the issue, stop cron from running by opening the command line and running the following command:
./vendor/bin/ece-tools cron:disable.

Previous pageEnvironment redeployment failed or MySQL server gone away
Next pageDeployment issues relating to account permissions and access keys

Commerce