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

Getting HTTP 500 after calling Rest API for Space data

XMLWordPrintable

      Summary

      When running a REST API search in Confluence 8.5.14 and below with a MySQL database an HTTP 500 error is generated. Tested with MySQL 8.0.34 database.

      {"statusCode":500,"message":"","reason":Internal Server Error"}

      In spite of related bugs being resolved in 8.5.14:

      This is reproducible on Data Center: (yes)

      Steps to Reproduce

      1. Install Confluence 8.5.14
      2. Send a GET request: 
        <CONFLUENCE-BASE-URL>/rest/api/space/<SPACEKEY>/content?expand=ancestors,children.page&start=800&limit=100

      Expected Results

      An output from your rest API call

      {
  "page": {
    "results": [],
    "start": 800,
    "limit": 100,
    "size": 0,
    "_links": {
      "self": "<CONFLUENCE-BASE-URL>/rest/api/space/TEST/content/page",
      "prev": "/rest/api/space/TEST/content/page?limit=100&start=700"
    }
  },
  "blogpost": {
    "results": [],
    "start": 800,
    "limit": 100,
    "size": 0,
    "_links": {
      "self": "<CONFLUENCE-BASE-URL>/rest/api/space/TEST/content/blogpost",
      "prev": "/rest/api/space/TEST/content/blogpost?limit=100&start=700"
    }
  },
  "_links": {
    "base": "<CONFLUENCE-BASE-URL>",
    "context": "/conf"
  }
}

      Actual Results

      HTTP 500 Error message in browser:

      {"statusCode":500,"message":"","reason":Internal Server Error"}

      Error message in logs:

      2024-09-03 15:12:25,012 ERROR [http-nio-127.0.0.1-8090-exec-2447] [rest.api.model.ExceptionConverter] convertServiceException No status code found for exception, converting to internal server error : 
 -- url: /rest/api/space/SPACE/content | userName: username | traceId: a8dc9be8902131fc
org.hibernate.HibernateException: Unable to resolve owner of loading collection [[com.atlassian.confluence.core.ContentEntityObject.contentProperties#145496197]] for second level caching

      Workaround

      Upgrade to Confluence 8.5.15

              Unassigned Unassigned
              rlouie Robert Louie
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: