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--
The backup machine is an dell poweredge r200 with dual xeon, 2gb ram,
1gb /tmp and 230gb other disc space. it runs on debian lenny with cryted
filesystem.
There are no other servers than bacula running on this machine.
A Superloader 3 with 16 lto2 tapes works as tape storage.
The postgresql config is this:
--snip--
shared_buffers = 1024MB # min 128kB or max_connections*16kB
temp_buffers = 160MB # min 800kB
max_prepared_transactions = 50 # can be 0 or more
work_mem = 92MB # min 64kB
maintenance_work_mem = 256MB # min 1MB
max_stack_depth = 6MB # min 100kB
max_fsm_pages = 33000 # min max_fsm_relations*16, 6
bytes each
max_fsm_relations = 2000 # min 100, ~70 bytes each
max_files_per_process = 1000
fsync = on # turns forced synchronization
on or off
synchronous_commit = on # immediate fsync at commit
wal_sync_method = fsync # the default is the first option
full_page_writes = on # recover from partial page writes
wal_buffers = 128kB # min 32kB
wal_writer_delay = 200ms # 1-10000 milliseconds
commit_delay = 0 # range 0-100000, in microsec
commit_siblings = 5 # range 1-1000
checkpoint_segments = 15 # in logfile segments 16MB each
checkpoint_timeout = 30s
--snap--
Before upgrading to lenny it runs a debian sarge with bacula 1.38 and
anything worked like a charm. But since this upgrade this one backup job
lets me goning crazy.
Please help me to fix this issue.
Best regards
Christian
------------------------------------------------------------------------------
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
|
