Skip to content
This repository has been archived by the owner. It is now read-only.

[dev.icinga.com #5256] Oracle update script 1.10.0 failes while trying to drop nonexisting index #1400

Closed
icinga-migration opened this issue Dec 3, 2013 · 2 comments
Labels
Milestone

Comments

@icinga-migration
Copy link
Member

@icinga-migration icinga-migration commented Dec 3, 2013

This issue has been migrated from Redmine: https://dev.icinga.com/issues/5256

Created by Tommi on 2013-12-03 18:22:50 +00:00

Assignee: Tommi
Status: Resolved (closed on 2013-12-04 23:58:01 +00:00)
Target Version: 1.10.2
Last Update: 2014-12-08 14:38:19 +00:00 (in Redmine)

Icinga Version: 1.10.0
OS Version: any

Oracle update script failes because it tries to remove an unknown index. sqlplus errorhandler terminates the upgrade script at this point and will not proceed remaining tasks. This causes the dbversion not updated to 1.10 and finally ido2db start will fail.

DROP INDEX timed_e_q_sched_time_idx
           *
ERROR at line 1:
ORA-01418: specified index does not exist

i found only one reference for this index - outcommented in Oracle-upgrade-1.0.1

oracle-upgrade-1.0.1.sql:-- CREATE INDEX timed_e_q_sched_time_idx on timedeventqueue(scheduled_time); -- defined above

i'll remove drop of timed_e_q_sched_time_idx from upgrade script

Changesets

2013-12-04 19:52:38 +00:00 by Tommi 8e06351

idoutils: fix oracle upgrade sql refs #5256

-remove separate named index drops in favor to let oracle do all this work when droping the table with all dependencies
-add drop index option to prevent "object exists" errors when recreating an unique or primary key constraint

refs #5256

2013-12-04 22:34:15 +00:00 by ricardo e6da325

Merge branch 'fix/oracle_upgrade_script-5256' into support/1.10

Fixes: #5256
@icinga-migration

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Dec 4, 2013

Updated by ricardo on 2013-12-04 23:58:01 +00:00

  • Status changed from Assigned to Resolved
  • Done % changed from 0 to 100

Applied in changeset icinga-core:e6da32525041e0d9509352167c5d205f6cfb5b60.

@icinga-migration

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Dec 8, 2014

Updated by mfriedrich on 2014-12-08 14:38:19 +00:00

  • Project changed from 18 to Core, Classic UI, IDOUtils
  • Category changed from 24 to IDOUtils
  • Icinga Version changed from 1 to 1
  • OS Version set to any
@icinga-migration icinga-migration added this to the 1.10.2 milestone Jan 17, 2017
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant
You can’t perform that action at this time.