HexDumped Binlogs

[Andreas Kammerer]

OK, i dumpd the binlogs. As far as i see the umlaut is absolutely idetical in Master and Slave Logs (e4)

So first the Slave-Status:

C:\Users\admin_csw\Desktop>mysql -pasus -e "show slave status\G"
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.21.24
Master_User: slave_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: PC-SD-PL-04-bin.000013
Read_Master_Log_Pos: 2313833
Relay_Log_File: SRV-PLATTENLAG-relay-bin.000069
Relay_Log_Pos: 1214
Relay_Master_Log_File: PC-SD-PL-04-bin.000013
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1267
Last_Error: Error 'Illegal mix of collations (latin1_swedish_
ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='' on query. Defaul
t database: 'lager'. Query: 'UPDATE `lager`.`materialpostings` SET `fSAVESTATUS`
='1' WHERE `strJOB`='Rehberger K-Põdag 31 07' AND `nPARTIALRESULT`='0' AND `strM
AT`='FUN0412PO19' AND `fTYPE`='0' AND `nTYP`='1' AND `strNR`='1' AND `fSAVESTATU
S`='0''
Skip_Counter: 0
Exec_Master_Log_Pos: 4136
Relay_Log_Space: 2352491
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1267
Last_SQL_Error: Error 'Illegal mix of collations (latin1_swedish_
ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='' on query. Defaul
t database: 'lager'. Query: 'UPDATE `lager`.`materialpostings` SET `fSAVESTATUS`
='1' WHERE `strJOB`='Rehberger K-Põdag 31 07' AND `nPARTIALRESULT`='0' AND `strM
AT`='FUN0412PO19' AND `fTYPE`='0' AND `nTYP`='1' AND `strNR`='1' AND `fSAVESTATU
S`='0''


Slave-Logs:
C:\>mysqlbinlog --hexdump --short-form c:\mysql\data\SRV-PLATTENLAG-relay-bin.00
0069

UPDATE `lager`.`materialpostings` SET `fSAVESTATUS`='1' WHERE `strJOB`='Rehberge
r K-Põdag 31 07' AND `nPARTIALRESULT`='0' AND `strMAT`='FUN0412PO19' AND `fTYPE`
='0' AND `nTYP`='1' AND `strNR`='1' AND `fSAVESTATUS`='0'
/*!*/;
# at 1495
#140807 10:29:37 server id 1 end_log_pos 4698
# Position Timestamp Type Master ID Size Master Pos Flags
# 5d7 f1 38 e3 53 02 01 00 00 00 19 01 00 00 5a 12 00 00 00 00
# 5ea 28 00 00 00 00 00 00 00 05 00 00 1a 00 00 00 00 |................|
# 5fa 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
# 60a 04 21 00 21 00 08 00 6c 61 67 65 72 00 55 50 44 |.......lager.UPD|
# 61a 41 54 45 20 60 6c 61 67 65 72 60 2e 60 6d 61 74 |ATE..lager...mat|
# 62a 65 72 69 61 6c 70 6f 73 74 69 6e 67 73 60 20 53 |erialpostings..S|
# 63a 45 54 20 60 66 53 41 56 45 53 54 41 54 55 53 60 |ET..fSAVESTATUS.|
# 64a 3d 27 30 27 20 57 48 45 52 45 20 60 73 74 72 4a |..0..WHERE..strJ|
# 65a 4f 42 60 3d 27 52 65 68 62 65 72 67 65 72 20 4b |OB...Rehberger.K|
# 66a 2d 50 e4 64 61 67 20 33 31 20 30 37 27 20 41 4e |.P.dag.31.07..AN|
# 67a 44 20 60 6e 50 41 52 54 49 41 4c 52 45 53 55 4c |D..nPARTIALRESUL|
# 68a 54 60 3d 27 30 27 20 41 4e 44 20 60 73 74 72 4d |T...0..AND..strM|
# 69a 41 54 60 3d 27 46 55 4e 30 34 31 32 50 4f 31 39 |AT...FUN0412PO19|
# 6aa 27 20 41 4e 44 20 60 66 54 59 50 45 60 3d 27 30 |..AND..fTYPE...0|
# 6ba 27 20 41 4e 44 20 60 6e 54 59 50 60 3d 27 31 27 |..AND..nTYP...1.|
# 6ca 20 41 4e 44 20 60 73 74 72 4e 52 60 3d 27 31 27 |.AND..strNR...1.|
# 6da 20 41 4e 44 20 60 66 53 41 56 45 53 54 41 54 55 |.AND..fSAVESTATU|
# 6ea 53 60 3d 27 31 27 |S...1.|
# Query thread_id=40 exec_time=0 error_code=0
SET TIMESTAMP=1407400177/*!*/;
UPDATE `lager`.`materialpostings` SET `fSAVESTATUS`='0' WHERE `strJOB`='Rehberge
r K-Põdag 31 07' AND `nPARTIALRESULT`='0' AND `strMAT`='FUN0412PO19' AND `fTYPE`
='0' AND `nTYP`='1' AND `strNR`='1' AND `fSAVESTATUS`='1'
/*!*/;
# at 1776
#140807 10:29:37 server id 1 end_log_pos 4856
# Position Timestamp Type Master ID Size Master Pos Flags
# 6f0 f1 38 e3 53 02 01 00 00 00 9e 00 00 00 f8 12 00 00 00 00
# 703 28 00 00 00 00 00 00 00 05 00 00 1a 00 00 00 00 |................|
# 713 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
# 723 04 21 00 21 00 08 00 6c 61 67 65 72 00 44 45 4c |.......lager.DEL|
# 733 45 54 45 20 46 52 4f 4d 20 6d 61 74 65 72 69 61 |ETE.FROM.materia|
# 743 6c 70 6f 73 74 69 6e 67 73 20 57 48 45 52 45 20 |lpostings.WHERE.|
# 753 28 28 73 74 72 4d 41 54 3d 27 46 55 4e 30 34 31 |..strMAT..FUN041|
# 763 32 50 4f 31 39 27 29 20 41 4e 44 20 28 66 54 59 |2PO19...AND..fTY|
# 773 50 45 3d 30 29 20 41 4e 44 20 28 66 53 41 56 45 |PE.0..AND..fSAVE|
# 783 53 54 41 54 55 53 3c 3e 30 29 29 |STATUS..0..|
# Query thread_id=40 exec_time=0 error_code=0
SET TIMESTAMP=1407400177/*!*/;




