# Mysql, rails , or my own bug?

**URL:** <https://www.ruby-forum.com/t/mysql-rails-or-my-own-bug/113304>\
**Category:** Rails\
**Created:** [August 29, 2007, 6:16pm UTC](https://www.ruby-forum.com/t/mysql-rails-or-my-own-bug/113304 "2007-08-29T18:16:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![zemariamm](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/58956e/32.png) [@zemariamm](https://www.ruby-forum.com/u/zemariamm)\
**Post date:** [August 29, 2007, 6:16pm UTC](https://www.ruby-forum.com/t/mysql-rails-or-my-own-bug/113304/1 "2007-08-29T18:16:17Z")

</div>

Hi guys,  
I’m doing some intensive operations over my mysql database, after some  
queries I get the error:

Processing 1616 of 12886  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_  
adapters/abstract\_adapter.rb:120:in `log': Mysql::Error: #HY000Can't create/writ e to file 'C:\WINDOWS\TEMP\#sql_8ec_0.MYD' (Errcode: 13): SHOW FIELDS FROM featu res_supers (ActiveRecord::StatementInvalid) from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor d/connection_adapters/mysql_adapter.rb:184:in`execute’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_recor  
d/connection\_adapters/mysql\_adapter.rb:292:in `columns' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor d/associations/has_and_belongs_to_many_association.rb:165:in`finding\_with\_ambig  
ious\_select?’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_recor  
d/associations/has\_and\_belongs\_to\_many\_association.rb:44:in `find' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor d/associations/has_and_belongs_to_many_association.rb:93:in`find\_target’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_recor  
d/associations/association\_proxy.rb:116:in `load_target' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor d/associations/association_proxy.rb:109:in`method\_missing’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_recor  
d/associations/has\_and\_belongs\_to\_many\_association.rb:81:in  
`method\_missing’  
from samplesfmoodsok.rb:29  
from samplesfmoodsok.rb:27  
from samplesfmoodsok.rb:23

E:\CMLabsServices\PandoraExtractor\>

I’ve no idea why, but if i restart the machine,sometimes, I don’t get  
that error again… it’s funny because it only happens if i do a lot of  
queries…  
Any ideas ?

Tks in advance  
Ze Maria