MySQL Forums
Forum List  »  Newbie

Error: ORDER BY clause
Posted by: Mike Sangray
Date: July 01, 2009 10:30AM

Hey all,

I've recently taken over administration of a mysql server and have been working on configuring BakBone's NetVault APM to do backups. Everything is installed, but when we try to do backups they fail when they encounter anything except InnoDB fails, MEMORY fails, etc.
After going the rounds with BakBone tech. support, they've deduced that it's a problem with the mysql server (hence my post here). I've reset some of the buffer sizes via my.cnf, but that hasn't helped.
Any ideas on what to look for to correct the error? I'm new to mysql, and after tweaking the buffer sizes didn't work I am at a loss as to where to go next.

Here's the error and server information.

Error (full error text below):
"Error: Not enough memory to store ORDER BY clause"

Server Info:
MySQL 5.0.27

set-variable = innodb_additional_mem_pool_size=8M
set-variable = innodb_buffer_pool_size=256M
set-variable = innodb_log_buffer_size=4M
set-variable = key_buffer=256M
set-variable = read_buffer_size=8M
set-variable = read_rnd_buffer_size=16M
set-variable = sort_buffer=32M

Full error text (this is where tech. support said the error is):

Warning: Can't set SQL_QUOTE_SHOW_CREATE option (%s)

-- Temporary table structure for view %s

-- It's a view, create dummy table for view
-- Warning: Unable to use delayed inserts for table '%s' because it's of type %s
Warning: Couldn't read keys from table %s; records are NOT sorted (%s)
%s: Can't get keys for table %s (%s)

-- Table structure for table %s

/*!50001 DROP VIEW IF EXISTS %s*/;
Error: Not enough memory to store ORDER BY clause
/*!50003 TRIGGER %s %s %s ON %s FOR EACH ROW%s%s */;;

/*!50003 SET SESSION SQL_MODE="%s" */;;
/*!50003 CREATE */
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
SELECT /*!40001 SQL_NO_CACHE */ * FROM %s SELECT /*!40001 SQL_NO_CACHE */ * INTO OUTFILE '%s' when executing 'SELECT INTO OUTFILE'


Options: ReplyQuote

Written By
Error: ORDER BY clause
July 01, 2009 10:30AM
July 02, 2009 10:54PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.