Level 50
That's the stack trace. What's the error message?
Sep 11, 2024
10
Level 3
issue with jobs and queue
after ran the queue:work
am getting error
[stacktrace]
#0 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\ManagesTransactions.php(141): Illuminate\\Database\\Connection->handleBeginTransactionException(Object(Error))
#1 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\ManagesTransactions.php(115): Illuminate\\Database\\Connection->createTransaction()
#2 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\ManagesTransactions.php(23): Illuminate\\Database\\Connection->beginTransaction()
#3 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\DatabaseQueue.php(223): Illuminate\\Database\\Connection->transaction(Object(Closure))
#4 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(345): Illuminate\\Queue\\DatabaseQueue->pop('default')
#5 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(354): Illuminate\\Queue\\Worker->Illuminate\\Queue\\{closure}('default')
#6 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Worker.php(159): Illuminate\\Queue\\Worker->getNextJob(Object(Illuminate\\Queue\\DatabaseQueue), 'default')
#7 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon('database', 'default', Object(Illuminate\\Queue\\WorkerOptions))
#8 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Queue\\Console\\WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker('database', 'default')
#9 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()
#10 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#11 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#12 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#13 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#14 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(136): Illuminate\\Container\\Container->call(Array)
#15 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\symfony\\console\\Command\\Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#16 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#17 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\symfony\\console\\Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#18 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\symfony\\console\\Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#19 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\symfony\\console\\Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#20 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#21 C:\\xampp\\htdocs\\redwing-backend-laravel\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Console\\Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#22 C:\\xampp\\htdocs\\redwing-backend-laravel\\artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#23 {main}
"}
Level 3
@JussiMannisto local.ERROR: Call to a member function beginTransaction() on null {"exception":"[object] (Error(code: 0): Call to a member function beginTransaction() on null at C:\xampp\htdocs\redwing-backend-laravel\vendor\laravel\framework\src\Illuminate\Database\Concerns\ManagesTransactions.php:175) [stacktrace]
Level 50
@UmaWorld What database do you use?
Level 3
@JussiMannisto mongodb
Level 6
@UmaWorld Shows the code as well please
Level 3
@Chingy dispatch job in observer
{
if ($task->assignee) {
TaskAssigned::dispatch($task);
}
$task->reOpenParentTasks();
// Invalidate cache for the specific task's worksheet and cache the task list again
$worksheetId = $task->worksheet_id;
$userId = $task->assignee;
Cache::forget('tasks_by_worksheet_' . $worksheetId . '_index');
Cache::forget('user_' . $userId);
// $this->cacheTaskList($worksheetId);
CacheTaskList::dispatch($worksheetId);
}```
CacheTaskList
``` public function handle()
{
Log::info('cacheTaskList is being processed ');
// **1. Cache for All Tasks of the Worksheet**
// Create the cache key for all tasks in the worksheet
$allTasksCacheKey = 'tasks_by_worksheet_' . $this->worksheetId . '_all';
// Fetch all tasks related to the worksheet
$allTasks = Task::where('worksheet_id', $this->worksheetId)
->orderBy('seq', 'asc')
->get();
// Store all tasks in the cache
Cache::put($allTasksCacheKey, $allTasks, now()->addDays(30));
// **2. Cache for User-Specific Tasks in the Worksheet (if userId is provided)**
if ($this->userId) {
// Create the cache key for user-specific tasks
$userTasksCacheKey = 'tasks_by_worksheet_' . $this->worksheetId . '_user_' . $this->userId;
// Fetch the tasks related to the worksheet and specific user
$userTasks = Task::where(['worksheet_id' => $this->worksheetId])
->where('assginee', $this->userId)
->orderBy('seq', 'asc')
->get();
// Store user-specific tasks in the cache
Cache::put($userTasksCacheKey, $userTasks, now()->addDays(30));
}```
Level 6
Are you having nested DB transactions?
Level 3
@Chingy i think no
Level 3
because of this error , i could not able to see log message in terminal
Level 3
anyone can help?
Please or to participate in this conversation.