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
