Bug #63365 What is errno 120 and 137?
Submitted: 21 Nov 2011 17:41 Modified: 21 Dec 2011 17:48
Reporter: Jamie Koc Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Errors Severity:S2 (Serious)
Version:5.1.42 OS:Linux
Assigned to: CPU Architecture:Any

[21 Nov 2011 17:41] Jamie Koc
Description:
Getting several of these messages in our mysqld.log

111120 14:14:45 [ERROR] myisam_sort_buffer_size is too small
111120 14:14:45 [Warning] Warning: Enabling keys got errno 120 on xyz, retrying
111120 14:14:45 [ERROR] Number of rows changed from 0 to 199

Our buffer size is large.
mysql> show variables like 'myisam_sort_buffer_size';
+-------------------------+------------+
| Variable_name           | Value      |
+-------------------------+------------+
| myisam_sort_buffer_size | 3221225472 |
+-------------------------+------------+

I am also seeing a lots of messages also saying:
[Warning] Warning: Enabling keys got errno 137 on xyz, retrying

How to repeat:
Not sure how to repeat.
[21 Nov 2011 17:48] Valeriy Kravchuk
Doesn't perror utility help? Look:

macbook-pro:trunk openxs$ bin/perror 120
MySQL error code 120: Didn't find key on read or update
macbook-pro:trunk openxs$ bin/perror 137
MySQL error code 137: No more records (read after end of file)
[22 Dec 2011 7:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".