Memory Leak

[jetx]

 I am having this issue, pretashop 1.7.3, VPS 4gb, php 7, Centos.

The issue started as soon as I deleted a  category. I also got server 500 on front end (admin was fine). Debug mode provided no info and there were no errors in logs (admin also).

The only way to get it back was to drop the tables and re-import from a backup. The process was affecting my entire VPN, a large number of sites.

I tried again and the same issue occurred. Non Prestashop modules were disabled.

[root@.. shop]# tail error_log [07-Jun-2018 18:16:16 ] PHP Fatal error: Out of memory (allocated 4042842112) (tried to allocate 3433041920 bytes) in /home/../classes/exception/PrestaShopException.php on line 140

[07-Jun-2018 18:16:16] PHP Fatal error: Out of memory (allocated 4042842112) (tried to allocate 3433041920 bytes) in /home/../vendor/symfony/symfony/src/Symfony/Component/Debug/ExceptionHandler.php on line 197

[07-Jun-2018 18:16:16 ] PHP Fatal error: Out of memory (allocated 4042842112) (tried to allocate 4009287680 bytes) in Unknown on line 0

 

[root@.. public_html]# mysqladmin proc stat +-----+------------+-----------------+----------------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+------------+-----------------+----------------+---------+------+-------+------------------+ | 522 | .. | localhost:34796 | .. | Sleep | 87 | | | | 525 | root | localhost | | Query | 0 | init | show processlist | +-----+------------+-----------------+----------------+---------+------+-------+------------------+ Uptime: 5493 Threads: 2 Questions: 69333 Slow queries: 0 Opens: 962 Flush tables: 1 Open tables: 887 Queries per second avg: 12.622

[root@.. shop]# tail error_logcond avg: 12.622

 

Note: re the sql you may notice there a mysql query sleeping during the loading of the page before the errors are shown by way of blank page, timing out at 87 seconds.

Any ideas?

[jetx]

An update to this, the bug appears to be caused by a module (mega menu from sunnytoo themes), so when a category is deleted (not all but some).

 

*ERROR*     v1.7.3.3    2018/06/18 - 09:28:55: Invalid category vars at line 374 in file classes/Link.php