WordPress database error Can't create/write to file '/tmp/#sql_e94_0.MYI' (Errcode: 28) for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (480) ORDER BY t.name ASC made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms WordPress database error Can't create/write to file '/tmp/#sql_e94_0.MYI' (Errcode: 28) for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (138) ORDER BY t.name ASC made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, start_post_rel_link, get_boundary_post_rel_link, get_boundary_post, get_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms
Written on October 30, 2011
if you are working with a new installed OSX Lion 10.7.* and XCode 4.2 i bet you will experiencing segmentation fault bug when tried to run fiber on ruby 1.9.2, by the time i wrote this post, many developers still hang on this issue on how to fix that.
f = Fiber.new { puts “hello” }
f.resume
The command above will return a stack trace of the error.
After day and night researching through the forums, blogs and project trakers i figured out that the problem was XCode now deprecating GNU gcc compilers and not including it in XCode 4.2, there is a memory issue as result of compiling package using default apple compiler (LLVM), so the solution is using gcc to compile ruby during the installation.
The solution is download the GNU gcc here and install it, I wrote a separated post on details of the compiler issue here.
Then if you are using RVM uninstall it using this command: rvm implode
Now we need to install the RVM back: http://beginrescueend.com/
Then install the ruby: rvm install 1.9.2-p180
Test by run irb and this piece of codes below:
f = Fiber.new { puts “hello” }
f.resume
It should returning no error