mysql - Replication issue on slave -


i have master-master replication setup db1 = windows server 2013, mysql v 5.6 db2 = debian, mysql v 5.5

i have replication couple of years now, , worked without issues. 2 days removed of unused users db1, limited root connection remote location, removed trigger , procedure

yesterday inserting records db1 , gets replicated db2, error generated:

error 'incorrect string value: '\xd8\xa8\xd9\x86\xd9\x83...' column 'url' @ row 1' on query. default database: 'media_media'.   query: 'insert    article     (id, publication_id, issue_date,      section_id, headline, headline_translated, author,      url, images_number, published, type_id,      tonality, created, created_by, page_name,      ave, reject, size, total_l,      total_w, `text`, text_translated, summary,      to_check, to_analyze, duration, broadcast_time,      issue_number, volume_number)   values     (null, '2956', '2017-04-06',      '10', 'بنك الإسكان الراعي الذهبي للقمة الأردنية الدولية الثالثة للطاقة', '', '',      'http://www.alwakaai.com/post/بنك-الإسكان-الراعي-الذهبي-للقمة-الأردنية-الدولية-الثالثة-للطاقة-238403/', '1', '1', '10',      '0', now(), '0', '',      '3000.00', '0', '0.00', '0.00',      '0.00', '<br />&nbsp;الوقائع الإخبارية:&nbsp; &nbsp; رعى 

the confusing part adds record db1 , db2 , gives error , replication stops processing further actions till skip error

today switched insertion process , inserts db2 , see error on db1 slave status.

last_sql_error: query caused different errors on master , slave.

error on master: message (format)='incorrect %-.32s value: '%-.128s' column '%.192s' @ row %ld' error code=1366 ;  error on slave: actual message='no error', error code=0. default database: 'media_media'.  query: 'insert    article     (id, publication_id, issue_date,      section_id, headline, headline_translated, author,      url, images_number, published, type_id,      tonality, created, created_by,page_name,      ave, reject, size, total_l,      total_w, `text`, text_translated, summary,      to_check, to_analyze, duration, broadcast_time,      issue_number, volume_number)   values     (null, '2835', '2017-03-30',      '10', 'وسائل إعلام تشيدبأداء منتجات هواوي عالي المستوى', '', '',      'http://www.almadenahnews.com/article/565845-وسائل-إعلام-تشيد-بأداء-منتجات-هواوي-عالي-المستوى', '1', '1', '10',      '0', now(), '0', '',      '3000.00', '0', '0.00', '0.00', 

the encoding uft8 through 2 db's suggestions on should here? thanks!


Comments

Popular posts from this blog

Command prompt result in label. Python 2.7 -

javascript - How do I use URL parameters to change link href on page? -

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -