Christian Schnelle wrote:
> Hi,
>
> after an upgrade from bacula 1.38 to 2.2.4 i got trouble with one
> backup job. This jobs backup round about 2TB data.
> After writing the data to the tapes bconsole shows:
> 'Dir inserting Attributes'.
> This inserting runs now for about 3 days.
>
> Postgres shows:
>
> --snip--
> template1=# select * from pg_stat_activity;
> datid | datname | procpid | usesysid | usename |
>
> current_query
>
> | waiting | xact_start |
> query_start | backend_start |
> client_addr | client_port
> -------+-----------+---------+----------+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+-------------------------------+-------------------------------+-------------------------------+-------------+-------------
> 16596 | bacula | 26795 | 16384 | bacula | <IDLE>
>
>
>
> | f | |
> 2009-10-22 11:04:53.904619+02 | 2009-10-17 22:10:00.599108+02 |
> | -1
> 16596 | bacula | 20226 | 16384 | bacula | INSERT INTO File
> (FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT
> batch.FileIndex, batch.JobId, Path.PathId,
> Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON
> (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name) |
> f | 2009-10-21 06:08:49.528248+02 | 2009-10-21 06:08:49.528248+02
> | 2009-10-19 03:44:09.545097+02 | | -1
> 1 | template1 | 12282 | 10 | postgres | select * from
> pg_stat_activity;
>
>
> | f | 2009-10-22 11:07:53.705321+02 |
> 2009-10-22 11:07:53.705321+02 | 2009-10-22 11:07:52.013214+02 |
> | -1
> --snap--
Does this output change over time? If it is, progress is being made.
It sounds like the query is running slowly. In which case, the query
can be tuned to make it run faster.
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
