Alrighty, so I took a look into it. I was also getting the error with MySQL, and it was indeed a code issue! I accidentally missed binding the organization to the transaction, which caused the decrement to run outside the confinement of the transaction - hence the lock block.

Below is the updated code that fixes this issue! Terribly sorry about the miss here! I'll get a note about this added into the lesson.

export default class DestroyLesson {
  static async handle({ organization, id }: Params) {
    const lesson = await organization.related('lessons').query().where({ id }).firstOrFail()

    await db.transaction(async (trx) => {
      lesson.useTransaction(trx)
      organization.useTransaction(trx) // 👈

      await lesson.delete()
      await organization
        .related('lessons')
        .query()
        .where('moduleId', lesson.moduleId)
        .where('order', '>', lesson.order)
        .decrement('order')
    })

    return lesson
  }
}

  

    

      Copied!