org.postgresql.util.PSQLException: ERROR: database "foo" is being accessed by other users Detail: There is 1 other session using the database.

Stack Overflow | Do Nhu Vy | 3 months ago
  1. 0

    How to create and drop database, schema PostgreSQL by Java code?

    Stack Overflow | 3 months ago | Do Nhu Vy
    org.postgresql.util.PSQLException: ERROR: database "foo" is being accessed by other users Detail: There is 1 other session using the database.
  2. 0

    GitHub comment 17#178916048

    GitHub | 10 months ago | thokari
    org.postgresql.util.PSQLException: ERROR: column "permissions" is of type character varying[] but expression is of type character varying Hint: You will need to rewrite or cast the expression. Position: 103
  3. 0

    org.postgresql.util.PSQLException: ERROR: index row requires more memory than default(8191)

    Stack Overflow | 8 months ago | M.S.Naidu
    org.postgresql.util.PSQLException: ERROR: index row requires 11936 bytes, maximum size is 8191
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Databene Benerator: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

    Stack Overflow | 7 months ago | RCola
    java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
  6. 0

    GitHub comment 163#222476235

    GitHub | 6 months ago | BorisDomajnko
    org.postgresql.util.PSQLException: ERROR: relation "uca_metadata.prop" does not exist

  1. serious2monkeys 24 times, last 4 months ago
  2. kjhdofjosvs 57 times, last 5 days ago
  3. archenroot 1 times, last 1 month ago
  4. smyrgeorge 1 times, last 4 months ago
17 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: database "foo" is being accessed by other users Detail: There is 1 other session using the database.

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    QueryExecutorImpl.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2453)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2153)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:286)
    3 frames
  3. org.postgresql.jdbc
    PgStatement.executeUpdate
    1. org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
    2. org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
    3. org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:305)
    4. org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:291)
    5. org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:269)
    6. org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:249)
    6 frames
  4. com.nttdata
    RunSqlScript.main
    1. com.nttdata.RunSqlScript.dropDatabase(RunSqlScript.java:71)
    2. com.nttdata.RunSqlScript.main(RunSqlScript.java:28)
    2 frames