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

GitHub | shashiadi | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Postgres connectivity via JDBC: org.postgresql.util.PSQLException: ERROR: relation "prescriptions" does not exist

    Stack Overflow | 9 months ago | xtro
    org.postgresql.util.PSQLException: ERROR: relation "prescriptions" does not exist Position: 29
  2. 0

    How to resolve "Caused by: org.postgresql.util.PSQLException: ERROR: relation "employee" does not exist Position: 13" error?

    Stack Overflow | 8 months ago | TechGuy
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Unable to execute command [create table HibernateDemo.Employee (id int4 not null, firstName varchar(255), lastName varchar(255), primary key (id))]
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Spring JDBC DataSource Initializer fails for schema with stored procedure definitions

    GitHub | 8 months ago | jhvhs
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Tomcat.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceInitializer': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #11 of URL [file:/Users/pivotal/workspace/db_initialize_fail/build/resources/main/schema.sql]: CREATE FUNCTION count_clients() RETURNS integer LANGUAGE plpgsql AS $$begin select count(*) from clients; nested exception is org.postgresql.util.PSQLException: ERROR: unterminated dollar-quoted string at or near "$$begin select count(*) from clients" Position: 69
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: relation "dual" already exists

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    QueryExecutorImpl.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
    3 frames
  3. org.postgresql.jdbc
    PgStatement.execute
    1. org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622)
    2. org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472)
    3. org.postgresql.jdbc.PgStatement.execute(PgStatement.java:465)
    3 frames
  4. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:498)
    4 frames
  5. com.palantir.nexus
    InterceptorStatement.handleInvocation
    1. com.palantir.nexus.db.pool.InterceptorStatement.handleInvocation(InterceptorStatement.java:52)
    1 frame
  6. Guava
    AbstractInvocationHandler.invoke
    1. com.google.common.reflect.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:87)
    1 frame
  7. com.sun.proxy
    $Proxy64.execute
    1. com.sun.proxy.$Proxy64.execute(Unknown Source)
    1 frame
  8. HikariCP-java6
    HikariProxyPreparedStatement.execute
    1. com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
    2. com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
    2 frames
  9. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:498)
    4 frames
  10. com.palantir.nexus
    BasicSQL$BlobCleanupPreparedStatement.invoke
    1. com.palantir.nexus.db.sql.BasicSQL$BlobCleanupPreparedStatement.invoke(BasicSQL.java:344)
    1 frame
  11. com.sun.proxy
    $Proxy65.execute
    1. com.sun.proxy.$Proxy65.execute(Unknown Source)
    1 frame
  12. com.palantir.sql
    PreparedStatements.execute
    1. com.palantir.sql.PreparedStatements.execute(PreparedStatements.java:42)
    1 frame
  13. com.palantir.nexus
    ThreadConfinedProxy$1.call
    1. com.palantir.nexus.db.sql.BasicSQL$4$1.visit(BasicSQL.java:543)
    2. com.palantir.nexus.db.sql.BasicSQL$4$1.visit(BasicSQL.java:540)
    3. com.palantir.nexus.db.sql.BasicSQL.wrapPreparedStatement(BasicSQL.java:482)
    4. com.palantir.nexus.db.sql.BasicSQL.access$100(BasicSQL.java:72)
    5. com.palantir.nexus.db.sql.BasicSQL$4.call(BasicSQL.java:540)
    6. com.palantir.nexus.db.sql.BasicSQL$4.call(BasicSQL.java:537)
    7. com.palantir.nexus.db.sql.BasicSQLUtils$1.call(BasicSQLUtils.java:284)
    8. com.palantir.nexus.db.ThreadConfinedProxy$1.call(ThreadConfinedProxy.java:102)
    8 frames
  14. com.palantir.common
    ThreadNamingCallable.call
    1. com.palantir.common.concurrent.ThreadNamingCallable.call(ThreadNamingCallable.java:55)
    1 frame
  15. Java RT
    FutureTask.run
    1. java.util.concurrent.FutureTask.run(FutureTask.java:266)
    1 frame
  16. com.palantir.common
    PTExecutors$5.run
    1. com.palantir.common.concurrent.ForwardingRunnableFuture.run(ForwardingRunnableFuture.java:55)
    2. com.palantir.common.concurrent.PTExecutors$5.run(PTExecutors.java:486)
    2 frames
  17. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames