Hello,<br>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 <a href="http://3.6.5.">3.6.5.</a> 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:<br>
Ticket could not be created due to an internal error<br><br>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. <br>
<br>Today it is not working again. I tracked down some errors and found this:<br><p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal;">
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</p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal;">sr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 505.</p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal;">RT::Handle=HASH(0xa12a6a8) couldn't execute the query 'INSERT INTO Groups (Domain, Type, Instance, id, Name, Description) VALU</p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal;">ES (?, ?, ?, ?, ?, ?)' at /usr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 518</p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;"><br></p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">In the MySQL DB, I find the following:</p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;"><br></p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
</p><p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">| 737 | | SystemRolegroup for internal use | RTx::AssetTracker::System-Role | Owner | 0 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 738 | | Pseudogroup for internal use | RTx::AssetTracker::System-Role | Admin | 0 | </p><p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 739 | NULL | NULL | RTx::AssetTracker::Type-Role | Admin | 1 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">| 740 | NULL | NULL | RTx::AssetTracker::Type-Role | Owner | 1 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 741 | NULL | NULL | RTx::AssetTracker::Type-Role | Admin | 2 | </p><p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 742 | NULL | NULL | RTx::AssetTracker::Type-Role | Owner | 2 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">| 743 | NULL | NULL | RTx::AssetTracker::Asset-Role | Admin | 1 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 744 | NULL | NULL | RTx::AssetTracker::Asset-Role | Owner | 1 | </p><p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 745 | NULL | NULL | RTx::AssetTracker::Type-Role | Admin | 3 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">| 746 | NULL | NULL | RTx::AssetTracker::Type-Role | Owner | 3 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 747 | NULL | NULL | RTx::AssetTracker::Type-Role | Admin | 4 | </p><p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 748 | NULL | NULL | RTx::AssetTracker::Type-Role | Owner | 4 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">| 749 | NULL | NULL | RTx::AssetTracker::Type-Role | Admin | 5 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 750 | NULL | NULL | RTx::AssetTracker::Type-Role | Owner | 5 | </p><p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 751 | NULL | NULL | RTx::AssetTracker::Asset-Role | Admin | 2 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">| 752 | NULL | NULL | RTx::AssetTracker::Asset-Role | Owner | 2 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 753 | NULL | NULL | RTx::AssetTracker::Type-Role | Admin | 6 | </p><p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 754 | NULL | NULL | RTx::AssetTracker::Type-Role | Owner | 6 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">| 756 | User 755 | ACL equiv. for user 755 | ACLEquivalence | UserEquiv | 755 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 757 | NULL | NULL | RT::Ticket-Role | Requestor | 153 | </p><p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 758 | NULL | NULL | RT::Ticket-Role | Owner | 153 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">| 759 | NULL | NULL | RT::Ticket-Role | Cc | 153 | </p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
| 760 | NULL | NULL | RT::Ticket-Role | AdminCc | 153 | </p><p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">
+-----+----------+----------------------------------+--------------------------------+--------------+----------+</p>
<p style="margin: 0px; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; font-size: 12px; line-height: normal; font-size-adjust: none; font-stretch: normal; min-height: 14px;">642 rows in set (0.00 sec)</p>
<br>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?<br><br><br>Thanks,<br><br>Chris<br>