SMT DB error?

SUSE Product Topics SLES Updates
1

Hi,

The daily run of smt-gen-report outputs the following at the top:

DBD::mysql::db do failed: Duplicate entry ‘somebighash-anotherhash’ for key 1 at /usr/lib/perl5/vendor_perl/5.10.0/SMT/NCCRegTools.pm line 699.

That line performs an insert:

[CODE] $statement = sprintf(“INSERT INTO ClientSubscriptions (GUID, SUBID) VALUES(%s, %s)”,
$self->{DBH}->quote($data->{GUID}),
$self->{DBH}->quote($subid));

            $self->{DBH}->do($statement);

[/CODE]

Can anybody explain what’s the problem and how to clean it up?

Thanks

2

[QUOTE=jmroth;3702]Hi,

Can anybody explain what’s the problem and how to clean it up?

[/QUOTE]

This looks like a code bug in the SMT server. Please contact Novell/SUSE Support Services, they will be able to provide you with a fix.