after running drush rr or drush cc I get this intermittently

WD facebook_publication_type: PDOException: SQLSTATE[40001]: Serialization failure: 1213 [error]
Deadlock found when trying to get lock; try restarting transaction: DELETE FROM
{semaphore}
WHERE (name = :db_condition_placeholder_0) AND (value = :db_condition_placeholder_1) AND
(expire menu_rebuild
[:db_condition_placeholder_1] => 159081450951ddebe6274ab4.86019032
[:db_condition_placeholder_2] => 1373498388.8027
)
in lock_may_be_available() (line 181 of
/var/aegir/platforms/7/servers/openatrium-7.x-2.x-dev/includes/lock.inc).

Comments

MtRoxx’s picture

Same issue here.

PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; 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] => 5053538605209685f87d367.87262302 [:db_condition_placeholder_2] => 1376348287.04 ) in lock_may_be_available() (line 181 of /home/domain/public_html/includes/lock.inc).

brentratliff’s picture

Issue summary: View changes

Same issue, any ideas?

MtRoxx’s picture

@brentratliff It has been an ongoing issue. I am working on my db now on my server. I did not find a work around, except to wait. Then when I upgrade a module that has a db update it goes through. I'm assuming (always dangerous) that when there is not an db update it hangs. I could be very wrong here.

e0ipso’s picture

Can you post the version of Facebook Autopost and Features you are using?

sahaj’s picture

I was getting similar error, using Facebook Autopost 7.x-1.2+3-dev & Features 7.x-2.0.
If it can help.. now I have uninstalled Facebook Autopost and got ride of the error message.
Somehow a pity, but my main interest about Facebook Autopost was to post images gallery, which I never succeed at, and neither did I heard anyone else succeeding at it.
I liked the concept of using rules with FB, but sounds a bit complicated for only simply sharing links.

P.S.: I wasn't using Features 7.x-2.1 because got some error while updating it. Now also got ride of it because not required by any other of my modules.

MtRoxx’s picture

I learned that it was not a Facebook module issue. I found that if I put the site in maintenance mode while updating I had the serial lock error. Which, for the record, is where I think it should be during any update procedures. When I update while in active mode I do not get the error. THANK YOU e0ipso for being willing to help. Please close the ticket.

e0ipso’s picture

@sahaj, sorry to see you not succeeding at this. I definitely posted images to an album. I have not tested creating albums in Facebook automatically, but it would be great if you could research & document your findings. The documentation could use some more love.

@MtRoxx thanks for taking the time to contribute back your findings. Hopefully someone in your very same situation will find it useful!

sahaj’s picture

@e0ipso ok, I will not give up and come back to other thread if I need more help and of course to the documentation if I succeed. ;)