List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:December 29 1999 10:56pm
Subject:RE: Insert delayed causing table corruption?
View as plain text  
Hi!

<cut>

Steven> Will 2.22.28 fix the insert delayed problem on Linux?

>> Yes.  The workaround in 3.22.28 is to change 'pthread_cond_timedwait()' in
>> sql/sql_insert.cc to pthread_cond_wait() until they have managed to
>> fix the bug in glibc.

Steven> Is there a patch for 3.22.27 such that we can implement this right away?

Didn't I post this already ?

*** /my/monty/master/mysql-3.22.26a/sql/sql_insert.cc	Sat Aug 28 15:10:46 1999
--- ./sql_insert.cc	Mon Dec 27 16:15:50 1999
***************
*** 925,931 ****
--- 936,950 ----
        for ( ; ;)
        {
  	int error;
+ #if (defined(HAVE_BROKEN_COND_TIMEDWAIT) || defined(HAVE_LINUXTHREADS))
+ 	error=pthread_cond_wait(&di->cond,&di->mutex);
+ #else
  	error=pthread_cond_timedwait(&di->cond,&di->mutex,&abstime);
+ #ifdef EXTRA_DEBUG
+ 	if (error && error != EINTR)
+ 	  fprintf(stderr, "Got error %d from pthread_cond_timedwait\n",error);
+ #endif
+ #endif
  	if (thd->killed || di->status)
  	  break;
  	if (error == ETIME || error == ETIMEDOUT)


Regards,
Monty
Thread
Insert delayed causing table corruption?struanb29 Nov
  • Re: Insert delayed causing table corruption?sinisa29 Nov
  • Insert delayed causing table corruption?Michael Widenius28 Dec
    • RE: Insert delayed causing table corruption?Steven Roussey29 Dec
      • RE: Insert delayed causing table corruption?Michael Widenius29 Dec
        • RE: Insert delayed causing table corruption?Steven Roussey29 Dec
          • Re: Insert delayed causing table corruption?Sasha Pachev29 Dec
          • RE: Insert delayed causing table corruption?Michael Widenius30 Dec
        • Table lockingSteven Roussey4 Jan
          • Re: Table lockingBenjamin Pflugmann4 Jan
            • Re: Table lockingMichael Widenius4 Jan
              • Optimize TableSteven Roussey5 Jan
                • Optimize TableMichael Widenius5 Jan
            • RE: Table lockingSteven Roussey4 Jan
RE: Insert delayed causing table corruption?Andy29 Dec
  • RE: Insert delayed causing table corruption?Michael Widenius30 Dec
RE: Insert delayed causing table corruption?Andy30 Dec
  • RE: Insert delayed causing table corruption?Michael Widenius30 Dec
    • The table 'SQL24d1ab_0' is fullDavid Moreno S.30 Dec
      • Re: The table 'SQL24d1ab_0' is fulljpabuyer30 Dec