[rt-users] Ticket Creation Failing

[Matt Higgins]

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.


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)

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
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)
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)
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)
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)
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)

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.

Some other systems notes that maybe helpful.

MySQL-shared-compat-5.0.27-0.rhel4
MySQL-client-standard-5.0.27-0.rhel4
MySQL-devel-standard-5.0.27-0.rhel4
MySQL-server-standard-5.0.27-0.rhel4
DBD-mysql-4.005
DBI-1.59
RT-3.6.1
CentOS release 4.4 (Final)
This is perl, v5.8.5 built for i386-linux-thread-multi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070829/2f7eea64/attachment.htm>