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

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: 6.14.2, 6.15.2, 7.1.1, 7.2.0, 7.3.3, 7.5.0
    • Component/s: Server - Installer / Setup
    • None
    • 5
    • Severity 3 - Minor
    • 1

      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

            Assignee:
            Unassigned
            Reporter:
            Steve Shaw
            Votes:
            2 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: