SerializeModels memory limit hit when a Model has a lot of relations.

[mwleinad]

• Laravel Version: 5.8
• PHP Version: 7.3
• Database Driver & Version:

Description:

Is there an issue with serializing models when they have a lot of relations?
We started to get a lot of memory size limit errors.
Our memory size is 512M which should be more than enough.

Is the serializemodel trying to get a cyclical relationship and running out of memory that way?
Is there anyway to not load the relations when you use the serializemodels? We actually don't need any relation.

Steps To Reproduce:

Create a table with 100 fields.
Relate it to another table with 100 fields.
Rinse and repeat 5 times.
Trigger an event that uses the model and the serializemodel trait.
The memory usage is very big.

ERROR: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) {"exception":"[object] (Symfony\\Component\\Debug\\Exception\\FatalErrorException(code: 1): Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /usr/share/nginx/laravel/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:158)
[stacktrace]
#0 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(137): Symfony\\Component\\Debug\\Exception\\FatalErrorException->__construct()
#1 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(123): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->fatalExceptionFromError()
#2 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(0): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleShutdown()
#3 /usr/share/nginx/laravel/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(158): Doctrine\\DBAL\\Driver\\PDOStatement->fetchAll()
#4 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(332): Doctrine\\DBAL\\Driver\\PDOStatement->fetchAll()
#5 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(657): Illuminate\\Database\\MySqlConnection->Illuminate\\Database\\{closure:/usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:317-333}()
#6 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\\Database\\MySqlConnection->runQueryCallback()
#7 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(333): Illuminate\\Database\\MySqlConnection->run()
#8 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2124): Illuminate\\Database\\MySqlConnection->select()
#9 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2112): Illuminate\\Database\\Query\\Builder->runSelect()
#10 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2598): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure:/usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2111-2113}()
#11 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2113): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#12 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(521): Illuminate\\Database\\Query\\Builder->get()
#13 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(505): Illuminate\\Database\\Eloquent\\Builder->getModels()
#14 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(155): Illuminate\\Database\\Eloquent\\Builder->get()
#15 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(144): Illuminate\\Database\\Eloquent\\Relations\\BelongsTo->get()
#16 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(569): Illuminate\\Database\\Eloquent\\Relations\\BelongsTo->getEager()
#17 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(538): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation()
#18 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(491): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations()
#19 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(85): ilos\\Models\\AuthToken->load()
#20 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(55): ilos\\Events\\Broadcasts\\Channels\\VideoCreation\\VideoPreuploadComplete->restoreModel()
#21 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(45): ilos\\Events\\Broadcasts\\Channels\\VideoCreation\\VideoPreuploadComplete->getRestoredPropertyValue()
#22 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(42): ilos\\Events\\Broadcasts\\Channels\\VideoCreation\\VideoPreuploadComplete->__wakeup()
#23 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(42): unserialize()
#24 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(88): Illuminate\\Queue\\CallQueuedHandler->call()
#25 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Queue/SyncQueue.php(42): Illuminate\\Queue\\Jobs\\SyncJob->fire()
#26 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Queue/Queue.php(44): Illuminate\\Queue\\SyncQueue->push()
#27 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Broadcasting/BroadcastManager.php(128): Illuminate\\Queue\\SyncQueue->pushOn()
#28 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(267): Illuminate\\Broadcasting\\BroadcastManager->queue()
#29 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(190): Illuminate\\Events\\Dispatcher->broadcastEvent()
#30 /usr/share/nginx/laravel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(237): Illuminate\\Events\\Dispatcher->dispatch()

[mfn]

This comes up from time to time: the easiest fix usually is to not pass the model, just the primary key, and simply load it yourself.

[mwleinad]

Thanks, agree, that's one of our solutions.
but is there a reason why?

Even loading all those relationships that's nowhere close to 512M of data