XP + MySQL + Rails = migration weirdness?


It seems I have come into uncommon situation here.

I and my fellow dev have probably almost identical machines in terms of
OS, SQLD, Ruby, Rails and gems...

However, where in my system everything works fine, he experiences weird
errors while migrating database.

c:\busiu>rake db:drop:all
(in c:/busiu)

c:\busiu>rake db:create:all
(in c:/busiu)

c:\busiu>rake db:migrate
(in c:/busiu)
rake aborted!
Mysql::Error: Commands out of sync; you can't run this command now: SHOW

(See full trace by running task with --trace)

As you can see, the schema_info is bringing us trouble, but I have
absolutely no ideas what is happening out there.

Perhaps anyone had similar experience and could share his wisdom? :slight_smile:

Some debugging info is below:

c:\busiu>gem list --local

*** LOCAL GEMS ***

abstract (1.0.0)
actionmailer (2.0.2)
actionpack (2.0.2)
activerecord (2.0.2)
activeresource (2.0.2)
activesupport (2.0.2)
cgi_multipart_eof_fix (2.5.0)
erubis (2.6.2)
fxri (0.3.6)
fxruby (1.6.12)
gem_plugin (0.2.3)
hpricot (0.6)
log4r (1.0.5)
mongrel (1.1.5)
mysql (2.7.3)
packr (1.0.2)
rails (2.0.2)
rake (0.7.3)
rmagick (2.5.0)
rubygems-update (1.2.0)
sources (0.0.1)
win32-api (1.0.4)
win32-clipboard (0.4.3)
win32-dir (0.3.2)
win32-eventlog (0.4.6)
win32-file (0.5.4) -
win32-file-stat (1.2.7)
win32-process (0.5.3)
win32-sapi (0.1.4)
win32-sound (0.4.1)
win32console (1.1.0)
windows-api (0.2.0)
windows-pr (0.7.2)

c:\busiu>mysql --version
mysql Ver 14.12 Distrib 5.0.51b, for Win32 (ia32)

c:\busiu>ruby --version
ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32]


PP Junty wrote:

apparently the sql command "show tables" is being called
inside your migration, perhaps that is the problem.

But on other development machine migration runs successfuly..