Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-60060

Confluence throws "org.postgresql.util.PSQLException: ERROR: relation 'users' does not exist" message when performing DB setup

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 6.14.2, 6.15.2, 7.1.1, 7.2.0, 7.3.3, 7.5.0
    • Server - Installer / Setup
    • None

      Issue Summary

      When installing Confluence, an error message is logged indicating an issue with a relation to various tables that can include:

      • users
      • os_user
      • groups
      • os_group

      Environment

      (Optional - If Applicable)

      • 6.14.2
      • 6.15.2
      • 7.1.1
      • 7.2.0
      • 7.3.3
      • 7.5.0
      • Postgres 9.6

      Steps to Reproduce

      1. Install Confluence with a Postgres database and step through the set up screens.

      Expected Results

      Confluence installs with none of these warnings.

      Actual Results

      The below exceptions are thrown in the atlassian-confluence.log file.

      This example is from 6.14:

      2020-05-13 16:38:35,075 WARN [SiteSummaryCalculator:thread-1] [status.service.systeminfo.UsageInfo] getCountForQuery Unable to execute usage info query: SELECT COUNT(*) FROM users - ERROR: relation "users" does not exist
  Position: 22
 -- referer: http://localhost:9614/conf/setup/setupdbtype-start.action | url: /conf/setup/setupdbtype.action | traceId: 00f537257f3768dc | userName: anonymous | action: setupdbtype
org.postgresql.util.PSQLException: ERROR: relation "users" does not exist
  Position: 22
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
	at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:231)

      In 7.x versions, this message slightly changes format:

      019-12-10 07:51:01,175 WARN [SiteSummaryCalculator:thread-1] [status.service.systeminfo.UsageInfo] getCountForQuery Unable to execute usage info query: SELECT COUNT(*) FROM users - ERROR: relation "users" does not exist
  Position: 22
 -- referer: http://localhost:9711/conf/setup/setupdbtype-start.action | url: /conf/setup/setupdbtype.action | traceId: 007416d44dacb0ac | userName: anonymous | action: setupdbtype

      Notes

      This issue may be related to CONFSERVER-58142: On first setup, logs warns that some tables are missing

      This doesn't appear to affect the operation of Confluence.

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

              Unassigned Unassigned
              sshaw@atlassian.com Steve Shaw
              Votes:
              2 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: