Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.
For bugs related to Red Hat Enterprise Linux 5 product line. The current stable release is 5.10. For Red Hat Enterprise Linux 6 and above, please visit Red Hat JIRA https://issues.redhat.com/secure/CreateIssue!default.jspa?pid=12332745 to report new issues.

Bug 518326

Summary: Replication: default location for relay logs is not persistent across reboots
Product: Red Hat Enterprise Linux 5 Reporter: Charles Gillet <charles>
Component: mysqlAssignee: Tom Lane <tgl>
Status: CLOSED DUPLICATE QA Contact: BaseOS QE <qe-baseos-auto>
Severity: medium Docs Contact:
Priority: low    
Version: 5.5CC: byte, hhorak
Target Milestone: rc   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-08-19 22:23:21 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Charles Gillet 2009-08-19 20:56:21 UTC
Description of problem: 

After turning on slave replication on a system, the slave creates critical relay log files in /var/run/mysqld by default, and that directory is blown away at boot time.

Version-Release number of selected component (if applicable):
mysql-server-5.0.45-7.el5


How reproducible: Easy


Steps to Reproduce:
1. Configure mysql server as a master in master/slave replication setup and add replication permissions for a DB user
2. On second slave server, add server-id setting in /etc/my.cnf (documented well) but do not add relay-log setting (which is only mentioned as optional in /var/log/mysqld.log to survive a hostname change)  
3. follow mysql docs for using "change master to" command and then "start slave"
  
Actual results:
Slave replication will work until the system is rebooted

Expected results:
Slave system should not lose its relay logs and should continue to replicate data

Additional info:
Recommendations: change default location of relay-log setting when you build mysql-server, or document in /etc/my.conf comments section that relay-log location needs to be set to a persistent directory, like /var/lib/mysql, because /var/run/mysqld is the default place mysqld uses and is not persistent.

Comment 1 Tom Lane 2009-08-19 21:15:18 UTC
I think this is a duplicate of bug #448534, which is already fixed for RHEL 5.4.  Please see if you agree ...

Comment 2 Charles Gillet 2009-08-19 21:25:12 UTC
Agreed. I thought I searched for "replication" through all mysql bugs.  Oh well.  Thanks!

Comment 3 Tom Lane 2009-08-19 22:23:21 UTC

*** This bug has been marked as a duplicate of bug 448534 ***