MySQL Bugs: #26562: All federated tests fails on Mac OS X PPC 64 bit

Bug #26562	All federated tests fails on Mac OS X PPC 64 bit
Submitted:	22 Feb 2007 11:49	Modified:	28 Apr 2007 11:54
Reporter:	Kent Boortz
Status:	Duplicate
Category:	Server: Federated	Severity:	S2 (Serious)
Version:	5.1.16-pre, 5.0.37	OS:	Mac OS X (Mac OS X 10.4 PPC 64 bit)
Assigned to:	Sergey Vojtovich	Target Version:

Description:
All federated tests fails, error messages

federated                      [ fail ]

mysqltest: At line 56: query 'CREATE TABLE federated.t1 (`id` int(20) NOT NULL,`name`
varchar(32) NOT NULL default ''    )ENGINE="FEDERATED" DEFAULT
CHARSET=latin1CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1'' failed:
1434: Can't create federated table. Foreign data src error:  error: 1159  ''

and then the rest like 

federated_archive              [ fail ]

mysqltest: At line 44: query 'UPDATE federated.t1 SET name='baz' WHERE id = 1' failed
with wrong errno 1430: 'There was a problem processing the query on the foreign data
source. Data source error:\ %The foreign data source you are trying to reference does not
exist. Data source error:  : 1159 : ', instead of 1296...

How to repeat:
Run the test on the specified platform

Configured like

CC="gcc" CFLAGS="-O -arch ppc64 -fno-common" CXX="gcc" CXXFLAGS="-O -arch ppc64
-felide-constructors -fno-common" LDFLAGS="-arch ppc64"  ./configure
--prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data
--libexecdir=/usr/local/mysql/bin --with-comment="MySQL Community Server - Debug (GPL)"
--with-server-suffix="-debug" --enable-thread-safe-client --enable-local-infile
--with-named-curses-libs=/Users/mysqldev/local/lib/libncurses.a --with-pic
--disable-shared --with-zlib-dir=bundled --with-debug --without-ndb-debug
--with-big-tables --with-ssl --with-readline --with-archive-storage-engine
--with-blackhole-storage-engine --with-ndbcluster --with-csv-storage-engine
--with-example-storage-engine --with-federated-storage-engine --with-partition
--with-innodb --with-extra-charsets=all

Thank you for the report.

Verified as described.

Failed tests are: federated federated_bug_13118 federated_server federated_transactions

Also observed in building 5.0.37 community.

This is likely a duplicate of BUG#26664. The problem occurs when mysql_real_query()
attempts to read data from a socket. read() fails with EAGAIN errno, though socket is in
blocking mode.

Also I tend to think that it is OS bug. read() should never return EAGAIN when socket is
in blocking mode.

This problem will be solved by fix for BUG#26664.