Hi Lise,
No, your server certainly can handle this. The Process ID 267 (maybe a
thread, maybe a process in UNIX) has crashed. I'm not sure how to handle
mysql syntax to get more details regarding the particular query, but the
answer would be inside it.
Cheers,
Michael
On Nov 1, 2007 1:34 PM, lise machetel <[EMAIL PROTECTED]> wrote:
> 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-fd
> Connecting to Client boing-fd at boing.sequans.com:9102
> boing-fd Version: 2.2.5 (09 October 2007) i686-pc-linux-gnu debian 3.1
> Daemon 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:26
> No 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+ COMMAND
> 15166 mysql 18 0 124m 32m 5032 S 99.9 12.6 310:57.49 mysqld
>
> maybe 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
>
>
> ------------------------------
> Besoin d'un e-mail ? Créez gratuitement un compte Windows Live Hotmail et
> bénéficiez de 5 Go de stockage ! Windows Live
> Hotmail<http://www.windowslive.fr/hotmail/default.asp>
>
--
Michael Lewinger
MBR Computers
http://mbrcomp.co.il
-------------------------------------------------------------------------
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
