# Upgrading to 1.1 causes MySQL Lost Connections under WinXP **URL:** \ **Category:** Rails\ **Created:** [March 30, 2006, 7:40am UTC](https://www.ruby-forum.com/t/upgrading-to-1-1-causes-mysql-lost-connections-under-winxp/56328 "2006-03-30T07:40:48Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![charlie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/d6d6ee/32.png) [@charlie](https://www.ruby-forum.com/u/charlie)\ **Post date:** [March 30, 2006, 7:40am UTC](https://www.ruby-forum.com/t/upgrading-to-1-1-causes-mysql-lost-connections-under-winxp/56328/1 "2006-03-30T07:40:48Z")
Ok so I updated my rails to version 1.1 and now all of a sudden I keep getting the dreaded “Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS FROM …” I’ve read all the stuff on the net, but none of it is working. I tried installing the mysql.so like suggested here: [http://wiki.rubyonrails.org/rails/pages/HowToUseMySQLRubyBindingsOnWin32/](http://wiki.rubyonrails.org/rails/pages/HowToUseMySQLRubyBindingsOnWin32/) That sort of worked. I was able to get rails working a little bit, but it eventually crashed with this: This application has requested the Runtime to terminate it in an unusual way. Please contact the application’s support team for more information. I could open a couple of pages, but eventually it bombed out in the middle of a request. I’m running Ruby 1.8.2, Rail 1.1, and MySQL 5.0.18 on WinXP machine. Actually I’ve tried it on two different machines I still get the same problem. Prior to upgrading I was using Rails 0.14 and it worked great. It was only after I upgraded to 1.1 did this MySQL problem start. I also should mention I tried reseting the passwords so they don’t use the old\_password hash algorithm. I had read somwhere that the old style passwords could cause this problem too. But, that doesn’t seem to be the issue. Thanks Charlie ---
**Author:** ![charlie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/d6d6ee/32.png) [@charlie](https://www.ruby-forum.com/u/charlie)\ **Post date:** [March 30, 2006, 9:05am UTC](https://www.ruby-forum.com/t/upgrading-to-1-1-causes-mysql-lost-connections-under-winxp/56328/2 "2006-03-30T09:05:29Z")
2006/3/30, Charlie [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > Ok so I updated my rails to version 1.1 and now all of a sudden I keep > getting the dreaded “Mysql::Error: Lost connection to MySQL server > during query: SHOW FIELDS FROM …” I’ve read all the stuff on the net, > but none of it is working. I tried installing the mysql.so like > suggested here: Same issue here. 1.8.2, Rails Edge, haven’t touched the mysql.so at all, and MySQL 4.0.12-nt. I _think_ this is related to the allow\_concurrency changes in 1.1. Sorry I can’t provide you with more information. If you run Rails from svn:externals, you could try going back in time to see if pre-allow\_concurrency would change things for you. If you don’t know how to set your svn:externals, try rake rails:freeze:edge REVISION=? You’ll have to find the appropriate revision using the Timeline: [http://dev.rubyonrails.org/timeline](http://dev.rubyonrails.org/timeline) If you get any results, please post back here. Hope that helps ! ---
**Author:** ![charlie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/d6d6ee/32.png) [@charlie](https://www.ruby-forum.com/u/charlie)\ **Post date:** [March 30, 2006, 4:06pm UTC](https://www.ruby-forum.com/t/upgrading-to-1-1-causes-mysql-lost-connections-under-winxp/56328/3 "2006-03-30T16:06:48Z")
François Beausoleil wrote: > 2006/3/30, Charlie [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > > > Ok so I updated my rails to version 1.1 and now all of a sudden I keep > > getting the dreaded “Mysql::Error: Lost connection to MySQL server > > during query: SHOW FIELDS FROM …” I’ve read all the stuff on the net, > > but none of it is working. I tried installing the mysql.so like > > suggested here: > > Same issue here. 1.8.2, Rails Edge, haven’t touched the mysql.so at > all, and MySQL 4.0.12-nt. I _think_ this is related to the > allow\_concurrency changes in 1.1. > > Sorry I can’t provide you with more information. If you run Rails > from svn:externals, you could try going back in time to see if > pre-allow\_concurrency would change things for you. I’m pretty green with Rails so this is starting to get over my head, but I tried looking at the timeline. I did a search and nothing came up for “pre-allow\_concurrency” so I’m stuck. I didn’t see it in there. I guess I’ll give it the weekend and see if anyone else can make some headway on this. Charlie ---
**Author:** ![charlie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/d6d6ee/32.png) [@charlie](https://www.ruby-forum.com/u/charlie)\ **Post date:** [March 30, 2006, 5:27pm UTC](https://www.ruby-forum.com/t/upgrading-to-1-1-causes-mysql-lost-connections-under-winxp/56328/4 "2006-03-30T17:27:16Z")
Charlie, Give ruby 1.8.4 a shot, I’m running a similar configuration on a windows box and the only difference seems to be ruby versions. –mark Charlie wrote: > François Beausoleil wrote: > > > 2006/3/30, Charlie [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid): > > > > > Ok so I updated my rails to version 1.1 and now all of a sudden I keep > > > getting the dreaded “Mysql::Error: Lost connection to MySQL server > > > during query: SHOW FIELDS FROM …” I’ve read all the stuff on the net, > > > but none of it is working. I tried installing the mysql.so like > > > suggested here: – sic transit gloria et adulescentia blog | [http://blog.hasno.info/blog](http://blog.hasno.info/blog) wiki | [http://wiki.hasno.info](http://wiki.hasno.info) ---
**Author:** ![charlie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/d6d6ee/32.png) [@charlie](https://www.ruby-forum.com/u/charlie)\ **Post date:** [March 30, 2006, 5:44pm UTC](https://www.ruby-forum.com/t/upgrading-to-1-1-causes-mysql-lost-connections-under-winxp/56328/5 "2006-03-30T17:44:08Z")
Charlie wrote: > Ok so I updated my rails to version 1.1 and now all of a sudden I keep > getting the dreaded “Mysql::Error: Lost connection to MySQL server > during query: SHOW FIELDS FROM …” I’ve read all the stuff on the net, > but none of it is working. I tried installing the mysql.so like > suggested here: I had a similar problem… fixed it by going in and editing my database.yml file under the config directory. I relpaced all potential tab characters (erring on the side of caution) with spaces and made sure there was at least one space after each colon (like host: localhost rather than host:localhost). Everything went fine after that. good luck. joe