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, "heitor AT bacula.com DOT br" <heitor AT bacula.com DOT br> 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: heitorfaria AT gmail DOT com ==========================================================================
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|