Symfony\Component\ErrorHandler\Error\FatalError

Question

Im new in laravel

Always get this

Symfony\Component\ErrorHandler\Error\FatalError Allowed memory size of 2147483648 bytes exhausted (tried to allocate 2147483656 bytes) Error on this line

$arrayGejala = collect([
        substr($gejala1, 14, 1), 
        substr($gejala2, 14, 1), 
        substr($gejala3, 14, 1),
    ])->implode(',');

    $belief = DB::table('pengetahuan')->select(DB::raw("GROUP_CONCAT(penyakit.kode_penyakit)"), 'pengetahuan.bobot')
        ->from('pengetahuan')
        ->join('penyakit', 'pengetahuan.id_penyakit', '=', 'penyakit.id_penyakit')
        ->whereIn('pengetahuan.id_gejala', [(array)$arrayGejala[0],(array)$arrayGejala[2],(array)$arrayGejala[4]])
        ->groupBy('pengetahuan.id_gejala')
        ->get();
        
        $evidence = array();
        while ($row = $belief->first()) {
            $evidence[]=$row;
        }

while ($row = $belief->first()) will result in an infinite loop. If $belief->first() is truthy once it will be truthy forever (the function is "pure" i.e. it doesn't change the state of the collection). You might want to do something like $evidence = $belief->all() instead of a loop — apokryfos
– apokryfos, Commented Jan 8, 2022 at 7:15

Kaushik Dhameliya · Accepted Answer · 2022-01-08 07:14:03Z

1

Increase your maximum memory limit to 64MB in your php.ini file. Google search But could I ask why you are trying to allocate that much memory? What line of code does it fail at?

in your PHP.ini file, change the line in PHP.ini If your line shows 32M try 64M: memory_limit = 64M ; Maximum amount of memory a script may consume (64MB)
If you don't have access to PHP.ini try adding this to an .htaccess file: php_value memory_limit 64M

answered Jan 8, 2022 at 7:14

Kaushik Dhameliya

1912 silver badges5 bronze badges

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

3 Comments

Muhammad Fajri Firdaus Over a year ago

i want to fetch data from $belief, and the code always say the error is on 'while'

Jack Over a year ago

Increasing the memory limit is not a good solution.

Muhammad Fajri Firdaus Over a year ago

Yeah, maybe im just gonna delete that infinte loop and find another solution. Thanks for answering guys

Inov Afani · Accepted Answer · 2025-04-27 09:11:18Z

0

This is because your Laravel version is not compatible with the Doctrine DBAL version you are using.

1. Check your version : composer why carbonphp/carbon-doctrine-types

2. Downgrade your version : composer require nesbot/carbon:^2.66(whatever your version is)

3. Remove your dependencies : composer remove carbonphp/carbon-doctrine-types

4. Install the compatible ones : composer require doctrine/dbal:^3.0(whatever your version is)

answered Apr 27 at 9:11

Inov Afani

1

Comments

Talha Rashid · Accepted Answer · 2025-04-28 11:37:59Z

The script is trying to use more memory than allowed (2GB in your case):

Inefficient Query Handling: You are fetching a large dataset with GROUP_CONCAT and storing it in memory. When you use $belief->first() repeatedly inside a loop, it loads data inefficiently, causing the memory usage to spike.
Memory Usage in implode(): The implode() function can also consume a lot of memory if $arrayGejala has too many elements or if it's creating large strings.

Solution:

Use foreach instead of while: Avoid using $belief->first() inside the loop, as it's inefficient.

$evidence = [];
foreach ($belief as $row) {
    $evidence[] = $row;
}

Optimize implode(): Ensure $arrayGejala is not too large. If possible, reduce the data size.

Increase PHP memory limit (if necessary): Temporarily increase memory by adding this at the top:

ini_set('memory_limit', '4G');

Noted:

Large datasets are being processed and stored in memory without efficient pagination or limiting the results.
Repeated calls to first() in a loop fetch the same data multiple times instead of iterating directly.

These lead to excessive memory consumption.

Collectives™ on Stack Overflow

Symfony\Component\ErrorHandler\Error\FatalError

3 Answers 3

3 Comments

Comments

Solution:

Noted:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Solution:

Noted:

Comments

Your Answer

Sign up or log in

Post as a guest

Related