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] <defunct> > frank> root 27091 1 0 19:32 ? 00:00:00 /bin/sh /backup/scripts/MyDatabase before > > What about the mysqldump process (not just the script)? > No, the process mysqldump is not there. The database is not that big so I assume it will finish fast.
> > Can you use lsof to see what files the fd has open? > # /usr/sbin/lsof |grep bacula-fd COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME bacula-fd 32601 root cwd DIR 104,5 4096 15859718 /etc/bacula bacula-fd 32601 root rtd DIR 104,5 4096 2 / bacula-fd 32601 root txt REG 104,5 302821 21604890 /usr/sbin/bacula-fd bacula-fd 32601 root mem REG 104,5 46552 23396404 /lib/libnss_files-2.3.5.so bacula-fd 32601 root mem REG 0,0 0 [vdso] (stat: No such file or directory) bacula-fd 32601 root mem REG 104,5 126564 23396445 /lib/ld-2.3.5.so bacula-fd 32601 root mem REG 104,5 1485672 23397398 /lib/libc-2.3.5.so bacula-fd 32601 root mem REG 104,5 201040 23397415 /lib/libm-2.3.5.so bacula-fd 32601 root mem REG 104,5 75568 21605789 /usr/lib/libz.so.1.2.2.2 bacula-fd 32601 root mem REG 104,5 101600 23397410 /lib/libpthread-2.3.5.so bacula-fd 32601 root mem REG 104,5 40112 23397417 /lib/libgcc_s-4.0.1-20050727.so.1 bacula-fd 32601 root mem REG 104,5 935092 21600657 /usr/lib/libstdc++.so.6.0.5 bacula-fd 32601 root mem REG 104,5 49623648 21605785 /usr/lib/locale/locale-archive bacula-fd 32601 root 0u CHR 136,5 7 /dev/pts/5 (deleted) bacula-fd 32601 root 1u CHR 136,5 7 /dev/pts/5 (deleted) bacula-fd 32601 root 2u CHR 136,5 7 /dev/pts/5 (deleted) bacula-fd 32601 root 3u IPv4 7220227 TCP host.domain.com:9102 (LISTEN) bacula-fd 32601 root 4u IPv4 9040646 TCP host.domain.com:9102->host.domain.com:38645 (ESTABLISHED) bacula-fd 32601 root 5u IPv4 9040647 TCP host.domain.com:39409->host.domain.com:9103 (ESTABLISHED) bacula-fd 32601 root 6r FIFO 0,6 9040649 pipe regards Frank -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Simmons Sent: Friday, October 28, 2005 9:39 PM To: [EMAIL PROTECTED] Cc: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] mysqldump using fifo >>>>> On Fri, 28 Oct 2005 18:51:18 +0700, "frank" <[EMAIL PROTECTED]> said: frank> So far no luck. frank> Kern Sibbald wrote: >> In addition, I don't see any need to redirect /dev/null to the input for rm, mkfifo, and mysqldump. It probably won't hurt anything, but it just complicates understanding what is really going on. A cleaner script would >> be: >> frank> Changed the script as indicated. The job is still hanging... 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] <defunct> frank> root 27091 1 0 19:32 ? 00:00:00 /bin/sh /backup/scripts/MyDatabase before What about the mysqldump process (not just the script)? frank> Status of the FD: frank> Running Jobs: frank> JobId 65 Job MyDatabaseFull.2005-10-28_19.32.05 is running. frank> Unknown Type Job started: 28-Oct-05 19:32 frank> Files=0 Bytes=0 Bytes/sec=0 frank> Files Examined=0 frank> SDReadSeqNo=3 fd=5 frank> Director connected at: 28-Oct-05 19:35 Can you use lsof to see what files the fd has open? __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
