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]
_______________________________________________
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]
