I've deleted a product type.

Decided to recreate one with the same name and I get "The website encountered an unexpected error. Please try again later"
This is pretty fast but then I cant access the site for a while. I get maximum php execution time errors, despite increasing the time, currently 180seconds. After around 10-15 min and a few attempts the site loads and seems to work normally.

When I finally get access back I visit the store configuration and it seems to have created the product type, however on inspection it seems to have the settings from the old one I deleted. It seems to take the sku pattern from the deleted product. It does not create a product display type

While its not responding I repeatedly get this error.

	PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: DELETE FROM {semaphore} WHERE (name = :db_condition_placeholder_0) AND (value = :db_condition_placeholder_1) AND (expire <= :db_condition_placeholder_2) ; Array ( [:db_condition_placeholder_0] => menu_rebuild [:db_condition_placeholder_1] => 862678742593ed9515b9704.78752475 [:db_condition_placeholder_2] => 1497291119.8734 ) in lock_may_be_available() (line 181 of /var/www/tina/stanspals.co.uk/includes/lock.inc).

Any idea where i even start for this. I dont want to risk the site dying if I ever accidentailly add a product type with a name I used in the past. I'm guessing its leaving somethign in the database but i dont know where to begin to make sure I dont leave a trace.

Comments

bigmonmulgrew created an issue. See original summary.

czigor’s picture

Status: Active » Postponed (maintainer needs more info)

Hi bigmonmulgrew,
Can you provide steps to reproduce this? I created a 'test' product type, added a 'Number' decimal field to it, removed the product type and then could re-add it without a problem. I'm on latest 7.x dev though, not 7.13.

rszrama’s picture

Priority: Critical » Normal
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

I also could not reproduce this. I created a product type called Pants, deleted it, and recreated it without any issues. I think something else must have caused the lock wait timeout, but as czigor suggested, it could just be the fact that we're on 7.x-1.x-dev instead of 7.x-1.13.