PHP Fatal error: Allowed memory size

Depending on how you are doing the migration it might take all data in memory and that can kill your memory_limit.

See what the current memory_limit is for the CLI

php -i | grep memory_limit

Just to make sure that you're editting the correct php.ini file

You can remove the memory limit in your migration script as well

ini_set('memory_limit', -1)

But eventually, it could be that you need to change the way you migrate your data to make sure you do not load to much data into memory at once.

Hi @lostdreamer_nl, I was checking

Cantidad total de memoria física:          8.089 MB
Memoria física disponible:                 4.876 MB
Memoria virtual: tamaño máximo:            9.625 MB
Memoria virtual: disponible:               6.273 MB
Memoria virtual: en uso:                   3.352 MB

And with the ini_set the CLI delay some minutes but in the end crashes

ini_set('memory_limit', -1)

The database is new, doesnt have any table, its totally empty.

What are you doing when this happens? With normal usage you should not need 400mb of memory.

update: nvm, I see you are trying to run a migration.

The culprit could be a slow (or huge) query you are running. Try to select and update in chunks. Or another cause could be that you collect a lot of data during the migration.

Or... an endless loop in your code

I'm guessing that you have something like the following in your migration code:

// pseudo code

$oldData = \DB::table('old_table')->get();
// do some magical data processing here
foreach($oldData as $row)  {
    Model::create($row);
}

First getting all old data in memory, then restructuring it, then re-importing it into the DB in the new way.

But when you get all that data into memory, at some point the script overflows your (physical) memory.

Without knowing the migration script, it's hard to say for sure.

If this is the case, you could try to change the way you migrate, for instance: getting the old data in chunks, processing them, inserting them in the new DB, and then loop back for the next chunk.

It might also be that you keep data in memory while it's not needed anymore. Something like:

$oldData = \DB::table('old_table')->get();
// do some magical data processing here
foreach($oldData as $row)  {
    Model::create($row);
}

$moreOldData = \DB::table('other_old_table')->get();
// do some magical data processing here
foreach($moreOldData as $row)  {
    DifferentModel::create($row);
}

If you do not unset() the $oldData variable when getting the next dataset, your memory will start climbing rapidly.

If you cant figure it out, try to anonymize the code if needed and post it here, we could have a look at how to refactor it.

@m-rk I'm only creating the two basics tables that came by default with laravel

1. 2014_1012000000_create_users_table.php
2. 2014_10_12_100000_create_password_resets_table.php

I wrote this and get the error

php artisan migrate

My database config is

'default' => env('DB_CONNECTION', 'sqlsrv'),

.
.
.

'sqlsrv' => [
            'driver' => 'sqlsrv',
            'host' => env('DB_HOST', '10.10.xx.xxx'),
            'port' => env('DB_PORT', '1433'),
            'database' => env('DB_DATABASE', 'WebService'),
            'username' => env('DB_USERNAME', 'laravel'),
            'password' => env('DB_PASSWORD', 'tG)P{JWf2Gt43L,Y'),
            'charset' => 'utf8',
            'prefix' => 'dbo.',
        ],

and the .env file

DB_CONNECTION=sqlsrv
DB_HOST=10.10.xx.xxx
DB_PORT=1433
DB_DATABASE=WebService
DB_USERNAME=laravel
DB_PASSWORD=tG)P{JWf2Gt43L,Y

This is the code from a migration file

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateUsersTable extends Migration
{    
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        ini_set('memory_limit', -1);
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('email')->unique();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('users');
    }
}

Ok, that should work out of the box you would think. I do not have any experience with sql server.

Does your application even run in the browser? Are you able to create a simple controller that does not do any database calls?

And can you confirm that you can make a connection to your sql server?

To test this create a manual table on in your sql server database (if you do not have one already).

# enter in your console:
php artisan tinker

# now run this (change your table name)
\DB::selectOne('SELECT * FROM your_table'));

@m-rk the connection is succeed

PS C:\xampp\htdocs\inteligencia> php artisan tinker
Psy Shell v0.8.17 (PHP 7.2.1 — cli) by Justin Hileman
>>> \DB::selectOne('SELECT * FROM dbo.Test');
=> {#760
     +"ID": "92838",
   }
>>>   

How much data are you trying to migrate? Is it just a small amount? Can you see what the last executed query was and find out where it stopped?

@djkevino as far as I understand now he is not running any big migrations. Only the two default migrations described in an earlier comment.

@YoTosho Ok, I am clueless now. Are you also able to run a route to a controller in your browser (read as: is your laravel application even working)? My suggestion would be to get xdebug running and step through the code and figure out what is eating all the memory.

ok, I think i might know whats happening here... We were all looking at 'migration' as migrating data from DB1 --> DB2

But you're just running the laravel migrations to create new tables in MSSQL and it errors out already.

This is definately a server issue instead of laravel.

Check your PDO SQLSRV drivers to see if they're up to date, I believe they will be outdated creating endless loops for you.

@YoTosho did you have any luck with a solution for this?

I'm getting the same issue php 7.2 commenting to SQL 2017 Express on Win Server 2016

@yotosho I am also getting the same issue with MYSQL, So how I solve it let's take eye on it. Changed run function to call because the run is creating recursion.

$this->run(UserSeeder::class);

To inside DatabaseSeeder.php

$this->call(UserSeeder::class);

it's answered by https://laracasts.com/discuss/channels/laravel/allowed-memory-size-exceeded