My system was working fine up until about 6:00 this AM and has been up and running for about 2 years now. I am seeing the following in my messages log. <br><br>Aug 29 10:12:49 bucky RT: DBD::mysql::st execute failed: Duplicate entry '0' for key 2 at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 505. (/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm:505)
<br>Aug 29 10:12:49 bucky RT: RT::Handle=HASH(0x9ff9658) couldn't execute the query 'INSERT INTO Principals (ObjectId, PrincipalType, Disabled) VALUES (?, ?, ?)' at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 518 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x9ff9658)', 'INSERT INTO Principals (ObjectId, PrincipalType, Disabled) VA...', 0, 'Group', 0) called at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 353 DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x9ff9658)', 'Principals', 'ObjectId', 0, 'PrincipalType', 'Group', 'Disabled', 0) called at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/mysql.pm line 36 DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x9ff9658)', 'Principals', 'ObjectId', 0, 'PrincipalType', 'Group', 'Disabled', 0) called at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm line 1299 DBIx::SearchBuilder::Record::Create('RT::Principal=HASH(0xac999d4)', 'ObjectId', 0, 'Disabled', 0, 'PrincipalType', 'Group') calle
<br>Aug 29 10:12:49 bucky RT: Couldn't create a Principal on new user create. Strange things are afoot at the circle K (/usr/local/rt/lib/RT/Group_Overlay.pm:500) <br>Aug 29 10:12:49 bucky RT: Couldn't create a ticket group of type 'Requestor' for ticket 139919: Could not create group (/usr/local/rt/lib/RT/Ticket_Overlay.pm:1288)
<br>Aug 29 10:12:49 bucky RT: Couldn't create ticket groups for ticket 139919. aborting Ticket creation. (/usr/local/rt/lib/RT/Ticket_Overlay.pm:624) <br>Aug 29 10:12:49 bucky RT: Ticket could not be created due to an internal error (/usr/local/rt/lib/RT/Interface/Email.pm:241)
<br>Aug 29 10:12:49 bucky RT: Could not record email: Ticket creation failed: Ticket could not be created due to an internal error (/usr/local/rt/share/html/REST/1.0/NoAuth/mail-gateway:73) <br><br>I looked around and found some rumblings about a bug in DBD::MySQL related to duplicate keys, I was running version
perl-DBD-MySQL-2.9004-3.1 from my centos 4 install so I upgraded to the latest version DBD-mysql-4.005 and also upgraded dbd module from libdbi-dbd-mysql-0.6.5-10.RHEL4.1 to DBI-1.59. I am still getting this error. For fun I also logged into mysql and inserted a record into the Principles table with out issue (I deleted it after). Any help on this would be great.
<br><br>Some other systems notes that maybe helpful.<br><br>MySQL-shared-compat-5.0.27-0.rhel4<br>MySQL-client-standard-5.0.27-0.rhel4<br>MySQL-devel-standard-5.0.27-0.rhel4<br>MySQL-server-standard-5.0.27-0.rhel4<br>DBD-mysql-4.005
<br>DBI-1.59<br>RT-3.6.1<br>CentOS release 4.4 (Final)<br>This is perl, v5.8.5 built for i386-linux-thread-multi<br><br><br><br><br><br><br><br>