I don't know if it the duplicates are caused by the copy job, but there are
two interesting differences between the rows:

1) The atime (access time) field in the LStat is different (BMvLg8 vs BMvJgV),
   suggesting that the file's stat was read more than once.

2) The FileIndex values are different (128385 vs 86).  These values increment
   from 1 at the start of the job, so it seems that the order of the files in
   the jobs is not very similar.

I think you need to do some tests, maybe periodically recording the value of

select max(fileid) from file;

to try to discover when the rows are added.

__Martin




>>>>> On Tue, 19 Oct 2010 14:28:24 +0200, Robert Oschwald said:
> 
> 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
> 

------------------------------------------------------------------------------
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