### Before filing a report

Begin of the deletion _Before you file a report, please ensure you are running the latest version of OpenProject and_ 
_have searched for similar bug reports._

End of the deletion * _I found this closed/rejected bug-report and commented but I got no reaction, hence opening a new one_

<br>

[_https://community.openproject.org/projects/openproject/work\_packages/59939_](https://community.openproject.org/projects/openproject/work_packages/59939)


### Steps to reproduce

Begin of the deletion _Please write down the steps to reproduce. Try to write down all necessary preconditions (what permissions do you have, are other users involved?). Example:_

End of the deletion 1. Select multiple work packages by holding down CTRL or SHIFT

2. Right click one and edit work packages

3. Change the start and end-date Begin of the insertion(it also happens when changing priority)End of the insertion

4. Begin of the insertionMake sure there are multiple ckeditor in the form (because of multiple &quot;long text&quot; custom fields)

5. End of the insertion Confirm with OK


Begin of the deletion **In the case of deletion**

We have observed the same error during bulk deletion. I wasn&#39;t able to reproduce it just yet, but the structure we saw was as follows.

```text
Parent Task
Task 1 - preceeds 2, ?
Task 2 - preceeds 3, succeeds 1
Task 3 - preceeds 4, succeeds 2
Task 4 - preceeds 5, succeeds 3
Task 5 - succeeds 4, ?
Milestone 1 - preceeds 2, ?
Milestone 2 - preceeds 3, succeeds 1
Milestone 3 - preceeds 4, succeeds 2
Milestone 4 - preceeds 5, succeeds 3
Milestone 5 - succeeds 4, ?
```

End of the deletion ### What is the buggy behavior?

Begin of the deletion _Please describe the bug in as much detail as possible. Example:_

End of the deletion * The website throws and error 500 and doesn&#39;t update the work packages as intended

* The error does not occur always, maybe 3 of 10 times. It can be reproduced


### What is the expected behavior?

Begin of the deletion _Describe how the application should behave like. Example:_

End of the deletion 1. The website confirms the changes and Begin of the insertionnavigatesEnd of the insertion Begin of the deletion revertsEnd of the deletion back to the work packages overview page


### Begin of the deletion Important note

_Please note that unless you are a contributor to OpenProject, you can no longer edit this bug report after saving. You can still add new comments, new images and upload attachments though, but updating description or modifying fields will not be possible after saving. Please make sure that all necessary information and attachments are added, and the following attributes are set:_

###End of the deletion **Logs**

Begin of the deletion _Are there errors in the browser console? (_[_Click here for information on how to open your browser&#39;s console_](https://webmasters.stackexchange.com/a/77337)_) For a local installation: Are there relevant logs output by_ `_openproject logs_` _(packaged installation) (_[_click here for details_](https://docs.openproject.org/installation-and-operations/operation/monitoring/#show-logs)_) or in a log/production.log or /var/log/openproject/ ? Please attach error output in these log files if applicable_

End of the deletion ```Debuglog
{"log":"E, [2025-01-09T08:22:25.284821 #1067] ERROR -- : [f20acbcc-396f-49cf-805f-4f1b559a39a9] user=24 Attempted to update a stale object: WorkPackage.: Attempted to update a stale object: WorkPackage.\n","stream":"stdout","time":"2025-01-09T08:22:25.285220189Z"}
{"log":"D, [2025-01-09T08:22:25.284907 #1067] DEBUG -- : [f20acbcc-396f-49cf-805f-4f1b559a39a9] [ActiveRecord::StaleObjectError] Attempted to update a stale object: WorkPackage.: Begin of the insertion<clean stacktrace below>\n","stream":"stdout","time":"2025-01-09T08:22:25.285257063Z"}

Attempted to update a stale object: WorkPackage.:
End of the insertion app/services/base_services/write.rb:36:in Begin of the insertion'persist'
End of the insertion Begin of the deletion `persist';End of the deletion app/services/base_services/base_contracted.rb:64:in Begin of the insertion'blockEnd of the insertion Begin of the deletion `blockEnd of the deletion in Begin of the insertionperform'
End of the insertion Begin of the deletion perform';End of the deletion app/models/journal/notification_configuration.rb:40:in Begin of the insertion'with'
End of the insertion Begin of the deletion `with';End of the deletion app/services/shared/service_context.rb:67:in Begin of the insertion'blockEnd of the insertion Begin of the deletion `blockEnd of the deletion in Begin of the insertionwithout_context_transaction'
End of the insertion Begin of the deletion without_context_transaction';End of the deletion lib/open_project/locale_helper.rb:36:in Begin of the insertion'with_locale_for'
End of the insertion Begin of the deletion `with_locale_for';End of the deletion app/models/user.rb:534:in Begin of the insertion'execute_as'
End of the insertion Begin of the deletion `execute_as';End of the deletion app/services/shared/service_context.rb:66:in Begin of the insertion'without_context_transaction'
End of the insertion Begin of the deletion `without_context_transaction';End of the deletion app/services/shared/service_context.rb:45:in Begin of the insertion'blockEnd of the insertion Begin of the deletion `blockEnd of the deletion in Begin of the insertionin_mutex_context'
End of the insertion Begin of the deletion in_mutex_context';End of the deletion lib/open_project/mutex.rb:71:in Begin of the insertion'blockEnd of the insertion Begin of the deletion `blockEnd of the deletion in Begin of the insertionwith_advisory_lock'
End of the insertion Begin of the deletion with_advisory_lock';End of the deletion lib/open_project/mutex.rb:69:in Begin of the insertion'with_advisory_lock'
End of the insertion Begin of the deletion `with_advisory_lock';End of the deletion lib/open_project/mutex.rb:63:in Begin of the insertion'blockEnd of the insertion Begin of the deletion `blockEnd of the deletion in Begin of the insertionwith_advisory_lock_transaction'
End of the insertion Begin of the deletion with_advisory_lock_transaction';End of the deletion lib/open_project/mutex.rb:62:in Begin of the insertion'with_advisory_lock_transaction'
End of the insertion Begin of the deletion `with_advisory_lock_transaction';End of the deletion app/services/shared/service_context.rb:44:in Begin of the insertion'in_mutex_context'
End of the insertion Begin of the deletion `in_mutex_context';End of the deletion app/services/shared/service_context.rb:35:in Begin of the insertion'in_context'
End of the insertion Begin of the deletion `in_context';End of the deletion app/services/base_services/base_contracted.rb:54:in Begin of the insertion'service_context'
End of the insertion Begin of the deletion `service_context';End of the deletion app/services/base_services/base_contracted.rb:59:in Begin of the insertion'perform'
End of the insertion Begin of the deletion `perform';End of the deletion app/services/base_services/base_callable.rb:40:in Begin of the insertion'blockEnd of the insertion Begin of the deletion `blockEnd of the deletion in Begin of the insertioncall'
End of the insertion Begin of the deletion call';End of the deletion app/services/concerns/with_reversible_state.rb:53:in Begin of the insertion'assign_state'
End of the insertion Begin of the deletion `assign_state';End of the deletion app/services/base_services/base_callable.rb:39:in Begin of the insertion'call'
End of the insertion Begin of the deletion `call';End of the deletion app/services/work_packages/bulk/update_service.rb:37:in Begin of the insertion'alter_work_package'
End of the insertion Begin of the deletion `alter_work_package';End of the deletion app/services/work_packages/bulk/bulked_service.rb:65:in Begin of the insertion'blockEnd of the insertion Begin of the deletion `blockEnd of the deletion in Begin of the insertionbulk'
End of the insertion Begin of the deletion bulk';End of the deletion app/services/work_packages/bulk/bulked_service.rb:57:in Begin of the insertion'bulk'
End of the insertion Begin of the deletion `bulk';End of the deletion app/services/work_packages/bulk/bulked_service.rb:48:in Begin of the insertion'blockEnd of the insertion Begin of the deletion `blockEnd of the deletion in Begin of the insertioncall'
End of the insertion Begin of the deletion call';End of the deletion app/models/journal/notification_configuration.rb:62:in Begin of the insertion'with_first'
End of the insertion Begin of the deletion `with_first';End of the deletion app/models/journal/notification_configuration.rb:45:in Begin of the insertion'with'
End of the insertion Begin of the deletion `with';End of the deletion app/services/shared/service_context.rb:67:in Begin of the insertion'blockEnd of the insertion Begin of the deletion `blockEnd of the deletion in Begin of the insertionwithout_context_transaction'
End of the insertion Begin of the deletion without_context_transaction';End of the deletion lib/open_project/locale_helper.rb:36:in Begin of the insertion'with_locale_for'
End of the insertion Begin of the deletion `with_locale_for';End of the deletion app/models/user.rb:534:in Begin of the insertion'execute_as'
End of the insertion Begin of the deletion `execute_as';End of the deletion app/services/shared/service_context.rb:66:in Begin of the insertion'without_context_transaction'
End of the insertion Begin of the deletion `without_context_transaction';End of the deletion app/services/work_packages/bulk/bulked_service.rb:47:in Begin of the insertion'call'
End of the insertion Begin of the deletion `call';End of the deletion app/controllers/work_packages/bulk_controller.rb:47:in Begin of the insertion'update'End of the insertion Begin of the deletion `update'\n","stream":"stdout","time":"2025-01-09T08:22:25.285257063Z"}End of the deletion
```

There&#39;s a 3000+ line debug log attached.

### Begin of the insertionAnalysisEnd of the insertion Begin of the deletion Stack trace for bulk deletionEnd of the deletion

The Begin of the insertionprovided log file shows that there are two identical requests received byEnd of the insertion Begin of the deletion same error (exception) was also observed during bulk deletion.

The error occurs inEnd of the deletion the Begin of the insertionserver to doEnd of the insertion Begin of the deletion [`reschedule_related`](https://github.com/opf/openproject/blob/release/15.5/app/services/work_packages/delete_service.rb#L83-L102) method ofEnd of the deletion the Begin of the insertionbulk edit:

* First one at 2025-01-09T08:22:25.012239

* request\_id: 5ff253ae-d128-4fc8-8031-7b8ce53a61d4

* status 302

* succeeded at 2025-01-09T08:22:25.935842

* Second one at 2025-01-09T08:22:25.017141

* request\_id: f20acbcc-396f-49cf-805f-4f1b559a39a9

* status 500

* fails at 2025-01-09T08:22:25.382549


What happensEnd of the insertion Begin of the deletion `WorkPackages::DeleteService`.
My guessEnd of the deletion is that the Begin of the insertionbulk edit page sentEnd of the insertion Begin of the deletion error occurs inEnd of the deletion the Begin of the insertion2 requests when &quot;Submit&quot; button was clicked, onlyEnd of the insertion Begin of the deletion method [`update_related`](https://github.com/opf/openproject/blob/release/15.5/app/services/work_packages/update_service.rb#L70-L73) inEnd of the deletion the Begin of the insertionlast request is taken into account for the frontend.End of the insertion Begin of the deletion `WorkPackages::UpdateService` as well.End of the deletion

Begin of the insertionThe server receives the 2 requests more or less at the same time. They try concurrently to edit the same data. One will work and returnEnd of the insertion Begin of the deletion In both casesEnd of the deletion a Begin of the insertion302 redirect to theEnd of the insertion Begin of the deletion list of dependentEnd of the deletion work packages Begin of the insertionlist,End of the insertion Begin of the deletion is iterated over and they are saved. This is then whenEnd of the deletion the Begin of the insertionother will fail withEnd of the insertion Begin of the deletion stale objectEnd of the deletion error Begin of the insertion500End of the insertion Begin of the deletion occursEnd of the deletion because Begin of the deletion related (e.g. via automatic scheduling) work packages in that list were updated through an updateEnd of the deletion of Begin of the insertionconcurrent edit.End of the insertion Begin of the deletion earlier work packages.End of the deletion

Begin of the insertionIf the last one sent by the frontendEnd of the insertion Begin of the deletion HereEnd of the deletion is the Begin of the insertionone succeeding, it&#39;s fine. Otherwise it will showEnd of the insertion Begin of the deletion respective stack trace forEnd of the deletion the Begin of the insertion500 error. That&#39;s why the error does not always occur.End of the insertion Begin of the deletion deletion.End of the deletion

Begin of the insertionFrom a first analysis, it seems to happen because of ckeditor intercepting the submit event and then reemitting it, butEnd of the insertion Begin of the deletion ```text
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/locking/optimistic.rb:112:in 'ActiveRecord::Locking::Optimistic#_update_row'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/persistence.rb:1234:in 'ActiveRecord::Persistence#_update_record'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/attribute_methods/dirty.rb:234:in 'ActiveRecord::AttributeMethods::Dirty#_update_record'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/callbacks.rb:449:in 'block (2 levels)End of the deletion in Begin of the insertioncase there are multiple ckeditor (because of &quot;long text&quot; custom fields), the submission is done as many times as the number of ckeditorEnd of the insertion Begin of the deletion ActiveRecord::Callbacks#_update_record'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/timestamp.rb:140:in 'ActiveRecord::Timestamp#record_update_timestamps'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/callbacks.rb:449:in 'blockEnd of the deletion in Begin of the insertionthe form.

For some reason, this error produces a 409 ConflictEnd of the insertion Begin of the deletion ActiveRecord::Callbacks#_update_record'
/app/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.5.1/lib/active_support/callbacks.rb:110:in 'ActiveSupport::Callbacks#run_callbacks'
/app/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.5.1/lib/active_support/callbacks.rb:952:in 'ActiveRecord::Base#_run_update_callbacks'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/callbacks.rb:449:in 'ActiveRecord::Callbacks#_update_record'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/timestamp.rb:122:in 'ActiveRecord::Timestamp#_update_record'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/persistence.rb:1221:in 'ActiveRecord::Persistence#create_or_update'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/callbacks.rb:441:in 'blockEnd of the deletion in Begin of the insertiondevelopment environment instead of a 500 Internal Server Error, and so it does not make a visible error on the frontend, which is why it cannot be visibly reproducedEnd of the insertion Begin of the deletion ActiveRecord::Callbacks#create_or_update'
/app/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.5.1/lib/active_support/callbacks.rb:121:in 'blockEnd of the deletion in Begin of the insertiondevelopment environment.End of the insertion Begin of the deletion ActiveSupport::Callbacks#run_callbacks'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/autosave_association.rb:375:in 'ActiveRecord::AutosaveAssociation#around_save_collection_association'
/app/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.5.1/lib/active_support/callbacks.rb:130:in 'block in ActiveSupport::Callbacks#run_callbacks'
/app/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.5.1/lib/active_support/callbacks.rb:141:in 'ActiveSupport::Callbacks#run_callbacks'
/app/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.5.1/lib/active_support/callbacks.rb:952:in 'ActiveRecord::Base#_run_save_callbacks'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/callbacks.rb:441:in 'ActiveRecord::Callbacks#create_or_update'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/timestamp.rb:127:in 'ActiveRecord::Timestamp#create_or_update'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/persistence.rb:718:in 'ActiveRecord::Persistence#save'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/validations.rb:49:in 'ActiveRecord::Validations#save'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/transactions.rb:309:in 'block in ActiveRecord::Transactions#save'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/transactions.rb:365:in 'block in ActiveRecord::Transactions#with_transaction_returning_status'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:342:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#transaction'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/transactions.rb:361:in 'ActiveRecord::Transactions#with_transaction_returning_status'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/transactions.rb:309:in 'ActiveRecord::Transactions#save'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/suppressor.rb:52:in 'ActiveRecord::Suppressor#save'
/app/app/services/work_packages/delete_service.rb:98:in 'block in WorkPackages::DeleteService#reschedule_related'
/app/app/services/work_packages/delete_service.rb:97:in 'Array#each'
/app/app/services/work_packages/delete_service.rb:97:in 'WorkPackages::DeleteService#reschedule_related'
/app/app/services/work_packages/delete_service.rb:74:in 'WorkPackages::DeleteService#update_ancestors_and_successors'
/app/app/services/work_packages/delete_service.rb:44:in 'WorkPackages::DeleteService#persist'
/app/app/services/base_services/base_contracted.rb:64:in 'block in BaseServices::BaseContracted#perform'
/app/app/models/journal/notification_configuration.rb:40:in 'Journal::NotificationConfiguration.with'
/app/app/services/shared/service_context.rb:67:in 'block in Shared::ServiceContext#without_context_transaction'
/app/lib/open_project/locale_helper.rb:36:in 'OpenProject::LocaleHelper.with_locale_for'
/app/app/models/user.rb:538:in 'User.execute_as'
/app/app/services/shared/service_context.rb:66:in 'Shared::ServiceContext#without_context_transaction'
/app/app/services/shared/service_context.rb:45:in 'block in Shared::ServiceContext#in_mutex_context'
/app/lib/open_project/mutex.rb:71:in 'block in OpenProject::Mutex.with_advisory_lock'
/app/vendor/bundle/ruby/3.4.0/gems/with_advisory_lock-5.1.0/lib/with_advisory_lock/base.rb:102:in 'WithAdvisoryLock::Base#yield_with_lock'
/app/vendor/bundle/ruby/3.4.0/gems/with_advisory_lock-5.1.0/lib/with_advisory_lock/base.rb:89:in 'WithAdvisoryLock::Base#yield_with_lock_and_timeout'
/app/vendor/bundle/ruby/3.4.0/gems/with_advisory_lock-5.1.0/lib/with_advisory_lock/base.rb:72:in 'WithAdvisoryLock::Base#lock_and_yield'
/app/vendor/bundle/ruby/3.4.0/gems/with_advisory_lock-5.1.0/lib/with_advisory_lock/base.rb:63:in 'WithAdvisoryLock::Base#with_advisory_lock_if_needed'
/app/vendor/bundle/ruby/3.4.0/gems/with_advisory_lock-5.1.0/lib/with_advisory_lock/concern.rb:23:in 'WithAdvisoryLock::Concern::ClassMethods#with_advisory_lock_result'
/app/vendor/bundle/ruby/3.4.0/gems/with_advisory_lock-5.1.0/lib/with_advisory_lock/concern.rb:10:in 'WithAdvisoryLock::Concern::ClassMethods#with_advisory_lock'
/app/lib/open_project/mutex.rb:69:in 'OpenProject::Mutex.with_advisory_lock'
/app/lib/open_project/mutex.rb:63:in 'block in OpenProject::Mutex.with_advisory_lock_transaction'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/connection_adapters/abstract/transaction.rb:535:in 'block in ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'
/app/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.5.1/lib/active_support/concurrency/null_lock.rb:9:in 'ActiveSupport::Concurrency::NullLock#synchronize'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/connection_adapters/abstract/transaction.rb:532:in 'ActiveRecord::ConnectionAdapters::TransactionManager#within_new_transaction'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:344:in 'ActiveRecord::ConnectionAdapters::DatabaseStatements#transaction'
/app/vendor/bundle/ruby/3.4.0/gems/activerecord-7.1.5.1/lib/active_record/transactions.rb:212:in 'ActiveRecord::Transactions::ClassMethods#transaction'
/app/lib/open_project/mutex.rb:62:in 'OpenProject::Mutex.with_advisory_lock_transaction'
/app/app/services/shared/service_context.rb:44:in 'Shared::ServiceContext#in_mutex_context'
/app/app/services/shared/service_context.rb:35:in 'Shared::ServiceContext#in_context'
/app/app/services/base_services/base_contracted.rb:54:in 'BaseServices::BaseContracted#service_context'
/app/app/services/base_services/base_contracted.rb:59:in 'BaseServices::BaseContracted#perform'
/app/app/services/base_services/base_callable.rb:40:in 'block in BaseServices::BaseCallable#call'
/app/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.5.1/lib/active_support/callbacks.rb:121:in 'block in ActiveSupport::Callbacks#run_callbacks'
/app/app/services/concerns/with_reversible_state.rb:53:in 'BaseServices::BaseCallable#assign_state'
/app/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.5.1/lib/active_support/callbacks.rb:130:in 'block in ActiveSupport::Callbacks#run_callbacks'
/app/vendor/bundle/ruby/3.4.0/gems/activesupport-7.1.5.1/lib/active_support/callbacks.rb:141:in 'ActiveSupport::Callbacks#run_callbacks'
/app/app/services/base_services/base_callable.rb:39:in 'BaseServices::BaseCallable#call'
```End of the deletion

Begin of the insertionAlso the server needs to use multiple workers and/or threads to be able to reproduce the issue.

End of the insertion ### Screenshots and other files

Begin of the deletion _If you have screenshots of the application&#39;s bug behavior or other relevant files, please drag them into this place or attach them using the &quot;Files&quot; section._

End of the deletion _<img class="image_resized op-uc-image op-uc-image_inline" style="width:1053px;" src="/api/v3/attachments/262070/content">_

### Environment information

Begin of the deletion _Please check and fill out the following details to help us identify in what versions and distributions of OpenProject the error occurs_

End of the deletion **OpenProject installation type**

* Docker-compose installation on Debian 12, docker engine 27.3.1


**OpenProject version**

Begin of the deletion _If you&#39;re not running on the cloud edition, please specify the version of OpenProject you&#39;re running. Example: v12.1.5_

End of the deletion _v15.1_

**Browser**

* [x] Chrome
* [ ] Firefox
* [ ] Safari
* [ ] Mobile Safari
* [ ] Other (please specify)

**Operating System**

* [x] Windows
* [ ] Mac OS X
* [ ] Mobile iOS
* [ ] Mobile Android
* [ ] Linux (please specify distro)
* [ ] Chrome OS
* [ ] Other (please specify)

**Language** Begin of the deletion

_Please specify the browser language and the language of the OpenProject user for which the bug occurred._End of the deletion

_both German_