Hi,
I have download the latest binary distribution for SGI Irix:
mysql-3.23.30-gamma-sgi-irix6.5-mips and it lock when I try the test suite:
Here is the test output:
thingol 117# ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
Installing Slave Databases
Starting MySQL daemon
Loading Standard Test Databases
Starting Tests
TEST USER SYSTEM ELAPSED RESULT
------------------------------------------------------------------------
alter_table 0,016 0,060 1,050 [ pass ]
analyse 0,012 0,034 0,242 [ pass ]
auto_increment 0,021 0,074 1,049 [ pass ]
bdb .... .... .... [ skipped ]
bigint 0,012 0,034 0,140 [ pass ]
binary 0,015 0,049 0,327 [ pass ]
case 0,015 0,044 0,138 [ pass ]
comments 0,012 0,036 0,090 [ pass ]
compare 0,012 0,035 0,152 [ pass ]
count_distinct 0,016 0,051 0,494 [ pass ]
create 0,017 0,054 0,422 [ pass ]
After that nothing happens. Here is what mysqladmin have to say:
../../../bin/mysqladmin -S mysql-master.sock processlist
+----+------+-----------+------+-------------+------+--------------------------+----------------------------------+
| Id | User | Host | db | Command | Time | State |
Info |
+----+------+-----------+------+-------------+------+--------------------------+----------------------------------+
| 1 | root | localhost | | Binlog Dump | 653 | Waiting for update
| |
| 13 | test | localhost | test | Query | 641 | waiting for handler open |
insert delayed into t1 set a = 2 |
| 14 | | | test | Killed | | Waiting on cond |
t1 |
| 17 | root | localhost | | Query | 0 | |
show processlist |
+----+------+-----------+------+-------------+------+--------------------------+----------------------------------+
thingol 126# !!
../../../bin/mysqladmin -S mysql-master.sock processlist
+----+------+-----------+------+-------------+------+--------------------------+----------------------------------+
| Id | User | Host | db | Command | Time | State |
Info |
+----+------+-----------+------+-------------+------+--------------------------+----------------------------------+
| 1 | root | localhost | | Binlog Dump | 691 | Waiting for update
| |
| 13 | test | localhost | test | Query | 679 | waiting for handler open |
insert delayed into t1 set a = 2 |
| 14 | | | test | Killed | | Waiting on cond |
t1 |
| 18 | root | localhost | | Query | 0 | |
show processlist |
+----+------+-----------+------+-------------+------+--------------------------+----------------------------------+
I'm testing this on an SGI O2 workstation running Irix 6.5.8f.
I have also try the source distribution. It compile OK but has the same
problem (at the same place). I have also try the source distribution on
other SGI box and it locks but on other places at random (in the tests).
I have also a dead lock problem with our production mysqld for which I have
posted here a while ago (all processes have the 'locked' state). Do others
run mysqld on SGI with success? I would like to know.
The notes on SGI in the manual are somewhat 'vague' and outdated to me.
I would be ready to investigate further but I don't know where to search.
Thanks.
-----------------
Robert Marchand
DGTIC/SIT
poste 5210
---------------------------------------------------------------------
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