laravel-mongodb: Database Transactions not working

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.

About this issue

Original URL
State: closed
Created 7 years ago
Reactions: 3
Comments: 40 (3 by maintainers)

Most upvoted comments

MongoDB 4.0 now supports multi-document transactions.

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

+34

fntneves on Jul 4, 2018

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

+21

salalaslam on Mar 21, 2019

Any update on this @jenssegers ?

coolsam726 on Aug 24, 2018

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.

ycgambo on Jan 7, 2019

@fidan-mkdir It seems to be included in the eloquent with jessengers and it seems to work properly with beginTransaction/commit/rollback I tested it with it and transaction seems to be working good.

julio-mesa on Jan 11, 2021

This would be another excellent feature of the package!

eleazarbr on Sep 3, 2018

PR with implementation https://github.com/jenssegers/laravel-mongodb/pull/1904

Smolevich on Jan 22, 2020

@leoku7020 you should do update on the mongo document object (not the model)

ycgambo on Jun 1, 2019

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

upsilon-den on Oct 24, 2017

Just a friendly reminder. If you have multiple database connection, make sure you define it first before you initialize transaction. File : config/database.php

...
'connections' => [
    ...
    'mongodb' => [
        // Your mongo db config
    ]
]
...

Then, you can use @salalaslam’s answer

File : app/Controllers/YourController.php

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

fendis0709 on Jan 26, 2021

$session = DB::connection('mongodb')->getMongoClient()->startSession();
$session->startTransaction();
try {
    DB::connection('mongodb')->collection('table1')->updateMany($data1);
    $session->commitTransaction();
    return true;
} catch (\Exception $e) {
    $session->abortTransaction();
    return false;
}

 MongoDB\Driver\Exception\RuntimeException

  Multi-document transactions are not supported by this server version

I get the error like this, please help me

Laravel 8 and “jenssegers/mongodb”: “^3.8.0”

Hello,

Let me guess, you’re using one server? MongoDB transactions does work only with replica sets and sharded clusters.

Thanks!

divine on Oct 26, 2020