[jira] [Created] (AMBARI-5585) Ambari-DDL-Oracle-CREATE.sql tries to delete/drop from inexistings Quartz tables

["Vladislav Pernin (JIRA)" <ji...@apache.org>]

Vladislav Pernin created AMBARI-5585:
----------------------------------------

             Summary: 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
            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)