mysql-3.23.51 with Current for the last few weeks.
This doesn't make much sense and is probably not related but I've had the problem for about a month and thought it was going to go away but it hasn't. I really don't know where to start looking. Just after the KSE changes at the beginning of July I upgraded mysql. Since then I have had intermittent problems with mysql hanging far too often. It takes 100% of the resources and has to be killed. I get no errors in the mysql log nor in the system logs. Has anyone seen this or do you have any ideas for a solution or for trouble shooting? I wanted to try a pkg_add -r but there doesn't seem to be a mysql-server package. I am running today's current and I check it daily to see if it still hangs. I initially thought that it was a problem with this version of mysql but I'm not really sure. Thanks, ed -- - http://worldinternet.org - Mergence of Business and Technology To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-current in the body of the message
Re: mysql-3.23.51 with Current for the last few weeks.
I really don't know where to start looking. Just after the KSE changes at the beginning of July I upgraded mysql. Since then I have had intermittent problems with mysql hanging far too often. It takes 100% of the resources and has to be killed. I get no errors in the mysql log nor in the system logs. This isn't only a mysql problem. The (at least) linux jdk 1.4, jikes and lt_rep (used by librep while building) have the same problem. They're just using CPU time and are doing nothing... (dead-lock?) Marc To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-current in the body of the message
Re: mysql-3.23.51 with Current for the last few weeks.
At 08:54 AM 8/2/2002 -0700, Edwin Culp wrote: This doesn't make much sense and is probably not related but I've had the problem for about a month and thought it was going to go away but it hasn't. I really don't know where to start looking. Just after the KSE changes at the beginning of July I upgraded mysql. Since then I have had intermittent problems with mysql hanging far too often. It takes 100% of the resources and has to be killed. I get no errors in the mysql log nor in the system logs. Has anyone seen this or do you have any ideas for a solution or for trouble shooting? I wanted to try a pkg_add -r but there doesn't seem to be a mysql-server package. I am running today's current and I check it daily to see if it still hangs. I initially thought that it was a problem with this version of mysql but I'm not really sure. Thanks, ed The same thing happend to me a few weeks ago when I did an upgrade from 3.23.49 == 3.23.51 I think what I ended up doing was to use the gcc3.2 from ports, and I built it staticlly. First i installed gcc3.2 the made sure /usr/local/bin was ahead of /usr/bin in my PATH then I built mysql enabling static build. Manfred == || [EMAIL PROTECTED] || || Ph. (415) 681-6235 || == To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-current in the body of the message
Re: mysql-3.23.51 with Current for the last few weeks.
Quoting Marc Recht [EMAIL PROTECTED]: | I really don't know where to start looking. Just after the KSE changes at | the beginning of July I upgraded mysql. Since then I have had | intermittent | problems with mysql hanging far too often. It takes 100% of the resources | and has to be killed. I get no errors in the mysql log nor in the system | logs. | This isn't only a mysql problem. The (at least) linux jdk 1.4, jikes and | lt_rep | (used by librep while building) have the same problem. They're just using | CPU | time and are doing nothing... (dead-lock?) | | Marc Thanks, Marc. I just tried another version of MySQL and it does the same so I think you are right. Thanks for the bad news, I just installed linux jdk 1.4 yesterday and haven't used it yet. Now I know what I have to look forward to this weekend :-) ed - http://worldinternet.org - Mergence of Business and Technology To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-current in the body of the message
Re: mysql-3.23.51 with Current for the last few weeks.
there are several possibilities: 1/ do a ktrace on teh spinning process for a couple of seconds and see what syscalls it is doing. 2/ if it's spinning in the kernel, you can drop into ddb and do a tr pid to see where it is in the kernel... c to continue.. do this several times to ge a sortof 'profile' of where you see it.. On Fri, 2 Aug 2002, Marc Recht wrote: I really don't know where to start looking. Just after the KSE changes at the beginning of July I upgraded mysql. Since then I have had intermittent problems with mysql hanging far too often. It takes 100% of the resources and has to be killed. I get no errors in the mysql log nor in the system logs. This isn't only a mysql problem. The (at least) linux jdk 1.4, jikes and lt_rep (used by librep while building) have the same problem. They're just using CPU time and are doing nothing... (dead-lock?) Marc To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-current in the body of the message
Re: mysql-3.23.51 with Current for the last few weeks.
Quoting Manfred Antar [EMAIL PROTECTED]: | The same thing happend to me a few weeks ago when I did an upgrade from | 3.23.49 == 3.23.51 | I think what I ended up doing was to use the gcc3.2 from ports, and I built | it staticlly. | First i installed gcc3.2 the made sure /usr/local/bin was ahead of /usr/bin | in my PATH | then I built mysql enabling static build. | Manfred Thanks, I'm going to try that right now. ed - http://worldinternet.org - Mergence of Business and Technology To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-current in the body of the message
Re: mysql-3.23.51 with Current for the last few weeks.
On Fri, 2 Aug 2002 10:08:47 -0700 (PDT) Julian Elischer [EMAIL PROTECTED] wrote: there are several possibilities: 1/ do a ktrace on teh spinning process for a couple of seconds and see what syscalls it is doing. stopped jikes with ctrl-c looks always like: 90998 sh RET read 650/0x28a 90998 sh CALL fork 90998 sh RET fork 91009/0x16381 90998 sh CALL getpgrp 90998 sh RET getpgrp 90998/0x16376 90998 sh CALL wait4(0x,0xbfbff498,0x2,0) 90998 sh RET wait4 -1 errno 4 Interrupted system call 90998 sh PSIG SIGINT caught handler=0x80595b0 mask=0x0 code=0x0 90998 sh CALL sigreturn(0xbfbff2b8) 90998 sh RET sigreturn JUSTRETURN 90998 sh CALL wait4(0x,0xbfbff498,0x2,0) 90998 sh RET wait4 91009/0x16381 90998 sh CALL read(0xa,0x80f6e80,0x3ff) 90998 sh GIO fd 10 read 0 bytes 90998 sh RET read 0 90998 sh CALL exit(0x82) 2/ if it's spinning in the kernel, you can drop into ddb and do a tr pid to see where it is in the kernel... c to continue.. I always get these two: Debugger(manual escape to debugger) Stopped at Debugger+0x4d: xchgl %ebx,in_Debugger.0 db tr 3402 mi_switch(c30f36c0,c01f23e8,c30f5cc0,f13c8d3c,c0237b5e) at mi_switch+0x15a ithread_schedule(c30dd500,1,f13c8d3c,c79309c0,0) at ithread_schedule+0x11f sched_ithd(5) at sched_ithd+0x43 Xintr5() at Xintr5+0x67 --- interrupt, eip = 0x80decb0, esp = 0xbfbfe4e0, ebp = 0xbfbfe548 --- db c mi_switch(c30e3d40,0,5,0,800) at mi_switch+0x15a ast(f16ddd48) at ast+0x35a doreti_ast() at doreti_ast+0x1a do this several times to ge a sortof 'profile' of where you see it.. Done that. Hope this helps. Please let me know if I could do more to find this problem. Marc To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-current in the body of the message
Re: mysql-3.23.51 with Current for the last few weeks.
Quoting Manfred Antar [EMAIL PROTECTED]: | At 08:54 AM 8/2/2002 -0700, Edwin Culp wrote: | This doesn't make much sense and is probably not related but I've had the | problem for about a month and thought it was going to go away but it | hasn't. | I really don't know where to start looking. Just after the KSE changes at | the beginning of July I upgraded mysql. Since then I have had intermittent | problems with mysql hanging far too often. It takes 100% of the resources | and has to be killed. I get no errors in the mysql log nor in the system | logs. | | Has anyone seen this or do you have any ideas for a solution or for trouble | shooting? I wanted to try a pkg_add -r but there doesn't seem to be a | mysql-server package. | | I am running today's current and I check it daily to see if it still hangs. | I initially thought that it was a problem with this version of mysql but | I'm | not really sure. | | Thanks, | | ed | | The same thing happend to me a few weeks ago when I did an upgrade from | 3.23.49 == 3.23.51 | I think what I ended up doing was to use the gcc3.2 from ports, and I built | it staticlly. | First i installed gcc3.2 the made sure /usr/local/bin was ahead of /usr/bin | in my PATH | then I built mysql enabling static build. Manford, It didn't work for me. What did you put in this line in the Makefile? CXX=${CC} \ I have compiled it three times, once without change, once by ereasing it and the last by changing it to CXX=${GCC} \ I compiled it with BUILD_STATIC=yes in all cases. They all compiled but continued to hang. Thanks again, ed - http://worldinternet.org - Mergence of Business and Technology To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-current in the body of the message
Re: mysql-3.23.51 with Current for the last few weeks.
Quoting Manfred Antar [EMAIL PROTECTED]: Manfred, ! ! IT WORKS ! ! for the first time is several weeks:-) ! THANKS ! I followed your steps and added a couple of my own below just in case someone else is having problems. | | Ed | I think i did this | Build and install the gcc32 port | cd /usr/local/bin | ln -s gcc32 gcc | ln -s gcc32 cc | ln -c g++32 g++ | ln -s g++32 c++ | And make sure /usr/local/bin is ahead of /usr/bin in your PATH | set PATH=/usr/local/bin:$PATH | export PATH # My additional steps. cd /usr/bin mv cc cc.org # This solves the tracked aliase problem - don't # forget to move it back. cd /usr/ports/databases/mysql323-server make BUILD_STATIC=yes install | I did this about a month ago and forgot about the linkking | As gcc32 is installed but not gcc so you need to do all the links. | Then just go to the /usr/ports/databases/mysql323-server or client and do a | make it should pick up /usr/local/bin/gcc or g++ as the compiler to use. | Manfred | - http://worldinternet.org - Mergence of Business and Technology To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-current in the body of the message