[rt-users] problem with database: Duplicate entry

Chris Campbell sambauser at iastate.edu
Mon Apr 21 18:09:23 EDT 2008


Hello,
I have had RT running for over 2 years now.  I recently (January) moved it
to a different server; the new one running Solaris 10, MySQL 5.1 and
Lighttpd.  It is RT 3.6.5.  After moving to the new server, we installed
RTx::AssetTracker, which we like.  However, about a week ago, RT stopped
taking requests.  It would respond to emails with a message saying:
Ticket could not be created due to an internal error

After some testing, I determined it was an issue with the database.  Rolling
MySQL back to a previous filesystem snapshot would allow RT to work again.
I found a snapshot from two weeks earlier that worked and rolled back to
that.  I tested RT again.  It worked.

Today it is not working again.  I tracked down some errors and found this:

2008-04-21 12:34:40: (mod_fastcgi.c.2570) FastCGI-stderr: DBD::mysql::st
execute failed: Duplicate entry '738' for key 1 at /u

sr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 505.

RT::Handle=HASH(0xa12a6a8) couldn't execute the query 'INSERT INTO Groups
(Domain, Type, Instance, id, Name, Description) VALU

ES (?, ?, ?, ?, ?, ?)' at
/usr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 518


In the MySQL DB, I find the following:


| 737 |          | SystemRolegroup for internal use |
RTx::AssetTracker::System-Role | Owner        |        0 |

| 738 |          | Pseudogroup for internal use     |
RTx::AssetTracker::System-Role | Admin        |        0 |

| 739 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Admin        |        1 |

| 740 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Owner        |        1 |

| 741 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Admin        |        2 |

| 742 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Owner        |        2 |

| 743 | NULL     | NULL                             |
RTx::AssetTracker::Asset-Role  | Admin        |        1 |

| 744 | NULL     | NULL                             |
RTx::AssetTracker::Asset-Role  | Owner        |        1 |

| 745 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Admin        |        3 |

| 746 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Owner        |        3 |

| 747 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Admin        |        4 |

| 748 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Owner        |        4 |

| 749 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Admin        |        5 |

| 750 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Owner        |        5 |

| 751 | NULL     | NULL                             |
RTx::AssetTracker::Asset-Role  | Admin        |        2 |

| 752 | NULL     | NULL                             |
RTx::AssetTracker::Asset-Role  | Owner        |        2 |

| 753 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Admin        |        6 |

| 754 | NULL     | NULL                             |
RTx::AssetTracker::Type-Role   | Owner        |        6 |

| 756 | User 755 | ACL equiv. for user 755          | ACLEquivalence
        | UserEquiv    |      755 |

| 757 | NULL     | NULL                             | RT::Ticket-Role
         | Requestor    |      153 |

| 758 | NULL     | NULL                             | RT::Ticket-Role
         | Owner        |      153 |

| 759 | NULL     | NULL                             | RT::Ticket-Role
         | Cc           |      153 |

| 760 | NULL     | NULL                             | RT::Ticket-Role
         | AdminCc      |      153 |

+-----+----------+----------------------------------+--------------------------------+--------------+----------+

642 rows in set (0.00 sec)

So there is already a record with that ID.  What I'm wondering is, why is RT
trying to insert something into the database with that ID?  And what could
be done to fix this?


Thanks,

Chris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080421/fd907e7c/attachment.htm>


More information about the rt-users mailing list