Closed SergeyParamoshkin closed 7 years ago
Did you install the postgresql connectors?
Hi. i`m use docker image https://github.com/cloudera/hue/tree/master/tools/docker
I installed psycopg2 inside the container, but now I get this error
/hue/build/env/bin/pip install --upgrade psycopg2
./build/env/bin/hue syncdb
INFO:root:Welcome to Hue 3.10.0
DEBUG:desktop.appmanager:Loaded Desktop Libraries: aws, hadoop, liboauth, liboozie, libopenid, librdbms, libsaml, libsentry, libsolr, libzookeeper
DEBUG:desktop.lib.conf:Loading configuration from: hue.ini
DEBUG:desktop.appmanager:Loaded Desktop Applications: about, beeswax, filebrowser, hbase, help, jobbrowser, jobsub, metastore, oozie, pig, proxy, rdbms, search, spark, sqoop, useradmin, zookeeper, indexer, metadata, notebook
DEBUG:root:Installed Django modules: DesktopModule(aws: aws),DesktopModule(hadoop: hadoop),DesktopModule(liboauth: liboauth),DesktopModule(liboozie: liboozie),DesktopModule(libopenid: libopenid),DesktopModule(librdbms: librdbms),DesktopModule(libsaml: libsaml),DesktopModule(libsentry: libsentry),DesktopModule(libsolr: libsolr),DesktopModule(libzookeeper: libzookeeper),DesktopModule(Hue: desktop),DesktopModule(About: about),DesktopModule(Hive: beeswax),DesktopModule(File Browser: filebrowser),DesktopModule(HBase Browser: hbase),DesktopModule(Help: help),DesktopModule(Job Browser: jobbrowser),DesktopModule(Job Designer: jobsub),DesktopModule(Metastore Manager: metastore),DesktopModule(Oozie Editor/Dashboard: oozie),DesktopModule(Pig Editor: pig),DesktopModule(Proxy: proxy),DesktopModule(RDBMS UI: rdbms),DesktopModule(Solr Search: search),DesktopModule(Spark: spark),DesktopModule(Sqoop: sqoop),DesktopModule(User Admin: useradmin),DesktopModule(ZooKeeper Browser: zookeeper),DesktopModule(Solr Indexer: indexer),DesktopModule(Metadata: metadata),DesktopModule(Notebook: notebook)
WARNING:desktop.lib.conf:enable_dbproxy_server is of type bool. Resetting it as type 'coerce_bool'. Please fix it permanently
WARNING:desktop.lib.conf:enable_query_builder is of type bool. Resetting it as type 'coerce_bool'. Please fix it permanently
WARNING:desktop.lib.conf:enable_query_scheduling is of type bool. Resetting it as type 'coerce_bool'. Please fix it permanently
DEBUG:desktop.lib.conf:Loading configuration from: hue.ini
DEBUG:desktop.lib.conf:Loading configuration from: hue.ini
DEBUG:root:DESKTOP_DB_TEST_NAME SET: /hue/desktop/desktop-test.db
DEBUG:root:DESKTOP_DB_TEST_USER SET: hue_test
WARNING:parquet:Couldn't import snappy. Support for snappy compression disabled.
Syncing...
Creating tables ...
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table auth_user_groups
Creating table auth_user_user_permissions
Creating table auth_user
Creating table django_openid_auth_nonce
Creating table django_openid_auth_association
Creating table django_openid_auth_useropenid
Creating table django_content_type
Creating table django_session
Creating table django_site
Creating table django_admin_log
Creating table south_migrationhistory
Creating table axes_accessattempt
Creating table axes_accesslog
You just installed Django's auth system, which means you don't have any superusers defined.
Would you like to create one now? (yes/no): no
Installing custom SQL ...
Installing indexes ...
Installed 0 object(s) from 0 fixture(s)
Synced:
> django.contrib.auth
> django_openid_auth
> django.contrib.contenttypes
> django.contrib.sessions
> django.contrib.sites
> django.contrib.staticfiles
> django.contrib.admin
> south
> axes
> about
> filebrowser
> help
> jobbrowser
> metastore
> proxy
> rdbms
> zookeeper
> indexer
Not synced (use migrations):
- django_extensions
- desktop
- beeswax
- hbase
- jobsub
- oozie
- pig
- search
- spark
- sqoop
- useradmin
- notebook
(use ./manage.py migrate to migrate these)
./build/env/bin/hue migrate
INFO:root:Welcome to Hue 3.10.0
DEBUG:desktop.appmanager:Loaded Desktop Libraries: aws, hadoop, liboauth, liboozie, libopenid, librdbms, libsaml, libsentry, libsolr, libzookeeper
DEBUG:desktop.lib.conf:Loading configuration from: hue.ini
DEBUG:desktop.appmanager:Loaded Desktop Applications: about, beeswax, filebrowser, hbase, help, jobbrowser, jobsub, metastore, oozie, pig, proxy, rdbms, search, spark, sqoop, useradmin, zookeeper, indexer, metadata, notebook
DEBUG:root:Installed Django modules: DesktopModule(aws: aws),DesktopModule(hadoop: hadoop),DesktopModule(liboauth: liboauth),DesktopModule(liboozie: liboozie),DesktopModule(libopenid: libopenid),DesktopModule(librdbms: librdbms),DesktopModule(libsaml: libsaml),DesktopModule(libsentry: libsentry),DesktopModule(libsolr: libsolr),DesktopModule(libzookeeper: libzookeeper),DesktopModule(Hue: desktop),DesktopModule(About: about),DesktopModule(Hive: beeswax),DesktopModule(File Browser: filebrowser),DesktopModule(HBase Browser: hbase),DesktopModule(Help: help),DesktopModule(Job Browser: jobbrowser),DesktopModule(Job Designer: jobsub),DesktopModule(Metastore Manager: metastore),DesktopModule(Oozie Editor/Dashboard: oozie),DesktopModule(Pig Editor: pig),DesktopModule(Proxy: proxy),DesktopModule(RDBMS UI: rdbms),DesktopModule(Solr Search: search),DesktopModule(Spark: spark),DesktopModule(Sqoop: sqoop),DesktopModule(User Admin: useradmin),DesktopModule(ZooKeeper Browser: zookeeper),DesktopModule(Solr Indexer: indexer),DesktopModule(Metadata: metadata),DesktopModule(Notebook: notebook)
WARNING:desktop.lib.conf:enable_dbproxy_server is of type bool. Resetting it as type 'coerce_bool'. Please fix it permanently
WARNING:desktop.lib.conf:enable_query_builder is of type bool. Resetting it as type 'coerce_bool'. Please fix it permanently
WARNING:desktop.lib.conf:enable_query_scheduling is of type bool. Resetting it as type 'coerce_bool'. Please fix it permanently
DEBUG:desktop.lib.conf:Loading configuration from: hue.ini
DEBUG:desktop.lib.conf:Loading configuration from: hue.ini
DEBUG:root:DESKTOP_DB_TEST_NAME SET: /hue/desktop/desktop-test.db
DEBUG:root:DESKTOP_DB_TEST_USER SET: hue_test
WARNING:parquet:Couldn't import snappy. Support for snappy compression disabled.
Running migrations for django_extensions:
- Migrating forwards to 0001_empty.
> django_extensions:0001_empty
- Loading initial data for django_extensions.
Installed 0 object(s) from 0 fixture(s)
Running migrations for desktop:
- Migrating forwards to 0022_auto__del_field_defaultconfiguration_group__del_unique_defaultconfigur.
> pig:0001_initial
DEBUG:south:execute "CREATE TABLE "pig_document" ("owner_id" integer NOT NULL, "is_design" boolean NOT NULL, "id" serial NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "CREATE TABLE "pig_pigscript" ("document_ptr_id" integer NOT NULL PRIMARY KEY, "data" text NOT NULL)" with params "[]"
DEBUG:south:execute "ALTER TABLE "pig_document" ADD CONSTRAINT "owner_id_refs_id_8d390f80" FOREIGN KEY ("owner_id") REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "pig_document_owner_id" ON "pig_document" ("owner_id");" with params "[]"
DEBUG:south:execute "CREATE INDEX "pig_document_is_design" ON "pig_document" ("is_design");" with params "[]"
DEBUG:south:execute "ALTER TABLE "pig_pigscript" ADD CONSTRAINT "document_ptr_id_refs_id_17b4e137" FOREIGN KEY ("document_ptr_id") REFERENCES "pig_document" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0001_initial
DEBUG:south:execute "CREATE TABLE "oozie_job" ("is_shared" boolean NOT NULL, "description" varchar(1024) NOT NULL, "parameters" text NOT NULL, "deployment_dir" varchar(1024) NOT NULL, "schema_version" varchar(128) NOT NULL, "last_modified" timestamp with time zone NOT NULL, "owner_id" integer NOT NULL, "id" serial NOT NULL PRIMARY KEY, "name" varchar(40) NOT NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_workflow" ("job_xml" varchar(512) NOT NULL, "end_id" integer NULL, "is_single" boolean NOT NULL, "job_ptr_id" integer NOT NULL PRIMARY KEY, "job_properties" text NOT NULL, "start_id" integer NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_link" ("comment" varchar(1024) NOT NULL, "name" varchar(40) NOT NULL, "id" serial NOT NULL PRIMARY KEY, "parent_id" integer NOT NULL, "child_id" integer NOT NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_node" ("description" varchar(1024) NOT NULL, "workflow_id" integer NOT NULL, "id" serial NOT NULL PRIMARY KEY, "node_type" varchar(64) NOT NULL, "name" varchar(40) NOT NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_mapreduce" ("files" varchar(512) NOT NULL, "job_xml" varchar(512) NOT NULL, "jar_path" varchar(512) NOT NULL, "job_properties" text NOT NULL, "archives" varchar(512) NOT NULL, "node_ptr_id" integer NOT NULL UNIQUE, "prepares" text NOT NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_streaming" ("files" varchar(512) NOT NULL, "mapper" varchar(512) NOT NULL, "reducer" varchar(512) NOT NULL, "job_properties" text NOT NULL, "archives" varchar(512) NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_java" ("files" varchar(512) NOT NULL, "job_xml" varchar(512) NOT NULL, "jar_path" varchar(512) NOT NULL, "java_opts" varchar(256) NOT NULL, "args" text NOT NULL, "job_properties" text NOT NULL, "prepares" text NOT NULL, "archives" varchar(512) NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY, "main_class" varchar(256) NOT NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_pig" ("files" varchar(512) NOT NULL, "job_xml" varchar(512) NOT NULL, "job_properties" text NOT NULL, "params" text NOT NULL, "archives" varchar(512) NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY, "prepares" text NOT NULL, "script_path" varchar(256) NOT NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_start" ("node_ptr_id" integer NOT NULL UNIQUE)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_end" ("node_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_kill" ("message" varchar(256) NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_fork" ("node_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_join" ("node_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_coordinator" ("end" timestamp with time zone NOT NULL, "concurrency" smallint CHECK ("concurrency" >= 0) NULL, "frequency_number" smallint NOT NULL, "workflow_id" integer NULL, "job_ptr_id" integer NOT NULL PRIMARY KEY, "frequency_unit" varchar(20) NOT NULL, "start" timestamp with time zone NOT NULL, "timeout" smallint NULL, "timezone" varchar(24) NOT NULL, "throttle" smallint CHECK ("throttle" >= 0) NULL, "execution" varchar(10) NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_dataset" ("description" varchar(1024) NOT NULL, "frequency_number" smallint NOT NULL, "coordinator_id" integer NOT NULL, "frequency_unit" varchar(20) NOT NULL, "uri" varchar(1024) NOT NULL, "start" timestamp with time zone NOT NULL, "timezone" varchar(24) NOT NULL, "done_flag" varchar(64) NOT NULL, "id" serial NOT NULL PRIMARY KEY, "name" varchar(40) NOT NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_datainput" ("coordinator_id" integer NOT NULL, "dataset_id" integer NOT NULL UNIQUE, "id" serial NOT NULL PRIMARY KEY, "name" varchar(40) NOT NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_dataoutput" ("coordinator_id" integer NOT NULL, "dataset_id" integer NOT NULL UNIQUE, "id" serial NOT NULL PRIMARY KEY, "name" varchar(40) NOT NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_history" ("submission_date" timestamp with time zone NOT NULL, "job_id" integer NOT NULL, "properties" text NOT NULL, "oozie_job_id" varchar(128) NOT NULL, "submitter_id" integer NOT NULL, "id" serial NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_job_is_shared" ON "oozie_job" ("is_shared");" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_job_last_modified" ON "oozie_job" ("last_modified");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_job" ADD CONSTRAINT "owner_id_refs_id_b9eb9598" FOREIGN KEY ("owner_id") REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_job_owner_id" ON "oozie_job" ("owner_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_workflow" ADD CONSTRAINT "end_id_refs_id_92f16762" FOREIGN KEY ("end_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_workflow_end_id" ON "oozie_workflow" ("end_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_workflow" ADD CONSTRAINT "job_ptr_id_refs_id_8bb519fb" FOREIGN KEY ("job_ptr_id") REFERENCES "oozie_job" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_workflow" ADD CONSTRAINT "start_id_refs_id_92f16762" FOREIGN KEY ("start_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_workflow_start_id" ON "oozie_workflow" ("start_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_link" ADD CONSTRAINT "parent_id_refs_id_4c5f8d9b" FOREIGN KEY ("parent_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_link_parent_id" ON "oozie_link" ("parent_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_link" ADD CONSTRAINT "child_id_refs_id_4c5f8d9b" FOREIGN KEY ("child_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_link_child_id" ON "oozie_link" ("child_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_node" ADD CONSTRAINT "workflow_id_refs_job_ptr_id_61733cb8" FOREIGN KEY ("workflow_id") REFERENCES "oozie_workflow" ("job_ptr_id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_node_workflow_id" ON "oozie_node" ("workflow_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_mapreduce" ADD CONSTRAINT "node_ptr_id_refs_id_faafd42d" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_streaming" ADD CONSTRAINT "node_ptr_id_refs_id_5857900b" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_java" ADD CONSTRAINT "node_ptr_id_refs_id_c5504fe4" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_pig" ADD CONSTRAINT "node_ptr_id_refs_id_3a145eb2" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_start" ADD CONSTRAINT "node_ptr_id_refs_id_ed4928be" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_end" ADD CONSTRAINT "node_ptr_id_refs_id_d2ab2ce2" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_kill" ADD CONSTRAINT "node_ptr_id_refs_id_6a5609f4" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_fork" ADD CONSTRAINT "node_ptr_id_refs_id_08311288" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_join" ADD CONSTRAINT "node_ptr_id_refs_id_5fe5ad59" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_coordinator" ADD CONSTRAINT "workflow_id_refs_job_ptr_id_eff253f3" FOREIGN KEY ("workflow_id") REFERENCES "oozie_workflow" ("job_ptr_id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_coordinator_workflow_id" ON "oozie_coordinator" ("workflow_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_coordinator" ADD CONSTRAINT "job_ptr_id_refs_id_02836103" FOREIGN KEY ("job_ptr_id") REFERENCES "oozie_job" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_dataset" ADD CONSTRAINT "coordinator_id_refs_job_ptr_id_c1a45b56" FOREIGN KEY ("coordinator_id") REFERENCES "oozie_coordinator" ("job_ptr_id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_dataset_coordinator_id" ON "oozie_dataset" ("coordinator_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_datainput" ADD CONSTRAINT "coordinator_id_refs_job_ptr_id_a7f5bae4" FOREIGN KEY ("coordinator_id") REFERENCES "oozie_coordinator" ("job_ptr_id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_datainput_coordinator_id" ON "oozie_datainput" ("coordinator_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_datainput" ADD CONSTRAINT "dataset_id_refs_id_6d9c387e" FOREIGN KEY ("dataset_id") REFERENCES "oozie_dataset" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_dataoutput" ADD CONSTRAINT "coordinator_id_refs_job_ptr_id_35e76a9d" FOREIGN KEY ("coordinator_id") REFERENCES "oozie_coordinator" ("job_ptr_id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_dataoutput_coordinator_id" ON "oozie_dataoutput" ("coordinator_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_dataoutput" ADD CONSTRAINT "dataset_id_refs_id_c25267c2" FOREIGN KEY ("dataset_id") REFERENCES "oozie_dataset" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_history_submission_date" ON "oozie_history" ("submission_date");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_history" ADD CONSTRAINT "job_id_refs_id_aca84a0b" FOREIGN KEY ("job_id") REFERENCES "oozie_job" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_history_job_id" ON "oozie_history" ("job_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_history" ADD CONSTRAINT "submitter_id_refs_id_be4aca60" FOREIGN KEY ("submitter_id") REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_history_submitter_id" ON "oozie_history" ("submitter_id");" with params "[]"
> oozie:0002_auto__add_hive
DEBUG:south:execute "CREATE TABLE "oozie_hive" ("files" varchar(512) NOT NULL, "job_xml" varchar(512) NOT NULL, "job_properties" text NOT NULL, "params" text NOT NULL, "archives" varchar(512) NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY, "prepares" text NOT NULL, "script_path" varchar(256) NOT NULL)" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_hive" ADD CONSTRAINT "node_ptr_id_refs_id_7061d230" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0003_auto__add_sqoop
DEBUG:south:execute "CREATE TABLE "oozie_sqoop" ("files" varchar(512) NOT NULL, "job_xml" varchar(512) NOT NULL, "job_properties" text NOT NULL, "params" text NOT NULL, "archives" varchar(512) NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY, "prepares" text NOT NULL, "script_path" varchar(256) NOT NULL)" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_sqoop" ADD CONSTRAINT "node_ptr_id_refs_id_51abc83b" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0004_auto__add_ssh
DEBUG:south:execute "CREATE TABLE "oozie_ssh" ("capture_output" boolean NOT NULL, "host" varchar(256) NOT NULL, "params" text NOT NULL, "user" varchar(64) NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY, "command" varchar(256) NOT NULL)" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_ssh" ADD CONSTRAINT "node_ptr_id_refs_id_e6a21afc" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0005_auto__add_shell
DEBUG:south:execute "CREATE TABLE "oozie_shell" ("files" varchar(512) NOT NULL, "job_xml" varchar(512) NOT NULL, "job_properties" text NOT NULL, "capture_output" boolean NOT NULL, "params" text NOT NULL, "archives" varchar(512) NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY, "prepares" text NOT NULL, "command" varchar(256) NOT NULL)" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_shell" ADD CONSTRAINT "node_ptr_id_refs_id_6a9f9c63" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0006_auto__chg_field_java_files__chg_field_java_archives__chg_field_sqoop_f
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "ALTER TABLE "oozie_java" ALTER COLUMN "files" TYPE text, ALTER COLUMN "files" SET NOT NULL, ALTER COLUMN "files" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "ALTER TABLE "oozie_java" ALTER COLUMN "archives" TYPE text, ALTER COLUMN "archives" SET NOT NULL, ALTER COLUMN "archives" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "ALTER TABLE "oozie_sqoop" ALTER COLUMN "files" TYPE text, ALTER COLUMN "files" SET NOT NULL, ALTER COLUMN "files" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "ALTER TABLE "oozie_sqoop" ALTER COLUMN "archives" TYPE text, ALTER COLUMN "archives" SET NOT NULL, ALTER COLUMN "archives" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_pig']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_pig']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_pig']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_pig']"
DEBUG:south:execute "ALTER TABLE "oozie_pig" ALTER COLUMN "files" TYPE text, ALTER COLUMN "files" SET NOT NULL, ALTER COLUMN "files" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_pig']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_pig']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_pig']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_pig']"
DEBUG:south:execute "ALTER TABLE "oozie_pig" ALTER COLUMN "archives" TYPE text, ALTER COLUMN "archives" SET NOT NULL, ALTER COLUMN "archives" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "ALTER TABLE "oozie_mapreduce" ALTER COLUMN "files" TYPE text, ALTER COLUMN "files" SET NOT NULL, ALTER COLUMN "files" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "ALTER TABLE "oozie_mapreduce" ALTER COLUMN "archives" TYPE text, ALTER COLUMN "archives" SET NOT NULL, ALTER COLUMN "archives" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_streaming']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_streaming']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_streaming']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_streaming']"
DEBUG:south:execute "ALTER TABLE "oozie_streaming" ALTER COLUMN "files" TYPE text, ALTER COLUMN "files" SET NOT NULL, ALTER COLUMN "files" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_streaming']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_streaming']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_streaming']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_streaming']"
DEBUG:south:execute "ALTER TABLE "oozie_streaming" ALTER COLUMN "archives" TYPE text, ALTER COLUMN "archives" SET NOT NULL, ALTER COLUMN "archives" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_shell']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_shell']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_shell']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_shell']"
DEBUG:south:execute "ALTER TABLE "oozie_shell" ALTER COLUMN "files" TYPE text, ALTER COLUMN "files" SET NOT NULL, ALTER COLUMN "files" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_shell']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_shell']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_shell']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_shell']"
DEBUG:south:execute "ALTER TABLE "oozie_shell" ALTER COLUMN "archives" TYPE text, ALTER COLUMN "archives" SET NOT NULL, ALTER COLUMN "archives" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_hive']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_hive']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_hive']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_hive']"
DEBUG:south:execute "ALTER TABLE "oozie_hive" ALTER COLUMN "files" TYPE text, ALTER COLUMN "files" SET NOT NULL, ALTER COLUMN "files" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_hive']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_hive']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_hive']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_hive']"
DEBUG:south:execute "ALTER TABLE "oozie_hive" ALTER COLUMN "archives" TYPE text, ALTER COLUMN "archives" SET NOT NULL, ALTER COLUMN "archives" DROP DEFAULT;" with params "[]"
> oozie:0007_auto__chg_field_sqoop_script_path
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_sqoop']"
DEBUG:south:execute "ALTER TABLE "oozie_sqoop" ALTER COLUMN "script_path" TYPE text, ALTER COLUMN "script_path" SET NOT NULL, ALTER COLUMN "script_path" DROP DEFAULT;" with params "[]"
> oozie:0008_auto__add_distcp
DEBUG:south:execute "CREATE TABLE "oozie_distcp" ("prepares" text NOT NULL, "job_xml" varchar(512) NOT NULL, "params" text NOT NULL, "job_properties" text NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_distcp" ADD CONSTRAINT "node_ptr_id_refs_id_94a882fe" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0009_auto__add_decision
DEBUG:south:execute "CREATE TABLE "oozie_decision" ("node_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_decision" ADD CONSTRAINT "node_ptr_id_refs_id_67bc250e" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0010_auto__add_fs
DEBUG:south:execute "CREATE TABLE "oozie_fs" ("mkdirs" text NOT NULL, "touchzs" text NOT NULL, "chmods" text NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY, "moves" text NOT NULL, "deletes" text NOT NULL)" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_fs" ADD CONSTRAINT "node_ptr_id_refs_id_f2c6c820" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0011_auto__add_email
DEBUG:south:execute "CREATE TABLE "oozie_email" ("cc" text NOT NULL, "to" text NOT NULL, "subject" text NOT NULL, "body" text NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_email" ADD CONSTRAINT "node_ptr_id_refs_id_a770716b" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0012_auto__add_subworkflow__chg_field_email_subject__chg_field_email_body
DEBUG:south:execute "CREATE TABLE "oozie_subworkflow" ("propagate_configuration" boolean NOT NULL, "job_properties" text NOT NULL, "sub_workflow_id" integer NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_email']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_email']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_email']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_email']"
DEBUG:south:execute "ALTER TABLE "oozie_email" ALTER COLUMN "subject" TYPE text, ALTER COLUMN "subject" SET NOT NULL, ALTER COLUMN "subject" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_email']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_email']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_email']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_email']"
DEBUG:south:execute "ALTER TABLE "oozie_email" ALTER COLUMN "body" TYPE text, ALTER COLUMN "body" SET NOT NULL, ALTER COLUMN "body" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_subworkflow" ADD CONSTRAINT "sub_workflow_id_refs_job_ptr_id_b9cfb611" FOREIGN KEY ("sub_workflow_id") REFERENCES "oozie_workflow" ("job_ptr_id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_subworkflow_sub_workflow_id" ON "oozie_subworkflow" ("sub_workflow_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_subworkflow" ADD CONSTRAINT "node_ptr_id_refs_id_9a2f74e6" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0013_auto__add_generic
DEBUG:south:execute "CREATE TABLE "oozie_generic" ("xml" text NOT NULL, "node_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_generic" ADD CONSTRAINT "node_ptr_id_refs_id_52bde32b" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0014_auto__add_decisionend
DEBUG:south:execute "CREATE TABLE "oozie_decisionend" ("node_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_decisionend" ADD CONSTRAINT "node_ptr_id_refs_id_31e174a0" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0015_auto__add_field_dataset_advanced_start_instance__add_field_dataset_ins
DEBUG:south:execute "ALTER TABLE "oozie_dataset" ADD COLUMN "advanced_start_instance" varchar(128) NOT NULL DEFAULT '0';" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_dataset" ALTER COLUMN "advanced_start_instance" TYPE varchar(128), ALTER COLUMN "advanced_start_instance" SET NOT NULL, ALTER COLUMN "advanced_start_instance" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_dataset" ADD COLUMN "instance_choice" varchar(10) NOT NULL DEFAULT 'default';" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_dataset" ALTER COLUMN "instance_choice" TYPE varchar(10), ALTER COLUMN "instance_choice" SET NOT NULL, ALTER COLUMN "instance_choice" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_dataset" ADD COLUMN "advanced_end_instance" varchar(128) NOT NULL DEFAULT '0';" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_dataset" ALTER COLUMN "advanced_end_instance" TYPE varchar(128), ALTER COLUMN "advanced_end_instance" SET NOT NULL, ALTER COLUMN "advanced_end_instance" DROP DEFAULT;" with params "[]"
> oozie:0016_auto__add_field_coordinator_job_properties
DEBUG:south:execute "ALTER TABLE "oozie_coordinator" ADD COLUMN "job_properties" text NOT NULL DEFAULT '[]';" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_coordinator" ALTER COLUMN "job_properties" TYPE text, ALTER COLUMN "job_properties" SET NOT NULL, ALTER COLUMN "job_properties" DROP DEFAULT;" with params "[]"
> oozie:0017_auto__add_bundledcoordinator__add_bundle
DEBUG:south:execute "CREATE TABLE "oozie_bundledcoordinator" ("coordinator_id" integer NOT NULL, "parameters" text NOT NULL, "id" serial NOT NULL PRIMARY KEY, "bundle_id" integer NOT NULL)" with params "[]"
DEBUG:south:execute "CREATE TABLE "oozie_bundle" ("kick_off_time" timestamp with time zone NOT NULL, "job_ptr_id" integer NOT NULL PRIMARY KEY)" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_bundledcoordinator" ADD CONSTRAINT "coordinator_id_refs_job_ptr_id_4b9a476a" FOREIGN KEY ("coordinator_id") REFERENCES "oozie_coordinator" ("job_ptr_id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_bundledcoordinator_coordinator_id" ON "oozie_bundledcoordinator" ("coordinator_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_bundledcoordinator" ADD CONSTRAINT "bundle_id_refs_job_ptr_id_49f6b676" FOREIGN KEY ("bundle_id") REFERENCES "oozie_bundle" ("job_ptr_id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_bundledcoordinator_bundle_id" ON "oozie_bundledcoordinator" ("bundle_id");" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_bundle" ADD CONSTRAINT "job_ptr_id_refs_id_dfe854cc" FOREIGN KEY ("job_ptr_id") REFERENCES "oozie_job" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
> oozie:0018_auto__add_field_workflow_managed
DEBUG:south:execute "ALTER TABLE "oozie_workflow" ADD COLUMN "managed" boolean NOT NULL DEFAULT True;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_workflow" ALTER COLUMN "managed" TYPE boolean, ALTER COLUMN "managed" SET NOT NULL, ALTER COLUMN "managed" DROP DEFAULT;" with params "[]"
> oozie:0019_auto__add_field_java_capture_output
DEBUG:south:execute "ALTER TABLE "oozie_java" ADD COLUMN "capture_output" boolean NOT NULL DEFAULT False;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_java" ALTER COLUMN "capture_output" TYPE boolean, ALTER COLUMN "capture_output" SET NOT NULL, ALTER COLUMN "capture_output" DROP DEFAULT;" with params "[]"
> oozie:0020_chg_large_varchars_to_textfields
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "ALTER TABLE "oozie_java" ALTER COLUMN "args" TYPE text, ALTER COLUMN "args" SET NOT NULL, ALTER COLUMN "args" DROP DEFAULT;" with params "[]"
> oozie:0021_auto__chg_field_java_args__add_field_job_is_trashed
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_java']"
DEBUG:south:execute "ALTER TABLE "oozie_java" ALTER COLUMN "args" TYPE text, ALTER COLUMN "args" SET NOT NULL, ALTER COLUMN "args" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_job" ADD COLUMN "is_trashed" boolean NOT NULL DEFAULT False;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_job" ALTER COLUMN "is_trashed" TYPE boolean, ALTER COLUMN "is_trashed" SET NOT NULL, ALTER COLUMN "is_trashed" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "CREATE INDEX "oozie_job_is_trashed" ON "oozie_job" ("is_trashed");" with params "[]"
> oozie:0022_auto__chg_field_mapreduce_node_ptr__chg_field_start_node_ptr
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.constraint_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "
SELECT kc.constraint_name, kc.column_name, c.constraint_type
FROM information_schema.key_column_usage AS kc
JOIN information_schema.table_constraints AS c ON
kc.table_schema = c.table_schema AND
kc.table_name = c.table_name AND
kc.constraint_name = c.constraint_name
WHERE
kc.table_schema = %s AND
kc.table_name = %s
" with params "['public', 'oozie_mapreduce']"
DEBUG:south:execute "ALTER TABLE "oozie_mapreduce" ALTER COLUMN "node_ptr_id" TYPE integer, ALTER COLUMN "node_ptr_id" SET NOT NULL, ALTER COLUMN "node_ptr_id" DROP DEFAULT;" with params "[]"
DEBUG:south:execute "ALTER TABLE "oozie_mapreduce" ADD CONSTRAINT "node_ptr_id_refs_id_faafd42d" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;" with params "[]"
FATAL ERROR - The following SQL query failed: ALTER TABLE "oozie_mapreduce" ADD CONSTRAINT "node_ptr_id_refs_id_faafd42d" FOREIGN KEY ("node_ptr_id") REFERENCES "oozie_node" ("id") DEFERRABLE INITIALLY DEFERRED;
The error was: constraint "node_ptr_id_refs_id_faafd42d" for relation "oozie_mapreduce" already exists
Error in migration: oozie:0022_auto__chg_field_mapreduce_node_ptr__chg_field_start_node_ptr
Traceback (most recent call last):
File "./build/env/bin/hue", line 9, in <module>
load_entry_point('desktop==3.10.0', 'console_scripts', 'hue')()
File "/hue/desktop/core/src/desktop/manage_entry.py", line 59, in entry
execute_from_command_line(sys.argv)
File "/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/core/management/__init__.py", line 399, in execute_from_command_line
utility.execute()
File "/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/core/management/__init__.py", line 392, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/core/management/base.py", line 242, in run_from_argv
self.execute(*args, **options.__dict__)
File "/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/core/management/base.py", line 285, in execute
output = self.handle(*args, **options)
File "/hue/build/env/lib/python2.7/site-packages/South-1.0.2-py2.7.egg/south/management/commands/migrate.py", line 111, in handle
ignore_ghosts = ignore_ghosts,
File "/hue/build/env/lib/python2.7/site-packages/South-1.0.2-py2.7.egg/south/migration/__init__.py", line 220, in migrate_app
success = migrator.migrate_many(target, workplan, database)
File "/hue/build/env/lib/python2.7/site-packages/South-1.0.2-py2.7.egg/south/migration/migrators.py", line 256, in migrate_many
result = migrator.__class__.migrate_many(migrator, target, migrations, database)
File "/hue/build/env/lib/python2.7/site-packages/South-1.0.2-py2.7.egg/south/migration/migrators.py", line 331, in migrate_many
result = self.migrate(migration, database)
File "/hue/build/env/lib/python2.7/site-packages/South-1.0.2-py2.7.egg/south/migration/migrators.py", line 133, in migrate
result = self.run(migration, database)
File "/hue/build/env/lib/python2.7/site-packages/South-1.0.2-py2.7.egg/south/migration/migrators.py", line 114, in run
return self.run_migration(migration, database)
File "/hue/build/env/lib/python2.7/site-packages/South-1.0.2-py2.7.egg/south/migration/migrators.py", line 84, in run_migration
migration_function()
File "/hue/build/env/lib/python2.7/site-packages/South-1.0.2-py2.7.egg/south/migration/migrators.py", line 60, in <lambda>
return (lambda: direction(orm))
File "/hue/apps/oozie/src/oozie/migrations/0022_auto__chg_field_mapreduce_node_ptr__chg_field_start_node_ptr.py", line 12, in forwards
db.alter_column('oozie_mapreduce', 'node_ptr_id', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['oozie.Node'], unique=True, primary_key=True))
File "/hue/build/env/lib/python2.7/site-packages/South-1.0.2-py2.7.egg/south/db/generic.py", line 47, in _cache_clear
return func(self, table, *args, **opts)
File "/hue/build/env/lib/python2.7/site-packages/South-1.0.2-py2.7.egg/south/db/generic.py", line 555, in alter_column
field.rel.to._meta.get_field(field.rel.field_name).column
File "/hue/build/env/lib/python2.7/site-packages/South-1.0.2-py2.7.egg/south/db/generic.py", line 282, in execute
cursor.execute(sql, params)
File "/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/backends/util.py", line 53, in execute
return self.cursor.execute(sql, params)
File "/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/utils.py", line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/backends/util.py", line 53, in execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: constraint "node_ptr_id_refs_id_faafd42d" for relation "oozie_mapreduce" already exists
Could you drop the DB and do 'syncdb' then 'migrate'?
hi. thx, I removed the sceme, delete the database, and then create the database and everything was ok
Hi, I'm using Docker container Hue and want to use an external database. but attempts to do that get error