| Project: | Ubercart Popular Product |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | fixed |
Jump to:
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.
