Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15498

replication connect engine Slave: Access denied for user ''@'' (using password: NO) Error_code: 1045

    XMLWordPrintable

    Details

      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

            Activity

              People

              Assignee:
              Elkin Andrei Elkin
              Reporter:
              nyxneuf Na Yun Ho
              Votes:
              1 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration