upgrade to 0.8.0 failed on MySQL errorcode 13

Added by Ivor Boers almost 11 years ago

I tried to uupgrade my redmine 0.7.3 insatllation to 0.8.0. I followed the upgrade instructions on the RedmineUpgrade page of the wiki.
step 2 failed (rake db:migrate RAILS_ENV="production").

Mysql::Error: Can't create/write to file 'C:\Windows\TEMP\#sql_9fc_0.MYI' (Errco
de: 13): SHOW FIELDS FROM `issue_categories`

My system is Windows Vista, (I have administartor rights). Before upgrading Redmine I updated my ruby and rails environment.
I believe errorcode 13 has to do with permissions.

Can anyone tell me how to solve this problem and upgrade Redmine?

Here is the trace:
C:\Development\redmine-0.8.0>rake db:migrate RAILS_ENV="production" --trace
(in C:/Development/redmine-0.8.0)
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
  • Execute db:migrate
  • Invoke db:schema:dump (first_time)
  • Invoke environment
  • Execute db:schema:dump
    rake aborted!
    Mysql::Error: Can't create/write to file 'C:\Windows\TEMP\#sql_9fc_0.MYI' (Errco
    de: 13): SHOW FIELDS FROM `issue_categories`
    C:/Development/redmine-0.8.0/vendor/rails/activerecord/lib/active_record/connect
    ion_adapters/abstract_adapter.rb:147:in `log'
    C:/Development/redmine-0.8.0/vendor/rails/activerecord/lib/active_record/connect
    ion_adapters/mysql_adapter.rb:302:in `execute'
    C:/Development/redmine-0.8.0/vendor/rails/activerecord/lib/active_record/connect
    ion_adapters/mysql_adapter.rb:433:in `columns'
    C:/Development/redmine-0.8.0/vendor/rails/activerecord/lib/active_record/schema_
    dumper.rb:75:in `table'
    C:/Development/redmine-0.8.0/vendor/rails/activerecord/lib/active_record/schema_
    dumper.rb:70:in `tables'
    C:/Development/redmine-0.8.0/vendor/rails/activerecord/lib/active_record/schema_
    dumper.rb:61:in `each'
    C:/Development/redmine-0.8.0/vendor/rails/activerecord/lib/active_record/schema_
    dumper.rb:61:in `tables'
    C:/Development/redmine-0.8.0/vendor/rails/activerecord/lib/active_record/schema_
    dumper.rb:23:in `dump'
    C:/Development/redmine-0.8.0/vendor/rails/activerecord/lib/active_record/schema_
    dumper.rb:17:in `dump'
    C:/Development/redmine-0.8.0/vendor/rails/railties/lib/tasks/databases.rake:219
    C:/Development/redmine-0.8.0/vendor/rails/railties/lib/tasks/databases.rake:218:
    in `open'
    C:/Development/redmine-0.8.0/vendor/rails/railties/lib/tasks/databases.rake:218
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in `call'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in `execut
    e'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in `each'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in `execut
    e'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:578:in `invoke
    _with_call_chain'
    C:/Development/ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:571:in `invoke
    _with_call_chain'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:564:in `invoke
    '
    C:/Development/redmine-0.8.0/vendor/rails/railties/lib/tasks/databases.rake:100
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in `call'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in `execut
    e'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in `each'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in `execut
    e'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:578:in `invoke
    _with_call_chain'
    C:/Development/ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:571:in `invoke
    _with_call_chain'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:564:in `invoke
    '
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2019:in `invok
    e_task'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `top_l
    evel'
    C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `each'

C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `top_l
evel'
C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in `stand
ard_exception_handling'
C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1991:in `top_l
evel'
C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1970:in `run'
C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in `stand
ard_exception_handling'
C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1967:in `run'
C:/Development/ruby/lib/ruby/gems/1.8/gems/rake-0.8.3/bin/rake:31
C:/Development/ruby/bin/rake:16:in `load'
C:/Development/ruby/bin/rake:16