Thanks that worked... I raised it to 2M which is what my deployment servers use. Mine was set at 32K on my dev box.
Though..... I never, ever, had to do this before. I will monitor this closely, but so far so great. Thanks James On Feb 6, 2012, at 7:44 AM, Kieran Kelleher wrote: > Hi James, > > You can check your current value by doing: > > (root@localhost@macpro) (none)> show variables like 'sort_buffer_size'; > +------------------+----------+ > | Variable_name | Value | > +------------------+----------+ > | sort_buffer_size | 67108864 | > +------------------+----------+ > 1 row in set (0.00 sec) > > > You can set higher value in /etc/my.cnf by adding (or replacing current > value) with 32M (32 megabytes) or 64M. > > > <snip> > # Sort buffer is used to perform sorts for some ORDER BY and GROUP BY > # queries. If sorted data does not fit into the sort buffer, a disk > # based merge sort is used instead - See the "Sort_merge_passes" > # status variable. Allocated per thread if sort is needed. > sort_buffer_size = 32M > </snip> > > > If /etc/my.cnf config is something you are not sure about, I recommend you > checkout the project: > > https://github.com/kierankelleher/gic-mysql-tools > > .... pick a config that most closely matches your server, and then tweak as > needed. Also, please read the README thoroughly for instructions. > > Regards, Kieran > > > > On Feb 6, 2012, at 8:29 AM, James Cicenia wrote: > >> Hello- >> >> I am trying get my tagged objects: >> >> return >> PortfolioProject.taggableEntity().fetchTaggedWith(session().defaultEditingContext(), >> args); >> >> args is an array of strings >> >> >> >> Feb 05 21:41:40 PI[52753] WARN NSLog - >> <com.webobjects.appserver._private.WOComponentRequestHandler>: Exception >> occurred while handling request: >> Out of sort memory; increase server sort buffer sizeat >> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) >> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) >> at >> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113) >> at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364) >> at >> com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:265) >> at >> com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337) >> at >> com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296) >> at >> er.extensions.eof.ERXEOAccessUtilities._rawRowsForSQLExpression(ERXEOAccessUtilities.java:377) >> at >> er.extensions.eof.ERXEOAccessUtilities.rawRowsForSQLExpression(ERXEOAccessUtilities.java:345) >> at er.taggable.ERTaggableEntity.fetchTaggedWith(ERTaggableEntity.java:714) >> at er.taggable.ERTaggableEntity.fetchTaggedWith(ERTaggableEntity.java:678) >> at er.taggable.ERTaggableEntity.fetchTaggedWith(ERTaggableEntity.java:664) >> at er.taggable.ERTaggableEntity.fetchTaggedWith(ERTaggableEntity.java:651) >> at com.tos.reports.TOSD2WQueryPage.taggedProjects(TOSD2WQueryPage.java:132) >> >> I am using mysql. >> >> Thanks >> James >> >> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com >> >> This email sent to [email protected] >
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
