maridb Error 'Operation DROP USER failed for
資料庫版本:mariadb 10.0.12
主庫刪除多餘的使用者名稱,因從庫沒有此資訊造成主從故障!
報錯資訊如下:
Error 'Operation DROP USER failed for 'username'@'192.16.%'
多源複製的主從報錯跳過:
根據mysql操作方式sql_slave_skip_counter = 1 ,執行不報錯,但是sql_slave_skip_counter = 1 不會生效
多源主從跳錯的操作如下:
SET @@default_master_connection = 'master_01';
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
STOP SLAVE 'master_01';
START SLAVE 'master_01';
主庫刪除多餘的使用者名稱,因從庫沒有此資訊造成主從故障!
報錯資訊如下:
Error 'Operation DROP USER failed for 'username'@'192.16.%'
多源複製的主從報錯跳過:
根據mysql操作方式sql_slave_skip_counter = 1 ,執行不報錯,但是sql_slave_skip_counter = 1 不會生效
多源主從跳錯的操作如下:
SET @@default_master_connection = 'master_01';
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
STOP SLAVE 'master_01';
START SLAVE 'master_01';
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28939273/viewspace-2097382/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- tidb Error: Operation aborted by user answer '' (cliutil.operation_aborted)TiDBError
- MySQL建立使用者報錯 ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'MySqlErrorAI
- Connection to x as user y failed: ERROR: Wrong password for userAIError
- [筆記].痛哉!!!Error: Can't access JTAG chain, Error: Operation failed筆記ErrorAI
- Oracle中drop user和drop user cascade的區別Oracle
- DBLOGIN ERROR: Failed to open data source for user OGG.ErrorAI
- "DROP USER" fails with error: ORA-00942 and ORA-00604 (一)AIError
- "DROP USER" fails with error: ORA-00942 and ORA-00604 (二)AIError
- Enable ISM Server User operation AuditingServer
- RAC User Equivalence Check FailedUIAI
- 【ERROR】OPatch failed with error code 73ErrorAI
- Connection to host as user root failed.ERROR: NMO not setuid-root (Unix-only)AIErrorUI
- NFS mount results in "vmount: operation not permitted" errorNFSMITError
- Failed to get D-Bus connection: Operation not permittedAIMIT
- [ERROR] Failed to open logErrorAI
- android模擬器 一個錯誤:X Error of failed request: BadRequest (invalid request code or no such operation)...AndroidErrorAI
- cuda runtime error (801) : operation not supportedError
- docker安裝matlab mount failed: Operation not permitted.DockerMatlabAIMIT
- mysql中delete fro mysql.user where XX和drop user的不同MySqldelete
- OPatch failed with error code 73AIError
- PRVF-4007 : User equivalence check failed for user "grid"UIAI
- Apache無法啟動解決 the requested operation has failedApacheAI
- ORA-00245: control file backup operation failedAI
- ORA-13516: AWR Operation failed: CATPROC not validAI
- sqlnet.log error - Operation timed outSQLError
- Installation failed with message INSTALL_FAILED_USER_RESTRICTED錯誤AIREST
- Error: failed PB timebomb checkErrorAI
- ORA-27300: OS system dependent operation:fork failed with statusAI
- 【ORACLE】ORA-00245: control file backup operation failedOracleAI
- ORA-27300: OS system dependent operation: CreateThread failedthreadAI
- ORA-29702: error occurred in Cluster Group Service operationError
- 資料庫審計(create/alter/drop table、user、tablespace)資料庫
- DROP USER過程中出現的奇怪的物件資訊物件
- About login/failed_user_auto_unlock work or notAI
- Error accessing PRODUCT_USER_PROFILEError
- Opiino: Attach Failed! Error=-1 Ifvp=0AIError
- ORA-27300: OS system dependent operation:fork failed with status: 12AI
- JBAS014613: Operation ("add") failed啟動報錯AI