by Here is a patch that is needed for mysql-3.23.21-beta
--
ZENEZ 3748 Valley Forge Road, Magna Utah 84044
Office 801-250-0795 FAX 801-250-7975
Date: Sun, 30 Jul 2000 06:02:31 +0300 (EEST)
Subject: Re: R: Compiling mysql-3.23.21on SCO 3.2V5.0.5
Hi!
Boyd> I guess this is a bug. My server had been up for 50 days without
Boyd> restarting. I ran the show processlist and I got lost connection to
Boyd> server and my server restarted. I guess I need to pass this on to the
Boyd> mysql people.
The problem is that pthread_kill() with signal 0 doesn't work with
FSU threads as it supposed to do :(
Fix:
=== cd /my/mysql/sql/
=== /my/gnu/bin/cvs diff -u sql_show.cc
Index: sql_show.cc
===================================================================
RCS file: /home/cvs/mysql/sql/sql_show.cc,v
retrieving revision 1.19
diff -u -r1.19 sql_show.cc
--- sql_show.cc 2000/07/27 23:49:58 1.19
List<Item> field_list;
I_List<thread_info> thread_infos;
ulong max_query_length= verbose ? max_allowed_packet : PROCESS_LIST_WIDTH;
- DBUG_ENTER("mysql_list_processes");
+ DBUG_ENTER("mysqld_list_processes");
field_list.push_back(new Item_int("Id",0,7));
if (tmp->mysys_var)
pthread_mutex_unlock(&tmp->mysys_var->mutex);
-#ifndef DONT_USE_THR_ALARM
+#if !defined(DONT_USE_THR_ALARM) && ! defined(SCO)
if (pthread_kill(tmp->real_id,0))
tmp->proc_info="*** DEAD ***"; // This shouldn't happen
#endif
=== Exit status: 1
Regards,
Monty