Dataprivacy delete job with error PG::StringDataRightTruncation: FEHLER: Wert zu lang für Typ character varying(8000)

bc1000 · June 4, 2021, 8:23am

Infos:

Used Zammad version: 4.0.x
Used Zammad installation type: centos package
Operating system: centos 7.9
Browser + version: Chrome

Expected behavior:

removing a user (agent) via ‘Dataprivacy’ option and change all corresponding tickets to system user.

Actual behavior:

error: ERROR – : PG::StringDataRightTruncation: FEHLER: Wert zu lang für Typ character varying(8000)
: INSERT INTO “data_privacy_tasks” (“deletable_type”, “deletable_id”, “preferences”, “updated_by_id”, “created_by_id”, “created_at”, “updated_at”) VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING “id” (ActiveRecord::ValueTooLong)
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql_adapter.rb:611:in async_exec' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql_adapter.rb:611:in block (2 levels) in exec_no_cache’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies/interlock.rb:48:in block in permit_concurrent_loads' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/concurrency/share_lock.rb:187:in yield_shares’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/dependencies/interlock.rb:47:in permit_concurrent_loads' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql_adapter.rb:610:in block in exec_no_cache’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract_adapter.rb:581:in block (2 levels) in log' /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/monitor.rb:235:in mon_synchronize’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract_adapter.rb:580:in block in log' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/notifications/instrumenter.rb:23:in instrument’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract_adapter.rb:571:in log' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql_adapter.rb:609:in exec_no_cache’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in execute_and_clear' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:81:in exec_query’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:130:in exec_insert' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:115:in exec_insert’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/composite_primary_keys-11.2.0/lib/composite_primary_keys/connection_adapters/abstract/database_statements.rb:6:in insert' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/query_cache.rb:21:in insert’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/persistence.rb:187:in _insert_record' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/composite_primary_keys-11.2.0/lib/composite_primary_keys/persistence.rb:64:in _create_record’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/counter_cache.rb:184:in _create_record' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/locking/optimistic.rb:70:in _create_record’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/attribute_methods/dirty.rb:140:in _create_record' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/callbacks.rb:346:in block in _create_record’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/callbacks.rb:132:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/callbacks.rb:816:in _run_create_callbacks’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/callbacks.rb:346:in _create_record' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/timestamp.rb:102:in _create_record’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/persistence.rb:705:in create_or_update' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/callbacks.rb:342:in block in create_or_update’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/callbacks.rb:132:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.4.6/lib/active_support/callbacks.rb:816:in _run_save_callbacks’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/callbacks.rb:342:in create_or_update' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/persistence.rb:308:in save!’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/validations.rb:52:in save!' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:315:in block in save!’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:387:in block in with_transaction_returning_status' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in block in transaction’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/transaction.rb:239:in block in within_new_transaction' /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/monitor.rb:235:in mon_synchronize’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/transaction.rb:236:in within_new_transaction' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in transaction’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:212:in transaction' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:385:in with_transaction_returning_status’
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/transactions.rb:315:in save!' /opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/suppressor.rb:48:in save!’
/opt/zammad/app/controllers/application_controller/renders_models.rb:19:in model_create_render' /opt/zammad/app/controllers/data_privacy_tasks_controller.rb:15:in create’

Steps to reproduce the behavior:

create new dataprivacy - delete job. select User. This user has 0 customer-tickets and 1693 owner-tickets. Start job with keyword “LÖSCHEN”

MrGeneration · June 4, 2021, 8:29am

github.com/zammad/zammad

Can't add (or run) DataPrivacyTask if the to remove user has too many ticket relations

opened 09:48AM - 07 May 21 UTC

closed 02:14PM - 10 May 21 UTC

MrGeneration

bug data privacy prioritised by payment verified

