Well, I decided to see directly in the Catalog :

mysql> select JobId, JobStatus, PoolId, Level from Job where JobId=27110;
+-------+-----------+--------+-------+
| JobId | JobStatus | PoolId | Level |
+-------+-----------+--------+-------+
| 27110 | R             |     34 | F     |
+-------+-----------+--------+-------+
1 row in set (0.00 sec)

mysql> select JobId, JobStatus, PoolId, Level from Job where JobId=27265;
+-------+-----------+--------+-------+
| JobId | JobStatus | PoolId | Level |
+-------+-----------+--------+-------+
| 27265 | R             |     84 | I     |
+-------+-----------+--------+-------+
1 row in set (0.00 sec)

As you can see, this two job have JobStatus = R (for running), and it's wrong. 
I think I could do that :

update Job set JobStatus = 'T' where JobId = 27110;
update Job set JobStatus = 'T' where JobId = 27265;

but I don't know if it's really a good idea,  someone can  say me if I am wrong 
or not ?
and I read also about dbchek, I don't know if this tool can help me to solve my 
problem...

Regards,

François




De : François Mehault [mailto:francois.meha...@netplus.fr]
Envoyé : jeudi 28 mai 2009 11:27
À : bacula-users@lists.sourceforge.net
Objet : [Bacula-users] running jobs in DB Catalog

Hi All

I have two jobs which are running in my DB Catalog for one client, and no jub 
running in my bacula-dir for this client, I would like to correct information 
in my Catalog. As I have this problem, my client can't be saved. And I don't 
succeed to cancel the jobs with the cancel command in bconsole as there is no 
running job for the director. Help will be really appreciated.

Regards,

François
------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT 
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, & 
iPhoneDevCamp as they present alongside digital heavyweights like Barbarian 
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com 
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to