[mylvmbackup] Re: File Descriptors Left Open

On Mon, 9 Feb 2009 10:05:04 -0600 "Boehm, Matthew" <mboehm@xxxxxxxxxxxxx> wrote:
[...]
> One thing that bothers me is that we see this "error":
> 
> File descriptor 3 left open
> 
> What I can only guess this comes from is the InnoDB datafile or log
> files because InnoDB doesn't actually do the flushing like MyISAM does.
> 
> Is there any way to have InnoDB properly close/let go of its open files
> before doing the snapshot?

this message is _completely_ unrelated to anything mysql...

it's printed by the lvm program,
which on startup does a loop over all fds it does not use, closes them, and 
prints
that warning if any were actually open.
(actually nothing unusual at all for any program, but from what i gather that 
is a
 precaution against deadlocks being caused by lvm freezing a filesystem while it
 itself holds a handle for a file on that filesystem.)

these warnings are harmless, and can be surpressed by setting the environment
variable LVM_SUPPRESS_FD_WARNINGS=1

> -Matthew

Greetings,
 Thorben Thuermer

Other related posts: