閱讀322 返回首頁    go 阿裏雲 go 技術社區[雲棲]


mysq主從報錯Last_SQL_Error: Error 'Duplicate entry

報錯信息如下:

Last_SQL_Error: Error 'Duplicate entry '2738079' for key 'PRIMARY'' on query. Default database: 'whsir'. Query: 'INSERT INTO dede_uploads(title,url,mediatype,width,height,playtime,filesize,uptime,mid)
VALUES ('小圖361_170525114411_1_lit.png','/uploads/allimg/170525/361_170525114411_1_lit.png','1','640','360','0','167502','1495683851','361')'

解決辦法:

修改my.cnf文件/etc/my.cnf[mysqld]下加一行slave-skip-errors=all

最後更新:2017-07-03 11:02:32

  上一篇:go  ubuntu安裝新立得軟件包管理器報錯
  下一篇:go  賽思互動:利用數據分析來提高企業績效管理