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 ------------------------------------------------------------------------- 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
