DB upgrade errors from 3.8.9 to 4.0.4

Kim_Pedersen · January 25, 2012, 8:32pm

Hi everyone

I have a 3.8.9 RT RPM based (Mandriva) installation runnning on Postgres
that I wanted to upgrade to 4.0.4, and get away from RPM based
distribution of RT at the same time.

I downloaded the 4.0.4 tarball, resolved the dependencies, and ran
configure & make upgrade successfully, installing to the default and
clean location of /opt/rt4

I cloned the postgres rt3 database to rt4 beforehand using the following
commands:
CREATE DATABASE rt4 TEMPLATE rt3 ;
ALTER DATABASE rt4 OWNER TO rt ;

Then I ran make upgrade-database, and got the following output listed
below, which looks good until I get to 4.0.1 where it complains that
column “delegatedby” does not exist.

I can see others have posted on this list about the same problem when
upgrading, but they have been installing RT4 on top of their old RT3.

And from what I can gather from the database upgrade scripts,
“delegatedby” was dropped in version 3.9.3 (Based on Schema.Pg), so
should I just ignore the error output, or do you have any words of
wisomd/guidance on how to proceed from here?

Best regards,

Kim

Proceed [y/N]:y

Processing 3.8.9
Now inserting data.
Processing 3.9.1
Now inserting data.
Processing 3.9.2
Now inserting data.
Processing 3.9.3
Now populating database schema.
Processing 3.9.5
Now populating database schema.
Processing 3.9.6
Now populating database schema.
Processing 3.9.7
Now populating database schema.
Now inserting data.
Processing 3.9.8
Now populating database schema.
Now inserting data.
Processing 4.0.0rc2
Processing 4.0.0rc4
Now populating database schema.
Processing 4.0.0rc7
Now inserting data.
Processing 4.0.1
Now inserting database ACLs.
Now inserting data.
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT delegatedby FROM ACL WHERE id = ?’, 90) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x6e70ef0)’,
‘DelegatedBy’) called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm
line 627
RT::Record::__Value(‘RT::ACE=HASH(0x6e70ef0)’, ‘DelegatedBy’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '90…
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT main.* FROM ACL main WHERE
(main.DelegatedFrom = ‘90’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '90…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6c6b1d0)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6c6b1d0)’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x6c6b1d0)’) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x6c6b1d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x6c6b1d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [crit]: _DoSearch is not so successful as it
still needs redo search, won’t call _BuildHash
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm:319)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
'DELETE FROM ACL WHERE id=? ', 90) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1325

DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x6e70ef0)’) called
at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 153

DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x6e70ef0)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm
line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x6e70ef0)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: Use of uninitialized value in
subroutine entry at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1327.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm:1327)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x6e87730)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e87730)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e87730)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e87730)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x71a3958)’,
‘RT::Principal=HASH(0x71b7f90)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6e70ef0)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [error]: Invalid right. Couldn’t canonicalize
right ‘AdminAllPersonalGroups’
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm:553)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x6fdf128)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fdf128)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fdf128)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fdf128)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x6c70378)’,
‘RT::Principal=HASH(0x6c859c0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6e70ef0)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [error]: Invalid right. Couldn’t canonicalize
right ‘AdminAllPersonalGroups’
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm:553)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT delegatedby FROM ACL WHERE id = ?’, 94) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x6c56230)’,
‘DelegatedBy’) called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm
line 627
RT::Record::__Value(‘RT::ACE=HASH(0x6c56230)’, ‘DelegatedBy’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '94…
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT main.* FROM ACL main WHERE
(main.DelegatedFrom = ‘94’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '94…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6c42aa8)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6c42aa8)’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x6c42aa8)’) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x6c42aa8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x6c42aa8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [crit]: _DoSearch is not so successful as it
still needs redo search, won’t call _BuildHash
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm:319)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
'DELETE FROM ACL WHERE id=? ', 94) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1325

DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x6c56230)’) called
at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 153

DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x6c56230)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm
line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x6c56230)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: Use of uninitialized value in
subroutine entry at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1327.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm:1327)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x6eb8910)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6eb8910)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x6eb8910)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6eb8910)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x700aba8)’,
‘RT::Principal=HASH(0x35a41a0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6c56230)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [error]: Invalid right. Couldn’t canonicalize
right ‘AdminOwnPersonalGroups’
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm:553)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x6e98e10)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e98e10)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e98e10)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e98e10)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x7194270)’,
‘RT::Principal=HASH(0x70cebc0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6c56230)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [error]: Invalid right. Couldn’t canonicalize
right ‘AdminOwnPersonalGroups’
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm:553)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT delegatedby FROM ACL WHERE id = ?’, 101) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x6fdef30)’,
‘DelegatedBy’) called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm
line 627
RT::Record::__Value(‘RT::ACE=HASH(0x6fdef30)’, ‘DelegatedBy’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '10…
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT main.* FROM ACL main WHERE
(main.DelegatedFrom = ‘101’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '10…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [crit]: _DoSearch is not so successful as it
still needs redo search, won’t call _BuildHash
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm:319)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
'DELETE FROM ACL WHERE id=? ', 101) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1325

DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x6fdef30)’) called
at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 153

DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x6fdef30)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm
line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x6fdef30)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: Use of uninitialized value in
subroutine entry at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1327.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm:1327)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x6fe68d0)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fe68d0)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fe68d0)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fe68d0)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x71b7f90)’,
‘RT::Principal=HASH(0x2c55410)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6fdef30)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT DISTINCT main.* FROM
CachedGroupMembers main JOIN Principals Principals_1 ON (
Principals_1.id = main.MemberId ) WHERE (main.GroupId = ‘106’) AND
(Principals_1.PrincipalType = ‘User’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT DISTINCT main.* FROM CachedGroupMembers main JOIN Prin…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235

DBIx::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x70ef4a0)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320

RT::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x70ef4a0)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503

DBIx::SearchBuilder::Next(‘RT::CachedGroupMembers=HASH(0x70ef4a0)’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1230

RT::Group::_CleanupInvalidDelegations(‘RT::Group=HASH(0x6ec6960)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Principal_Overlay.pm line 249

RT::Principal::_CleanupInvalidDelegations(‘RT::Principal=HASH(0x71c81d8)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT delegatedby FROM ACL WHERE id = ?’, 910) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x70f03d0)’,
‘DelegatedBy’) called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm
line 627
RT::Record::__Value(‘RT::ACE=HASH(0x70f03d0)’, ‘DelegatedBy’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '91…
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT main.* FROM ACL main WHERE
(main.DelegatedFrom = ‘910’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '91…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [crit]: _DoSearch is not so successful as it
still needs redo search, won’t call _BuildHash
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm:319)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
'DELETE FROM ACL WHERE id=? ', 910) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1325

DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x70f03d0)’) called
at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 153

DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x70f03d0)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm
line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x70f03d0)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: Use of uninitialized value in
subroutine entry at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1327.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm:1327)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x70c0218)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x70c0218)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x70c0218)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x70c0218)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x6ec31a0)’,
‘RT::Principal=HASH(0x70c5f40)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x70f03d0)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT DISTINCT main.* FROM
CachedGroupMembers main JOIN Principals Principals_1 ON (
Principals_1.id = main.MemberId ) WHERE (main.GroupId = ‘106’) AND
(Principals_1.PrincipalType = ‘User’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT DISTINCT main.* FROM CachedGroupMembers main JOIN Prin…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235

DBIx::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x70df5e8)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320

RT::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x70df5e8)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503

DBIx::SearchBuilder::Next(‘RT::CachedGroupMembers=HASH(0x70df5e8)’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1230

RT::Group::_CleanupInvalidDelegations(‘RT::Group=HASH(0x2c55410)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Principal_Overlay.pm line 249

RT::Principal::_CleanupInvalidDelegations(‘RT::Principal=HASH(0x7103508)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT delegatedby FROM ACL WHERE id = ?’, 918) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x6c5bf60)’,
‘DelegatedBy’) called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm
line 627
RT::Record::__Value(‘RT::ACE=HASH(0x6c5bf60)’, ‘DelegatedBy’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '91…
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT main.* FROM ACL main WHERE
(main.DelegatedFrom = ‘918’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '91…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6fef070)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6fef070)’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x6fef070)’) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x6fef070)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x6fef070)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [crit]: _DoSearch is not so successful as it
still needs redo search, won’t call _BuildHash
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm:319)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
'DELETE FROM ACL WHERE id=? ', 918) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1325

DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x6c5bf60)’) called
at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 153

DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x6c5bf60)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm
line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x6c5bf60)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: Use of uninitialized value in
subroutine entry at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1327.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm:1327)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x71a5ca0)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x71a5ca0)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x71a5ca0)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x71a5ca0)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x6c6b260)’,
‘RT::Principal=HASH(0x71ca138)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6c5bf60)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT DISTINCT main.* FROM
CachedGroupMembers main JOIN Principals Principals_1 ON (
Principals_1.id = main.MemberId ) WHERE (main.GroupId = ‘106’) AND
(Principals_1.PrincipalType = ‘User’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT DISTINCT main.* FROM CachedGroupMembers main JOIN Prin…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235

DBIx::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x71dc798)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320

RT::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x71dc798)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503

DBIx::SearchBuilder::Next(‘RT::CachedGroupMembers=HASH(0x71dc798)’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1230

RT::Group::_CleanupInvalidDelegations(‘RT::Group=HASH(0x71f45c0)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Principal_Overlay.pm line 249

RT::Principal::_CleanupInvalidDelegations(‘RT::Principal=HASH(0x6c8a968)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
Processing 4.0.3
Now inserting data.
Processing 4.0.4
Now inserting data.
Done.

Kevin_Falcone · January 25, 2012, 8:42pm

Hi everyone

I have a 3.8.9 RT RPM based (Mandriva) installation runnning on
Postgres that I wanted to upgrade to 4.0.4, and get away from RPM
based distribution of RT at the same time.

I downloaded the 4.0.4 tarball, resolved the dependencies, and ran
configure & make upgrade successfully, installing to the default and
clean location of /opt/rt4

I cloned the postgres rt3 database to rt4 beforehand using the
following commands:

CREATE DATABASE rt4 TEMPLATE rt3 ;
ALTER DATABASE rt4 OWNER TO rt ;

Then I ran make upgrade-database, and got the following output
listed below, which looks good until I get to 4.0.1 where it
complains that column “delegatedby” does not exist.

I can see others have posted on this list about the same problem
when upgrading, but they have been installing RT4 on top of their
old RT3.

And from what I can gather from the database upgrade scripts,
“delegatedby” was dropped in version 3.9.3 (Based on Schema.Pg), so
should I just ignore the error output, or do you have any words of
wisomd/guidance on how to proceed from here?

Your error appears to be because your 3.8 install is being loaded
along with the 4.0 install:

/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm:553)
etc etc, others trimmed.

ACE_Overlay.pm is a 3.8 file, it doesn’t exist in 4.0

You’ll need to remove the RPM install, use another server, or use
another perl to install 4.0 on this system (this is one of the many
problems with installing RT into the standard system perl paths, which
is the technique used by the RPMs).

Also, I wouldn’t trust that any part of the upgrade ran properly,
since having 3.8 libraries loaded on top of the 4.0 libraries
guarantees some failures.

-kevin

Kim_Pedersen · January 25, 2012, 8:50pm

Your error appears to be because your 3.8 install is being loaded
along with the 4.0 install:

/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm:553)
etc etc, others trimmed.

ACE_Overlay.pm is a 3.8 file, it doesn’t exist in 4.0

You’ll need to remove the RPM install, use another server, or use
another perl to install 4.0 on this system (this is one of the many
problems with installing RT into the standard system perl paths, which
is the technique used by the RPMs).

Also, I wouldn’t trust that any part of the upgrade ran properly,
since having 3.8 libraries loaded on top of the 4.0 libraries
guarantees some failures.

Hi Kevin,

Thanks for that - I had hoped to be able to run both installations side
by side on the same system, but what you say makes sense.

I’ll remove the RPM and re-install

Thanks again,

Kim

Kevin_Falcone · January 25, 2012, 9:07pm

Your error appears to be because your 3.8 install is being loaded
along with the 4.0 install:

/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm:553)
etc etc, others trimmed.

ACE_Overlay.pm is a 3.8 file, it doesn’t exist in 4.0

You’ll need to remove the RPM install, use another server, or use
another perl to install 4.0 on this system (this is one of the many
problems with installing RT into the standard system perl paths, which
is the technique used by the RPMs).

Also, I wouldn’t trust that any part of the upgrade ran properly,
since having 3.8 libraries loaded on top of the 4.0 libraries
guarantees some failures.

Thanks for that - I had hoped to be able to run both installations
side by side on the same system, but what you say makes sense.

I’ll remove the RPM and re-install

yeahhh, sorry about that. With two normal installs, you would be able
to do what you want. The Debian packages can also be run in parallel,
but the RPMs dump RT into @INC which pollutes the box for any other RT
installs.

