Hi Heitor,
Thanks for your kind reply! No upgrade had done in those few months for
Bacula. If DB got error, just query why volume 1 has no problem but always
stuck at volume 2? Is it able to check/repair the DB comes with bacula? Or
shall I check postgresql manual? I ran the job again after replaced another USB
docking and HDD to see whether it would be the issue related.
DB: postgresql-8.4.9-1.fc14.x86_64
Catalog size: 4.6TB
[root@baculab]# echo "list jobs"|bconsole|grep MTHLY
| 828 | COMMTHLY1 | 2014-05-15 11:41:40 | B | F | 12,041,875
| 3,186,454,529,352 | T |
| 833 | COMMTHLY2 | 2014-05-18 10:13:00 | B | F | 1,709,675
| 6,256,974,076,676 | T |
| 928 | COMMTHLY2 | 2014-07-08 09:56:23 | B | F | 1,743,758
| 6,575,280,360,690 | T |
| 964 | COMMTHLY1 | 2014-08-03 08:00:05 | B | F | 12,286,436
| 3,598,328,180,140 | T |
| 965 | COMMTHLY2 | 2014-08-05 12:22:48 | B | F | 1,673,471
| 6,415,007,319,252 | T |
| 1,098 | COMMTHLY1 | 2014-11-02 22:09:18 | B | F | 0
| 0 | A |
| 1,099 | COMMTHLY2 | 2014-11-05 11:25:33 | B | F | 0
| 0 | A |
| 1,113 | COMMTHLY1 | 2014-11-10 09:55:34 | B | F | 0
| 0 | R |
Thanks and best regards,Keith
On Monday, November 10, 2014 8:44 PM, "[email protected]"
<[email protected]> wrote:
10-Nov 01:12 bacula-fd JobId 1105: Error: bsock.c:429 Write error sending 29424
bytes to Storage daemon:localhost:910
3: ERR=Connection reset by peer
10-Nov 01:12 bacula-fd JobId 1105: Fatal error: backup.c:1200 Network send
error to SD. ERR=Connection reset by peer
10-Nov 01:45 bacula-dir JobId 1105: Fatal error: sql_create.c:860 Fill File
table Query failed: INSERT INTO File (Fil
eIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT
batch.FileIndex, batch.JobId, Path.PathId, Filename.F
ilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON
(batch.Path = Path.Path) JOIN Filename ON (b
atch.Name = Filename.Name): ERR=ERROR: relation "batch" does not exist
LINE 1: ...ameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch JOIN...
Mr. Keith: this is a database error. Probably related with batch insert
feature. Was it upgraded before the problem starts to happen?Other causes to
the similar problem: disk partition full on the database host; backup volumes
loop inferno when PurgestOldestVolume is enabled.
Regards,=========================================================================
Heitor Medrado de Faria
Faltam poucos dias - Treinamento Telepresencial Bacula:
http://www.bacula.com.br/?p=2174
61 2021-8260 | 8268-4220
Site: www.bacula.com.br | Facebook: heitor.faria | Gtalk: [email protected]
==========================================================================
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
