[Bacula-bugs] [bacula 0000148]: duplicate empty file name in database

[<bac...@li...>]

The following bug has been SUBMITTED.
======================================================================
http://bugs.bacula.org/bug_view_advanced_page.php?bug_id=0000148
======================================================================
Reported By:                kardel
Assigned To:                
======================================================================
Project:                    bacula
Bug ID:                     148
Category:                   Storage Daemon
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
======================================================================
Date Submitted:             10-24-2004 00:02 PDT
Last Modified:              10-24-2004 00:02 PDT
======================================================================
Summary:                    duplicate empty file name in database
Description: 
It happens that bacula sql_create.c seems to manage
to put 2 version of the empty file name into the filename table. It trips
over those later with:
24-Oct-2004 04:21 pip-dir: System.2004-10-24_00.27.13 Warning:
sql_create.c:662 More than one Filename! 2 for file: 
24-Oct-2004 04:21 pip-dir: System.2004-10-24_00.27.13 Warning:
sql_create.c:662 More than one Filename! 2 for file: 
24-Oct-2004 04:21 pip-dir: System.2004-10-24_00.27.13 Warning:
sql_create.c:662 More than one Filename! 2 for file: 
24-Oct-2004 04:21 pip-dir: System.2004-10-24_00.27.13 Warning:
sql_create.c:662 More than one Filename! 2 for file: 
24-Oct-2004 04:21 pip-dir: System.2004-10-24_00.27.13 Warning:
sql_create.c:662 More than one Filename! 2 for file: 
24-Oct-2004 04:21 pip-dir: System.2004-10-24_00.27.13 Warning:
sql_create.c:662 More than one Filename! 2 for file: 
24-Oct-2004 04:21 pip-dir: System.2004-10-24_00.27.13 Warning:
sql_create.c:662 More than one Filename! 2 for file: 
24-Oct-2004 04:21 pip-dir: System.2004-10-24_00.27.13 Warning:
sql_create.c:662 More than one Filename! 2 for file: 


Questions are: how can there be an empty file name ?
Why are there two entries in the DB ?
Why are bacula=# select * from filename where name = '';
 filenameid | name 
------------+------
     537056 | 
         90 | 
(2 rows)

bacula=# 

Should the index for filename.name be unique ? (-> also performance?)

======================================================================

Bug History
Date Modified  Username       Field                    Change              
======================================================================
10-24-04 00:02 kardel         New Bug                                      
======================================================================