RT mail failing after Fedora upgrade

RT Users
1

I had to reinstall a bunch of the perl packages after the FC upgrade to
FC9, now the rt-dependency check comes back clean, but this is the error
I get when I run fetchmail with the RT user:

[root@sfnix1 sbin]# su - rt_user
[rt_user@sfnix1 ~]$ fetchmail -s
RT server error.

The RT server which handled your email did not behave as expected. It
said:

Transactions not supported by database at
/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi/DBI.pm line
1674.

Stack:

[/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi/DBI.pm:1674]
[/usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm:720]
[/usr/local/rt3/lib/RT/Ticket_Overlay.pm:554]
[/usr/local/rt3/lib/RT/Interface/Email.pm:765]
[/usr/local/rt3/share/html/REST/1.0/NoAuth/mail-gateway:58]

fetchmail: MDA returned nonzero status 75
RT server error.

Machine info:
RT Version: 3.6.0
Linux sfnix1 2.6.27.25-78.2.56.fc9.i586 #1 SMP Thu Jun 18 12:14:31 EDT
2009 i686 i686 i386 GNU/Linux

[rt_user@sfnix1 ~]$ which perl
/usr/local/bin/perl
[rt_user@sfnix1 ~]$ perl --version

This is perl, v5.10.0 built for i386-linux-thread-multi

[rt_user@sfnix1 ~]$ which mysql
/usr/bin/mysql
[rt_user@sfnix1 ~]$ mysql --version
mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using readline
5.0

–Jay
–Director, Production Operations & IT
–Ecast

2

Correction, any database transaction is failing in RT (I didn’t try
that after the upgrade):

error:

Transactions not supported by database at
/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi/DBI.pm line
1674.

context:

…

1670:

sub begin_work {

1671:

my $dbh = shift;

1672:

return $dbh->set_err($DBI::stderr, “Already in a transaction”)

1673:

unless $dbh->FETCH(‘AutoCommit’);

1674:

$dbh->STORE(‘AutoCommit’, 0); # will croak if driver doesn’t support it

1675:

$dbh->STORE(‘BegunWork’, 1); # trigger post commit/rollback action

1676:

return 1;

1677:

}

1678:

…

code stack:

/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi/DBI.pm:1674
/usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm:720
/usr/local/rt3/lib/RT/Ticket_Overlay.pm:3024
/usr/local/rt3/lib/RT/Ticket_Overlay.pm:3091
/usr/local/rt3/share/html/Ticket/Display.html:124
/usr/local/rt3/local/html/autohandler:173From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jay
Vlavianos
Sent: Wednesday, July 08, 2009 12:09 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT mail failing after Fedora upgrade

I had to reinstall a bunch of the perl packages after the FC upgrade to
FC9, now the rt-dependency check comes back clean, but this is the error
I get when I run fetchmail with the RT user:

[root@sfnix1 sbin]# su - rt_user

[rt_user@sfnix1 ~]$ fetchmail -s

RT server error.

The RT server which handled your email did not behave as expected. It

said:

Transactions not supported by database at
/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi/DBI.pm line
1674.

Stack:

[/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi/DBI.pm:1674]

[/usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm:720]

[/usr/local/rt3/lib/RT/Ticket_Overlay.pm:554]

[/usr/local/rt3/lib/RT/Interface/Email.pm:765]

[/usr/local/rt3/share/html/REST/1.0/NoAuth/mail-gateway:58]

fetchmail: MDA returned nonzero status 75

RT server error.

Machine info:

RT Version: 3.6.0

Linux sfnix1 2.6.27.25-78.2.56.fc9.i586 #1 SMP Thu Jun 18 12:14:31 EDT
2009 i686 i686 i386 GNU/Linux

[rt_user@sfnix1 ~]$ which perl

/usr/local/bin/perl

[rt_user@sfnix1 ~]$ perl --version

This is perl, v5.10.0 built for i386-linux-thread-multi

[rt_user@sfnix1 ~]$ which mysql

/usr/bin/mysql

[rt_user@sfnix1 ~]$ mysql --version

mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using readline
5.0

–Jay

–Director, Production Operations & IT

–Ecast

3

Jay Vlavianos wrote:

Transactions not supported by database at
/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi/DBI.pm line 1674.

What DBD::mysql version do you use? Do you have InnoDB engine enabled in your
my.cnf ?

Agnislav Onufrijchuk
PortaOne, Inc., RT Developer
Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7670

Meet us at ITEXPO West 2009
September 2-3, Booth 427
Los Angeles Convention Center

4

Thanks for responding:

Rpm -qa reports : perl-DBD-MySQL-4.005-8.fc9.i386
All tables in the rt3 database are InnoDB except sessions

