List:Internals« Previous MessageNext Message »
From:Michael Widenius Date:June 4 2001 7:44pm
Subject:Re: check table failing under OS/2
View as plain text  
Hi!

>>>>> "Yuri" == Yuri Dario <mc6530@stripped> writes:

Yuri> Hi Monty,
Yuri> the 'check table' is failing because of a RDLCK lock on the index file.
>> From the trace

<cut>

Yuri> I don't see unlocking calls in this block of tracing.

Yuri> T@4    : | | | | >my_pwrite
Yuri> T@4    : | | | | | my: Fd: 12  Seek: 0  Buffer: d2d654  Count: 176 
Yuri> MyFlags: 132
Yuri> T@4    : | | | | | error: Write only -1 bytes
Yuri> T@4    : | | | | <my_pwrite
Yuri> T@4    : | | | | error: message: 43 when updateing keyfile

Yuri> so write() is failing.

Yuri> So I need to unlock file before calling my_pwrite(), or stay with
Yuri> current locking code (which doesn't make difference between F_RDLCK and
Yuri> F_WRLCK).

You are right;  We added that even if we just check the table, MySQL
will write some status to the header file;  We don't need to protect
this with a write lock, as it's not important if we loose this
information.

The fix is probably to lock tables with write locks when doing CHECK
TABLE and running under OS2.

Regards,
Monty
Thread
check table failing under OS/2Yuri Dario30 May
  • Re: check table failing under OS/2Sinisa Milivojevic31 May
  • check table failing under OS/2Michael Widenius1 Jun
    • Re: check table failing under OS/2Yuri Dario1 Jun
      • Re: check table failing under OS/2Michael Widenius1 Jun
        • Re: check table failing under OS/2Yuri Dario1 Jun
          • Re: check table failing under OS/2Michael Widenius2 Jun
            • Re: check table failing under OS/2Yuri Dario2 Jun
              • Re: check table failing under OS/2Michael Widenius3 Jun
                • Re: check table failing under OS/2Yuri Dario3 Jun
                  • Re: check table failing under OS/2Yuri Dario3 Jun
                    • Re: check table failing under OS/2Michael Widenius3 Jun
                      • Re: check table failing under OS/2Yuri Dario4 Jun
                  • Re: check table failing under OS/2Michael Widenius3 Jun
                    • Re: check table failing under OS/2Yuri Dario4 Jun
                      • Re: check table failing under OS/2Yuri Dario4 Jun
                        • Re: check table failing under OS/2Michael Widenius5 Jun
                      • Re: check table failing under OS/2Michael Widenius4 Jun
                        • Re: check table failing under OS/2Yuri Dario4 Jun
                          • Re: check table failing under OS/2Michael Widenius5 Jun
  • check table failing under OS/2Michael Widenius1 Jun
    • Re: check table failing under OS/2Yuri Dario1 Jun
    • Re: check table failing under OS/2Yuri Dario2 Jun
      • Re: check table failing under OS/2Michael Widenius3 Jun
        • Re: check table failing under OS/2Yuri Dario3 Jun
Re: check table failing under OS/2Yuri Dario5 Jun
Re: check table failing under OS/2Yuri Dario5 Jun
  • Re: check table failing under OS/2Michael Widenius6 Jun
    • Re: check table failing under OS/2Yuri Dario6 Jun
      • Re: check table failing under OS/2Michael Widenius7 Jun
        • Re: check table failing under OS/2Yuri Dario7 Jun
          • Re: check table failing under OS/2Michael Widenius11 Jun