Try/catch block and unhandled promise exception

Question

I wanted to test my async function querying a table which does not exist. Therefore the error is generated on purpose.

async function getPosts() {
  try {
    const connection = await dbConnection()
    const result = await connection.query('SELECT * FROM x')
    await connection.release()
    console.log(result)
  }
  catch(ex) {
     throw new Error(ex)
  } 
}

When I call that function:

UnhandledPromiseRejectionWarning: Error: Error: ER_NO_SUCH_TABLE: Table 'test.x' doesn't exist.

Can you tell me why?

Answer 1

You're getting UnhandledPromiseRejectionWarning because you're not adding a .catch handler to getPosts()

---

getPosts()
  .then(console.log)
  .catch(console.error); // You're missing this

Or using async/await

try {
    const posts = await getPosts();
    console.log(posts);
} catch(e) { // Missing this
    console.error(e); 
}

There is no need to add a try/catch on your getPosts function if you're going to throw the error again without any modification. Just let it bubble up, and handle the error when calling getPosts() as shown above.

async function getPosts() {

    const connection = await dbConnection()
    const result = await connection.query('SELECT * FROM x')
    await connection.release()
    return result;
}

---

Regarding your current error, you're trying to perform a query on a table that doesn't exist.

You can learn more about this in the following question: What is an unhandled promise rejection?