ImportAction job is failing but there is no error message

I have simple table with dozens of fields. Nothing special. I want to import records with Filament ImportAction. I am able to select file, then I get to choose to map CSV fields with database fields. After I click import, the job is dispatched, but the problem is that job is never completed. I see in my terminal window where I am running php artisan queue:work that ImportCsv job is failing: 2024-03-13 19:36:32 Filament\Actions\Imports\Jobs\ImportCsv .............................................................................. RUNNING 2024-03-13 19:36:32 Filament\Actions\Imports\Jobs\ImportCsv ......................................................................... 56.26ms FAIL And the job is running and failing, running and failing over and over again. But the job is never added to fail_jobs table. I get import error for every row in the CSV file and my failed_import_rows table is filled with thousand of records but for each row validation_error field is set to NULL. My CSV file is not big it has 65 rows, so that should be 65 records but the job is stuced in a loop. I need to stop laravel queue worker and delete the job from the jobs table. This is how I run my queue worker
php artisan queue:work --tries=3
php artisan queue:work --tries=3
5 Replies
JJSanders
JJSanders4mo ago
Did you check your laravel.log?
tjodalv
tjodalv4mo ago
This is my error log from laravel.log file
JJSanders
JJSanders4mo ago
It says exactly where the error is. Did you read it?
tjodalv
tjodalv4mo ago
you mean this file: /var/www/html/vendor/filament/actions/src/Imports/Jobs/ImportCsv.php:160 In that file line 160 filament is throwing an exception saying too many exceptions. This is my failed_import_rows table
No description
JJSanders
JJSanders4mo ago
Maybe look in your import action. There seems to be a mistake in the query As you get a QueryException