| Bug #15202 | Running mysql-test-run return 2 failed test (func_compress rpl_rotate_logs) | ||
|---|---|---|---|
| Submitted: | 23 Nov 2005 20:36 | Modified: | 1 Dec 2005 13:07 |
| Reporter: | [ name withheld ] | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.16 | OS: | IBM AIX (AIX 5.2) |
| Assigned to: | CPU Architecture: | Any | |
[28 Nov 2005 14:25]
[ name withheld ]
The "suggested fix" comment seem a little harsh and I didn't meant that. I meant to say it could be an algorithm issues that isn't coded properly or logic issues or something like that.
[1 Dec 2005 13:07]
Valeriy Kravchuk
Thank you for a problem report. Sorry, but I was not able to repeat it as you described. I performed the following actions: gunzip < mysql-standard-5.0.16-aix5.2-powerpc-64bit.tar.gz | tar xvf - Then: mysqldev@aix52:~/valeriy> cd mysql-standard-5.0.16-aix5.2-powerpc-64bit <tandard-5.0.16-aix5.2-powerpc-64bit> cd mysql-test/ </mysql-test-run --force func_compress rpl_rotate_logs Installing Test Databases Removing Stale Files Installing Master Databases running ../bin/mysqld --no-defaults --bootstrap --skip-grant-tables --based ir=.. --datadir=mysql-test/var/master-data --skip-innodb --skip-ndbcluster --ski p-bdb Installing Slave Databases running ../bin/mysqld --no-defaults --bootstrap --skip-grant-tables --based ir=.. --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 ------------------------------------------------------- func_compress [ pass ] rpl_rotate_logs [ pass ] ------------------------------------------------------- Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished All 2 tests were successful. So, these 2 tests alone worked OK on our AIX 5.2 machine: <l-standard-5.0.16-aix5.2-powerpc-64bit/mysql-test> uname -a AIX aix52 2 5 00592F0F4C00 It is IBM P615 7029-6C3 (ppc64) Dual POWER4 1.2 GHz box with 2 GB RAM
Description: Machine Model: RS/6000 44P Model 1170 AIX: Version 5.2, 64 bits kernel and JFS2 (filesystem) Hardware: 1 GB RAM and 35 GB Hard Disk MySQL: downloaded mysql-standard-5.0.16-aix5.2-powerpc-64bit zipped file Two seperate errors as result of running the mysql-test-run script with the "--force" option... Error #1 --snip-- func_compress [ fail ] Errors are (from /usr/local/mysql/mysql-test/var/log/mysqltest-time) : mysqltest: At line 48: query 'select compress(repeat('aaaaaaaaaa', IF('', 10, 10000000))) is null' failed: 5: Out of memory (Needed 120000024 bytes) (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished --snip-- Error #2 --snip-- rpl_rotate_logs [ fail ] Errors are (from /usr/local/mysql/mysql-test/var/log/mysqltest-time) : mysqltest: At line 28: query 'start slave' failed with wrong errno 1201 instead of 1105... (the last lines may be the most important ones) Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished --snip-- The log file of the mysql-test-run result in /usr/local/mysql/mysql-test/var/log is garabges. How to repeat: Download the MySQL 5.0.16 (64 bits) and install it on the AIX supported machine. Then run the mysql-test-run with the "--force" option. Wait a while. Then see 2 seperate errors. Also, "cat /usr/local/mysql/mysql-test/var/log" is all garabages in it. Suggested fix: The AIX server use 1 GB of RAM and yet the func_compress had failed in the mysql-test-run which doesn't make sense. So, the bad algorithm need to be fixed or corrected.