[rt-users] Problem with upgrade from 3.8.9 to 4.0.1

hubert depesz lubaczewski depesz at depesz.com
Sun Jun 26 12:53:51 EDT 2011


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:
1. what did I screw?
2. 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/



More information about the rt-users mailing list