Laravel DOMPDF exceed memory limit

Question

I have an issue with Laravel DOMPDF package. I've set the php.ini memory limit to 2G and launched a queue with --timeout=3600. The script is a foreach with a helper function called every times, it produces pdfs for 7/8 minutes, than it stops doing it and after 10 minutes it returns in the terminal

Symfony\Component\ErrorHandler\Error\FatalError 

 Allowed memory size of 2147483648 bytes exhausted (tried to allocate 20480 bytes)

 at vendor/dompdf/dompdf/src/Css/Style.php:577
   573▕             //Early check on cache, before converting $length to array
   574▕             if (isset($cache[$key])) {
   575▕                 return $cache[$key];
   576▕             }
 ➜ 577▕             $length = [$length];
   578▕         } else {
   579▕             $key = implode("@", $length) . "/$ref_size";
   580▕             if (isset($cache[$key])) {
   581▕                 return $cache[$key];


  Whoops\Exception\ErrorException 

 Allowed memory size of 2147483648 bytes exhausted (tried to allocate 20480 bytes)

 at vendor/dompdf/dompdf/src/Css/Style.php:577
   573▕             //Early check on cache, before converting $length to array
   574▕             if (isset($cache[$key])) {
   575▕                 return $cache[$key];
   576▕             }
 ➜ 577▕             $length = [$length];
   578▕         } else {
   579▕             $key = implode("@", $length) . "/$ref_size";
   580▕             if (isset($cache[$key])) {
   581▕                 return $cache[$key];

     +1 vendor frames 
 2   [internal]:0
     Whoops\Run::handleShutdown()

I'm using tables and I've read that it may be for that reason. Thanks to anyone who could help me.

process_id = $process_id;
    }

    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        
        $process = Process::find($this->process_id);
      //look for all provinces
      $provinces = Province::all();
      //cicle them
      foreach($provinces as $province)
      {
          //questa query mi dà una collection con tutti i movimenti per quel mese/anno/provincia
          $movements = Movement::where('process_id', '=', $process->id)->where('district', '=', $province['code'])->get();
          $movements = $movements->toArray();

          if(!empty($movements))
          {
              //passo il risultato alla funzione che fa il pdf
              //GENERATEPDFHELPER

              $test = new GeneratePdfHelper($movements);
              $test->create_pdf();
              
          }         
      }
      //Update the record in DB
        $process->update(['is_pdf_generated' => 1]);
    }
}

movements = $movements;
        }

        public function create_pdf(){
        
        //contatore per vedere quanti record ci sono per i movimenti di quel processo per quella provincia
        $count = count($this->movements);
        //totale ritenute e ruolo
        $amount = 0; // ritenute
        $roles = array(); //ruoli

            foreach($this->movements as $key => $movement){
                $amount = $amount + $movement['amount'];
                if(!array_key_exists($movement['position'], $roles)){
                    $roles[$movement['position']] = 0;
                    $roles[$movement['position']] = $roles[$movement['position']] + 1;
                } else {
                    $roles[$movement['position']] = $roles[$movement['position']] + 1;
                }
            }

            $summary = array();
            $summary['amount'] = $amount;
            $summary['count'] = $count;
            $summary['roles'] = $roles;

            $pdf = PDF::loadView('pdf.index', ['movements' => $this->movements, 'summary' => $summary])->setPaper('a4', 'landscape');
            $content = $pdf->download()->getOriginalContent();
            Storage::put("processes/{$this->movements[0]['process_id']}/{$this->movements[0]['district']}.pdf", $content);
     
          }        

        }
    }





