transaction - laravel transaction does not commit. I don’t know where I wrote it wrong.

Question

laravel transaction is not committed. I don’t know where I wrote it wrong

The following is the code
DB::transaction(function () use ($payment,$userBalance) {

            Payment::insert($payment);
            $userName = $payment['payment_user_name'];
            User::where('user_name', $userName)
                 ->increment('user_balance', $userBalance);
        });
        
        
        跪求指教

Answer 1

DB::transaction(function () use ($payment,$userBalance) {
         try {
            Payment::insert($payment);
            $userName = $payment['payment_user_name'];
            User::where('user_name', $userName)->increment('user_balance', $userBalance);
         } catch (\Exception $e) {
            var_dump($e);
            exit;
         }
});

Answer 2

//打印输出下sql 看是否有问题，因为在 transaction 闭包若抛出任何异常会导致事务自动回滚
\DB::listen(function ($sql,$bind) { 
   dump($sql,$bind);
}