Unable to move posts due to 500 error

[Festinger]

Hello,

I am encountering an issue by moving a post to a different topic.

When I check the error log:

ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_posts_on_topic_id_and_post_number" DETAIL: Key (topic_id, post_number)=(22680, 3) alr

And:

rack-mini-profiler (3.0.0) lib/patches/db/pg.rb:72:in `exec_params'

rack-mini-profiler (3.0.0) lib/patches/db/pg.rb:72:in `exec_params'

activerecord (7.0.4.3) lib/active_record/connection_adapters/postgresql_adapter.rb:768:in `block (2 levels) in exec_no_cache'

activesupport (7.0.4.3) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'

activesupport (7.0.4.3) lib/active_support/dependencies/interlock.rb:41:in `permit_concurrent_loads'

activerecord (7.0.4.3) lib/active_record/connection_adapters/postgresql_adapter.rb:767:in `block in exec_no_cache'

activesupport (7.0.4.3) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'

activesupport (7.0.4.3) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'

activesupport (7.0.4.3) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'

activesupport (7.0.4.3) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'

activerecord (7.0.4.3) lib/active_record/connection_adapters/abstract_adapter.rb:765:in `block in log'

activesupport (7.0.4.3) lib/active_support/notifications/instrumenter.rb:24:in `instrument'

activerecord (7.0.4.3) lib/active_record/connection_adapters/abstract_adapter.rb:756:in `log'

activerecord (7.0.4.3) lib/active_record/connection_adapters/postgresql_adapter.rb:766:in `exec_no_cache'

activerecord (7.0.4.3) lib/active_record/connection_adapters/postgresql_adapter.rb:745:in `execute_and_clear'

activerecord (7.0.4.3) lib/active_record/connection_adapters/postgresql/database_statements.rb:71:in `exec_delete'

activerecord (7.0.4.3) lib/active_record/connection_adapters/abstract/database_statements.rb:175:in `update'

activerecord (7.0.4.3) lib/active_record/connection_adapters/abstract/query_cache.rb:22:in `update'

activerecord (7.0.4.3) lib/active_record/persistence.rb:513:in `_update_record'

activerecord (7.0.4.3) lib/active_record/persistence.rb:1058:in `_update_row'

activerecord (7.0.4.3) lib/active_record/locking/optimistic.rb:88:in `_update_row'

activerecord (7.0.4.3) lib/active_record/persistence.rb:1080:in `_update_record'

activerecord (7.0.4.3) lib/active_record/attribute_methods/dirty.rb:216:in `_update_record'

activerecord (7.0.4.3) lib/active_record/callbacks.rb:465:in `block in _update_record'

activesupport (7.0.4.3) lib/active_support/callbacks.rb:107:in `run_callbacks'

activesupport (7.0.4.3) lib/active_support/callbacks.rb:929:in `_run_update_callbacks'

activerecord (7.0.4.3) lib/active_record/callbacks.rb:465:in `_update_record'

activerecord (7.0.4.3) lib/active_record/timestamp.rb:121:in `_update_record'

activerecord (7.0.4.3) lib/active_record/persistence.rb:1067:in `create_or_update'

activerecord (7.0.4.3) lib/active_record/callbacks.rb:457:in `block in create_or_update'

activesupport (7.0.4.3) lib/active_support/callbacks.rb:118:in `block in run_callbacks'

activerecord (7.0.4.3) lib/active_record/autosave_association.rb:370:in `around_save_collection_association'

activesupport (7.0.4.3) lib/active_support/callbacks.rb:127:in `block in run_callbacks'

activesupport (7.0.4.3) lib/active_support/callbacks.rb:138:in `run_callbacks'

activesupport (7.0.4.3) lib/active_support/callbacks.rb:929:in `_run_save_callbacks'

activerecord (7.0.4.3) lib/active_record/callbacks.rb:457:in `create_or_update'

activerecord (7.0.4.3) lib/active_record/timestamp.rb:126:in `create_or_update'

activerecord (7.0.4.3) lib/active_record/persistence.rb:615:in `save'

activerecord (7.0.4.3) lib/active_record/validations.rb:47:in `save'

activerecord (7.0.4.3) lib/active_record/transactions.rb:298:in `block in save'

activerecord (7.0.4.3) lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'

activerecord (7.0.4.3) lib/active_record/connection_adapters/abstract/database_statements.rb:314:in `transaction'

activerecord (7.0.4.3) lib/active_record/transactions.rb:350:in `with_transaction_returning_status'

activerecord (7.0.4.3) lib/active_record/transactions.rb:298:in `save'

activerecord (7.0.4.3) lib/active_record/suppressor.rb:50:in `save'

app/models/post_mover.rb:206:in `move'

app/models/post_mover.rb:137:in `block in move_each_post'

activerecord (7.0.4.3) lib/active_record/relation/delegation.rb:88:in `each'

activerecord (7.0.4.3) lib/active_record/relation/delegation.rb:88:in `each'

app/models/post_mover.rb:135:in `move_each_post'

app/models/post_mover.rb:88:in `move_posts_to'

app/models/post_mover.rb:26:in `block in to_topic'

activerecord (7.0.4.3) lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'

activesupport (7.0.4.3) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'

activesupport (7.0.4.3) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'

activesupport (7.0.4.3) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'

activesupport (7.0.4.3) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'

activerecord (7.0.4.3) lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'

activerecord (7.0.4.3) lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'

activerecord (7.0.4.3) lib/active_record/transactions.rb:209:in `transaction'

app/models/post_mover.rb:26:in `to_topic'

app/models/topic.rb:1239:in `move_posts'

app/controllers/topics_controller.rb:827:in `merge_topic'

actionpack (7.0.4.3) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'

actionpack (7.0.4.3) lib/abstract_controller/base.rb:215:in `process_action'

actionpack (7.0.4.3) lib/action_controller/metal/rendering.rb:53:in `process_action'

actionpack (7.0.4.3) lib/abstract_controller/callbacks.rb:234:in `block in process_action'

activesupport (7.0.4.3) lib/active_support/callbacks.rb:118:in `block in run_callbacks'

app/controllers/application_controller.rb:414:in `block in with_resolved_locale'

i18n (1.12.0) lib/i18n.rb:322:in `with_locale'

app/controllers/application_controller.rb:414:in `with_resolved_locale'

activesupport (7.0.4.3) lib/active_support/callbacks.rb:127:in `block in run_callbacks'

activesupport (7.0.4.3) lib/active_support/callbacks.rb:138:in `run_callbacks'

actionpack (7.0.4.3) lib/abstract_controller/callbacks.rb:233:in `process_action'

actionpack (7.0.4.3) lib/action_controller/metal/rescue.rb:22:in `process_action'

actionpack (7.0.4.3) lib/action_controller/metal/instrumentation.rb:67:in `block in process_action'

activesupport (7.0.4.3) lib/active_support/notifications.rb:206:in `block in instrument'

activesupport (7.0.4.3) lib/active_support/notifications/instrumenter.rb:24:in `instrument'

activesupport (7.0.4.3) lib/active_support/notifications.rb:206:in `instrument'

actionpack (7.0.4.3) lib/action_controller/metal/instrumentation.rb:66:in `process_action'

actionpack (7.0.4.3) lib/action_controller/metal/params_wrapper.rb:259:in `process_action'

activerecord (7.0.4.3) lib/active_record/railties/controller_runtime.rb:27:in `process_action'

actionpack (7.0.4.3) lib/abstract_controller/base.rb:151:in `process'

actionview (7.0.4.3) lib/action_view/rendering.rb:39:in `process'

rack-mini-profiler (3.0.0) lib/mini_profiler/profiling_methods.rb:111:in `block in profile_method'

actionpack (7.0.4.3) lib/action_controller/metal.rb:188:in `dispatch'

actionpack (7.0.4.3) lib/action_controller/metal.rb:251:in `dispatch'

actionpack (7.0.4.3) lib/action_dispatch/routing/route_set.rb:49:in `dispatch'

actionpack (7.0.4.3) lib/action_dispatch/routing/route_set.rb:32:in `serve'

actionpack (7.0.4.3) lib/action_dispatch/journey/router.rb:50:in `block in serve'

actionpack (7.0.4.3) lib/action_dispatch/journey/router.rb:32:in `each'

actionpack (7.0.4.3) lib/action_dispatch/journey/router.rb:32:in `serve'

actionpack (7.0.4.3) lib/action_dispatch/routing/route_set.rb:852:in `call'

lib/middleware/omniauth_bypass_middleware.rb:74:in `call'

rack (2.2.6.4) lib/rack/tempfile_reaper.rb:15:in `call'

rack (2.2.6.4) lib/rack/conditional_get.rb:40:in `call'

rack (2.2.6.4) lib/rack/head.rb:12:in `call'

actionpack (7.0.4.3) lib/action_dispatch/http/permissions_policy.rb:38:in `call'

lib/content_security_policy/middleware.rb:12:in `call'

lib/middleware/anonymous_cache.rb:369:in `call'

rack (2.2.6.4) lib/rack/session/abstract/id.rb:266:in `context'

rack (2.2.6.4) lib/rack/session/abstract/id.rb:260:in `call'

actionpack (7.0.4.3) lib/action_dispatch/middleware/

Can somebody suggest me how to fix this error, please?

Thanks in advance!

[Canapin (Coin-coin le Canapin)]

I found a similar issue that was fixed 5 years ago:

Moving a post fails in unknown circumstances

I’ve noticed the same problem with imported posts. They do not always conform to requirements like min_post_length. Moving posts triggered those validations and silently prevented the posts from being moved to the target topic. It should be fixed. https://github.com/discourse/discourse/commit/0ecdf900230eee21beaf54b80428bd18768127ae

Is your forum imported?

[Festinger]

@Canapin

I found a similar issue that was fixed 5 years ago:

Thanks for your comment @Canapin.

I just checked the topic and I didn’t find a solution for my problem.

@Canapin

Is your forum imported?

Nope, it was a fresh install. None of the content is imported.

[eisammy (Sammy)]

Same here current version

[Moin]

@eisammy

Same here current version

By ‘same’, do you mean a 500 error or a 500 error and the same error in /logs?

[eisammy (Sammy)]

I can’t move older topics even new topics returning this error at console.

[Moin]

Did you look at the error logs on your forum? Can you share the detailed error?

[eisammy (Sammy)]

Failed to process hijacked response correctly : ActiveRecord::StatementInvalid : PG::DatetimeFieldOverflow: ERROR: timestamp out of range: "2739932-10-20 22:37:03.335108" LINE 1: ...uration_minutes",

[eisammy (Sammy)]

A timestamp error, maybe an old problem

Failed to process hijacked response correctly : Couldn't find Topic with 'id'=569

perfect, works great now, everything got deleted and then I could also delete the user. Thanks a lot for the fix.

[eisammy (Sammy)]

Ok I get it my problem is: /admin/site_settings/category/all_results?filter=delete%20merged I defined 999999999 I set 7 days and voilá solved.

Man I’m so dumb

[tobiaseigen]

I have unlisted and set a timer to delete this topic, because it is confusing and the original issue from 2023 was never resolved, and has nothing to do with the issue @eisammy is posting about more recently.

@eisammy

Same here current version

@eisammy in future please start new topics to discuss new issues, and provide enough information in your topics about the issue you are encountering so that your fellow community members here can help you.