Hi,
I've mysql 3.23.32 running on FreeBSD 4.0.
It runs a site with heavy traffic and heavy
database interaction.
After starting mysql it hangs after some days.
Mysql server is still in the processlist, but
it is not possible to connect to the sql
server anymore. Therefor it is impossible
to stop the server and rerun it without killing.
Problem with threads??
I've found the following in the config.log generated
by ./configure:
--------------------- SNIP ------------------------
configure:5648: gcc -o conftest conftest.c -lz -lcrypt -lm 1>&5
/tmp/ccF77967.o: In function `main':
/tmp/ccF77967.o(.text+0xf): undefined reference to `pthread_create'
configure: failed program was:
#line 5641 "configure"
#include "confdefs.h"
#include <pthread.h>
int main() {
(void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
; return 0; }
configure:5662: checking for pthread_create in -lpthread
configure:5673: gcc -o conftest conftest.c -lz -lcrypt -lm -lpthread
1>&5
/usr/libexec/elf/ld: cannot open -lpthread: No such file or directory
configure: failed program was:
#line 5666 "configure"
#include "confdefs.h"
#include <pthread.h>
int main() {
(void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
; return 0; }
configure:5688: checking for pthread_create in -lpthreads
configure:5697: gcc -o conftest
conftest.c -lz -lcrypt -lm -lpthreads 1>&5
/usr/libexec/elf/ld: cannot open -lpthreads: No such file or directory
configure: failed program was:
#line 5690 "configure"
#include "confdefs.h"
#include <pthread.h>
int main() {
pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0);
; return 0; }
--------------------- SNIP ------------------------
I've no idea if this is important or not?
I've made a script which reboots the server if connection
to sql server fails. But this is not a solution :).
Thanks in advance.
Regards,
Patric de Waha
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
