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
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.
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
> 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]>: | 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.
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 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 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.
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.
> 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
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
