ECONNRESET with Node JS and MySQL server

1

Hello,

My problem is my API performs to connect but gets interrupted by ECONNRESET randomly, even sometimes when there is low traffic.

I use node js, the mysql2 library and pools, here is how :

db = mysql.createPool({
host: process.env.HOST,
user: process.env.USER,
password: process.env.PASSWORD,
database: process.env.DATABASE,
waitForConnections: true,
connectionLimit: 60,
queueLimit: 100,
port: process.env.PORT || 3306,
enableKeepAlive: true,
keepAliveInitialDelay: 0,
});

and here is for example one route that works but is often blocked by ECONNRESET :

app.get(‘/reservations/all’, authenticate, async (req, res) => {
console.log(“OK”);

const id_loueur_global = req.user.id; // Récupérer id_loueur_global depuis req.body

try {
    // Base de la requête SQL
    let query = `
    SELECT 
        r.id_reservation,
        r.retour, 
        r.id_loueur
    FROM reservations r

    `;
    
    // Ajouter une clause WHERE si id_loueur_global est fourni et valide
    const queryParams = [];
    if (!isNaN(id_loueur_global)) {
        query += 'AND v.id_loueur_global = ? ';
        queryParams.push(id_loueur_global);
    }

    const [results] = await db.query(query, queryParams);

    res.status(200).json(results);
} catch (error) {
    console.error('Erreur lors de la récupération des réservations:', error);
    res.status(500).json({ message: 'Erreur lors de la récupération des réservations.' });
}

});

I thought it was my MYSQL host CleverCloud that was blocking connexions but I changed for Hostinger and I still have ECONNRESET.

Thanks !