Permissions issue and wrong error message

Bug #832298 reported by Shawn Usry on 2011-08-23
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Alex Yurchenko

Bug Description

This is moreso a bug with error messaging - or at least - needs a bit of cleanup, or at least a look at permissions during state transfers.

Set up a 2 node environment. Configured to use the newer rsync_wan for joiner resync. For testing, I brought down the 2nd node, then back up again. Cluster correctly identified that that the joining node needed a state transfer. Transfer proceeded, but then near the end I received an error message from the SENDING side that the receiving side had "too many open files" - a typical problem - but upping the limit on BOTH sender and receiver did not resolve the issue.

It turned out the issue was due to the fact that the file "RPM_UPGRADE_HISTORY", in /var/lib/mysql, had root:root permissions, and could not be overwritten. Changing permissions to mysql:mysql resulted in the state transfer completing on the next run.

I'm not sure how the original file permissions were set. The RPM's were originally installed as root however.

Related branches

Shawn Usry (shawn-h) on 2011-08-23
description: updated
Alex Yurchenko (ayurchen) wrote :

Changed rsync filter to exclude all files by default (r3120)

Changed in codership-mysql:
assignee: nobody → Alex Yurchenko (ayurchen)
importance: Undecided → Medium
milestone: none → 0.8.2
status: New → Fix Committed
Changed in codership-mysql:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers