[rt-users] Can't create new tickets, new problem

[Steve Holmes]

James,

It looks like 58 patches were applied on the RT server. I can list them for
you if you like. No we have not tried to back any of them out.

I'm not sure how to know which ones would be appropriate to backout. I'm
about to start reading all of the READMEs for the patches to see if I can
find anything that stands out.

Thanks,
Steve

On 3/7/07, jmoseley at pgtv.com <jmoseley at pgtv.com> wrote:
>
> Which Solaris patches were installed?  Have you tried backing out of them?
>
>
> James Moseley
>
>
>
>
>
>              "Steve Holmes"
>              <sholmes42 at mac.co
>              m>                                                         To
>              Sent by:                  "RT Users"
>              rt-users-bounces@         <rt-users at lists.bestpractical.com>
>              lists.bestpractic                                          cc
>              al.com
>                                                                    Subject
>                                        [rt-users] Can't create new
>              03/07/2007 02:15          tickets, new problem
>              PM
>
>
>
>
>
>
>
>
>
> 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:
>
> error:   Transactions not supported by database at
>           /opt/perlsite/lib/site_perl/5.8.7/sun4-solaris/DBI.pm line 1668.
>
> context:
>
>           ...
>
>           1664:
>                       sub begin_work {
>           1665:
>                       my $dbh = shift;
>           1666:
>                       return $dbh->set_err(1, "Already in a transaction")
>           1667:
>                       unless $dbh->FETCH('AutoCommit');
>           1668:
>                       $dbh->STORE('AutoCommit', 0); # will croak if driver
>                       doesn't support it
>           1669:
>                       $dbh->STORE('BegunWork', 1); # trigger post
>                       commit/rollback action
>           1670:
>                       return 1;
>           1671:
>                       }
>           1672:
>
>           ...
>
>
>
> code     /opt/perlsite/lib/site_perl/5.8.7/sun4-solaris/DBI.pm:1668
> stack:   /opt/perlsite/lib/site_perl/5.8.7
>           /DBIx/SearchBuilder/Handle.pm:720
>           /opt/rt3/lib/RT/Ticket_Overlay.pm:564
>           /opt/rt3/lib/RT/Interface/Web.pm:446
>           /opt/rt3/share/html/Ticket/Display.html:103
>           /opt/rt3/share/html/Ticket/Create.html:300
>           /opt/rt3/share/html/autohandler:279
>
>
>
>
> 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.
>
> I checked the rt3.Transactions table on the mysql server it it is INNODB.
> Are there other tables to check?
>
> 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.
>
> Appreciate any ideas of where to look.
>
> Thanks,
> Steve Holmes
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
>


-- 
I believe I found the missing link between animal and civilized man. It is
us. -Konrad Lorenz, ethologist, Nobel laureate (1903-1989)

We in America do not have government by the majority. We have government by
the majority who participate. -Thomas Jefferson, third US president,
architect and author (1743-1826)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070307/0b3ae04a/attachment.htm>