I don’t have a my.cnf so mysql is loading with defaults, but since the
DB is InnoDB I would imagine that it is running?

Thanks,
-JayFrom: Agnislav Onufrijchuk [mailto:Agnislav.Onufrijchuk@portaone.com]
Sent: Thursday, July 09, 2009 12:27 AM
To: Jay Vlavianos
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT [Transactions] failing after Fedora upgrade

Jay Vlavianos wrote:

Transactions not supported by database at
/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi/DBI.pm line

What DBD::mysql version do you use? Do you have InnoDB engine enabled in
your
my.cnf ?

Agnislav Onufrijchuk
PortaOne, Inc., RT Developer
Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7670

Meet us at ITEXPO West 2009
September 2-3, Booth 427
Los Angeles Convention Center

5

Jay Vlavianos wrote:

Thanks for responding:

Rpm -qa reports : perl-DBD-MySQL-4.005-8.fc9.i386

I suspect you may need to rebuild DBD::mysql and/or DBI. This is why
yum/rpm never touches perl on my systems. It never does anything GOOD,
it only breaks things. Package management is fine if you never need to
install anything any other way, but if you need to touch cpan even once,
you’re likely hosed after each update.

6

I can try removing DBD/DBI with Yum and then building the packages
manually. Shouldn’t take too long :wink:

Thanks,
-JayFrom: Drew Barnes [mailto:barnesaw@ucrwcu.rwc.uc.edu]
Sent: Thursday, July 09, 2009 11:46 AM
To: Jay Vlavianos
Cc: Agnislav Onufrijchuk; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT [Transactions] failing after Fedora upgrade

Jay Vlavianos wrote:

Thanks for responding:

Rpm -qa reports : perl-DBD-MySQL-4.005-8.fc9.i386

I suspect you may need to rebuild DBD::mysql and/or DBI. This is why
yum/rpm never touches perl on my systems. It never does anything GOOD,
it only breaks things. Package management is fine if you never need to
install anything any other way, but if you need to touch cpan even once,

you’re likely hosed after each update.

All tables in the rt3 database are InnoDB except sessions

I don’t have a my.cnf so mysql is loading with defaults, but since the
DB is InnoDB I would imagine that it is running?

Thanks,
-Jay

-----Original Message-----
From: Agnislav Onufrijchuk [mailto:Agnislav.Onufrijchuk@portaone.com]
Sent: Thursday, July 09, 2009 12:27 AM
To: Jay Vlavianos
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT [Transactions] failing after Fedora upgrade

Jay Vlavianos wrote:

Transactions not supported by database at
/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi/DBI.pm line

What DBD::mysql version do you use? Do you have InnoDB engine enabled
in
your
my.cnf ?

7

Ok, just to close this out (for the digest & history). I did a :

yum remove perl-DBD-MySQL
cpan && get DBD-mysql
configure, make and makeinstall DBD-mysql from the /root/.cpan/build
directory
I had to skip the make test for some reason because it would hang… but
RT is back up and running now.

I will need to be very careful from now on with yum. Heretofore I have
had no problems at all with yum, in fact I have used yum to upgrade my
Fedora core to each new distro release with virtually no pain at all.

Well, now I am a little gun-shy :slight_smile:

Thanks!
-JayFrom: Drew Barnes [mailto:barnesaw@ucrwcu.rwc.uc.edu]
Sent: Thursday, July 09, 2009 11:46 AM
To: Jay Vlavianos
Cc: Agnislav Onufrijchuk; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT [Transactions] failing after Fedora upgrade

Jay Vlavianos wrote:

Thanks for responding:

Rpm -qa reports : perl-DBD-MySQL-4.005-8.fc9.i386

I suspect you may need to rebuild DBD::mysql and/or DBI. This is why
yum/rpm never touches perl on my systems. It never does anything GOOD,
it only breaks things. Package management is fine if you never need to
install anything any other way, but if you need to touch cpan even once,

you’re likely hosed after each update.

All tables in the rt3 database are InnoDB except sessions

I don’t have a my.cnf so mysql is loading with defaults, but since the
DB is InnoDB I would imagine that it is running?

Thanks,
-Jay

-----Original Message-----
From: Agnislav Onufrijchuk [mailto:Agnislav.Onufrijchuk@portaone.com]
Sent: Thursday, July 09, 2009 12:27 AM
To: Jay Vlavianos
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT [Transactions] failing after Fedora upgrade

Jay Vlavianos wrote:

Transactions not supported by database at
/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi/DBI.pm line

What DBD::mysql version do you use? Do you have InnoDB engine enabled
in
your
my.cnf ?