~tsarev/percona-server/5.1_slow_extended_tests_fixes

~tsarev/percona-server/5.1_slow_extended_tests_fixes_2 » Changes from revision 251

From Revision 251 to 232

Rev	Summary	Authors	Date
251	1) Move all tests from mysql-test/slow_extended.patch to slo... 1) Move all tests from mysql-test/slow_extended.patch to slow_extended.patch. Now tests in "percona" suite 2) Rename all tests from percoa_slow_extended-X to X name 3) Extract start/stop/grep logic from tests to log_start/log_stop/log_grep includes 4) Remove tests mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time, because variable "use_global_long_query_time" was removed in 5.5 (and logic from this test) available in the slow_query_log_use_global_control. 5) Replace all SLEEP(X) by SET SESSION debug="+d,query_exec_time_X" or /* query_exec_time_X */ Also fixes bugs: bug #794780 - "percona_slow_extended-microseconds_in_slow_extended sometimes fails" bug #803071 - "add command-line variable setup test - log_slow_filter" bug #803076 - "add command-line variable setup test - log_slow_slave_statements" bug #803088 - "fix tests for log_slow_sp_statements: bug #803093 - "add test for variable "log_slow_timestamp_every/slow_query_log_timestamp_always" (not command-line version)" bug #803100 - "fix tests for use_global_log_slow_control/slow_query_log_use_global_control" bug #803110 - "fix tests for slow_query_log_microseconds_timestamp/slow_query_log_timestamp_precision" bug #803120 - "log_slow_verbosity ommited command-line tests in 5.5 " bug #803137 - "rename percona_slow_extended-slave_innodb_stats.test to percona_slow_extended-log_slow_verbosity-innodb.test" bug #760085 - "main.percona_slow_extended-slave_innodb_stats fails sporadically in 5.1.56 " bug #803140 - "percona_slow_extended-min_examined_row_limit.test incorrect"	Oleg Tsarev	12 years ago
250	Fixes for bugs #712393 #803867 Fixes for bugs #712393 #803867 1) I move query_response_time_collect call from intermediate of log_slow_statement to begin. Reason of bug #712393 - log_slow_statement exit before call query_response_time_collect 2) I move all DBUG_EXECUTE_IF (what used in percona_query_response_time.test) from response_time_distribution.patch to slow_extended.patch This functionality requires in the slow_extended sporadic fails 3) If we set "debug" variable: SET [SESSION\|GLOBAL] debug="+d,query_exec_time_debug" we can setup exact query_exec_time through set "debug" variable: SET [SESSION\|GLOBAL] debug="+d,query_exec_time_TIMES"; where TIMES is [0.31\|0.32\|0.33\|0.34\|0.35\|0.36\|0.37\|0.38\|0.39\|0.4\|0.5\|1.1\|1.2\|1.3\|1.4\|1.5\|2.1\|2.3\|2.5] After this commit we can also add special comment to the begin of query: /* query_exec_time="TIMES" / QUERY; This changes requires for test SQL_Slave_Thread query execution. 4) I replace logic: /----------------------------------------/ DBUG_EXECUTE_IF("query_exec_time_debug", if (query_execution_time == 0) opt_query_response_time_stats= 0; else opt_query_response_time_stats= 1;); /----------------------------------------/ By following: /----------------------------------------/ void query_response_time_collect_with_check(ulonglong query_exec_time) { DBUG_ENTER("query_response_time_collect_with_check"); bool collect= opt_query_response_time_stats; DBUG_EXECUTE_IF("query_exec_time_debug", { if (0 == query_exec_time) { collect= false; } }); if(collect) { query_response_time_collect(query_exec_time); } DBUG_VOID_RETURN; } /----------------------------------------*/ Otherwise debug-code has bad side-effect - set QUERY_RESPONSE_TIME_STATS to OFF if query shouldn't collect 5) I rewrite tests for response_time_distribution.patch, now all test unified and wouldn't have sporadic fails in the feature. This change fixes the bug #803867. 6) I also remove mysql-test/response_time_distribution.patch and move to patch. Now this is the suite "percona" and tests "query_response_time[-[stored\|replication]]" 7) I also move have_response_time_distribution.[require\|inc] to patch 8) I also add "percona_suite.patch" for include "percona" test suite to default suites list	Oleg Tsarev	12 years ago
249	merge fdatasync() usage for innodb log files merge fdatasync() usage for innodb log files	Stewart Smith	12 years ago
248	merge bug 802829 fix merge bug 802829 fix	Stewart Smith	12 years ago
247	merge zip_clean removal merge zip_clean removal	Stewart Smith	12 years ago
246	fix bug794840 and bug802348 fix bug794840 and bug802348	kinoyasu	12 years ago
245	merge test fixes for percona_server_variables merge test fixes for percona_server_variables	Stewart Smith	12 years ago
244	merge valgrind fix for profiling_slow.patch around enabling ... merge valgrind fix for profiling_slow.patch around enabling of profiling_use_getrusage	Stewart Smith	12 years ago
243	regenerate slow_extended.patch to attempt to fix hunk apply ... regenerate slow_extended.patch to attempt to fix hunk apply failure on CentOS 5 hosts.	Stewart Smith	12 years ago
242	merge bug794776 fix: write_to_slow_log used without initiali... merge bug794776 fix: write_to_slow_log used without initialization	Stewart Smith	12 years ago
241	merge fix of Percona-Server directories, including very usef... merge fix of Percona-Server directories, including very useful symlinks to simplify jenkins build	Stewart Smith	12 years ago
240	merge fix for precona_innodb_deadlock failures merge fix for precona_innodb_deadlock failures	Stewart Smith	12 years ago
239	merge bug 704216 fix: ignore-builtin-innodb merge bug 704216 fix: ignore-builtin-innodb	Stewart Smith	12 years ago
238	merge fix include/wait_for_slave_param.inc to use real timeo... merge fix include/wait_for_slave_param.inc to use real timeout value and not a tenth of it	Stewart Smith	12 years ago
237	merge percona_innodb_buffer_pool_shm test fixup for removed ... merge percona_innodb_buffer_pool_shm test fixup for removed buffer pool shm	Stewart Smith	12 years ago
236	Move tests from mysql-test/ to mysql-test/innodb_deadlock_co... Move tests from mysql-test/ to mysql-test/innodb_deadlock_count.patch according to bug #788569 Now test explicit return "ERROR 40001: Deadlock found when trying to get lock; try restarting transaction"	Oleg Tsarev	12 years ago
235	merge minimize buf pool shm patch (removes shm buffer pool merge minimize buf pool shm patch (removes shm buffer pool functionality)	Stewart Smith	12 years ago
234	merge atomic fixes for response-time-distribution.patch merge atomic fixes for response-time-distribution.patch	Stewart Smith	12 years ago
233	BEFORE-FIX behaviour: ,/install_tests.sh always install all ... BEFORE-FIX behaviour: ,/install_tests.sh always install all files from mysql-test/ AFTER-FIX behavior: ./install_tests.sh install tests just for patches listed in "series" file and from mysql-test/. For every "name.patch" patch we have directory "mysql-test/name.patch/" with tests for this patch. This script help to maintain patches, merge between different versions, backport patches with tests and so one. My change fix bug #782391 My change included fix of bug #790199 already. Also script print statistics of patch applying.	Oleg Tsarev	12 years ago
232	Use bash as interpreter Use bash as interpreter This script use the bash-specific construction let.	Ignacio Nin	12 years ago

Older »