# Problem: The command "rake db:create:all" crashes

**URL:** <https://www.ruby-forum.com/t/problem-the-command-rake-dball-crashes/183958>\
**Category:** Rails\
**Created:** [February 23, 2010, 3:26am UTC](https://www.ruby-forum.com/t/problem-the-command-rake-dball-crashes/183958 "2010-02-23T03:26:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![RichardOnRails](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e0b2c6/32.png) [@RichardOnRails](https://www.ruby-forum.com/u/RichardOnRails)\
**Post date:** [February 23, 2010, 3:26am UTC](https://www.ruby-forum.com/t/problem-the-command-rake-dball-crashes/183958/1 "2010-02-23T03:26:02Z")

</div>

Hi All,

I’m running:  
Rails 2.3.5  
MySQL 5.1.44  
WindowsXP-Pro/SP3

Following Noel Rappin’s book, Pro RoR, I successfully got past the  
point of creating my first scaffold:  
ruby script/generate scaffold supplier nickname:string qbname:string  
That produced the migration, 20100221011210\_create\_suppliers.rb:  
class CreateSuppliers \< ActiveRecord::Migration  
def self.up  
create\_table :suppliers do |t|  
t.string :nickname  
t.string :qbname

```
  t.timestamps
end

```

end

def self.down  
drop\_table :suppliers  
end  
end

Then I ran “rake db:create:all”. The Command Window display for this  
is:

K:\_Projects\Ruby\_Rails\_Apps\_EIMS\RTS\>rake db:create:all  
(in K:/\_Projects/Ruby/\_Rails\_Apps/\_EIMS/RTS)  
K:/\_Utilities/ruby186-26\_rc2/ruby/lib/ruby/gems/1.8/gems/  
activesupport-2.3.5/lib/active\_support/core\_ext/module/  
introspection.rb:73: [BUG] Segmentation fault  
ruby 1.8.6 (2007-09-24) [i386-mswin32]

This application has requested the Runtime to terminate it in an  
unusual way.  
Please contact the application’s support team for more information.

K:\_Projects\Ruby\_Rails\_Apps\_EIMS\RTS\>

Then I checked for generated databases with:  
mysql\> show databases;

Among several tables, it showed only one of my RTS app’s expected  
databases: rts\_development.  
My database.yaml specifies the normal 3: development, test and  
production

Further, I tested whether this database had the specified table  
“supplier”:  
mysql\> show tables in rts\_development;  
Empty set (0.00 sec)

Then I tested whether I could drop the RTS database:  
mysql\> drop database if exists rts\_development;  
Query OK, 0 rows affected (0.01 sec)

All the logs in RTS\log are empty except for development.log. But as  
far as I can tell, all that data was written a couple of days ago  
when I had an older edition of MySQL and gave me crashes.

Any ideas on how to proceed. I’ve tested my current version of MySQL  
with a number of commands in the MySQL monitor in a Windows Command  
Window and seems to perform well.

Any ideas?

Thanks in Advance,Richard

---

<div class="post-metadata">

**Author:** ![RichardOnRails](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e0b2c6/32.png) [@RichardOnRails](https://www.ruby-forum.com/u/RichardOnRails)\
**Post date:** [February 23, 2010, 9:58am UTC](https://www.ruby-forum.com/t/problem-the-command-rake-dball-crashes/183958/2 "2010-02-23T09:58:39Z")

</div>

> Any ideas on how to proceed. I’ve tested my current version of MySQL  
> with a number of commands in the MySQL monitor in a Windows Command  
> Window and seems to perform well.
> 
> Any ideas?
> 
> Thanks in Advance,Richard

I know there are some issues with RoR and MySQL 5.1 on windows, at least  
for Vista x64 and Win7 x64. I dont know if there’s a bug with the  
adapter or if  
its mysql itself. I suggest you try version 5.0.

---

<div class="post-metadata">

**Author:** ![RichardOnRails](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e0b2c6/32.png) [@RichardOnRails](https://www.ruby-forum.com/u/RichardOnRails)\
**Post date:** [February 23, 2010, 6:03pm UTC](https://www.ruby-forum.com/t/problem-the-command-rake-dball-crashes/183958/3 "2010-02-23T18:03:57Z")

</div>

Hi Sharagoz,

> I suggest you try version 5.0.

5.0 was working well for years on my WinXP machine. I thought that  
since I had a bad installation for the purpose rake db:create:all, I  
outgh to get the latest release of MySQL. But that extra step might  
have been unwise.

Thanks for the suggestion.  
Richard