laravel - Allowed memory size exhausted in queue

Question

I want to fire import from Excel file by queues so I do:
queue file

/**
 * Execute the job.
 *
 * @return void
 */
public function handle()
{
    Excel::filter('chunk')->load(storage_path('engine-valves.xlsx'))->chunk(500, function($results) {
        \Illuminate\Support\Facades\File::put(storage_path('data2.txt'), json_encode($results));
    });
}

but on listen process I getting standard error Allowed memory size of xxx bytes exhausted. For one moment I tried to set ini_set('memory_limit', '-1'); but still I getting this error. There is full line with this error:
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 100663304 bytes) in [app_path]\vendor\phpoffice\phpexcel\Classes\PHPExcel\Cell.php on line 889.
I'm using: https://github.com/Maatwebsite/Laravel-Excel
Where is can be problem?

Too big file to keep in memory so you would need to read it as a ByteStream or something — aaron0207
– aaron0207, Commented Sep 13, 2017 at 11:33

Hectorda · Accepted Answer · 2017-09-13 11:49:05Z

1

Maybe is not a good practice but you can set the memory limit just for the method

/**
* Execute the job.
*
* @return void
*/
public function handle()
{
    ini_set('memory_limit', '-1');
    Excel::filter('chunk')->load(storage_path('engine-valves.xlsx'))>chunk(500, function($results) {
    \Illuminate\Support\Facades\File::put(storage_path('data2.txt'), json_encode($results));
    });
}

with memory limit = -1, you dont have limit.

answered Sep 13, 2017 at 11:49

Hectorda

1213 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vertisan Over a year ago

Like I wrote in question - I have setted this for test and I still getting this error, please read it again.

2 revs · Accepted Answer · 2018-06-28 09:49:27Z

0

I think, you should change maximum upload file size in your php.ini file. So, open your php.ini file and find upload_max_filesize. Then change the value. You should also change post_max_size directive in php.ini file.

edited Jun 28, 2018 at 9:49

community wiki

2 revs
Muminur Rahman

2 Comments

user1978550 Over a year ago

Do you have an example of what that would look like? It's usually best to expand upon suggestions.

Muminur Rahman Over a year ago

changed as you suggested. Thanks.

Collectives™ on Stack Overflow

laravel - Allowed memory size exhausted in queue

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related