Hi everyone, For those who have/had problems with Webrick not properly closing MySQL connections, there is a new MySQL gem. (Actually the version was released some time ago, just nobody took the time to make a gem) So run "gem update" or just "gem install mysql" to update (not sure if the latter also updates). Special thanks to Tobias Luetke, who forwarded the gem to Chad on RubyForge. Kind Regards, Flurin Egger
Thanks for the info! I''ve had this issue on OS X but have been ignoring it since it was easy to stop/restart webrick. Although... I''ve noticed lately that it has been happening right in the middle of coding something important -- Murphy''s law at work I guess. aw On 6/24/05, Flurin Egger <f.egger.mailings-c2BlD8dJSIudKNnQ2JlF7Q@public.gmane.org> wrote:> > Hi everyone, > > For those who have/had problems with Webrick not properly closing MySQL > connections, there is a new MySQL gem. (Actually the version was > released some time ago, just nobody took the time to make a gem) > > So run "gem update" or just "gem install mysql" to update (not sure if > the latter also updates). > > Special thanks to Tobias Luetke, who forwarded the gem to Chad on > RubyForge. > > Kind Regards, > Flurin Egger > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >_______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
Are there any other advantages to this gem that would make it worth bugging DreamHost to install it on their servers? On 6/24/05, Flurin Egger <f.egger.mailings-c2BlD8dJSIudKNnQ2JlF7Q@public.gmane.org> wrote:> Hi everyone, > > For those who have/had problems with Webrick not properly closing MySQL > connections, there is a new MySQL gem. (Actually the version was > released some time ago, just nobody took the time to make a gem)
See http://www.tmtm.org/en/mysql/ruby/ for more information (at the bottom under "history"). The previous gem was version 2.5.1 Flurin Carl Youngblood wrote:>Are there any other advantages to this gem that would make it worth >bugging DreamHost to install it on their servers? > >On 6/24/05, Flurin Egger <f.egger.mailings-c2BlD8dJSIudKNnQ2JlF7Q@public.gmane.org> wrote: > > >>Hi everyone, >> >>For those who have/had problems with Webrick not properly closing MySQL >>connections, there is a new MySQL gem. (Actually the version was >>released some time ago, just nobody took the time to make a gem) >> >> >_______________________________________________ >Rails mailing list >Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org >http://lists.rubyonrails.org/mailman/listinfo/rails > >
On Jun 24, 2005, at 1:37 PM, Flurin Egger wrote:> See http://www.tmtm.org/en/mysql/ruby/ for more information (at the > bottom under "history"). The previous gem was version 2.5.1Is this my problem or a more general problem? Attempting remote installation of ''mysql'' ERROR: While executing gem ... (OpenURI::HTTPError) 404 Not Found
On Jun 24, 2005, at 12:39 PM, Steven Palm wrote:> On Jun 24, 2005, at 1:37 PM, Flurin Egger wrote: > >> See http://www.tmtm.org/en/mysql/ruby/ for more information (at >> the bottom under "history"). The previous gem was version 2.5.1 > > Is this my problem or a more general problem? > > Attempting remote installation of ''mysql'' > ERROR: While executing gem ... (OpenURI::HTTPError) > 404 Not Found >Been like that for a while. When the gem was outdated, I did a gem uninstall mysql cd /usr/local/src/ {or wherever you temporarily put things} curl -O http://www.tmtm.org/en/mysql/ruby/mysql-ruby-2.6.tar.gz tar zxvf mysql-ruby-2.6.tar.gz cd mysql-ruby-2.6/ ruby extconf.rb --with-mysql-include=/usr/local/include/mysql --with- mysql-lib=/usr/local/lib/mysql make install The mysql-include and lib might have to be adjusted. - Jason
Under OS X 10.4.1, I''m getting this error with 2.6: gcc -fno-common -arch ppc -g -Os -pipe -fno-common -arch ppc -pipe -pipe -fno-common -I. -I/usr/lib/ruby/1.8/powerpc-darwin8.0 -I/usr/lib/ruby/1.8/powerpc-darwin8.0 -I. -DHAVE_MYSQL_SSL_SET -DHAVE_MYSQL_H -I/usr/local/mysql/include -c mysql.c mysql.c: In function ''query'': mysql.c:635: error: invalid storage class for function ''res_free'' make: *** [mysql.o] Error 1 2.5.2 works fine. -PJ On 6/24/05, Jason A. Hoffman <jason-xKtDo/uLHBtl57MIdRCFDg@public.gmane.org> wrote:> > On Jun 24, 2005, at 12:39 PM, Steven Palm wrote: > > On Jun 24, 2005, at 1:37 PM, Flurin Egger wrote: > > > >> See http://www.tmtm.org/en/mysql/ruby/ for more information (at > >> the bottom under "history"). The previous gem was version 2.5.1 > > > > Is this my problem or a more general problem? > > > > Attempting remote installation of ''mysql'' > > ERROR: While executing gem ... (OpenURI::HTTPError) > > 404 Not Found > > > > Been like that for a while. When the gem was outdated, I did a > > gem uninstall mysql > cd /usr/local/src/ {or wherever you temporarily put things} > curl -O http://www.tmtm.org/en/mysql/ruby/mysql-ruby-2.6.tar.gz > tar zxvf mysql-ruby-2.6.tar.gz > cd mysql-ruby-2.6/ > ruby extconf.rb --with-mysql-include=/usr/local/include/mysql --with- > mysql-lib=/usr/local/lib/mysql > make install > > The mysql-include and lib might have to be adjusted. > > - Jason > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
> For those who have/had problems with Webrick not properly closing MySQL > connections, there is a new MySQL gem. (Actually the version was > released some time ago, just nobody took the time to make a gem)Hello, can you better describe the problem that this gem fixes? I have seen some sporadic ''Mysql has gone away'' errors on a Webrick application. It would be great if the latest version fixes those errors. regards, George. -- http://www.nitrohq.com http://www.joy.gr
On 6/24/05, PJ Hyett <pjhyett-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Under OS X 10.4.1, I''m getting this error with 2.6: > > gcc -fno-common -arch ppc -g -Os -pipe -fno-common -arch ppc -pipe > -pipe -fno-common -I. -I/usr/lib/ruby/1.8/powerpc-darwin8.0 > -I/usr/lib/ruby/1.8/powerpc-darwin8.0 -I. -DHAVE_MYSQL_SSL_SET > -DHAVE_MYSQL_H -I/usr/local/mysql/include -c mysql.c > mysql.c: In function ''query'': > mysql.c:635: error: invalid storage class for function ''res_free'' > make: *** [mysql.o] Error 1 >Same setup, I get exactly the same error. M -- Matt Mower :: http://matt.blogs.it/
On 6/24/05, PJ Hyett <pjhyett-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Under OS X 10.4.1, I''m getting this error with 2.6: > > gcc -fno-common -arch ppc -g -Os -pipe -fno-common -arch ppc -pipe > -pipe -fno-common -I. -I/usr/lib/ruby/1.8/powerpc-darwin8.0 > -I/usr/lib/ruby/1.8/powerpc-darwin8.0 -I. -DHAVE_MYSQL_SSL_SET > -DHAVE_MYSQL_H -I/usr/local/mysql/include -c mysql.c > mysql.c: In function ''query'': > mysql.c:635: error: invalid storage class for function ''res_free'' > make: *** [mysql.o] Error 1 >This turns out to be a problem with the C code in the extension. You''re not supposed to declare static functions within other functions and GCC 4.0 now enforces this, hence the error. My solution was to move the declaration of res_free (mysql.c:635) outside the enclosing function and it then compiles without any problems. According to KirinDave in #rubyonrails the simpler solution was to gcc_select 3.3 to get the older behaviour ;-) Regards, Matt -- Matt Mower :: http://matt.blogs.it/