Titolo



        
            
                
                
                    
                        
                            {{$movements[0]['district']}}
                        
                        
                            (Mese di confronto: {{$movements[0]['month_payment']}}/{{$movements[0]['year_payment']}})
                        
                    
                
                


                
                
                    
                        
                            
                                
                                    Iscritti: {{$summary['count']}}
                                
                                
                                    Nuove iscrizioni: ?
                                
                            

                            
                                
                                    
                                        Ritenute nel mese: ?
                                    
                                    
                                        Riattivazioni: ?
                                    
                                    
                                        Cessazioni: ?
                                    
                                
                            

                            
                                
                                    
                                        
                                            
                                                
                                                    TOTALE (ritenute rimborsi):
                                                
                                                
                                                    {{$summary['amount']}}
                                                
                                            
                                            
                                                
                                                    Quota al Nazionale:
                                                
                                                
                                                    ?
                                                
                                            
                                            
                                                
                                                    NETTO per la Sede prov.:
                                                
                                                
                                                    €355,62
                                                
                                            
                                            
                                        
                                    
                                    
                                        
                                            
                                                
                                                    ATA:
                                                
                                                
                                                    16
                                                
                                            
                                            
                                                
                                                    DOCENTI:
                                                
                                                
                                                    33
                                                
                                            
                                            
                                                
                                                    ITP:
                                                
                                                
                                                    0
                                                
                                            
                                        
                                        
                                            
                                                
                                                    Precari:
                                                
                                                
                                                    5
                                                
                                            
                                            
                                                
                                                    Pensionandi:
                                                
                                                
                                                    0
                                                
                                            
                                        
                                    
                                
                            
                        
                        
                            
                                
                                    Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
                                
                                
                                    Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
                                
                            
                        
                    
                
                


                    
                    
                    1 - RITENUTE NEL Mese
                    
                            
                                @foreach ($movements as $movement)
                                            
                                            @endforeach
                            
                                
                                    
                                        Partita
                                    
                                    
                                        SS
                                    
                                    
                                        Eta'
                                    
                                    
                                        Nominativo
                                    
                                    
                                        Qualifica
                                    
                                    
                                        Sede di servizio
                                    
                                    
                                        Tel sede
                                    
                                    
                                        Fax sede
                                    
                                    
                                        Scadenze
                                    
                                

                                                
                                                    {{$movement['receipt_id']}}
                                                
                                                
                                                    M
                                                
                                                
                                                    54
                                                
                                                
                                                    {{$movement['name_lastname']}}
                                                
                                                
                                                    {{$movement['position']}}
                                                
                                                
                                                    ANIC83300cc Senigallia Marchetti
                                                
                                                
                                                    0717922289
                                                
                                                
                                                    07165487
                                                
                                                
                                                    202106 scadenza contratto

user_2760986 · Answer

In general your approach seems wrong or kinda misunderstood, in regards to what a job actually achieves. Jobs are short running jobs that executes code that prevents the Http server from responding slow and is a more scalable solution. This is not as black and white, but in general long running tasks is more suited for commands.

You are using 2000 mb of ram, that is a lot and as long as you keep on adding models it will be higher. Instead create multiple small jobs that does the same, each job will cleanup after itself and therefor never exceed the memory limit, while also being able to execute multiple pdf's simultaneously.

Create a job for a single Movement.

class GeneratePdfFile implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

    public $province;

    public $process_id;

    /**
     * Create a new job instance.
     *
     * @return void
     */
    public function __construct(Province $province, $process_id)
    {
        $this->province = $province;
        $this->process_id = $process_id;
    }

    public function handle() {
      $movements = Movement::where('process_id', '=', $process->id)->where('district', '=', $this->province['code'])->get();
      $movements = $movements->toArray();

      if(!empty($movements))
      {
          //passo il risultato alla funzione che fa il pdf
          //GENERATEPDFHELPER

          $test = new GeneratePdfHelper($movements);
          $test->create_pdf();
      }    
    }
}

Then when creating the job instead loop your Province there.

foreach($provinces as $province)
{
    dispatch(new GeneratePdfFile($province, $process_id));
}

Laravel DOMPDF exceed memory limit

1 Answers