50749 - descriptions found with no corresponding entry in checkin table

Status: RESOLVED WONTFIX

(Webtools Graveyard :: Bonsai, defect, P2)

Description

[Dawn Endico]

In the process of searching for patch contributors in bonsai checkin comments,
I noticed that the bonsai db @mozilla.org has a whole lot of entries in
the descs table with no checkins that refer to them.  I think this must be
a bug. I don't see anywhere else that would refer to a description.

I was going to try rebuilding the db but we don't have an "all" module so
i'll just rebuild seamonkeyall since that's the part of the tree i'm interested
in now.

Here's a script I wrote to check for orphaned descriptions that aren't
pointed to by any checkin. Its really slow and I didn't let the script
finish but it looks like most of descriptions 50-200 are horked.

Please tell me I'm doing something wrong and the db is fine.


-----------------------------------
require 'globals.pl';
require 'get_line.pl';

use diagnostics;
use strict;

ConnectToDatabase();

my $qstring = "select id from descs";

SendSQL($qstring);

my @row;
my @ids ;
while (@row = FetchSQLData()) {
  push @ids, $row[0] ;
}

print "there are " .  @ids  . " descriptions: \n";

my @orphans;
foreach my $id (@ids) {
  my $query = "select * from checkins where descid=$id";
  SendSQL($query);
  my @row2;
  unless (@row2 = FetchSQLData()) {
    print "descid $id has no checkin\n";
    push @orphans, $id ;
  }
}
print "there are " . @orphans . " orphan descriptions.\n";
print "orphan descriptions: " . join(', ', @orphans) . "\n";

Comment 1

[Terry Weissman]

It's just probably some historical screwup on my part when I rebuilt the
database for something or another.

If it really bothers you, the easiest way to fix it would be:

(1) Backup the bonsai database.
(2) Blow it away (by running the maketables.sh script)
(3) Repopulate the entire thing from scratch.

Comment 2

[Tara Hernandez]

I have one instance of this problem on the landfill test CVS repository, but I
also have been seriously dorking around with the server.

Dawn--can you check to see if your recreated tables have the same problem?

Comment 3

[Adam Muntner [:adamm] (use NEEDINFO)]

Bonsai was decommissioned, closing all remaining bugs "wontfix"