./mtr rpl.rpl_heartbeat_basic
|
|
rpl.rpl_heartbeat_basic 'mix' [ pass ] 55221
|
|
MTR's internal check of the test case 'rpl.rpl_heartbeat_basic' failed.
|
This means that the test case does not preserve the state that existed
|
before the test case was executed. Most likely the test case did not
|
do a proper clean-up. It could also be caused by the previous test run
|
by this thread, if the server wasn't restarted.
|
This is the diff of the states of the servers before and after the
|
test case was executed:
|
mysqltest: Logging to '/extra.home/prohaska/mariadb-5.5.37-install/mysql-test/var/tmp/check-mysqld_2.log'.
|
mysqltest: Results saved in '/extra.home/prohaska/mariadb-5.5.37-install/mysql-test/var/tmp/check-mysqld_2.result'.
|
mysqltest: Connecting to server localhost:16001 (socket /extra.home/prohaska/mariadb-5.5.37-install/mysql-test/var/tmp/mysqld.2.sock) as 'root', connection 'default', attempt 0 ...
|
mysqltest: ... Connected.
|
mysqltest: Start processing test commands from './include/check-testcase.test' ...
|
mysqltest: ... Done processing test commands.
|
--- /extra.home/prohaska/mariadb-5.5.37-install/mysql-test/var/tmp/check-mysqld_2.result 2014-04-24 12:52:59.490405310 -0400
|
+++ /extra.home/prohaska/mariadb-5.5.37-install/mysql-test/var/tmp/check-mysqld_2.reject 2014-04-24 12:53:55.089530393 -0400
|
@@ -722,6 +722,9 @@
|
mysql.user plugin 41 NO char 64 64 NULL NULL latin1 latin1_swedish_ci char(64)
|
mysql.user authentication_string 42 NULL NO text 65535 65535 NULL NULL utf8 utf8_bin text
|
EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDSTATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
|
+def test e1 root@localhost SYSTEM SQL BEGIN
|
+UPDATE test.t1 SET a = a + 1 WHERE a < 10;
|
+END RECURRING NULL 1 SECOND 2014-04-24 12:53:16 NULL SLAVESIDE_DISABLED NOT PRESERVE 2014-04-24 12:53:16 2014-04-24 12:53:16 NULL 1 latin1 latin1_swedish_ci latin1_swedish_ci
|
TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
|
SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
|
add_suppression def mtr add_suppression PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN INSERT INTO test_suppressions (pattern) VALUES (pattern); END NULL NULL SQL NO CONTAINS SQL NULL DEFINER 2014-04-24 12:52:50 2014-04-24 12:52:50 root@localhost utf8 utf8_general_ci latin1_swedish_ci
|
|
mysqltest: Result length mismatch
|
|
not ok
|
|
--------------------------------------------------------------------------
|
The servers were restarted 0 times
|
Spent 55.221 of 70 seconds executing testcases
|
|
Check of testcase failed for: rpl.rpl_heartbeat_basic
|
{"report":{"fcp":754.3000001907349,"ttfb":172.5,"pageVisibility":"visible","entityId":36014,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"a77f0968-b780-46b3-83dd-a302556151fa","navigationType":0,"readyForUser":828.3000001907349,"redirectCount":0,"resourceLoadedEnd":884,"resourceLoadedStart":178.10000038146973,"resourceTiming":[{"duration":24.699999809265137,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":178.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":178.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":202.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":25.09999942779541,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":178.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":178.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":203.5,"responseStart":0,"secureConnectionStart":0},{"duration":81.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":178.5,"connectEnd":178.5,"connectStart":178.5,"domainLookupEnd":178.5,"domainLookupStart":178.5,"fetchStart":178.5,"redirectEnd":0,"redirectStart":0,"requestStart":178.5,"responseEnd":260.30000019073486,"responseStart":260.30000019073486,"secureConnectionStart":178.5},{"duration":139.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":178.70000076293945,"connectEnd":178.70000076293945,"connectStart":178.70000076293945,"domainLookupEnd":178.70000076293945,"domainLookupStart":178.70000076293945,"fetchStart":178.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":178.70000076293945,"responseEnd":318.4000005722046,"responseStart":318.4000005722046,"secureConnectionStart":178.70000076293945},{"duration":143.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":179,"connectEnd":179,"connectStart":179,"domainLookupEnd":179,"domainLookupStart":179,"fetchStart":179,"redirectEnd":0,"redirectStart":0,"requestStart":179,"responseEnd":322.1000003814697,"responseStart":322.1000003814697,"secureConnectionStart":179},{"duration":143.29999923706055,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":179.20000076293945,"connectEnd":179.20000076293945,"connectStart":179.20000076293945,"domainLookupEnd":179.20000076293945,"domainLookupStart":179.20000076293945,"fetchStart":179.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":179.20000076293945,"responseEnd":322.5,"responseStart":322.5,"secureConnectionStart":179.20000076293945},{"duration":143.60000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":179.30000019073486,"connectEnd":179.30000019073486,"connectStart":179.30000019073486,"domainLookupEnd":179.30000019073486,"domainLookupStart":179.30000019073486,"fetchStart":179.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":179.30000019073486,"responseEnd":322.9000005722046,"responseStart":322.9000005722046,"secureConnectionStart":179.30000019073486},{"duration":221.9000005722046,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":179.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":179.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":401.4000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":143.5999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":179.70000076293945,"connectEnd":179.70000076293945,"connectStart":179.70000076293945,"domainLookupEnd":179.70000076293945,"domainLookupStart":179.70000076293945,"fetchStart":179.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":179.70000076293945,"responseEnd":323.30000019073486,"responseStart":323.30000019073486,"secureConnectionStart":179.70000076293945},{"duration":221.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":179.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":179.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":401.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":143.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":180.10000038146973,"connectEnd":180.10000038146973,"connectStart":180.10000038146973,"domainLookupEnd":180.10000038146973,"domainLookupStart":180.10000038146973,"fetchStart":180.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":180.10000038146973,"responseEnd":323.80000019073486,"responseStart":323.80000019073486,"secureConnectionStart":180.10000038146973},{"duration":326.8999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":181.4000005722046,"connectEnd":181.4000005722046,"connectStart":181.4000005722046,"domainLookupEnd":181.4000005722046,"domainLookupStart":181.4000005722046,"fetchStart":181.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":181.4000005722046,"responseEnd":508.30000019073486,"responseStart":508.30000019073486,"secureConnectionStart":181.4000005722046},{"duration":348.6000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":181.5,"connectEnd":181.5,"connectStart":181.5,"domainLookupEnd":181.5,"domainLookupStart":181.5,"fetchStart":181.5,"redirectEnd":0,"redirectStart":0,"requestStart":181.5,"responseEnd":530.1000003814697,"responseStart":530.1000003814697,"secureConnectionStart":181.5},{"duration":96.89999961853027,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":411.9000005722046,"connectEnd":411.9000005722046,"connectStart":411.9000005722046,"domainLookupEnd":411.9000005722046,"domainLookupStart":411.9000005722046,"fetchStart":411.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":411.9000005722046,"responseEnd":508.80000019073486,"responseStart":508.80000019073486,"secureConnectionStart":411.9000005722046},{"duration":89.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":674.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":674.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":764.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":201,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":675.8000001907349,"connectEnd":675.8000001907349,"connectStart":675.8000001907349,"domainLookupEnd":675.8000001907349,"domainLookupStart":675.8000001907349,"fetchStart":675.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":675.8000001907349,"responseEnd":876.8000001907349,"responseStart":876.8000001907349,"secureConnectionStart":675.8000001907349},{"duration":185.69999980926514,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":748.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":748.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":934,"responseStart":0,"secureConnectionStart":0},{"duration":207.79999923706055,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":676.2000007629395,"connectEnd":676.2000007629395,"connectStart":676.2000007629395,"domainLookupEnd":676.2000007629395,"domainLookupStart":676.2000007629395,"fetchStart":676.2000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":676.2000007629395,"responseEnd":884,"responseStart":884,"secureConnectionStart":676.2000007629395}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":13,"responseStart":172,"responseEnd":176,"domLoading":175,"domInteractive":885,"domContentLoadedEventStart":885,"domContentLoadedEventEnd":929,"domComplete":1089,"loadEventStart":1089,"loadEventEnd":1090,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":865.4000005722046},{"name":"bigPipe.sidebar-id.end","time":866.1000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":866.2000007629395},{"name":"bigPipe.activity-panel-pipe-id.end","time":867.3000001907349},{"name":"activityTabFullyLoaded","time":947.9000005722046}],"measures":[],"correlationId":"b3e8e197565727","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":94,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
The problem appeared in the upstream tree after a check for events was added:
revno: 4558
revision-id: sayantan.dutta@oracle.com-20131212065057-xl4jjsx581mpnpv8
parent: guilhem.bichot@oracle.com-20131204113242-977a3wsclnh3uz7w
committer: sayantan dutta <sayantan.dutta@oracle.com>
branch nick: mysql-5.5
timestamp: Thu 2013-12-12 12:20:57 +0530
message:
Bug #17827378 - MTR DOES NOT REPORT IF A TEST FAILS TO DROP CREATED EVENTS
Fix pushed into 5.5 tree:
http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/4164