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

Virtuemart 3.4.2 - mysql overload

Started by pivovary, November 20, 2018, 07:08:48 AM

Previous topic - Next topic

pivovary

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

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 '';
        }

jenkinhill

#2
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
Lowestoft, Suffolk, UK

Retired from forum life November 2023

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

pivovary

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

Another bug, VM Handle 404 causes cycling script and memory consuption

VM version 3.4.2
Joomla: 3.8.13

Studio 42

I do not use Soft VM 404 because i had many problems too.

pivovary

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

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
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

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

pivovary

Maybe test on monday, but i dont understant, why you not release oficial version when you know about this big issues.

vep87895

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

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/