Deadlock while migrations

[vldmr-k]

• Lunar version: 1.0.0-beta.6
• Laravel Version: 11.37.0
• PHP Version: 8.4
• Database Driver & Version: postgres

Expected Behaviour:

Migration applying whithout any deadlocks

Actual Behaviour:

[previous exception] [object] (PDOException(code: 40P01): SQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected
DETAIL:  Process 906552 waits for ShareLock on transaction 2081153; blocked by process 906548.
Process 906548 waits for ShareLock on transaction 2081157; blocked by process 906552.
HINT:  See server log for query details.
CONTEXT:  while updating tuple (28453,1) in relation \"lunar_carts\" at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:412)
[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(412): PDOStatement->execute()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\\Database\\Connection->{closure:Illuminate\\Database\\Connection::select():398}()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run()
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(495): Illuminate\\Database\\Connection->select()
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\\Database\\DatabaseManager->__call()
#6 /var/www/html/vendor/lunarphp/core/database/state/MigrateCartOrderRelationship.php(26): Illuminate\\Support\\Facades\\Facade::__callStatic()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(459): Lunar\\Database\\State\\MigrateCartOrderRelationship->run()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(287): Illuminate\\Events\\Dispatcher->{closure:Illuminate\\Events\\Dispatcher::makeListener():454}()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(267): Illuminate\\Events\\Dispatcher->invokeListeners()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(755): Illuminate\\Events\\Dispatcher->dispatch()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(156): Illuminate\\Database\\Migrations\\Migrator->fireMigrationEvent()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(123): Illuminate\\Database\\Migrations\\Migrator->runPending()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\\Database\\Migrations\\Migrator->run()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(616): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->{closure:Illuminate\\Database\\Console\\Migrations\\MigrateCommand::runMigrations():109}()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#23 /var/www/html/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#25 /var/www/html/vendor/symfony/console/Application.php(1094): Illuminate\\Console\\Command->run()
#26 /var/www/html/vendor/symfony/console/Application.php(342): Symfony\\Component\\Console\\Application->doRunCommand()
#27 /var/www/html/vendor/symfony/console/Application.php(193): Symfony\\Component\\Console\\Application->doRun()
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()
#29 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#30 {main}
"} 

Steps To Reproduce:

1. setup default configuration https://hub.docker.com/r/bitnami/postgresql
2. setup lunar
3. in config/lunar/cart_session.php set auto_create => true
4. generate 651035 carts :) Thanks bots 🤖

select count(*) from lunar_carts;
 count  
--------
 651035
(1 row)