Re: upgrading to v 4.1
4.8-STABLE and linuxthreads-2.2.3_10 and gcc3.2 It's easy for me to reproduce this bug on my system, but I don't know if I could come up with a simple test case for someone to play with. Do you compile with the BUILT_OPTIMIZED flag? --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On Wed, May 28, 2003 at 03:42:24PM -0700, LS wrote: > > > > I don't know about Mac OS X, but I can tell you that with 4.1 on > > FreeBSD w/LinuxThreads, my application's query threads get hung up > > almost instantly, requiring a kill -9. > > > > When I back down to 4.0.13 (and 3.23), I don't see that particular > > problem anymore. So keep an eye out for how it behaves for you on > > Max OS X under load. > > Which version of FreeBSD and LinuxThreads are you using? I've never > experienced that bug before. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.8: up 114 days, processed 3,574,536,636 queries (360/sec. avg) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading to v 4.1
On Wed, May 28, 2003 at 03:42:24PM -0700, LS wrote: > > I don't know about Mac OS X, but I can tell you that with 4.1 on > FreeBSD w/LinuxThreads, my application's query threads get hung up > almost instantly, requiring a kill -9. > > When I back down to 4.0.13 (and 3.23), I don't see that particular > problem anymore. So keep an eye out for how it behaves for you on > Max OS X under load. Which version of FreeBSD and LinuxThreads are you using? I've never experienced that bug before. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.8: up 114 days, processed 3,574,536,636 queries (360/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading to v 4.1
No, in my case, both queries report being in "Connect" state and just stay there. Something like this: >| 14376 | unauthenticated user | 10.0.48.147 | | Connect >| | login > | | >| 14416 | unauthenticated user | 10.0.48.147 | | Connect >| | login Googling around on this I see various people have run into something similar from time to time, so perhaps it's an old bug that has been reintroduced in the 4.1alpha code --- Jocelyn Fournier <[EMAIL PROTECTED]> wrote: > Hi, > > What do you call "hung up" ? All query appearing in "opening table" state > when doing a show processlist ? > If this is the case, I'm experiencing the same problem here with Linux. > > Regards, > Jocelyn > - Original Message - > From: "LS" <[EMAIL PROTECTED]> > To: "Ted Rogers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, May 29, 2003 12:42 AM > Subject: Re: upgrading to v 4.1 > > > > I don't know about Mac OS X, but I can tell you that with 4.1 on FreeBSD > > w/LinuxThreads, my application's query threads get hung up almost > instantly, > > requiring a kill -9. > > > > When I back down to 4.0.13 (and 3.23), I don't see that particular problem > anymore. > > So keep an eye out for how it behaves for you on Max OS X under load. > > > > --- Ted Rogers <[EMAIL PROTECTED]> wrote: > > > Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? Are then any > > > special notes I might remember when doing so? > > > (Mac OS X Server 10.2.6) > > > > > > Ted > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > __ > > Do you Yahoo!? > > Yahoo! Calendar - Free online calendar with sync to Outlook(TM). > > http://calendar.yahoo.com > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading to v 4.1
Hi, What do you call "hung up" ? All query appearing in "opening table" state when doing a show processlist ? If this is the case, I'm experiencing the same problem here with Linux. Regards, Jocelyn - Original Message - From: "LS" <[EMAIL PROTECTED]> To: "Ted Rogers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, May 29, 2003 12:42 AM Subject: Re: upgrading to v 4.1 > I don't know about Mac OS X, but I can tell you that with 4.1 on FreeBSD > w/LinuxThreads, my application's query threads get hung up almost instantly, > requiring a kill -9. > > When I back down to 4.0.13 (and 3.23), I don't see that particular problem anymore. > So keep an eye out for how it behaves for you on Max OS X under load. > > --- Ted Rogers <[EMAIL PROTECTED]> wrote: > > Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? Are then any > > special notes I might remember when doing so? > > (Mac OS X Server 10.2.6) > > > > Ted > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > __ > Do you Yahoo!? > Yahoo! Calendar - Free online calendar with sync to Outlook(TM). > http://calendar.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading to v 4.1
I don't know about Mac OS X, but I can tell you that with 4.1 on FreeBSD w/LinuxThreads, my application's query threads get hung up almost instantly, requiring a kill -9. When I back down to 4.0.13 (and 3.23), I don't see that particular problem anymore. So keep an eye out for how it behaves for you on Max OS X under load. --- Ted Rogers <[EMAIL PROTECTED]> wrote: > Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? Are then any > special notes I might remember when doing so? > (Mac OS X Server 10.2.6) > > Ted > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: upgrading to v 4.1
Ted, 4.1 is not in production release yet. So, for home development to test or develop for new features specific to 4.1, then OK. If your database server is for production use serving critical data, then use 4.0.13 which is the current production release. Follow the instructions carefully and read http://www.mysql.com/doc/en/Upgrading-from-3.23.html and http://www.mysql.com/doc/en/Mac_OS_X_installation.html and http://www.entropy.ch/software/macosx/mysql/ -Original Message- From: Ted Rogers [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 4:52 PM To: [EMAIL PROTECTED] Subject: upgrading to v 4.1 Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? Are then any special notes I might remember when doing so? (Mac OS X Server 10.2.6) Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: upgrading to v 4.1
AHHH! I bet that is why I was having such a horrible time last night trying to upgrade! I finally said fsck it and reverted back to 3.23.55... I don't use a root password on localhost... Now I'll try your suggestions and see if it works. *sigh* *crosses fingers* > -Original Message- > From: Scott Haneda [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 28, 2003 1:59 PM > To: MySql > Subject: Re: upgrading to v 4.1 > > > on 05/28/2003 1:51 PM, Ted Rogers at [EMAIL PROTECTED] wrote: > > > Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? > Are then any > > special notes I might remember when doing so? > > (Mac OS X Server 10.2.6) > > > > Ted > > Yeah, I posted this and no reply, but you need to do this > > Subject : mysql_fix_privilege_tables behaves odd, explain this > Well this is very interesting > > At the start of the script they have > root_password="$1" > host="localhost" > user="root" > > I added in just below the above > echo "--" > echo $root_password > echo "--" > > Then if you try > sh mysql_fix_privilege_tables -p somepassword > Guess what you get... > -- > -p somepassword > -- > > So it seems the script takes the whole argument... > > sh mysql_fix_privilege_tables my_root_pass > Works fine > > Is this standard behavior? > The Script says > echo "If you get 'Access denied' errors, you should run this > script again" > echo "and give the MySQL root user password as an argument!" > > Does not really tell you there is some special way to do it. > What is the > heck is $1 anyway? And why is it a literally quoted value? > > - > Scott HanedaTel: 415.898.2602 > http://www.newgeo.com Fax: 313.557.5052 > [EMAIL PROTECTED]Novato, CA U.S.A. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrading to v 4.1
on 05/28/2003 1:51 PM, Ted Rogers at [EMAIL PROTECTED] wrote: > Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? Are then any > special notes I might remember when doing so? > (Mac OS X Server 10.2.6) > > Ted Yeah, I posted this and no reply, but you need to do this Subject : mysql_fix_privilege_tables behaves odd, explain this Well this is very interesting At the start of the script they have root_password="$1" host="localhost" user="root" I added in just below the above echo "--" echo $root_password echo "--" Then if you try sh mysql_fix_privilege_tables -p somepassword Guess what you get... -- -p somepassword -- So it seems the script takes the whole argument... sh mysql_fix_privilege_tables my_root_pass Works fine Is this standard behavior? The Script says echo "If you get 'Access denied' errors, you should run this script again" echo "and give the MySQL root user password as an argument!" Does not really tell you there is some special way to do it. What is the heck is $1 anyway? And why is it a literally quoted value? - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
