-
Type:
Regression Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 7.0.X EE, Master
-
Fix Version/s: 7.0.0 DXP FP28, 7.0.X EE, 7.0.4 CE GA5, 7.1.X, Master
-
Component/s: Calendar, Portal Configuration > Portal Instances
-
Branch Version/s:7.0.x
-
Backported to Branch:Committed
-
Fix Priority:4
-
Last Working Version:
-
Git Pull Request:
-
QA Test Name:
- Calendar#AddEventAllDayRSVPYes
- Calendar#AddEventAllDayWithRemindersEnabled
- Calendar#AddEventAllDayWithTag
- Calendar#AddEventAllDayWithUserInviteAccept
- Calendar#AddEventAsPowerUserWhenSiteMemberNoViewPermissions
- Calendar#AddEventRegular
- Calendar#AddEventRegularAndResourceWithStagingAndSchedulePublishToLive
- Calendar#AddEventRegularCommentToCurrentSiteCalendars
- Calendar#AddEventRegularRSVPYes
- Calendar#AddEventRegularWithUserInvite
- Calendar#AddEventRegularWithUserInviteAccept
- Calendar#AddEventRepeating
- Calendar#AddEventRepeatingMonthly2Times
- Calendar#AddEventRepeatingWeekly2Times
- Calendar#AddEventRepeatingWithEndDateBeforeStartDate
- Calendar#AddEventRepeatingWithRemindersEnabled
- Calendar#AddEventRepeatingWithTag
- Calendar#AddEventRepeatingWithUserInviteAccept
- Calendar#AddEventWithLargeDateRange
- Calendar#AddEventsViaScheduler
- Calendar#AddResourceCalendarToOtherCalendars
- Calendar#AddUserCalendarToOtherCalendars
- Calendar#CancelRepeatingDialog
- Calendar#ChangeCalendarTypeForRegularEvent
- Calendar#ChangeColorCalendarSiteCalendarsEventRegular
- Calendar#ConfigureDefaultView
- Calendar#DeleteCalendarMyCalendars
- Calendar#DeleteEventAndViewRSSFeed
- Calendar#DeleteEventRepeatingAllEventsInTheSeries
- Calendar#DeleteEventRepeatingOnlyThisInstance
- Calendar#DisableRSSFeedForSiteCalendar
- Calendar#EditCalendarResource
- Calendar#EditEventAllDay
- Calendar#EditEventAllDayReminders
- Calendar#EditEventAndViewRSVP
- Calendar#EditEventRegular
- Calendar#EditEventRegularWithUserInvite
- Calendar#EditEventRepeating
- Calendar#EditEventRepeatingAllEventsInTheSeries
- Calendar#EditEventRepeatingWithUserInvite
- Calendar#EditInviteEmailTemplateForCalendarResourceCalendar
- Calendar#EditInviteEmailTemplateForCurrentSiteCalendarsCalendar
- Calendar#EditInviteEmailTemplateForMyCalendarsCalendar
- Calendar#EditReminderEmailTemplateForCurrentSiteCalendarsCalendar
- Calendar#EditReminderEmailTemplateForMyCalendarsCalendar
- Calendar#EditReminderEmailTemplateForUserCalendar
- Calendar#EditUserCalendarOtherCalendars
- Calendar#ExportUserCalendarAsICS
- Calendar#ImportMicrosoftOutlookCalendarICS
- Calendar#InviteAndViewAdditionalUsers
- Calendar#SearchEventInSearchPortletWithTag
- Calendar#View24hourTimeFormat
- Calendar#ViewCorrectCalendarOnEventSwitch
- Calendar#ViewCorrectNumberOfWeeksMonthView
- Calendar#ViewDefaultDurationsViaScheduler
- Calendar#ViewEventCalendarChange
- Calendar#ViewEventDateAndTimeInResourcesAvailability
- Calendar#ViewEventDetailsAllDayWithModifiedUserTimeZone
- Calendar#ViewInactiveResourceNotPresent
- Calendar#ViewInvitedResourceAvailability
- Calendar#ViewResourceCalendarPageAfterCancellingEdit
- Calendar#ViewSiteCalendarRSSFeed
- Calendar#ViewWeekStartMonday
- Calendar#ViewWeekStartSaturday
- CalendarConfiguration#ConfigureDefaultView
- CalendarConfiguration#View24hourTimeFormat
- CalendarConfiguration#ViewEventDetailsAllDayWithModifiedUserTimeZone
- CalendarConfiguration#ViewWeekStartSaturday
- CalendarCreateCalendar#AddCalendarToCurrentSiteCalendars
- CalendarCreateCalendar#AddCalendarToMyCalendars
- CalendarCreateCalendar#ViewUserCanAddSiteCalendarsWithCalendarPermissions
- CalendarCreateEvent#AddAfterClosingModal
- CalendarCreateEvent#AddAllDayWithTag
- CalendarCreateEvent#AddAllDayWithUserInviteAccept
- CalendarCreateEvent#AddRegular
- CalendarCreateEvent#AddRegularRSVPYes
- CalendarCreateEvent#AddRegularWithRemindersEnabled
- CalendarCreateEvent#AddRegularWithTag
- CalendarCreateEvent#AddRepeating
- CalendarCreateEvent#AddRepeatingRSVPYes
- CalendarCreateEvent#AddRepeatingWeekly2Times
- CalendarCreateEvent#AddRepeatingWithEndDateBeforeStartDate
- CalendarCreateEvent#AddRepeatingWithUserInviteAccept
- CalendarCreateEvent#AddRepeatingYearly
- CalendarCreateEvent#AddViaScheduler
- CalendarCreateEvent#InviteAndViewAdditionalUsers
- CalendarCreateEvent#InviteUsersAndViewResponse
- CalendarEmailTemplate#EditInviteForCalendarResourceCalendar
- CalendarEmailTemplate#EditInviteForMyCalendarsCalendar
- CalendarEmailTemplate#EditReminderForMyCalendarsCalendar
- CalendarEmailTemplate#EditReminderForUserCalendar
- CalendarExportImport#ExportUserCalendarAsICS
- CalendarExportImport#ImportCalendarAndViewEventComment
- CalendarExportImport#ImportMicrosoftOutlookCalendarICS
- CalendarLocalization#ViewShowMoreLocalization
- CalendarManageCalendar#ChangeCalendarTypeForRegularEvent
- CalendarManageCalendar#ChangeCalendarTypeForRepeatingEvent
- CalendarManageCalendar#EditCalendarCurrentSiteCalendars
- CalendarManageCalendar#EditCalendarMyCalendars
- CalendarManageCalendar#EditCalendarResource
- CalendarManageCalendar#EditUserCalendarOtherCalendars
- CalendarManageEvent#DeleteRepeatingAllEventsInTheSeries
- CalendarManageEvent#DeleteRepeatingOnlyThisInstance
- CalendarManageEvent#EditAllDay
- CalendarManageEvent#EditAllDayReminders
- CalendarManageEvent#EditAllDayWithUserInvite
- CalendarManageEvent#EditAndViewRSVP
- CalendarManageEvent#EditRegular
- CalendarManageEvent#EditRegularReminders
- CalendarManageEvent#EditRepeatingWithUserInvite
- CalendarManageEvent#SearchInSearchPortletWithTag
- CalendarManageEvent#ViewCalendarChange
- CalendarManageEvent#ViewCorrectCalendarOnEventSwitch
- CalendarManageResource#Delete
- CalendarManageResource#Search
- CalendarManageResource#ViewInactive
- CalendarManageResource#ViewInvitedResourceAvailability
- CalendarRSS#DeleteEventAndViewFeed
- CalendarRSS#ViewSiteCalendarFeed
- CalendarScheduler#ViewCreatedEventVisibleOnScheduler
- CalendarScheduler#ViewDefaultDurationsViaScheduler
- CalendarStaging#AddEvent
- EventsList#ViewEventTime
- WorkflowCalendar#ApproveEventWithInvitedUser
- WorkflowCalendar#DeleteAndRestoreEvent
- WorkflowCalendar#RejectEventWithInvitedUser
- WorkflowCalendar#ViewPendingStatusInEventDetails
-
QA Test Score:449
Steps to Reproduce:
- Go to Control Panel > Virtual Instances
- Create an instance
- Navigate to new instance
- Add Calendar portlet to a page
- Go to Calendar portlet > Configuration
- Set "Week Start On" to "Monday
- Save
- Go to main instance
- Go to Control Panel > Virtual Instances
- Attempt to delete created virtual instance
Expected Result:
Instance can be deleted.
Actual Result:
Instance fails to delete with error:
15:48:36,527 ERROR [http-nio-8080-exec-4][JDBCExceptionReporter:234] Lock wait timeout exceeded; try restarting transaction 15:48:36,628 ERROR [http-nio-8080-exec-4][GroupLocalServiceImpl:3556] Unable to delete data for portlet null in group 35326
mysql> select * from Group_ where groupId=35326; +-------------+--------------------------------------+---------+-----------+---------------+-------------+---------+---------------+-------------+----------+----------+------+-------------+-------+--------------+------------------+-----------------------+-------------+------+-------------------------+----------------+---------+ | mvccVersion | uuid_ | groupId | companyId | creatorUserId | classNameId | classPK | parentGroupId | liveGroupId | treePath | groupKey | name | description | type_ | typeSettings | manualMembership | membershipRestriction | friendlyURL | site | remoteStagingGroupCount | inheritContent | active_ | +-------------+--------------------------------------+---------+-----------+---------------+-------------+---------+---------------+-------------+----------+----------+------+-------------+-------+--------------+------------------+-----------------------+-------------+------+-------------------------+----------------+---------+ | 0 | db11bf5c-7468-e34e-3934-87a5ff839530 | 35326 | 35284 | 35324 | 20084 | 35324 | 0 | 0 | /35326/ | 35324 | NULL | NULL | 0 | | 1 | 0 | /test | 0 | 0 | 0 | 1 | +-------------+--------------------------------------+---------+-----------+---------------+-------------+---------+---------------+-------------+----------+----------+------+-------------+-------+--------------+------------------+-----------------------+-------------+------+-------------------------+----------------+---------+ 1 row in set (0.00 sec)
Reproduced on:
Tomcat 8.0.32 + MySQL 5.7.17. Portal master GIT ID: 4d447e93b2535b210eb32b92354e2c4f24196183.
Tomcat 8.0.32 + MySQL 5.7.17. Portal ee-7.0.x GIT ID: e08a350d6f41d526e1437e421a8b1998540061e9.
Not Reproducible on:
Tomcat 8.0.32 + MySQL 5.7.17. 7.0 DXP + FP24
- is caused by
-
LPS-55244 ResourceBlockPermission table grows with orphan rows
- Closed