My install of RT 3.6.1 (on Solaris 10, mysql 5.0.22) has been working very nicely for several months. We only have about 80 tickets, but we have been able to create tickets with no problems both in the web interface and via email. That is, until today. Now I get:
<br><br><table border="0" cellpadding="1" cellspacing="0"><tbody><tr><td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>error:</b> </font></td>
<td align="left" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2">Transactions not supported by database at /opt/perlsite/lib/site_perl/5.8.7/sun4-solaris/DBI.pm line 1668.<br></font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>context:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2">
<table border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>...</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><br></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>1664:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"> sub begin_work {</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>1665:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"> my $dbh = shift;</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>1666:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"> return $dbh->set_err(1, "Already in a transaction")</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>1667:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"> unless $dbh->FETCH('AutoCommit');</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>1668:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><font color="red"> $dbh->STORE('AutoCommit', 0); # will croak if driver doesn't support it</font>
</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>1669:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"> $dbh->STORE('BegunWork', 1); # trigger post commit/rollback action</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>1670:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"> return 1;</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>1671:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"> }</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>1672:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><br></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>...</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><br></td>
</tr>
</tbody></table>
</font></td>
</tr>
<tr>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2"><b>code stack:</b> </font></td>
<td align="left" nowrap="nowrap" valign="top"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2">
/opt/perlsite/lib/site_perl/5.8.7/sun4-solaris/DBI.pm:1668<br>
/opt/perlsite/lib/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm:720<br>
/opt/rt3/lib/RT/Ticket_Overlay.pm:564<br>
/opt/rt3/lib/RT/Interface/Web.pm:446<br>
/opt/rt3/share/html/Ticket/Display.html:103<br>
/opt/rt3/share/html/Ticket/Create.html:300<br>
/opt/rt3/share/html/autohandler:279</font></td></tr></tbody></table><br>when trying to create a ticket on the web. I get similar, but slightly different errors from an email attempt. I've searched the archives and the wiki but any mention of the keywords here are from 2002 or so.
<br><br>I checked the rt3.Transactions table on the mysql server it it is INNODB. Are there other tables to check?<br><br>I haven't modified RT or the mysql server at all in many weeks. However, Solaris patches were applied last night. Unfortunately, I can't see anything has changed in the RT or the mysql install. And SearchBuilder is up to date according to CPAN.
<br><br>Appreciate any ideas of where to look.<br><br>Thanks,<br>Steve Holmes<br clear="all"><br>