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)
