Package: request-tracker4
Version: 4.2.8-1
Severity: serious
User: debian...@lists.debian.org
Usertags: piuparts

Hi,

during a test with piuparts I noticed your package fails to upgrade from
'wheezy'.
It installed fine in 'wheezy', then the upgrade to 'jessie' fails.

rt4-extension-assettracker is not in jessie due to
#748737: doesn't support RT 4.2

>From the attached log (scroll to the bottom...):

  Setting up request-tracker4 (4.2.8-1) ...
  **WARNING**  
  **WARNING**  If you are using mod_perl or any form of persistent perl
  **WARNING**  process such as FastCGI, you will need to restart your
  **WARNING**  web server and any persistent processes now.
  **WARNING**  
  **WARNING**  For mod_perl this means
  **WARNING**  
  **WARNING**  invoke-rc.d apache2 stop && invoke-rc.d apache2 start
  **WARNING**  
  **WARNING**  
  **WARNING**  If you are using mod_perl or any form of persistent perl
  **WARNING**  process such as FastCGI, you will need to restart your
  **WARNING**  web server and any persistent processes now.
  **WARNING**  
  **WARNING**  For mod_perl this means
  **WARNING**  
  **WARNING**  invoke-rc.d apache2 stop && invoke-rc.d apache2 start
  **WARNING**  
  dbconfig-common: writing config to /etc/dbconfig-common/request-tracker4.conf
  creating database backup in 
/var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u2.sqlite3.
  applying upgrade script for 4.0.7-5+deb7u2 -> 4.0.10.
  Working with:
  Type: SQLite
  Host: localhost
  Port: 
  Name: /var/lib/dbconfig-common/sqlite3/request-tracker4/rtdb
  User: 
  DBA:   (No DBA)
  Now inserting data.
  Done inserting data.
  Done.
  applying upgrade script for 4.0.7-5+deb7u2 -> 4.0.12.
  Working with:
  Type: SQLite
  Host: localhost
  Port: 
  Name: /var/lib/dbconfig-common/sqlite3/request-tracker4/rtdb
  User: 
  DBA:   (No DBA)
  Now populating database schema.
  Done.
  applying upgrade script for 4.0.7-5+deb7u2 -> 4.0.19.
  Working with:
  Type: SQLite
  Host: localhost
  Port: 
  Name: /var/lib/dbconfig-common/sqlite3/request-tracker4/rtdb
  User: 
  DBA:   (No DBA)
  Now inserting data.
  Done inserting data.
  Done.
  Working with:
  Type: SQLite
  Host: localhost
  Port: 
  Name: /var/lib/dbconfig-common/sqlite3/request-tracker4/rtdb
  User: 
  DBA:   (No DBA)
  Now inserting data.
  Done inserting data.
  Done.
  applying upgrade script for 4.0.7-5+deb7u2 -> 4.2.3.
  Working with:
  Type: SQLite
  Host: localhost
  Port: 
  Name: /var/lib/dbconfig-common/sqlite3/request-tracker4/rtdb
  User: 
  DBA:   (No DBA)
  Enter RT version you're upgrading from: 
  Going to apply following upgrades:
  * 4.1.0
  * 4.1.1
  * 4.1.4
  * 4.1.5
  * 4.1.6
  * 4.1.7
  * 4.1.8
  * 4.1.9
  * 4.1.10
  * 4.1.11
  * 4.1.12
  * 4.1.13
  * 4.1.14
  * 4.1.15
  * 4.1.16
  * 4.1.17
  * 4.1.18
  * 4.1.19
  * 4.1.20
  * 4.1.21
  * 4.1.22
  * 4.1.23
  * 4.2.1
  * 4.2.2
  * 4.2.4
  * 4.2.6
  * 4.2.7
  * 4.2.8
  
  Enter RT version if you want to stop upgrade at some point,
    or leave it blank if you want apply above upgrades: 
  Going to apply following upgrades:
  * 4.1.0
  * 4.1.1
  * 4.1.4
  * 4.1.5
  * 4.1.6
  * 4.1.7
  * 4.1.8
  * 4.1.9
  * 4.1.10
  * 4.1.11
  * 4.1.12
  * 4.1.13
  * 4.1.14
  * 4.1.15
  * 4.1.16
  * 4.1.17
  * 4.1.18
  * 4.1.19
  * 4.1.20
  * 4.1.21
  * 4.1.22
  * 4.1.23
  * 4.2.1
  * 4.2.2
  Processing 4.1.0
  Now inserting data.
  [24429] [Mon Dec 15 12:08:07 2014] [warning]: DBD::SQLite::db do failed: 
UNIQUE constraint failed: Groups.Name, Groups.Domain, Groups.Type, 
Groups.Instance at /usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat 
line 26, <> line 1. 
(/usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat:26)
  Processing 4.1.1
  Now populating database schema.
  Now inserting data.
  [24429] [Mon Dec 15 12:08:17 2014] [warning]: DBD::SQLite::db do failed: 
UNIQUE constraint failed: Groups.Name, Groups.Domain, Groups.Type, 
Groups.Instance at /usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat 
line 26, <> line 2. 
(/usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat:26)
  Processing 4.1.4
  Now populating database schema.
  Now inserting data.
  [24429] [Mon Dec 15 12:08:23 2014] [warning]: DBD::SQLite::db do failed: 
UNIQUE constraint failed: Groups.Name, Groups.Domain, Groups.Type, 
Groups.Instance at /usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat 
line 26, <> line 3. 
(/usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat:26)
  [24429] [Mon Dec 15 12:08:23 2014] [error]: Can't load role group AdminCc: 
Couldn't find row (/usr/share/request-tracker4/etc/upgrade/4.1.4/content:18)
  [24429] [Mon Dec 15 12:08:23 2014] [error]: Can't load role group Cc: 
Couldn't find row (/usr/share/request-tracker4/etc/upgrade/4.1.4/content:18)
  [24429] [Mon Dec 15 12:08:23 2014] [error]: Can't load role group Owner: 
Couldn't find row (/usr/share/request-tracker4/etc/upgrade/4.1.4/content:18)
  [24429] [Mon Dec 15 12:08:23 2014] [error]: Can't load role group Requestor: 
Couldn't find row (/usr/share/request-tracker4/etc/upgrade/4.1.4/content:18)
  Processing 4.1.5
  Now inserting data.
  [24429] [Mon Dec 15 12:08:28 2014] [warning]: DBD::SQLite::db do failed: 
UNIQUE constraint failed: Groups.Name, Groups.Domain, Groups.Type, 
Groups.Instance at /usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat 
line 26, <> line 4. 
(/usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat:26)
  Processing 4.1.6
  Now inserting data.
  [24429] [Mon Dec 15 12:08:33 2014] [warning]: DBD::SQLite::db do failed: 
UNIQUE constraint failed: Groups.Name, Groups.Domain, Groups.Type, 
Groups.Instance at /usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat 
line 26, <> line 5. 
(/usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat:26)
  Processing 4.1.7
  Now populating database schema.
  Processing 4.1.8
  Now populating database schema.
  Processing 4.1.9
  Now inserting data.
  [24429] [Mon Dec 15 12:08:38 2014] [warning]: DBD::SQLite::db do failed: 
UNIQUE constraint failed: Groups.Name, Groups.Domain, Groups.Type, 
Groups.Instance at /usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat 
line 26, <> line 6. 
(/usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat:26)
  Processing 4.1.10
  Processing 4.1.11
  Processing 4.1.12
  Now inserting data.
  [24429] [Mon Dec 15 12:08:43 2014] [warning]: DBD::SQLite::db do failed: 
UNIQUE constraint failed: Groups.Name, Groups.Domain, Groups.Type, 
Groups.Instance at /usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat 
line 26, <> line 7. 
(/usr/share/request-tracker4/etc/upgrade/4.1.13/backcompat:26)
  [24429] [Mon Dec 15 12:08:43 2014] [warning]: Use of uninitialized value in 
