In order for the following test cases to pass:
perfschema.binlog_mix perfschema.binlog_row perfschema.binlog_stmt
We need to backport:
revno: 4559
committer: Marc Alff <marc.alff@oracle.com>
branch nick: mysql-5.6-bug14741537-v4
timestamp: Thu 2012-11-08 22:40:31 +0100
message:
Bug#14741537 - MYSQL 5.6, GTID AND PERFORMANCE_SCHEMA
Currently in progress.
Timour Katchaounov (Inactive)
added a comment - In order for the following test cases to pass:
perfschema.binlog_mix perfschema.binlog_row perfschema.binlog_stmt
We need to backport:
revno: 4559
committer: Marc Alff <marc.alff@oracle.com>
branch nick: mysql-5.6-bug14741537-v4
timestamp: Thu 2012-11-08 22:40:31 +0100
message:
Bug#14741537 - MYSQL 5.6, GTID AND PERFORMANCE_SCHEMA
Currently in progress.
In order to reuse MySQL's version of perfschema.privilege (and the related privilege.inc), it is necessary to backport the following patch. I don't think this is a priority ATM.
Analysis
--------
When an ALTER TABLE operation is performed with an invalid foreign key
constraint, the error reported is ER_CANT_CREATE_TABLE(Cannot create
the table). The ALTER TABLE operation is performed on a copy of the
original table, the original table is later deleted and the copy is
renamed to the original table name. The error reported contains the
temporary table name which is of the format
'database_ name.#sql-[0-9_a-f-]*'.
Fix:
—
print_error() which maps the handler error to a SQL error has been used
to report the error. This has helped in reporting more specific errors
instead of the previously reported generic error ER_CANT_CREATE_TABLE
(Cannot create the table) in most of the error scenarios. For the case
of invalid foreign key constraint, the error that will be reported is:
ER_CANNOT_ADD_FOREIGN- Cannot add foreign key constraint.
Timour Katchaounov (Inactive)
added a comment - - edited In order to reuse MySQL's version of perfschema.privilege (and the related privilege.inc), it is necessary to backport the following patch. I don't think this is a priority ATM.
------------------------------------------------------------
revno: 3690.34.61
committer: Nisha Gopalakrishnan <nisha.gopalakrishnan@oracle.com>
branch nick: mysql-trunk-13840553_2
timestamp: Thu 2012-06-07 09:12:57 +0530
message:
Bug#13840553:64617: MYSQL MUST IMPROVE ERROR MESSAGES
Analysis
--------
When an ALTER TABLE operation is performed with an invalid foreign key
constraint, the error reported is ER_CANT_CREATE_TABLE(Cannot create
the table). The ALTER TABLE operation is performed on a copy of the
original table, the original table is later deleted and the copy is
renamed to the original table name. The error reported contains the
temporary table name which is of the format
'database_ name.#sql- [0-9_a-f-] *'.
Fix:
—
print_error() which maps the handler error to a SQL error has been used
to report the error. This has helped in reporting more specific errors
instead of the previously reported generic error ER_CANT_CREATE_TABLE
(Cannot create the table) in most of the error scenarios. For the case
of invalid foreign key constraint, the error that will be reported is:
ER_CANNOT_ADD_FOREIGN- Cannot add foreign key constraint.
It turns out that there is an additional PFS-related test suite - perfschema_stress, that needs to be merged.
Timour Katchaounov (Inactive)
added a comment - It turns out that there is an additional PFS-related test suite - perfschema_stress, that needs to be merged.
Agreed with Serg that it doesn't make sense to check the remaining patches, because all tests cases are merged anyway.
Timour Katchaounov (Inactive)
added a comment - Agreed with Serg that it doesn't make sense to check the remaining patches, because all tests cases are merged anyway.
People
Timour Katchaounov (Inactive)
Timour Katchaounov (Inactive)
Votes:
0Vote for this issue
Watchers:
2Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":767.0999999046326,"ttfb":151,"pageVisibility":"visible","entityId":24453,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"2ba17e9a-a1c0-43c4-9e70-700c1a154da4","navigationType":0,"readyForUser":829.7000000476837,"redirectCount":0,"resourceLoadedEnd":780.7999999523163,"resourceLoadedStart":156.59999990463257,"resourceTiming":[{"duration":170.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":156.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":327,"responseStart":0,"secureConnectionStart":0},{"duration":170.20000004768372,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":156.89999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":327.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":183.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/b09d0d077992e4331b5f9ec0d3ec448c-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":157,"connectEnd":157,"connectStart":157,"domainLookupEnd":157,"domainLookupStart":157,"fetchStart":157,"redirectEnd":0,"redirectStart":0,"requestStart":157,"responseEnd":340.59999990463257,"responseStart":340.59999990463257,"secureConnectionStart":157},{"duration":307.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/b47ab3df14096803b180217eb8482517-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":157.09999990463257,"connectEnd":157.09999990463257,"connectStart":157.09999990463257,"domainLookupEnd":157.09999990463257,"domainLookupStart":157.09999990463257,"fetchStart":157.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":157.09999990463257,"responseEnd":465,"responseStart":465,"secureConnectionStart":157.09999990463257},{"duration":311,"initiatorType":"script","name":"https://jira.mariadb.org/s/6c569cbf8087ab04e40d0bef98627457-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":157.20000004768372,"connectEnd":157.20000004768372,"connectStart":157.20000004768372,"domainLookupEnd":157.20000004768372,"domainLookupStart":157.20000004768372,"fetchStart":157.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":157.20000004768372,"responseEnd":468.2000000476837,"responseStart":468.2000000476837,"secureConnectionStart":157.20000004768372},{"duration":311.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":157.29999995231628,"connectEnd":157.29999995231628,"connectStart":157.29999995231628,"domainLookupEnd":157.29999995231628,"domainLookupStart":157.29999995231628,"fetchStart":157.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":157.29999995231628,"responseEnd":468.7999999523163,"responseStart":468.7999999523163,"secureConnectionStart":157.29999995231628},{"duration":311.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":157.29999995231628,"connectEnd":157.29999995231628,"connectStart":157.29999995231628,"domainLookupEnd":157.29999995231628,"domainLookupStart":157.29999995231628,"fetchStart":157.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":157.29999995231628,"responseEnd":469.09999990463257,"responseStart":469.09999990463257,"secureConnectionStart":157.29999995231628},{"duration":312.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":157.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":469.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":312,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":157.59999990463257,"connectEnd":157.59999990463257,"connectStart":157.59999990463257,"domainLookupEnd":157.59999990463257,"domainLookupStart":157.59999990463257,"fetchStart":157.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":157.59999990463257,"responseEnd":469.59999990463257,"responseStart":469.59999990463257,"secureConnectionStart":157.59999990463257},{"duration":312.39999985694885,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/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":157.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":470.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":312.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/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":157.79999995231628,"connectEnd":157.79999995231628,"connectStart":157.79999995231628,"domainLookupEnd":157.79999995231628,"domainLookupStart":157.79999995231628,"fetchStart":157.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":157.79999995231628,"responseEnd":470.2999999523163,"responseStart":470.2999999523163,"secureConnectionStart":157.79999995231628},{"duration":605.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":163.09999990463257,"connectEnd":163.09999990463257,"connectStart":163.09999990463257,"domainLookupEnd":163.09999990463257,"domainLookupStart":163.09999990463257,"fetchStart":163.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":163.09999990463257,"responseEnd":768.2999999523163,"responseStart":768.2999999523163,"secureConnectionStart":163.09999990463257},{"duration":613.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":167.5,"connectEnd":167.5,"connectStart":167.5,"domainLookupEnd":167.5,"domainLookupStart":167.5,"fetchStart":167.5,"redirectEnd":0,"redirectStart":0,"requestStart":167.5,"responseEnd":780.7999999523163,"responseStart":780.7999999523163,"secureConnectionStart":167.5},{"duration":277.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":490.7999999523163,"connectEnd":490.7999999523163,"connectStart":490.7999999523163,"domainLookupEnd":490.7999999523163,"domainLookupStart":490.7999999523163,"fetchStart":490.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":490.7999999523163,"responseEnd":768.7000000476837,"responseStart":768.5999999046326,"secureConnectionStart":490.7999999523163},{"duration":26.40000009536743,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":759.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":759.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":786.2000000476837,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":17,"responseStart":151,"responseEnd":167,"domLoading":154,"domInteractive":935,"domContentLoadedEventStart":935,"domContentLoadedEventEnd":980,"domComplete":1165,"loadEventStart":1165,"loadEventEnd":1166,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":911.2999999523163},{"name":"bigPipe.sidebar-id.end","time":912.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":912.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":913.8999998569489},{"name":"activityTabFullyLoaded","time":999.2999999523163}],"measures":[],"correlationId":"caab4d42a35584","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":87,"dbReadsTimeInMs":8,"dbConnsTimeInMs":15,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
In order for the following test cases to pass:
perfschema.binlog_mix perfschema.binlog_row perfschema.binlog_stmt
We need to backport:
revno: 4559
committer: Marc Alff <marc.alff@oracle.com>
branch nick: mysql-5.6-bug14741537-v4
timestamp: Thu 2012-11-08 22:40:31 +0100
message:
Bug#14741537 - MYSQL 5.6, GTID AND PERFORMANCE_SCHEMA
Currently in progress.