>Description: mysqld 4.0.17 crash on FreeBSD 5.1-current-alpha >How-To-Repeat: Any acces over IP (not domain socket) crashes mysqld: #/usr/local/bin/mysqladmin: connect to server at 'install' failed error: 'Lost connection to MySQL server during query'
syslog: install mysqld[78066]: warning: can't get client address: Bad file descriptor mysqld errorlog (/var/db/mysql/install.err): /usr/local/libexec/mysqld: ready for connections. Version: '4.0.17' socket: '/tmp/mysql.sock' port: 3306 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 Kbytes of memory Hope that's ok; if not, decrease some variables in the equation. Number of processes running now: 0 040112 12:33:42 mysqld restarted 040112 12:33:43 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43892 InnoDB: Doing recovery: scanned up to log sequence number 0 43892 040112 12:33:43 InnoDB: Flushing modified pages from the buffer pool... 040112 12:33:43 InnoDB: Started /usr/local/libexec/mysqld: ready for connections. Version: '4.0.17' socket: '/tmp/mysql.sock' port: 3306 I've tried several versions of mysql, all with the same result. PostgreSQL is running fine on this machine. >Fix: none known >Submitter-Id: holm >Originator: Holm Tiffe >Organization: FreibergNet Internet Systems >MySQL support: none >Synopsis: mysqld Crash on FreeBSD Alpha >Severity: critical >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-4.0.17 (FreeBSD port: mysql-server-4.0.17) >C compiler: cc (GCC) 3.3.1 [FreeBSD] >C++ compiler: c++ (GCC) 3.3.1 [FreeBSD] >Environment: Compaq PWS 500au (Miata), FreeBSD-5.1-current System: FreeBSD install.freibergnet.de 5.1-CURRENT FreeBSD 5.1-CURRENT #1: Mon Dec 8 11:59:39 CET 2003 [EMAIL PROTECTED]:/usr/src/sys/alpha/compile/HAL alpha Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using built-in specs. Configured with: FreeBSD/alpha system compiler Thread model: posix gcc version 3.3.1 [FreeBSD] Compilation info: CC='cc' CFLAGS='-O -pipe -mcpu=ev4 -mtune=ev5 -mieee' CXX='c++' CXXFLAGS='-O -pipe -mcpu=ev4 -mtune=ev5 -mieee -O -pipe -mcpu=ev4 -mtune=ev5 -mieee -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' ASFLAGS='' LIBC: -r--r--r-- 1 root wheel 1201336 Dec 3 21:44 /lib/libc.so.5 -r--r--r-- 1 root wheel 3355602 Dec 3 07:09 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 14 Dec 3 21:44 /usr/lib/libc.so -> /lib/libc.so.5 Configure command: ./configure '--localstatedir=/var/db/mysql' '--without-debug' '--without-readline' '--without-bench' '--without-extra-tools' '--with-libwrap' '--with-vio' '--with-low-memory' '--with-comment=FreeBSD port: mysql-server-4.0.17' '--enable-thread-safe-client' '--prefix=/usr/local' '--build=alpha-portbld-freebsd5.1' 'CFLAGS=-O -pipe -mcpu=ev4 -mtune=ev5 -mieee' 'CXX=c++' 'build_alias=alpha-portbld-freebsd5.1' 'CC=cc' 'CXXFLAGS=-O -pipe -mcpu=ev4 -mtune=ev5 -mieee -O -pipe -mcpu=ev4 -mtune=ev5 -mieee -felide-constructors -fno-rtti -fno-exceptions' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]