DB::transaction(), DB::commit() & DB::rollBack() issues

@Snapey Yes, I do reach it. I dumped some dumb things like "rollbacked" and could have the message, but the first part of my transaction still got persisted for some reason.

@gollumeo-109650634 try moving your Transaction statement to just inside the try catch

        try {
            DB::beginTransaction();

@Snapey As you can notice in the below code, I've just tried it, yet my real estate still gets saved although I'm getting proper ValidationExceptions

    public function __invoke($tierId, Request $request)
    {
        $newEstateRules = [
            'type' => ['bail', 'required', Rule::enum(Type::class)],
            'usage' => ['bail', 'required', Rule::enum(Usage::class)],
            'start_lease' => ['bail', 'required', 'date', 'date_format:Y-m-d'],
            'end_lease' => ['bail', 'date', 'date_format:Y-m-d', 'nullable', 'after_or_equal:start_lease'],
            'street' => 'required',
            'number' => 'required',
            'box' => 'nullable',
            'zip_code' => 'required',
            'city' => 'required',
            'country' => 'required'
        ];

        $newRealEstateByExRules = [
            'bookyear' => ['required', 'integer'],
            'percentage_pro' => ['bail', 'required', 'numeric', 'digits_between:0,100'],
            'yearly_rent_account' => ['required', 'integer'],
            'rental_advantage' => ['nullable', 'numeric'],
            'rental_advantage_account' => ['nullable', 'integer'],
            'is_furnished' => 'boolean',
            'has_late_payment' => 'boolean',
            'late_payment' => ['nullable', 'numeric'],
            'rc' => ['required', 'numeric'],
        ];

        $rentalsRules = [
            'rentals.*.bookyear' => ['required', 'integer'],
            'rentals.*.date' => ['required', 'date', 'date_format:Y-m-d'],
            'rentals.*.amount' => ['required', 'numeric'],
            'rentals.*.real_estate_id' => ['required', 'integer'],
            'rentals.*.id' => ['nullable', 'integer'],
        ];


        try {
            DB::beginTransaction();
            $tier = Tier::findOrFail($tierId);

            $realEstateValidator = Validator::make($request->all(), $newEstateRules);
            $realEstateValidated = $realEstateValidator->validate();
            $realEstateValidated['tier_id'] = $tier->id;

//            dd($realEstateValidated);

            $realEstate = RealEstate::create($realEstateValidated);

            $realEstateByExValidator = Validator::make($request->all(), $newRealEstateByExRules);
            $realEstateByExValidated = $realEstateByExValidator->validate();
            $realEstateByExValidated['real_estate_id'] = $realEstate->id;

            RealEstateByEx::create($realEstateByExValidated);

            $rentalsValidator = Validator::make($request->all(), $rentalsRules);
            $rentalsValidated = $rentalsValidator->validate();

            RealEstateRental::upsert($rentalsValidated['rentals'], 'id');

            DB::commit();

            return response()->json(['message' => 'Les loyers ont été enregistrés avec succès'], 200, [], JSON_PRETTY_PRINT);

        } catch (Exception|ValidationException $e) {
            DB::rollBack();
            throw new ApiException($e->getMessage(), 500);
        }
    }

@gollumeo-109650634 just do database work inside transaction, not validation

@Snapey it did work, thanks!! I didn't catch that transactions were only rollbacking on SQL Exceptions, so thanks for this as well :D