Problem with upgrade from 3.8.9 to 4.0.1

hubert_depesz_lubacz · June 26, 2011, 4:53pm

Hi,
downloaded fresh 4.0.1
did:
./configure --enable-graphviz --enable-gd --with-db-type=Pg --with-web-user=www-data --with-web-group=www-data --with-rt-group=www-data
make testdeps
make fixdeps
make testdeps
make upgrade

so far everything worked.

I had my previous pg in /opt/rt3, but for upgrade purposes I did cp -av
/opt/rt3 /opt/rt4

database was the same (had backup luckily).

Then I entered database upgrade, and got:

=# /opt/rt4/sbin/rt-setup-database --prompt-for-dba-password --action upgrade
Subroutine IsGroup redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 76.
Subroutine IsUser redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 96.
Subroutine Object redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 116.
Subroutine GrantRight redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 153.
Subroutine RevokeRight redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 190.
Subroutine HasRight redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 282.
Subroutine _HasRight redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 372.
Subroutine _HasGroupRight redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 390.
Subroutine _HasRoleRight redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 444.
Subroutine RolesWithRight redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 516.
Subroutine InvalidateACLCache redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 581.
Subroutine _GetPrincipalTypeForACL redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 602.
Subroutine _ReferenceId redefined at /opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm line 628.
Subroutine _InitSQL redefined at /opt/rt4/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 64.
Subroutine _SQLLimit redefined at /opt/rt4/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 77.
Subroutine _SQLJoin redefined at /opt/rt4/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 96.
Subroutine _OpenParen redefined at /opt/rt4/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 106.
Subroutine _CloseParen redefined at /opt/rt4/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 109.
Subroutine _close_bundle redefined at /opt/rt4/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 140.
Subroutine _parser redefined at /opt/rt4/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 171.
Subroutine ClausesToSQL redefined at /opt/rt4/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 247.
Subroutine FromSQL redefined at /opt/rt4/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 282.
Subroutine Query redefined at /opt/rt4/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 348.
Subroutine ClassifySQLOperation redefined at /opt/rt4/sbin/…/lib/RT/Tickets_Overlay_SQL.pm line 365.
In order to create or update your RT database, this script needs to connect to your Pg instance on localhost as postgres
Please specify that user’s database password below. If the user has no database
password, just press return.

Password:
Working with:
Type: Pg
Host: localhost
Name: rt
User: rt
DBA: postgres
Enter RT version you’re upgrading from: 3.8.9

Going to apply following upgrades:

3.9.1
3.9.2
3.9.3
3.9.5
3.9.6
3.9.7
3.9.8
4.0.0rc2
4.0.0rc4
4.0.0rc7
4.0.1

Enter RT version if you want to stop upgrade at some point,
or leave it blank if you want apply above upgrades:

IT’S VERY IMPORTANT TO BACK UP BEFORE THIS STEP

Proceed [y/N]:y
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.
[Sun Jun 26 16:45:17 2011] [error]: We found RTFM tables in your database. Checking for content. (./etc/upgrade/3.9.8/content:17)
[Sun Jun 26 16:45:17 2011] [error]: You appear to have RTFM Articles. You can upgrade using the etc/upgrade/upgrade-articles script. Read more about it in UPGRADING (./etc/upgrade/3.9.8/content:22)
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.
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT delegatedby FROM ACL WHERE id = ?’, 712) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x4c02280)’, ‘DelegatedBy’) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 627
RT::Record::__Value(‘RT::ACE=HASH(0x4c02280)’, ‘DelegatedBy’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x4c02280)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '71…
^ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query 'SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = ‘712’) ’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '71…’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x4ed86d8)’) called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x4ed86d8)’) called at /opt/rt4/sbin/…/lib/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x4ed86d8)’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x4ed86d8)’) called at /opt/rt4/sbin/…/lib/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x4ed86d8)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x4c02280)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x4c02280)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [crit]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildHash (/opt/rt4/sbin/…/lib/RT/ACL_Overlay.pm:319)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, 'DELETE FROM ACL WHERE id=? ', 712) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1325
DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x4c02280)’) called at /usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 153
DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x4c02280)’) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x4c02280)’) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x4c02280)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x4c02280)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x4c02280)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [warning]: Use of uninitialized value in subroutine entry at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1327. (/usr/share/perl5/DBIx/SearchBuilder/Record.pm:1327)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query ‘SELECT * FROM Principals WHERE id = ?’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1206
DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Principal=HASH(0x3084c68)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1125
DBIx::SearchBuilder::Record::LoadByCols(‘RT::Principal=HASH(0x3084c68)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 120
DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::Principal=HASH(0x3084c68)’, ‘id’, 3097) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::Principal=HASH(0x3084c68)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1140
DBIx::SearchBuilder::Record::LoadById(‘RT::Principal=HASH(0x3084c68)’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1056
DBIx::SearchBuilder::Record::Load(‘RT::Principal=HASH(0x3084c68)’, 3097) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 622
RT::ACE::PrincipalObj(‘RT::ACE=HASH(0x4c02280)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x4c02280)’, ‘RightName’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x4c02280)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x4c02280)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x4c02280)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [err]: ACE 712 couldn’t load its principal object (/opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm:625)
[Sun Jun 26 16:45:31 2011] [error]: Invalid right. Couldn’t canonicalize right ‘AdminAllPersonalGroups’ (/opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm:553)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query ‘SELECT * FROM Principals WHERE id = ?’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1206
DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Principal=HASH(0x309d358)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1125
DBIx::SearchBuilder::Record::LoadByCols(‘RT::Principal=HASH(0x309d358)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 120
DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::Principal=HASH(0x309d358)’, ‘id’, 3097) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::Principal=HASH(0x309d358)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1140
DBIx::SearchBuilder::Record::LoadById(‘RT::Principal=HASH(0x309d358)’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1056
DBIx::SearchBuilder::Record::Load(‘RT::Principal=HASH(0x309d358)’, 3097) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 622
RT::ACE::PrincipalObj(‘RT::ACE=HASH(0x4c02280)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x4c02280)’, ‘RightName’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x4c02280)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x4c02280)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x4c02280)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [err]: ACE 712 couldn’t load its principal object (/opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm:625)
[Sun Jun 26 16:45:31 2011] [error]: Invalid right. Couldn’t canonicalize right ‘AdminAllPersonalGroups’ (/opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm:553)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT delegatedby FROM ACL WHERE id = ?’, 716) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x3b59f00)’, ‘DelegatedBy’) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 627
RT::Record::__Value(‘RT::ACE=HASH(0x3b59f00)’, ‘DelegatedBy’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x3b59f00)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '71…
^ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query 'SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = ‘716’) ’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '71…’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x4ea0078)’) called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x4ea0078)’) called at /opt/rt4/sbin/…/lib/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x4ea0078)’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x4ea0078)’) called at /opt/rt4/sbin/…/lib/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x4ea0078)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x3b59f00)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x3b59f00)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [crit]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildHash (/opt/rt4/sbin/…/lib/RT/ACL_Overlay.pm:319)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, 'DELETE FROM ACL WHERE id=? ', 716) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1325
DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x3b59f00)’) called at /usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 153
DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x3b59f00)’) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x3b59f00)’) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x3b59f00)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x3b59f00)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x3b59f00)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [warning]: Use of uninitialized value in subroutine entry at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1327. (/usr/share/perl5/DBIx/SearchBuilder/Record.pm:1327)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query ‘SELECT * FROM Principals WHERE id = ?’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1206
DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Principal=HASH(0x3b59c48)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1125
DBIx::SearchBuilder::Record::LoadByCols(‘RT::Principal=HASH(0x3b59c48)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 120
DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::Principal=HASH(0x3b59c48)’, ‘id’, 3097) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::Principal=HASH(0x3b59c48)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1140
DBIx::SearchBuilder::Record::LoadById(‘RT::Principal=HASH(0x3b59c48)’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1056
DBIx::SearchBuilder::Record::Load(‘RT::Principal=HASH(0x3b59c48)’, 3097) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 622
RT::ACE::PrincipalObj(‘RT::ACE=HASH(0x3b59f00)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x3b59f00)’, ‘RightName’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x3b59f00)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x3b59f00)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x3b59f00)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [err]: ACE 716 couldn’t load its principal object (/opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm:625)
[Sun Jun 26 16:45:31 2011] [error]: Invalid right. Couldn’t canonicalize right ‘AdminOwnPersonalGroups’ (/opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm:553)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query ‘SELECT * FROM Principals WHERE id = ?’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1206
DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Principal=HASH(0x309d4a8)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1125
DBIx::SearchBuilder::Record::LoadByCols(‘RT::Principal=HASH(0x309d4a8)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 120
DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::Principal=HASH(0x309d4a8)’, ‘id’, 3097) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::Principal=HASH(0x309d4a8)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1140
DBIx::SearchBuilder::Record::LoadById(‘RT::Principal=HASH(0x309d4a8)’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1056
DBIx::SearchBuilder::Record::Load(‘RT::Principal=HASH(0x309d4a8)’, 3097) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 622
RT::ACE::PrincipalObj(‘RT::ACE=HASH(0x3b59f00)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x3b59f00)’, ‘RightName’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x3b59f00)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x3b59f00)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x3b59f00)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [err]: ACE 716 couldn’t load its principal object (/opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm:625)
[Sun Jun 26 16:45:31 2011] [error]: Invalid right. Couldn’t canonicalize right ‘AdminOwnPersonalGroups’ (/opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm:553)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: column “delegatedby” does not exist
LINE 1: SELECT delegatedby FROM ACL WHERE id = $1
^ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query ‘SELECT delegatedby FROM ACL WHERE id = ?’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT delegatedby FROM ACL WHERE id = ?’, 726) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 714
DBIx::SearchBuilder::Record::__Value(‘RT::ACE=HASH(0x3b4f960)’, ‘DelegatedBy’) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 627
RT::Record::__Value(‘RT::ACE=HASH(0x3b4f960)’, ‘DelegatedBy’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 440
RT::ACE::Delete(‘RT::ACE=HASH(0x3b4f960)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: column main.delegatedfrom does not exist
LINE 1: SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '72…
^ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query 'SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = ‘726’) ’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT main.* FROM ACL main WHERE (main.DelegatedFrom = '72…’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 235
DBIx::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x30a9260)’) called at /opt/rt4/sbin/…/lib/RT/SearchBuilder.pm line 320
RT::SearchBuilder::_DoSearch(‘RT::ACL=HASH(0x30a9260)’) called at /opt/rt4/sbin/…/lib/RT/ACL_Overlay.pm line 316
RT::ACL::_DoSearch(‘RT::ACL=HASH(0x30a9260)’) called at /usr/share/perl5/DBIx/SearchBuilder.pm line 503
DBIx::SearchBuilder::Next(‘RT::ACL=HASH(0x30a9260)’) called at /opt/rt4/sbin/…/lib/RT/ACL_Overlay.pm line 283
RT::ACL::Next(‘RT::ACL=HASH(0x30a9260)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 467
RT::ACE::_Delete(‘RT::ACE=HASH(0x3b4f960)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x3b4f960)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [crit]: _DoSearch is not so successful as it still needs redo search, won’t call _BuildHash (/opt/rt4/sbin/…/lib/RT/ACL_Overlay.pm:319)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query 'DELETE FROM ACL WHERE id=? ’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, 'DELETE FROM ACL WHERE id=? ', 726) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1325
DBIx::SearchBuilder::Record::__Delete(‘RT::ACE=HASH(0x3b4f960)’) called at /usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 153
DBIx::SearchBuilder::Record::Cachable::__Delete(‘RT::ACE=HASH(0x3b4f960)’) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1305
DBIx::SearchBuilder::Record::Delete(‘RT::ACE=HASH(0x3b4f960)’) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 121
RT::Record::Delete(‘RT::ACE=HASH(0x3b4f960)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 478
RT::ACE::_Delete(‘RT::ACE=HASH(0x3b4f960)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x3b4f960)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [warning]: Use of uninitialized value in subroutine entry at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1327. (/usr/share/perl5/DBIx/SearchBuilder/Record.pm:1327)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query ‘SELECT * FROM Principals WHERE id = ?’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1206
DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Principal=HASH(0x309a8b0)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1125
DBIx::SearchBuilder::Record::LoadByCols(‘RT::Principal=HASH(0x309a8b0)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 120
DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::Principal=HASH(0x309a8b0)’, ‘id’, 3097) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::Principal=HASH(0x309a8b0)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1140
DBIx::SearchBuilder::Record::LoadById(‘RT::Principal=HASH(0x309a8b0)’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1056
DBIx::SearchBuilder::Record::Load(‘RT::Principal=HASH(0x309a8b0)’, 3097) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 622
RT::ACE::PrincipalObj(‘RT::ACE=HASH(0x3b4f960)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 650
RT::ACE::_Value(‘RT::ACE=HASH(0x3b4f960)’, ‘RightName’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 545
RT::ACE::RightName(‘RT::ACE=HASH(0x3b4f960)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x3b4f960)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x3b4f960)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [err]: ACE 726 couldn’t load its principal object (/opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm:625)
[Sun Jun 26 16:45:31 2011] [warning]: DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jun 26 16:45:31 2011] [warning]: RT::Handle=HASH(0x30ad6e0) couldn’t execute the query ‘SELECT * FROM Principals WHERE id = ?’ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x30ad6e0)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1206
DBIx::SearchBuilder::Record::_LoadFromSQL(‘RT::Principal=HASH(0x3098418)’, ‘SELECT * FROM Principals WHERE id = ?’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1125
DBIx::SearchBuilder::Record::LoadByCols(‘RT::Principal=HASH(0x3098418)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 120
DBIx::SearchBuilder::Record::Cachable::LoadByCols(‘RT::Principal=HASH(0x3098418)’, ‘id’, 3097) called at /opt/rt4/sbin/…/lib/RT/Record.pm line 381
RT::Record::LoadByCols(‘RT::Principal=HASH(0x3098418)’, ‘id’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1140
DBIx::SearchBuilder::Record::LoadById(‘RT::Principal=HASH(0x3098418)’, 3097) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1056
DBIx::SearchBuilder::Record::Load(‘RT::Principal=HASH(0x3098418)’, 3097) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 622
RT::ACE::PrincipalObj(‘RT::ACE=HASH(0x3b4f960)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 482
RT::ACE::_Delete(‘RT::ACE=HASH(0x3b4f960)’) called at /opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm line 447
RT::ACE::Delete(‘RT::ACE=HASH(0x3b4f960)’) called at ./etc/upgrade/4.0.1/content line 56
RT::Handle::ANON() called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
eval {…} called at /opt/rt4/sbin/…/lib/RT/Handle.pm line 767
RT::Handle::InsertData(‘RT::Handle=HASH(0x30ad6e0)’, ‘./etc/upgrade/4.0.1/content’, undef) called at /opt/rt4/sbin/rt-setup-database line 292
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef, ‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/4.0.1’, ‘backcompat’, …) called at /opt/rt4/sbin/rt-setup-database line 398
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’, ‘upgrade’, ‘dba’, ‘postgres’) called at /opt/rt4/sbin/rt-setup-database line 197 (/usr/share/perl/5.12/Carp.pm:65)
[Sun Jun 26 16:45:31 2011] [err]: ACE 726 couldn’t load its principal object (/opt/rt4/sbin/…/lib/RT/ACE_Overlay.pm:625)
[Sun Jun 26 16:45:31 2011] [warning]: Principal not loaded. (/opt/rt4/sbin/…/lib/RT/Principal_Overlay.pm:246)
[Sun Jun 26 16:45:31 2011] [warn]: Unable to delete ACE 726: Right could not be revoked (./etc/upgrade/4.0.1/content:60)
Done.

Despite reaching “Done” at the end, I think that something went wrong.

Questions are:

what did I screw?
how to fix it?

Best regards,

depesz

The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/

Alex_Vandiver · June 26, 2011, 9:03pm

so far everything worked.

I had my previous pg in /opt/rt3, but for upgrade purposes I did cp -av
/opt/rt3 /opt/rt4
[snip]
Questions are:

what did I screw?

From docs/UPGRADING-4.0:

    You really shouldn't install RT4 into your RT3 source tree
    (/opt/rt3) and instead should be using make install to set up a
    clean environment. This will allow you to evaluate your local
    modifications and configuration changes as you migrate to 4.0.
    
    If you choose to force RT to install into /opt/rt3, or another
    existing RT 3.x install location, you will encounter issues
    because we removed the _Overlay files (such as
    Ticket_Overlay.pm) and relocated other files.  You will need to
    manually remove these files after the upgrade or RT will fail.
    After making a complete backup of your /opt/rt3 install, you
    might use a command like the following to remove the _Overlay
    files:
    
        find /opt/rt3/lib/ -type f -name '*_Overlay*' -delete

Alex