Re: [CentOS] Problems with mysql multi-master after update.
On 2/10/2009 10:28 PM, J Potter wrote: For what it's worth, I haven't seen this on any systems I manage when going from 5.0.22-5.0.45, which include permutations of master-slave and master-master. Is there anything useful in /var/log/mysqld.log? Just that I cant't read the incremental that does exist anymore. []s. after I updated from mysql-5.0.22 CentOS 5.0 to mysqld-5.0.45 in CentOS 5.2, mysql looses master-slave sync after one node reboots. I've noticed that the slave doest not respect the informantion on master.info, instead, it tries to read the informantion from the master server file inc-index.index ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Problems with mysql multi-master after update.
On 2/11/2009 12:46 AM, Jim Perrin wrote: On Mon, Feb 9, 2009 at 7:33 AM, Alessandro Ren alessandro@opservices.com.br wrote: e incremental.01 on the master and this causes the problem. In 5.0.22 this would not happen, this does not happen as I have servers running this version and after the reboot, it starts syncing on the right incremental. Any idea? While I haven't seen this going from 0.22 to 0.45, did you run mysql_upgrade following your upgrade? Last I had this issue my table structure wasn't quite what the server was expecting, and running mysql_upgrade was the solution. I tried it , but it did't help. I just rebooted one of the nodes and I am getting this error in the logs. 090211 9:07:41 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.12' (relay_log_pos 358860475) 090211 9:07:41 [ERROR] Could not find target log during relay log initialization 090211 9:07:41 [ERROR] Failed to initialize the master info structure 090211 9:07:41 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution Afeter deleting master.info and relay-log.ingo I get the incremental error: 090211 9:23:23 [ERROR] Error reading packet from server: File './incremental.03' not found (Errcode: 2) ( server_errno=29) 090211 9:23:23 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 090211 9:23:23 [Note] Slave: connected to master 'r...@192.168.10.207:3306',replication resumed in log 'FIRST' at position 4 090211 9:23:23 [ERROR] Error reading packet from server: File './incremental.03' not found (Errcode: 2) ( server_errno=29) After fixing de inc-index on the master en restarting, abd restarting the slave, it workis fine: Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 090211 9:26:14 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/run/mysqld/mysqld-relay-bin.05' position: 98 090211 9:26:14 [Note] Slave I/O thread: connected to master 'r...@192.168.10.207:3306', replication started in log 'FIRST' at position 4 Any tips? On 5.0.22 I never had this problem. Tks. ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Problems with mysql multi-master after update.
For what it's worth, I haven't seen this on any systems I manage when going from 5.0.22-5.0.45, which include permutations of master-slave and master-master. Is there anything useful in /var/log/mysqld.log? after I updated from mysql-5.0.22 CentOS 5.0 to mysqld-5.0.45 in CentOS 5.2, mysql looses master-slave sync after one node reboots. I've noticed that the slave doest not respect the informantion on master.info, instead, it tries to read the informantion from the master server file inc-index.index ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Problems with mysql multi-master after update.
On Mon, Feb 9, 2009 at 7:33 AM, Alessandro Ren alessandro@opservices.com.br wrote: e incremental.01 on the master and this causes the problem. In 5.0.22 this would not happen, this does not happen as I have servers running this version and after the reboot, it starts syncing on the right incremental. Any idea? While I haven't seen this going from 0.22 to 0.45, did you run mysql_upgrade following your upgrade? Last I had this issue my table structure wasn't quite what the server was expecting, and running mysql_upgrade was the solution. -- During times of universal deceit, telling the truth becomes a revolutionary act. George Orwell ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
[CentOS] Problems with mysql multi-master after update.
Hello, after I updated from mysql-5.0.22 CentOS 5.0 to mysqld-5.0.45 in CentOS 5.2, mysql looses master-slave sync after one node reboots. I've noticed that the slave doest not respect the informantion on master.info, instead, it tries to read the informantion from the master server file inc-index.index. Let me give a example, the master is alredy on incremental.06 and the slave in synced, the master.info in the slave server is showing is is reading de incremental.06, but in the master inc-index.index all 6 files are listed, from 1 to 6. The file 1 to 5 were already deleted in a cleaning process as thay were alread synced with the slave. After the reboot, the slave tries to find the file incremental.01 on the master and this causes the problem. In 5.0.22 this would not happen, this does not happen as I have servers running this version and after the reboot, it starts syncing on the right incremental. Any idea? Tks. ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos