Hi,

    this is a follow up to my problem with the test suite on an SGI O2 with 
Irix 6.5.8f

I manage to pass through all the tests without problems but a very long 
'select' test:

select          0,209           0,336           239,115         [pass]

but thats another problem. The previous problem I had (hanging in 'delayed' 
test) seems
du to the CAP_SCHED_MGT privilege as required by the doc.

Let me explain:

IF I run the tests with root OR with the CAP privilege attached to the 
mysqld process, the
bug appears as said earlier.

IF I run the tests with a user without this privilege, the tests are 
fine.  When doing this,
threads appears to be OK.

I'll now try if this privilege is really required on an Apache-mysql context.

Thanks.

At 23:09 01-01-17 +0200, Michael Widenius wrote:

>Hi!
>
> >>>>> "robert" == robert marchand <[EMAIL PROTECTED]> writes:
>
> >> Description:
>robert>       I have download the latest binary distribution for SGI Irix:
>robert>       mysql-3.23.30-gamma-sgi-irix6.5-mips and it lock
>robert>       when I try the test suite
>
>robert>       The test suite hang after the 'create' test on my O2 Workstation
>robert>       running Irix 6.5.8.  It is always at the same place.  It is 
>the same
>robert>       to use the binary distribution on the mysql Web site or the 
>compiled
>robert>       source on my machine.
>
>robert> Here is the report from the test:
>
>robert>  Here is the test output:
>robert>  thingol 117# ./mysql-test-run
>robert>  Installing Test Databases
>robert>  Removing Stale Files
>robert>  Installing Master Databases
>robert>  Installing Slave Databases
>robert>  Starting MySQL daemon
>robert>  Loading Standard Test Databases
>robert>  Starting Tests
>
>robert>   TEST                         USER   SYSTEM  ELAPSED        RESULT
>robert> 
>------------------------------------------------------------------------
>robert>  alter_table                  0,016    0,060    1,050       [ pass ]
>robert>  analyse                      0,012    0,034    0,242       [ pass ]
>robert>  auto_increment               0,021    0,074    1,049       [ pass ]
>robert>  bdb                           ....     ....     ....       [ 
>skipped ]
>robert>  bigint                       0,012    0,034    0,140       [ pass ]
>robert>  binary                       0,015    0,049    0,327       [ pass ]
>robert>  case                         0,015    0,044    0,138       [ pass ]
>robert>  comments                     0,012    0,036    0,090       [ pass ]
>robert>  compare                      0,012    0,035    0,152       [ pass ]
>robert>  count_distinct               0,016    0,051    0,494       [ pass ]
>robert>  create                       0,017    0,054    0,422       [ pass ]
>
>robert>  After that nothing happens.  Here is what mysqladmin have to say:
>
><cut>
>
>This means that there is some problem with insert delayed on OS/2.
>
>This is one of the few piece of MySQL that uses
>pthread_cond_broadcast();  It may be a that Irix has a problem with this.
>
>I shall try to test this on the Iirix 6.5 machine I have an account of
>during the next few days!
>
>Regards,
>Monty

-------
Robert Marchand                 tél: 343-6111 poste 5210
DGTIC-SIT                       e-mail: [EMAIL PROTECTED]
Université de Montréal          Montréal, Canada


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to