[request-tracker-maintainers] Bug#534346: request-tracker3.8: Upgrading a postgresql database from 3.8.2 to 3.8.3 via rt-setup-database is broken
Matt Zagrabelny
mzagrabe at d.umn.edu
Tue Jun 23 19:33:34 UTC 2009
Package: request-tracker3.8
Version: 3.8.4-1
Severity: important
Hello,
I am using RT 3.8.2 (debian package) and am upgrading to 3.8.4.
I am using apache2, postgresql 8.3, and postfix with it.
I attempted to upgrade the database using the rt-setup-database program,
but it failed.
I attempted two different paths to upgrade:
% rt-setup-database --action upgrade --dba rtuser
--prompt-for-dba-password
In order to create or update your RT database, this script needs to
connect to your Pg instance on localhost as rtuser
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: rt3
User: rtuser
DBA: rtuser
Enter RT version you're upgrading from: 3.8.2
Going to apply following upgrades:
* 3.8.3
* 3.8.4
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:
* 3.8.3
* 3.8.4
IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP
Proceed [y/N]:y
Processing 3.8.3
Now populating database schema.
DBD::Pg::st execute failed: ERROR: relation "attachments_id_seq"
already exists at /usr/share/request-tracker3.8/lib/RT/Handle.pm line
506.
And also the excerpt from the dbconfig-common script:
% cat
/usr/share/dbconfig-common/scripts/request-tracker3.8/upgrade/pgsql/3.8.3
Where I found the following command, and executed it.
# /usr/sbin/rt-setup-database-3.8 --action schema --datafile
/usr/share/request-tracker3.8/etc/upgrade/3.8.3/schema.Pg --skip-creates
But it blew up with the same error.
-- Package-specific info:
Changed files:
usr/share/request-tracker3.8/html/Ticket/Elements/EditCustomFields
There are locally modified files in /usr/local/share/request-tracker3.8/,
these may (or may not) be the source of the problem.
-- System Information:
Debian Release: squeeze/sid
APT prefers unstable
APT policy: (990, 'unstable'), (500, 'oldstable'), (500, 'testing'), (500, 'stable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.29-2-686 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages request-tracker3.8 depends on:
ii dbconfig-common 1.8.41 common framework for packaging dat
ii debconf [debconf-2.0] 1.5.26 Debian configuration management sy
ii libapache-session-perl 1.87-1 Perl modules for keeping persisten
ii libcache-simple-timedexpiry- 0.27-2 Perl module to cache and expire ke
ii libcalendar-simple-perl 1.20-1 Perl extension to create simple ca
ii libclass-returnvalue-perl 0.55-1 A return-value object that lets yo
ii libcss-squish-perl 0.08-1 Perl module to compact many CSS fi
ii libdata-ical-perl 0.15+dfsg-1 Perlmodule to generate and read iC
ii libdbi-perl 1.608-1 Perl5 database interface by Tim Bu
ii libdbix-searchbuilder-perl 1.55-1 Perl implementation of a simple OR
ii libdevel-stacktrace-perl 1.2000-1 Stack trace and stack trace frame
ii libemail-address-perl 1.889-2 RFC 2822 Address Parsing and Creat
ii libfile-sharedir-perl 1.00-0.1 Locate per-dist and per-module sha
ii libgd-graph-perl 1.44-3 Graph Plotting Module for Perl 5
ii libgd-text-perl 0.86-5 Text utilities for use with GD
ii libgnupg-interface-perl 0.36-1 Perl interface to GnuPG
ii libgraphviz-perl 2.03-2 Perl interface to the GraphViz gra
ii libhtml-mason-perl 1:1.39-1 HTML::Mason Perl module
ii libhtml-parser-perl 3.60-1 collection of modules that parse H
ii libhtml-rewriteattributes-pe 0.03-1 concise attribute rewriting
ii libhtml-scrubber-perl 0.08-4 Perl extension for scrubbing/sanit
ii libipc-run-safehandles-perl 0.02-1 Use IPC::Run and IPC::Run3 safely
ii libjs-prototype 1.6.0.3-1 JavaScript Framework for dynamic w
ii libjs-scriptaculous 1.8.2-1 JavaScript library for dynamic web
ii liblocale-maketext-fuzzy-per 0.10-1 Maketext from already interpolated
ii liblocale-maketext-lexicon-p 0.77-1 Lexicon-handling backends for "Loc
ii liblog-dispatch-perl 2.22-1 Dispatches messages to multiple Lo
ii libmailtools-perl 2.04-1 Manipulate email in perl programs
ii libmime-perl 5.427-2 transitional dummy package
ii libmime-tools-perl [libmime- 5.427-2 Perl5 modules for MIME-compliant m
ii libmime-types-perl 1.27-1 Perl extension for determining MIM
ii libmodule-versions-report-pe 1.06-1 Report versions of all modules in
ii libperlio-eol-perl 0.14-1+b1 PerlIO layer for normalizing line
ii libregexp-common-perl 2.122-1 Provide commonly requested regular
ii libtext-autoformat-perl 1.666.0-1 Perl module for automatic text wra
ii libtext-quoted-perl 2.05-2 Extract the structure of a quoted
ii libtext-template-perl 1.45-1 Text::Template perl module
ii libtext-wikiformat-perl 0.78-1 translates Wiki formatted text int
ii libtext-wrapper-perl 1.02-1 Simple word wrapping routine
ii libtime-modules-perl 2006.0814-2 Various Perl modules for time/date
ii libtimedate-perl 1.1600-9 Time and date functions for Perl
ii libtree-simple-perl 1.18-1 A simple tree object
ii libuniversal-require-perl 0.13-1 Load modules from a variable
ii libxml-rss-perl 1.44-1 Perl module for managing RSS (RDF
ii libxml-simple-perl 2.18-2 Perl module for reading and writin
ii perl 5.10.0-23 Larry Wall's Practical Extraction
ii postfix [mail-transport-agen 2.6.2~rc1-1 High-performance mail transport ag
ii rt3.8-apache2 3.8.4-1 Apache 2 specific files for reques
ii rt3.8-clients 3.8.4-1 mail gateway and command-line inte
ii rt3.8-db-postgresql 3.8.4-1 PostgreSQL database backend for re
ii syslog-ng [system-log-daemon 2.0.9-4.1 Next generation logging daemon
ii ucf 3.0018 Update Configuration File: preserv
Versions of packages request-tracker3.8 recommends:
ii speedy-cgi-perl 2.22-10 speed up perl scripts by making th
Versions of packages request-tracker3.8 suggests:
pn rt3.8-rtfm <none> (no description available)
-- debconf information:
request-tracker3.8/mysql/method: unix socket
request-tracker3.8/dbconfig-reinstall: false
request-tracker3.8/db/dbname: rtdb
* request-tracker3.8/dbconfig-install: false
request-tracker3.8/db/app-user: rtuser
request-tracker3.8/pgsql/no-empty-passwords:
* request-tracker3.8/handle-siteconfig-permissions: true
request-tracker3.8/dbconfig-upgrade: true
request-tracker3.8/purge: false
* request-tracker3.8/commentaddress: comment at grateful.d.umn.edu
* request-tracker3.8/organization: grateful.d.umn.edu
request-tracker3.8/pgsql/authmethod-user: password
request-tracker3.8/install-error: abort
request-tracker3.8/remove-error: abort
request-tracker3.8/pgsql/admin-user: postgres
request-tracker3.8/remote/host:
request-tracker3.8/database-type:
request-tracker3.8/remote/port:
request-tracker3.8/pgsql/method: unix socket
request-tracker3.8/pgsql/manualconf:
* request-tracker3.8/webbaseurl: http://grateful.d.umn.edu
request-tracker3.8/remote/newhost:
* request-tracker3.8/rtname: ZTEST
request-tracker3.8/internal/reconfiguring: false
request-tracker3.8/passwords-do-not-match:
* request-tracker3.8/correspondaddress: correspond at grateful.d.umn.edu
* request-tracker3.8/webpath: /rt
request-tracker3.8/upgrade-backup: true
request-tracker3.8/db/basepath:
request-tracker3.8/internal/skip-preseed: true
request-tracker3.8/dbconfig-remove:
request-tracker3.8/missing-db-package-error: abort
request-tracker3.8/warn-sqlite-file:
request-tracker3.8/upgrade-error: abort
request-tracker3.8/mysql/admin-user: root
request-tracker3.8/pgsql/changeconf: false
request-tracker3.8/pgsql/authmethod-admin: ident
More information about the pkg-request-tracker-maintainers
mailing list