LibsqlError: SERVER_ERROR: Server returned HTTP status 404

try {
      const response = await db.transaction(async (tx) => {
        const [{ insertedOrderId }] = await tx
          .insert(orders)
          .values({ id, totalPrice, customerId, obs })
          .returning({ insertedOrderId: orders.id })

        for (const { id, quantity, customProductPrice, obs } of products) {
          const product = await tx.select().from(productsSchema).where(eq(productsSchema.id, id)).get()

          if (!product) {
            throw new Error(`Product with ID ${id} not found`)
          }

          const updatedProductAvailableQuantity = (product?.availableQuantity ?? 0) - quantity

          await tx
            .update(productsSchema)
            .set({ availableQuantity: updatedProductAvailableQuantity })
            .where(eq(productsSchema.id, product.id))

          await tx.insert(ordersProducts).values({
            orderId: insertedOrderId,
            productId: product.id,
            productCostPrice: product.costPrice,
            productPrice: product.price,
            customProductPrice,
            quantity,
            obs,
          })
        }

        const response = await tx.select().from(orders).where(eq(orders.id, insertedOrderId)).get()

        if (!response) {
          throw new Error('Failed to create order')
        }

        return response
      })

      if (!response) {
        throw new Error('Transaction failed')
      }

      return response
    } catch (error) {
      console.error('Transaction error:', error)
      throw error // Re-throw the error to be handled by the caller
    }

try {
      const response = await db.transaction(async (tx) => {
        const [{ insertedOrderId }] = await tx
          .insert(orders)
          .values({ id, totalPrice, customerId, obs })
          .returning({ insertedOrderId: orders.id })

        for (const { id, quantity, customProductPrice, obs } of products) {
          const product = await tx.select().from(productsSchema).where(eq(productsSchema.id, id)).get()

          if (!product) {
            throw new Error(`Product with ID ${id} not found`)
          }

          const updatedProductAvailableQuantity = (product?.availableQuantity ?? 0) - quantity

          await tx
            .update(productsSchema)
            .set({ availableQuantity: updatedProductAvailableQuantity })
            .where(eq(productsSchema.id, product.id))

          await tx.insert(ordersProducts).values({
            orderId: insertedOrderId,
            productId: product.id,
            productCostPrice: product.costPrice,
            productPrice: product.price,
            customProductPrice,
            quantity,
            obs,
          })
        }

        const response = await tx.select().from(orders).where(eq(orders.id, insertedOrderId)).get()

        if (!response) {
          throw new Error('Failed to create order')
        }

        return response
      })

      if (!response) {
        throw new Error('Transaction failed')
      }

      return response
    } catch (error) {
      console.error('Transaction error:', error)
      throw error // Re-throw the error to be handled by the caller
    }