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

[icinga-migration]

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]

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]

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