News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Forcibly terminating processes due to lack of memory.

Started by marvays, May 06, 2019, 18:07:20 PM

Previous topic - Next topic

marvays

I've had a problem with my eshop for several months. I still couldn't solve it. I have a 500 error several times a day. Too many queries to the database.

Today I accidentally logged in to the shop under my account from the front. And I found out that I have 136 products in my cart. Can't the problem be somewhere in the settings? in cache? Something wrong? I have always logged into administration only.

I have a new, really good hosting.
Joomla 3.9.5
VirtueMart 3.4.2
php 7.1
memory_limit   2048M
max_execution_time   300

Forcibly terminating processes due to lack of memory.

Date  Process
05.05.2019  17:16 php-cgi

AH

Regards
A

Joomla 4.4.5
php 8.1


balai

Please check where those visits come from and block the bots.

I have the same problem in my site, which turned out to be bots calling my site.
Have a look here:
https://www.seoblog.com/2018/03/block-bots-spiders-htaccess/

jjk

Perhaps also check if you do have a 'huge' session table in your database or a 'huge' session folder on the server?
Some time ago I had memory problem because I did hit the maximum allowed webspace on the server (too many subfolders for testing).
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

marvays

Quote from: jjk on May 07, 2019, 17:01:17 PM
Perhaps also check if you do have a 'huge' session table in your database or a 'huge' session folder on the server?
Some time ago I had memory problem because I did hit the maximum allowed webspace on the server (too many subfolders for testing).

Studio 42

I think the problem is that you have 136 products in the cart.
Remove the entry in XXX_virtuemart_carts for your virtuemart_user_id

marvays

Quote from: Studio 42 on May 07, 2019, 18:44:38 PM
I think the problem is that you have 136 products in the cart.
Remove the entry in XXX_virtuemart_carts for your virtuemart_user_id
I deleted items manually. But I don't understand how they got there. I suspect there's a mistake somewhere. Which may be related to speed problems.

jjk

The screenshot doesn't include the size column. I would also look into the sh404sef cache folder. Almost 24000 urls in the table and maybe a huge amount of megabytes in the cache folder.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

GJC Web Design

QuoteBut I don't understand how they got there

multiple test 'add to carts' over time? You said this was the account u use for testing...
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

marvays

Quote from: GJC Web Design on May 07, 2019, 22:17:44 PM
QuoteBut I don't understand how they got there

multiple test 'add to carts' over time? You said this was the account u use for testing...
Yes. but I haven't been on the site for months. I perform tests on e-shop as anonymous.