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

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

Yuri> Hi Monty,
Yuri> 1) alter_table.test: check table reports
Yuri> could be related to buffered disk writes?
>> No..

Yuri> ok, still open.

Yuri> 2) func_test: at line 16
>> Strange; The macros in m_ctype.h should be ok.

Yuri> I will compare macros.

Yuri> 6) status.test: different locking count
>> Just put a breakpoint in mysys/thr_lock.c at:
>> statistic_increment(locks_waited, &THR_LOCK_lock);

Yuri> never stopped here: while running the test, MySQL called thr_lock() 3
Yuri> times, the first 2 from thread @6, the third from thread@5.

I am now looking at the test:

--------
t/status.test:

flush status;
show status like 'Table_lock%';
connection con1;
SET SQL_LOG_BIN=0;
drop table if exists t1;
create table t1(n int);
insert into t1 values(1);
connection con2;
lock tables t1 read;
unlock tables;
lock tables t1 read;
connection con1;

# At this point table t1 should be locked.


# The following query should block because t1 is locking the table, if
# you are running with MyISAM tables.

--send
update t1 set n = 3;
connection con2;
sleep 0.5;
unlock tables;
----------

Note the --send command;  This tells MySQL to just send the command
but not wait for the commend to execute.

You could try to increase the 'sleep' time to 3 seconds to check if
this is a bug in the thread scheduler on OS/2.

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