Comment résoudre l’erreur « MySQL server has gone away » lors de l’import massif de données avec Laravel

    
namespace App\Jobs;

use App\Models\Personnality;
use Illuminate\Bus\Batchable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Queue\Queueable;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Queue\SerializesModels;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Storage;

class ProcessPersonnalityChunk implements ShouldQueue
{
    use Queueable, InteractsWithQueue, SerializesModels;
    use Batchable;

    public int $tries = 3;
    public int $timeout = 300;

    public string $file;

    public function __construct(string $file)
    {
        $this->file = $file;
    }

    public function handle(): void
    {
        // Vérification si le batch a été annulé
        if ($this->batch()?->cancelled()) {
            Log::warning("Batch cancelled for file: {$this->file}");
            return;
        }

        if (!Storage::exists($this->file)) {
            Log::error("Chunk file not found: {$this->file}");
            return;
        }

        $chunk = json_decode(Storage::get($this->file), true);

        // Traitement ligne par ligne
        foreach ($chunk as $row) {
            try {
                Personnality::create([
                    'first_name' => $row[1],
                    'last_name' => $row[2],
                    'profession' => $row[4],
                    'nationality' => $row[5],
                    'birth_year' => $row[6],
                    'short_bio' => $row[7],
                ]);
            } catch (\Throwable $th) {
                throw $th;
            }
        }

        // Nettoyage du fichier chunk
        Storage::delete($this->file);
    }

    public function failed(\Throwable $exception): void
    {
        Log::error("Job failed for file: {$this->file}", [
            'error' => $exception->getMessage(),
            'trace' => $exception->getTraceAsString()
        ]);
    }
}