• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: ERTaggable Error?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: ERTaggable Error?

  • Subject: Re: ERTaggable Error?
  • From: Kieran Kelleher <email@hidden>
  • Date: Mon, 06 Feb 2012 08:44:46 -0500
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@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Prev by Date: OVERLOAD AjaxInPlaceEditor
  • Next by Date: Re: AutoLaunch on Windows
  • Previous by thread: OVERLOAD AjaxInPlaceEditor
  • Next by thread: Re: I have to say… ERMD2W is f'ing amazing
  • Index(es):
    • Date
    • Thread