List:Internals« Previous MessageNext Message »
From:Jocelyn Fournier Date:October 20 2002 6:26pm
Subject:Re: Temporary fix for SIGHUP and delayed_insert thread problem
View as plain text  
Hi,

Any news about this patch ? (I'm still have to edit sql_base.cc each time
it's modified).
AFAIK, it works perfectly for me.

Regards,
  Jocelyn

----- Original Message -----
From: "Jocelyn Fournier" <joc@stripped>
To: "Michael Widenius" <monty@stripped>
Cc: <internals@stripped>

>Hi,
>
>I finally found a fix to the delayed insert problem when mysqld catchs a
>SIGHUP signal.
>I don't know if it's an ideal fix, but at least it solves the problem for
>me.
>Here is my patch :
>
>===== sql_base.cc 1.135 vs edited =====
>--- 1.135/sql/sql_base.cc       Sun Sep 22 09:59:31 2002
>+++ edited/sql_base.cc  Thu Oct  3 15:47:22 2002
>@@ -376,14 +376,14 @@
>     if (!found)
>       if_wait_for_refresh=0;                   // Nothing to wait for
>   }
>+  if (!tables)
>+    kill_delayed_threads();
>   if (if_wait_for_refresh)
>   {
>     /*
>       If there is any table that has a lower refresh_version, wait until
>       this is closed (or this thread is killed) before returning
>     */
>-    if (!tables)
>-      kill_delayed_threads();
>     thd->mysys_var->current_mutex= &LOCK_open;
>     thd->mysys_var->current_cond= &COND_refresh;
>     thd->proc_info="Flushing tables";
>
>Regards,
>  Jocelyn



Thread
Re: Temporary fix for SIGHUP and delayed_insert thread problemJocelyn Fournier20 Oct
  • Re: Temporary fix for SIGHUP and delayed_insert thread problemSinisa Milivojevic21 Oct