Master-Logs:
C:\>mysqlbinlog --read-from-remote-server --host=192.168.21.24 --user=root --pas
sword --hexdump PC-SD-PL-04-bin.000013 > c:\users\admin\mlog.txt

UPDATE `lager`.`materialpostings` SET `fSAVESTATUS`='1' WHERE `strJOB`='Rehberger K-Pädag 31 07' AND `nPARTIALRESULT`='0' AND `strMAT`='FUN0412PO19' AND `fTYPE`='0' AND `nTYP`='1' AND `strNR`='1' AND `fSAVESTATUS`='0'
/*!*/;
# at 4417
#140807 10:29:37 server id 1 end_log_pos 4698
# Position Timestamp Type Master ID Size Master Pos Flags
# 1141 f1 38 e3 53 02 01 00 00 00 19 01 00 00 5a 12 00 00 00 00
# 1154 28 00 00 00 00 00 00 00 05 00 00 1a 00 00 00 00 |................|
# 1164 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
# 1174 04 21 00 21 00 08 00 6c 61 67 65 72 00 55 50 44 |.......lager.UPD|
# 1184 41 54 45 20 60 6c 61 67 65 72 60 2e 60 6d 61 74 |ATE..lager...mat|
# 1194 65 72 69 61 6c 70 6f 73 74 69 6e 67 73 60 20 53 |erialpostings..S|
# 11a4 45 54 20 60 66 53 41 56 45 53 54 41 54 55 53 60 |ET..fSAVESTATUS.|
# 11b4 3d 27 30 27 20 57 48 45 52 45 20 60 73 74 72 4a |..0..WHERE..strJ|
# 11c4 4f 42 60 3d 27 52 65 68 62 65 72 67 65 72 20 4b |OB...Rehberger.K|
# 11d4 2d 50 e4 64 61 67 20 33 31 20 30 37 27 20 41 4e |.P.dag.31.07..AN|
# 11e4 44 20 60 6e 50 41 52 54 49 41 4c 52 45 53 55 4c |D..nPARTIALRESUL|
# 11f4 54 60 3d 27 30 27 20 41 4e 44 20 60 73 74 72 4d |T...0..AND..strM|
# 1204 41 54 60 3d 27 46 55 4e 30 34 31 32 50 4f 31 39 |AT...FUN0412PO19|
# 1214 27 20 41 4e 44 20 60 66 54 59 50 45 60 3d 27 30 |..AND..fTYPE...0|
# 1224 27 20 41 4e 44 20 60 6e 54 59 50 60 3d 27 31 27 |..AND..nTYP...1.|
# 1234 20 41 4e 44 20 60 73 74 72 4e 52 60 3d 27 31 27 |.AND..strNR...1.|
# 1244 20 41 4e 44 20 60 66 53 41 56 45 53 54 41 54 55 |.AND..fSAVESTATU|
# 1254 53 60 3d 27 31 27 |S...1.|
# Query thread_id=40 exec_time=0 error_code=0
SET TIMESTAMP=1407400177/*!*/;
UPDATE `lager`.`materialpostings` SET `fSAVESTATUS`='0' WHERE `strJOB`='Rehberger K-Pädag 31 07' AND `nPARTIALRESULT`='0' AND `strMAT`='FUN0412PO19' AND `fTYPE`='0' AND `nTYP`='1' AND `strNR`='1' AND `fSAVESTATUS`='1'
/*!*/;
# at 4698
#140807 10:29:37 server id 1 end_log_pos 4856
# Position Timestamp Type Master ID Size Master Pos Flags
# 125a f1 38 e3 53 02 01 00 00 00 9e 00 00 00 f8 12 00 00 00 00
# 126d 28 00 00 00 00 00 00 00 05 00 00 1a 00 00 00 00 |................|
# 127d 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
# 128d 04 21 00 21 00 08 00 6c 61 67 65 72 00 44 45 4c |.......lager.DEL|
# 129d 45 54 45 20 46 52 4f 4d 20 6d 61 74 65 72 69 61 |ETE.FROM.materia|
# 12ad 6c 70 6f 73 74 69 6e 67 73 20 57 48 45 52 45 20 |lpostings.WHERE.|
# 12bd 28 28 73 74 72 4d 41 54 3d 27 46 55 4e 30 34 31 |..strMAT..FUN041|
# 12cd 32 50 4f 31 39 27 29 20 41 4e 44 20 28 66 54 59 |2PO19...AND..fTY|
# 12dd 50 45 3d 30 29 20 41 4e 44 20 28 66 53 41 56 45 |PE.0..AND..fSAVE|
# 12ed 53 54 41 54 55 53 3c 3e 30 29 29 |STATUS..0..|
# Query thread_id=40 exec_time=0 error_code=0
SET TIMESTAMP=1407400177/*!*/;