Apache hanging on RT 3.6


#1

I have RT 3.6 installed on a Debian Lenny system. After logging in to
RT, I get the following in my syslog:

Jun 30 14:38:56 darwin RT: RT::Handle=HASH(0xd0eddf8) couldn’t execute
the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectType =
‘RT::System’) AND (main.ObjectId = 1) ’ at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 518
^IDBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xd0eddf8)’,
‘SELECT main.* FROM Attributes main WHERE (main.ObjectType = …’)
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 238
^IDBIx::SearchBuilder::_DoSearch(‘RT::Attributes=HASH(0xd543dd8)’)
called at /usr/share/request-tracker3.6/lib/RT/Attributes_Overlay.pm
line 73 ^IRT::Attributes::_DoSearch(‘RT::Attributes=HASH(0xd543dd8)’)
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 498
^IDBIx::SearchBuilder::Next(‘RT::Attributes=HASH(0xd543dd8)’) called at
/usr/share/request-tracker3.6/lib/RT/Attributes_Overlay.pm line 81
^IRT::Attributes::_BuildAccessTable(‘RT::Attributes=HASH(0xd543dd8)’)
called at /usr/share/request-tracker3.6/lib/RT/Attributes_Overlay.pm
line 74 ^IRT::Attributes::_DoSearch('RT::Attri

after which the browser just hangs waiting for a response from RT.

I think I’ve followed all the installation instructions. I installed the
package that’s in the Debian repository.

Any ideas?

Regards,
Tony.
Tony Arnold, Tel: +44 (0) 161 275 6093
Head of IT Security, Fax: +44 (0) 870 136 1004
University of Manchester, Mob: +44 (0) 773 330 0039
Manchester M13 9PL. Email: tony.arnold@manchester.ac.uk


#2

Following on from below, the database I’m using was created with RT
3.0.12. Some investigations shows the table ‘Attributes’ does not exist.
I’ve seen some info about upgrading the database. Will this stop it
working from an RT 3.0.12 system?

Regards,
Tony.

Tony Arnold wrote:

I have RT 3.6 installed on a Debian Lenny system. After logging in to
RT, I get the following in my syslog:

Jun 30 14:38:56 darwin RT: RT::Handle=HASH(0xd0eddf8) couldn’t execute
the query 'SELECT main.* FROM Attributes main WHERE (main.ObjectType =
‘RT::System’) AND (main.ObjectId = 1) ’ at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 518
^IDBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0xd0eddf8)’,
‘SELECT main.* FROM Attributes main WHERE (main.ObjectType = …’)
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 238
^IDBIx::SearchBuilder::_DoSearch(‘RT::Attributes=HASH(0xd543dd8)’)
called at /usr/share/request-tracker3.6/lib/RT/Attributes_Overlay.pm
line 73 ^IRT::Attributes::_DoSearch(‘RT::Attributes=HASH(0xd543dd8)’)
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 498
^IDBIx::SearchBuilder::Next(‘RT::Attributes=HASH(0xd543dd8)’) called at
/usr/share/request-tracker3.6/lib/RT/Attributes_Overlay.pm line 81
^IRT::Attributes::_BuildAccessTable(‘RT::Attributes=HASH(0xd543dd8)’)
called at /usr/share/request-tracker3.6/lib/RT/Attributes_Overlay.pm
line 74 ^IRT::Attributes::_DoSearch('RT::Attri

after which the browser just hangs waiting for a response from RT.

I think I’ve followed all the installation instructions. I installed the
package that’s in the Debian repository.

Any ideas?

Regards,
Tony.

Tony Arnold, Tel: +44 (0) 161 275 6093
Head of IT Security, Fax: +44 (0) 870 136 1004
University of Manchester, Mob: +44 (0) 773 330 0039
Manchester M13 9PL. Email: tony.arnold@manchester.ac.uk