-
Bug
-
-
Major
-
Resolution:
Fixed
-
N/A
-
-
-
-
10.1.9-1, 10.1.9-2
It's related to MDEV-6877 changes.
Test case (for reproducing, not for including into the test suite!)
|
# Run with --mysqld=--binlog-row-image=minimal
|
|
--source include/have_log_bin.inc
|
--source include/have_binlog_format_row.inc
|
|
CREATE TABLE t1 (pk INT PRIMARY KEY, f1 INT, f2 INT, f3 INT, f4 INT, f5 INT, f6 INT, f7 INT, f8 INT);
|
INSERT INTO t1 VALUES (10, 1, 2, 3, 4, 5, 6, 7, 8);
|
DELETE FROM t1;
|
|
--let $binlog = query_get_value(SHOW MASTER STATUS, File, 1)
|
--let $datadir = `SELECT @@datadir`
|
|
FLUSH BINARY LOGS;
|
|
--exec $MYSQL_BINLOG --verbose --base64-output=DECODE-ROWS $datadir/$binlog
|
|
DROP TABLE t1;
|
Partial output from 10.1 commit 302bf7c4664b904482ecc133476e822d497b114d
|
# at 739
|
#150705 2:12:29 server id 1 end_log_pos 777 GTID 0-1-3
|
/*!100001 SET @@session.gtid_seq_no=3*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 777
|
# at 827
|
#150705 2:12:29 server id 1 end_log_pos 827 Table_map: `test`.`t1` mapped to number 30
|
#150705 2:12:29 server id 1 end_log_pos 862 Delete_rows: table id 30 flags: STMT_END_F
|
### DELETE FROM `test`.`t1`
|
### WHERE
|
### @1=***Corrupted replication event was detected. Not printing the value***
|
# at 862
|
#150705 2:12:29 server id 1 end_log_pos 931 Query thread_id=4 exec_time=0 error_code=0
|
SET TIMESTAMP=1436051549/*!*/;
|
COMMIT
|
/*!*/;
|
# at 931
|
Notes:
- FLUSH LOGS is unrelated, it just allows to avoid warnings;
- the number of fields seems to be important.
- relates to
-
MDEV-6877
Merge binlog_row_image from MySQL 5.6
-
-
Closed
{"report":{"fcp":867.2000000476837,"ttfb":133.10000014305115,"pageVisibility":"visible","entityId":52067,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"617b0eab-80a2-40a5-b6f0-69b180b3b15f","navigationType":0,"readyForUser":927.9000000953674,"redirectCount":0,"resourceLoadedEnd":674,"resourceLoadedStart":147.10000014305115,"resourceTiming":[{"duration":286.2999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":147.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":147.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":433.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":286.10000014305115,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":147.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":147.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":433.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":295.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":147.40000009536743,"connectEnd":147.40000009536743,"connectStart":147.40000009536743,"domainLookupEnd":147.40000009536743,"domainLookupStart":147.40000009536743,"fetchStart":147.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":147.40000009536743,"responseEnd":442.5,"responseStart":442.5,"secureConnectionStart":147.40000009536743},{"duration":319.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":147.5,"connectEnd":147.5,"connectStart":147.5,"domainLookupEnd":147.5,"domainLookupStart":147.5,"fetchStart":147.5,"redirectEnd":0,"redirectStart":0,"requestStart":147.5,"responseEnd":467,"responseStart":467,"secureConnectionStart":147.5},{"duration":323,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":147.60000014305115,"connectEnd":147.60000014305115,"connectStart":147.60000014305115,"domainLookupEnd":147.60000014305115,"domainLookupStart":147.60000014305115,"fetchStart":147.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":147.60000014305115,"responseEnd":470.60000014305115,"responseStart":470.60000014305115,"secureConnectionStart":147.60000014305115},{"duration":323.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":147.70000004768372,"connectEnd":147.70000004768372,"connectStart":147.70000004768372,"domainLookupEnd":147.70000004768372,"domainLookupStart":147.70000004768372,"fetchStart":147.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":147.70000004768372,"responseEnd":471.10000014305115,"responseStart":471.10000014305115,"secureConnectionStart":147.70000004768372},{"duration":323.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":147.79999995231628,"connectEnd":147.79999995231628,"connectStart":147.79999995231628,"domainLookupEnd":147.79999995231628,"domainLookupStart":147.79999995231628,"fetchStart":147.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":147.79999995231628,"responseEnd":471.5,"responseStart":471.40000009536743,"secureConnectionStart":147.79999995231628},{"duration":324.39999985694885,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":147.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":147.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":472.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":323.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":148,"connectEnd":148,"connectStart":148,"domainLookupEnd":148,"domainLookupStart":148,"fetchStart":148,"redirectEnd":0,"redirectStart":0,"requestStart":148,"responseEnd":471.7999999523163,"responseStart":471.7999999523163,"secureConnectionStart":148},{"duration":324.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":148.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":148.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":472.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":324.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":148.20000004768372,"connectEnd":148.20000004768372,"connectStart":148.20000004768372,"domainLookupEnd":148.20000004768372,"domainLookupStart":148.20000004768372,"fetchStart":148.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":148.20000004768372,"responseEnd":472.40000009536743,"responseStart":472.40000009536743,"secureConnectionStart":148.20000004768372},{"duration":331.10000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":153.29999995231628,"connectEnd":153.29999995231628,"connectStart":153.29999995231628,"domainLookupEnd":153.29999995231628,"domainLookupStart":153.29999995231628,"fetchStart":153.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":153.29999995231628,"responseEnd":484.40000009536743,"responseStart":484.40000009536743,"secureConnectionStart":153.29999995231628},{"duration":520.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":153.70000004768372,"connectEnd":153.70000004768372,"connectStart":153.70000004768372,"domainLookupEnd":153.70000004768372,"domainLookupStart":153.70000004768372,"fetchStart":153.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":153.70000004768372,"responseEnd":674,"responseStart":674,"secureConnectionStart":153.70000004768372},{"duration":343.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":673.5,"connectEnd":673.5,"connectStart":673.5,"domainLookupEnd":673.5,"domainLookupStart":673.5,"fetchStart":673.5,"redirectEnd":0,"redirectStart":0,"requestStart":673.5,"responseEnd":1017.4000000953674,"responseStart":1017.4000000953674,"secureConnectionStart":673.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":12,"responseStart":133,"responseEnd":152,"domLoading":145,"domInteractive":981,"domContentLoadedEventStart":981,"domContentLoadedEventEnd":1022,"domComplete":1682,"loadEventStart":1682,"loadEventEnd":1683,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":963.6000001430511},{"name":"bigPipe.sidebar-id.end","time":964.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":964.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":967.2999999523163},{"name":"activityTabFullyLoaded","time":1029.2999999523163}],"measures":[],"correlationId":"463a93112087d2","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":67,"dbReadsTimeInMs":9,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}