- 论坛徽章:
- 0
|
本帖最后由 clyet 于 2010-05-13 13:53 编辑
binlog中问题的insert语句:
insert into pageview_recorder_05 (fkey,time,ip,refer_url,url,cust_id,Permanent_id,machine,http_user_agent,misc,ref,trace_id) VALUES (0x3333393338363734,0x323031302D30352D31322032333A31393A3539,0x3131372E38392E3137392E313336,0x687474703A2F2F7365617263682E64616E6764616E672E636F6D2F7365617263682E7068703F636174616C6F673D266B65793D2543442543312542352544382542332546362543382543332653656172636846726F6D546F703D31,0x687474703A2F2F73656172636831393334352F70696E672E7068703F6163743D64656661756C7426706F733D305F305F305F266361743D266B65793DCDC1B5D8B3F6C8C32670696E666F3D3435355F355F3130266D696E666F3D305F305F30266E696E666F3D305F30266375737469643D7965563452786C5A58436C526F6C776962302B7677513D3D267065726D69643D3230313930373133353732373236353231373830323432373330313739313134322675726C3D687474702533412F2F7365617263682E64616E6764616E672E636F6D2F7365617263682E706870253346636174616C6F672533442532366B65792533442532354344253235433125323542352532354438253235423325323546362532354338253235433325323653656172636846726F6D546F70253344312532335075625F746F7026743D31323733363737353939353933,0x3232333139313433,0x323031393037313335373237323635323137383032343237333031373931313432,0x7365617263683139333435,0x4D6F7A696C6C612F342E302028636F6D70617469626C653B204D53494520362E303B2057696E646F7773204E5420352E313B205356313B20515150696E79696E203733303B204D415854484F4E20322E3029,NULL,NULL,NULL)
binlog不全是这样,只有一部分,其他是正常的语句。
实际上和slave没有什么关系,因为记入的binlog已经和master中实际数据不一致了,不知道这种原因是如何产生的。 |
|