'React - Node app Intermittently failing to connect to mysql

I have a React/Node App that connects to a Google Cloud SQL database. Getting the data for the dropdowns works but occasionally during the "Get dropdown data" part it fails with:

Error: connect ETIMEDOUT
[server]     at PromisePool.query (C:...\server\node_modules\mysql2\promise.js:340:22)
[server]     at Object.exports.getServiceType (C:..\server\helper\dropdown.js:23:44)
[server]     at C:...\server\routes\searchResourceRoute.js:21:103
[server]     at processTicksAndRejections (node:internal/process/task_queues:96:5) {
[server]   code: 'ETIMEDOUT',
[server]   errno: undefined,
[server]   sqlState: undefined,
[server]   sqlMessage: undefined
[server] }

// Make poolection to database
    let pool = await db;

    // Get dropdown data
    [ageGroupType, serviceType, cities] = await Promise.all([dropdown.getAgeGroupType(pool), dropdown.getServiceType(pool), dropdown.getCities(pool)]);

 exports.getServiceType = async (pool) => {
  // Create query params
  const sql = 'SELECT * FROM ServiceType';

  // Query database and get notification
  const [serviceType, fields] = await pool.query(sql);
  return serviceType;
}

I'm guessing that calling for the data sets is why the timeout. What's a better way to do this?

mysqlnode.jsreactjshtmlcssflexbox


Solution 1:[1]

.d-flex {
  display:flex;
}

.flex-column {
  flex-direction: column;
}

.align-items-center {
  align-items: center;
}
<div class="d-flex flex-column align-items-center">
  <div>centered content1</div>
  <div>centered content2</div>
  <div style="align-self: start;">I want to be this content to be left-aligned</div>
  <div>centered content3</div>
  <div>...</div>
</div>

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Nikhil Parmar

Related Questions