• unknown's avatar
    Fix multiple test suite failures in Buildbot due to races in the test cases or... · 0855019e
    unknown authored
    Fix multiple test suite failures in Buildbot due to races in the test cases or missing server features not properly checked
    
    mysql-test/r/func_misc.result:
      Move test that requires query cache from main.func_misc to main.query_cache.
    mysql-test/r/mysqltest.result:
      Fix test failure due to race.
      This test case creates > 300 connections in a tight loop, and depending on thread
      scheduling and load, even though each connection is immediately disconnected
      before connecting the next one, the server max connections may still be exceeded
      due to server not being able to free old connections as fast as new ones are made.
    mysql-test/r/query_cache.result:
      Move test that requires query cache from main.func_misc to main.query_cache.
      Move test that requires query cache from main.variables to main.query_cache.
    mysql-test/r/query_cache_notembedded.result:
      Move test that requires query cache from main.sp_notembedded to main.query_cache_notembedded.
    mysql-test/r/sp_notembedded.result:
      Move test that requires query cache from main.sp_notembedded to main.query_cache_notembedded.
    mysql-test/r/udf.result:
      Move test in main.udf that requires query cache to separate file.
    mysql-test/r/udf_query_cache.result:
      Move test in main.udf that requires query cache to separate file.
    mysql-test/r/variables.result:
      Move test that requires query cache from main.variables to main.query_cache.
    mysql-test/suite/funcs_1/datadict/processlist_val.inc:
      Fix race where result file may show state "cleaning up" in the small window
      between setting COMMAND to 'Sleep' and clearing STATE.
    mysql-test/suite/rpl/r/rpl_temporary.result:
      Fix race with suppression of warning message by fixing the test to not generate the
      warning message in the first place.
      
      Problem was a race between creating an anonymous account and resetting the slave.
      If the slave reset happens before replicating the account, the subsequest deletion
      of the account will fail to replicate correctly due to missing row.
    mysql-test/suite/rpl/t/rpl_temporary.test:
      Fix race with suppression of warning message by fixing the test to not generate the
      warning message in the first place.
      
      Problem was a race between creating an anonymous account and resetting the slave.
      If the slave reset happens before replicating the account, the subsequest deletion
      of the account will fail to replicate correctly due to missing row.
    mysql-test/t/func_misc.test:
      Move test that requires query cache from main.func_misc to main.query_cache.
      Move test that requires query cache from main.variables to main.query_cache.
    mysql-test/t/mysqltest.test:
      Fix test failure due to race.
      This test case creates > 300 connections in a tight loop, and depending on thread
      scheduling and load, even though each connection is immediately disconnected
      before connecting the next one, the server max connections may still be exceeded
      due to server not being able to free old connections as fast as new ones are made.
    mysql-test/t/query_cache.test:
      Move test that requires query cache to main.query_cache.
    mysql-test/t/query_cache_notembedded.test:
      Move test that requires query cache from main.sp_notembedded to main.query_cache_notembedded.
    mysql-test/t/sp_notembedded.test:
      Move test that requires query cache from main.sp_notembedded to main.query_cache_notembedded.
    mysql-test/t/udf.test:
      Move test in main.udf that requires query cache to separate file.
    mysql-test/t/udf_query_cache-master.opt:
      Move test in main.udf that requires query cache to separate file.
    mysql-test/t/udf_query_cache.test:
      Move test in main.udf that requires query cache to separate file.
    mysql-test/t/variables.test:
      Move test that requires query cache from main.variables to main.query_cache.
    tests/mysql_client_test.c:
      In tests that require query cache, skip the test if query cache not available.
      Do this dynamically rather than using HAVE_QUERY_CACHE, as there is no guarantee
      that the server we run against was compiled with same preprocessor #define as
      the mysql_client_test program (and since it is trivial to check dynamically).
    0855019e
variables.result 51.2 KB