SQLSTATE[HY001] Unable to allocate sufficient memory - Laravel 8

Question

I have the following problem when trying to connect to a database in sqlserver that is on a shared server from laravel.

Problem:

I am using laravel 8. I would be very grateful if anyone has solved this problem or something similar has happened and can help me.

Note: I have reviewed several forums and tested the sqlsrv driver is correct with tinker.

Review and verify what they tell me in this other stackoverflow link but it does not work for me.

Your memory is not enough, just create a swap memory or upgrade your RAM. — Muhammad Dyas Yaskur, Mar 15 '21 at 03:46
Thanks for answering, but I already tried that and nothing ... — Susje, Mar 15 '21 at 03:52

score 0 · Answer 1 · answered Mar 15 '21 at 03:39

0

In this case, you need to start the tinker with the following command.

php -d memory_limit=-1 artisan tinker

answered Mar 15 '21 at 03:39

No, the error persists even if I modify my memory limit in php ... won't there be something else to do from the laravel system other than that? I already checked the drivers and others ... and nothing .. – Susje Mar 15 '21 at 03:52
I don't think, you need to modify the Laravel. – Iynga Iyngaran Iyathurai Mar 15 '21 at 04:03
What do you think I should modify? – Susje Mar 15 '21 at 04:04
I hope It's something to do with the PHP memory limit or database memory limit. – Iynga Iyngaran Iyathurai Mar 15 '21 at 04:05

score 0 · Answer 2 · answered Mar 15 '21 at 05:35

0

Instead of reading the whole table from the database, considering chunking the result.

Flight::chunk(200, function ($flights) {
    foreach ($flights as $flight) {
        //
    }
});

answered Mar 15 '21 at 05:35

Anurat Chapanond

2 Answers2