>   frank> No, the process mysqldump is not there. The database is not that
big so I
>   frank> assume it will finish fast.
> 
> Or maybe it got an error?  Can you redirect stderr to a file to see?
> 

No error, the file stays empty.

> If nothing, then you can try setting the debug level in the FD to 400 to
see whether it is reading anything at all.
> 

I can set the debug level to 400 for the client, but don't know where to
look for the debug output. Logfile does not look any different when I change
the debug level.

> __Martin

I found something interesting: when I do a cat on the fifo, the database
starts roling over my terminal. That means that the mysqldump process works.
After cat finishes, bacula will actually start writing to the "tape":

Volume "TestVolume000" previously written, moving to end of data.

I tried this a couple of times, most of the time it does not write any data
to the tape however one time it wrote a part of the data to the tape:

Terminated Jobs:
 JobId  Level     Files      Bytes     Status   Finished        Name
========================================================================
    77  Full          1              0 OK       29-Oct-05 00:52
MyDatabaseFull
    78  Full          1         81,277 OK       29-Oct-05 00:54
MyDatabaseFull

regards
Frank


-----Original Message-----
From: Martin Simmons [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 28, 2005 11:37 PM
To: [EMAIL PROTECTED]
Cc: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] mysqldump using fifo

>>>>> On Fri, 28 Oct 2005 22:45:17 +0700, "frank" <[EMAIL PROTECTED]> said:

  frank> Martin Simmons wrote:
  frank> Martin Simmons wrote:
  >> >> Is the mysqldump process still there when the job is hanging?
  >> >>
  >>
  frank> Yes, the process is there:
  >>
  frank> ps -ef |grep MyDatabase
  frank> root     27088 32601  0 19:32 ?        00:00:00 [MyDatabase]
  frank> <defunct>
  frank> root     27091     1  0 19:32 ?        00:00:00 /bin/sh
  frank> /backup/scripts/MyDatabase before
  >>
  >> What about the mysqldump process (not just the script)?
  >> 
  
  frank> No, the process mysqldump is not there. The database is not that
big so I
  frank> assume it will finish fast.

Or maybe it got an error?  Can you redirect stderr to a file to see?

If nothing, then you can try setting the debug level in the FD to 400 to see
whether it is reading anything at all.

__Martin



-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
Free Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to