Last_SQL_Error: Could not execute Update_rows event
踩吭:
主從同步錯誤 :
Last_SQL_Error: Could not execute Update_rows event on table db_name.table_name; Can't find record in 'table_name', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log mysql-bin.000106, end_log_pos 1057304453
去檢視那個sql執行到的位置sql語句,是一個update
在主庫和從庫上都能找到這條記錄。
這就怪了,還報找不到這個記錄:
只能去找 萬能的網路了。
ROW Format Replication Can't Find Record with Floating Point Fields
我就找到這個文件,檢視了一下,和我的情況很匹配.
1 binlog_foramt=row
2 表中有float欄位
3 版本是5.5
總結原因是:
對float或double型別的 使用binlog_format=row時 出現了這個問題:
解決方法 :
1 使用DECIMAL 替代float,double
2 還原從庫時不使用邏輯備份的,而使用物理備份
3 加主鍵
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25099483/viewspace-1760506/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Could not execute Write_rows event on table time_task.tt_log
- 【Mysql】Last_SQL_Error: 1594MySqlASTError
- MySQL案例01:Last_SQL_Errno: 1755 Cannot execute the current event group in the parallel modeMySqlASTParallel
- hibernate配置級聯刪除時報錯:could not execute statement; SQL [n/a]; constraint [null]SQLAINull
- The Execute Disable/No Execute CPU feature is not enabled for this machineMac
- mysql從庫伺服器down機報錯Could not parse relay log event entryMySql伺服器
- VMware: ESXi requires the Execute Disable/No Execute CPU feature to be enabledUI
- java cmd executeJava
- Execute to Parse 指標指標
- event_x ()、event_y ()、event_x_root ()、event_y_root ()
- app:processReleaseResources, Failed to execute aaptAPPAIAPT
- 理解EXECUTE_TO_PARSE(二)
- 理解EXECUTE_TO_PARSE(一)
- EXECUTE IMMEDIATE dynamic sql in procedureSQL
- ExecutorService之submit與executeMIT
- SQL can execute in wrong SchemaSQL
- Spring CouldSpring
- i_init_func_execute_data
- AWR Execute to Parse引數解析
- execute shell script from stored procedure
- EXECUTE DBMS_LOGSTDBY.BUILDUI
- execute immediate 語法小結
- event.preventDefault()和event.stopPropagation()
- JavaScript EventJavaScript
- Event LoopOOP
- apt could not get lockAPT
- VS Could not evaluate expressionExpress
- could not initialize proxy - no SessionSession
- Event ID: 1111 , Event Source: TermServDevicesdev
- Apache httpclient的execute方法除錯ApacheHTTPclient除錯
- 載入驅動三種execute
- execute immediate的簡單用法(oracle)Oracle
- 11g DBMS_PARALLEL_EXECUTEParallel
- revoke EXECUTE privileges on powerful packages from PUBLICPackage
- 在QTP中使用Eval與ExecuteQT
- EXECUTE IMMEDIATE 呼叫動態過程
- EXECUTE IMMEDIATE 儲存過程中 許可權不足及EXECUTE IMMEDIATE的除錯避坑儲存過程除錯
- jquery , find the event handler,找到jquery中的event handlerjQuery