Bug 85886

Summary: 2.17 schema not compatible with 2.15 running on rhdb 2.1
Product: [Community] Bugzilla Reporter: sand
Component: Bugzilla GeneralAssignee: PnT DevOps Devs <hss-ied-bugs>
Status: CLOSED WONTFIX QA Contact: David Lawrence <dkl>
Severity: medium Docs Contact:
Priority: medium    
Version: 2.18CC: sand
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2007-08-08 21:06:54 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description sand 2003-03-10 10:01:36 UTC
Description of problem: 2.17 schema not compatible with 2.15 running on rhdb 2.1

Version-Release number of selected component (if applicable): 2.17

How reproducible: Only have done it once (see below).

Steps to Reproduce:
1. Install rh pro 8.0.
2. Install rhdb 2.1.
3. Install rh bugzilla 2.15
4. Enter some bugs.
5. Install rh bugzilla 2.17
6. Run pgsetup.pl
7. Try to enter or view bugs.
Actual results: Errors are thrown by the SQL code because of missing id for such tables as components, products, etc.

My analysis: rhdb 2.1 basically is postgresql 7.2.3 and I need 7.3 in order to add such things as a "serial primary key." They can only be applied to a not null int, which can't be added directly, can't be altered from a plain int, since you can't alter it "set not null." So, I am about to uninstall rhdb 2.1 and install postgres 7.3. To see if I can hammer the schema into line.

Expected results: Would have preferred that pgsetup.pl had worked. Perhaps it will when I install postgresql 7.3 rpm's.

Additional info:

Comment 1 sand 2003-06-04 18:05:23 UTC
I'm currently running version 2.17.1. To accomplish this, I (a) upgraded to
postgresql 7.3.2, (b) added new tables to the bugs database, (c) altered half a
dozen existing ones (adding columns and altering values), (d) added expanded
permissions to several tables and sequences. This process took several hours.

I would have preferred that pgsetup.pl have done all of this upgrading for me.
If you like, if it will aid in improving pgsetup, I can email you some of the
queries I used in (c) and (d). Let me know.

Comment 2 David Lawrence 2006-04-08 17:44:16 UTC
Red Hat's current Bugzilla version is 2.18. I am moving all older open bugs to
this version. Any bugs against the older versions will need to be verified that
they are still bugs. This will help me also to sort them better.