Author Topic: Virtuemart 3.4.2 - mysql overload  (Read 1730 times)

pivovary

  • Beginner
  • *
  • Posts: 17
  • A beginner
Virtuemart 3.4.2 - mysql overload
« on: November 20, 2018, 07:08:48 am »
Hi,
i have problem after update to virtuemart 3.4.2. With 1000 products and 7 language

I dont't know where is this query and still run and run and server hang up.

Slow sql:

SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id`, l.product_name
      FROM `joom_virtuemart_products` as p   
 INNER JOIN `joom_virtuemart_products_cs_cz` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
 LEFT JOIN `joom_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` 
 LEFT JOIN `joom_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` 
 LEFT JOIN `joom_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
 WHERE ( ((p.`product_parent_id` = "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  AND  ((p.`product_parent_id` > "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  AND  .......
 group by p.`virtuemart_product_id`
 ORDER BY `pc`.`ordering` ASC, `product_name` ASC LIMIT 0, 100;

pivovary

  • Beginner
  • *
  • Posts: 17
  • A beginner
Re: Virtuemart 3.4.2 - mysql overload
« Reply #1 on: November 21, 2018, 07:00:17 am »
I think same problem as

http://forum.virtuemart.net/index.php?topic=141440.0

Please when it be available new version 3.4.3

I stop this problem edit in vmmodel.php after row

Code: [Select]
public function exeSortSearchListQuery($object, $select, $joinedTables, $whereString = '', $groupBy = '', $orderBy = '', $filter_order_Dir = '', $nbrReturnProducts = false ){

i added
Code: [Select]
       if (preg_match("/`product_parent_id` = \"0\"/", $whereString))
        {
            return '';
        }

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27600
  • Always on vacation
    • Jenkin Hill Internet
Re: Virtuemart 3.4.2 - mysql overload
« Reply #2 on: November 21, 2018, 12:45:46 pm »
VM3.4.3.9989 was release 2 days ago.  http://dev.virtuemart.net/projects/virtuemart/files

Test on a copy of the live site first.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.6.10.10211 on Joomla 3.9.13 PHP 7.0.33

pivovary

  • Beginner
  • *
  • Posts: 17
  • A beginner
Re: Virtuemart 3.4.2 - mysql overload
« Reply #3 on: November 21, 2018, 13:13:08 pm »
You know, how to repeat this problem? I don't know where url start this problem.I have only log from mysql server. Before update i test version 3.4.2 on dev server but without problem after update on production server problem start.

pivovary

  • Beginner
  • *
  • Posts: 17
  • A beginner
Re: Virtuemart 3.4.2 - mysql overload
« Reply #4 on: December 07, 2018, 14:20:43 pm »
Another bug, VM Handle 404 causes cycling script and memory consuption

VM version 3.4.2
Joomla: 3.8.13

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4067
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: Virtuemart 3.4.2 - mysql overload
« Reply #5 on: December 07, 2018, 14:36:28 pm »
I do not use Soft VM 404 because i had many problems too.

pivovary

  • Beginner
  • *
  • Posts: 17
  • A beginner
Re: Virtuemart 3.4.2 - mysql overload
« Reply #6 on: December 07, 2018, 15:24:38 pm »
And info about problem from hosting

[07-Dec-2018 14:04:43 Europe/Prague] PHP Warning: array_merge(): Argument #1 is not an array in /domains1/gh43254800/public/www_root/components/com_virtuemart/views/category/view.html.php on line 257
[07-Dec-2018 14:04:43 Europe/Prague] PHP Notice: Undefined index: debug in /domains1/gh43254800/public/www_root/administrator/components/com_virtuemart/helpers/vmmodel.php on line 816

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27600
  • Always on vacation
    • Jenkin Hill Internet
Re: Virtuemart 3.4.2 - mysql overload
« Reply #7 on: December 07, 2018, 15:31:56 pm »
Another bug, VM Handle 404 causes cycling script and memory consuption

VM version 3.4.2
Joomla: 3.8.13

Already fixed in VM3.4.3
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM 3.6.10.10211 on Joomla 3.9.13 PHP 7.0.33

pivovary

  • Beginner
  • *
  • Posts: 17
  • A beginner
Re: Virtuemart 3.4.2 - mysql overload
« Reply #8 on: December 07, 2018, 17:31:19 pm »
Maybe test on monday, but i dont understant, why you not release oficial version when you know about this big issues.

vep87895

  • Beginner
  • *
  • Posts: 9
  • A beginner
Re: Virtuemart 3.4.2 - mysql overload
« Reply #9 on: December 10, 2018, 09:46:27 am »
This is the reason (mysql overload) that I'm still on VM3.4.0. I assume that VM3.4.3 will soon be released as the new stable official version?

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9997
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Virtuemart 3.4.2 - mysql overload
« Reply #10 on: December 10, 2018, 10:11:45 am »
You can already use it live.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/