Error message after logging in

Infos:

  • Used Zammad version:
  • Used Zammad installation source: (source, package, …) rpm
  • Operating system: centos 7
  • Browser + version: chrome Version 74.0.3729.157

Actual behavior:

Since yesterday, everytime a user logs into zammad, the following error message pops up. After closing it, you can work with zammad as expected, only the view “Wartung” in the settings is now empty :frowning:
I don´t know exactly what went wrong, the only thing i did was a new ldap sync and afterwards restarting the server.


{“error”:""\xD6" from ASCII-8BIT to UTF-8"}

is the error message

Somehow the rest of my text got missing:

… I restarted all services and the server, but no changes. Does anyone has an idea how to fix this?

Thank you :slight_smile:

Sounds like a Ruby exception, but the complete error message didn’t really make it into the JSON reply. It’s most probably some kind of encoding error; I assume that it tries to read a string that it expects to be UTF-8, but the string isn’t encoded as UTF-8 or at least contains some 8-bit sequences that aren’t valid UTF-8.

Have a look into the Rails server log, the complete exception should be logged there. That should hopefully help to isolate where the problem is occurring exactly, and then we should be able to figure out where that improperly encoded string is (most probably somewhere in the DB).

1 Like

I finally managed to get the log files:

I, [2019-05-27T12:56:12.467399 #8813-47337029261120] INFO – : Performed SearchIndexJob (Job ID: 2626920d-3d3e-4889-be7f-ca79185634f9) from DelayedJob(default) in 75.73ms I, [2019-05-27T12:56:12.477916 #8912-47318848280840] INFO – : Completed 200 OK in 79ms (Views: 0.5ms | ActiveRecord: 37.9ms) I, [2019-05-27T12:56:12.484467 #8813-47337029261120] INFO – : 2019-05-27T12:56:12+0200: [Worker(host:slgmvzn-zammad01 pid:8813)] Job ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper (id=1504709) (queue=default) COMPLETED after 0.1432 I, [2019-05-27T12:56:12.488726 #8925-70220065860920] INFO – : Started PUT “/api/v1/taskbar/8355” for 127.0.0.1 at 2019-05-27 12:56:12 +0200 I, [2019-05-27T12:56:12.499944 #8813-47337029261120] INFO – : 2019-05-27T12:56:12+0200: [Worker(host:slgmvzn-zammad01 pid:8813)] Job ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper (id=1504710) (queue=default) RUNNING I, [2019-05-27T12:56:12.508310 #8925-70220065860920] INFO – : Processing by TaskbarController#update as JSON I, [2019-05-27T12:56:12.508472 #8925-70220065860920] INFO – : Parameters: {“key”=>“Ticket-1017”, “client_id”=>“123”, “callback”=>“TicketZoom”, “state”=>{“ticket”=>{}, “article”=>{“form_id”=>“614037033”}}, “params”=>{“ticket_id”=>“1017”, “init”=>true}, “prio”=>53, “notify”=>false, “active”=>false, “attachments”=>[], “updated_at”=>“2019-05-23T15:24:10.664Z”, “id”=>“8355”} I, [2019-05-27T12:56:12.562095 #8813-47337029261120] INFO – : Performing SearchIndexJob (Job ID: 6a22aec3-33c7-4828-89b0-77f9d5f435a5) from DelayedJob(default) with arguments: “User”, 84 I, [2019-05-27T12:56:12.569183 #8925-70220065860920] INFO – : Completed 200 OK in 61ms (Views: 0.6ms | ActiveRecord: 29.2ms) I, [2019-05-27T12:56:12.581519 #8912-47318885076040] INFO – : Started PUT “/api/v1/taskbar/8350” for 127.0.0.1 at 2019-05-27 12:56:12 +0200 I, [2019-05-27T12:56:12.584251 #8813-47337029261120] INFO – : # curl -X POST “http://127.0.0.1:9200/zammad_production/User/84?pipeline=zammad486624305990” \ I, [2019-05-27T12:56:12.598813 #8912-47318885076040] INFO – : Processing by TaskbarController#update as JSON I, [2019-05-27T12:56:12.598945 #8912-47318885076040] INFO – : Parameters: {“key”=>“Ticket-1016”, “client_id”=>“123”, “callback”=>“TicketZoom”, “state”=>{“ticket”=>{}, “article”=>{“form_id”=>“613279401”}}, “params”=>{“ticket_id”=>“1016”, “init”=>true}, “prio”=>52, “notify”=>false, “active”=>false, “attachments”=>[], “updated_at”=>“2019-05-23T15:24:12.660Z”, “id”=>“8350”} I, [2019-05-27T12:56:12.752285 #8912-47318885076040] INFO – : Completed 200 OK in 153ms (Views: 0.5ms | ActiveRecord: 121.5ms) I, [2019-05-27T12:56:12.802368 #8813-47337029261120] INFO – : # 200 I, [2019-05-27T12:56:12.803184 #8813-47337029261120] INFO – : Performed SearchIndexJob (Job ID: 6a22aec3-33c7-4828-89b0-77f9d5f435a5) from DelayedJob(default) in 240.93ms E, [2019-05-27T12:56:12.803106 #8908-47318885077140] ERROR – : “\xD6” from ASCII-8BIT to UTF-8 (Encoding::UndefinedConversionError) /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/object/json.rb:36:in encode' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/object/json.rb:36:into_json’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/object/json.rb:36:in to_json' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/json/encoding.rb:55:into_json’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/json-2.1.0/lib/json/common.rb:224:in generate' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/json-2.1.0/lib/json/common.rb:224:ingenerate’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/json/encoding.rb:100:in stringify' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/json/encoding.rb:33:inencode’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/json/encoding.rb:20:in encode' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/object/json.rb:39:into_json’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/renderers.rb:156:in block in <module:Renderers>' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/renderers.rb:149:inblock in _render_to_body_with_renderer’ /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/set.rb:324:in each_key' /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/set.rb:324:ineach’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/renderers.rb:145:in _render_to_body_with_renderer' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/renderers.rb:141:inrender_to_body’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/abstract_controller/rendering.rb:24:in render' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/rendering.rb:36:inrender’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:44:in block (2 levels) in render' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/benchmark.rb:12:inblock in ms’ /opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/benchmark.rb:308:in realtime' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/benchmark.rb:12:inms’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:44:in block in render' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:87:incleanup_view_runtime’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.2/lib/active_record/railties/controller_runtime.rb:29:in cleanup_view_runtime' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:43:inrender’ /opt/zammad/app/controllers/settings_controller.rb:14:in index' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/basic_implicit_render.rb:4:insend_action’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/abstract_controller/base.rb:186:in process_action' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/rendering.rb:30:inprocess_action’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/abstract_controller/callbacks.rb:20:in block in process_action' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/callbacks.rb:131:inrun_callbacks’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/abstract_controller/callbacks.rb:19:in process_action' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/rescue.rb:20:inprocess_action’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:32:in block in process_action' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/notifications.rb:166:inblock in instrument’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/notifications/instrumenter.rb:21:in instrument' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/notifications.rb:166:ininstrument’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:30:in process_action' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/params_wrapper.rb:252:inprocess_action’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.2/lib/active_record/railties/controller_runtime.rb:22:in process_action' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/abstract_controller/base.rb:124:inprocess’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionview-5.1.6.2/lib/action_view/rendering.rb:30:in process' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal.rb:189:indispatch’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal.rb:253:in dispatch' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/routing/route_set.rb:49:indispatch’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/routing/route_set.rb:31:in serve' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/journey/router.rb:50:inblock in serve’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/journey/router.rb:33:in each' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/journey/router.rb:33:inserve’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/routing/route_set.rb:844:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:incall!’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:incall!’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:incall!’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:incall!’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:incall!’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:incall!’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:incall!’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:incall!’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:incall!’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/builder.rb:64:incall’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/etag.rb:25:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/conditional_get.rb:25:incall’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/head.rb:12:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/session/abstract/id.rb:232:incontext’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/session/abstract/id.rb:226:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/cookies.rb:613:incall’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/callbacks.rb:26:in block in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/callbacks.rb:97:inrun_callbacks’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/callbacks.rb:24:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/debug_exceptions.rb:59:incall’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/show_exceptions.rb:31:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.2/lib/rails/rack/logger.rb:36:incall_app’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.2/lib/rails/rack/logger.rb:24:in block in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/tagged_logging.rb:69:inblock in tagged’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/tagged_logging.rb:26:in tagged' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/tagged_logging.rb:69:intagged’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.2/lib/rails/rack/logger.rb:24:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/remote_ip.rb:79:incall’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/request_id.rb:25:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/method_override.rb:22:incall’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/runtime.rb:22:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/cache/strategy/local_cache_middleware.rb:27:incall’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/executor.rb:12:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/static.rb:125:incall’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/sendfile.rb:111:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.2/lib/rails/engine.rb:522:incall’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/puma-3.11.0/lib/puma/configuration.rb:225:in call' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/puma-3.11.0/lib/puma/server.rb:624:inhandle_request’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/puma-3.11.0/lib/puma/server.rb:438:in process_client' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/puma-3.11.0/lib/puma/server.rb:302:inblock in run’ /opt/zammad/vendor/bundle/ruby/2.4.0/gems/puma-3.11.0/lib/puma/thread_pool.rb:120:in block in spawn_thread' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/logging-2.2.2/lib/logging/diagnostic_context.rb:474:inblock in create_with_logging_context’ I, [2019-05-27T12:56:12.803948 #8908-47318885077140] INFO – : Completed 500 Internal Server Error in 839ms (Views: 0.2ms | ActiveRecord: 23.9ms) I, [2019-05-27T12:56:12.943931 #8925-70220065861400] INFO – : Started PUT “/api/v1/taskbar/8484” for 93.188.31.106 at 2019-05-27 12:56:12 +0200 I, [2019-05-27T12:56:12.961059 #8925-70220065861400] INFO – : Processing by TaskbarController#update as JSON I, [2019-05-27T12:56:12.961208 #8925-70220065861400] INFO – : Parameters: {“key”=>“Ticket-1011”, “client_id”=>“123”, “callback”=>“TicketZoom”, “state”=>{“ticket”=>{}, “article”=>{“body”=>"[FILTERED]", “from”=>“Monika Müller”, “ticket_id”=>“1011”, “content_type”=>“text/html”, “sender_id”=>“1”, “type_id”=>“10”, “form_id”=>“954371388”}}, “params”=>{“ticket_id”=>1011, “overview_id”=>1, “shown”=>true}, “prio”=>2, “notify”=>false, “active”=>true, “attachments”=>[], “updated_at”=>“2019-05-27T10:52:06.795Z”, “id”=>“8484”} I, [2019-05-27T12:56:13.058633 #8925-70220065861400] INFO – : Completed 200 OK in 97ms (Views: 0.6ms | ActiveRecord: 31.9ms) I, [2019-05-27T12:56:13.086602 #8813-47337029261120] INFO – : 2019-05-27T12:56:13+0200: [Worker(host:slgmvzn-zammad01 pid:8813)] Job ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper (id=1504710) (queue=default) COMPLETED after 0.5864 I, [2019-05-27T12:56:13.198182 #8813-47337029261120] INFO – : 2019-05-27T12:56:13+0200: [Worker(host:slgmvzn-zammad01 pid:8813)] Job ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper (id=1504711) (queue=default) RUNNING I, [2019-05-27T12:56:13.232479 #8813-47337029261120] INFO – : Performing SearchIndexJob (Job ID: 3bdb0dc8-c7e8-41d1-a118-1d01acd7931a) from DelayedJob(default) with arguments: “User”, 29 I, [2019-05-27T12:56:13.252661 #8813-47337029261120] INFO – : # curl -X POST “http://127.0.0.1:9200/zammad_production/User/29?pipeline=zammad486624305990” \ I, [2019-05-27T12:56:13.487092 #8813-47337029261120] INFO – : # 200 I, [2019-05-27T12:56:13.487638 #8813-47337029261120] INFO – : Performed SearchIndexJob (Job ID: 3bdb0dc8-c7e8-41d1-a118-1d01acd7931a) from DelayedJob(default) in 254.94ms I, [2019-05-27T12:56:13.507732 #8813-47337029261120] INFO – : 2019-05-27T12:56:13+0200: [Worker(host:slgmvzn-zammad01 pid:8813)] Job ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper (id=1504711) (queue=default) COMPLETED after 0.3094 I, [2019-05-27T12:56:13.542717 #8813-47337029261120] INFO – : 2019-05-27T12:56:13+0200: [Worker(host:slgmvzn-zammad01 pid:8813)] Job ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper (id=1504712) (queue=default) RUNNING I, [2019-05-27T12:56:13.587397 #8813-47337029261120] INFO – : Performing SearchIndexJob (Job ID: 5134e3d5-fe34-4880-8403-ea0d19efec45) from DelayedJob(default) with arguments: “User”, 35 I, [2019-05-27T12:56:13.608360 #8813-47337029261120] INFO – : # curl -X POST “http://127.0.0.1:9200/zammad_production/User/35?pipeline=zammad486624305990” \ I, [2019-05-27T12:56:13.653150 #8813-47337029261120] INFO – : # 200 I, [2019-05-27T12:56:13.653332 #8813-47337029261120] INFO – : Performed SearchIndexJob (Job ID: 5134e3d5-fe34-4880-8403-ea0d19efec45) from DelayedJob(default) in 65.21ms I, [2019-05-27T12:56:13.677450 #8813-47337029261120] INFO – : 2019-05-27T12:56:13+0200: [Worker(host:slgmvzn-zammad01 pid:8813)] Job ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper (id=1504712) (queue=default) COMPLETED after 0.1345 I, [2019-05-27T12:56:13.702599 #8813-47337029261120] INFO – : 2019-05-27T12:56:13+0200: [Worker(host:slgmvzn-zammad01 pid:8813)] Job ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper (id=1504713) (queue=default) RUNNING I, [2019-05-27T12:56:13.737111 #8813-47337029261120] INFO – : Performing SearchIndexJob (Job ID: 8373d35f-07c0-47b3-9839-33b6edbb3e79) from DelayedJob(default) with arguments: “User”, 10 I, [2019-05-27T12:56:13.756261 #8813-47337029261120] INFO – : # curl -X POST “http://127.0.0.1:9200/zammad_production/User/10?pipeline=zammad486624305990” \ I, [2019-05-27T12:56:13.812552 #8912-70220071821240] INFO – : Started PUT “/api/v1/taskbar/8483” for 127.0.0.1 at 2019-05-27 12:56:13 +0200 I, [2019-05-27T12:56:13.817704 #8813-47337029261120] INFO – : # 200

Hmm, that’s a bit hard to read - all the new lines are missing. Could you format the log as code?

I tried to read through it anyway, and I think this line points us into the right direction:

The front-end is requesting the settings. The controller looks like this:

  # GET /settings
  def index
    list = []
    Setting.all.each do |setting|
      next if setting.preferences[:permission] && !current_user.permissions?(setting.preferences[:permission])

      list.push setting
    end
    render json: list, status: :ok
  end

It’s crashing while it’s trying to return the settings as JSON array. This leads me to believe that the malformed string is located in the settings table. Assuming you’re using PostgreSQL as database, the following query should show you all settings that you’ve changed:

\x
select * from settings where state_current != state_initial order by area desc;

Scroll through the results and keep a lookout for settings where an unprintable character shows up, I guess.

I’m not entirely clear though how it’s even possible for this to break - the settings are stored in a TEXT column, and postgres should have enforced valid UTF-8. I’ve tried to insert invalid characters into my settings, and I wasn’t able to break Zammad with that. Maybe something’s wrong with your database so that it failed to enfore valid UTF-8? Or are you using MySQL (at least in that case, I wouldn’t be surprised that it’s broken)?

I, [2019-05-27T12:56:12.467399 #8813-47337029261120]  INFO -- : Performed SearchIndexJob (Job ID: 2626920d-3d3e-4889-be7f-ca79185634f9) from DelayedJob(default) in 75.73msI, [2019-05-27T12:56:12.477916 #8912-47318848280840]  INFO -- : Completed 200 OK in 79ms (Views: 0.5ms | ActiveRecord: 37.9ms)
I, [2019-05-27T12:56:12.484467 #8813-47337029261120]  INFO -- : 2019-05-27T12:56:12+0200: [Worker(host:slgmvzn-zammad01 pid:8813)] Job ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper (id=1504709) (queue=default) COMPLETED after 0.1432
I, [2019-05-27T12:56:12.488726 #8925-70220065860920]  INFO -- : Started PUT "/api/v1/taskbar/8355" for 127.0.0.1 at 2019-05-27 12:56:12 +0200
I, [2019-05-27T12:56:12.499944 #8813-47337029261120]  INFO -- : 2019-05-27T12:56:12+0200: [Worker(host:slgmvzn-zammad01 pid:8813)] Job ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper (id=1504710) (queue=default) RUNNING
I, [2019-05-27T12:56:12.508310 #8925-70220065860920]  INFO -- : Processing by TaskbarController#update as JSON
I, [2019-05-27T12:56:12.508472 #8925-70220065860920]  INFO -- :   Parameters: {"key"=>"Ticket-1017", "client_id"=>"123", "callback"=>"TicketZoom", "state"=>{"ticket"=>{}, "article"=>{"form_id"=>"614037033"}}, "params"=>{"ticket_id"=>"1017", "init"=>true}, "prio"=>53, "notify"=>false, "active"=>false, "attachments"=>[], "updated_at"=>"2019-05-23T15:24:10.664Z", "id"=>"8355"}
I, [2019-05-27T12:56:12.562095 #8813-47337029261120]  INFO -- : Performing SearchIndexJob (Job ID: 6a22aec3-33c7-4828-89b0-77f9d5f435a5) from DelayedJob(default) with arguments: "User", 84
I, [2019-05-27T12:56:12.569183 #8925-70220065860920]  INFO -- : Completed 200 OK in 61ms (Views: 0.6ms | ActiveRecord: 29.2ms)
I, [2019-05-27T12:56:12.581519 #8912-47318885076040]  INFO -- : Started PUT "/api/v1/taskbar/8350" for 127.0.0.1 at 2019-05-27 12:56:12 +0200
I, [2019-05-27T12:56:12.584251 #8813-47337029261120]  INFO -- : # curl -X POST "http://127.0.0.1:9200/zammad_production/User/84?pipeline=zammad486624305990" \
I, [2019-05-27T12:56:12.598813 #8912-47318885076040]  INFO -- : Processing by TaskbarController#update as JSON
I, [2019-05-27T12:56:12.598945 #8912-47318885076040]  INFO -- :   Parameters: {"key"=>"Ticket-1016", "client_id"=>"123", "callback"=>"TicketZoom", "state"=>{"ticket"=>{}, "article"=>{"form_id"=>"613279401"}}, "params"=>{"ticket_id"=>"1016", "init"=>true}, "prio"=>52, "notify"=>false, "active"=>false, "attachments"=>[], "updated_at"=>"2019-05-23T15:24:12.660Z", "id"=>"8350"}
I, [2019-05-27T12:56:12.752285 #8912-47318885076040]  INFO -- : Completed 200 OK in 153ms (Views: 0.5ms | ActiveRecord: 121.5ms)
I, [2019-05-27T12:56:12.802368 #8813-47337029261120]  INFO -- : # 200
I, [2019-05-27T12:56:12.803184 #8813-47337029261120]  INFO -- : Performed SearchIndexJob (Job ID: 6a22aec3-33c7-4828-89b0-77f9d5f435a5) from DelayedJob(default) in 240.93ms
E, [2019-05-27T12:56:12.803106 #8908-47318885077140] ERROR -- : "\xD6" from ASCII-8BIT to UTF-8 (Encoding::UndefinedConversionError)
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/object/json.rb:36:in `encode'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/object/json.rb:36:in `to_json'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/object/json.rb:36:in `to_json'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/json/encoding.rb:55:in `to_json'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/json-2.1.0/lib/json/common.rb:224:in `generate'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/json-2.1.0/lib/json/common.rb:224:in `generate'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/json/encoding.rb:100:in `stringify'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/json/encoding.rb:33:in `encode'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/json/encoding.rb:20:in `encode'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/object/json.rb:39:in `to_json'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/renderers.rb:156:in `block in <module:Renderers>'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/renderers.rb:149:in `block in _render_to_body_with_renderer'
/opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/set.rb:324:in `each_key'
/opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/set.rb:324:in `each'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/renderers.rb:145:in `_render_to_body_with_renderer'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/renderers.rb:141:in `render_to_body'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/abstract_controller/rendering.rb:24:in `render'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/rendering.rb:36:in `render'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:44:in `block (2 levels) in render'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/benchmark.rb:12:in `block in ms'
/opt/zammad/vendor/ruby-2.4.4/lib/ruby/2.4.0/benchmark.rb:308:in `realtime'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/core_ext/benchmark.rb:12:in `ms'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:44:in `block in render'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:87:in `cleanup_view_runtime'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.2/lib/active_record/railties/controller_runtime.rb:29:in `cleanup_view_runtime'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:43:in `render'
/opt/zammad/app/controllers/settings_controller.rb:14:in `index'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/basic_implicit_render.rb:4:in `send_action'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/abstract_controller/base.rb:186:in `process_action'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/rendering.rb:30:in `process_action'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/abstract_controller/callbacks.rb:20:in `block in process_action'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/callbacks.rb:131:in `run_callbacks'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/abstract_controller/callbacks.rb:19:in `process_action'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/rescue.rb:20:in `process_action'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:32:in `block in process_action'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/notifications.rb:166:in `block in instrument'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/notifications.rb:166:in `instrument'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/instrumentation.rb:30:in `process_action'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal/params_wrapper.rb:252:in `process_action'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.6.2/lib/active_record/railties/controller_runtime.rb:22:in `process_action'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/abstract_controller/base.rb:124:in `process'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionview-5.1.6.2/lib/action_view/rendering.rb:30:in `process'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal.rb:189:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_controller/metal.rb:253:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/routing/route_set.rb:49:in `dispatch'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/routing/route_set.rb:31:in `serve'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/journey/router.rb:50:in `block in serve'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/journey/router.rb:33:in `each'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/journey/router.rb:33:in `serve'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/routing/route_set.rb:844:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:in `call!'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:in `call!'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:in `call!'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:in `call!'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:in `call!'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:in `call!'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:in `call!'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:in `call!'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:192:in `call!'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/strategy.rb:169:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/omniauth-1.9.0/lib/omniauth/builder.rb:64:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/etag.rb:25:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/conditional_get.rb:25:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/head.rb:12:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/session/abstract/id.rb:232:in `context'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/session/abstract/id.rb:226:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/cookies.rb:613:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/callbacks.rb:26:in `block in call'
 /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/callbacks.rb:97:in `run_callbacks'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/callbacks.rb:24:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/debug_exceptions.rb:59:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/show_exceptions.rb:31:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.2/lib/rails/rack/logger.rb:36:in `call_app'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.2/lib/rails/rack/logger.rb:24:in `block in call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/tagged_logging.rb:69:in `block in tagged'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/tagged_logging.rb:26:in `tagged'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/tagged_logging.rb:69:in `tagged'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.2/lib/rails/rack/logger.rb:24:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/remote_ip.rb:79:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/request_id.rb:25:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/method_override.rb:22:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/runtime.rb:22:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.6.2/lib/active_support/cache/strategy/local_cache_middleware.rb:27:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/executor.rb:12:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/actionpack-5.1.6.2/lib/action_dispatch/middleware/static.rb:125:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rack-2.0.6/lib/rack/sendfile.rb:111:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/railties-5.1.6.2/lib/rails/engine.rb:522:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/puma-3.11.0/lib/puma/configuration.rb:225:in `call'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/puma-3.11.0/lib/puma/server.rb:624:in `handle_request'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/puma-3.11.0/lib/puma/server.rb:438:in `process_client'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/puma-3.11.0/lib/puma/server.rb:302:in `block in run'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/puma-3.11.0/lib/puma/thread_pool.rb:120:in `block in spawn_thread'
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/logging-2.2.2/lib/logging/diagnostic_context.rb:474:in `block in create_with_logging_context'
I, [2019-05-27T12:56:12.803948 #8908-47318885077140]  INFO -- : Completed 500 Internal Server Error in 839ms (Views: 0.2ms | ActiveRecord: 23.9ms)
I, [2019-05-27T12:56:12.943931 #8925-70220065861400]  INFO -- : Started PUT "/api/v1/taskbar/8484" for 93.188.31.106 at 2019-05-27 12:56:12 +0200
I, [2019-05-27T12:56:12.961059 #8925-70220065861400]  INFO -- : Processing by TaskbarController#update as JSON

Sorry for that, I hope now its better to read.

Yes we are using PostgreSQL.
I will try to run the query.

Yep, thanks!

Hm, interesting. I wonder if the database isn’t set to UTF-8? Try to run \l in the psql shell. For me (Zammad installed via docker-compose) it looks like this:

zammad_production=# \l
                                     Liste der Datenbanken
       Name        | Eigentümer | Kodierung | Sortierfolge | Zeichentyp |  Zugriffsprivilegien
-------------------+------------+-----------+--------------+------------+-----------------------
 postgres          | postgres   | UTF8      | en_US.utf8   | en_US.utf8 |
 template0         | postgres   | UTF8      | en_US.utf8   | en_US.utf8 | =c/postgres          +
                   |            |           |              |            | postgres=CTc/postgres
 template1         | postgres   | UTF8      | en_US.utf8   | en_US.utf8 | =c/postgres          +
                   |            |           |              |            | postgres=CTc/postgres
 zammad_production | postgres   | UTF8      | en_US.utf8   | en_US.utf8 |
(4 Zeilen)

Does it say UTF8 there for you, or is something like C?

In any case, before you fix the issue, export the settings table into an SQL file:

pg_dump -at settings > settings.sql

That might be useful for reproducing and fixing this issue in Zammad’s code. Even better if you remember or find a way to reproduce the issue :slight_smile:

ok, thank you! I will try to find some more informiation tonight and give you feedback by tommorrow.

i was able to have a look into the table, but as far as I can see it says UTF8 like in your example…

Try to update to Zammad 3.0 which might solve some issues.
Ensure to create a new, clean elasticsearch index.

(Just fishing in the dark, your current version is unclear)

Last night I tried to update to version 3.0

I got the following error messages. Do you think it has something to do with the error messages mentionend above?

Exceptions::UnprocessableEntity: Invalid perform notification.email, subject is missing!

Total download size: 109 M
Is this ok [y/d/N]: y
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
zammad-3.0.0-1560433985.617324d6.centos7.x86_64.rpm | 109 MB 01:11
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : zammad-3.0.0-1560433985.617324d6.centos7.x86_64 1/2

(Re)creating init scripts

Nothing to do.
Nothing to do.
Nothing to do.

Enabling Zammad on boot

Stopping Zammad

database.yml found. Updating db…

rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

Invalid perform notification.email, subject is missing!
/opt/zammad/app/models/concerns/checks_perform_validation.rb:24:in block (2 lev els) in validate_perform' /opt/zammad/app/models/concerns/checks_perform_validation.rb:23:ineach’
/opt/zammad/app/models/concerns/checks_perform_validation.rb:23:in block in val idate_perform' /opt/zammad/app/models/concerns/checks_perform_validation.rb:20:ineach’
/opt/zammad/app/models/concerns/checks_perform_validation.rb:20:in validate_per form' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:413:inblock in make_lambda’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:197:in block (2 levels) in halting' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:601:inblock (2 levels) in default_terminator’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:600:in catch' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:600:inblock in default_terminator’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:198:in block in halting' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:507:inblock in invoke_before’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:507:in each' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:507:ininvoke_before’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:130:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:827:inrun_update_callbacks’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c allbacks.rb:348:in _update_record' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t imestamp.rb:114:inupdate_record’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/p ersistence.rb:554:in create_or_update' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c allbacks.rb:340:inblock in create_or_update’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:97:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:827:inrun_save_callbacks’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c allbacks.rb:340:in create_or_update' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/p ersistence.rb:162:insave!’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/v alidations.rb:50:in save!' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/a ttribute_methods/dirty.rb:43:insave!’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:313:in block in save!' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:384:inblock in with_transaction_returning_status’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/database_statements.rb:233:in transaction' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:210:intransaction’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:381:in with_transaction_returning_status' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:313:insave!’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/s uppressor.rb:46:in save!' /opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without_ body.rb:17:inblock (3 levels) in up’
/opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without
body.rb:12:in each' /opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without_ body.rb:12:inblock (2 levels) in up’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/r elation/delegation.rb:39:in each' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/r elation/delegation.rb:39:ineach’
/opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without
body.rb:9:in block in up' /opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without_ body.rb:8:ineach’
/opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without
body.rb:8:in up' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:795:inexec_migration’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:776:in block (2 levels) in migrate' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:775:inblock in migrate’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/connection_pool.rb:410:in with_connection' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:774:inmigrate’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:953:in migrate' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1230:inblock in execute_migration_in_transaction’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1298:in block in ddl_transaction' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/database_statements.rb:235:inblock in transaction’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/transaction.rb:194:in block in within_new_transacti on' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/transaction.rb:191:inwithin_new_transaction’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/database_statements.rb:235:in transaction' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:210:intransaction’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1298:in ddl_transaction' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1229:inexecute_migration_in_transaction’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1201:in block in migrate_without_lock' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1200:ineach’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1200:in migrate_without_lock' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1148:inblock in migrate’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1317:in with_advisory_lock' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1148:inmigrate’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1007:in up' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:985:inmigrate’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t asks/database_tasks.rb:171:in migrate' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/r ailties/databases.rake:58:inblock (2 levels) in <top (required)>’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.2/exe/rake:27:in <top (requ ired)>' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli/exec.rb :74:inload’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli/exec.rb :74:in kernel_load' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli/exec.rb :27:inrun’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli.rb:360: in exec' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/vendor/thor /lib/thor/command.rb:27:inrun’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/vendor/thor /lib/thor/invocation.rb:126:in invoke_command' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/vendor/thor /lib/thor.rb:369:indispatch’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli.rb:20:i n dispatch' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/vendor/thor /lib/thor/base.rb:444:instart’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli.rb:10:i n start' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/exe/bundle:30:inblock in <top (required)>’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/friendly_er rors.rb:121:in with_friendly_errors' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/exe/bundle:22:in<top (required)>’
/opt/zammad/bin/bundle:3:in load' /opt/zammad/bin/bundle:3:in

Caused by:
Exceptions::UnprocessableEntity: Invalid perform notification.email, subject is missing!
/opt/zammad/app/models/concerns/checks_perform_validation.rb:24:in block (2 lev els) in validate_perform' /opt/zammad/app/models/concerns/checks_perform_validation.rb:23:ineach’
/opt/zammad/app/models/concerns/checks_perform_validation.rb:23:in block in val idate_perform' /opt/zammad/app/models/concerns/checks_perform_validation.rb:20:ineach’
/opt/zammad/app/models/concerns/checks_perform_validation.rb:20:in validate_per form' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:413:inblock in make_lambda’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:197:in block (2 levels) in halting' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:601:inblock (2 levels) in default_terminator’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:600:in catch' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:600:inblock in default_terminator’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:198:in block in halting' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:507:inblock in invoke_before’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:507:in each' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:507:ininvoke_before’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:130:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:827:inrun_update_callbacks’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c allbacks.rb:348:in _update_record' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t imestamp.rb:114:inupdate_record’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/p ersistence.rb:554:in create_or_update' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c allbacks.rb:340:inblock in create_or_update’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:97:in run_callbacks' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activesupport-5.1.7/lib/active_support /callbacks.rb:827:inrun_save_callbacks’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c allbacks.rb:340:in create_or_update' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/p ersistence.rb:162:insave!’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/v alidations.rb:50:in save!' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/a ttribute_methods/dirty.rb:43:insave!’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:313:in block in save!' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:384:inblock in with_transaction_returning_status’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/database_statements.rb:233:in transaction' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:210:intransaction’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:381:in with_transaction_returning_status' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:313:insave!’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/s uppressor.rb:46:in save!' /opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without_ body.rb:17:inblock (3 levels) in up’
/opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without
body.rb:12:in each' /opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without_ body.rb:12:inblock (2 levels) in up’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/r elation/delegation.rb:39:in each' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/r elation/delegation.rb:39:ineach’
/opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without
body.rb:9:in block in up' /opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without_ body.rb:8:ineach’
/opt/zammad/db/migrate/20190408000001_issue_2541_fix_notification_email_without
body.rb:8:in `up’

/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:795:in exec_migration' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:776:inblock (2 levels) in migrate’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:775:in block in migrate' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/connection_pool.rb:410:inwith_connection’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:774:in migrate' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:953:inmigrate’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1230:in block in execute_migration_in_transaction' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1298:inblock in ddl_transaction’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/database_statements.rb:235:in block in transaction' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/transaction.rb:194:inblock in within_new_transacti on’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/transaction.rb:191:in within_new_transaction' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/c onnection_adapters/abstract/database_statements.rb:235:intransaction’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t ransactions.rb:210:in transaction' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1298:inddl_transaction’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1229:in execute_migration_in_transaction' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1201:inblock in migrate_without_lock’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1200:in each' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1200:inmigrate_without_lock’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1148:in block in migrate' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1317:inwith_advisory_lock’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1148:in migrate' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:1007:inup’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/m igration.rb:985:in migrate' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/t asks/database_tasks.rb:171:inmigrate’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/activerecord-5.1.7/lib/active_record/r ailties/databases.rake:58:in block (2 levels) in <top (required)>' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/rake-12.3.2/exe/rake:27:in<top (requ ired)>’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli/exec.rb :74:in load' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli/exec.rb :74:inkernel_load’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli/exec.rb :27:in run' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli.rb:360: inexec’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/vendor/thor /lib/thor/command.rb:27:in run' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/vendor/thor /lib/thor/invocation.rb:126:ininvoke_command’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/vendor/thor /lib/thor.rb:369:in dispatch' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli.rb:20:i ndispatch’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/vendor/thor /lib/thor/base.rb:444:in start' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/cli.rb:10:i nstart’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/exe/bundle:30:in block in <top (required)>' /opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/lib/bundler/friendly_er rors.rb:121:inwith_friendly_errors’
/opt/zammad/vendor/bundle/ruby/2.4.0/gems/bundler-1.15.2/exe/bundle:22:in <top (required)>' /opt/zammad/bin/bundle:3:inload’
/opt/zammad/bin/bundle:3:in `’
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
== 20181102142526 ObjectManagerAttributeIndexes: migrating ====================
– add_index(:object_manager_attributes, :active)
-> 0.2426s
– add_index(:object_manager_attributes, :updated_at)
-> 0.1107s
== 20181102142526 ObjectManagerAttributeIndexes: migrated (0.3535s) ===========

== 20190314084909 ObjectManagerAttributeDateRemoveFuturePast: migrating =======
== 20190314084909 ObjectManagerAttributeDateRemoveFuturePast: migrated (0.0078s)

== 20190328000000 RenameLocaleOnUsers: migrating ==============================
== 20190328000000 RenameLocaleOnUsers: migrated (0.0059s) =====================

== 20190405000001 DatabaseIndexes: migrating ==================================
– index_exists?(:activity_streams, [:permission_id, :group_id])
-> 0.0065s
– add_index(:activity_streams, [:permission_id, :group_id])
-> 0.1110s
– index_exists?(:activity_streams, [:permission_id, :group_id, :created_at], {: name=>“index_activity_streams_on_permission_id_group_id_created_at”})
-> 0.0054s
– add_index(:activity_streams, [:permission_id, :group_id, :created_at], {:name =>“index_activity_streams_on_permission_id_group_id_created_at”})
-> 0.1085s
– index_exists?(:stores, [:store_file_id])
-> 0.0022s
– add_index(:stores, [:store_file_id])
-> 0.0702s
– index_exists?(:cti_caller_ids, [:object, :o_id, :level, :user_id, :caller_id] , {:name=>“index_cti_caller_ids_on_object_o_id_level_user_id_caller_id”})
-> 0.0037s
– add_index(:cti_caller_ids, [:object, :o_id, :level, :user_id, :caller_id], {: name=>“index_cti_caller_ids_on_object_o_id_level_user_id_caller_id”})
-> 0.0849s
– index_exists?(:tickets, [:updated_at])
-> 0.0161s
– add_index(:tickets, [:updated_at])
-> 0.0657s
– index_exists?(:tickets, [:customer_id, :state_id, :created_at])
-> 0.0160s
– add_index(:tickets, [:customer_id, :state_id, :created_at])
-> 0.0646s
– index_exists?(:tickets, [:group_id, :state_id, :updated_at])
-> 0.0163s
– add_index(:tickets, [:group_id, :state_id, :updated_at])
-> 0.0525s
– index_exists?(:tickets, [:group_id, :state_id, :owner_id, :updated_at], {:nam e=>“index_tickets_on_group_id_state_id_owner_id_updated_at”})
-> 0.0167s
– add_index(:tickets, [:group_id, :state_id, :owner_id, :updated_at], {:name=>" index_tickets_on_group_id_state_id_owner_id_updated_at"})
-> 0.1425s
– index_exists?(:tickets, [:group_id, :state_id, :created_at])
-> 0.0176s
– add_index(:tickets, [:group_id, :state_id, :created_at])
-> 0.0622s
– index_exists?(:tickets, [:group_id, :state_id, :owner_id, :created_at], {:nam e=>“index_tickets_on_group_id_state_id_owner_id_created_at”})
-> 0.0179s
– add_index(:tickets, [:group_id, :state_id, :owner_id, :created_at], {:name=>" index_tickets_on_group_id_state_id_owner_id_created_at"})
-> 0.0561s
– index_exists?(:tickets, [:group_id, :state_id, :close_at])
-> 0.0183s
– add_index(:tickets, [:group_id, :state_id, :close_at])
-> 0.0557s
– index_exists?(:tickets, [:group_id, :state_id, :owner_id, :close_at], {:name= >“index_tickets_on_group_id_state_id_owner_id_close_at”})
-> 0.0189s
– add_index(:tickets, [:group_id, :state_id, :owner_id, :close_at], {:name=>“in dex_tickets_on_group_id_state_id_owner_id_close_at”})
-> 0.0730s
== 20190405000001 DatabaseIndexes: migrated (1.1048s) =========================

== 20190408000001 Issue2541FixNotificationEmailWithoutBody: migrating =========

Updating translations…

Configuring Elasticsearch…

-> removing [ingest-attachment]…
-> Downloading ingest-attachment from elastic
[=================================================] 100%
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@ WARNING: plugin requires additional permissions @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

  • java.lang.RuntimePermission accessClassInPackage.sun.java2d.cmm.kcms
  • java.lang.RuntimePermission accessDeclaredMembers
  • java.lang.RuntimePermission getClassLoader
  • java.lang.reflect.ReflectPermission suppressAccessChecks
  • java.security.SecurityPermission createAccessControlContext
  • java.security.SecurityPermission insertProvider
  • java.security.SecurityPermission putProviderProperty.BC
    See http://docs.oracle.com/javase/8/docs/technotes/guides/security/permissions.h tml
    for descriptions of what these permissions allow and the associated risks.
    -> Installed ingest-attachment

Starting Zammad

Creating webserver bootstart

Restarting webserver nginx

################################################################################ ####

Add your fully qualified domain name or public IP to servername directive of
nginx, if this installation is done on a remote server. You have to change:
/etc/nginx/conf.d/zammad.conf and restart nginx process.
Otherwise just open http://localhost/ in your browser to start using Zammad.

Remember to enable selinux and firewall rules!

Use the following commands:
setsebool httpd_can_network_connect on -P
firewall-cmd --zone=public --add-service=http --permanent
firewall-cmd --zone=public --add-service=https --permanent
firewall-cmd --reload

################################################################################ ####
Cleanup : zammad-2.9.0-1554805410.8c7abf98.centos7.x86_64 2/2
Verifying : zammad-3.0.0-1560433985.617324d6.centos7.x86_64 1/2
Verifying : zammad-2.9.0-1554805410.8c7abf98.centos7.x86_64 2/2

Updated:
zammad.x86_64 0:3.0.0-1560433985.617324d6.centos7

Complete!

You have Triggers or Schedulers without Subjects, please fix that mistake and try to run the following again:

zammad run /opt/zammad/contrib/packager.io/postinstall.sh
This will pickup the migration at the point it died.

I was able to successfully update the system, but unfortunately the encoding error still persists.

Did you by any change run this command within the Zammad database already?
I can’t seem to find the output on the post.

Also, by any chance, did you change any of the Zammad source code?
Are you using ANY custom objects?
If so, which and where?

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