[rt-users] RT cannot open database

[Stephen Carr]

Dear All

After restarting apache I am having trouble with the TR database - it is
not any SQL type database. The only modification was to add phpMyAdmin to
httpd.conf

The initial screen appears as per normal but when I click on Take an error
occurs - see below.

I can view tickets but cannot update / modify them. I tend to leave RT
running for days.

Version of RT is 3.6.1

Thanks
Stephen Carr

----------------------

error:   	Transactions not supported by database at
/usr/lib/perl5/site_perl/5.8.6/i486-linux-thread-multi/DBI.pm line 1657.
context:
...
1653:  	sub begin_work {
1654:  	my $dbh = shift;
1655:  	return $dbh->set_err(1, "Already in a transaction")
1656:  	unless $dbh->FETCH('AutoCommit');
1657:  	$dbh->STORE('AutoCommit', 0); # will croak if driver doesn't
support it
1658:  	$dbh->STORE('BegunWork', 1); # trigger post commit/rollback action
1659:  	return 1;
1660:  	}
1661:
...
code stack: 
	/usr/lib/perl5/site_perl/5.8.6/i486-linux-thread-multi/DBI.pm:1657
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm:720
/opt/rt3/lib/RT/Ticket_Overlay.pm:3044
/opt/rt3/lib/RT/Ticket_Overlay.pm:3111
/opt/rt3/share/html/Ticket/Display.html:128
/opt/rt3/share/html/autohandler:279

-------------------------------
The error trace is below.

The erro

Transactions not supported by database at
/usr/lib/perl5/site_perl/5.8.6/i486-linux-thread-multi/DBI.pm line 1657.


Trace begun at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Exceptions.pm
line 129
HTML::Mason::Exceptions::rethrow_exception('Transactions not supported by
database at /usr/lib/perl5/site_perl/5.8.6/i486-linux-thread-multi/DBI.pm
line 1657.^J') called at
/usr/lib/perl5/site_perl/5.8.6/i486-linux-thread-multi/DBI.pm line 1657
DBD::_::db::begin_work('DBI::db=HASH(0x9b61a04)') called at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 720
DBIx::SearchBuilder::Handle::BeginTransaction('RT::Handle=HASH(0x94ec500)')
called at /opt/rt3/lib/RT/Ticket_Overlay.pm line 3044
RT::Ticket::SetOwner('RT::Ticket=HASH(0x9edc74c)', 26, 'Take') called at
/opt/rt3/lib/RT/Ticket_Overlay.pm line 3111
RT::Ticket::Take('RT::Ticket=HASH(0x9edc74c)') called at
/opt/rt3/share/html/Ticket/Display.html line 128
HTML::Mason::Commands::__ANON__('Action', 'Take', 'id', 433, 'Action',
'Take', 'id', 433) called at
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9eb9824)',
'Action', 'Take', 'id', 433, 'Action', 'Take', 'id', 433) called at
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 1255
eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 1249
HTML::Mason::Request::comp(undef, undef, 'Action', 'Take', 'id', 433,
'Action', 'Take', 'id', 433) called at
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 916
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x9da0aec)',
'Action', 'Take', 'id', 433) called at /opt/rt3/share/html/autohandler
line 279
HTML::Mason::Commands::__ANON__('Action', 'Take', 'id', 433) called at
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9da7b9c)',
'Action', 'Take', 'id', 433) called at
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 1250
eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 1249
HTML::Mason::Request::comp(undef, undef, undef, 'Action', 'Take', 'id',
433) called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
461
eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 461
eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 413
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9da0aec)')
called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm line
167
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9da0aec)')
called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm line
817
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x94e62d0)',
'Apache=SCALAR(0x9e36168)') called at /opt/rt3/bin/webmux.pl line 123
eval {...} at /opt/rt3/bin/webmux.pl line 123
RT::Mason::handler('Apache=SCALAR(0x9e36168)') called at /dev/null line 0
eval {...} at /dev/null line 0

-- 
Stephen Carr
Computing Officer
School of Civil and Environmental Engineering
The University of Adelaide
Tel +618-8303-4313
Fax +618-8303-4359
Email sgcarr at civeng.adelaide.edu.au

CRICOS Provider Number 00123M
-----------------------------------------------------------
This email message is intended only for the addressee(s)and contains
information that may be confidential and/or copyright.  If you are not the
intended recipient please notify the sender by reply email and immediately
delete this email. Use, disclosure or reproduction of this email by anyone
other than the intended recipient(s) is strictly prohibited. No
representation is made that this email or any attachments are free of
viruses. Virus scanning is recommended and is the responsibility of the
recipient.