[
https://issues.apache.org/jira/browse/AMBARI-5585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladislav Pernin updated AMBARI-5585:
-------------------------------------
Affects Version/s: 1.6.0
> Ambari-DDL-Oracle-CREATE.sql tries to delete/drop from inexistings Quartz
> tables
> --------------------------------------------------------------------------------
>
> Key: AMBARI-5585
> URL: https://issues.apache.org/jira/browse/AMBARI-5585
> Project: Ambari
> Issue Type: Bug
> Affects Versions: 1.5.1, 1.6.0
> Reporter: Vladislav Pernin
>
> The Quartz DDL are wrong.
> The file Ambari-DDL-Oracle-CREATE.sql tries to delete and drop Quartz tables
> that do not exists.
> Extract :
> -- Quartz tables
> delete from qrtz_fired_triggers;
> delete from qrtz_simple_triggers;
> delete from qrtz_simprop_triggers;
> delete from qrtz_cron_triggers;
> delete from qrtz_blob_triggers;
> delete from qrtz_triggers;
> delete from qrtz_job_details;
> delete from qrtz_calendars;
> delete from qrtz_paused_trigger_grps;
> delete from qrtz_locks;
> delete from qrtz_scheduler_state;
> drop table qrtz_calendars;
> drop table qrtz_fired_triggers;
> drop table qrtz_blob_triggers;
> drop table qrtz_cron_triggers;
> drop table qrtz_simple_triggers;
> drop table qrtz_simprop_triggers;
> drop table qrtz_triggers;
> drop table qrtz_job_details;
> drop table qrtz_paused_trigger_grps;
> drop table qrtz_locks;
> drop table qrtz_scheduler_state;
> CREATE TABLE qrtz_job_details ...
> The file Ambari-DDL-Postgres-CREATE.sql seems to be correct
--
This message was sent by Atlassian JIRA
(v6.2#6252)
