MariaDB NodeJS backend : too many connections

I have a NodeJS express backend which uses a MariaDB database.

My file dbconnect.js creates a mariadb pool and has a function to make queries.

const mariadb = require('mariadb');
const pool = mariadb.createPool({ 
  host: process.env.DBHost, 
  user: process.env.DBUser, 
  database: process.env.DB, 
  password: process.env.DBSecret 
});

const dbQuery = async(query) => {
    let conn;
    let res = '';
    try {
        conn = await pool.getConnection();
        res = await conn.query(query);
    } catch (err) {
        console.log("Error sending Query: ", query, err.text);
    } finally {
        if (conn) {
            conn.end();
        }
        return res;
    }
}

Everything seems to work perfectly, but after a few months with the server running these messages begin to appear on the console:

These messages keep appearing every 10-14 seconds, but no queries are being performed.

Thanks for any help

I am not sure but there is one way,

configure your connection pool to ping at particular time. so it will close any inactive connections before the server closes them. mariadb has pingInterval for this

Replace this code with your code

<!-- begin snippet: js hide: false console: true babel: false -->

<!-- language: lang-js -->

const pool = mariadb.createPool({
  host: process.env.DBHost,
  user: process.env.DBUser,
  database: process.env.DB,
  password: process.env.DBSecret,
  pingInterval: 60000
});

<!-- end snippet -->

This will send a ping to the server every 60 seconds, which will prevent the server from closing inactive connections.