You could build your own recent perl into /opt/perl and use that to
install RT.

-kevin

Kim_Pedersen · January 25, 2012, 8:18pm

Hi everyone

I have a 3.8.9 RT RPM based (Mandriva) installation runnning on Postgres
that I wanted to upgrade to 4.0.4, and get away from RPM based
distribution of RT at the same time.

I downloaded the 4.0.4 tarball, resolved the dependencies, and ran
configure & make upgrade successfully, installing to the default and
clean location of /opt/rt4

I cloned the postgres rt3 database to rt4 beforehand using the following
commands:
CREATE DATABASE rt4 TEMPLATE rt3 ;
ALTER DATABASE rt4 OWNER TO rt ;

Then I ran make upgrade-database, and got the following output listed
below, which looks good until I get to 4.0.1 where it complains that
column “delegatedby” does not exist.

I can see others have posted on this list about the same problem when
upgrading, but they have been installing RT4 on top of their old RT3.

And from what I can gather from the database upgrade scripts,
“delegatedby” was dropped in version 3.9.3 (Based on Schema.Pg), so
should I just ignore the error output, or do you have any words of
wisomd/guidance on how to proceed from here?

Best regards,

Kim

Proceed [y/N]:y

Processing 3.8.9
Now inserting data.
Processing 3.9.1
Now inserting data.
Processing 3.9.2
Now inserting data.
Processing 3.9.3
Now populating database schema.
Processing 3.9.5
Now populating database schema.
Processing 3.9.6
Now populating database schema.
Processing 3.9.7
Now populating database schema.
Now inserting data.
Processing 3.9.8
Now populating database schema.
Now inserting data.
Processing 4.0.0rc2
Processing 4.0.0rc4
Now populating database schema.
Processing 4.0.0rc7
Now inserting data.
Processing 4.0.1
Now inserting database ACLs.
Now inserting data.
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT delegatedby FROM ACL WHERE id = ?’, 90) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x6e70ef0)’,
‘DelegatedBy’) called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm
line 627
RT::Record::__Value(‘RT::ACE=HASH(0x6e70ef0)’, ‘DelegatedBy’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '90…
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT main.* FROM ACL main WHERE
(main.DelegatedFrom = ‘90’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '90…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6c6b1d0)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6c6b1d0)’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x6c6b1d0)’) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x6c6b1d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x6c6b1d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [crit]: _DoSearch is not so successful as it
still needs redo search, won’t call _BuildHash
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm:319)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
'DELETE FROM ACL WHERE id=? ', 90) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1325

DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x6e70ef0)’) called
at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 153

DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x6e70ef0)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm
line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x6e70ef0)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: Use of uninitialized value in
subroutine entry at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1327.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm:1327)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x6e87730)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e87730)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e87730)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e87730)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x71a3958)’,
‘RT::Principal=HASH(0x71b7f90)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6e70ef0)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [error]: Invalid right. Couldn’t canonicalize
right ‘AdminAllPersonalGroups’
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm:553)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x6fdf128)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fdf128)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fdf128)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fdf128)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x6c70378)’,
‘RT::Principal=HASH(0x6c859c0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6e70ef0)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6e70ef0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [error]: Invalid right. Couldn’t canonicalize
right ‘AdminAllPersonalGroups’
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm:553)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT delegatedby FROM ACL WHERE id = ?’, 94) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x6c56230)’,
‘DelegatedBy’) called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm
line 627
RT::Record::__Value(‘RT::ACE=HASH(0x6c56230)’, ‘DelegatedBy’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '94…
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT main.* FROM ACL main WHERE
(main.DelegatedFrom = ‘94’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '94…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6c42aa8)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6c42aa8)’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x6c42aa8)’) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x6c42aa8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x6c42aa8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [crit]: _DoSearch is not so successful as it
still needs redo search, won’t call _BuildHash
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm:319)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
'DELETE FROM ACL WHERE id=? ', 94) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1325

DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x6c56230)’) called
at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 153

DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x6c56230)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm
line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x6c56230)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: Use of uninitialized value in
subroutine entry at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1327.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm:1327)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x6eb8910)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6eb8910)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x6eb8910)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6eb8910)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x700aba8)’,
‘RT::Principal=HASH(0x35a41a0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6c56230)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [error]: Invalid right. Couldn’t canonicalize
right ‘AdminOwnPersonalGroups’
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm:553)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x6e98e10)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e98e10)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e98e10)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6e98e10)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x7194270)’,
‘RT::Principal=HASH(0x70cebc0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6c56230)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c56230)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c56230)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [error]: Invalid right. Couldn’t canonicalize
right ‘AdminOwnPersonalGroups’
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm:553)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT delegatedby FROM ACL WHERE id = ?’, 101) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x6fdef30)’,
‘DelegatedBy’) called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm
line 627
RT::Record::__Value(‘RT::ACE=HASH(0x6fdef30)’, ‘DelegatedBy’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '10…
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT main.* FROM ACL main WHERE
(main.DelegatedFrom = ‘101’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '10…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [crit]: _DoSearch is not so successful as it
still needs redo search, won’t call _BuildHash
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm:319)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
'DELETE FROM ACL WHERE id=? ', 101) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1325

DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x6fdef30)’) called
at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 153

DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x6fdef30)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm
line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x6fdef30)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: Use of uninitialized value in
subroutine entry at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1327.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm:1327)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x6fe68d0)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fe68d0)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fe68d0)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x6fe68d0)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x71b7f90)’,
‘RT::Principal=HASH(0x2c55410)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6fdef30)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT DISTINCT main.* FROM
CachedGroupMembers main JOIN Principals Principals_1 ON (
Principals_1.id = main.MemberId ) WHERE (main.GroupId = ‘106’) AND
(Principals_1.PrincipalType = ‘User’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT DISTINCT main.* FROM CachedGroupMembers main JOIN Prin…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235

DBIx::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x70ef4a0)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320

RT::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x70ef4a0)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503

DBIx::SearchBuilder::Next(‘RT::CachedGroupMembers=HASH(0x70ef4a0)’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1230

RT::Group::_CleanupInvalidDelegations(‘RT::Group=HASH(0x6ec6960)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Principal_Overlay.pm line 249

RT::Principal::_CleanupInvalidDelegations(‘RT::Principal=HASH(0x71c81d8)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6fdef30)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT delegatedby FROM ACL WHERE id = ?’, 910) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x70f03d0)’,
‘DelegatedBy’) called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm
line 627
RT::Record::__Value(‘RT::ACE=HASH(0x70f03d0)’, ‘DelegatedBy’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '91…
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT main.* FROM ACL main WHERE
(main.DelegatedFrom = ‘910’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '91…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x70df3a8)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [crit]: _DoSearch is not so successful as it
still needs redo search, won’t call _BuildHash
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm:319)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
'DELETE FROM ACL WHERE id=? ', 910) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1325

DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x70f03d0)’) called
at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 153

DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x70f03d0)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm
line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x70f03d0)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: Use of uninitialized value in
subroutine entry at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1327.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm:1327)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x70c0218)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x70c0218)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x70c0218)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x70c0218)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x6ec31a0)’,
‘RT::Principal=HASH(0x70c5f40)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x70f03d0)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT DISTINCT main.* FROM
CachedGroupMembers main JOIN Principals Principals_1 ON (
Principals_1.id = main.MemberId ) WHERE (main.GroupId = ‘106’) AND
(Principals_1.PrincipalType = ‘User’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT DISTINCT main.* FROM CachedGroupMembers main JOIN Prin…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235

DBIx::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x70df5e8)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320

RT::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x70df5e8)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503

DBIx::SearchBuilder::Next(‘RT::CachedGroupMembers=HASH(0x70df5e8)’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1230

RT::Group::_CleanupInvalidDelegations(‘RT::Group=HASH(0x2c55410)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Principal_Overlay.pm line 249

RT::Principal::_CleanupInvalidDelegations(‘RT::Principal=HASH(0x7103508)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x70f03d0)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT delegatedby FROM ACL WHERE id = ?’, 918) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x6c5bf60)’,
‘DelegatedBy’) called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm
line 627
RT::Record::__Value(‘RT::ACE=HASH(0x6c5bf60)’, ‘DelegatedBy’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '91…
^ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT main.* FROM ACL main WHERE
(main.DelegatedFrom = ‘918’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '91…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6fef070)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x6fef070)’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x6fef070)’) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x6fef070)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x6fef070)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [crit]: _DoSearch is not so successful as it
still needs redo search, won’t call _BuildHash
(/usr/lib/perl5/vendor_perl/5.10.1/RT/ACL_Overlay.pm:319)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
'DELETE FROM ACL WHERE id=? ', 918) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1325

DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x6c5bf60)’) called
at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 153

DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x6c5bf60)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm
line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x6c5bf60)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: Use of uninitialized value in
subroutine entry at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1327.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm:1327)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query ‘SELECT * FROM CachedGroupMembers WHERE
GroupId = ? AND MemberId = ?’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1206

DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::CachedGroupMember=HASH(0x71a5ca0)’,
‘SELECT * FROM CachedGroupMembers WHERE GroupId = ? AND Membe…’, 106,

called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1125

DBIx::SearchBuilder::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x71a5ca0)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Record/Cachable.pm
line 120

DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::CachedGroupMember=HASH(0x71a5ca0)’,
‘GroupId’, 106, ‘MemberId’, 1) called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::CachedGroupMember=HASH(0x71a5ca0)’,
‘MemberId’, 1, ‘GroupId’, 106) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1098
RT::Group::HasMemberRecursively(‘RT::Group=HASH(0x6c6b260)’,
‘RT::Principal=HASH(0x71ca138)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x6c5bf60)’, ‘RightName’) called
at /usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
[Wed Jan 25 18:23:30 2012] [warning]: DBD::Pg::st execute failed:
ERROR: current transaction is aborted, commands ignored until end of
transaction block at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587)
[Wed Jan 25 18:23:30 2012] [warning]: RT::Handle=HASH(0x71d00c8)
couldn’t execute the query 'SELECT DISTINCT main.* FROM
CachedGroupMembers main JOIN Principals Principals_1 ON (
Principals_1.id = main.MemberId ) WHERE (main.GroupId = ‘106’) AND
(Principals_1.PrincipalType = ‘User’) ’ at
/usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x71d00c8)’,
‘SELECT DISTINCT main.* FROM CachedGroupMembers main JOIN Prin…’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 235

DBIx::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x71dc798)’)
called at /home/kim/src/rt-4.0.4/sbin/…/lib/RT/SearchBuilder.pm line 320

RT::SearchBuilder::_DoSearch(‘RT::CachedGroupMembers=HASH(0x71dc798)’)
called at /usr/lib/perl5/site_perl/5.10.1/DBIx/SearchBuilder.pm line 503

DBIx::SearchBuilder::Next(‘RT::CachedGroupMembers=HASH(0x71dc798)’)
called at /usr/lib/perl5/vendor_perl/5.10.1/RT/Group_Overlay.pm line 1230

RT::Group::_CleanupInvalidDelegations(‘RT::Group=HASH(0x71f45c0)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/Principal_Overlay.pm line 249

RT::Principal::_CleanupInvalidDelegations(‘RT::Principal=HASH(0x6c8a968)’,
‘InsideTransaction’, 1) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
/usr/lib/perl5/vendor_perl/5.10.1/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x6c5bf60)’) called at
./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at
/home/kim/src/rt-4.0.4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x71d00c8)’,
‘./etc/upgrade/4.0.1/content’, undef) called at sbin/rt-setup-database
line 293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’,
undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’,
‘backcompat’, …) called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘postgres’) called at sbin/rt-setup-database line 198
(/usr/lib/perl5/5.10.1/Carp.pm:47)
Processing 4.0.3
Now inserting data.
Processing 4.0.4
Now inserting data.
Done.

Kim_Pedersen · January 25, 2012, 9:22pm

Thanks for that - I had hoped to be able to run both installations
side by side on the same system, but what you say makes sense.

I’ll remove the RPM and re-install
yeahhh, sorry about that. With two normal installs, you would be able
to do what you want. The Debian packages can also be run in parallel,
but the RPMs dump RT into @INC which pollutes the box for any other RT
installs.

You could build your own recent perl into /opt/perl and use that to
install RT.

No problem - it all worked like a charm.

I removed the 2 RPMs (rpm -e rt rt-mailgate), cloned the rt3 database to
again, and when I ran “make upgrade-database” it passed with flying colors.

If I need to roll back I can re-install the RPMs and re-instate the
configs, but hopefull that won’t be necessary

Kim

DB upgrade errors from 3.8.9 to 4.0.4

I cloned the postgres rt3 database to rt4 beforehand using the following commands:

CREATE DATABASE rt4 TEMPLATE rt3 ; ALTER DATABASE rt4 OWNER TO rt ;

I cloned the postgres rt3 database to rt4 beforehand using the
following commands:

CREATE DATABASE rt4 TEMPLATE rt3 ;
ALTER DATABASE rt4 OWNER TO rt ;