Author Topic: Server overload since J 3.8.13  (Read 193 times)

marscom

  • Beginner
  • *
  • Posts: 4
  • A beginner
Server overload since J 3.8.13
« on: October 29, 2018, 09:52:28 am »
Hi,
the shop www.moebeldiscount.ch runs on its own server, which is great. Until week 41, there wasn't any problem. But since the update to J 3.8.13, I get daily notes from our server administrator that the server is totally overloaded. This leads to regular downtimes, which is more than annoying. What I'm reporting here is just what I get from the server admin:
"In der MySQL-Prozessliste sind erneut diese Prozesse zu finden:

SELECT p.`virtuemart_product_id` FROM `gm60x_virtuemart_products` as p
SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `gm60x_virtuemart_products` as p

Können Sie beim "Hersteller" des Webshops (Virtuemart) eine Anfrage machen und nachfragen wieso diese Prozesse so lange laufen? Allenfalls wird bei einer Bestellung etwas ausgelöst, was nicht ausgeführt werden kann und es wird trotzdem 1-2h versucht?"

What could the issue be?

Thanks for any hint,
Martin Scheidegger

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 8433
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: Server overload since J 3.8.13
« Reply #1 on: October 29, 2018, 10:47:26 am »
deselect

Enable VirtueMart 404 error handling in VM admin

will be fixed in next release
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

marscom

  • Beginner
  • *
  • Posts: 4
  • A beginner
Re: Server overload since J 3.8.13
« Reply #2 on: October 29, 2018, 10:57:41 am »
Thanks so much for your quick reply! I did this and wait for the results.

Thanks again!

role74

  • Beginner
  • *
  • Posts: 18
    • Dekostop Onlineshop for technical and advanced Divers
  • Skype Name: role74
  • VirtueMart Version: 3.0.10
Re: Server overload since J 3.8.13
« Reply #3 on: November 08, 2018, 20:32:32 pm »
Hi marscom

I assume your provider is hostpoint :-) Had the same issue just recently (see post http://forum.virtuemart.net/index.php?topic=141361.0) after stwitching the to the new category view layout.

Switch back to the old virtuemart standard layout in the main menu home entry and reactivate the legacy mode in the shop configuration. This helped in my case.

cheers
-role (ä bärner)

marscom

  • Beginner
  • *
  • Posts: 4
  • A beginner
Re: Server overload since J 3.8.13
« Reply #4 on: November 08, 2018, 21:55:15 pm »
Hoi Role,
merssi für den Input. Aber: Nein, es ist ein eigener Server (mit nur dieser Site drauf...) bei einem kleineren Anbieter. Und: es war tatsächlich die Lösung, die GJC Webdesign vorgeschlagen hat. Ein Klick aufs Häckchen - und alles tut wie's sollte.