Uploaded image for project: 'Commenting'
  1. Commenting
  2. COMMENTING-23

getForUpdate on PostgreSQL throws exception

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 1.0
    • None
    • None
    • PostgreSQL 12.3-1.pgdg100+1
    • Scrum Sprint 1

    Description

      When trying to like or dislie or report o run any update operation on comment entity, the following exception is thrown by info.magnolia.commenting.service.CommentingServiceImpl.getForUpdate(long):

      javax.persistence.PersistenceException: Query threw SQLException:ERROR: FOR UPDATE cannot be applied to the nullable side of an outer join Bind values:[4, ] Query was:select t0.id, t0.mgnl_workspace, t0.mgnl_id, t0.text, t0.user_name, t0.user_email, t0.author_choice, t0.abuse_report, t0.num_likes, t0.num_unlikes, t0.rating, t0.version, t0.created, t0.created_by, t0.modified, t0.modified_by, t2.id, t2.mgnl_workspace, t2.mgnl_id, t2.text, t2.user_name, t2.user_email, t2.author_choice, t2.abuse_report, t2.num_likes, t2.num_unlikes, t2.rating, t2.version, t2.created, t2.created_by, t2.modified, t2.modified_by, t2.parent_id, t1.id, t1.mgnl_workspace, t1.mgnl_id, t1.text, t1.user_name, t1.user_email, t1.author_choice, t1.abuse_report, t1.num_likes, t1.num_unlikes, t1.rating, t1.version, t1.created, t1.created_by, t1.modified, t1.modified_by, t1.parent_id from comments t0 left join comments t2 on t2.id = t0.parent_id  left join comments t1 on t1.parent_id = t0.id  where t0.id = ?   order by t0.id for update
      

      Full exception log attached.

      Checklists

        Acceptance criteria

        Attachments

          Activity

            People

              rdrangovski Riste Drangovski
              ebguilbert Edwin Guilbert
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Checklists

                  Bug DoR
                  Task DoD