ES searchindex:rebuild fails after update to 4.x

After upgrading to Zammad 4.1 from 3.*, which happened by accident via apt upgrade using Ansible (so no backup), I cannot rebuild the ES index.

I have tried already to:

  • install ingest-attachment
  • add the suggested configuration to /etc/elasticsearch/elasticsearch.yml
  • restart elastic service
  • run zammad run rake searchindex:rebuild

As a result, the user’s list is not populated on my Zammad instance.

Any suggestions?

Infos:

  • Used Zammad version: 4.1
  • Used Zammad installation type: package
  • Operating system: Debian 9

Expected behavior:

  • Index should finish.

Actual behavior:

  • Instead a get an error:
$ zammad run rake searchindex:rebuild
drop indexes...done
delete pipeline (pipeline)... done
create indexes...done
create pipeline (pipeline)... done
reload data...
 reload Group
  - started at 2021-06-22 11:16:47 UTC
	4/4
  - took 0 seconds
 reload Chat::Session
  - started at 2021-06-22 11:16:47 UTC

rake aborted!
SystemStackError: stack level too deep
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/coders/yaml_column.rb:26:in `load'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/store.rb:196:in `load'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/type/serialized.rb:22:in `deserialize'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activemodel-5.2.4.6/lib/active_model/attribute.rb:165:in `type_cast'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activemodel-5.2.4.6/lib/active_model/attribute.rb:42:in `value'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activemodel-5.2.4.6/lib/active_model/attribute_set.rb:28:in `transform_values'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activemodel-5.2.4.6/lib/active_model/attribute_set.rb:28:in `to_hash'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/attribute_methods.rb:327:in `attributes'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:22:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:19:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'

[.... the same repeats too many times and eventually ....]

/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:177:in `search_index_update_backend'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:226:in `block (2 levels) in search_index_reload'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:222:in `each'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:222:in `block in search_index_reload'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/batches.rb:136:in `block in find_in_batches'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/batches.rb:238:in `block in in_batches'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/batches.rb:222:in `loop'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/batches.rb:222:in `in_batches'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/batches.rb:135:in `find_in_batches'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:221:in `with_index'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:221:in `search_index_reload'
/opt/zammad/lib/tasks/search_index_es.rake:48:in `block (3 levels) in <main>'
/opt/zammad/lib/tasks/search_index_es.rake:44:in `each'
/opt/zammad/lib/tasks/search_index_es.rake:44:in `block (2 levels) in <main>'
/opt/zammad/lib/tasks/search_index_es.rake:63:in `block (2 levels) in <main>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/exe/rake:27:in `<top (required)>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:74:in `load'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:28:in `run'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:463:in `exec'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:27:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:18:in `start'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/exe/bundle:30:in `block in <top (required)>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/exe/bundle:22:in `<top (required)>'
/opt/zammad/bin/bundle:3:in `load'
/opt/zammad/bin/bundle:3:in `<main>'
Tasks: TOP => searchindex:rebuild
(See full trace by running task with --trace)

Steps to reproduce the behavior:

  • Not sure how to reproduce :slight_smile:

Similar thing going on here. Don’t know whether there were any updates in before, all I know, updating to the latest available version via apt did not fix it.

