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

Hibernate query deprecation warnings in Confluence 6 logs

XMLWordPrintable

      Summary

      Hibernate query deprecation warnings in Confluence 6 logs

      Environment

      • Confluence 6
      • Synchrony enabled

      Steps to reproduce

      After startup the following message is printed to the atlassian-confluenc.log:

      2017-03-13 16:53:32,450 WARN [http-nio-443-exec-23] [hql.internal.ast.HqlSqlWalker] generatePositionalParameter [DEPRECATION] Encountered positional parameter near line 1, column 131 in HQL: [SELECT mem.parentGroup.name FROM com.atlassian.crowd.embedded.hibernate2.HibernateMembership mem WHERE mem.userMember.lowerName = ? and mem.parentGroup.directory.id = ? ORDER BY mem.parentGroup.lowerName]. Positional parameter are considered deprecated; use named parameters or JPA-style positional parameters instead.

      Notes

      Error seems to be benign as Synchrony still works, this is a logging issue.

      Workaround

      Adding the following to log4j.properties will suppress those messages

      log4j.logger.org.hibernate.hql.internal.ast=ERROR

            [CONFSERVER-51874] Hibernate query deprecation warnings in Confluence 6 logs

            Security Metrics Bot made changes -
            Labels Original: affects-server enterprise enterprise-backlog lbp log-pollution pse-request New: affects-server enterprise enterprise-backlog lbp log-pollution no-advisory-required pse-request

            Oliver Shen added a comment -

            A fix for this issue is available to Server and Data Center customers in Confluence 7.3.1
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            Oliver Shen added a comment - A fix for this issue is available to Server and Data Center customers in Confluence 7.3.1 Upgrade now or check out the Release Notes to see what other issues are resolved.
            Oliver Shen made changes -
            Fix Version/s New: 7.3.1 [ 91398 ]
            Fix Version/s Original: 7.3.0 [ 90890 ]
            Dhruv Phadnis (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]
            Dhruv Phadnis (Inactive) made changes -
            Fix Version/s New: 7.3.0 [ 90890 ]
            Dhruv Phadnis (Inactive) made changes -
            Status Original: Awaiting Merge [ 10064 ] New: Waiting for Release [ 12075 ]
            Dhruv Phadnis (Inactive) made changes -
            Remote Link New: This issue links to "R7.3 P1. Baseline › WebDriver tests (Firefox 2.53.1, Oracle JDK 11) › db-issue-73-CONFSERVER-51874-fix-hibernate-positional-deprecation (server-syd-bamboo)" [ 467362 ]
            Dhruv Phadnis (Inactive) made changes -
            Remote Link New: This issue links to "R7.3 P3. Database Support › SQL Server 2012, Tomcat 9, Java 11 › db-issue-73-CONFSERVER-51874-fix-hibernate-positional-deprecation (server-syd-bamboo)" [ 467361 ]
            Dhruv Phadnis (Inactive) made changes -
            Remote Link New: This issue links to "R7.3 P3. Major Release › Windows H2 (Tomcat 9, Java 11) › db-issue-73-CONFSERVER-51874-fix-hibernate-positional-deprecation (server-syd-bamboo)" [ 467549 ]
            Dhruv Phadnis (Inactive) made changes -
            Remote Link New: This issue links to "R7.3 P3. Database Support › MySQL 8.0, Tomcat 9, Java 11 › db-issue-73-CONFSERVER-51874-fix-hibernate-positional-deprecation (server-syd-bamboo)" [ 467360 ]

              dphadnis@atlassian.com Dhruv Phadnis (Inactive)
              dponzio Daniel Ponzio
              Affected customers:
              40 This affects my team
              Watchers:
              69 Start watching this issue

                Created:
                Updated:
                Resolved: