942 Update Album Access > 500 error appears when changing Album Access

[email protected] added a feedback(#2992764) from https://app.greatalbum.net/album/new1:

Steps to reproduce:
1. Navigate to the album ( I used previously created album with many media inside)
2. Click 'Edit' button
3. Change the Album Access ( I selected from Public to Community)
4. Validate the process

Expected Result: The Album Access is changed successfully.
Actual Result: The following error message is displayed:
An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /batch?id=921&op=do_nojs&op=do
StatusText: error
ResponseText: The website encountered an unexpected error. Please try again later.Drupal\Core\Entity\EntityStorageException: SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT savepoint_1 does not exist: ROLLBACK TO SAVEPOINT savepoint_1; Array
(
)
in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 846 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php). Drupal\Core\Database\Statement->execute(Array, Array) (Line: 640)
Drupal\Core\Database\Connection->query('ROLLBACK TO SAVEPOINT savepoint_1', Array, Array) (Line: 357)
Drupal\Core\Database\Driver\mysql\Connection->query('ROLLBACK TO SAVEPOINT savepoint_1') (Line: 1160)
Drupal\Core\Database\Connection->rollBack('savepoint_1') (Line: 96)
Drupal\Core\Database\Transaction->rollBack() (Line: 844)
Drupal\Core\Entity\Sql\SqlContentEntityStorage->save(Object) (Line: 395)
Drupal\Core\Entity\EntityBase->save() (Line: 327)
Drupal\message\Entity\Message->save() (Line: 156)
Drupal\activity_logger\Service\ActivityLoggerFactory->createMessages(Object, 'great_custom_follow_individual_update_media_action') (Line: 34)
Drupal\great_custom\Plugin\ActivityAction\FollowIndividualMediaUpdateActivityAction->createMessage(Object) (Line: 18)
Drupal\activity_creator\Plugin\ActivityActionBase->create(Object) (Line: 434)
great_custom_entity_update(Object)
call_user_func_array('great_custom_entity_update', Array) (Line: 403)
Drupal\Core\Extension\ModuleHandler->invokeAll('entity_update', Array) (Line: 206)
Drupal\Core\Entity\EntityStorageBase->invokeHook('update', Object) (Line: 843)
Drupal\Core\Entity\ContentEntityStorageBase->invokeHook('update', Object) (Line: 535)
Drupal\Core\Entity\EntityStorageBase->doPostSave(Object, 1) (Line: 728)
Drupal\Core\Entity\ContentEntityStorageBase->doPostSave(Object, 1) (Line: 460)
Drupal\Core\Entity\EntityStorageBase->save(Object) (Line: 837)
Drupal\Core\Entity\Sql\SqlContentEntityStorage->save(Object) (Line: 29)
Drupal\media\MediaStorage->save(Object) (Line: 395)
Drupal\Core\Entity\EntityBase->save() (Line: 135)
Drupal\social_group_flexible_group\FlexibleGroupContentVisibilityUpdate::updateVisibility(Object, Array, Array) (Line: 295)
_batch_process() (Line: 137)
_batch_do() (Line: 93)
_batch_page(Object) (Line: 55)
Drupal\system\Controller\BatchController->batchPage(Object)
call_user_func_array(Array, Array) (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber
{closure}() (Line: 573)
Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 124)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext(Array, Array) (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber
{closure}() (Line: 151)
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 68)
Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 57)
Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 47)
Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 1, 1) (Line: 106)
Drupal\page_cache\StackMiddleware\PageCache->pass(Object, 1, 1) (Line: 85)
Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 47)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 52)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 23)
Stack\StackedHttpKernel->handle(Object, 1, 1) (Line: 708)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)

The user I used - https://app.greatalbum.net/user/431/information

The album I used - https://app.greatalbum.net/album/new1

Attachment: https://static.userback.io/57763/project/71541/feedback/2992764/attachment/Снимок экрана 2023-09-26 в 13.56.13.png

Session details:

• Feedback ID: #2992764
• Browser: Chrome 116.0.0.0 (macOS)
• Rating: N/A
• Window Size: 1389 x 790
• Resolution: 1440 x 900
• DPI: 1
• Colour Depth: 24-bit
• Category: Album

View feedback details in Userback:
https://app.userback.io/viewer/36775/71541/2992764xRD5MGBw/