| Bug #15670 | Replication | ||
|---|---|---|---|
| Submitted: | 11 Dec 2005 20:17 | Modified: | 23 Dec 2005 14:19 |
| Reporter: | benhamou ariel | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 5.0.16 | OS: | Windows (windows 2003 server) |
| Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[11 Dec 2005 20:29]
MySQL Verification Team
Sorry I didn't ubderstand very well what are you reporting. Please provide the slave and master setup (my.ini files) and a sample of table on master and the queries that the slave can't update. Thanks in advance.
[14 Dec 2005 10:53]
benhamou ariel
Fichier my.ini du serveur
Attachment: my.ini (application/octet-stream, text), 1.13 KiB.
[14 Dec 2005 10:54]
benhamou ariel
Fichier my.ini du slave
Attachment: my.ini (application/octet-stream, text), 946 bytes.
[14 Dec 2005 12:40]
benhamou ariel
all the requetes to send to the slave is taken into account. It are put on the files of log but are not carried out
[23 Dec 2005 13:52]
MySQL Verification Team
While setting your master/slave configuration files (my.ini) I noticed that you are using the 3306 port for both. I assume that master and slave are installed on different machines, that is correct? Thanks in advance.
[23 Dec 2005 14:00]
benhamou ariel
Indeed. The two basic engines of data are sure 2 different waiters
[23 Dec 2005 14:19]
MySQL Verification Team
I was unable to repeat, I edited your configuration files for my environment
install and the slave is updated:
E:\master\bin>mysql --defaults-file=e:\master\my.ini -uroot --prompt="master>"
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.17-nt-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
master>grant all on *.* to "slaveuser"@"localhost" identified by "slaveuser";
Query OK, 0 rows affected (0.14 sec)
master>show master status\G
*************************** 1. row ***************************
File: sc002-bin.000001
Position: 98
Binlog_Do_DB:
Binlog_Ignore_DB: mysql
1 row in set (0.01 sec)
E:\slave\bin>mysql --defaults-file=e:\slave\smy.ini -uroot --prompt="slave>"
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.17-nt-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
slave>CHANGE MASTER TO
-> MASTER_HOST='localhost',
-> MASTER_USER='slaveuser',
-> MASTER_PASSWORD='slaveuser',
-> MASTER_LOG_FILE='sc002-bin.000001',
-> MASTER_LOG_POS=98;
Query OK, 0 rows affected (0.23 sec)
slave>start slave;
Query OK, 0 rows affected (0.00 sec)
slave>show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: localhost
Master_User: slaveuser
Master_Port: 3306
Connect_Retry: 98
Master_Log_File: sc002-bin.000001
Read_Master_Log_Pos: 98
Relay_Log_File: sc004-relay-bin.000002
Relay_Log_Pos: 235
Relay_Master_Log_File: sc002-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: 98
Relay_Log_Space: 235
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
1 row in set (0.03 sec)
slave>show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.09 sec)
slave>
master>create database slavetest;
Query OK, 1 row affected (0.02 sec)
master>use slavetest
Database changed
master>create table tb1 (id int not null, nombre char(20));
Query OK, 0 rows affected (0.06 sec)
master>insert into tb1 values (1,"maria");
Query OK, 1 row affected (0.00 sec)
master>insert into tb1 values (2,"josefina");
Query OK, 1 row affected (0.00 sec)
master>
slave>show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| slavetest |
| test |
+--------------------+
4 rows in set (0.00 sec)
slave>use slavetest
Database changed
slave>select * from tb1;
+----+----------+
| id | nombre |
+----+----------+
| 1 | maria |
| 2 | josefina |
+----+----------+
2 rows in set (0.00 sec)
slave>show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: localhost
Master_User: slaveuser
Master_Port: 3306
Connect_Retry: 98
Master_Log_File: sc002-bin.000001
Read_Master_Log_Pos: 517
Relay_Log_File: sc004-relay-bin.000002
Relay_Log_Pos: 654
Relay_Master_Log_File: sc002-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: 517
Relay_Log_Space: 654
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
1 row in set (0.00 sec)
slave>
Description: Probléme of replication. The replication is well taken into account on the level of the escave in its file of log but, there is no éxécution in the data base. The fields are not updated. Name of the server : SC002 : master SC004 : slave sc002-bin.000001: þbinï„œC ^ b 5.0.16-pro-nt-log ï„œC8 K ‚…œC Ž ð @ P std remuneration update lignes set mont_sticker=5000 where num_sim='8933209805124939773'Ä…œC Ž ~ @ P std remuneration update lignes set mont_sticker=4000 where num_sim='8933209805124939773' sc004-bin.000001: þbin"…œC ^ b 5.0.16-pro-nt-log "…œC8 K sc004-relay-bin.000002: þbin"…œC ^ b 5.0.16-pro-nt-log 8 K + sc002-bin.000001ï„œC ^ b 5.0.16-pro-nt-log ï„œC8 K ‚…œC Ž ð @ P std remuneration update lignes set mont_sticker=5000 where num_sim='8933209805124939773'Ä…œC Ž ~ @ P std remuneration update lignes set mont_sticker=4000 where num_sim='8933209805124939773' show master status : File Position Binlog_Do_DB Binlog_Ignore_DB sc002-bin.000001 382 remuneration show slave status : Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Waiting for master to send event 192.168.1.6 repl 3306 98 sc002-bin.000001 382 sc004-relay-bin.000002 519 sc002-bin.000001 Yes Yes 0 0 382 519 None 0 No 0 How to repeat: To put 2 servers in replication and to make an update of fields. On the slave the update is not to make