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

findPagesWithHistoricalTitle broken on Oracle / DB2

    XMLWordPrintable

Details

    Description

      Eg see the error message in https://bamboo.extranet.atlassian.com/browse/CONFFUNC-T5DB282-484/artifact/Logs/output.log

      rg.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -134, SQLSTATE: 42907, SQLERRMC: VERSIONC9_
      Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -134, SQLSTATE: 42907, SQLERRMC: VERSIONC9_
      	at com.ibm.db2.jcc.b.zc.e(zc.java:1606)
      	at com.ibm.db2.jcc.b.zc.a(zc.java:1206)
      	at com.ibm.db2.jcc.a.db.h(db.java:149)
      	at com.ibm.db2.jcc.a.db.a(db.java:43)
      	at com.ibm.db2.jcc.a.r.a(r.java:30)
      	at com.ibm.db2.jcc.a.sb.g(sb.java:152)
      	at com.ibm.db2.jcc.b.zc.n(zc.java:1186)
      	at com.ibm.db2.jcc.b.ad.db(ad.java:1761)
      	at com.ibm.db2.jcc.b.ad.d(ad.java:2203)
      	at com.ibm.db2.jcc.b.ad.U(ad.java:489)
      	at com.ibm.db2.jcc.b.ad.executeQuery(ad.java:472)
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      	at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
      	at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
      	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
      	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
      	at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
      	at net.sf.hibernate.loader.Loader.list(Loader.java:1048)
      	at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
      	at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
      	at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
      	at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao$4.doInHibernate(HibernatePageDao.java:455)
      	at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
      	at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
      	at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.findPagesWithHistoricalTitle(HibernatePageDao.java:427)
      	at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.findPagesWithHistoricalTitleInPermittedSpace(HibernatePageDao.java:397)
      	at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao.findPagesWithHistoricalTitleInPermittedSpace(CachingPageDao.java:156)
      	at com.atlassian.confluence.pages.DefaultPageManager.getPossibleRedirectsInSpace(DefaultPageManager.java:81)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:585)
      

      Attachments

        Issue Links

          Activity

            People

              dave@atlassian.com dave (Inactive)
              don.willis@atlassian.com Don Willis
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: