From: elfchief
Date: April 7 2000 10:27pm
Subject: Warning: Got signal 14 from thread 4
List-Archive: http://lists.mysql.com/bugs/63
Message-Id: <20000407222708.10340.qmail@eclipse.lupine.org>

>Description:
	[This bug was previously reported informally to the mailing list.
	 I'm submitting a formal report, now, since we didn't get very 
	 far from there]

	Very simply, MySQL occasionally prints in the log:

		000407  9:18:14  Warning: Got signal 14 from thread 4
		000407  9:18:14  Warning: Got signal 14 from thread 4
		000407 12:29:46  Warning: Got signal 14 from thread 4
		000407 12:29:46  Warning: Got signal 14 from thread 4

	... sometimes multiple times per day, sometimes not at all. The 
	messages -always- seem to come in pairs.

  	This problem seems to have begun after an upgrade from Solaris 
	2.5.1 to Solaris 7 (both x86), though I admit to not having
	looked at my logs very closely before the upgrade.

	The Solaris box is fully patched with the current reccomended 
	patch cluster.

	This problem can not be duplicated on the other in-house Solaris 7
	x86 box, nor a Solaris 7/sparc box. 

	This Solaris 7 x86 box is the only multi-processor Solaris x86 box
 	we have -- The second Solaris x86 box we tested on (that worked
	fine, we think) is uniprocessor.


>How-To-Repeat:
	I can not find a repeatable case of this issue; At first I thought
	it to be load related, but the messages have continued even after
	my load-testing on my server completed. (The current server load
	is averaging about one (simple) query a second). I've seen the
	messages during high-usage times of the day, and during low-usage
	times of the day.  Best I can tell, the message is completely 
	random.


>Fix:
	Beg Monty to look at it?	 :)


>Submitter-Id:	<submitter ID>
>Originator:	Jay 'Whip' Grizzard
>Organization:
 
>MySQL support: none
>Synopsis:	Warning: Got signal 14 from thread 4
>Severity:	non-critical
>Priority:	low
>Category:	mysql
>Class:		sw-bug
>Release:	mysql-3.22.32 (Source distribution)

>Environment:
	Solaris 7 x86, Dual Celeron
System: SunOS eclipse 5.7 Generic_106542-10 i86pc i386 i86pc
Architecture: i86pc

Some paths:  /usr/local/bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.7/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS='-O -march=pentium -fomit-frame-pointer'  CXX='gcc'  CXXFLAGS='-O -march=pentium -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
Configure command: ./configure  --with-mysqld-user=mysql --prefix=/usr/local/mysql --with-named-thread-libs=-lpthread
Perl: This is perl, version 5.005_03 built for i86pc-solaris