concatenation (.) or string at /usr/share/request-tracker4/lib/RT/Handle.pm 
line 1102, <> line 7. (/usr/share/request-tracker4/lib/RT/Handle.pm:1102)
  [24429] [Mon Dec 15 12:08:43 2014] [warning]: Use of uninitialized value in 
concatenation (.) or string at /usr/share/request-tracker4/lib/RT/Handle.pm 
line 1102, <> line 7. (/usr/share/request-tracker4/lib/RT/Handle.pm:1102)
  [24429] [Mon Dec 15 12:08:43 2014] [error]: Unable to load Group: GroupDomain 
=> SystemInternal, GroupId => , Queue =>  
(/usr/share/request-tracker4/lib/RT/Handle.pm:1102)
  Processing 4.1.13
  Now populating database schema.
  [24429] [Mon Dec 15 12:09:14 2014] [warning]: DBD::SQLite::st execute failed: 
database is locked at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 586. 
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
  [24429] [Mon Dec 15 12:09:14 2014] [warning]: RT::Handle=HASH(0x615e200) 
couldn't execute the query 'UPDATE Attributes SET LastUpdated=? WHERE id=? ' at 
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
        DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x615e200), 
"UPDATE Attributes SET LastUpdated=? WHERE id=? ", "2014-12-15 12:08:44", 6) 
called at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 453
        
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x615e200), 
"PrimaryKeys", HASH(0x6014c20), "Column", "LastUpdated", "IsSQLFunction", 
undef, "Value", "2014-12-15 12:08:44", ...) called at 
/usr/share/perl5/DBIx/SearchBuilder/Record.pm line 871
        DBIx::SearchBuilder::Record::__Set(RT::Attribute=HASH(0x699eae0), 
"Field", "LastUpdated", "Value", "2014-12-15 12:08:44") called at 
/usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 140
        
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Attribute=HASH(0x699eae0), 
"Field", "LastUpdated", "Value", "2014-12-15 12:08:44") called at 
/usr/share/request-tracker4/lib/RT/Record.pm line 549
        RT::Record::_SetLastUpdated(RT::Attribute=HASH(0x699eae0)) called at 
/usr/share/request-tracker4/lib/RT/Record.pm line 501
        RT::Record::_Set(RT::Attribute=HASH(0x699eae0), "Field", "Description", 
"Value", undef) called at /usr/share/request-tracker4/lib/RT/Attribute.pm line 
403
        RT::Attribute::_Set(RT::Attribute=HASH(0x699eae0), "Field", 
"Description", "Value", undef) called at 
/usr/share/perl5/DBIx/SearchBuilder/Record.pm line 439
        DBIx::SearchBuilder::Record::__ANON__(RT::Attribute=HASH(0x699eae0), 
undef) called at /usr/share/request-tracker4/lib/RT/Record.pm line 231
        RT::Record::SetAttribute(RT::System=HASH(0x697d940), "Name", 
"UpgradeHistory", "Content", HASH(0x69c5d68)) called at 
/usr/share/request-tracker4/lib/RT/System.pm line 236
        RT::System::AddUpgradeHistory(RT::System=HASH(0x697d940), "RT", 
HASH(0x16bb600)) called at /usr/sbin/rt-setup-database-4 line 268
        main::action_schema("upgrade-from", "4.0.19", "skip-create", 1, 
"backcompat", ARRAY(0x16efc88), "package", "RT", "datafile", ...) called at 
/usr/sbin/rt-setup-database-4 line 550
        main::action_upgrade("skip-create", 1, "upgrade-from", "4.0.19", 
"action", "upgrade", "upgrade-to", "4.2.3", "package", ...) called at 
/usr/sbin/rt-setup-database-4 line 209 (/usr/share/perl/5.20/Carp.pm:169)
  [24429] [Mon Dec 15 12:09:44 2014] [warning]: DBD::SQLite::st execute failed: 
database is locked at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 586. 
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
  [24429] [Mon Dec 15 12:09:44 2014] [warning]: RT::Handle=HASH(0x615e200) 
couldn't execute the query 'UPDATE Attributes SET LastUpdated=? WHERE id=? ' at 
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
        DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x615e200), 
