Hello,
I have a very strange problem that started about a week ago and I can't figure out why it's happening now.
I have several sites running on Barracuda-Octopus-Aegir platform that have been working fine for months, but then last week one of the site owners discovered that they could not add a node to a nodequeue.
Removing a node from a nodequeue works fine, but you cannot re-add it or add a new one.
Upon investigation, I have discovered that every site I have on the BOA system that is using Nodequeue-7.x-2.0-beta1 now gets an error like this when I try to add a node to nodequeue.
Additional uncaught exception thrown while handling exception.
Original
PDOException: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query: INSERT INTO {nodequeue_nodes} (sqid, qid, nid, position, timestamp) VALUES (:sqid, :qid, :nid, IFNULL((SELECT MAX(position)+1 FROM (SELECT * from {nodequeue_nodes} WHERE sqid = :sqid) as nn), 1), :time); Array ( [:sqid] => 1 [:qid] => 1 [:nid] => 88 [:time] => 1335464651 ) in nodequeue_subqueue_add() (line 1044 of /data/disk/BOA-USER/static/custom/PLATFORM/sites/all/modules/nodequeue/nodequeue.module).
Additional
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {system} WHERE type = 'theme' OR (type = 'module' AND status = 1) ORDER BY weight ASC, name ASC; Array ( ) in system_list() (line 165 of /data/disk/BOA-USER/static/custom/PLATFORM/includes/module.inc).
Uncaught exception thrown in session handler.
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in _drupal_session_write() (line 206 of /data/disk/BOA-USER/static/custom/PLATFORM/includes/session.inc).
This even happens for nodes that were in a nodequeue, removed and then attempted to be readded.
Frankly, I don't think it's really a nodequeue problem because I have been successfully using this version of the module for months, but I thought I should report it here also just in case others have the problem or someone watching this forum has some insight as to what might be going on.
Here's the link to the description of the problem at Barracuda Project: http://drupal.org/node/1551136
Thanks for any help in advance.
Steve
Comments
Comment #1
wickwood commentedI discovered that this was fixed in the last commit of the 7.x-2.0-dev version of this module on Jan 24, 2012. http://drupalcode.org/project/nodequeue.git/commit/9572de5
Also this issue is essentially a duplicate of the issue PDOException: SQLSTATE[HY000]: General error: 1093