Vote #69518: Attempted to update a stale object when copying a project - redmineorg-copy202205 - Redmine

編集操作

リンクをコピー

Vote #69518

完了

Attempted to update a stale object when copying a project

Admin Redmine さんが約4年前に追加. 約4年前に更新.

ステータス:

Closed

優先度:

通常

担当者:

カテゴリ:

Projects_11

対象バージョン:

1.4.0_40

開始日:

2011/03/18

期日:

進捗率:

予定工数:

Redmineorg_URL:

https://www.redmine.org/issues/7920

category_id:

version_id:

issue_org_id:

7920

author_id:

23360

assigned_to_id:

comments:

status_id:

tracker_id:

plus1:

affected_version:

closed_on:

affected_version_id:

ステータス-->[Closed]

引用

説明

When I try to copy a project 80 tasks, subtasks and relations, versions, Redmine returns this messsage:

ActiveRecord::StaleObjectError in ProjectsController#copy

Attempted to update a stale object

RAILS_ROOT: /var/www/redmine

Application Trace | Framework Trace | Full Trace
/var/www/redmine/vendor/rails/activerecord/lib/active_record/locking/optimistic.rb:89:in update_without_dirty' /var/www/redmine/vendor/rails/activerecord/lib/active_record/dirty.rb:146:inupdate_without_timestamps'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/timestamp.rb:64:in update_without_callbacks' /var/www/redmine/vendor/rails/activerecord/lib/active_record/callbacks.rb:282:inupdate'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/base.rb:2874:in create_or_update_without_callbacks' /var/www/redmine/vendor/rails/activerecord/lib/active_record/callbacks.rb:250:increate_or_update'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/base.rb:2538:in save_without_validation' /var/www/redmine/vendor/rails/activerecord/lib/active_record/validations.rb:1078:insave_without_dirty'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/dirty.rb:79:in save_without_transactions' /var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:229:insend'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in with_transaction_returning_status' /var/www/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:intransaction'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:182:in transaction' /var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:228:inwith_transaction_returning_status'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in save' /var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:208:inrollback_active_record_state!'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in save' /var/www/redmine/app/models/issue.rb:542:inreschedule_after_without_earlier_date'
/var/www/redmine/app/models/issue_relation.rb:88:in set_issue_to_dates' /var/www/redmine/app/models/issue_relation.rb:82:inbefore_save'
/var/www/redmine/app/models/project.rb:729:in copy_issues' /var/www/redmine/app/models/project.rb:722:incopy_issues'
/var/www/redmine/app/models/project.rb:714:in copy_issues' /var/www/redmine/app/models/project.rb:579:insend'
/var/www/redmine/app/models/project.rb:579:in copy' /var/www/redmine/app/models/project.rb:578:ineach'
/var/www/redmine/app/models/project.rb:578:in copy' /var/www/redmine/app/models/project.rb:575:incopy'
/var/www/redmine/app/controllers/projects_controller.rb:121:in copy' /var/www/redmine/app/models/mailer.rb:337:inwith_deliveries'
/var/www/redmine/app/controllers/projects_controller.rb:117:in `copy'
Request

Parameters:

{"enabled_modules"=>["issue_tracking",
"time_tracking",
"news",
"documents",
"files",
"wiki",
"repository",
"boards",
"calendar",
"gantt",
"budget_module",
"customer_module",
"ezfaq",
"redmine_blocks",
"charts",
"wiki_extensions"],
"commit"=>"Copiar",
"only"=>["members",
"versions",
"issue_categories",
"issues",
"queries",
"boards",
"wiki",
""],
"authenticity_token"=>"NVeCcahXzbXnygJw82iVbZFogwgeNEjkQPpsxWMvF+E=",
"id"=>"prueba2",
"project"=>{"name"=>"prueba4",
"issue_custom_field_ids"=>["48",
"49",
"53",
""],
"custom_field_values"=>{"44"=>"Número de albarán EST",
"45"=>"Número de albarán VAR",
"46"=>"Ubicación",
"47"=>"Dirección de la obra",
"50"=>"Número de albarán SOFT",
"51"=>"Número de albarán HARD",
"41"=>"Delegación",
"42"=>"Número de la obra",
"43"=>"Número de albarán ROB"},
"tracker_ids"=>["2",
"1",
"3",
"5",
"6",
"7",
"8",
"9",
""],
"parent_id"=>"",
"homepage"=>"",
"description"=>"Descripción del proyecto de operaciones",
"is_public"=>"0",
"identifier"=>"prueba4",
"enabled_module_names"=>["issue_tracking",
"time_tracking",
"news",
"documents",
"files",
"wiki",
"repository",
"boards",
"calendar",
"gantt",
"budget_module",
"customer_module",
"ezfaq",
"redmine_blocks",
"charts",
"wiki_extensions",
""]}}
Show session dump

Response

Headers:

{"Content-Type"=>"",
"Cache-Control"=>"no-cache"}

If I use the same database with aptana and with the debugger and I try to copy the same project redmine don't returns any error...

Ithink it

journals

I think its a problems of locks and velocity... with aptana redmine works more slow...

Could that be this?

Thanks
--------------------------------------------------------------------------------
The method that triggers your error (@#reschedule_after_without_earlier_date@) is not defined in Redmine core.
--------------------------------------------------------------------------------
It's true but without this plugin (better_gantt) redmine also fails

ActiveRecord::StaleObjectError in ProjectsController#copy

Attempted to update a stale object
RAILS_ROOT: /var/www/redmine

Application Trace | Framework Trace | Full Trace
/var/www/redmine/vendor/rails/activerecord/lib/active_record/locking/optimistic.rb:89:in `update_without_dirty'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/dirty.rb:146:in `update_without_timestamps'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/timestamp.rb:64:in `update_without_callbacks'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/callbacks.rb:282:in `update'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/base.rb:2874:in `create_or_update_without_callbacks'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/callbacks.rb:250:in `create_or_update'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/base.rb:2538:in `save_without_validation'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/validations.rb:1078:in `save_without_dirty'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/dirty.rb:79:in `save_without_transactions'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `send'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:182:in `transaction'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'
/var/www/redmine/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
/var/www/redmine/app/models/issue.rb:516:in `reschedule_after'
/var/www/redmine/app/models/issue_relation.rb:88:in `set_issue_to_dates'
/var/www/redmine/app/models/issue.rb:824:in `reschedule_following_issues'
/var/www/redmine/app/models/issue.rb:823:in `reschedule_following_issues'
/var/www/redmine/app/models/issue.rb:516:in `reschedule_after'
/var/www/redmine/app/models/issue_relation.rb:88:in `set_issue_to_dates'
/var/www/redmine/app/models/issue.rb:824:in `reschedule_following_issues'
/var/www/redmine/app/models/issue.rb:823:in `reschedule_following_issues'
/var/www/redmine/app/models/issue.rb:516:in `reschedule_after'
/var/www/redmine/app/models/issue_relation.rb:88:in `set_issue_to_dates'
/var/www/redmine/app/models/issue_relation.rb:82:in `before_save'
/var/www/redmine/app/models/project.rb:729:in `copy_issues'
/var/www/redmine/app/models/project.rb:722:in `copy_issues'
/var/www/redmine/app/models/project.rb:714:in `copy_issues'
/var/www/redmine/app/models/project.rb:579:in `send'
/var/www/redmine/app/models/project.rb:579:in `copy'
/var/www/redmine/app/models/project.rb:578:in `each'
/var/www/redmine/app/models/project.rb:578:in `copy'
/var/www/redmine/app/models/project.rb:575:in `copy'
/var/www/redmine/app/controllers/projects_controller.rb:121:in `copy'
/var/www/redmine/app/models/mailer.rb:337:in `with_deliveries'
/var/www/redmine/app/controllers/projects_controller.rb:117:in `copy'
Request

Parameters:

{"enabled_modules"=>["issue_tracking",
"time_tracking",
"news",
"documents",
"files",
"wiki",
"boards",
"calendar",
"gantt",
"budget_module",
"customer_module",
"redmine_blocks",
"charts",
"wiki_extensions",
"work_time"],
"commit"=>"Copiar",
"only"=>["members",
"versions",
"issue_categories",
"issues",
"queries",
"boards",
"wiki",
""],
"authenticity_token"=>"hrXm4psY17wxTVIXaDeEoiuhT+jECVTPvwqQ4DRKzgs=",
"id"=>"opnotocar",
"project"=>{"name"=>"Prueba",
"issue_custom_field_ids"=>["48",
"49",
"53",
""],
"custom_field_values"=>{"44"=>"Número de albarán EST",
"45"=>"Número de albarán VAR",
"46"=>"Ubicación",
"47"=>"Dirección de la obra",
"50"=>"Número de albarán SOFT",
"51"=>"Número de albarán HARD",
"41"=>"Delegación",
"42"=>"Número de la obra",
"43"=>"Número de albarán ROB"},
"tracker_ids"=>["2",
"1",
"3",
"5",
"6",
"7",
"8",
"9",
""],
"parent_id"=>"",
"homepage"=>"",
"description"=>"Descripción del proyecto de operaciones",
"is_public"=>"0",
"identifier"=>"prueba",
"enabled_module_names"=>["issue_tracking",
"time_tracking",
"news",
"documents",
"files",
"wiki",
"boards",
"calendar",
"gantt",
"budget_module",
"customer_module",
"redmine_blocks",
"charts",
"wiki_extensions",
"work_time",
""]}}
Show session dump

