Laravel 11 DB Transaction and Validation Order Issue

[Abhishek-Jetani]

Laravel Version

11.15.0

PHP Version

8.2.0

Database Driver & Version

Mysql & 5.2.0

Description

In Laravel 10 and previous versions, the following code worked perfectly without any issues. However, in Laravel 11, I encountered a problem when using database transactions with validation.

Issue:

When I add DB::beginTransaction(); above the validation code, the validation messages do not display in the Blade view file.

Steps To Reproduce

1. Add DB::beginTransaction(); before the validation logic.

2. Perform validation.

3. If validation fails, the error messages do not show up in the Blade view file.

Non-working Code:

Solutions:

1. Solution 1:
   Adding DB::rollBack(); above the redirect statement with errors works.
   

2. Solution 2:
   Moving DB::beginTransaction(); after handling validation errors works perfectly.
   

Question:
Is this a bug in Laravel 11, or have there been any changes to the database methods that could cause this issue? This code works without any issues in Laravel 10 and previous versions.

Thank you for your time and assistance.

[ghost]

What you just posted is just common sense :)

[Abhishek-Jetani]

😏

[Abhishek-Jetani]

I would like to determine whether this is a bug or if there have been changes to the database transaction methods in Laravel 11 that could be causing this problem.