>Description:
Mysql 4.0.15 from ports on FreeBSD 4.7 has this repeated many times in the logs while under heavier loads:
Warning: thr_alarm queue is full
Threads get disconnected when this happens. I assume it is the thread that has this problem:
("..."=removed sensitive data)
DBI->connect(...;...) failed: Lost connection to MySQL server during query at ...
Reconnections can happen, and things work fine, but persistent connections are lost.
Tried linuxthreads, but it worse, causing the server to refuse connections.
>How-To-Repeat:
On my same setup, load the server down with many connections and lots of activity.
>Fix: Unknown.
>Submitter-Id: none >Originator: Troy Bowman >Organization: ArosNet, Inc > >MySQL support: none >Synopsis: Warning: thr_alarm queue is full in FreeBSD >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-4.0.15 (FreeBSD port: mysql-server-4.0.15)
>C compiler: 2.95.4
>C++ compiler: 2.95.4
>Environment:
<machine, os, target, libraries (multiple lines)>
System: FreeBSD io.aros.net 4.7-STABLE FreeBSD 4.7-STABLE #332: Sat Nov 2 05:31:36 MST 2002 [EMAIL PROTECTED]:/.amd_mnt/ophelia/export/usr/src/sys/compile/ AROS-SMP i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.4 20020320 [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe -mcpu=i686 -O3 -fno-omit-frame-pointer' CXX='cc' CXXFLAGS='-O -pipe -mcpu=i686 -O3 -fno-omit-frame-pointer -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' ASFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1222906 Nov 3 2002 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Nov 3 2002 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 577804 Nov 3 2002 /usr/lib/libc.so.4
Configure command: ./configure '--localstatedir=/var/db/mysql' '--without-debug' '--without-readline' '--without-bench' '--without-extra-tools' '--with-libwrap' '--with-mysqlfs' '--with-vio' '--with-low-memory' '--with-comment=FreeBSD port: mysql-server-4.0.15' '--enable-thread-safe-client' '--enable-assembler' '--with-berkeley-db' '--with-openssl' '--prefix=/usr/local' '--build=i386-portbld-freebsd4.7' 'CFLAGS=-O -pipe -mcpu=i686 -O3 -fno-omit-frame-pointer' 'CXX=cc' 'build_alias=i386-portbld-freebsd4.7' 'CC=cc' 'CXXFLAGS=-O -pipe -mcpu=i686 -O3 -fno-omit-frame-pointer -felide-constructors -fno-rtti -fno-exceptions'
Perl: This is perl, version 5.005_03 built for i386-freebsd
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
