Uploaded image for project: 'JCommune'
  1. JCommune
  2. JC-1157

An exception on the main Forum page is displayed when some entity was deleted (user or permissions)

    Details

    • Sprint:
      1.4 Larks

      Description

      Preconditions:
      Somehow related with user or usergroup or permissions deletion
      Upd: probably the deletion of not activated user 24 hours after registration

      How to reproduce:
      1. Login as any user
      2. Go to uat.jtalks.org/jcommune/ or http://uat.jtalks.org/jcommune/sections

      AR:
      An exception is displayed (full text see attached)

      org.hibernate.ObjectNotFoundException: No row with the given identifier exists: org.jtalks.jcommune.model.entity.JCUser#72

      ER:
      Forum is displayed as usual

        Attachments

          Issue Links

            Activity

            Hide
            kitsune Polina added a comment - - edited

            First exception appears in localhost.2012-12-04.log
            Dec 4, 2012 12:58:14 PM

            Another record
            2012-12-03 12:41:11,726 [INFO ][http-8105-12 ][-.-.-.-.-.TransactionalUserService] - JCUser registered: idima

            The user idima is not available in DB, it was likely deleted 24 hours after creation.
            (the last created user has id#71, and the exception points to id#72)

            The first exception appears 24 hours (and 20 minutes) after this user was created

            The problem is related somehow with user which was registered, but never logged in.

            The one question: why it still happens even after the DB restore?

            Show
            kitsune Polina added a comment - - edited First exception appears in localhost.2012-12-04.log Dec 4, 2012 12:58:14 PM Another record 2012-12-03 12:41:11,726 [INFO ] [http-8105-12 ] [-.-.-.-.-.TransactionalUserService] - JCUser registered: idima The user idima is not available in DB, it was likely deleted 24 hours after creation. (the last created user has id#71, and the exception points to id#72) The first exception appears 24 hours (and 20 minutes) after this user was created The problem is related somehow with user which was registered, but never logged in. The one question: why it still happens even after the DB restore?
            Hide
            ctapobep Stanislav Bashkyrtsev added a comment - - edited

            So the reason this exception happens:

            1. User was registered, but didn't activate his profile
            2. User was added to moderators list of some branch
            3. JCommune removes the user in 24hrs, but the users stays in the cached collections.
            4. JCommune tries to read from cached collection, sees the obsolete record and tries to read it from DB. And fails.

            The root cause of this is that Poulpe doesn't know anything about activated/non-activated users and thus can't filter them out while adding to the moderators list. What we need is to share the information with Poulpe and let it filter the users.
            The issue will be fixed during next 2 iterations (1 iteration for JCommune, 1 iteration for Poulpe).

            Show
            ctapobep Stanislav Bashkyrtsev added a comment - - edited So the reason this exception happens: User was registered, but didn't activate his profile User was added to moderators list of some branch JCommune removes the user in 24hrs, but the users stays in the cached collections. JCommune tries to read from cached collection, sees the obsolete record and tries to read it from DB. And fails. The root cause of this is that Poulpe doesn't know anything about activated/non-activated users and thus can't filter them out while adding to the moderators list. What we need is to share the information with Poulpe and let it filter the users. The issue will be fixed during next 2 iterations (1 iteration for JCommune, 1 iteration for Poulpe).
            Hide
            julik Julia Atlygina added a comment -

            Stanislav Bashkyrtsev can we fix it in 1.3? it's annoying to see error 500 every day on uat

            Show
            julik Julia Atlygina added a comment - Stanislav Bashkyrtsev can we fix it in 1.3? it's annoying to see error 500 every day on uat
            Hide
            ctapobep Stanislav Bashkyrtsev added a comment -

            It will be fixed by POULPE-489

            Show
            ctapobep Stanislav Bashkyrtsev added a comment - It will be fixed by POULPE-489
            Hide
            sasha2888 Alexandra Pancheshenko added a comment -

            Browser: Opera 12.14
            Build version: 1.4 Swallows

            Test scenario:

            Functionality Result
            1. Not activated user can't automatically added to the group "Registered User" Passed
            2. Not activated user can't manually added to the group "Registered User" Passed

            Regression testing:

            Functionality Result
            1. The deletion of user group that has permission to SEND_PRIVATE_MESSAGES Passed
            2. The deletion of user group that has component admin permission to JCommune Passed
            3. The deletion of user group that has some permission in any branch Passed
            4. The deletion of user group that has moderating permission for branch Passed
            5. The deletion of branch which contains а moderation user group with permissions Passed
            6. The deletion of section with branch which contain moderation user group with permissions Passed

            Test results: Issue can be closed

            Show
            sasha2888 Alexandra Pancheshenko added a comment - Browser: Opera 12.14 Build version: 1.4 Swallows Test scenario : № Functionality Result 1. Not activated user can't automatically added to the group "Registered User" Passed 2. Not activated user can't manually added to the group "Registered User" Passed Regression testing : № Functionality Result 1. The deletion of user group that has permission to SEND_PRIVATE_MESSAGES Passed 2. The deletion of user group that has component admin permission to JCommune Passed 3. The deletion of user group that has some permission in any branch Passed 4. The deletion of user group that has moderating permission for branch Passed 5. The deletion of branch which contains а moderation user group with permissions Passed 6. The deletion of section with branch which contain moderation user group with permissions Passed Test results : Issue can be closed

              People

              • Assignee:
                sasha2888 Alexandra Pancheshenko
                Reporter:
                kitsune Polina
              • Votes:
                0 Vote for this issue
                Watchers:
                Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Structure Helper Panel