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

XMLWordPrintable

    • 8
    • Severity 3 - Minor
    • 0

      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

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

              Created:
              Updated: