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 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT [Transactions] failing after Fedora upgrade
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, -Jay -Original Message- From: Agnislav Onufrijchuk [mailto:agnislav.onufrijc...@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 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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
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.onufrijc...@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 1674. What DBD::mysql version do you use? Do you have InnoDB engine enabled in your my.cnf ? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT [Transactions] failing after Fedora upgrade
I can try removing DBD/DBI with Yum and then building the packages manually. Shouldn't take too long ;) Thanks, -Jay -Original Message- From: Drew Barnes [mailto:barne...@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.onufrijc...@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 1674. What DBD::mysql version do you use? Do you have InnoDB engine enabled in your my.cnf ? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT [Transactions] failing after Fedora upgrade
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 :) Thanks! -Jay -Original Message- From: Drew Barnes [mailto:barne...@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.onufrijc...@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 1674. What DBD::mysql version do you use? Do you have InnoDB engine enabled in your my.cnf ? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT [Transactions] failing after Fedora upgrade
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:173 From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@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: [r...@sfnix1 sbin]# su - rt_user [rt_u...@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_u...@sfnix1 ~]$ which perl /usr/local/bin/perl [rt_u...@sfnix1 ~]$ perl --version This is perl, v5.10.0 built for i386-linux-thread-multi [rt_u...@sfnix1 ~]$ which mysql /usr/bin/mysql [rt_u...@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 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com