RT cannot open database

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@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.

And you’re 100% certain that phpMyAdmin didn’t muck-up
your MySQL? Because restarting apache won’t modify perl
modules…

Cheers,
Andrej

Dear Andrej

The data seems to be installed in ibdata1 in the /var/lib/mysql - I
installed rt at the beginning of the year and if I remember correctly I
could not use MySQL as it was not version 5.x

I notice the session.MYD and session.MYI in the rt3 directory are active
ie recent time stamps.

Could the problem be related to session files as I am seeing this in the
apache error_log

[Mon Nov 6 13:10:38 2006] [error] Can’t locate object method
“TIESCALAR” via package “DBI::st” at
/usr/lib/perl5/site_perl/5.8.6/i486-linux-thread-multi/DBI.pm line 1178.\n
Use of uninitialized value in subroutine entry at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 105.
Use of uninitialized value in subroutine entry at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 465.

This is with latest DBI-1.53 I may an older version.

Thanks
Stephen Carr

Andrej Ricnik-Bay wrote:

And you’re 100% certain that phpMyAdmin didn’t muck-up
your MySQL? Because restarting apache won’t modify perl
modules…

Cheers,
Andrej

Stephen Carr
Computing Officer
School of Civil and Environmental Engineering
The University of Adelaide
Tel +618-8303-4313
Fax +618-8303-4359
Email sgcarr@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.

Dear Chaim

phpMyAdmin did not request a root password - I installed it to manage
the DSPAM database.

I am getting the following in rt.log (the time is incorrect) see below.

I upgraded to DBI-1.53 I indicated to another post I eill rool back to
an earlier version. Also the data is in ibdata1 but the sessions are
stored in rt3/sessions.MY*

Thanks
Stephen Carr

[Mon Nov 6 07:40:05 2006] [warning]: Use of uninitialized value in
substitution (s///) at /opt/rt3/lib/RT/Interface/Web.pm line 617.
(/opt/rt3/lib/RT/Interface/Web.pm:617)
[Mon Nov 6 07:40:05 2006] [warning]: rollback ineffective with
AutoCommit enabled at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 758.
(/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm:758)
[Mon Nov 6 07:40:05 2006] [warning]: Rollback ineffective while
AutoCommit is on at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 758.
(/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm:758)
[Mon Nov 6 07:40:05 2006] [warning]: DBD::mysql::db rollback failed:
Rollback ineffective while AutoCommit is on at
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 758.
(/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm:758)
[Mon Nov 6 07:40:05 2006] [crit]: Transaction not committed. Usually
indicates a software fault.Data loss may have occurred
(/opt/rt3/lib/RT/Interface/Web/Handler.pm:194)

Regards
Stephen Carr
Chaim Rieger wrote:

Stephen Carr wrote:

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

is mysql running, does ~/rt/var/log/rt.log show anything, are
permissions set properly in the rt dir,

let me make a stab at the following secnario

you installed phpmyadmin, it warned you that there is no root password,
so you created one ?

Stephen Carr
Computing Officer
School of Civil and Environmental Engineering
The University of Adelaide
Tel +618-8303-4313
Fax +618-8303-4359
Email sgcarr@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.