"UPDATE Attributes SET LastUpdated=? WHERE id=? ", "2014-12-15 12:09:14", 6) 
called at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 453
        
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x615e200), 
"Table", "Attributes", "Value", "2014-12-15 12:09:14", "IsSQLFunction", undef, 
"Column", "LastUpdated", ...) called at 
/usr/share/perl5/DBIx/SearchBuilder/Record.pm line 871
        DBIx::SearchBuilder::Record::__Set(RT::Attribute=HASH(0x699eae0), 
"Field", "LastUpdated", "Value", "2014-12-15 12:09:14") called at 
/usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 140
        
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Attribute=HASH(0x699eae0), 
"Field", "LastUpdated", "Value", "2014-12-15 12:09:14") called at 
/usr/share/request-tracker4/lib/RT/Record.pm line 549
        RT::Record::_SetLastUpdated(RT::Attribute=HASH(0x699eae0)) called at 
/usr/share/request-tracker4/lib/RT/Record.pm line 501
        RT::Record::_Set(RT::Attribute=HASH(0x699eae0), "Field", "Content", 
"Value", "BQoDAAAAAQQCAAAANgQDAAAACAo1L3Vzci9zaGFyZS9yZXF1ZXN0LXRyYWNrZ"...) 
called at /usr/share/request-tracker4/lib/RT/Attribute.pm line 403
        RT::Attribute::_Set(RT::Attribute=HASH(0x699eae0), "Field", "Content", 
"Value", "BQoDAAAAAQQCAAAANgQDAAAACAo1L3Vzci9zaGFyZS9yZXF1ZXN0LXRyYWNrZ"...) 
called at /usr/share/request-tracker4/lib/RT/Attribute.pm line 287
        RT::Attribute::SetContent(RT::Attribute=HASH(0x699eae0), 
HASH(0x69c5d68)) called at /usr/share/request-tracker4/lib/RT/Record.pm line 232
        RT::Record::SetAttribute(RT::System=HASH(0x697d940), "Name", 
"UpgradeHistory", "Content", HASH(0x69c5d68)) called at 
/usr/share/request-tracker4/lib/RT/System.pm line 236
        RT::System::AddUpgradeHistory(RT::System=HASH(0x697d940), "RT", 
HASH(0x16bb600)) called at /usr/sbin/rt-setup-database-4 line 268
        main::action_schema("upgrade-from", "4.0.19", "skip-create", 1, 
"backcompat", ARRAY(0x16efc88), "package", "RT", "datafile", ...) called at 
/usr/sbin/rt-setup-database-4 line 550
        main::action_upgrade("skip-create", 1, "upgrade-from", "4.0.19", 
"action", "upgrade", "upgrade-to", "4.2.3", "package", ...) called at 
/usr/sbin/rt-setup-database-4 line 209 (/usr/share/perl/5.20/Carp.pm:169)
  [24429] [Mon Dec 15 12:10:15 2014] [warning]: DBD::SQLite::st execute failed: 
database is locked at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 586. 
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
  [24429] [Mon Dec 15 12:10:15 2014] [warning]: RT::Handle=HASH(0x615e200) 
couldn't execute the query 'UPDATE Attributes SET Content=? WHERE id=? ' at 
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
        DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x615e200), 
"UPDATE Attributes SET Content=? WHERE id=? ", 
"BQoDAAAAAQQCAAAANgQDAAAACAo1L3Vzci9zaGFyZS9yZXF1ZXN0LXRyYWNrZ"..., 6) called 
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 453
        
DBIx::SearchBuilder::Handle::UpdateRecordValue(RT::Handle=HASH(0x615e200), 
"Table", "Attributes", "Value", 
"BQoDAAAAAQQCAAAANgQDAAAACAo1L3Vzci9zaGFyZS9yZXF1ZXN0LXRyYWNrZ"..., 
"IsSQLFunction", undef, "Column", "Content", ...) called at 
/usr/share/perl5/DBIx/SearchBuilder/Record.pm line 871
        DBIx::SearchBuilder::Record::__Set(RT::Attribute=HASH(0x699eae0), 
"Field", "Content", "Value", 
"BQoDAAAAAQQCAAAANgQDAAAACAo1L3Vzci9zaGFyZS9yZXF1ZXN0LXRyYWNrZ"..., "IsSQL", 
undef) called at /usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm line 140
        
