Error: ORDER BY clause

[Mike Sangray]

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