[request-tracker-maintainers] Bug#773343: request-tracker4: fails to upgrade from 'wheezy' if rt4-extension-assettracker is installed
Andreas Beckmann
anbe at debian.org
Wed Dec 17 09:36:49 UTC 2014
Package: request-tracker4
Version: 4.2.8-1
Severity: serious
User: debian-qa at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: rt4-extension-assettracker_None.log.gz
Type: application/gzip
Size: 77999 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-request-tracker-maintainers/attachments/20141217/be9e1c0a/attachment-0001.bin>
More information about the pkg-request-tracker-maintainers
mailing list