MySQL Problem
- From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Sep 2008 09:42:53 -0500
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@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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