### Infos: * Used Zammad version: 4.0/stable * Installation method (source, package, ..): any * Operating system: any * Database + version: any * Elasticsearch version: any * Browser + version: verified on latest Google Chrome, shouldn't be relevant though * Ticket: #1086977 ### Expected behavior: The number of tickets a user owns no matter if as owner or customer is not relevant for the removal process. ### Actual behavior: As Zammad saves a list of ticket numbers into the preferences of the removal task, the number of tickets can get too big for the ticket. This will cause either a removal failure or the user not being able to add the removal job. **Screencast:** ![bug-too-many-tickets-too-big-for-preferences](https://user-images.githubusercontent.com/6549061/117431873-05756900-af2a-11eb-8b74-1a608369ee43.gif) **Traceback:** ``` I, [2021-05-06T16:20:34.975428 #18841-91661620] INFO -- : Started POST "/api/v1/data_privacy_tasks" for 666.666.666.666 at 2021-05-06 16:20:34 +0200 I, [2021-05-06T16:20:34.978319 #18841-91661620] INFO -- : Processing by DataPrivacyTasksController#create as JSON I, [2021-05-06T16:20:34.978354 #18841-91661620] INFO -- : Parameters: {"deletable_id"=>"381", "deletable_type"=>"User", "preferences"=>{"sure"=>"EFFACER"}, "id"=>"c-2"} E, [2021-05-06T16:20:35.050221 #18841-91661620] ERROR -- : PG::StringDataRightTruncation: ERROR: value too long for type character varying(8000) : INSERT INTO "data_privacy_tasks" ("deletable_type", "deletable_id", "preferences", "updated_by_id", "created_by_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" (ActiveRecord::ValueTooLong) /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql_adapter.rb:611:in `async_exec' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql_adapter.rb:611:in `block (2 levels) in exec_no_cache' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql_adapter.rb:610:in `block in exec_no_cache' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log' /usr/local/rvm/rubies/ruby-2.6.6/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/notifications/instrumenter.rb:23:in `instrument' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql_adapter.rb:609:in `exec_no_cache' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `execute_and_clear' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:81:in `exec_query' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:130:in `exec_insert' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:115:in `exec_insert' /usr/local/rvm/gems/ruby-2.6.6/gems/composite_primary_keys-11.2.0/lib/composite_primary_keys/connection_adapters/abstract/database_statements.rb:6:in `insert' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/query_cache.rb:21:in `insert' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/persistence.rb:187:in `_insert_record' /usr/local/rvm/gems/ruby-2.6.6/gems/composite_primary_keys-11.2.0/lib/composite_primary_keys/persistence.rb:64:in `_create_record' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/counter_cache.rb:184:in `_create_record' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/locking/optimistic.rb:70:in `_create_record' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/attribute_methods/dirty.rb:140:in `_create_record' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/callbacks.rb:346:in `block in _create_record' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:132:in `run_callbacks' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:816:in `_run_create_callbacks' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/callbacks.rb:346:in `_create_record' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/timestamp.rb:102:in `_create_record' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/persistence.rb:705:in `create_or_update' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/callbacks.rb:342:in `block in create_or_update' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:132:in `run_callbacks' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:816:in `_run_save_callbacks' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/callbacks.rb:342:in `create_or_update' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/persistence.rb:308:in `save!' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/validations.rb:52:in `save!' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:315:in `block in save!' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:387:in `block in with_transaction_returning_status' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `block in transaction' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction' /usr/local/rvm/rubies/ruby-2.6.6/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `transaction' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:212:in `transaction' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:385:in `with_transaction_returning_status' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/transactions.rb:315:in `save!' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/suppressor.rb:48:in `save!' /opt/zammad/app/controllers/application_controller/renders_models.rb:19:in `model_create_render' /opt/zammad/app/controllers/data_privacy_tasks_controller.rb:15:in `create' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/abstract_controller/base.rb:194:in `process_action' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_controller/metal/rendering.rb:30:in `process_action' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/abstract_controller/callbacks.rb:42:in `block in process_action' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:109:in `block in run_callbacks' /opt/zammad/app/controllers/application_controller/has_secure_content_security_policy_for_downloads.rb:18:in `block (4 levels) in <module:HasSecureContentSecurityPolicyForDownloads>' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/notifications.rb:180:in `subscribed' /opt/zammad/app/controllers/application_controller/has_secure_content_security_policy_for_downloads.rb:17:in `block (3 levels) in <module:HasSecureContentSecurityPolicyForDownloads>' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/notifications.rb:180:in `subscribed' /opt/zammad/app/controllers/application_controller/has_secure_content_security_policy_for_downloads.rb:16:in `block (2 levels) in <module:HasSecureContentSecurityPolicyForDownloads>' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:118:in `instance_exec' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:118:in `block in run_callbacks' /opt/zammad/app/controllers/application_controller/handles_transitions.rb:14:in `handle_transaction' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:118:in `block in run_callbacks' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:136:in `run_callbacks' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/abstract_controller/callbacks.rb:41:in `process_action' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_controller/metal/rescue.rb:22:in `process_action' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_controller/metal/instrumentation.rb:34:in `block in process_action' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/notifications.rb:168:in `block in instrument' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/notifications/instrumenter.rb:23:in `instrument' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/notifications.rb:168:in `instrument' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_controller/metal/instrumentation.rb:32:in `process_action' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_controller/metal/params_wrapper.rb:256:in `process_action' /usr/local/rvm/gems/ruby-2.6.6/gems/activerecord-5.2.4.5/lib/active_record/railties/controller_runtime.rb:24:in `process_action' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/abstract_controller/base.rb:134:in `process' /usr/local/rvm/gems/ruby-2.6.6/gems/actionview-5.2.4.5/lib/action_view/rendering.rb:32:in `process' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_controller/metal.rb:191:in `dispatch' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_controller/metal.rb:252:in `dispatch' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/routing/route_set.rb:52:in `dispatch' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/routing/route_set.rb:34:in `serve' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/journey/router.rb:52:in `block in serve' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/journey/router.rb:35:in `each' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/journey/router.rb:35:in `serve' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/routing/route_set.rb:840:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:420:in `call_app!' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-saml-1.10.1/lib/omniauth/strategies/saml.rb:89:in `other_phase' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:190:in `call!' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in `call!' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in `call!' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in `call!' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in `call!' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in `call!' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in `call!' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in `call!' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:192:in `call!' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/strategy.rb:169:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/omniauth-1.9.1/lib/omniauth/builder.rb:45:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/rack-2.2.3/lib/rack/tempfile_reaper.rb:15:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/rack-2.2.3/lib/rack/etag.rb:27:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/rack-2.2.3/lib/rack/conditional_get.rb:40:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/rack-2.2.3/lib/rack/head.rb:12:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/http/content_security_policy.rb:18:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:266:in `context' /usr/local/rvm/gems/ruby-2.6.6/gems/rack-2.2.3/lib/rack/session/abstract/id.rb:260:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/middleware/cookies.rb:670:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/middleware/callbacks.rb:28:in `block in call' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/callbacks.rb:98:in `run_callbacks' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/middleware/callbacks.rb:26:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/middleware/debug_exceptions.rb:61:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/middleware/show_exceptions.rb:33:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/railties-5.2.4.5/lib/rails/rack/logger.rb:38:in `call_app' /usr/local/rvm/gems/ruby-2.6.6/gems/railties-5.2.4.5/lib/rails/rack/logger.rb:26:in `block in call' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/tagged_logging.rb:71:in `block in tagged' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/tagged_logging.rb:28:in `tagged' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/tagged_logging.rb:71:in `tagged' /usr/local/rvm/gems/ruby-2.6.6/gems/railties-5.2.4.5/lib/rails/rack/logger.rb:26:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/middleware/remote_ip.rb:81:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/middleware/request_id.rb:27:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/rack-2.2.3/lib/rack/method_override.rb:24:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/rack-2.2.3/lib/rack/runtime.rb:22:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/activesupport-5.2.4.5/lib/active_support/cache/strategy/local_cache_middleware.rb:29:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/middleware/executor.rb:14:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/actionpack-5.2.4.5/lib/action_dispatch/middleware/static.rb:127:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/rack-2.2.3/lib/rack/sendfile.rb:110:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/railties-5.2.4.5/lib/rails/engine.rb:524:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/railties-5.2.4.5/lib/rails/railtie.rb:190:in `public_send' /usr/local/rvm/gems/ruby-2.6.6/gems/railties-5.2.4.5/lib/rails/railtie.rb:190:in `method_missing' /usr/local/rvm/gems/ruby-2.6.6/gems/puma-3.12.6/lib/puma/configuration.rb:227:in `call' /usr/local/rvm/gems/ruby-2.6.6/gems/puma-3.12.6/lib/puma/server.rb:706:in `handle_request' /usr/local/rvm/gems/ruby-2.6.6/gems/puma-3.12.6/lib/puma/server.rb:476:in `process_client' /usr/local/rvm/gems/ruby-2.6.6/gems/puma-3.12.6/lib/puma/server.rb:334:in `block in run' /usr/local/rvm/gems/ruby-2.6.6/gems/puma-3.12.6/lib/puma/thread_pool.rb:135:in `block in spawn_thread' /usr/local/rvm/gems/ruby-2.6.6/gems/logging-2.2.2/lib/logging/diagnostic_context.rb:474:in `block in create_with_logging_context' I, [2021-05-06T16:20:35.051853 #18841-91661620] INFO -- : Completed 422 Unprocessable Entity in 73ms (Views: 0.1ms | ActiveRecord: 14.9ms) ``` ### Steps to reproduce the behavior: * create 1500 tickets and assign your favorite agent as owner (creating 1500 tickets for a specific customer should work too) * try to remove said user Yes I'm sure this is a bug and no feature request or a general question.

system · October 2, 2021, 8:30am

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.