Not unlocking database correctly after hitting Adjustments on product page.

Project:Ubercart Popular Product
Component:Miscellaneous
Category:bug report
Priority:normal
Assigned:Unassigned
Status:fixed
Description
Project: 
Product Minimum

When I hit the adjustments tab on any product, the page doesn't show up and I have the following tables locked:

root@useast12 [~]# mysqladmin proc |grep nordicpc
| 11266045 | nordicpc_user | localhost | nordicpc_drupal | Query | 6260 | statistics | SELECT COUNT(*) FROM (uc_product_options AS po1 LEFT JOIN uc_attribute_options AS ao1 ON po1.oid = a |
| 11267185 | nordicpc_user | localhost | nordicpc_drupal | Query | 5959 | Locked | DELETE FROM uc_product_options WHERE nid = 6 AND oid = 79 |
| 11267998 | nordicpc_user | localhost | nordicpc_drupal | Query | 5750 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11278389 | nordicpc_user | localhost | nordicpc_drupal | Query | 3219 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11280521 | nordicpc_user | localhost | nordicpc_drupal | Query | 2707 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11280604 | nordicpc_user | localhost | nordicpc_drupal | Query | 2689 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11280762 | nordicpc_user | localhost | nordicpc_drupal | Query | 2654 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11280815 | nordicpc_user | localhost | nordicpc_drupal | Query | 2639 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11280891 | nordicpc_user | localhost | nordicpc_drupal | Query | 2622 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11285984 | nordicpc_user | localhost | nordicpc_drupal | Query | 1588 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11286043 | nordicpc_user | localhost | nordicpc_drupal | Query | 1573 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11286063 | nordicpc_user | localhost | nordicpc_drupal | Query | 1568 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11286275 | nordicpc_user | localhost | nordicpc_drupal | Query | 1513 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11286720 | nordicpc_user | localhost | nordicpc_drupal | Query | 1393 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11287071 | nordicpc_user | localhost | nordicpc_drupal | Query | 1325 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11287199 | nordicpc_user | localhost | nordicpc_drupal | Query | 1303 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11288515 | nordicpc_user | localhost | nordicpc_drupal | Query | 1056 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11289586 | nordicpc_user | localhost | nordicpc_drupal | Query | 815 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11290546 | nordicpc_user | localhost | nordicpc_drupal | Query | 559 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11291125 | nordicpc_user | localhost | nordicpc_drupal | Query | 368 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11291153 | nordicpc_user | localhost | nordicpc_drupal | Query | 360 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
| 11292472 | nordicpc_user | localhost | nordicpc_drupal | Query | 35 | Locked | SELECT po.nid, po.oid, po.cost, po.price, po.weight, po.ordering, ao.name, ao.aid FROM uc_product_op |
root@useast12 [~]#

This causes the product pages to become unresponsive.

Version: 
Ubercart 2.x-dev
duckz's picture
Offline
Joined: 05/13/2009
Juice: 115
#1
Status:active» fixed

Wrong project, you should try Product Minimum project to post this issue.

---------------------------------------------------------------------------------------------------------------------
available for custom works, drupalstore.info
------------------------------------------------