Drupal SQL timeout error

Question

I keep randomly getting this error within my Drupal site. Only way to resolve is to delete the session from the database.

PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: SELECT revision.order_number AS order_number, revision.revision_id AS revision_id, revision.revision_uid AS revision_uid, revision.mail AS mail, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.revision_hostname AS revision_hostname, revision.data AS data, base.order_id AS order_id, base.type AS type, base.uid AS uid, base.created AS created, base.changed AS changed, base.hostname AS hostname FROM {commerce_order} base INNER JOIN {commerce_order_revision} revision ON revision.revision_id = base.revision_id WHERE (base.order_id IN (:db_condition_placeholder_0)) FOR UPDATE; Array ( [:db_condition_placeholder_0] => 1 ) in DrupalDefaultEntityController->load() (line 196 of C:\Sites\includes\entity.inc).

Do you have any idea what is wrong?

Clive · Accepted Answer · 2011-11-17 23:36:28Z

2

The sessions table has been known to get corrupted, try running a REPAIR TABLE sessions query against your database.

answered Nov 17, 2011 at 23:36

Clive

36.9k8 gold badges89 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

clockworkworks Over a year ago

I see, seems to have worked for now.. It started happening when introduced the commerce module..

Clive Over a year ago

@clockworkworks: On closer inspection is seems to be a reported bug...no fix as yet :(

clockworkworks Over a year ago

spoke too soon is still doin it.... has somehing to do with (line 196 of C:\Sites\includes\entity.inc).

clockworkworks Over a year ago

well at least i know it isnt me ha. im thinking maybe should just use Ubercart then for the time being? until a fix comes up.... would you reccomend this? Thanks again Clive

Clive Over a year ago

I would recommend Ubercart 110%, I've used Commerce and Ubercart for Drupal 7 and Commerce just isn't mature enough yet in my humble opinion (or at least the add-on modules aren't). I'm currently developing several Ubercart 7 sites, and have one in production as well and they're all working great

|

Collectives™ on Stack Overflow

Drupal SQL timeout error

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related