Bug #20057 Test suite fails on QNX 6.3
Submitted: 24 May 2006 21:18 Modified: 25 Jun 2006 20:01
Reporter: William Stelwagon Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.21 OS:Other (qnx 6.3)
Assigned to: CPU Architecture:Any

[24 May 2006 21:18] William Stelwagon
Description:
Installing 5.0.21 on qnx6.3 the test suite fails on 'rpl-rotate-logs' and 'trigger'.
These failures also occur when running the tests individually.  There are no .reject files in the mysql-test/r directory as a result of these runs.  

When mysql 4.1.10 (from QNX) or 4.1.19 (from MYSQL) is installed the same way, the test suite runs OK. However our application requires cursors.

The debug version fails in the same manner, but running 
        mysql-test-run --debug
bombs with a memory fault, no master.trace file.  

How to repeat:
Install mysql-max-5.0.21-nto-qnx6.2.1-i386 on a QNX6.3 system as indicated in INSTALL-BINARY.

Then cd mysql-test and execute mysql-test-run.  The test bombs at 'rpl-rotate-logs'.  Running it with --force also shows error at 'trigger'.
[24 May 2006 21:34] William Stelwagon
Output from the run

Attachment: ntemp (application/octet-stream, text), 20.73 KiB.

[24 May 2006 21:38] William Stelwagon
.result file from rpl_rotate_log

Attachment: rpl_rotate_logs.result (application/octet-stream, text), 4.30 KiB.

[24 May 2006 21:40] William Stelwagon
.log file for rpl_rotate_log

Attachment: rpl_rotate_logs.log (application/octet-stream, text), 200 bytes.

[24 May 2006 21:42] William Stelwagon
.result file from trigger

Attachment: trigger.result (application/octet-stream, text), 30.04 KiB.

[24 May 2006 21:43] William Stelwagon
.log file from trigger

Attachment: trigger.log (application/octet-stream, text), 27.23 KiB.

[25 Jun 2006 20:01] Valeriy Kravchuk
Thank you for a problem report. Sorry, but I was not able to repeat with 5.0.22 on QNX 6.2.1 (sorry, we have no version 6.3 around):

mysqldev@buildqnx2:~/valeriy/5.0/mysql-test> ./mysql-test-run --force rpl_rota>
Logging: ./mysql-test-run --force rpl_rotate_logs trigger
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/master-data --skip-innodb --skip-ndbcluster --skip-bdb
Installing Slave Databases
running  ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=.. --datadir=mysql-test/var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

TEST                            RESULT
-------------------------------------------------------
rpl_rotate_logs                [ pass ]
trigger                        [ pass ]
-------------------------------------------------------

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
All 2 tests were successful.

mysqldev@buildqnx2:~/valeriy/5.0/mysql-test> uname -a
QNX buildqnx2 6.2.1 2003/01/18-02:12:22est x86pc x86

Server was built from sources, with usual (for QNX) options:

CC="ccache qcc" CXX="ccache qcc" CFLAGS="-O1 -Wl,-E" CXXFLAGS="-O1 -Wl,
-E"  ./configure --prefix=/home/mysqldev/valeriy/5.0 --with-comment="MySQL Commu
nity Edition - Experimental (GPL)" --with-extra-charsets=complex --with-server-s
uffix="-max" --enable-thread-safe-client --enable-local-infile --disable-shared
--with-big-tables --with-readline --with-archive-storage-engine --with-blackhole
-storage-engine --with-csv-storage-engine --with-example-storage-engine --with-f
ederated-storage-engine --with-innodb

Then I just performed:

make
make install
cd ../5.0/
cd mysql-test/

and then ran tests. So, please, try to use version 5.0.22.