Allowed memory error in BackOffice after selecting an order

[juanitourquiza]

Hello,

An order has arrived a few days ago, I enter to see all the orders without problem but when I select one

It shows me the error:

[2021-07-09 19:04:57] request.CRITICAL: Uncaught PHP Exception Symfony\Component\Debug\Exception\OutOfMemoryException: "Error: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 16777224 bytes)" at /home/xxxxxxxx/xbpycqskgb/public_html/classes/db/DbPDO.php line 187 {"exception":"[object] (Symfony\\Component\\Debug\\Exception\\OutOfMemoryException(code: 0): Error: Allowed memory size of 2147483648 bytes exhausted (tried to allocate 16777224 bytes) at /home/xxxxxxxx/xbpycqskgb/public_html/classes/db/DbPDO.php:187)"} []

Version: 1.7.4.2
PHP: 7.1

The memory has already risen to 2048M the memory_limit

[Nickz]

48 minutes ago, juanitourquiza said:

The memory has already risen to 2048M the memory_limit

After that you need to restart apache2

Have you raised the limit of the one governing the shop. Place a phpinfo.php file in the webroot with

<?php

// Show all information, defaults to INFO_ALL
phpinfo();

// Show just the module information.
// phpinfo(8) yields identical results.
phpinfo(INFO_MODULES);

?>

taken form php.net

[juanitourquiza]

Hi, 

Now have this configuration.

 

The problem is the same:

[2021-07-13 08:59:23] php.CRITICAL: Fatal Error: Allowed memory size of 3221225472 bytes exhausted (tried to allocate 203423752 bytes) {"exception":"[object] (Symfony\\Component\\Debug\\Exception\\OutOfMemoryException(code: 0): Error: Allowed memory size of 3221225472 bytes exhausted (tried to allocate 203423752 bytes) at /home/xxxxxxxxxx/xbpycqskgb/public_html/classes/db/DbPDO.php:147)"} []

 

Other idea?

 

 

[juanitourquiza]

19 minutes ago, Crezzur said:

Don't set it at 3072M use 512M; and try to clear your cache files

Ok perfect.

 

Where is the cache files? 

 

I have a new error:

[2021-07-13 09:59:36] php.CRITICAL: Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 35651592 bytes) {"exception":"[object] (Symfony\\Component\\Debug\\Exception\\OutOfMemoryException(code: 0): Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 35651592 bytes) at /home/xxxxxxxxxxxxxxx/xbpycqskgb/public_html/classes/db/DbPDO.php:147)"} []

Edited July 13, 2021 by juanitourquiza (see edit history)

[juanitourquiza]

1 hour ago, Crezzur said:

the cache folder is located here:

Yourstore/var/cache/

Delete everything inside

I delete files cache but doesn't work

[2021-07-13 11:35:39] php.CRITICAL: Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 31457288 bytes) {"exception":"[object] (Symfony\\Component\\Debug\\Exception\\OutOfMemoryException(code: 0): Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 31457288 bytes) at /home/547729.cloudwaysapps.com/xbpycqskgb/public_html/classes/db/DbPDO.php:147)"} []

Other idea?

[juanitourquiza]

The solution is this:  It's necessary to clean data in this tables:

ps_guest

ps_connections

ps_connections_page

ps_connections_source

ps_page_viewed

ps_layered_filter_block

ps_log

ps_statssearch

ps_pagenotfound

ps_smarty_cache

For example:

TRUNCATE table ps_guest

 

Regards