[prev in list] [next in list] [prev in thread] [next in thread]
List: rt-users
Subject: [rt-users] Ticket Creation Failing
From: "Matt Higgins" <matt.higgins () gmail ! com>
Date: 2007-08-29 14:25:09
Message-ID: 950550040708290725o41ddb3a4w9bd146a2dadd5f0c () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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
[Attachment #5 (text/html)]
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.r \
hel4<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>
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic