Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-42592

TurnitinOC: the duedate placeholder items are not being deleted in the contentreview_item table

    XMLWordPrintable

    Details

    • 19 status:
      Resolved
    • 12 status:
      Resolved
    • Previous Issue Keys:
      TII-273

      Description

      The `_placeholder` content review items are used to keep track of when to re-run a report after due date for collusion checking. However, there is a hibernate exception that causes these items to not delete:

       

      catalina.out-pre-patch-38805-08-Sep-2019 04:57:21.064 INFO [http-apr-8477-exec-236] org.sakaiproject.webservices.interceptor.RemoteHostMatcher.isAllowed Access denied (implicit): 34.198.36.87/34.198.36.87
      catalina.out-pre-patch-38805-08-Sep-2019 04:57:21.063 INFO [http-apr-8477-exec-290] org.sakaiproject.webservices.interceptor.RemoteHostMatcher.isAllowed Access denied (implicit): 34.198.36.87/34.198.36.87
      catalina.out-pre-patch-38805-08-Sep-2019 04:57:21.063 INFO [http-apr-8477-exec-294] org.sakaiproject.webservices.interceptor.RemoteHostMatcher.isAllowed Access denied (implicit): 34.198.36.87/34.198.36.87
      catalina.out-pre-patch-38805-08-Sep-2019 04:57:21.063 INFO [http-apr-8477-exec-283] org.sakaiproject.webservices.interceptor.RemoteHostMatcher.isAllowed Access denied (implicit): 34.198.36.87/34.198.36.87
      catalina.out-pre-patch-38805-08-Sep-2019 04:57:21.064 INFO [http-apr-8477-exec-285] org.sakaiproject.webservices.interceptor.RemoteHostMatcher.isAllowed Access denied (implicit): 34.198.36.87/34.198.36.87
      catalina.out-pre-patch-38805-08-Sep-2019 04:57:21.095 INFO [http-apr-8477-exec-270] org.sakaiproject.webservices.interceptor.RemoteHostMatcher.isAllowed Access denied (implicit): 34.198.36.87/34.198.36.87
      catalina.out-pre-patch-38805-08-Sep-2019 04:57:21.095 INFO [http-apr-8477-exec-236] org.sakaiproject.webservices.interceptor.RemoteHostMatcher.isAllowed Access denied (implicit): 34.198.36.87/34.198.36.87
      catalina.out-pre-patch-38805-08-Sep-2019 04:57:21.133 INFO [http-apr-8477-exec-290] org.sakaiproject.webservices.interceptor.RemoteHostMatcher.isAllowed Access denied (implicit): 34.198.36.87/34.198.36.87
      catalina.out-pre-patch-38805-08-Sep-2019 04:57:23.056 WARN [http-apr-8477-exec-284] org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.resolveException Resolved [org.springframework.data.rest.webmvc.ResourceNotFoundException: Resource not found!]
      catalina.out-pre-patch-38805-08-Sep-2019 05:00:00.151 INFO [QuartzScheduler_Worker-4] org.sakaiproject.contentreview.vericite.ContentReviewServiceVeriCite.processQueue Processing VeriCite submission queue
      catalina.out-pre-patch-38805-08-Sep-2019 05:00:02.737 INFO [QuartzScheduler_Worker-4] org.sakaiproject.contentreview.vericite.ContentReviewServiceVeriCite.processQueue Submission VeriCite queue run completed: 0 items submitted, 0 errors.
      catalina.out-pre-patch-38805-08-Sep-2019 05:00:02.737 INFO [QuartzScheduler_Worker-4] org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.processQueue Processing Turnitin OC submission queue
      catalina.out-pre-patch-38805:08-Sep-2019 05:00:02.785 ERROR [pool-205-thread-2] org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.checkForReport Removing a detached instance org.sakaiproject.contentreview.dao.ContentReviewItem#507835
      catalina.out-pre-patch-38805:java.lang.IllegalArgumentException: Removing a detached instance org.sakaiproject.contentreview.dao.ContentReviewItem#507835
      catalina.out-pre-patch-38805- at org.hibernate.jpa.event.internal.core.JpaDeleteEventListener.performDetachedEntityDeletionCheck(JpaDeleteEventListener.java:69)
      catalina.out-pre-patch-38805- at org.hibernate.event.internal.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:106)
      catalina.out-pre-patch-38805- at org.hibernate.event.internal.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:73)
      catalina.out-pre-patch-38805- at org.hibernate.internal.SessionImpl.fireDelete(SessionImpl.java:956)
      catalina.out-pre-patch-38805- at org.hibernate.internal.SessionImpl.delete(SessionImpl.java:896)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.dao.HibernateCommonDao.delete(HibernateCommonDao.java:65)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.service.ContentReviewQueueServiceImpl.delete(ContentReviewQueueServiceImpl.java:269)
      catalina.out-pre-patch-38805- at sun.reflect.GeneratedMethodAccessor7965.invoke(Unknown Source)
      catalina.out-pre-patch-38805- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      catalina.out-pre-patch-38805- at java.lang.reflect.Method.invoke(Method.java:498)
      catalina.out-pre-patch-38805- at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
      catalina.out-pre-patch-38805- at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
      catalina.out-pre-patch-38805- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
      catalina.out-pre-patch-38805- at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
      catalina.out-pre-patch-38805- at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
      catalina.out-pre-patch-38805- at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
      catalina.out-pre-patch-38805- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      catalina.out-pre-patch-38805- at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
      catalina.out-pre-patch-38805- at com.sun.proxy.$Proxy174.delete(Unknown Source)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.checkForReport(ContentReviewServiceTurnitinOC.java:895)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC$3.run(ContentReviewServiceTurnitinOC.java:835)
      catalina.out-pre-patch-38805- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      catalina.out-pre-patch-38805- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      catalina.out-pre-patch-38805- at java.lang.Thread.run(Thread.java:748)
      catalina.out-pre-patch-38805-08-Sep-2019 05:00:02.824 INFO [pool-205-thread-1] org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.processUnsubmitted Submission starting...
      catalina.out-pre-patch-38805-08-Sep-2019 05:00:02.825 INFO [pool-205-thread-2] org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.checkForReport Turnitin report queue run completed: 0 items submitted, 1 errors.
      catalina.out-pre-patch-38805-08-Sep-2019 05:00:03.710 ERROR [pool-205-thread-1] org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.getSubmissionId Server returned HTTP response code: 451 for URL: https://lamp.turnitin.com/api/v1/submissions
      catalina.out-pre-patch-38805-java.io.IOException: Server returned HTTP response code: 451 for URL: https://lamp.turnitin.com/api/v1/submissions
      catalina.out-pre-patch-38805- at sun.reflect.GeneratedConstructorAccessor415.newInstance(Unknown Source)
      catalina.out-pre-patch-38805- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      catalina.out-pre-patch-38805- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection$10.run(HttpURLConnection.java:1944)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection$10.run(HttpURLConnection.java:1939)
      catalina.out-pre-patch-38805- at java.security.AccessController.doPrivileged(Native Method)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection.getChainedException(HttpURLConnection.java:1938)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1508)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1492)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:263)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.makeHttpCall(ContentReviewServiceTurnitinOC.java:629)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.getSubmissionId(ContentReviewServiceTurnitinOC.java:783)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.processUnsubmitted(ContentReviewServiceTurnitinOC.java:1026)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC$2.run(ContentReviewServiceTurnitinOC.java:828)
      catalina.out-pre-patch-38805- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      catalina.out-pre-patch-38805- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      catalina.out-pre-patch-38805- at java.lang.Thread.run(Thread.java:748)
      catalina.out-pre-patch-38805-Caused by: java.io.IOException: Server returned HTTP response code: 451 for URL: https://lamp.turnitin.com/api/v1/submissions
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1894)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1492)
      catalina.out-pre-patch-38805- at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:347)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.makeHttpCall(ContentReviewServiceTurnitinOC.java:627)
      catalina.out-pre-patch-38805- ... 6 more
      catalina.out-pre-patch-38805-08-Sep-2019 05:00:03.711 ERROR [pool-205-thread-1] org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.processUnsubmitted submission id is missing
      catalina.out-pre-patch-38805-java.lang.Exception: submission id is missing
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.processUnsubmitted(ContentReviewServiceTurnitinOC.java:1028)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC$2.run(ContentReviewServiceTurnitinOC.java:828)
      catalina.out-pre-patch-38805- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      catalina.out-pre-patch-38805- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      catalina.out-pre-patch-38805- at java.lang.Thread.run(Thread.java:748)
      catalina.out-pre-patch-38805-08-Sep-2019 05:00:03.724 INFO [pool-205-thread-1] org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.processUnsubmitted Submission starting...
      catalina.out-pre-patch-38805-08-Sep-2019 05:00:04.632 ERROR [pool-205-thread-1] org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.getSubmissionId Server returned HTTP response code: 451 for URL: https://lamp.turnitin.com/api/v1/submissions
      catalina.out-pre-patch-38805-java.io.IOException: Server returned HTTP response code: 451 for URL: https://lamp.turnitin.com/api/v1/submissions
      catalina.out-pre-patch-38805- at sun.reflect.GeneratedConstructorAccessor415.newInstance(Unknown Source)
      catalina.out-pre-patch-38805- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      catalina.out-pre-patch-38805- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection$10.run(HttpURLConnection.java:1944)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection$10.run(HttpURLConnection.java:1939)
      catalina.out-pre-patch-38805- at java.security.AccessController.doPrivileged(Native Method)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection.getChainedException(HttpURLConnection.java:1938)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1508)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1492)
      catalina.out-pre-patch-38805- at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:263)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.makeHttpCall(ContentReviewServiceTurnitinOC.java:629)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.getSubmissionId(ContentReviewServiceTurnitinOC.java:783)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC.processUnsubmitted(ContentReviewServiceTurnitinOC.java:1026)
      catalina.out-pre-patch-38805- at org.sakaiproject.contentreview.turnitin.oc.ContentReviewServiceTurnitinOC$2.run(ContentReviewServiceTurnitinOC.java:828)
      catalina.out-pre-patch-38805- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      catalina.out-pre-patch-38805- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      catalina.out-pre-patch-38805- at java.lang.Thread.run(Thread.java:748)
      catalina.out-pre-patch-38805-Caused by: java.io.IOException: Server returned HTTP response code: 451 for URL: https://lamp.turnitin.com/api/v1/submissions

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                baholladay Bryan Holladay
                Reporter:
                baholladay Bryan Holladay
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code