Response

Headers:

{"Content-Type"=>"",
"Cache-Control"=>"no-cache"}
--------------------------------------------------------------------------------
So much plugins, did you try with no plugin at all ?
--------------------------------------------------------------------------------
Without plugins and a clean installation, redmine return this

ActiveRecord::StaleObjectError in ProjectsController#copy

Attempted to update a stale object
RAILS_ROOT: /home/lserrano/redmine-dev1

Application Trace | Framework Trace | Full Trace
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/locking/optimistic.rb:89:in `update_without_dirty'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/dirty.rb:146:in `update_without_timestamps'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/timestamp.rb:64:in `update_without_callbacks'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/callbacks.rb:282:in `update'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/base.rb:2874:in `create_or_update_without_callbacks'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/callbacks.rb:250:in `create_or_update'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/base.rb:2538:in `save_without_validation'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/validations.rb:1078:in `save_without_dirty'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/dirty.rb:79:in `save_without_transactions'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `send'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `with_transaction_returning_status'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/transactions.rb:182:in `transaction'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/transactions.rb:228:in `with_transaction_returning_status'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'
/home/lserrano/redmine-dev1/vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
/home/lserrano/redmine-dev1/app/models/issue.rb:500:in `reschedule_after'
/home/lserrano/redmine-dev1/app/models/issue_relation.rb:88:in `set_issue_to_dates'
/home/lserrano/redmine-dev1/app/models/issue.rb:806:in `reschedule_following_issues'
/home/lserrano/redmine-dev1/app/models/issue.rb:805:in `reschedule_following_issues'
/home/lserrano/redmine-dev1/app/models/issue.rb:500:in `reschedule_after'
/home/lserrano/redmine-dev1/app/models/issue_relation.rb:88:in `set_issue_to_dates'
/home/lserrano/redmine-dev1/app/models/issue.rb:806:in `reschedule_following_issues'
/home/lserrano/redmine-dev1/app/models/issue.rb:805:in `reschedule_following_issues'
/home/lserrano/redmine-dev1/app/models/issue.rb:500:in `reschedule_after'
/home/lserrano/redmine-dev1/app/models/issue_relation.rb:88:in `set_issue_to_dates'
/home/lserrano/redmine-dev1/app/models/issue_relation.rb:82:in `before_save'
/home/lserrano/redmine-dev1/app/models/project.rb:729:in `copy_issues'
/home/lserrano/redmine-dev1/app/models/project.rb:722:in `copy_issues'
/home/lserrano/redmine-dev1/app/models/project.rb:714:in `copy_issues'
/home/lserrano/redmine-dev1/app/models/project.rb:579:in `send'
/home/lserrano/redmine-dev1/app/models/project.rb:579:in `copy'
/home/lserrano/redmine-dev1/app/models/project.rb:578:in `each'
/home/lserrano/redmine-dev1/app/models/project.rb:578:in `copy'
/home/lserrano/redmine-dev1/app/models/project.rb:575:in `copy'
/home/lserrano/redmine-dev1/app/controllers/projects_controller.rb:121:in `copy'
/home/lserrano/redmine-dev1/app/models/mailer.rb:337:in `with_deliveries'
/home/lserrano/redmine-dev1/app/controllers/projects_controller.rb:117:in `copy'
Request

Parameters:

{"enabled_modules"=>["issue_tracking",
"time_tracking",
"news",
"documents",
"files",
"wiki",
"boards",
"calendar",
"gantt"],
"commit"=>"Copiar",
"only"=>["members",
"versions",
"issue_categories",
"issues",
"queries",
"boards",
"wiki",
""],
"authenticity_token"=>"xvPtz4xU7a4RKeyfKN1TknbJ4kO/L+9nG0UpsQYg0ls=",
"id"=>"opnotocar",
"project"=>{"name"=>"Prueba",
"issue_custom_field_ids"=>["48",
"49",
"53",
""],
"custom_field_values"=>{"44"=>"Número de albarán EST",
"45"=>"Número de albarán VAR",
"46"=>"Ubicación",
"47"=>"Dirección de la obra",
"50"=>"Número de albarán SOFT",
"51"=>"Número de albarán HARD",
"41"=>"Delegación",
"42"=>"Número de la obra",
"43"=>"Número de albarán ROB"},
"tracker_ids"=>["2",
"1",
"3",
"5",
"6",
"7",
"8",
"9",
""],
"parent_id"=>"",
"homepage"=>"",
"description"=>"Descripción del proyecto de operaciones",
"is_public"=>"0",
"identifier"=>"prueba",
"enabled_module_names"=>["issue_tracking",
"time_tracking",
"news",
"documents",
"files",
"wiki",
"boards",
"calendar",
"gantt",
""]}}
Show session dump

Response

Headers:

{"Content-Type"=>"",
"Cache-Control"=>"no-cache"}
--------------------------------------------------------------------------------
The problem is in the function def reschedule_after(date)
--------------------------------------------------------------------------------
The problem is in the save method...

def reschedule_after(date)
return if date.nil?
if leaf?
if start_date.nil? || start_date < date
self.start_date, self.due_date = date, date + duration
# save
end
else
leaves.each do |leaf|
leaf.reschedule_after(date)
end
end
end
--------------------------------------------------------------------------------
Try replacing @self.due_date = date@ with @self.due_date = date.dup@
--------------------------------------------------------------------------------
I have try it
if start_date.nil? || start_date < date
self.start_date, self.due_date = date.dup, date + duration
save
end

but not fails

Attempted to update a stale object
RAILS_ROOT: /home/lserrano/redmine-dev1

Parameters:

{"enabled_modules"=>["issue_tracking",
"time_tracking",
"news",
"documents",
"files",
"wiki",
"boards",
"calendar",
"gantt"],
"commit"=>"Copiar",
"only"=>["members",
"versions",
"issue_categories",
"issues",
"boards",
"wiki",
""],
"authenticity_token"=>"xvPtz4xU7a4RKeyfKN1TknbJ4kO/L+9nG0UpsQYg0ls=",
"id"=>"opnotocar",
"project"=>{"name"=>"Prueba2",
"issue_custom_field_ids"=>["48",
"49",
"53",
""],
"custom_field_values"=>{"44"=>"Número de albarán EST",
"45"=>"Número de albarán VAR",
"46"=>"Ubicación",
"47"=>"Dirección de la obra",
"50"=>"Número de albarán SOFT",
"51"=>"Número de albarán HARD",
"41"=>"Delegación",
"42"=>"Número de la obra",
"43"=>"Número de albarán ROB"},
"tracker_ids"=>["2",
"1",
"3",
"5",
"6",
"7",
"8",
"9",
""],
"parent_id"=>"",
"homepage"=>"",
"description"=>"Descripción del proyecto de operaciones",
"is_public"=>"0",
"identifier"=>"prueba2",
"enabled_module_names"=>["issue_tracking",
"time_tracking",
"news",
"documents",
"files",
"wiki",
"boards",
"calendar",
"gantt",
""]}}
Show session dump

Response

Headers:

{"Content-Type"=>"",
"Cache-Control"=>"no-cache"}
--------------------------------------------------------------------------------
Make sure you don't have some circular dependencies with issue relations, that is :

issue1 -> issue2 -> issue1
--------------------------------------------------------------------------------
Just hit a very similar issue :

# following scenario of note 10 in #6320, I got : issue 380 parent of 379 and 381
# in the issue list, select all the 3 issues and right-click to delete all the 3

Bang !
<pre>
Processing IssuesController#destroy (for 10.132.21.161 at 2011-04-01 11:32:03) [POST]
Parameters: {"back_url"=>"/projects/psmtxa/issues", "ids"=>["381", "380", "379"], "action"=>"destroy", "authenticity_token"=>"gGV5wcWHWc+93sHWkfbrS79eCHaDFVroRIbO/Rwcl7A=", "controller"=>"issues"}

ActiveRecord::StaleObjectError (Attempted to delete a stale object: Issue):
(eval):4:in `destroy_without_callbacks'
app/controllers/issues_controller.rb:239:in `each'
app/controllers/issues_controller.rb:239:in `destroy'
config/initializers/mongrel.rb:62:in `dispatch_cgi'
</pre>

Actually, only the 381 has been deleted.

--------------------------------------------------------------------------------
In my case, the issue is that you can't destroy a parent issue, period.
--------------------------------------------------------------------------------
Etienne Massip wrote:
> Just hit a very similar issue :
>
> # following scenario of note 10 in #6320, I got : issue 380 parent of 379 and 381
> # in the issue list, select all the 3 issues and right-click to delete all the 3
>
> Bang !

Fixed in r5283.
--------------------------------------------------------------------------------
Actually, not totally fixed.
--------------------------------------------------------------------------------
Finally fixed the error that may occur on deletion in r5285.
--------------------------------------------------------------------------------
Even I have the same error and have made modifications r5283 and r5285
--------------------------------------------------------------------------------
More news...

I need a copy of this project to use as a template, for error left the project start date in the template, if I delete that date (it is not no date) gives me no error when copying....

I deleted the changes (r5283 and r5285) and still works.

Leave patches or delete?

Thanks

--------------------------------------------------------------------------------
I couldn't reproduce but the error on @#reschedule_after@ should be fixed by r8864.
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

操作

リンクをコピー

Admin Redmine さんが約4年前に更新

カテゴリ を Projects_11 にセット
対象バージョン を 1.4.0_40 にセット

編集操作

リンクをコピー

他の形式にエクスポート: Atom PDF

プロジェクト

全般

プロフィール

redmineorg-copy202205

カスタムクエリ

Vote #69518

Attempted to update a stale object when copying a project

Admin Redmine さんが約4年前に更新

編集

unofficial-redmine.org デモサイト¶

Redmine.org上のチケットplus1数を集計し、検索用に公開しています。( 2022/5 Redmine5.0 リリース記念版)¶