Skip to content

Geo search running out of memory #3

@wyattis

Description

@wyattis

We could probably stream this response instead of holding it all in memory.

[2019-09-05 15:09:47] dev.DEBUG: select * from `geo` where `name_translation_id` in (select `translation_id` from `translation_text` where `translated_text` like ?) and `geo_type_id` in (select `id` from `geo_type` where `study_id` = ?) and `parent_id` = ? and `geo`.`deleted_at` is null limit 1000 offset 0
[2019-09-05 15:09:53] dev.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Allowed memory size of 134217728 bytes exhausted (tried to allocate 8392704 bytes) in /var/www/trellis-api-5.6/vendor/illuminate/http/JsonResponse.php:71
Stack trace:
#0 /var/www/trellis-api-5.6/vendor/laravel/lumen-framework/src/Concerns/RegistersExceptionHandlers.php(54): Laravel\Lumen\Application->handleShutdown()
#1 [internal function]: Laravel\Lumen\Application->Laravel\Lumen\Concerns\{closure}()
#2 {main} {"exception":"[object] (Symfony\\Component\\Debug\\Exception\\FatalErrorException(code: 1): Allowed memory size of 134217728 bytes exhausted (tried to allocate 8392704 bytes) at /var/www/trellis-api-5.6/vendor/illuminate/http/JsonResponse.php:71)
[stacktrace]
#0 /var/www/trellis-api-5.6/vendor/laravel/lumen-framework/src/Concerns/RegistersExceptionHandlers.php(54): Laravel\\Lumen\\Application->handleShutdown()
#1 [internal function]: Laravel\\Lumen\\Application->Laravel\\Lumen\\Concerns\\{closure}()
#2 {main}
"}

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions