PDA

View Full Version : SMT DB error?



jmroth
28-Mar-2012, 10:28
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:


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

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


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

Thanks

dirkmueller
04-Apr-2012, 14:02
Hi,

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



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.