Cannot catch QueryException in Laravel

Question

I'm trying to catch a QueryException error in a try/catch block. I'm running a migrate:fresh command from the terminal and setting some config values. I want to rule out some exceptions and catch this error if it appears. I tried everything but could not seem to succeed.

Command

php artisan migrate:fresh --seed

Error

Illuminate\Database\QueryException SQLSTATE[08006] [7] FATAL: database "x" does not exist (SQL: select tablename from pg_catalog.pg_tables where schemana*me in ('public'))

Code

try {
    DB::purge('pgsql');
    Config::set('database.connections.pgsql.database', $config['database']);
    Config::set('database.connections.pgsql.username', $config['username']);
    Config::set('database.connections.pgsql.password', $config['password']);
} catch (\Throwable $e) {
    dd($e); //it never gets here
    Log::error($e->getMessage());
}

I also tried

catch (\Illuminate\Database\QueryException $e) 
catch (\Exception $e)
catch (\PDOException $e)

Is there any way to do this?

Is the exception thrown in `php artisan migrate:fresh --seed`? How does the rest of the code relate to that? — apokryfos, Jan 05 '22 at 11:35
The command triggers a function in which I have the try/catch block. I tried both \QueryException and \PDOException. — Ana-Maria Milea, Jan 05 '22 at 13:03

score 1 · Answer 1 · answered Jan 05 '22 at 13:13

1

After hours of trying, I managed to catch the error. The $this->laravel->call([$this, 'handle']) was in another class and this is where the try/catch block should actually be.

answered Jan 05 '22 at 13:13

Ana-Maria Milea

11
3

Cannot catch QueryException in Laravel

1 Answers1