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

GitHub | shashiadi | 4 months ago
  1. 0

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

    Stack Overflow | 6 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 | 6 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 | 5 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

  1. archenroot 1 times, last 4 weeks ago
  2. serious2monkeys 19 times, last 1 month ago
  3. kjhdofjosvs 1 times, last 3 weeks ago
  4. smyrgeorge 1 times, last 4 months ago
16 unregistered visitors
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