Error SQL ER_DUP_ENTRY not try/ catcher : completely crash adonis (nodejs) server

[titoff002]

Good evening,

I use adonis v6 + lucid + mysql 8XXX.

So I want to insert a new row into my mysql table.

My problem occurs when the mysql driver detects a "duplicate key" error:

• what is surprising is that my actions in the controller and function are trty/catcher but that this error does not enter at all in the try / catch and completely crash adonisjs (I have to do an npm run dev again).
• this error is not caught by any of the "try/catch" blocks

here is my code (on controller) :

 public async saveTenant (payload: any, userId: number) {
  try {
    const tenant = new Tenant()
    if (payload.email) {
      tenant.email = payload.email
    }
    if (payload.phone_number) {
      tenant.phone_number = payload.phone_number
    }
    tenant.nom = payload.nom.trim()
    tenant.pnom = payload.pnom.trim()
    tenant.userId = userId 
  
    tenant.save()
  } catch (err) {
    throw new Error('Duplicate entry detected. Please use a unique value.')
  }

 }

  async addTenant({ request, response, session, auth }: HttpContext) {
    try {
      const payload = await request.validateUsing(postTenant)
      // const existingUser = await Tenant.findBy('nom', payload.nom, 'pnom', payload.pnom)
      this.saveTenant (payload, auth?.user?.id ??  -1)

      session.flash('success', {
        message: `Votre locataire a été enregistré avec succès ! 🏡✨`
      })
      return response.redirect().back()
    } catch (err) {
      session.flash({ showOTP: false });
      if (err.code === 'ER_DUP_ENTRY') { return response.status(400).json({ message: 'Duplicate entry detected. Please use a unique value.', }); }
      if (typeof err === 'object' && err?.code === 'E_ROW_NOT_FOUND') {
        session.flash('errors', {
          message: "Une erreur est survenue lors de l'ajout de votre locataire. Veuillez recommencer !"
        })
      } else {
        session.flash('errors', {
          message: (err?.messages ?? err?.messages)
        })
      }

      return response.redirect().back()
    }
  }

 ........

I don't understand why this happens (this is the first time I've encountered this problem).
so if you have a solution: I'm interested

(because I don't want to do an additional SQL query checking the existence or not of the tuple before doing make "lucid tenant.save()")

Thank you for your help and have a nice day.

[titoff002]

arfff ...

I found my error 'tenant.save()'
I had forgotten to put "await" in front of 'await tenant.save()' ....

thank you