[Bug 358652] Re: Error during mysql slave replication

Mariusz Kielpinski kielpi at poczta.onet.pl
Fri Apr 10 13:04:08 BST 2009

Ok I did some additional tests and there is a time to give some result:

First of all I am doing a master-master replication. On Ubuntu 8.04 my
configuration works for months so I rather expect an error on Ubuntu
9.04 site. The problem is the configuration is almost the same (exludind
server-id of cource). In addition I say I used new my.cnf file delivered
with new version of mysql server in 9.04.

My changes are:

# bind-address          =
# * Logging and Replication                                          
# Both location gets rotated by the cronjob.                         
# Be aware that this log type is a performance killer.               
log             = /var/log/mysql/mysql.log                           
# Error logging goes to syslog. This is a Debian improvement :)      
# Here you can see queries with especially long duration             
#log_slow_queries       = /var/log/mysql/mysql-slow.log              
#long_query_time = 2                                                 
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about   
#       other settings you may need to change.                               
server-id               = 1                                                  
log_bin                 = /var/log/mysql/mysql-bin.log                       
expire_logs_days        = 10                                                 
max_binlog_size         = 100M                                               
#binlog_ignore_db       = include_database_name                              
binlog_do_db            = .......                                           
binlog_do_db            = .......                                              


auto_increment_increment = 2
auto_increment_offset = 1   
slave-skip-errors = 1062    

Secondly after reboot 
In /var/lib/mysql/

cat relay-log.info


ls mysqld-relay-*
mysqld-relay-bin.000006 mysqld-relay-bin.000007  mysqld-relay-bin.index

So there is a inconsistency. 

info in relay-log.info and files are consistent.

Error during mysql slave replication
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

More information about the Ubuntu-server-bugs mailing list