MySQL Forums :: Newbie :: Error: ORDER BY clause


Advanced Search

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 MyISAM...so 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
FreeBSD 6.2-RELEASE
4GB RAM

my.cnf:
[mysqld]
max_allowed_packet=600M
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*/;
DELIMITER ;;
DELIMITER ;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE */;
SELECT /*!40001 SQL_NO_CACHE */ * FROM %s SELECT /*!40001 SQL_NO_CACHE */ * INTO OUTFILE '%s' when executing 'SELECT INTO OUTFILE'


Thanks!!!
Mike

Options: ReplyQuote


Subject Written By Posted
Error: ORDER BY clause Mike Sangray 07/01/2009 10:30AM
Re: Error: ORDER BY clause Rick James 07/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.