On Mon, Feb 21, 2011 at 5:41 PM, John Drescher <drescherjm AT gmail DOT com> 
wrote:
>>> It appears the problem is with the catalog. I am using 64 bit gentoo
>>> linux and bacula-5.0.3 although the problem has persisted for years. I
>>> only use disk volumes for my catalog so I have not spent much effort
>>> investigating the cause.
>>
>> What datatype is media.endblock on your system?  On mine, PostgreSQL, it is:
>> endblock         | bigint                      | not null
>>
>> I suspect yours is int.  Changing it to bigint should fix the problem.
>>
>
> It was an int.
>
> I executed the following command in psql:
> ALTER table media ALTER column endblock TYPE bigint;
>
> I will restart the catalog job and see if that fixes the problem..
> Thanks,
>

Looks like that worked..



You have messages.
*mes
21-Feb 17:51 datastore3-fd JobId 24353: shell command: run
ClientAfterJob "/usr/libexec/bacula/delete_catalog_backup"
21-Feb 17:48 fileserver-sd JobId 24353: Job write elapsed time =
00:08:07, Transfer rate = 6.757 M Bytes/second
21-Feb 17:48 fileserver-dir JobId 24353: Bacula fileserver-dir 5.0.3
(04Aug10): 21-Feb-2011 17:48:29
  Build OS:               x86_64-pc-linux-gnu gentoo
  JobId:                  24353
  Job:                    BackupCatalog.2011-02-21_17.36.52_39
  Backup Level:           Incremental, since=2011-02-21 01:13:25
  Client:                 "datastore3-fd" 5.0.3 (04Aug10)
x86_64-pc-linux-gnu,gentoo,
  FileSet:                "Catalog" 2006-07-24 14:04:28
  Pool:                   "BackupCatalogs" (From Job resource)
  Catalog:                "HBCatalog" (From Client resource)
  Storage:                "File" (From Job resource)
  Scheduled time:         21-Feb-2011 17:36:49
  Start time:             21-Feb-2011 17:40:21
  End time:               21-Feb-2011 17:48:29
  Elapsed time:           8 mins 8 secs
  Priority:               10
  FD Files Written:       1
  SD Files Written:       1
  FD Bytes Written:       3,290,703,552 (3.290 GB)
  SD Bytes Written:       3,290,703,667 (3.290 GB)
  Rate:                   6743.2 KB/s
  Software Compression:   69.6 %
  VSS:                    no
  Encryption:             no
  Accurate:               no
  Volume name(s):         Catalogs-0298
  Volume Session Id:      2
  Volume Session Time:    1298321400
  Last Volume Bytes:      3,294,522,464 (3.294 GB)
  Non-fatal FD errors:    0
  SD Errors:              0
  FD termination status:  OK
  SD termination status:  OK
  Termination:            Backup OK

John

------------------------------------------------------------------------------
Index, Search & Analyze Logs and other IT data in Real-Time with Splunk 
Collect, index and harness all the fast moving IT data generated by your 
applications, servers and devices whether physical, virtual or in the cloud.
Deliver compliance at lower cost and gain new business insights. 
Free Software Download: http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users