Today I checked again the migrated pg82 db for last nights incremental of one 
of the servers.
Still the same error  for this backup's new entries when I click on one of the 
nodes in the bat restore select tree:

sql_get.c:156-0 === Problem!  sql_get.c:155 get_file_record want 1 got rows=2 
PathId=138243 FilenameId=2533203

DB entry check:
SELECT * FROM public.file WHERE  file.filenameid = 2533203 AND pathid=138243 
and jobid = 3347;

Result:
FileId  FileIndex       JobId   PathId  FilenameId      MarkId  LStat   MD5
273044923 128385 3347 138243  2533203|0  "P0G VIFW IGk B A A A IB BAA I BMvLg8 
BMvJIy BMvJIy A A E"  "3eBz2t04SgJGcJFHVq62Mw"
273041096          86 3347 138243  2533203|0  "P0G VIFW IGk B A A A IB BAA I 
BMvJgV BMvJIy BMvJIy A A E"  "3eBz2t04SgJGcJFHVq62Mw"

I then checked my old Bacula 5.0.2 MySQL Database.
Here is a query for one of the oldest backups I have in the former mysql db:

SELECT * FROM File WHERE  filenameid = 42066 AND pathid=102145 and jobid = 2941;

FileId         FileIndex JobId  PathId    FilenameId MarkId  LStat              
                                                                                
             MD5
228247316       1910509 2941  102145  42066         0           P0C OhMx IGk B 
A A A J8 BAA I BMiHlI BDIcWc BLkzrq A A E      SiJb2FBj/EYO/nmnkj9i7w
229942749       3605942 2941  102145  42066         0           P0C OhMx IGk B 
A A A J8 BAA I BMkXTF BDIcWc BLkzrq A A E   SiJb2FBj/EYO/nmnkj9i7w
 
Even in the former MySQL DB I got two entries for each file in the db.

Maybe this is related to the copy job for the "Default" Pool which copies to 
LTO-4 tapes (B2D2T) after all backups to the Default (disk) pool?

Pool {
  Name = Default
  Pool Type = Backup
  Storage = File
  Recycle = yes
  AutoPrune = yes
  Volume Retention = 14 days
  LabelFormat = b2d-
  Maximum Volume Bytes = 50G
  # Duplicate: Next pool to use if running copy jobs
  NextPool = Tape
}

Note that the error message is only displayed if:
 - You start bacula-dir manually in the console or
 - Add 2>&1 > log_file to the init.d start() line

e.g.:
daemon /usr/sbin/bacula-dir $2 ${DIR_OPTIONS} -c /etc/bacula/bacula-dir.conf 
2>&1 > /var/log/bacula_startup.log

on CentOS5.

Any ideas?

Robert


>>>>>> On Mon, 18 Oct 2010 09:54:28 +0200, Robert Oschwald said:
>> 
>> I migrated Bacula 5.0.2 from MySQL to Bacula 5.0.3 PostgreSQL 8.1, 
>> and then migrated to PostgreSQL 8.2 using dump/restore.
>> ...snip...
>> Migration from PostgreSQL 8.1 to 8.2:
>> pg_dumpall > pg_dump.sql
>> - install postgreSQL 8.2 (CentOS-Testing)
>> psql < pg_dump.sql
> 
> Did you start with an empty database when you imported the dump after
> migration from PostgreSQL 8.1 to 8.2?  I suspect not, because you have
> everything twice.
> 
> 
>> 
>> 
>> Are these error messages critical?
> 
> Yes.
> 
> __Martin
> 
> ------------------------------------------------------------------------------
> Download new Adobe(R) Flash(R) Builder(TM) 4
> The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
> Flex(R) Builder(TM)) enable the development of rich applications that run
> across multiple browsers and platforms. Download your free trials today!
> http://p.sf.net/sfu/adobe-dev2dev
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users