I keep getting the following message in pink text whenever I try to go to the "recent posts" section:
* warning: mysqli_query() [function.mysqli-query]: (HY000/5): Out of memory (Needed 1048548 bytes) in /usr/home/boaddrink/drupal/includes/database.mysqli.inc on line 132.
* user warning: Got error 12 from storage engine query: pager_query SELECT DISTINCT(n.nid), f.tid, n.title, n.sticky, u.name, u.uid, n.created AS timestamp, n.comment AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid != 0, cu.name, l.last_comment_name) AS last_comment_name, l.last_comment_uid, l.comment_count AS num_comments FROM node_comment_statistics l, users cu, term_node r, users u, forum f, node n INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access') OR (na.gid = 3 AND na.realm = 'term_access'))) AND ( n.status = 1 AND l.last_comment_uid = cu.uid AND n.nid = l.nid AND n.nid = r.nid AND r.tid = 3 AND n.uid = u.uid AND n.vid = f.vid) ORDER BY n.sticky DESC, l.last_comment_timestamp DESC, n.created DESC LIMIT 0, 25 in /usr/home/boaddrink/drupal/includes/database.mysqli.inc on line 151.
Any clue why?
I don't think it's a recent posts issue. The database is being a little flakey at the moment. I'm keeping a watch on it.Â
Boad Redblades
KOTG Webmaster and badly dressed retired Ranger
Side note, the permissions are being really odd right now on the forums. I'm working on them but it takes some time so everybody please be patient.Â
Boad Redblades
KOTG Webmaster and badly dressed retired Ranger
Meboom Mebigg, 75 Conqueror
Tried to log in at 2:55pm pacific time on Monday, 12 Mar. It shows 2 of me currently logged in. And my login attempts alternated between getting logged in ok and receiving the following error message:
Warning: mysqli_error() [function.mysqli-error]: invalid object or resource mysqli in /usr/home/boaddrink/drupal/includes/database.mysqli.inc on line 89
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/boaddrink/drupal/includes/database.mysqli.inc:89) in /usr/home/boaddrink/drupal/includes/common.inc on line 141
The first time i was able to log in ok, all posted messages were at least 1 year old but they got more recent as I logged out then back in, interspersed with the above error message where I would just closed the window and connect to the website again.
Yeah, the mysql server has been all over the place for the past day. I've been watching it and manually restarting it when needed. I just recommpiled from source both the server and the client, lets hope that fixes it (server was having swap errors earlier today too... when it rains it pours).Â
Boad Redblades
KOTG Webmaster and badly dressed retired Ranger
Receiving these messages again this morning:
user warning: Got error 12 from storage engine query: forum_block SELECT DISTINCT(n.nid), n.title, l.comment_count FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access') OR (na.gid = 3 AND na.realm = 'term_access'))) AND ( n.type = 'forum' AND n.status = 1 ) ORDER BY n.nid DESC LIMIT 0, 5 in /usr/home/boaddrink/drupal/includes/database.mysqli.inc on line 151.
And:
user warning: Got error 12 from storage engine query: pager_query SELECT DISTINCT(node.nid), node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.type AS node_type, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp FROM node node LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN users users ON node.uid = users.uid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access') OR (na.gid = 3 AND na.realm = 'term_access'))) AND ( (node.status = '1') ) ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 25 in /usr/home/boaddrink/drupal/includes/database.mysqli.inc on line 151.
This is actually a pretty small error compared to whats been happening over the past few days.  Mysql is having issues allocating memory.   I'll fix it this evening... until then, pretend there are no red boxes :)Â
Boad Redblades
KOTG Webmaster and badly dressed retired Ranger
Ok, lets try this again... I'll keep an eye on the logs for this error message. At least the db server isn't totaly dieing like yesterday.Â
Boad Redblades
KOTG Webmaster and badly dressed retired Ranger
