API tools faq
paste
Guest User

Katello import errors.

a guest
Jun 29th, 2020
166
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 60.04 KB | None | 0 0
raw download clone embed print report
  1. foreman-rake db:import_dump file=/var/lib/foreman/db/foreman.1592992346.sql
  2. Your backup is going to be imported from: /var/lib/foreman/db/foreman.1592992346.sql
  3. You can backup the old database 'foreman' by running:
  4. - foreman-rake db:dump destination=/mydir/dumps/foreman.sql RAILS_ENV=production
  5. This task will destroy your old database tables! Are you sure you want to continue? [y/N]
  6. y
  7. pg_restore: while PROCESSING TOC:
  8. pg_restore: from TOC entry 4651; 2606 17097 FK CONSTRAINT subnets subnets_discovery_id_fk foreman
  9. pg_restore: error: could not execute query: ERROR: constraint "subnets_discovery_id_fk" of relation "subnets" does not exist
  10. Command was: ALTER TABLE ONLY public.subnets DROP CONSTRAINT subnets_discovery_id_fk;
  11. pg_restore: from TOC entry 4730; 2606 16692 FK CONSTRAINT discovery_rules discovery_rules_hostgroup_id_fk foreman
  12. pg_restore: error: could not execute query: ERROR: relation "public.discovery_rules" does not exist
  13. Command was: ALTER TABLE ONLY public.discovery_rules DROP CONSTRAINT discovery_rules_hostgroup_id_fk;
  14. pg_restore: from TOC entry 4731; 2606 16687 FK CONSTRAINT discovery_attribute_sets discovery_attribute_sets_host_id_fk foreman
  15. pg_restore: error: could not execute query: ERROR: relation "public.discovery_attribute_sets" does not exist
  16. Command was: ALTER TABLE ONLY public.discovery_attribute_sets DROP CONSTRAINT discovery_attribute_sets_host_id_fk;
  17. pg_restore: from TOC entry 4328; 1259 16392 INDEX unique_schema_migrations foreman
  18. pg_restore: error: could not execute query: ERROR: index "unique_schema_migrations" does not exist
  19. Command was: DROP INDEX public.unique_schema_migrations;
  20. pg_restore: from TOC entry 4614; 1259 413144 INDEX index_discovery_rules_on_priority foreman
  21. pg_restore: error: could not execute query: ERROR: index "index_discovery_rules_on_priority" does not exist
  22. Command was: DROP INDEX public.index_discovery_rules_on_priority;
  23. pg_restore: from TOC entry 4617; 1259 413105 INDEX index_discovery_attribute_sets_on_host_id foreman
  24. pg_restore: error: could not execute query: ERROR: index "index_discovery_attribute_sets_on_host_id" does not exist
  25. Command was: DROP INDEX public.index_discovery_attribute_sets_on_host_id;
  26. pg_restore: from TOC entry 4409; 2606 16655 CONSTRAINT users users_pkey foreman
  27. pg_restore: error: could not execute query: ERROR: cannot drop constraint users_pkey on table public.users because other objects depend on it
  28. DETAIL: constraint activation_keys_user_id_fk on table public.katello_activation_keys depends on index public.users_pkey
  29. constraint task_statuses_user_id_fk on table public.katello_task_statuses depends on index public.users_pkey
  30. constraint fk_rails_ee1659f1ac on table public.katello_subscription_facets depends on index public.users_pkey
  31. constraint fk_rails_a56904dd86 on table public.foreman_tasks_tasks depends on index public.users_pkey
  32. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  33. Command was: ALTER TABLE ONLY public.users DROP CONSTRAINT users_pkey;
  34. pg_restore: from TOC entry 4489; 2606 16642 CONSTRAINT taxonomies taxonomies_pkey foreman
  35. pg_restore: error: could not execute query: ERROR: cannot drop constraint taxonomies_pkey on table public.taxonomies because other objects depend on it
  36. DETAIL: constraint katello_content_views_organization_fk on table public.katello_content_views depends on index public.taxonomies_pkey
  37. constraint katello_task_statuses_organization_fk on table public.katello_task_statuses depends on index public.taxonomies_pkey
  38. constraint katello_sync_plans_organization_fk on table public.katello_sync_plans depends on index public.taxonomies_pkey
  39. constraint katello_providers_organization_fk on table public.katello_providers depends on index public.taxonomies_pkey
  40. constraint katello_gpg_keys_organization_fk on table public.katello_gpg_keys depends on index public.taxonomies_pkey
  41. constraint katello_products_organization_fk on table public.katello_products depends on index public.taxonomies_pkey
  42. constraint katello_activation_keys_organization_fk on table public.katello_activation_keys depends on index public.taxonomies_pkey
  43. constraint katello_host_collections_organization_fk on table public.katello_host_collections depends on index public.taxonomies_pkey
  44. constraint katello_environments_organization_fk on table public.katello_environments depends on index public.taxonomies_pkey
  45. constraint katello_subscriptions_organization_fk on table public.katello_subscriptions depends on index public.taxonomies_pkey
  46. constraint katello_pools_organization_id on table public.katello_pools depends on index public.taxonomies_pkey
  47. constraint fk_rails_7d58ab6001 on table public.katello_contents depends on index public.taxonomies_pkey
  48. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  49. Command was: ALTER TABLE ONLY public.taxonomies DROP CONSTRAINT taxonomies_pkey;
  50. pg_restore: from TOC entry 4455; 2606 16633 CONSTRAINT smart_proxies smart_proxies_pkey foreman
  51. pg_restore: error: could not execute query: ERROR: cannot drop constraint smart_proxies_pkey on table public.smart_proxies because other objects depend on it
  52. DETAIL: constraint hostgroups_content_source_id_fk on table public.hostgroups depends on index public.smart_proxies_pkey
  53. constraint katello_capsule_lifecycle_environments_capsule_fk on table public.katello_capsule_lifecycle_environments depends on index public.smart_proxies_pkey
  54. constraint katello_content_facets_content_source_id_fk on table public.katello_content_facets depends on index public.smart_proxies_pkey
  55. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  56. Command was: ALTER TABLE ONLY public.smart_proxies DROP CONSTRAINT smart_proxies_pkey;
  57. pg_restore: from TOC entry 4555; 2606 16632 CONSTRAINT setup_provisioners setup_provisioners_pkey foreman
  58. pg_restore: error: could not execute query: ERROR: relation "public.setup_provisioners" does not exist
  59. Command was: ALTER TABLE ONLY public.setup_provisioners DROP CONSTRAINT setup_provisioners_pkey;
  60. pg_restore: from TOC entry 4602; 2606 16606 CONSTRAINT http_proxies http_proxies_pkey foreman
  61. pg_restore: error: could not execute query: ERROR: cannot drop constraint http_proxies_pkey on table public.http_proxies because other objects depend on it
  62. DETAIL: constraint fk_rails_4c4627948f on table public.katello_root_repositories depends on index public.http_proxies_pkey
  63. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  64. Command was: ALTER TABLE ONLY public.http_proxies DROP CONSTRAINT http_proxies_pkey;
  65. pg_restore: from TOC entry 4335; 2606 16605 CONSTRAINT hosts hosts_pkey foreman
  66. pg_restore: error: could not execute query: ERROR: cannot drop constraint hosts_pkey on table public.hosts because other objects depend on it
  67. DETAIL: constraint katello_subscription_facets_host_id on table public.katello_subscription_facets depends on index public.hosts_pkey
  68. constraint katello_content_facets_host_id on table public.katello_content_facets depends on index public.hosts_pkey
  69. constraint katello_host_collection_hosts_host_id_fk on table public.katello_host_collection_hosts depends on index public.hosts_pkey
  70. constraint katello_host_trace_host_id on table public.katello_host_tracers depends on index public.hosts_pkey
  71. constraint katello_host_installed_packages_host_id on table public.katello_host_installed_packages depends on index public.hosts_pkey
  72. constraint katello_host_installed_debs_host_id on table public.katello_host_installed_debs depends on index public.hosts_pkey
  73. constraint katello_pools_hypervisor_fk on table public.katello_pools depends on index public.hosts_pkey
  74. constraint katello_hems_host_id_fk on table public.katello_host_available_module_streams depends on index public.hosts_pkey
  75. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  76. Command was: ALTER TABLE ONLY public.hosts DROP CONSTRAINT hosts_pkey;
  77. pg_restore: from TOC entry 4377; 2606 16591 CONSTRAINT environments environments_pkey foreman
  78. pg_restore: error: could not execute query: ERROR: cannot drop constraint environments_pkey on table public.environments because other objects depend on it
  79. DETAIL: constraint katello_cvpe_pe_id on table public.katello_content_view_puppet_environments depends on index public.environments_pkey
  80. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  81. Command was: ALTER TABLE ONLY public.environments DROP CONSTRAINT environments_pkey;
  82. pg_restore: from TOC entry 4613; 2606 16583 CONSTRAINT discovery_rules discovery_rules_pkey foreman
  83. pg_restore: error: could not execute query: ERROR: relation "public.discovery_rules" does not exist
  84. Command was: ALTER TABLE ONLY public.discovery_rules DROP CONSTRAINT discovery_rules_pkey;
  85. pg_restore: from TOC entry 4616; 2606 16582 CONSTRAINT discovery_attribute_sets discovery_attribute_sets_pkey foreman
  86. pg_restore: error: could not execute query: ERROR: relation "public.discovery_attribute_sets" does not exist
  87. Command was: ALTER TABLE ONLY public.discovery_attribute_sets DROP CONSTRAINT discovery_attribute_sets_pkey;
  88. pg_restore: from TOC entry 4293; 2604 16545 DEFAULT setup_provisioners id foreman
  89. pg_restore: error: could not execute query: ERROR: relation "public.setup_provisioners" does not exist
  90. Command was: ALTER TABLE public.setup_provisioners ALTER COLUMN id DROP DEFAULT;
  91. pg_restore: from TOC entry 4300; 2604 16502 DEFAULT dynflow_envelopes id foreman
  92. pg_restore: error: could not execute query: ERROR: column "id" of relation "dynflow_envelopes" is an identity column
  93. HINT: Use ALTER TABLE ... ALTER COLUMN ... DROP IDENTITY instead.
  94. Command was: ALTER TABLE public.dynflow_envelopes ALTER COLUMN id DROP DEFAULT;
  95. pg_restore: from TOC entry 4318; 2604 16500 DEFAULT discovery_rules id foreman
  96. pg_restore: error: could not execute query: ERROR: relation "public.discovery_rules" does not exist
  97. Command was: ALTER TABLE public.discovery_rules ALTER COLUMN id DROP DEFAULT;
  98. pg_restore: from TOC entry 4323; 2604 16499 DEFAULT discovery_attribute_sets id foreman
  99. pg_restore: error: could not execute query: ERROR: relation "public.discovery_attribute_sets" does not exist
  100. Command was: ALTER TABLE public.discovery_attribute_sets ALTER COLUMN id DROP DEFAULT;
  101. pg_restore: from TOC entry 242; 1259 16677 TABLE users foreman
  102. pg_restore: error: could not execute query: ERROR: cannot drop table public.users because other objects depend on it
  103. DETAIL: constraint activation_keys_user_id_fk on table public.katello_activation_keys depends on table public.users
  104. constraint task_statuses_user_id_fk on table public.katello_task_statuses depends on table public.users
  105. constraint fk_rails_ee1659f1ac on table public.katello_subscription_facets depends on table public.users
  106. constraint fk_rails_a56904dd86 on table public.foreman_tasks_tasks depends on table public.users
  107. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  108. Command was: DROP TABLE public.users;
  109. pg_restore: from TOC entry 294; 1259 17084 TABLE taxonomies foreman
  110. pg_restore: error: could not execute query: ERROR: cannot drop table public.taxonomies because other objects depend on it
  111. DETAIL: constraint katello_content_views_organization_fk on table public.katello_content_views depends on table public.taxonomies
  112. constraint katello_task_statuses_organization_fk on table public.katello_task_statuses depends on table public.taxonomies
  113. constraint katello_sync_plans_organization_fk on table public.katello_sync_plans depends on table public.taxonomies
  114. constraint katello_providers_organization_fk on table public.katello_providers depends on table public.taxonomies
  115. constraint katello_gpg_keys_organization_fk on table public.katello_gpg_keys depends on table public.taxonomies
  116. constraint katello_products_organization_fk on table public.katello_products depends on table public.taxonomies
  117. constraint katello_activation_keys_organization_fk on table public.katello_activation_keys depends on table public.taxonomies
  118. constraint katello_host_collections_organization_fk on table public.katello_host_collections depends on table public.taxonomies
  119. constraint katello_environments_organization_fk on table public.katello_environments depends on table public.taxonomies
  120. constraint katello_subscriptions_organization_fk on table public.katello_subscriptions depends on table public.taxonomies
  121. constraint katello_pools_organization_id on table public.katello_pools depends on table public.taxonomies
  122. constraint fk_rails_7d58ab6001 on table public.katello_contents depends on table public.taxonomies
  123. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  124. Command was: DROP TABLE public.taxonomies;
  125. pg_restore: from TOC entry 274; 1259 16915 TABLE smart_proxies foreman
  126. pg_restore: error: could not execute query: ERROR: cannot drop table public.smart_proxies because other objects depend on it
  127. DETAIL: constraint hostgroups_content_source_id_fk on table public.hostgroups depends on table public.smart_proxies
  128. constraint katello_capsule_lifecycle_environments_capsule_fk on table public.katello_capsule_lifecycle_environments depends on table public.smart_proxies
  129. constraint katello_content_facets_content_source_id_fk on table public.katello_content_facets depends on table public.smart_proxies
  130. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  131. Command was: DROP TABLE public.smart_proxies;
  132. pg_restore: from TOC entry 338; 1259 18582 SEQUENCE setup_provisioners_id_seq foreman
  133. pg_restore: error: could not execute query: ERROR: sequence "setup_provisioners_id_seq" does not exist
  134. Command was: DROP SEQUENCE public.setup_provisioners_id_seq;
  135. pg_restore: from TOC entry 339; 1259 18584 TABLE setup_provisioners foreman
  136. pg_restore: error: could not execute query: ERROR: table "setup_provisioners" does not exist
  137. Command was: DROP TABLE public.setup_provisioners;
  138. pg_restore: from TOC entry 360; 1259 188007 TABLE http_proxies foreman
  139. pg_restore: error: could not execute query: ERROR: cannot drop table public.http_proxies because other objects depend on it
  140. DETAIL: constraint fk_rails_4c4627948f on table public.katello_root_repositories depends on table public.http_proxies
  141. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  142. Command was: DROP TABLE public.http_proxies;
  143. pg_restore: from TOC entry 204; 1259 16395 TABLE hosts foreman
  144. pg_restore: error: could not execute query: ERROR: cannot drop table public.hosts because other objects depend on it
  145. DETAIL: constraint katello_subscription_facets_host_id on table public.katello_subscription_facets depends on table public.hosts
  146. constraint katello_content_facets_host_id on table public.katello_content_facets depends on table public.hosts
  147. constraint katello_host_collection_hosts_host_id_fk on table public.katello_host_collection_hosts depends on table public.hosts
  148. constraint katello_host_trace_host_id on table public.katello_host_tracers depends on table public.hosts
  149. constraint katello_host_installed_packages_host_id on table public.katello_host_installed_packages depends on table public.hosts
  150. constraint katello_host_installed_debs_host_id on table public.katello_host_installed_debs depends on table public.hosts
  151. constraint katello_pools_hypervisor_fk on table public.katello_pools depends on table public.hosts
  152. constraint katello_hems_host_id_fk on table public.katello_host_available_module_streams depends on table public.hosts
  153. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  154. Command was: DROP TABLE public.hosts;
  155. pg_restore: from TOC entry 225; 1259 16571 TABLE environments foreman
  156. pg_restore: error: could not execute query: ERROR: cannot drop table public.environments because other objects depend on it
  157. DETAIL: constraint katello_cvpe_pe_id on table public.katello_content_view_puppet_environments depends on table public.environments
  158. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  159. Command was: DROP TABLE public.environments;
  160. pg_restore: from TOC entry 353; 1259 187888 SEQUENCE dynflow_envelopes_id_seq foreman
  161. pg_restore: error: could not execute query: ERROR: cannot drop sequence public.dynflow_envelopes_id_seq because column id of table public.dynflow_envelopes requires it
  162. HINT: You can drop column id of table public.dynflow_envelopes instead.
  163. Command was: DROP SEQUENCE public.dynflow_envelopes_id_seq;
  164. pg_restore: from TOC entry 367; 1259 413078 SEQUENCE discovery_rules_id_seq foreman
  165. pg_restore: error: could not execute query: ERROR: sequence "discovery_rules_id_seq" does not exist
  166. Command was: DROP SEQUENCE public.discovery_rules_id_seq;
  167. pg_restore: from TOC entry 368; 1259 413080 TABLE discovery_rules foreman
  168. pg_restore: error: could not execute query: ERROR: table "discovery_rules" does not exist
  169. Command was: DROP TABLE public.discovery_rules;
  170. pg_restore: from TOC entry 369; 1259 413093 SEQUENCE discovery_attribute_sets_id_seq foreman
  171. pg_restore: error: could not execute query: ERROR: sequence "discovery_attribute_sets_id_seq" does not exist
  172. Command was: DROP SEQUENCE public.discovery_attribute_sets_id_seq;
  173. pg_restore: from TOC entry 370; 1259 413095 TABLE discovery_attribute_sets foreman
  174. pg_restore: error: could not execute query: ERROR: table "discovery_attribute_sets" does not exist
  175. Command was: DROP TABLE public.discovery_attribute_sets;
  176. pg_restore: from TOC entry 225; 1259 16571 TABLE environments foreman
  177. pg_restore: error: could not execute query: ERROR: relation "environments" already exists
  178. Command was: CREATE TABLE public.environments (
  179. id integer NOT NULL,
  180. name character varying(255) NOT NULL,
  181. created_at timestamp without time zone,
  182. updated_at timestamp without time zone
  183. );
  184.  
  185.  
  186. pg_restore: from TOC entry 204; 1259 16395 TABLE hosts foreman
  187. pg_restore: error: could not execute query: ERROR: relation "hosts" already exists
  188. Command was: CREATE TABLE public.hosts (
  189. id integer NOT NULL,
  190. name character varying(255) NOT NULL,
  191. last_compile timestamp without time zone,
  192. last_report timestamp without time zone,
  193. updated_at timestamp without time zone,
  194. created_at timestamp without time zone,
  195. root_pass text,
  196. architecture_id integer,
  197. operatingsystem_id integer,
  198. environment_id integer,
  199. ptable_id integer,
  200. medium_id integer,
  201. build boolean DEFAULT false,
  202. comment text,
  203. disk text,
  204. installed_at timestamp without time zone,
  205. model_id integer,
  206. hostgroup_id integer,
  207. owner_id integer,
  208. owner_type character varying(255),
  209. enabled boolean DEFAULT true,
  210. puppet_ca_proxy_id integer,
  211. managed boolean DEFAULT false NOT NULL,
  212. use_image boolean,
  213. image_file character varying(128),
  214. uuid character varying(255),
  215. compute_resource_id integer,
  216. puppet_proxy_id integer,
  217. certname character varying(255),
  218. image_id integer,
  219. organization_id integer,
  220. location_id integer,
  221. type character varying(255),
  222. otp character varying(255),
  223. realm_id integer,
  224. compute_profile_id integer,
  225. provision_method character varying(255),
  226. grub_pass character varying(255) DEFAULT ''::character varying,
  227. global_status integer DEFAULT 0 NOT NULL,
  228. lookup_value_matcher character varying(255),
  229. pxe_loader character varying(255),
  230. initiated_at timestamp without time zone,
  231. build_errors text,
  232. discovery_rule_id integer
  233. );
  234.  
  235.  
  236. pg_restore: from TOC entry 360; 1259 188007 TABLE http_proxies foreman
  237. pg_restore: error: could not execute query: ERROR: relation "http_proxies" already exists
  238. Command was: CREATE TABLE public.http_proxies (
  239. id integer NOT NULL,
  240. name character varying NOT NULL,
  241. url character varying NOT NULL,
  242. username character varying,
  243. password character varying
  244. );
  245.  
  246.  
  247. pg_restore: from TOC entry 274; 1259 16915 TABLE smart_proxies foreman
  248. pg_restore: error: could not execute query: ERROR: relation "smart_proxies" already exists
  249. Command was: CREATE TABLE public.smart_proxies (
  250. id integer NOT NULL,
  251. name character varying(255),
  252. url character varying(255),
  253. created_at timestamp without time zone,
  254. updated_at timestamp without time zone,
  255. expired_logs character varying(255) DEFAULT '0'::character varying
  256. );
  257.  
  258.  
  259. pg_restore: from TOC entry 294; 1259 17084 TABLE taxonomies foreman
  260. pg_restore: error: could not execute query: ERROR: relation "taxonomies" already exists
  261. Command was: CREATE TABLE public.taxonomies (
  262. id integer NOT NULL,
  263. name character varying(255),
  264. type character varying(255),
  265. created_at timestamp without time zone,
  266. updated_at timestamp without time zone,
  267. ignore_types text,
  268. ancestry character varying(255),
  269. title character varying(255),
  270. description text
  271. );
  272.  
  273.  
  274. pg_restore: from TOC entry 242; 1259 16677 TABLE users foreman
  275. pg_restore: error: could not execute query: ERROR: relation "users" already exists
  276. Command was: CREATE TABLE public.users (
  277. id integer NOT NULL,
  278. login character varying(255),
  279. firstname character varying(255),
  280. lastname character varying(255),
  281. mail character varying(255),
  282. admin boolean DEFAULT false NOT NULL,
  283. last_login_on timestamp without time zone,
  284. auth_source_id integer,
  285. created_at timestamp without time zone,
  286. updated_at timestamp without time zone,
  287. password_hash character varying(128),
  288. password_salt character varying(128),
  289. locale character varying(5),
  290. avatar_hash character varying(128),
  291. default_organization_id integer,
  292. default_location_id integer,
  293. lower_login character varying(255),
  294. mail_enabled boolean DEFAULT true,
  295. timezone character varying(255),
  296. description text
  297. );
  298.  
  299.  
  300. pg_restore: from TOC entry 4862; 0 16395 TABLE DATA hosts foreman
  301. pg_restore: error: could not execute query: ERROR: column "discovery_rule_id" of relation "hosts" does not exist
  302. Command was: COPY public.hosts (id, name, last_compile, last_report, updated_at, created_at, root_pass, architecture_id, operatingsystem_id, environment_id, ptable_id, medium_id, build, comment, disk, installed_at, model_id, hostgroup_id, owner_id, owner_type, enabled, puppet_ca_proxy_id, managed, use_image, image_file, uuid, compute_resource_id, puppet_proxy_id, certname, image_id, organization_id, location_id, type, otp, realm_id, compute_profile_id, provision_method, grub_pass, global_status, lookup_value_matcher, pxe_loader, initiated_at, build_errors, discovery_rule_id) FROM stdin;
  303. pg_restore: from TOC entry 4932; 0 16915 TABLE DATA smart_proxies foreman
  304. pg_restore: error: COPY failed for table "smart_proxies": ERROR: duplicate key value violates unique constraint "smart_proxies_pkey"
  305. DETAIL: Key (id)=(1) already exists.
  306. CONTEXT: COPY smart_proxies, line 1
  307. pg_restore: from TOC entry 4952; 0 17084 TABLE DATA taxonomies foreman
  308. pg_restore: error: COPY failed for table "taxonomies": ERROR: duplicate key value violates unique constraint "taxonomies_pkey"
  309. DETAIL: Key (id)=(1) already exists.
  310. CONTEXT: COPY taxonomies, line 2
  311. pg_restore: from TOC entry 4900; 0 16677 TABLE DATA users foreman
  312. pg_restore: error: COPY failed for table "users": ERROR: duplicate key value violates unique constraint "users_pkey"
  313. DETAIL: Key (id)=(1) already exists.
  314. CONTEXT: COPY users, line 1
  315. pg_restore: from TOC entry 4377; 2606 16591 CONSTRAINT environments environments_pkey foreman
  316. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "environments" are not allowed
  317. Command was: ALTER TABLE ONLY public.environments
  318. ADD CONSTRAINT environments_pkey PRIMARY KEY (id);
  319.  
  320.  
  321. pg_restore: from TOC entry 4335; 2606 16605 CONSTRAINT hosts hosts_pkey foreman
  322. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "hosts" are not allowed
  323. Command was: ALTER TABLE ONLY public.hosts
  324. ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
  325.  
  326.  
  327. pg_restore: from TOC entry 4602; 2606 16606 CONSTRAINT http_proxies http_proxies_pkey foreman
  328. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "http_proxies" are not allowed
  329. Command was: ALTER TABLE ONLY public.http_proxies
  330. ADD CONSTRAINT http_proxies_pkey PRIMARY KEY (id);
  331.  
  332.  
  333. pg_restore: from TOC entry 4455; 2606 16633 CONSTRAINT smart_proxies smart_proxies_pkey foreman
  334. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "smart_proxies" are not allowed
  335. Command was: ALTER TABLE ONLY public.smart_proxies
  336. ADD CONSTRAINT smart_proxies_pkey PRIMARY KEY (id);
  337.  
  338.  
  339. pg_restore: from TOC entry 4489; 2606 16642 CONSTRAINT taxonomies taxonomies_pkey foreman
  340. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "taxonomies" are not allowed
  341. Command was: ALTER TABLE ONLY public.taxonomies
  342. ADD CONSTRAINT taxonomies_pkey PRIMARY KEY (id);
  343.  
  344.  
  345. pg_restore: from TOC entry 4409; 2606 16655 CONSTRAINT users users_pkey foreman
  346. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "users" are not allowed
  347. Command was: ALTER TABLE ONLY public.users
  348. ADD CONSTRAINT users_pkey PRIMARY KEY (id);
  349.  
  350.  
  351. pg_restore: from TOC entry 4646; 2606 16752 FK CONSTRAINT fact_values fact_values_host_id_fk foreman
  352. pg_restore: error: could not execute query: ERROR: insert or update on table "fact_values" violates foreign key constraint "fact_values_host_id_fk"
  353. DETAIL: Key (host_id)=(1) is not present in table "hosts".
  354. Command was: ALTER TABLE ONLY public.fact_values
  355. ADD CONSTRAINT fact_values_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  356.  
  357.  
  358. pg_restore: from TOC entry 4695; 2606 16762 FK CONSTRAINT smart_proxy_features features_smart_proxies_smart_proxy_id_fk foreman
  359. pg_restore: error: could not execute query: ERROR: insert or update on table "smart_proxy_features" violates foreign key constraint "features_smart_proxies_smart_proxy_id_fk"
  360. DETAIL: Key (smart_proxy_id)=(2) is not present in table "smart_proxies".
  361. Command was: ALTER TABLE ONLY public.smart_proxy_features
  362. ADD CONSTRAINT features_smart_proxies_smart_proxy_id_fk FOREIGN KEY (smart_proxy_id) REFERENCES public.smart_proxies(id);
  363.  
  364.  
  365. pg_restore: from TOC entry 4721; 2606 16792 FK CONSTRAINT notification_recipients fk_rails_51975e21a8 foreman
  366. pg_restore: error: could not execute query: ERROR: insert or update on table "notification_recipients" violates foreign key constraint "fk_rails_51975e21a8"
  367. DETAIL: Key (user_id)=(13) is not present in table "users".
  368. Command was: ALTER TABLE ONLY public.notification_recipients
  369. ADD CONSTRAINT fk_rails_51975e21a8 FOREIGN KEY (user_id) REFERENCES public.users(id);
  370.  
  371.  
  372. pg_restore: from TOC entry 4733; 2606 16807 FK CONSTRAINT host_facets_reported_data_facets fk_rails_a82ac722f1 foreman
  373. pg_restore: error: could not execute query: ERROR: insert or update on table "host_facets_reported_data_facets" violates foreign key constraint "fk_rails_a82ac722f1"
  374. DETAIL: Key (host_id)=(1011) is not present in table "hosts".
  375. Command was: ALTER TABLE ONLY public.host_facets_reported_data_facets
  376. ADD CONSTRAINT fk_rails_a82ac722f1 FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  377.  
  378.  
  379. pg_restore: from TOC entry 4660; 2606 16822 FK CONSTRAINT host_classes host_classes_host_id_fk foreman
  380. pg_restore: error: could not execute query: ERROR: insert or update on table "host_classes" violates foreign key constraint "host_classes_host_id_fk"
  381. DETAIL: Key (host_id)=(897) is not present in table "hosts".
  382. Command was: ALTER TABLE ONLY public.host_classes
  383. ADD CONSTRAINT host_classes_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  384.  
  385.  
  386. pg_restore: from TOC entry 4718; 2606 16832 FK CONSTRAINT host_status host_status_hosts_host_id_fk foreman
  387. pg_restore: error: could not execute query: ERROR: insert or update on table "host_status" violates foreign key constraint "host_status_hosts_host_id_fk"
  388. DETAIL: Key (host_id)=(1018) is not present in table "hosts".
  389. Command was: ALTER TABLE ONLY public.host_status
  390. ADD CONSTRAINT host_status_hosts_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  391.  
  392.  
  393. pg_restore: from TOC entry 4673; 2606 16887 FK CONSTRAINT hostgroups hostgroups_puppet_proxy_id_fk foreman
  394. pg_restore: error: could not execute query: ERROR: insert or update on table "hostgroups" violates foreign key constraint "hostgroups_puppet_proxy_id_fk"
  395. DETAIL: Key (puppet_proxy_id)=(2) is not present in table "smart_proxies".
  396. Command was: ALTER TABLE ONLY public.hostgroups
  397. ADD CONSTRAINT hostgroups_puppet_proxy_id_fk FOREIGN KEY (puppet_proxy_id) REFERENCES public.smart_proxies(id);
  398.  
  399.  
  400. pg_restore: from TOC entry 4699; 2606 17022 FK CONSTRAINT nics nics_host_id_fk foreman
  401. pg_restore: error: could not execute query: ERROR: insert or update on table "nics" violates foreign key constraint "nics_host_id_fk"
  402. DETAIL: Key (host_id)=(815) is not present in table "hosts".
  403. Command was: ALTER TABLE ONLY public.nics
  404. ADD CONSTRAINT nics_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  405.  
  406.  
  407. pg_restore: from TOC entry 4657; 2606 17077 FK CONSTRAINT reports reports_host_id_fk foreman
  408. pg_restore: error: could not execute query: ERROR: insert or update on table "reports" violates foreign key constraint "reports_host_id_fk"
  409. DETAIL: Key (host_id)=(865) is not present in table "hosts".
  410. Command was: ALTER TABLE ONLY public.reports
  411. ADD CONSTRAINT reports_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  412.  
  413.  
  414. pg_restore: from TOC entry 4653; 2606 17107 FK CONSTRAINT subnets subnets_tftp_id_fk foreman
  415. pg_restore: error: could not execute query: ERROR: insert or update on table "subnets" violates foreign key constraint "subnets_tftp_id_fk"
  416. DETAIL: Key (tftp_id)=(5) is not present in table "smart_proxies".
  417. Command was: ALTER TABLE ONLY public.subnets
  418. ADD CONSTRAINT subnets_tftp_id_fk FOREIGN KEY (tftp_id) REFERENCES public.smart_proxies(id);
  419.  
  420.  
  421. pg_restore: from TOC entry 4707; 2606 17117 FK CONSTRAINT taxable_taxonomies taxable_taxonomies_taxonomy_id_fk foreman
  422. pg_restore: error: could not execute query: ERROR: insert or update on table "taxable_taxonomies" violates foreign key constraint "taxable_taxonomies_taxonomy_id_fk"
  423. DETAIL: Key (taxonomy_id)=(4) is not present in table "taxonomies".
  424. Command was: ALTER TABLE ONLY public.taxable_taxonomies
  425. ADD CONSTRAINT taxable_taxonomies_taxonomy_id_fk FOREIGN KEY (taxonomy_id) REFERENCES public.taxonomies(id);
  426.  
  427.  
  428. pg_restore: from TOC entry 4705; 2606 17142 FK CONSTRAINT tokens tokens_host_id_fk foreman
  429. pg_restore: error: could not execute query: ERROR: insert or update on table "tokens" violates foreign key constraint "tokens_host_id_fk"
  430. DETAIL: Key (host_id)=(1052) is not present in table "hosts".
  431. Command was: ALTER TABLE ONLY public.tokens
  432. ADD CONSTRAINT tokens_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  433.  
  434.  
  435. pg_restore: from TOC entry 4717; 2606 17157 FK CONSTRAINT user_mail_notifications user_mail_notifications_user_id_fk foreman
  436. pg_restore: error: could not execute query: ERROR: insert or update on table "user_mail_notifications" violates foreign key constraint "user_mail_notifications_user_id_fk"
  437. DETAIL: Key (user_id)=(28) is not present in table "users".
  438. Command was: ALTER TABLE ONLY public.user_mail_notifications
  439. ADD CONSTRAINT user_mail_notifications_user_id_fk FOREIGN KEY (user_id) REFERENCES public.users(id);
  440.  
  441.  
  442. pg_restore: warning: errors ignored on restore: 61
  443. pg_restore: while PROCESSING TOC:
  444. pg_restore: from TOC entry 4717; 2606 17157 FK CONSTRAINT user_mail_notifications user_mail_notifications_user_id_fk foreman
  445. pg_restore: error: could not execute query: ERROR: constraint "user_mail_notifications_user_id_fk" of relation "user_mail_notifications" does not exist
  446. Command was: ALTER TABLE ONLY public.user_mail_notifications DROP CONSTRAINT user_mail_notifications_user_id_fk;
  447. pg_restore: from TOC entry 4705; 2606 17142 FK CONSTRAINT tokens tokens_host_id_fk foreman
  448. pg_restore: error: could not execute query: ERROR: constraint "tokens_host_id_fk" of relation "tokens" does not exist
  449. Command was: ALTER TABLE ONLY public.tokens DROP CONSTRAINT tokens_host_id_fk;
  450. pg_restore: from TOC entry 4707; 2606 17117 FK CONSTRAINT taxable_taxonomies taxable_taxonomies_taxonomy_id_fk foreman
  451. pg_restore: error: could not execute query: ERROR: constraint "taxable_taxonomies_taxonomy_id_fk" of relation "taxable_taxonomies" does not exist
  452. Command was: ALTER TABLE ONLY public.taxable_taxonomies DROP CONSTRAINT taxable_taxonomies_taxonomy_id_fk;
  453. pg_restore: from TOC entry 4653; 2606 17107 FK CONSTRAINT subnets subnets_tftp_id_fk foreman
  454. pg_restore: error: could not execute query: ERROR: constraint "subnets_tftp_id_fk" of relation "subnets" does not exist
  455. Command was: ALTER TABLE ONLY public.subnets DROP CONSTRAINT subnets_tftp_id_fk;
  456. pg_restore: from TOC entry 4657; 2606 17077 FK CONSTRAINT reports reports_host_id_fk foreman
  457. pg_restore: error: could not execute query: ERROR: constraint "reports_host_id_fk" of relation "reports" does not exist
  458. Command was: ALTER TABLE ONLY public.reports DROP CONSTRAINT reports_host_id_fk;
  459. pg_restore: from TOC entry 4699; 2606 17022 FK CONSTRAINT nics nics_host_id_fk foreman
  460. pg_restore: error: could not execute query: ERROR: constraint "nics_host_id_fk" of relation "nics" does not exist
  461. Command was: ALTER TABLE ONLY public.nics DROP CONSTRAINT nics_host_id_fk;
  462. pg_restore: from TOC entry 4673; 2606 16887 FK CONSTRAINT hostgroups hostgroups_puppet_proxy_id_fk foreman
  463. pg_restore: error: could not execute query: ERROR: constraint "hostgroups_puppet_proxy_id_fk" of relation "hostgroups" does not exist
  464. Command was: ALTER TABLE ONLY public.hostgroups DROP CONSTRAINT hostgroups_puppet_proxy_id_fk;
  465. pg_restore: from TOC entry 4718; 2606 16832 FK CONSTRAINT host_status host_status_hosts_host_id_fk foreman
  466. pg_restore: error: could not execute query: ERROR: constraint "host_status_hosts_host_id_fk" of relation "host_status" does not exist
  467. Command was: ALTER TABLE ONLY public.host_status DROP CONSTRAINT host_status_hosts_host_id_fk;
  468. pg_restore: from TOC entry 4660; 2606 16822 FK CONSTRAINT host_classes host_classes_host_id_fk foreman
  469. pg_restore: error: could not execute query: ERROR: constraint "host_classes_host_id_fk" of relation "host_classes" does not exist
  470. Command was: ALTER TABLE ONLY public.host_classes DROP CONSTRAINT host_classes_host_id_fk;
  471. pg_restore: from TOC entry 4733; 2606 16807 FK CONSTRAINT host_facets_reported_data_facets fk_rails_a82ac722f1 foreman
  472. pg_restore: error: could not execute query: ERROR: constraint "fk_rails_a82ac722f1" of relation "host_facets_reported_data_facets" does not exist
  473. Command was: ALTER TABLE ONLY public.host_facets_reported_data_facets DROP CONSTRAINT fk_rails_a82ac722f1;
  474. pg_restore: from TOC entry 4721; 2606 16792 FK CONSTRAINT notification_recipients fk_rails_51975e21a8 foreman
  475. pg_restore: error: could not execute query: ERROR: constraint "fk_rails_51975e21a8" of relation "notification_recipients" does not exist
  476. Command was: ALTER TABLE ONLY public.notification_recipients DROP CONSTRAINT fk_rails_51975e21a8;
  477. pg_restore: from TOC entry 4695; 2606 16762 FK CONSTRAINT smart_proxy_features features_smart_proxies_smart_proxy_id_fk foreman
  478. pg_restore: error: could not execute query: ERROR: constraint "features_smart_proxies_smart_proxy_id_fk" of relation "smart_proxy_features" does not exist
  479. Command was: ALTER TABLE ONLY public.smart_proxy_features DROP CONSTRAINT features_smart_proxies_smart_proxy_id_fk;
  480. pg_restore: from TOC entry 4646; 2606 16752 FK CONSTRAINT fact_values fact_values_host_id_fk foreman
  481. pg_restore: error: could not execute query: ERROR: constraint "fact_values_host_id_fk" of relation "fact_values" does not exist
  482. Command was: ALTER TABLE ONLY public.fact_values DROP CONSTRAINT fact_values_host_id_fk;
  483. pg_restore: from TOC entry 4409; 2606 16655 CONSTRAINT users users_pkey foreman
  484. pg_restore: error: could not execute query: ERROR: cannot drop constraint users_pkey on table public.users because other objects depend on it
  485. DETAIL: constraint activation_keys_user_id_fk on table public.katello_activation_keys depends on index public.users_pkey
  486. constraint task_statuses_user_id_fk on table public.katello_task_statuses depends on index public.users_pkey
  487. constraint fk_rails_ee1659f1ac on table public.katello_subscription_facets depends on index public.users_pkey
  488. constraint fk_rails_a56904dd86 on table public.foreman_tasks_tasks depends on index public.users_pkey
  489. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  490. Command was: ALTER TABLE ONLY public.users DROP CONSTRAINT users_pkey;
  491. pg_restore: from TOC entry 4489; 2606 16642 CONSTRAINT taxonomies taxonomies_pkey foreman
  492. pg_restore: error: could not execute query: ERROR: cannot drop constraint taxonomies_pkey on table public.taxonomies because other objects depend on it
  493. DETAIL: constraint katello_content_views_organization_fk on table public.katello_content_views depends on index public.taxonomies_pkey
  494. constraint katello_task_statuses_organization_fk on table public.katello_task_statuses depends on index public.taxonomies_pkey
  495. constraint katello_sync_plans_organization_fk on table public.katello_sync_plans depends on index public.taxonomies_pkey
  496. constraint katello_providers_organization_fk on table public.katello_providers depends on index public.taxonomies_pkey
  497. constraint katello_gpg_keys_organization_fk on table public.katello_gpg_keys depends on index public.taxonomies_pkey
  498. constraint katello_products_organization_fk on table public.katello_products depends on index public.taxonomies_pkey
  499. constraint katello_activation_keys_organization_fk on table public.katello_activation_keys depends on index public.taxonomies_pkey
  500. constraint katello_host_collections_organization_fk on table public.katello_host_collections depends on index public.taxonomies_pkey
  501. constraint katello_environments_organization_fk on table public.katello_environments depends on index public.taxonomies_pkey
  502. constraint katello_subscriptions_organization_fk on table public.katello_subscriptions depends on index public.taxonomies_pkey
  503. constraint katello_pools_organization_id on table public.katello_pools depends on index public.taxonomies_pkey
  504. constraint fk_rails_7d58ab6001 on table public.katello_contents depends on index public.taxonomies_pkey
  505. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  506. Command was: ALTER TABLE ONLY public.taxonomies DROP CONSTRAINT taxonomies_pkey;
  507. pg_restore: from TOC entry 4455; 2606 16633 CONSTRAINT smart_proxies smart_proxies_pkey foreman
  508. pg_restore: error: could not execute query: ERROR: cannot drop constraint smart_proxies_pkey on table public.smart_proxies because other objects depend on it
  509. DETAIL: constraint katello_capsule_lifecycle_environments_capsule_fk on table public.katello_capsule_lifecycle_environments depends on index public.smart_proxies_pkey
  510. constraint katello_content_facets_content_source_id_fk on table public.katello_content_facets depends on index public.smart_proxies_pkey
  511. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  512. Command was: ALTER TABLE ONLY public.smart_proxies DROP CONSTRAINT smart_proxies_pkey;
  513. pg_restore: from TOC entry 4602; 2606 16606 CONSTRAINT http_proxies http_proxies_pkey foreman
  514. pg_restore: error: could not execute query: ERROR: cannot drop constraint http_proxies_pkey on table public.http_proxies because other objects depend on it
  515. DETAIL: constraint fk_rails_4c4627948f on table public.katello_root_repositories depends on index public.http_proxies_pkey
  516. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  517. Command was: ALTER TABLE ONLY public.http_proxies DROP CONSTRAINT http_proxies_pkey;
  518. pg_restore: from TOC entry 4335; 2606 16605 CONSTRAINT hosts hosts_pkey foreman
  519. pg_restore: error: could not execute query: ERROR: cannot drop constraint hosts_pkey on table public.hosts because other objects depend on it
  520. DETAIL: constraint katello_subscription_facets_host_id on table public.katello_subscription_facets depends on index public.hosts_pkey
  521. constraint katello_content_facets_host_id on table public.katello_content_facets depends on index public.hosts_pkey
  522. constraint katello_host_collection_hosts_host_id_fk on table public.katello_host_collection_hosts depends on index public.hosts_pkey
  523. constraint katello_host_trace_host_id on table public.katello_host_tracers depends on index public.hosts_pkey
  524. constraint katello_host_installed_packages_host_id on table public.katello_host_installed_packages depends on index public.hosts_pkey
  525. constraint katello_host_installed_debs_host_id on table public.katello_host_installed_debs depends on index public.hosts_pkey
  526. constraint katello_pools_hypervisor_fk on table public.katello_pools depends on index public.hosts_pkey
  527. constraint katello_hems_host_id_fk on table public.katello_host_available_module_streams depends on index public.hosts_pkey
  528. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  529. Command was: ALTER TABLE ONLY public.hosts DROP CONSTRAINT hosts_pkey;
  530. pg_restore: from TOC entry 4377; 2606 16591 CONSTRAINT environments environments_pkey foreman
  531. pg_restore: error: could not execute query: ERROR: cannot drop constraint environments_pkey on table public.environments because other objects depend on it
  532. DETAIL: constraint katello_cvpe_pe_id on table public.katello_content_view_puppet_environments depends on index public.environments_pkey
  533. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  534. Command was: ALTER TABLE ONLY public.environments DROP CONSTRAINT environments_pkey;
  535. pg_restore: from TOC entry 242; 1259 16677 TABLE users foreman
  536. pg_restore: error: could not execute query: ERROR: cannot drop table public.users because other objects depend on it
  537. DETAIL: constraint activation_keys_user_id_fk on table public.katello_activation_keys depends on table public.users
  538. constraint task_statuses_user_id_fk on table public.katello_task_statuses depends on table public.users
  539. constraint fk_rails_ee1659f1ac on table public.katello_subscription_facets depends on table public.users
  540. constraint fk_rails_a56904dd86 on table public.foreman_tasks_tasks depends on table public.users
  541. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  542. Command was: DROP TABLE public.users;
  543. pg_restore: from TOC entry 294; 1259 17084 TABLE taxonomies foreman
  544. pg_restore: error: could not execute query: ERROR: cannot drop table public.taxonomies because other objects depend on it
  545. DETAIL: constraint katello_content_views_organization_fk on table public.katello_content_views depends on table public.taxonomies
  546. constraint katello_task_statuses_organization_fk on table public.katello_task_statuses depends on table public.taxonomies
  547. constraint katello_sync_plans_organization_fk on table public.katello_sync_plans depends on table public.taxonomies
  548. constraint katello_providers_organization_fk on table public.katello_providers depends on table public.taxonomies
  549. constraint katello_gpg_keys_organization_fk on table public.katello_gpg_keys depends on table public.taxonomies
  550. constraint katello_products_organization_fk on table public.katello_products depends on table public.taxonomies
  551. constraint katello_activation_keys_organization_fk on table public.katello_activation_keys depends on table public.taxonomies
  552. constraint katello_host_collections_organization_fk on table public.katello_host_collections depends on table public.taxonomies
  553. constraint katello_environments_organization_fk on table public.katello_environments depends on table public.taxonomies
  554. constraint katello_subscriptions_organization_fk on table public.katello_subscriptions depends on table public.taxonomies
  555. constraint katello_pools_organization_id on table public.katello_pools depends on table public.taxonomies
  556. constraint fk_rails_7d58ab6001 on table public.katello_contents depends on table public.taxonomies
  557. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  558. Command was: DROP TABLE public.taxonomies;
  559. pg_restore: from TOC entry 274; 1259 16915 TABLE smart_proxies foreman
  560. pg_restore: error: could not execute query: ERROR: cannot drop table public.smart_proxies because other objects depend on it
  561. DETAIL: constraint katello_capsule_lifecycle_environments_capsule_fk on table public.katello_capsule_lifecycle_environments depends on table public.smart_proxies
  562. constraint katello_content_facets_content_source_id_fk on table public.katello_content_facets depends on table public.smart_proxies
  563. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  564. Command was: DROP TABLE public.smart_proxies;
  565. pg_restore: from TOC entry 360; 1259 188007 TABLE http_proxies foreman
  566. pg_restore: error: could not execute query: ERROR: cannot drop table public.http_proxies because other objects depend on it
  567. DETAIL: constraint fk_rails_4c4627948f on table public.katello_root_repositories depends on table public.http_proxies
  568. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  569. Command was: DROP TABLE public.http_proxies;
  570. pg_restore: from TOC entry 204; 1259 16395 TABLE hosts foreman
  571. pg_restore: error: could not execute query: ERROR: cannot drop table public.hosts because other objects depend on it
  572. DETAIL: constraint katello_subscription_facets_host_id on table public.katello_subscription_facets depends on table public.hosts
  573. constraint katello_content_facets_host_id on table public.katello_content_facets depends on table public.hosts
  574. constraint katello_host_collection_hosts_host_id_fk on table public.katello_host_collection_hosts depends on table public.hosts
  575. constraint katello_host_trace_host_id on table public.katello_host_tracers depends on table public.hosts
  576. constraint katello_host_installed_packages_host_id on table public.katello_host_installed_packages depends on table public.hosts
  577. constraint katello_host_installed_debs_host_id on table public.katello_host_installed_debs depends on table public.hosts
  578. constraint katello_pools_hypervisor_fk on table public.katello_pools depends on table public.hosts
  579. constraint katello_hems_host_id_fk on table public.katello_host_available_module_streams depends on table public.hosts
  580. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  581. Command was: DROP TABLE public.hosts;
  582. pg_restore: from TOC entry 225; 1259 16571 TABLE environments foreman
  583. pg_restore: error: could not execute query: ERROR: cannot drop table public.environments because other objects depend on it
  584. DETAIL: constraint katello_cvpe_pe_id on table public.katello_content_view_puppet_environments depends on table public.environments
  585. HINT: Use DROP ... CASCADE to drop the dependent objects too.
  586. Command was: DROP TABLE public.environments;
  587. pg_restore: error: could not execute query: ERROR: relation "environments" already exists
  588. Command was: CREATE TABLE public.environments (
  589. id integer NOT NULL,
  590. name character varying(255) NOT NULL,
  591. created_at timestamp without time zone,
  592. updated_at timestamp without time zone
  593. );
  594.  
  595.  
  596. pg_restore: from TOC entry 204; 1259 16395 TABLE hosts foreman
  597. pg_restore: error: could not execute query: ERROR: relation "hosts" already exists
  598. Command was: CREATE TABLE public.hosts (
  599. id integer NOT NULL,
  600. name character varying(255) NOT NULL,
  601. last_compile timestamp without time zone,
  602. last_report timestamp without time zone,
  603. updated_at timestamp without time zone,
  604. created_at timestamp without time zone,
  605. root_pass text,
  606. architecture_id integer,
  607. operatingsystem_id integer,
  608. environment_id integer,
  609. ptable_id integer,
  610. medium_id integer,
  611. build boolean DEFAULT false,
  612. comment text,
  613. disk text,
  614. installed_at timestamp without time zone,
  615. model_id integer,
  616. hostgroup_id integer,
  617. owner_id integer,
  618. owner_type character varying(255),
  619. enabled boolean DEFAULT true,
  620. puppet_ca_proxy_id integer,
  621. managed boolean DEFAULT false NOT NULL,
  622. use_image boolean,
  623. image_file character varying(128),
  624. uuid character varying(255),
  625. compute_resource_id integer,
  626. puppet_proxy_id integer,
  627. certname character varying(255),
  628. image_id integer,
  629. organization_id integer,
  630. location_id integer,
  631. type character varying(255),
  632. otp character varying(255),
  633. realm_id integer,
  634. compute_profile_id integer,
  635. provision_method character varying(255),
  636. grub_pass character varying(255) DEFAULT ''::character varying,
  637. global_status integer DEFAULT 0 NOT NULL,
  638. lookup_value_matcher character varying(255),
  639. pxe_loader character varying(255),
  640. initiated_at timestamp without time zone,
  641. build_errors text,
  642. discovery_rule_id integer
  643. );
  644.  
  645.  
  646. pg_restore: from TOC entry 360; 1259 188007 TABLE http_proxies foreman
  647. pg_restore: error: could not execute query: ERROR: relation "http_proxies" already exists
  648. Command was: CREATE TABLE public.http_proxies (
  649. id integer NOT NULL,
  650. name character varying NOT NULL,
  651. url character varying NOT NULL,
  652. username character varying,
  653. password character varying
  654. );
  655.  
  656.  
  657. pg_restore: from TOC entry 274; 1259 16915 TABLE smart_proxies foreman
  658. pg_restore: error: could not execute query: ERROR: relation "smart_proxies" already exists
  659. Command was: CREATE TABLE public.smart_proxies (
  660. id integer NOT NULL,
  661. name character varying(255),
  662. url character varying(255),
  663. created_at timestamp without time zone,
  664. updated_at timestamp without time zone,
  665. expired_logs character varying(255) DEFAULT '0'::character varying
  666. );
  667.  
  668.  
  669. pg_restore: from TOC entry 294; 1259 17084 TABLE taxonomies foreman
  670. pg_restore: error: could not execute query: ERROR: relation "taxonomies" already exists
  671. Command was: CREATE TABLE public.taxonomies (
  672. id integer NOT NULL,
  673. name character varying(255),
  674. type character varying(255),
  675. created_at timestamp without time zone,
  676. updated_at timestamp without time zone,
  677. ignore_types text,
  678. ancestry character varying(255),
  679. title character varying(255),
  680. description text
  681. );
  682.  
  683.  
  684. pg_restore: from TOC entry 242; 1259 16677 TABLE users foreman
  685. pg_restore: error: could not execute query: ERROR: relation "users" already exists
  686. Command was: CREATE TABLE public.users (
  687. id integer NOT NULL,
  688. login character varying(255),
  689. firstname character varying(255),
  690. lastname character varying(255),
  691. mail character varying(255),
  692. admin boolean DEFAULT false NOT NULL,
  693. last_login_on timestamp without time zone,
  694. auth_source_id integer,
  695. created_at timestamp without time zone,
  696. updated_at timestamp without time zone,
  697. password_hash character varying(128),
  698. password_salt character varying(128),
  699. locale character varying(5),
  700. avatar_hash character varying(128),
  701. default_organization_id integer,
  702. default_location_id integer,
  703. lower_login character varying(255),
  704. mail_enabled boolean DEFAULT true,
  705. timezone character varying(255),
  706. description text
  707. );
  708.  
  709.  
  710. pg_restore: from TOC entry 4883; 0 16571 TABLE DATA environments foreman
  711. pg_restore: error: COPY failed for table "environments": ERROR: duplicate key value violates unique constraint "environments_pkey"
  712. DETAIL: Key (id)=(9) already exists.
  713. CONTEXT: COPY environments, line 1
  714. pg_restore: from TOC entry 4862; 0 16395 TABLE DATA hosts foreman
  715. pg_restore: error: could not execute query: ERROR: column "discovery_rule_id" of relation "hosts" does not exist
  716. Command was: COPY public.hosts (id, name, last_compile, last_report, updated_at, created_at, root_pass, architecture_id, operatingsystem_id, environment_id, ptable_id, medium_id, build, comment, disk, installed_at, model_id, hostgroup_id, owner_id, owner_type, enabled, puppet_ca_proxy_id, managed, use_image, image_file, uuid, compute_resource_id, puppet_proxy_id, certname, image_id, organization_id, location_id, type, otp, realm_id, compute_profile_id, provision_method, grub_pass, global_status, lookup_value_matcher, pxe_loader, initiated_at, build_errors, discovery_rule_id) FROM stdin;
  717. pg_restore: from TOC entry 4932; 0 16915 TABLE DATA smart_proxies foreman
  718. pg_restore: error: COPY failed for table "smart_proxies": ERROR: duplicate key value violates unique constraint "smart_proxies_pkey"
  719. DETAIL: Key (id)=(1) already exists.
  720. CONTEXT: COPY smart_proxies, line 1
  721. pg_restore: from TOC entry 4952; 0 17084 TABLE DATA taxonomies foreman
  722. pg_restore: error: COPY failed for table "taxonomies": ERROR: duplicate key value violates unique constraint "taxonomies_pkey"
  723. DETAIL: Key (id)=(1) already exists.
  724. CONTEXT: COPY taxonomies, line 2
  725. pg_restore: from TOC entry 4900; 0 16677 TABLE DATA users foreman
  726. pg_restore: error: COPY failed for table "users": ERROR: duplicate key value violates unique constraint "users_pkey"
  727. DETAIL: Key (id)=(1) already exists.
  728. CONTEXT: COPY users, line 1
  729. pg_restore: from TOC entry 4377; 2606 16591 CONSTRAINT environments environments_pkey foreman
  730. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "environments" are not allowed
  731. Command was: ALTER TABLE ONLY public.environments
  732. ADD CONSTRAINT environments_pkey PRIMARY KEY (id);
  733.  
  734.  
  735. pg_restore: from TOC entry 4335; 2606 16605 CONSTRAINT hosts hosts_pkey foreman
  736. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "hosts" are not allowed
  737. Command was: ALTER TABLE ONLY public.hosts
  738. ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
  739.  
  740.  
  741. pg_restore: from TOC entry 4602; 2606 16606 CONSTRAINT http_proxies http_proxies_pkey foreman
  742. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "http_proxies" are not allowed
  743. Command was: ALTER TABLE ONLY public.http_proxies
  744. ADD CONSTRAINT http_proxies_pkey PRIMARY KEY (id);
  745.  
  746.  
  747. pg_restore: from TOC entry 4455; 2606 16633 CONSTRAINT smart_proxies smart_proxies_pkey foreman
  748. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "smart_proxies" are not allowed
  749. Command was: ALTER TABLE ONLY public.smart_proxies
  750. ADD CONSTRAINT smart_proxies_pkey PRIMARY KEY (id);
  751.  
  752.  
  753. pg_restore: from TOC entry 4489; 2606 16642 CONSTRAINT taxonomies taxonomies_pkey foreman
  754. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "taxonomies" are not allowed
  755. Command was: ALTER TABLE ONLY public.taxonomies
  756. ADD CONSTRAINT taxonomies_pkey PRIMARY KEY (id);
  757.  
  758.  
  759. pg_restore: from TOC entry 4409; 2606 16655 CONSTRAINT users users_pkey foreman
  760. pg_restore: error: could not execute query: ERROR: multiple primary keys for table "users" are not allowed
  761. Command was: ALTER TABLE ONLY public.users
  762. ADD CONSTRAINT users_pkey PRIMARY KEY (id);
  763.  
  764.  
  765. pg_restore: from TOC entry 4646; 2606 16752 FK CONSTRAINT fact_values fact_values_host_id_fk foreman
  766. pg_restore: error: could not execute query: ERROR: insert or update on table "fact_values" violates foreign key constraint "fact_values_host_id_fk"
  767. DETAIL: Key (host_id)=(1) is not present in table "hosts".
  768. Command was: ALTER TABLE ONLY public.fact_values
  769. ADD CONSTRAINT fact_values_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  770.  
  771.  
  772. pg_restore: from TOC entry 4695; 2606 16762 FK CONSTRAINT smart_proxy_features features_smart_proxies_smart_proxy_id_fk foreman
  773. pg_restore: error: could not execute query: ERROR: insert or update on table "smart_proxy_features" violates foreign key constraint "features_smart_proxies_smart_proxy_id_fk"
  774. DETAIL: Key (smart_proxy_id)=(2) is not present in table "smart_proxies".
  775. Command was: ALTER TABLE ONLY public.smart_proxy_features
  776. ADD CONSTRAINT features_smart_proxies_smart_proxy_id_fk FOREIGN KEY (smart_proxy_id) REFERENCES public.smart_proxies(id);
  777.  
  778.  
  779. pg_restore: from TOC entry 4721; 2606 16792 FK CONSTRAINT notification_recipients fk_rails_51975e21a8 foreman
  780. pg_restore: error: could not execute query: ERROR: insert or update on table "notification_recipients" violates foreign key constraint "fk_rails_51975e21a8"
  781. DETAIL: Key (user_id)=(13) is not present in table "users".
  782. Command was: ALTER TABLE ONLY public.notification_recipients
  783. ADD CONSTRAINT fk_rails_51975e21a8 FOREIGN KEY (user_id) REFERENCES public.users(id);
  784.  
  785.  
  786. pg_restore: from TOC entry 4733; 2606 16807 FK CONSTRAINT host_facets_reported_data_facets fk_rails_a82ac722f1 foreman
  787. pg_restore: error: could not execute query: ERROR: insert or update on table "host_facets_reported_data_facets" violates foreign key constraint "fk_rails_a82ac722f1"
  788. DETAIL: Key (host_id)=(1011) is not present in table "hosts".
  789. Command was: ALTER TABLE ONLY public.host_facets_reported_data_facets
  790. ADD CONSTRAINT fk_rails_a82ac722f1 FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  791.  
  792.  
  793. pg_restore: from TOC entry 4660; 2606 16822 FK CONSTRAINT host_classes host_classes_host_id_fk foreman
  794. pg_restore: error: could not execute query: ERROR: insert or update on table "host_classes" violates foreign key constraint "host_classes_host_id_fk"
  795. DETAIL: Key (host_id)=(897) is not present in table "hosts".
  796. Command was: ALTER TABLE ONLY public.host_classes
  797. ADD CONSTRAINT host_classes_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  798.  
  799.  
  800. pg_restore: from TOC entry 4718; 2606 16832 FK CONSTRAINT host_status host_status_hosts_host_id_fk foreman
  801. pg_restore: error: could not execute query: ERROR: insert or update on table "host_status" violates foreign key constraint "host_status_hosts_host_id_fk"
  802. DETAIL: Key (host_id)=(1018) is not present in table "hosts".
  803. Command was: ALTER TABLE ONLY public.host_status
  804. ADD CONSTRAINT host_status_hosts_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  805.  
  806.  
  807. pg_restore: from TOC entry 4673; 2606 16887 FK CONSTRAINT hostgroups hostgroups_puppet_proxy_id_fk foreman
  808. pg_restore: error: could not execute query: ERROR: insert or update on table "hostgroups" violates foreign key constraint "hostgroups_puppet_proxy_id_fk"
  809. DETAIL: Key (puppet_proxy_id)=(2) is not present in table "smart_proxies".
  810. Command was: ALTER TABLE ONLY public.hostgroups
  811. ADD CONSTRAINT hostgroups_puppet_proxy_id_fk FOREIGN KEY (puppet_proxy_id) REFERENCES public.smart_proxies(id);
  812.  
  813.  
  814. pg_restore: from TOC entry 4699; 2606 17022 FK CONSTRAINT nics nics_host_id_fk foreman
  815. pg_restore: error: could not execute query: ERROR: insert or update on table "nics" violates foreign key constraint "nics_host_id_fk"
  816. DETAIL: Key (host_id)=(815) is not present in table "hosts".
  817. Command was: ALTER TABLE ONLY public.nics
  818. ADD CONSTRAINT nics_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  819.  
  820.  
  821. pg_restore: from TOC entry 4657; 2606 17077 FK CONSTRAINT reports reports_host_id_fk foreman
  822. pg_restore: error: could not execute query: ERROR: insert or update on table "reports" violates foreign key constraint "reports_host_id_fk"
  823. DETAIL: Key (host_id)=(865) is not present in table "hosts".
  824. Command was: ALTER TABLE ONLY public.reports
  825. ADD CONSTRAINT reports_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  826.  
  827.  
  828. pg_restore: from TOC entry 4653; 2606 17107 FK CONSTRAINT subnets subnets_tftp_id_fk foreman
  829. pg_restore: error: could not execute query: ERROR: insert or update on table "subnets" violates foreign key constraint "subnets_tftp_id_fk"
  830. DETAIL: Key (tftp_id)=(5) is not present in table "smart_proxies".
  831. Command was: ALTER TABLE ONLY public.subnets
  832. ADD CONSTRAINT subnets_tftp_id_fk FOREIGN KEY (tftp_id) REFERENCES public.smart_proxies(id);
  833.  
  834.  
  835. pg_restore: from TOC entry 4707; 2606 17117 FK CONSTRAINT taxable_taxonomies taxable_taxonomies_taxonomy_id_fk foreman
  836. pg_restore: error: could not execute query: ERROR: insert or update on table "taxable_taxonomies" violates foreign key constraint "taxable_taxonomies_taxonomy_id_fk"
  837. DETAIL: Key (taxonomy_id)=(4) is not present in table "taxonomies".
  838. Command was: ALTER TABLE ONLY public.taxable_taxonomies
  839. ADD CONSTRAINT taxable_taxonomies_taxonomy_id_fk FOREIGN KEY (taxonomy_id) REFERENCES public.taxonomies(id);
  840.  
  841.  
  842. pg_restore: from TOC entry 4705; 2606 17142 FK CONSTRAINT tokens tokens_host_id_fk foreman
  843. pg_restore: error: could not execute query: ERROR: insert or update on table "tokens" violates foreign key constraint "tokens_host_id_fk"
  844. DETAIL: Key (host_id)=(1052) is not present in table "hosts".
  845. Command was: ALTER TABLE ONLY public.tokens
  846. ADD CONSTRAINT tokens_host_id_fk FOREIGN KEY (host_id) REFERENCES public.hosts(id);
  847.  
  848.  
  849. pg_restore: from TOC entry 4717; 2606 17157 FK CONSTRAINT user_mail_notifications user_mail_notifications_user_id_fk foreman
  850. pg_restore: error: could not execute query: ERROR: insert or update on table "user_mail_notifications" violates foreign key constraint "user_mail_notifications_user_id_fk"
  851. DETAIL: Key (user_id)=(28) is not present in table "users".
  852. Command was: ALTER TABLE ONLY public.user_mail_notifications
  853. ADD CONSTRAINT user_mail_notifications_user_id_fk FOREIGN KEY (user_id) REFERENCES public.users(id);
  854.  
  855.  
  856. pg_restore: warning: errors ignored on restore: 55
  857. Completed.
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!