| Bug #40145 | general_log_func fails in 6.0-rpl, powermacg5/embedded | ||
|---|---|---|---|
| Submitted: | 19 Oct 2008 15:40 | Modified: | 30 Jan 2009 17:44 |
| Reporter: | Sven Sandberg | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Tests | Severity: | S7 (Test Cases) |
| Version: | 6.0-rpl | OS: | MacOS |
| Assigned to: | Serge Kozlov | CPU Architecture: | Any |
| Tags: | 51rpl, 6.0-rpl-green, general_log_func, pushbuild, test failure | ||
[16 Nov 2008 21:30]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/58910 2701 Serge Kozlov 2008-11-17 Bug#40145. Argument for LOAD_FILE() can be too long and sometimes a query with two or more these functions truncated. Therefore data from each LOAD_FILE() copied into its local variables and then used in a query.
[27 Nov 2008 12:16]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/60027 2706 Serge Kozlov 2008-11-27 Bug#40145. Argument for LOAD_FILE() can be too long and sometimes a query with two or more these functions truncated. Therefore data from each LOAD_FILE() copied into its local variables and then used in a query.
[27 Nov 2008 12:21]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/60029 2740 Serge Kozlov 2008-11-27 [merge] Bug#40145. Argument for LOAD_FILE() can be too long and sometimes a query with two or more these functions truncated. Therefore data from each LOAD_FILE() copied into its local variables and then used in a query. Bug#40708: Sometimes DB mysqltest1 did not removed before starting test rpl_row_create_table therefore the patch add the cleanup operation if DB with such name already exists.
[28 Nov 2008 9:53]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/60130 2702 He Zhenxing 2008-11-28 [merge] Auto merge
[30 Jan 2009 13:28]
Bugs System
Pushed into 6.0.10-alpha (revid:luis.soares@sun.com-20090129165607-wiskabxm948yx463) (version source revid:luis.soares@sun.com-20090129163120-e2ntks4wgpqde6zt) (merge vers: 6.0.10-alpha) (pib:6)
[30 Jan 2009 15:09]
Bugs System
Pushed into 5.1.32 (revid:luis.soares@sun.com-20090129165946-d6jnnfqfokuzr09y) (version source revid:msvensson@mysql.com-20081205211552-7odzip74f430g1du) (merge vers: 5.1.31) (pib:6)
[30 Jan 2009 17:44]
Paul DuBois
Test case changes. No changelog entry needed.
[17 Feb 2009 14:53]
Bugs System
Pushed into 5.1.32-ndb-6.3.23 (revid:tomas.ulin@sun.com-20090217131017-6u8qz1edkjfiobef) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)
[17 Feb 2009 16:41]
Bugs System
Pushed into 5.1.32-ndb-6.4.3 (revid:tomas.ulin@sun.com-20090217134419-5ha6xg4dpedrbmau) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)
[17 Feb 2009 18:17]
Bugs System
Pushed into 5.1.32-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090217134216-5699eq74ws4oxa0j) (version source revid:tomas.ulin@sun.com-20090201210519-vehobc4sy3g9s38e) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)
Description: main.general_log_func fails in pushbuild. The failure happens every time the test is run, but only in 6.0-rpl, on powermacg5, in embedded. The error message is: main.general_log_func [ fail ] CURRENT_TEST: main.general_log_func --- /Users/henry/pb/bzr_mysql-6.0-rpl/58/mysql-6.0.7-alpha-pb58/mysql-test/r/general_log_func.result Fri Aug 29 16:12:25 2008 +++ /Users/henry/pb/bzr_mysql-6.0-rpl/58/mysql-6.0.7-alpha-pb58/mysql-test/r/general_log_func.reject Sun Aug 31 08:22:25 2008 @@ -29,7 +29,7 @@ SET @@session.max_allowed_packet= 1024*1024*1024; select STRCMP(load_file('MYSQLD_LOGFILE.orig'), load_file('MYSQLD_LOGFILE.copy')); -STRCMP(load_file('MYSQLD_LOGFILE.orig'), load_file('MYSQLD_LOGFILE.copy')) +STRCMP(load_file('MYSQLD_LOGFILE.orig'), load_file('MYSQLD_LOGFILE.copy') 1 ## Dropping tables ## DROP TABLE t1; mysqltest: Result length mismatch - saving '/Users/henry/pb/bzr_mysql-6.0-rpl/58/mysql-6.0.7-alpha-pb58/mysql-test/var-embedded-5/log/main.general_log_func/' to '/Users/henry/pb/bzr_mysql-6.0-rpl/58/mysql-6.0.7-alpha-pb58/mysql-test/var-embedded-5/log/main.general_log_func/' Retrying test, attempt(2/3)... How to repeat: https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=89 powermacg5/embedded xref: http://tinyurl.com/5tu768 Suggested fix: The only thing I can think of is that the string is truncated by mysqltest at some point. That explains why it happens only in 6.0-rpl (because paths are slightly longer than on other platforms in the new mtr), and also why it happens on only a very specific platform (probably that platform has long paths). I suggest: - increase the buffer size - make mtr print an error message when output text is truncated.