Bug #42239 Test main.max_prepared_stmt_count_basic fails sporadically on pushbuild

• Submitted: 21 Jan 2009 13:40
• Modified: 12 Jun 2009 4:10
• Reporter: Alfranio Junior
• Status: Can't repeat
• Category: Tests: Server
• Severity: S7 (Test Cases)
• Version: 6.0-rpl
• OS: Any
• Assigned to: Alfranio Junior
• CPU Architecture: Any
• Tags: 6.0-rpl-green, pushbuild, sporadic, test failure

[21 Jan 2009 13:40] Alfranio Junior

Description:
main.max_prepared_stmt_count_basic       [ fail ]  timeout after 900 seconds
        Test ended at 2009-01-19 02:03:28

Test case timeout after 900 seconds

== e:/var-embedded-102/log/max_prepared_stmt_count_basic.log == 
'#---------------------FN_DYNVARS_081_09----------------------#'
SET max_prepared_stmt_count = 6000;
ERROR HY000: Variable 'max_prepared_stmt_count' is a GLOBAL variable and should be set with SET GLOBAL
SELECT @@max_prepared_stmt_count;
@@max_prepared_stmt_count
5000
SET local.max_prepared_stmt_count = 7000;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'max_prepared_stmt_count = 7000' at line 1
SELECT local.max_prepared_stmt_count;
ERROR 42S02: Unknown table 'local' in field list
SET global.max_prepared_stmt_count = 8000;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'max_prepared_stmt_count = 8000' at line 1
SELECT global.max_prepared_stmt_count;
ERROR 42S02: Unknown table 'global' in field list
SELECT max_prepared_stmt_count = @@session.max_prepared_stmt_count;
ERROR 42S22: Unknown column 'max_prepared_stmt_count' in 'field list'
SET @@global.max_prepared_stmt_count = @start_value;
SELECT @@global.max_prepared_stmt_count;
@@global.max_prepared_stmt_count
16382

 - saving 'e:/var-embedded-102/log/main.max_prepared_stmt_count_basic/' to 'e:/var-embedded-102/log/main.max_prepared_stmt_count_basic/'

Retrying test, attempt(2/3)...

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=147 [vm-win2003-64-b/embedded]

http://tinyurl.com/9kezfc