Skip to content
  • Praveenkumar Hulakund's avatar
    e451e7a9
    BUG#18432770 - SYS_VARS.LOG_SLOW_ADMIN_STATEMENTS_FUNC TEST · e451e7a9
    Praveenkumar Hulakund authored
                   IS FAILING ON WINDOWS ON 5.6 
    
    Analysis:
    ---------
    In test file "SYS_VARS.LOG_SLOW_ADMIN_STATEMENTS_FUNC.test",
    logging of slow admin statement such as ALTER, OPTIMIZE and ANALYZE
    operations is verified . When "long_query_time" is zero then
    admin statement which runs for  at least 1 microsecond is
    considered for logging. On some platforms (special on Windows)
    time taken for OPTIMIZE and ANALYZE table is less than 1 
    microsecond sometimes. So test is failed sporadically.
    
    Fix: 
    ----
    To make sure OPTIMIZE table operation take enough time
    so that it is logged, increased the number of rows in table.
    With the current changes also ANALYZE table returned within 1
    microsecond sometimes.Removed ANALYZE table operation from the
    test to avoid sporadic failure of this test case.
    CHECK table is another admin table which is logged to slow
    log table. Added CHECK table operation to test case.
    
    To test the changes, ran SYS_VARS.LOG_SLOW_ADMIN_STATEMENTS_FUNC
    for many times on windows machine.
    e451e7a9
    BUG#18432770 - SYS_VARS.LOG_SLOW_ADMIN_STATEMENTS_FUNC TEST
    Praveenkumar Hulakund authored
                   IS FAILING ON WINDOWS ON 5.6 
    
    Analysis:
    ---------
    In test file "SYS_VARS.LOG_SLOW_ADMIN_STATEMENTS_FUNC.test",
    logging of slow admin statement such as ALTER, OPTIMIZE and ANALYZE
    operations is verified . When "long_query_time" is zero then
    admin statement which runs for  at least 1 microsecond is
    considered for logging. On some platforms (special on Windows)
    time taken for OPTIMIZE and ANALYZE table is less than 1 
    microsecond sometimes. So test is failed sporadically.
    
    Fix: 
    ----
    To make sure OPTIMIZE table operation take enough time
    so that it is logged, increased the number of rows in table.
    With the current changes also ANALYZE table returned within 1
    microsecond sometimes.Removed ANALYZE table operation from the
    test to avoid sporadic failure of this test case.
    CHECK table is another admin table which is logged to slow
    log table. Added CHECK table operation to test case.
    
    To test the changes, ran SYS_VARS.LOG_SLOW_ADMIN_STATEMENTS_FUNC
    for many times on windows machine.
Loading