Causing Too many connections error on mysql server

[abisao1]

Causing Too many connections error on mysql server

[smanask]

In the finally block, you are calling dbConnection.end, but it seems like there's a missing pair of parentheses (). It should be dbConnection.end() to actually invoke the method.

The correct code should be:

finally {
    // Terminate connection to the database
    dbConnection.end();
}

Without them, it won't execute the method and the database connections may not be closed correctly, leading to "Too many connections".

You might also consider using pooling to manage database connections, especially in scenarios with multiple concurrent requests.

[abisao1]

In the finally block, you are calling dbConnection.end, but it seems like there's a missing pair of parentheses (). It should be dbConnection.end() to actually invoke the method.

The correct code should be:

finally {
    // Terminate connection to the database
    dbConnection.end();
}

Without them, it won't execute the method and the database connections may not be closed correctly, leading to "Too many connections".

You might also consider using pooling to manage database connections, especially in scenarios with multiple concurrent requests.

The issue has been resolved. Thank thank you for the heads-up.

[Ejayz]

Hi is this problem solved ? I am also using nextjs with seperate db.ts file and i just call this file

"use strict";
import mysql from "mysql2/promise";
import * as dotenv from "dotenv";
dotenv.config();
const { DB_HOST, DB_USER, DB_PASSWORD, DB_NAME } = process.env;

 const Connection=async ()=>{
  return  mysql.createConnection({
    host: DB_HOST,
    user: DB_USER,
    password: DB_PASSWORD,
    database: DB_NAME,
    waitForConnections: true,
    connectionLimit: 10,
    idleTimeout: 5000,
    queueLimit: 0,
  });
 }

Connection().then((res)=>{
  console.log(res)
}
).catch((err)=>{
  console.log(err)
})
console.log( Connection());

export default Connection;

But getting error too of too many connection after several queries . Have you checked the process and connection stats of your mysql if proccesses are being stopped ?

as you can see in the image it keeps on increasing the process but it is true that the connection is dropped . Will this be about me importing the db.ts file?

[Ejayz]

Hi is this problem solved ? I am also using nextjs with seperate db.ts file and i just call this file

@Ejayz, it looks like you're already following this thread on #2362 🕵🏻

Both actually lol. But yea . my issue is fixed also .

[abisao1]

Hi is this problem solved ? I am also using nextjs with seperate db.ts file and i just call this file

import mysql from "mysql2/promise";
import * as dotenv from "dotenv";
dotenv.config();
const { DB_HOST, DB_USER, DB_PASSWORD, DB_NAME } = process.env;

 const Connection=async ()=>{
  return  mysql.createConnection({
    host: DB_HOST,
    user: DB_USER,
    password: DB_PASSWORD,
    database: DB_NAME,
    waitForConnections: true,
    connectionLimit: 10,
    idleTimeout: 5000,
    queueLimit: 0,
  });
 }

Connection().then((res)=>{
  console.log(res)
}
).catch((err)=>{
  console.log(err)
})
console.log( Connection());

export default Connection;

But getting error too of too many connection after several queries . Have you checked the process and connection stats of your mysql if proccesses are being stopped ? as you can see in the image it keeps on increasing the process but it is true that the connection is dropped . Will this be about me importing the db.ts file?

Yes it has been resolved. Thanks!

[wellwelwel]

Hi is this problem solved ? I am also using nextjs with seperate db.ts file and i just call this file

@Ejayz, it looks like you're already following this thread on #2362 🕵🏻