org.postgresql.util.PSQLException: ERROR: update or delete on table "fact_paths" violates foreign key constraint "fact_values_path_id_fk" on table "fact_values" Detail: Key (id)=(452) is still referenced from table "fact_values".

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via JIRA by Pete Brown, 1 year ago
ERROR: update or delete on table "fact_paths" violates foreign key constraint "fact_values_path_id_fk" on table "fact_values" Detail: Key (id)=(452) is still referenced from table "fact_values".
via JIRA by Pete Brown, 1 year ago
ERROR: update or delete on table "fact_paths" violates foreign key constraint "fact_values_path_id_fk" on table "fact_values" Detail: Key (id)=(452) is still referenced from table "fact_values".
via Google Groups by Ken Barber, 5 months ago
ERROR: relation "certnames" already exists
via Stack Overflow by membersound
, 2 years ago
via GitHub by danfruehauf
, 2 years ago
ERROR: null value in column "device_id" violates not-null constraint Detail: Failing row contains (1160282, 92, null, null, null, null, null, null, null, null, null, null, 2015-12-08 12:40:00+11, 2015-12-08 14:36:00+11, 0, 15, -32.4983470893467086, 133.279227014756117, 0101000020E610000031117E6DEFA86040846661D6C93F40C0, null).
via GitHub by xhoenner
, 2 years ago
ERROR: deadlock detected Detail: Process 1214 waits for AccessExclusiveLock on relation 12888578 of database 382180; blocked by process 9072. Process 9072 waits for AccessShareLock on relation 27608909 of database 382180; blocked by process 1214. Hint: See server log for query details.
org.postgresql.util.PSQLException: ERROR: update or delete on table "fact_paths" violates foreign key constraint "fact_values_path_id_fk" on table "fact_values" Detail: Key (id)=(452) is still referenced from table "fact_values".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893)
at clojure.java.jdbc$do_commands.doInvoke(jdbc.clj:187)
at clojure.lang.RestFn.invoke(RestFn.java:3894)
at com.puppetlabs.puppetdb.scf.migrate$lift_fact_paths_into_facts.invoke(migrate.clj:968)
at com.puppetlabs.puppetdb.scf.migrate$migrate_BANG_$fn__20902$fn__20915.invoke(migrate.clj:1063)
at com.puppetlabs.puppetdb.scf.migrate$migrate_BANG_$fn__20902.invoke(migrate.clj:1062)
at com.puppetlabs.puppetdb.scf.migrate$migrate_BANG_.invoke(migrate.clj:1059)
at com.puppetlabs.puppetdb.cli.services$start_puppetdb$fn__21109.invoke(services.clj:292)
at com.puppetlabs.puppetdb.cli.services$start_puppetdb.invoke(services.clj:290)
at com.puppetlabs.puppetdb.cli.services$reify__21157$service_fnk__18232__auto___positional$reify__21168.start(services.clj:366)
at puppetlabs.trapperkeeper.services$eval18068$fn__18082$G__18058__18085.invoke(services.clj:10)
at puppetlabs.trapperkeeper.services$eval18068$fn__18082$G__18057__18089.invoke(services.clj:10)
at puppetlabs.trapperkeeper.internal$run_lifecycle_fn_BANG_.invoke(internal.clj:154)
at puppetlabs.trapperkeeper.internal$run_lifecycle_fns.invoke(internal.clj:182)
at puppetlabs.trapperkeeper.internal$build_app_STAR_$reify__18905.start(internal.clj:449)
at puppetlabs.trapperkeeper.internal$boot_services_STAR_$fn__18917.invoke(internal.clj:473)
at puppetlabs.trapperkeeper.internal$boot_services_STAR_.invoke(internal.clj:471)
at puppetlabs.trapperkeeper.core$boot_with_cli_data.invoke(core.clj:113)
at puppetlabs.trapperkeeper.core$run.invoke(core.clj:144)
at puppetlabs.trapperkeeper.core$main.doInvoke(core.clj:159)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at clojure.core$apply.invoke(core.clj:624)
at com.puppetlabs.puppetdb.cli.services$_main.doInvoke(services.clj:373)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at clojure.lang.Var.invoke(Var.java:383)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.Var.applyTo(Var.java:700)
at clojure.core$apply.invoke(core.clj:624)
at com.puppetlabs.puppetdb.core$run_command.invoke(core.clj:87)
at com.puppetlabs.puppetdb.core$_main.doInvoke(core.clj:95)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at clojure.lang.Var.invoke(Var.java:388)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.Var.applyTo(Var.java:700)
at clojure.core$apply.invoke(core.clj:624)
at clojure.main$main_opt.invoke(main.clj:315)
at clojure.main$main.doInvoke(main.clj:420)
at clojure.lang.RestFn.invoke(RestFn.java:482)
at clojure.lang.Var.invoke(Var.java:401)
at clojure.lang.AFn.applyToHelper(AFn.java:171)
at clojure.lang.Var.applyTo(Var.java:700)
at clojure.main.main(main.java:37)

Users with the same issue

37 times, 1 week ago
3 times, 1 month ago
Once, 2 months ago
Once, 2 months ago
32 times, 2 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.