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