VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: pivovary on November 20, 2018, 07:08:48 AM

Title: Virtuemart 3.4.2 - mysql overload
Post by: pivovary 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;
Title: Re: Virtuemart 3.4.2 - mysql overload
Post by: pivovary 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


public function exeSortSearchListQuery($object, $select, $joinedTables, $whereString = '', $groupBy = '', $orderBy = '', $filter_order_Dir = '', $nbrReturnProducts = false ){


i added

       if (preg_match("/`product_parent_id` = \"0\"/", $whereString))
        {
            return '';
        }
Title: Re: Virtuemart 3.4.2 - mysql overload
Post by: jenkinhill 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.
Title: Re: Virtuemart 3.4.2 - mysql overload
Post by: pivovary 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.
Title: Re: Virtuemart 3.4.2 - mysql overload
Post by: pivovary 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
Title: Re: Virtuemart 3.4.2 - mysql overload
Post by: Studio 42 on December 07, 2018, 14:36:28 PM
I do not use Soft VM 404 because i had many problems too.
Title: Re: Virtuemart 3.4.2 - mysql overload
Post by: pivovary 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
Title: Re: Virtuemart 3.4.2 - mysql overload
Post by: jenkinhill on December 07, 2018, 15:31:56 PM
Quote from: pivovary 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

Already fixed in VM3.4.3
Title: Re: Virtuemart 3.4.2 - mysql overload
Post by: pivovary 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.
Title: Re: Virtuemart 3.4.2 - mysql overload
Post by: vep87895 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?
Title: Re: Virtuemart 3.4.2 - mysql overload
Post by: Milbo on December 10, 2018, 10:11:45 AM
You can already use it live.