org.postgresql.util.PSQLException: ERROR: relation "dual" already exists

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 GitHub by BorisDomajnko
, 1 year ago
ERROR: relation "sch_testa.users" does not exist
via GitHub by BorisDomajnko
, 1 year ago
ERROR: relation "uca_metadata.prop" does not exist
via GitHub by kskim80
, 9 months ago
ERROR: graph_path is NULL Hint: Use SET graph_path
via Stack Overflow by Asher Fischbaum
, 1 year ago
ERROR: syntax error at or near "=" Position: 56
org.postgresql.util.PSQLException: ERROR: relation "dual" already exists
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:465)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.palantir.nexus.db.pool.InterceptorStatement.handleInvocation(InterceptorStatement.java:52)
at com.google.common.reflect.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:87)
at com.sun.proxy.$Proxy64.execute(Unknown Source)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.palantir.nexus.db.sql.BasicSQL$BlobCleanupPreparedStatement.invoke(BasicSQL.java:344)
at com.sun.proxy.$Proxy65.execute(Unknown Source)
at com.palantir.sql.PreparedStatements.execute(PreparedStatements.java:42)
at com.palantir.nexus.db.sql.BasicSQL$4$1.visit(BasicSQL.java:543)
at com.palantir.nexus.db.sql.BasicSQL$4$1.visit(BasicSQL.java:540)
at com.palantir.nexus.db.sql.BasicSQL.wrapPreparedStatement(BasicSQL.java:482)
at com.palantir.nexus.db.sql.BasicSQL.access$100(BasicSQL.java:72)
at com.palantir.nexus.db.sql.BasicSQL$4.call(BasicSQL.java:540)
at com.palantir.nexus.db.sql.BasicSQL$4.call(BasicSQL.java:537)
at com.palantir.nexus.db.sql.BasicSQLUtils$1.call(BasicSQLUtils.java:284)
at com.palantir.nexus.db.ThreadConfinedProxy$1.call(ThreadConfinedProxy.java:102)
at com.palantir.common.concurrent.ThreadNamingCallable.call(ThreadNamingCallable.java:55)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at com.palantir.common.concurrent.ForwardingRunnableFuture.run(ForwardingRunnableFuture.java:55)
at com.palantir.common.concurrent.PTExecutors$5.run(PTExecutors.java:486)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

Once, 1 month ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
18 times, 7 months ago
4430 times, 11 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

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