http://bugs.bacula.org/view.php?id=1594
On Sat, 2010-06-12 at 11:03 +0200, Ulrich Leodolter wrote:
> hi
>
> now i have looked int sources and i am sure this#
> is a BUG in cats/sql_cmds.c:select_copy_del:
>
> Job.Type='C' should be Job.Type='c' (note lowercase!)
>
> when i look at select_migrate_del i see the lowercase
> Job.Type='g', this means migration admin jobs are pruned
> in dird/ua_prune.c:prune_jobs() when JobType = JT_MIGRATE.
> same should apply to JobType = JT_COPY (copy admin jobs).
>
> so i will write a BUG report.
>
> best regards
> ulrich
>
> On Fri, 2010-06-11 at 10:38 +0200, Ulrich Leodolter wrote:
> > hello,
> >
> > after copy jobs i see slow queries like:
> >
> > # Query_time: 152 Lock_time: 0 Rows_sent: 0 Rows_examined: 16026
> > SELECT DISTINCT DelCandidates.JobId,DelCandidates.PurgedFiles FROM
> > Job,DelCandidates WHERE (Job.JobId=DelCandidates.JobId AND
> > DelCandidates.JobStatus NOT IN ('T','W')) OR (Job.JobTDate>1260691871
> > AND Job.ClientId=30 AND Job.Type='C');
> >
> > i see this since i upgraded to git Branch-5.0 (5.0.2).
> > ClientId=30 is dummy client used only for copy jobs:
> >
> > Client {
> > Name = None
> > Address = localhost
> > Password = "NoNe"
> > Catalog = MyCatalog
> > }
> >
> > this client has only jobs of Type='c', and no real copy jobs of
> > Type='C'. the above select is always empty!
> >
> > i have more then 100 daily copy jobs, for small incremental jobs
> > most of the time is spent in this needless select.
> >
> >
> > regards
> > ulrich
> >
--
Ulrich Leodolter <[email protected]>
Oesterreichische Bibliothekenverbund und Service GmbH
Bruennlbadgasse 17/2A, A-1090 Wien
Fax +43 1 4035158-30
Tel +43 1 4035158-21
Web http://www.obvsg.at
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
