Bug 595286
| Summary: | Upgrade JON 2.2 to JON 2.4 gives error in server log - ORA-00942: table or view does not exist | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Other] RHQ Project | Reporter: | Rajan Timaniya <rtimaniy> | ||||
| Component: | Core Server | Assignee: | Jay Shaughnessy <jshaughn> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Rajan Timaniya <rtimaniy> | ||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | urgent | ||||||
| Version: | 3.0.0 | ||||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | All | ||||||
| OS: | Linux | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | 2.4 | Doc Type: | Bug Fix | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2010-08-12 16:55:14 UTC | Type: | --- | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Bug Depends On: | 596096 | ||||||
| Bug Blocks: | 565628, 591531 | ||||||
| Attachments: |
|
||||||
|
Description
Rajan Timaniya
2010-05-24 09:51:22 UTC
Rajan We need to determine two things: 1) Whether this only occurs on Oracle, or also PG 2) Whether this only occurs upgrading from 2.2 to 2.4, or also going from 2.3 to 2.4 1) Upgrade JON2.2 to JON2.4 with Postgres 8.3 The error/exception - ORA-00942: table or view does not exist: only found with Oracle, it not reproduce on Postgres. I have verified upgrade JON2.2 to JON2.4 (JON build #166) with Postgres 8.3 2) Upgrade JON 2.3 to JON 2.4 (JON build #166) with Postgres 8.4 didn't found the error/exception - ORA-00942: table or view does not exist. Note: I will test same bug for upgrade JON2.3 to JON2.4 with Oracle 10g and add my comment to bug. (8:46:07 PM) jshaughn\away: ccrouch: I upgraded from 2.3 to 2.4 and did not encounter the issue in 595286. I did encounter a different issue which I fixed locally. I'll look more into it tomorrow. Rajan, are you seeing this going from 2.3 to 2.4? Upgrade JON 2.3 to JON 2.4 with Oracle 10g give 'SQLException: ORA-00911: invalid character' error/exception on the screen (during installation). Please refer bug #596096 for same. I was unable to reproduce this problem. I didn't have the resources to completely mimic the reproduction steps but I did have inventory, operation schedules and history, ldap authorization configured, ldap and non-ldap users created, groups created, role created with user and group assignment. I did not have multiple servers nor did I generate alerts. There has just been a merge of the bundle branch into master and that may have fixed any issue with bundle table upgrades (i.e. DEPLOYMENT). The errors above, regarding "Subject#1", seems to indicate a failing trying to get a Subject with id=1, which is overlord (superuser), and that is hard to explain and may indicate a fouled test environment. Please retest with the latest build, which, as mentioned above, is quite different given the latest merges. Also, #596096 has been resolved. Verified on JON build #172 - Revision: 10621 Upgrade JON 2.2 to JON 2.4 (JON build #172) with Oracle 10g Upgrade JON 2.3 to JON 2.4 (JON build #172) with Oracle 10g Upgrade JON 2.3.1 to JON 2.4 (JON build #172) with Oracle 10g Observed that there is no - ORA-00942: table or view does not exist Mass-closure of verified bugs against JON. |