Hi Michael
When the job is like this: (status dir)
Running Jobs: JobId Level Name
Status======================================================================
28817 Increme BoingBackup.2007-10-31_23.58.42 is in unknown state i
and client say:
*status client=boing-fdConnecting to Client boing-fd at boing.sequans.com:9102
boing-fd Version: 2.2.5 (09 October 2007) i686-pc-linux-gnu debian 3.1Daemon
started 29-Oct-07 15:24, 3 Jobs run since started. Heap: heap=622,592
smbytes=8,394 max_bytes=262,048 bufs=51 max_bufs=224 Sizeof: boffset_t=8
size_t=4 debug=1 trace=0
Running Jobs:Director connected at: 01-Nov-07 12:26No Jobs running.====
Terminated Jobs: JobId Level Files Bytes Status Finished
Name======================================================================
28259 Incr 929 105.7 M OK 17-Oct-07 06:08 BoingBackup 28310
Incr 699 120.3 M OK 18-Oct-07 06:19 BoingBackup 28355 Incr
89 105.7 M OK 19-Oct-07 05:53 BoingBackup 28456 Incr 1,005
192.5 M OK 23-Oct-07 08:29 BoingBackup 28501 Incr 88
110.2 M OK 24-Oct-07 06:38 BoingBackup 28546 Incr 1,400 127.4 M
OK 25-Oct-07 06:30 BoingBackup 28591 Incr 232 119.5 M OK
26-Oct-07 10:43 BoingBackup 28673 Full 182,369 1.477 G OK
29-Oct-07 16:04 BoingBackup 28723 Incr 571 209.3 M OK
30-Oct-07 10:37 BoingBackup 28817 Incr 135,776 443.7 M OK
01-Nov-07 08:21 BoingBackup
show process list show:
mysql> show
processlist;+-----+--------+-----------+--------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+|
Id | User | Host | db | Command | Time | State | Info
|+-----+--------+-----------+--------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+|
234 | bacula | localhost | bacula | Sleep | 164 | | NULL
|| 267 | bacula | localhost | bacula | Query | 14398 | Sending
data | INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat,
MD5)SELECT batch.FileIndex, batch.Job || 268 | root | localhost | NULL |
Query | 0 | NULL | show processlist
|+-----+--------+-----------+--------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+3
rows in set (0.00 sec)and top:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND15166 mysql
18 0 124m 32m 5032 S 99.9 12.6 310:57.49 mysqldmaybe my server isn't
powerful enough ?
Lise
> Date: Tue, 30 Oct 2007 23:17:38 +0200> From: [EMAIL PROTECTED]> To: [EMAIL
> PROTECTED]> Subject: Re: [Bacula-users] bacula 2.2.5: some job never finish>
> CC: bacula-users@lists.sourceforge.net> > Hi Lise,> > If this is a recurrent
> problem, there may be a problem with the query,> maybe related to characters
> (I doubt) or accessing a problematic file> (maybe...). Check the mysql server
> with the "SHOW PROCESSLIST"> command, maybe the stuck query will show in the
> info field.> > Cheers,> > Michael> > On 10/30/07, lise machetel <[EMAIL
> PROTECTED]> wrote:> >> >> >> > I use bacula 2.2.5 on a debian Etch server
> (recent update).> > clients are debian Etch or sarge with same version of
> bacula client> > MySql server is used - version 5.0 (Etch stable package)> >>
> > I had no error during the compilation.> >> > during backup, under bconsole,
> if I do a "status dir", I can see that the status of the client is "is in
> unknow state"> > if I do a status client=name-of-this-client, the client
> answer that there is no job running, and that the job finished successfully.>
> > under a shell, I can see that MySql take 99% of the cpu> > and a nestat -an
> show:> > tcp 0 0 192.168.200.19:9101 192.168.200.19:43174 ESTABLISHED> > tcp
> 0 0 192.168.200.19:43174 192.168.200.19:9101 ESTABLISHED> > tcp 0 0
> 192.168.200.19:49926 192.168.200.19:9103 TIME_WAIT> > tcp 9 0
> 192.168.200.19:41945 192.168.200.19:9103 CLOSE_WAIT> > tcp 0 0
> 192.168.200.19:56060 192.168.200.215:9102 TIME_WAIT> > tcp 1 0
> 192.168.200.19:55688 192.168.200.215:9102 CLOSE_WAIT> >> > some times, the
> job finish, and some times the job stay like this (with the cpu in use). I
> tried to let it like this, to see if the job will finish - but It can stay
> like this during one day without terminate anything.> > If I try to cancel
> the job, it doesn't work either (job stay with the "cancel" state and mysql
> still use 99% of the cpu)> > When it is like this, I have to stop bacula and
> restart mysql to have a chance to do something later.> >> > It doesn't
> happens always with the same client - so I think I have an issue with the
> server - but I really don't know what.> > I checked the mysql database
> (repair command), and I have no issue with the databases (mysql or bacula).>
> >> > on this bacula server, I backup 50 clients, it takes 1 To and backup
> used to finish during the night. Because of this strange new behavior, it
> doesn't work anymore like this.> >> > any ideas ?> > thanks> >> >> >
> ________________________________> Besoin d'un e-mail ? Créez gratuitement un
> compte Windows Live Hotmail> et bénéficiez d'un filtre antispam gratuit !
> Windows Live Hotmail> >
> -------------------------------------------------------------------------> >
> This SF.net email is sponsored by: Splunk Inc.> > Still grepping through log
> files to find problems? Stop.> > Now Search log events and configuration
> files using AJAX and a browser.> > Download your FREE copy of Splunk now >>
> http://get.splunk.com/> > _______________________________________________> >
> Bacula-users mailing list> > Bacula-users@lists.sourceforge.net> >
> https://lists.sourceforge.net/lists/listinfo/bacula-users> >> >> > > > -- >
> Michael Lewinger> MBR Computers> http://mbrcomp.co.il
_________________________________________________________________
Votez pour vos séries TV préférées et tentez de gagner un voyage à Hawaï !
http://messengerawards.divertissements.fr.msn.com/
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
