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 10:49	Modified:	28 Apr 2007 9:54
Reporter:	Kent Boortz	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Federated storage engine	Severity:	S2 (Serious)
Version:	5.1.16-pre, 5.0.37	OS:	MacOS (Mac OS X 10.4 PPC 64 bit)
Assigned to:	Assigned Account	CPU Architecture:	Any

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.