Database Transactions not working

[klferreira]

Hello everyone, i stumbled on this issue today:

When i try to use laravel's transactions like this

DB::transaction(function() use($data) {
        $this->repository->create($data);
});

I get the following:

Call to a member function beginTransaction() on null
/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php:108
/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php:92
/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php:23
/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:327
/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:221

I'm using laravel 5.4 and php version 7.1.

Is there any workaround for this issue?

This package is helping me out a lot with my personal project and i guess there is no other option for laravel and mongodb, so anything that solves it will do for me i guess.

[jim5359]

I'm having the same issue and can't seem to find a solution.

[upsilon-den]

Mongodb not support transactions.
It has another logic for this. Check https://docs.mongodb.com/manual/tutorial/perform-two-phase-commits/

[fntneves]

MongoDB 4.0 now supports multi-document transactions.

@jenssegers Any chance to have transactions working here?
Let me know if you need help.

[coolsam726]

Any update on this @jenssegers ?

[eleazarbr]

This would be another excellent feature of the package!

[deyikong]

Any update on this @jenssegers ?

[ycgambo]

use DB::connection('mongodb')->getMongoClient() to access original MongoDB\Driver and use DB::connection('mongodb')->getMongoClient()->startSession() to create a session and then start a transaction.

[leong918]

DB::connection('mongodb')->getMongoClient()->startSession() does not work, even i use getDatabase method. but dont have this function.

got any idea two collection if got error, rollback the data.

[ycgambo]

mongo transaction is a little different from mysql. you need to create a session first, and pass this session as a option when you do update.

[leong918]

@ycgambo How to create a session and pass the session as option by using laravel-mongodb ?

[salalaslam]

I got it working like this

$session = DB::getMongoClient()->startSession();
$session->startTransaction();
try {
    // Perform actions.
    $session->commitTransaction();
} catch(Exception $e) {
    $session->abortTransaction();
}

As answered here