** Invoke searchindex:rebuild (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke searchindex:configured (first_time)
** Invoke environment 
** Execute searchindex:configured
** Invoke searchindex:version_supported (first_time)
** Invoke environment 
** Execute searchindex:version_supported
** Execute searchindex:rebuild
** Execute searchindex:drop
** Execute searchindex:drop_pipeline
** Execute searchindex:create
** Execute searchindex:create_pipeline
** Execute searchindex:reload
rake aborted!
SystemStackError: stack level too deep
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:822:in `block in inject_join'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:820:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:820:in `each_with_index'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:820:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:820:in `inject'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:820:in `inject_join'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:639:in `visit_Arel_Nodes_And'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/reduce.rb:15:in `visit'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:601:in `visit_Arel_Nodes_On'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/reduce.rb:15:in `visit'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:593:in `visit_Arel_Nodes_InnerJoin'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/reduce.rb:15:in `visit'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:824:in `block in inject_join'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:820:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:820:in `each_with_index'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:820:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:820:in `inject'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:820:in `inject_join'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:550:in `visit_Arel_Nodes_JoinSource'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/reduce.rb:15:in `visit'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:251:in `visit_Arel_Nodes_SelectCore'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:217:in `block in visit_Arel_Nodes_SelectStatement'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:216:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:216:in `inject'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/to_sql.rb:216:in `visit_Arel_Nodes_SelectStatement'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/reduce.rb:15:in `visit'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/arel-9.0.0/lib/arel/visitors/reduce.rb:8:in `accept'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/determine_if_preparable_visitor.rb:10:in `accept'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:25:in `to_sql_and_binds'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/database_statements.rb:61:in `select_all'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/connection_adapters/abstract/query_cache.rb:106:in `select_all'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/calculations.rb:197:in `block in pluck'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation.rb:584:in `skip_query_cache_if_necessary'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/calculations.rb:197:in `pluck'
/opt/zammad/app/models/tag.rb:153:in `tag_list'
/opt/zammad/app/models/concerns/has_tags.rb:55:in `tag_list'
/opt/zammad/app/models/chat/session/search_index.rb:22:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'

[…]

/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:81:in `search_index_value_by_attribute'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:48:in `block in search_index_attribute_lookup'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `each'
/opt/zammad/app/models/application_model/can_lookup_search_index_attributes.rb:23:in `search_index_attribute_lookup'
/opt/zammad/app/models/chat/session/search_index.rb:29:in `block in search_index_attribute_lookup'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/delegation.rb:71:in `each'
/opt/zammad/app/models/chat/session/search_index.rb:26:in `search_index_attribute_lookup'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:177:in `search_index_update_backend'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:226:in `block (2 levels) in search_index_reload'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:222:in `each'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:222:in `block in search_index_reload'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/batches.rb:136:in `block in find_in_batches'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/batches.rb:238:in `block in in_batches'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/batches.rb:222:in `loop'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/batches.rb:222:in `in_batches'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.4.6/lib/active_record/relation/batches.rb:135:in `find_in_batches'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:221:in `with_index'
/opt/zammad/app/models/concerns/has_search_index_backend.rb:221:in `search_index_reload'
/opt/zammad/lib/tasks/search_index_es.rake:48:in `block (3 levels) in <main>'
/opt/zammad/lib/tasks/search_index_es.rake:44:in `each'
/opt/zammad/lib/tasks/search_index_es.rake:44:in `block (2 levels) in <main>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/task.rb:273:in `block in execute'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/task.rb:273:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/task.rb:273:in `execute'
/opt/zammad/lib/tasks/search_index_es.rake:63:in `block (2 levels) in <main>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/task.rb:273:in `block in execute'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/task.rb:273:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/task.rb:273:in `execute'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/task.rb:214:in `block in invoke_with_call_chain'
/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/rake-12.3.3/lib/rake/task.rb:194:in `invoke_with_call_chain'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/task.rb:183:in `invoke'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/application.rb:160:in `invoke_task'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/application.rb:116:in `each'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/application.rb:116:in `block in top_level'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/application.rb:125:in `run_with_threads'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/application.rb:110:in `top_level'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/application.rb:83:in `block in run'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/application.rb:186:in `standard_exception_handling'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/lib/rake/application.rb:80:in `run'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/rake-12.3.3/exe/rake:27:in `<top (required)>'
/opt/zammad/vendor/bundle/ruby/2.6.0/bin/rake:23:in `load'
/opt/zammad/vendor/bundle/ruby/2.6.0/bin/rake:23:in `<top (required)>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:74:in `load'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:74:in `kernel_load'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli/exec.rb:28:in `run'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:463:in `exec'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:27:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/cli.rb:18:in `start'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/exe/bundle:30:in `block in <top (required)>'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/exe/bundle:22:in `<top (required)>'
/opt/zammad/bin/bundle:3:in `load'
/opt/zammad/bin/bundle:3:in `<main>'
Tasks: TOP => searchindex:rebuild

OS: Debian 10 (4.19.0-17-amd64 #1 SMP Debian 4.19.194-1 (2021-06-10) x86_64)
ES: elasticsearch/stable,now 7.13.2 amd64 (from https://artifacts.elastic.co/packages/7.x/apt)

Steps to reproduce the behavior:

  1. SSH into our vServer
  2. zammad run rake searchindex:rebuild

You may have been affected by this bug:

Update to the latest available stable Zammad version to fix it and try again.

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