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

Date Manager: Uncaught error if fixing date from previous error

    XMLWordPrintable

Details

    • Bug
    • Status: OPEN
    • Critical
    • Resolution: Unresolved
    • 22.0 [Tentative]
    • None
    • Date Manager
    • None
    • Sakai nightly
    • Hide

      Original test plan:

      1. Add Calendar tool to a site
      2. Add a couple events to the calendar
      3. Access Date Manager
      4. Update one of the calendar items and set the open date later than the end date
      5. You will receive and error that the open date should be before the end date
      6. Update the open date correctly so its before the end date.
      7. Press save
      8. The update should be successful

      Updated test:

      1. Add Calendar tool and another, such as Announcements to a site.
      2. Add an announcement with start/end dates
      3. Add a couple calendar events
      4. Access Date Manager
      5. Update the Announcement to have the open date after the close date.
      6. Update all calendar events to be ok.
      7. Click the Save button - you will receive a warning about the announcement.
      8. Fix the announcement dates.
      9. Click the Save button again
        Expected behavior: Everything saved
        Current behavior: Uncaught error for the calendar events.
      Show
      Original test plan: Add Calendar tool to a site Add a couple events to the calendar Access Date Manager Update one of the calendar items and set the open date later than the end date You will receive and error that the open date should be before the end date Update the open date correctly so its before the end date. Press save The update should be successful Updated test: Add Calendar tool and another, such as Announcements to a site. Add an announcement with start/end dates Add a couple calendar events Access Date Manager Update the Announcement to have the open date after the close date. Update all calendar events to be ok. Click the Save button - you will receive a warning about the announcement. Fix the announcement dates. Click the Save button again Expected behavior: Everything saved Current behavior: Uncaught error for the calendar events.

    Description

      If fixing an error from any tool, Calendar events will give an uncaught error in Date manager. (New fullcalendar tool)

      An error in the UI will appear stating uncaught error.  

      In the catalina logs there will be an issue stating can not write to db due to an insert in the sakai_locks table.
       
      10-Sep-2021 10:41:42.593 ERROR [http-nio-20013-exec-20] o.s.d.i.DateManagerServiceImpl.validateCalendarEvents Cannot edit event 88d7f43d-a9c2-4bce-adf2-3923e2de4994
       
      10-Sep-2021 10:41:42.602 WARN [http-nio-20013-exec-20] o.s.d.i.BasicSqlService.dbWriteCount Sql.dbWrite(): recordAlreadyExists: true, failQuiet: 1, : error code: 1062, sql: insert into SAKAI_LOCKS (TABLE_NAME,RECORD_ID,LOCK_TIME,USAGE_SESSION_ID) values (?, ?, ?, ?), binds: CALENDAR_EVENT 1396663355 - /calendar/calendar/40a87050-f7a2-404f-a01e-20a6d8c84141/main/cf3d6baf-0db1-4a9e-904d-0361f20f0d56 20210910144142601 72711009-8045-4dd2-96ab-d3907d1ec694, error: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'CALENDAR_EVENT-1396663355 - /calendar/calendar/40a87050-f7a2-40' for key 'SAKAI_LOCKS_INDEX'
       
      10-Sep-2021 10:41:42.605 ERROR [http-nio-20013-exec-20] o.s.d.i.DateManagerServiceImpl.validateCalendarEvents Cannot edit event cf3d6baf-0db1-4a9e-904d-0361f20f0d56
       
      10-Sep-2021 10:41:42.615 WARN [http-nio-20013-exec-20] o.s.d.i.BasicSqlService.dbWriteCount Sql.dbWrite(): recordAlreadyExists: true, failQuiet: 1, : error code: 1062, sql: insert into SAKAI_LOCKS (TABLE_NAME,RECORD_ID,LOCK_TIME,USAGE_SESSION_ID) values (?, ?, ?, ?), binds: CALENDAR_EVENT 898958332 - /calendar/calendar/40a87050-f7a2-404f-a01e-20a6d8c84141/main/3fa6c2fc-abb0-47b5-91fb-5182d551780e 20210910144142613 72711009-8045-4dd2-96ab-d3907d1ec694, error: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'CALENDAR_EVENT-898958332 - /calendar/calendar/40a87050-f7a2-404f' for key 'SAKAI_LOCKS_INDEX'

      Gliffy Diagrams

        Zeplin

          Attachments

            Issue Links

              Activity

                People

                  bergarvi Bernardo Garcia Vila
                  cschwiebert Christina Schwiebert
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                    Created:
                    Updated:

                    Git Integration