DBIx::SearchBuilder::Record::Cachable::__Set(RT::Attribute=HASH(0x699eae0), 
"Field", "Content", "Value", 
"BQoDAAAAAQQCAAAANgQDAAAACAo1L3Vzci9zaGFyZS9yZXF1ZXN0LXRyYWNrZ"..., "IsSQL", 
undef) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 744
        DBIx::SearchBuilder::Record::_Set(RT::Attribute=HASH(0x699eae0), 
"Field", "Content", "Value", 
"BQoDAAAAAQQCAAAANgQDAAAACAo1L3Vzci9zaGFyZS9yZXF1ZXN0LXRyYWNrZ"..., "IsSQL", 
undef) called at /usr/share/request-tracker4/lib/RT/Record.pm line 502
        RT::Record::_Set(RT::Attribute=HASH(0x699eae0), "Field", "Content", 
"Value", "BQoDAAAAAQQCAAAANgQDAAAACAo1L3Vzci9zaGFyZS9yZXF1ZXN0LXRyYWNrZ"...) 
called at /usr/share/request-tracker4/lib/RT/Attribute.pm line 403
        RT::Attribute::_Set(RT::Attribute=HASH(0x699eae0), "Field", "Content", 
"Value", "BQoDAAAAAQQCAAAANgQDAAAACAo1L3Vzci9zaGFyZS9yZXF1ZXN0LXRyYWNrZ"...) 
called at /usr/share/request-tracker4/lib/RT/Attribute.pm line 287
        RT::Attribute::SetContent(RT::Attribute=HASH(0x699eae0), 
HASH(0x69c5d68)) called at /usr/share/request-tracker4/lib/RT/Record.pm line 232
        RT::Record::SetAttribute(RT::System=HASH(0x697d940), "Name", 
"UpgradeHistory", "Content", HASH(0x69c5d68)) called at 
/usr/share/request-tracker4/lib/RT/System.pm line 236
        RT::System::AddUpgradeHistory(RT::System=HASH(0x697d940), "RT", 
HASH(0x16bb600)) called at /usr/sbin/rt-setup-database-4 line 268
        main::action_schema("upgrade-from", "4.0.19", "skip-create", 1, 
"backcompat", ARRAY(0x16efc88), "package", "RT", "datafile", ...) called at 
/usr/sbin/rt-setup-database-4 line 550
        main::action_upgrade("skip-create", 1, "upgrade-from", "4.0.19", 
"action", "upgrade", "upgrade-to", "4.2.3", "package", ...) called at 
/usr/sbin/rt-setup-database-4 line 209 (/usr/share/perl/5.20/Carp.pm:169)
  Couldn't finish 'upgrade' step.
  
  ERROR: Couldn't run SQL query:
  UPDATE Groups SET Name = Type
  WHERE Domain IN ('ACLEquivalence', 'SystemInternal') OR Domain LIKE '%-Role'
  
  ERROR: UNIQUE constraint failed: Groups.Name, Groups.Domain, Groups.Type, 
Groups.Instance
  
  error encountered processing 
/usr/share/dbconfig-common/scripts/request-tracker4/upgrade/sqlite3/4.2.3:
  /usr/share/dbconfig-common/scripts/request-tracker4/upgrade/sqlite3/4.2.3 
exited with non-zero status
  dbconfig-common: request-tracker4 configure: aborted.
  dpkg: error processing package request-tracker4 (--configure):
   subprocess installed post-installation script returned error exit status 1
  Processing triggers for libc-bin (2.19-13) ...
  Processing triggers for ca-certificates (20141019) ...
  Updating certificates in /etc/ssl/certs... 10 added, 8 removed; done.
  Running hooks in /etc/ca-certificates/update.d....done.
  Errors were encountered while processing:
   request-tracker4


cheers,

Andreas

Attachment: rt4-extension-assettracker_None.log.gz
Description: application/gzip

Reply via email to