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

            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.

            Roman Joss added a comment -

            Having this bug in our Confluence Version 6.15.4

            Roman Joss added a comment - Having this bug in our Confluence Version 6.15.4

            Doods Perea added a comment -

            Having this bug in our Confluence version 6.11.2

            Doods Perea added a comment - Having this bug in our Confluence version 6.11.2

            Mayuresh Sakharape added a comment -

            seen in 6.6.8  (Enterprise version) as well (upgraded from 5.10.8)

            Mayuresh Sakharape added a comment - seen in 6.6.8  (Enterprise version) as well (upgraded from 5.10.8)

            Damon Cassell added a comment -

            Seeing these in 6.11.2 as well (upgraded from 5.10.2).

            Damon Cassell added a comment - Seeing these in 6.11.2 as well (upgraded from 5.10.2).

            Gonchik Tsymzhitov added a comment -

            6.10.2 and 6.10.1

            Gonchik Tsymzhitov added a comment - 6.10.2 and 6.10.1

            Jim Birch added a comment -

            And in 6.9

            Jim Birch added a comment - And in 6.9

            A R Desai added a comment -

            Seen in Confluence 6.6.2 Data Center

            A R Desai added a comment - Seen in Confluence 6.6.2 Data Center

            Ales Huzik (Inactive) added a comment -

            jxie : Embedded Crowd still exhibit this warning

            Ales Huzik (Inactive) added a comment - jxie : Embedded Crowd still exhibit this warning

            Claudia Armentano added a comment -

            Can be seen in 6.0.4 when trying to restore data from XML backup.

            Claudia Armentano added a comment - Can be seen in 6.0.4 when trying to restore data from XML backup.

              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: