Replication problems (server_errno=1236)

2003-06-03 Thread Calvin Hill
Hello, I'm running MySQL Ver 12.18 Distrib 4.0.12 I had replication set up and working perfectly between two machines in a round robin fashion. (Serv 1 updates Serv 2 and Serv 2 updates Serv 1.) Recently serv 2 locked up, upon restarting, it automatically began to update with the files

Re: Replication problems (server_errno=1236)

2003-06-03 Thread Nils Valentin
Hi Calvin, I am not sure which table format you use, but somehow I assume you use innodb. If I remember correctly than Innodb will need all log files. If only one is missing than thats it, you get the error described. - anybody please correct me if I talk rubbish here Best regards Nils

Re: Replication problems (server_errno=1236)

2003-06-03 Thread Calvin Hill
Nils, I agree with you, you do have to have all the log files, which is why I reset the master. According to the manual: 4.10.7.5 RESET MASTER (master) Deletes all binary logs listed in the index file, resetting the binlog index file to be empty. Previously