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

On first setup, logs warns that some tables are missing.

XMLWordPrintable

      Issue Summary

      1. When setting up Confluence 6.15.2 the first time, during the database setup, the warning below appears in the logs. Here are some examples:
        • 2019-04-10 17:33:50,825 WARN [SiteSummaryCalculator:thread-1] [status.service.systeminfo.UsageInfo] getCountForQuery Unable to execute usage info query: SELECT COUNT(*) FROM os_user - Table 'conf61501.os_user' doesn't exist
           -- referer: http://localhost:8090/setup/setupdbtype.action | url: /setup/setupdbtype.action | traceId: 00b3f5e1fabc3bb2 | userName: anonymous | action: setupdbtype
          com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'conf61502.os_user' doesn't exist
          
        • 2020-07-14 10:04:57,073 WARN [SiteSummaryCalculator:thread-1] [status.service.systeminfo.UsageInfo] getCountForQuery Unable to execute usage info query: SELECT COUNT(*) FROM users - Table 'confluence.users' doesn't exist
           -- referer: http://x.x.x.x:8090/setup/setupdbtype-start.action | url: /setup/setupdbtype.action | traceId: 00ea43fb602f76ee | userName: anonymous | action: setupdbtype
          com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.users' doesn't exist
          	at sun.reflect.GeneratedConstructorAccessor300.newInstance(Unknown Source)
          
      2. The error above is shown for the following tables.
        1. os_user
        2. users
        3. os_group
        4. groups
      3. The table indeed does not exist, but it does not exist on Confluence 6.15.1 as well, but we do not get these warnings on that version and below.

      Environment

      1. Tested on Confluence 6.15.2 with MySQL 5.7

      Steps to Reproduce

      1. Setup Confluence 6.15.2 with MySQL
      2. Error is seen just after database setup has completed.

      Expected Results

      1. The tables should be created if it's required, or the warning should not exist if the tables are not meant to be there

      Workaround

      1. None

              Unassigned Unassigned
              smaran Sattesh M
              Votes:
              7 Vote for this issue
              Watchers:
              9 Start watching this issue

                Created:
                Updated: