-
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.
Praveenkumar Hulakund authoredIS 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