Mariadb-10.2.13 (MASTER)
Mariadb-10.2.13 (SLAVE)
use config MASTER/SLAVE replication AND Oracle connect engine
[SLAVE Status]
Last_Error: Error executing row event: 'Access denied for user ''@'' (using password: NO)'
|
.
|
Last_SQL_Error: Error executing row event: 'Access denied for user ''@'' (using password: NO)'
|
=====================================================================
[SLAVE Error]
2018-03-07 10:50:12 139672396281600 [ERROR] Slave SQL: Error executing row event: 'Access denied for user ''@'' (using password: NO)', Gtid 0-1-2431744, Internal MariaDB error code: 1045
|
2018-03-07 10:50:12 139672396281600 [Warning] Slave: Access denied for user ''@'' (using password: NO) Error_code: 1045
|
2018-03-07 10:50:12 139672396281600 [Warning] Slave: Got error 122 'This operation requires the FILE privilege' from CONNECT Error_code: 1296
|
2018-03-07 10:50:12 139672396281600 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000131' position 628823487
|
2018-03-07 10:50:12 139674090174208 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000131' at position 628823487
|
======================================================================
[Master Query]
#180307 3:47:34 server id 1 end_log_pos 628823487 CRC32 0xb6d494b1 Query thread_id=575007 exec_time=0 error_code=0
|
SET TIMESTAMP=1520362054/*!*/;
|
CREATE OR REPLACE TABLE `ora_ctx_t_ctx_dspy_cate_m` (
|
`DSPY_CATE_ID` int(11) NOT NULL,
|
`ROOT_DSPY_CATE_ID` int(11) NOT NULL,
|
`DSPY_CATE_NM` varchar(200) DEFAULT NULL,
|
`UPPER_DSPY_CATE_ID` int(11) DEFAULT NULL,
|
`EXPSR_YN` char(1) DEFAULT NULL,
|
`REPR_YN` char(1) DEFAULT NULL,
|
`CTN` varchar(1000) DEFAULT NULL,
|
`SORT_SEQ` int(11) DEFAULT NULL,
|
`USE_YN` char(1) DEFAULT NULL,
|
`REG_ID` varchar(13) DEFAULT NULL,
|
`REG_DT` datetime DEFAULT current_timestamp(),
|
`UPD_ID` varchar(13) DEFAULT NULL,
|
`UPD_DT` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
|
) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='Driver=oracle;DSN=pcerp;UID=ctxowner;PWD=ctxowner' `TABLE_TYPE`=ODBC `tabname`='T_CTX_DSPY_CATE_M'
|
/*!*/;
|
# at 628823487
|
- relates to
-
MDEV-25157
Replication ignores --slave_skip_error option and stops with "CONNECT Unsupported command"
-
-
Open
{"report":{"fcp":790.6000001430511,"ttfb":136.60000014305115,"pageVisibility":"visible","entityId":66180,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"2b4b7a5c-ebbf-4b22-b153-ba72961ddd1f","navigationType":0,"readyForUser":854,"redirectCount":0,"resourceLoadedEnd":906.8000001907349,"resourceLoadedStart":143,"resourceTiming":[{"duration":176.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":143,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":143,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":319.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":176.79999995231628,"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":143.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":143.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":320.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":186.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":143.40000009536743,"connectEnd":143.40000009536743,"connectStart":143.40000009536743,"domainLookupEnd":143.40000009536743,"domainLookupStart":143.40000009536743,"fetchStart":143.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":143.40000009536743,"responseEnd":329.80000019073486,"responseStart":329.7000000476837,"secureConnectionStart":143.40000009536743},{"duration":263.2000000476837,"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":143.5,"connectEnd":143.5,"connectStart":143.5,"domainLookupEnd":143.5,"domainLookupStart":143.5,"fetchStart":143.5,"redirectEnd":0,"redirectStart":0,"requestStart":143.5,"responseEnd":406.7000000476837,"responseStart":406.7000000476837,"secureConnectionStart":143.5},{"duration":267.7999999523163,"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":143.70000004768372,"connectEnd":143.70000004768372,"connectStart":143.70000004768372,"domainLookupEnd":143.70000004768372,"domainLookupStart":143.70000004768372,"fetchStart":143.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":143.70000004768372,"responseEnd":411.5,"responseStart":411.5,"secureConnectionStart":143.70000004768372},{"duration":268.09999990463257,"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":143.80000019073486,"connectEnd":143.80000019073486,"connectStart":143.80000019073486,"domainLookupEnd":143.80000019073486,"domainLookupStart":143.80000019073486,"fetchStart":143.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":143.80000019073486,"responseEnd":411.90000009536743,"responseStart":411.90000009536743,"secureConnectionStart":143.80000019073486},{"duration":268.5,"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":143.80000019073486,"connectEnd":143.80000019073486,"connectStart":143.80000019073486,"domainLookupEnd":143.80000019073486,"domainLookupStart":143.80000019073486,"fetchStart":143.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":143.80000019073486,"responseEnd":412.30000019073486,"responseStart":412.30000019073486,"secureConnectionStart":143.80000019073486},{"duration":268.80000019073486,"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":144,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":144,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":412.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":268.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":144.10000014305115,"connectEnd":144.10000014305115,"connectStart":144.10000014305115,"domainLookupEnd":144.10000014305115,"domainLookupStart":144.10000014305115,"fetchStart":144.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":144.10000014305115,"responseEnd":412.7000000476837,"responseStart":412.7000000476837,"secureConnectionStart":144.10000014305115},{"duration":269,"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":144.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":144.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":413.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":268.90000009536743,"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":144.40000009536743,"connectEnd":144.40000009536743,"connectStart":144.40000009536743,"domainLookupEnd":144.40000009536743,"domainLookupStart":144.40000009536743,"fetchStart":144.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":144.40000009536743,"responseEnd":413.30000019073486,"responseStart":413.30000019073486,"secureConnectionStart":144.40000009536743},{"duration":362.2000000476837,"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":145.10000014305115,"connectEnd":145.10000014305115,"connectStart":145.10000014305115,"domainLookupEnd":145.10000014305115,"domainLookupStart":145.10000014305115,"fetchStart":145.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":145.10000014305115,"responseEnd":507.30000019073486,"responseStart":507.30000019073486,"secureConnectionStart":145.10000014305115},{"duration":761.7000000476837,"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":145.10000014305115,"connectEnd":145.10000014305115,"connectStart":145.10000014305115,"domainLookupEnd":145.10000014305115,"domainLookupStart":145.10000014305115,"fetchStart":145.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":145.10000014305115,"responseEnd":906.8000001907349,"responseStart":906.8000001907349,"secureConnectionStart":145.10000014305115},{"duration":319.09999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":543.3000001907349,"connectEnd":543.3000001907349,"connectStart":543.3000001907349,"domainLookupEnd":543.3000001907349,"domainLookupStart":543.3000001907349,"fetchStart":543.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":543.3000001907349,"responseEnd":862.4000000953674,"responseStart":862.4000000953674,"secureConnectionStart":543.3000001907349}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":10,"responseStart":137,"responseEnd":139,"domLoading":141,"domInteractive":928,"domContentLoadedEventStart":928,"domContentLoadedEventEnd":970,"domComplete":1685,"loadEventStart":1685,"loadEventEnd":1686,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":908.5},{"name":"bigPipe.sidebar-id.end","time":909.3000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":909.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":911.9000000953674},{"name":"activityTabFullyLoaded","time":981}],"measures":[],"correlationId":"800b5ed7b5392f","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":70,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}