Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2
Description
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 |
Attachments
Issue Links
- relates to
-
MDEV-25157 Replication ignores --slave_skip_error option and stops with "CONNECT Unsupported command"
- Open