Cannot Create Ticket Error Again Please Help

RT Users
1

I was running RT 3.0.8 and after about two months of solid use every ticket
creation attempt was met by an Internal Error.

[Sat Feb 14 05:28:04 2004] [error]: Couldn’t create a ticket group of type
’Requestor’ for ticket 1473: Could not create group
(/home/rt/lib/RT/Ticket_Overlay.pm:1314)
[Sat Feb 14 05:28:04 2004] [crit]: Couldn’t create ticket groups for ticket
1473. aborting Ticket creation. (/home/rt/lib/RT/Ticket_Overlay.pm:528)
[Sat Feb 14 05:28:04 2004] [crit]: Ticket could not be created due to an
internal error (/home/rt/lib/RT/Interface/Email.pm:579)
[Sat Feb 14 05:28:04 2004] [error]: Create failed: 0 / 0 / Ticket could not
be created due to an internal error
(/home/rt/lib/RT/Interface/Email.pm:583)
[Sat Feb 14 05:39:00 2004] [error]: Couldn’t create a ticket group of type
’Requestor’ for ticket 1474: Could not create group
(/home/rt/lib/RT/Ticket_Overlay.pm:1314)
[Sat Feb 14 05:39:00 2004] [crit]: Couldn’t create ticket groups for ticket
1474. aborting Ticket creation. (/home/rt/lib/RT/Ticket_Overlay.pm:528)
[Sat Feb 14 05:39:00 2004] [error]: WebRT: Ticket could not be created due
to an internal error () (/home/rt/share/html/Elements/Error:53)

I asked around, couldn¹t find anything and was forced to install again from
scratch 3.0.9. I got 3.0.9 up and running and now after about a month of
solid use I get ticket creation errors again.

[Thu Mar 18 22:20:10 2004] [crit]: Couldn’t create a ticket
(/home/rt3/lib/RT/Ticket_Overlay.pm:519)
[Thu Mar 18 22:20:10 2004] [crit]: Ticket could not be created due to an
internal error (/home/rt3/lib/RT/Interface/Email.pm:678)
[Thu Mar 18 22:20:41 2004] [error]: Create failed: 0 / 0 / Ticket could not
be created due to an internal error
(/home/rt3/lib/RT/Interface/Email.pm:684)
[Thu Mar 18 18:08:51 2004] [error] [client 172.16.2.44] File does not exist:
/home/rt3/share/html/favicon.ico
[Thu Mar 18 18:09:07 2004] [error] [client 172.16.2.44] File does not exist:
/home/rt3/share/html/favicon.ico
[Fri Mar 19 04:23:44 2004] [crit]: Couldn’t create a ticket
(/home/rt3/lib/RT/Ticket_Overlay.pm:519)
[Fri Mar 19 04:23:44 2004] [error]: WebRT: Ticket could not be created due
to an internal error () (/home/rt3/share/html/Elements/Error:53)
[Fri Mar 19 04:27:20 2004] [crit]: Couldn’t create a ticket
(/home/rt3/lib/RT/Ticket_Overlay.pm:519)
[Fri Mar 19 04:27:21 2004] [error]: WebRT: Ticket could not be created due
to an internal error () (/home/rt3/share/html/Elements/Error:53)

Please! Any help any of you could offer. Im running RT 3.0.9 with a MySQL
database on the backend.

-Nick

2

Nick wrote:

[Sat Feb 14 05:28:04 2004] [error]: Couldn’t create a ticket group of type
‘Requestor’ for ticket 1473: Could not create group
(/home/rt/lib/RT/Ticket_Overlay.pm:1314)

Sounds like the autoincrement field on the Principals or
Groups table (or maybe another table) is corrupted.
Compare the result of

mysql> show table status from rt3 like ‘Groups’

with

mysql> select max(id) from Groups

to check.
�|� Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

3

Nick wrote:

[Sat Feb 14 05:28:04 2004] [error]: Couldn’t create a ticket group of type
‘Requestor’ for ticket 1473: Could not create group
(/home/rt/lib/RT/Ticket_Overlay.pm:1314)

Sounds like the autoincrement field on the Principals or
Groups table (or maybe another table) is corrupted.
Compare the result of

mysql> show table status from rt3 like ‘Groups’

with

mysql> select max(id) from Groups

to check.

mysql> show table status from rt3 like ‘Groups’

Gives me an Auto_increment of 7009.

mysql> select max(id) from Groups

Gives me 7008.

Same results when I check Principals. When I check tickets though,

mysql> show table status from rt3 like ‘Tickets’

Auto Increment is 1598

mysql> select max(id) from Tickets

Max(id) is 1594

I don¹t know as much about SQL as I should lol but that doesn¹t sound right.
There an easy way to get things back on track? Any help would be greatly
appreciated!

-Nick

4

Nick wrote:

mysql> show table status from rt3 like ‘Groups’
Gives me an Auto_increment of 7009.
mysql> select max(id) from Groups
Gives me 7008.

Sounds good.

Same results when I check Principals. When I check tickets though,
mysql> show table status from rt3 like ‘Tickets’
Auto Increment is 1598
mysql> select max(id) from Tickets
Max(id) is 1594

That’s not really a problem. Means some rows have been deleted, or
have been partially inserted then rolled back. As long as your
autoincrement is higher than max(id) you should be fine.

Next step would be to check your database logs for signs of
illness. Could be something as simple as a lack of disk space,
or something as evil as database corruption, or possibly
something else entirely.

Good luck…