Uploaded image for project: 'Runtime'
  1. Runtime
  2. RUNTIME-3175

[PostgreSQL] Wrong db url for creating databases

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 4.2.1, 4.3.0
    • 4.2.0, 4.3.0
    • Tests
    • None
    • 4.2.1

      Blocks tests of Runtime 4.2.x and 4.3.x which run concurrently for instance. the current connection (url + "/template1") does not allow multiple sessions.

       

      Caused by: org.postgresql.util.PSQLException: ERROR: source database "template1" is being accessed by other users
        Détail : There are 1 other session(s) using the database.
      	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
      	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
      	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
      	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
      	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
      	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
      	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
      	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
      	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
      	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
      	at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
      	at org.ametys.core.script.SQLScriptHelper._execute(SQLScriptHelper.java:397) 

            sprieul Simon Prieul (Inactive)
            sprieul Simon Prieul (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: