How to remove all queued jobs because it's causing errors?

laravel laravel-5 laravel-queue
Joshua Leung picture Joshua Leung · Nov 9, 2017 · Viewed 9.6k times · Source

My website queues email sending jobs to the jobs table. I think the email server has some problem and it can't send emails so the jobs are stuck at the jobs table. Now maybe there are too many jobs, and I receive this error message:

Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'attempts' at row 1 (SQL: update `jobs` set `reserved_at` = 1510263884, `attempts` = 256 where `id` = 342)' in /var/www/vhosts/parcgilley.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647
#0 /var/www/vhosts/parcgilley.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('update `jobs` s...', Array, Object(Closure))
#1 /var/www/vhosts/parcgilley.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(477): Illuminate\Database\Connection->run('update `jobs` s...', Array, Object(Closure))
#2 /var/www/vhosts/parcgilley.com/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(416): Illuminate\Database\Connection->affectingStatement('update `jobs` s...', Array)

So I am wondering how do I flush all the queued jobs to clear the table? I can't access the database to remove the data in the table, so is there any command line to do so? I don't have a failed queue table.

Answer

Marcin Nabiałek picture Marcin Nabiałek · Nov 9, 2017

Assuming you are using database driver you can use:

DB::table('jobs')->delete();

to delete all the jobs.

The other thing is that you should always run queue worker with attempts set:

php artisan queue:work --tries=3

Also remember that whenever you change your application code, you should restart your workers:

php artisan queue:restart

( I assume you use supervisor that will start workers again).

Related questions

when using laravel queue job processing, getting stuck

i am on 5.3.31 so it cannot be related to https://github.com/laravel/framework/issues/15179 after 300ish jobs I get: [2017-04-11 13:51:53] local.ERROR: Symfony\Component\Debug\Exception\FatalThrowableError: Call to a member function beginTransaction() on null in /var/www/…

Read More
Laravel 5 Run queue:work on laravel schedule

I have a schedule like this: <?php namespace App\Console; use Illuminate\Support\Facades\Artisan; use Illuminate\Console\Scheduling\Schedule; protected function schedule(Schedule $schedule) { Artisan::call('queue:work'); } I add this on my cronjob: * * * * * cd /var/www/html/…

Read More
Laravel Checking If a Record Exists

I am new to Laravel. Please excuse the newbie question but how do I find if a record exists? $user = User::where('email', '=', Input::get('email')); What can I do here to see if $user has a record?

Read More