MySQL Problem

From: Newman, Christopher <cjnewman_at_uillinois.edu>
Date: Wed, 24 Sep 2008 09:42:53 -0500
Message-ID: <565F609E6D736D439837F1A1A797F34101C6ECE7@ADMINMAIL1.ui.uillinois.edu>


Hi Folks,

Sorry to post a MySQL issue, but we're in a bad spot having to support it and we don't have much expertise in house. If anyone can help me just contact me directly via email or phone.

We are using master-master replication, and we have a disconnect; both masters contain different information. We're at a loss as to how to resync them, and we really don't want to lose any of the data in either of them.

The mysqld.log from one shows the following, with the other server's log being similar. Everything worked fine until we had to reboot one of the servers, then replication seemed to be broken.

080924 09:12:29 mysqld started
080924 9:12:29 [Warning] The syntax for replication startup options is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
080924 9:12:30 InnoDB: Started; log sequence number 0 43655 080924 9:12:30 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use
'--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem.
080924 9:12:30 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
080924 9:12:30 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000019' at position 196, relay log
'/var/run/mysqld/mysqld-relay-bin.000031' position: 333
080924 9:12:30 [Note] Slave I/O thread: connected to master
'repl_at_myserver1:3306', replication started in log 'mysql-bin.000019' at
position 196
080924 9:27:43 [Note] Slave I/O thread killed while reading event 080924 9:27:43 [Note] Slave I/O thread exiting, read up to log
'mysql-bin.000020', position 98

080924 9:27:43 [Note] Error reading relay log event: slave SQL thread was killed
080924 9:27:48 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log
'/var/run/mysqld/mysqld-relay-bin.000001' position: 4
080924 9:27:48 [Note] Slave I/O thread: connected to master
'repl_at_myserver1:3306', replication started in log 'FIRST' at position 4
080924 9:27:48 [ERROR] Slave: Error 'Table 'test.test' doesn't exist' on query. Default database: 'test'. Query: 'insert into test values (2343)', Error_code: 1146
080924 9:27:48 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000019' position 98

Again, apologies for using the oracle-l, but we're in quite a pinch. Thanks in advance - Chris

Chris Newman
Database Specialist
AITS, University of Illinois
217-333-5429

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 24 2008 - 09:42:53 CDT

Original text of this message