Cant reproduce Problem in Lab
Hi again!
I did set up a Win7 VM and copy the original mysql master dir to c:\mysql (as it is in the original master). chcp Shows Codepage 850 - as in the original. I made a second instance from scratch in c:\mysql-s on port 3307 and started replication. Works fine. Then i tried to insert some "Problem"-querys from the replication Errors, which run without error on the master.
The Problem is, that i dont get any error on the slave as well. I tried to Change the umlauts in the querys back to the original (so "K-F³rstaller" back to "K-Fürstaller". But same result - it runs fine and no replication error on slave.
Seems the Application does the querys somehow different. Do you have any idea how i could reproduce the error in the lab?
Master:
mysql> UPDATE `lager`.`materialpostings` SET `fSAVESTATUS`='0' WHERE `strJOB`='W
eibold K-Sch÷nauer 26.06.' AND `nPARTIALRESULT`='0' AND `strMAT`='KRO514PE19' AN
D `fTYPE`='0' AND `nTYP`='1' AND `strNR`='2' AND `fSAVESTATUS`='1'
-> ;
Query OK, 0 rows affected (0.04 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql> INSERT INTO `lager`.`materialpostings` (`strJOB`,`nPARTIALRESULT`,`strMAT
`,`fTYPE`,`nTYP`,`strNR`,`nLENGTH`,`nWIDTH`,`nCOUNT`,`strTYPENR`,`fSAVESTATUS`)
VALUES ('Steiner K-F³rstaller 04.08.','0','EGW980ST228','0','1','1','2.800000000
00000000e+003','2.07000000000000000e+003','2','454','0');
Query OK, 1 row affected (0.02 sec)
mysql> UPDATE `lager`.`materialpostings` SET `fSAVESTATUS`='0' WHERE `strJOB`='W
eibold K-Schönauer 26.06.' AND `nPARTIALRESULT`='0' AND `strMAT`='KRO514PE19' AN
D `fTYPE`='0' AND `nTYP`='1' AND `strNR`='2' AND `fSAVESTATUS`='1';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Slave:
mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: localhost
Master_User: slave_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-PC-bin.000001
Read_Master_Log_Pos: 1591
Relay_Log_File: mysql-PC-relay-bin.000002
Relay_Log_Pos: 1739
Relay_Master_Log_File: mysql-PC-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 1591
Relay_Log_Space: 1897
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: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)