Can't create tickets per mail - Database error

Technical assistance
1

Infos:

with fresh zammad 2.5 installation (with your “production docker” version) tried to setup “fetching mails”. Did not work, zammad complains about violations regarding key constraints. Stacktrace below.

Any help appreciated.

  • Used Zammad version: 2.5
  • Used Zammad installation source: docker (production)
  • Operating system: docker
  • Browser + version:

Expected behavior:

  • E-Mail creates ticket

Actual behavior:

  • Database error

Steps to reproduce the behavior:

Fresh install, imported tickets via OTRS import. Created E-Mail IMAP account.

Stacktrace:

I, [2018-08-03T14:45:06.487625 #1]  INFO -- : fetching imap
I, [2018-08-03T14:45:06.672387 #1]  INFO -- :  - message 1/1
I, [2018-08-03T14:45:06.949057 #1]  INFO -- : Process email with msgid '<5ab916e3-5ba7-0efa-0c03-27653fb84310@anon>'
I, [2018-08-03T14:45:06.963263 #1]  INFO -- : set_attributes_by_x_headers header x-zammad-ticket-customer_id found. Assign customer_id=2
"ERROR: Can't process email, you will find it for bug reporting under /opt/zammad/tmp/unprocessable_mail/84d139bdec3c2c066a251797417c16c7.eml, please create an issue at https://github.com/zammad/zammad/issues"
"ERROR: #<ActiveRecord::InvalidForeignKey: PG::ForeignKeyViolation: ERROR:  insert or update on table \"activity_streams\" violates foreign key constraint \"fk_rails_15ed0d0859\"\nDETAIL:  Key (activity_stream_type_id)=(3) is not present in table \"type_lookups\".\n: INSERT INTO \"activity_streams\" (\"activity_stream_type_id\", \"activity_stream_object_id\", \"permission_id\", \"group_id\", \"o_id\", \"created_by_id\", \"created_at\", \"updated_at\") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING \"id\">"
E, [2018-08-03T14:45:06.986128 #1] ERROR -- : ERROR: Can't process email, you will find it for bug reporting under /opt/zammad/tmp/unprocessable_mail/84d139bdec3c2c066a251797417c16c7.eml, please create an issue at https://github.com/zammad/zammad/issues
E, [2018-08-03T14:45:06.986177 #1] ERROR -- : PG::ForeignKeyViolation: ERROR:  insert or update on table "activity_streams" violates foreign key constraint "fk_rails_15ed0d0859"
DETAIL:  Key (activity_stream_type_id)=(3) is not present in table "type_lookups".
: INSERT INTO "activity_streams" ("activity_stream_type_id", "activity_stream_object_id", "permission_id", "group_id", "o_id", "created_by_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id" (ActiveRecord::InvalidForeignKey)
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `async_exec'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `block (2 levels) in exec_no_cache'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:615:in `block in exec_no_cache'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:613:in `block (2 levels) in log'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block in log'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:604:in `log'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:614:in `exec_no_cache'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:603:in `execute_and_clear'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:79:in `exec_query'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in `exec_insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:113:in `exec_insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:133:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/query_cache.rb:17:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/relation.rb:61:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:585:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/counter_cache.rb:178:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/locking/optimistic.rb:76:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:297:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `block in _create_record'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_create_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/timestamp.rb:95:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:559:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `block in create_or_update'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_save_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:129:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/validations.rb:44:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:35:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:308:in `block (2 levels) in save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:384:in `block in with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:233:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:381:in `with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:308:in `block in save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:323:in `rollback_active_record_state!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:307:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/suppressor.rb:42:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:34:in `create'
/opt/zammad/app/models/activity_stream.rb:77:in `add'
/opt/zammad/app/models/application_model/can_activity_stream_log.rb:45:in `activity_stream_log'
/opt/zammad/app/models/concerns/has_activity_stream_log.rb:21:in `activity_stream_create'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:413:in `block in make_lambda'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:235:in `block in halting_and_conditional'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `block in invoke_after'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `each'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `invoke_after'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:132:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_create_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/timestamp.rb:95:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:559:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `block in create_or_update'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_save_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:162:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/validations.rb:50:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:43:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:313:in `block in save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:384:in `block in with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:233:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:381:in `with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:313:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/suppressor.rb:46:in `save!'
/opt/zammad/app/models/channel/email_parser.rb:641:in `block in _process'
/opt/zammad/app/models/transaction.rb:12:in `block in execute'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `block in transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/transaction.rb:194:in `block in within_new_transaction'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/transaction.rb:191:in `within_new_transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/opt/zammad/app/models/transaction.rb:10:in `execute'
/opt/zammad/app/models/channel/email_parser.rb:565:in `_process'
/opt/zammad/app/models/channel/email_parser.rb:508:in `process'
/opt/zammad/app/models/channel/driver/imap.rb:209:in `block in fetch'
/opt/zammad/app/models/channel/driver/imap.rb:187:in `each'
/opt/zammad/app/models/channel/driver/imap.rb:187:in `fetch'
/opt/zammad/app/models/channel.rb:61:in `fetch'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/relation/delegation.rb:39:in `each'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/relation/delegation.rb:39:in `each'
/opt/zammad/app/models/channel.rb:30:in `fetch'
(eval):1:in `_start_job'
/opt/zammad/app/models/scheduler.rb:274:in `eval'
/opt/zammad/app/models/scheduler.rb:274:in `_start_job'
/opt/zammad/app/models/scheduler.rb:237:in `block (2 levels) in start_job'
/opt/zammad/app/models/scheduler.rb:236:in `loop'
/opt/zammad/app/models/scheduler.rb:236:in `block in start_job'
/usr/local/bundle/gems/logging-2.2.2/lib/logging/diagnostic_context.rb:474:in `block in create_with_logging_context'
I, [2018-08-03T14:45:07.067690 #1]  INFO -- : done
2

Hi @MrDigit - Thanks for creating the thread. Could you please run Channel::EmailParser.process_unprocessable_mails on your Zammad rails console.

3

@thorsteneckel
here the requested output:

I, [2018-08-03T15:51:17.337254 #74]  INFO -- : Process email with msgid '<efc764ee-c1fb-6fce-85ca-63f105c52ec2@anon>'
I, [2018-08-03T15:51:17.356972 #74]  INFO -- : set_attributes_by_x_headers header x-zammad-ticket-customer_id found. Assign customer_id=2
"ERROR: Can't process email, you will find it for bug reporting under /opt/zammad/tmp/unprocessable_mail/2ed95a736941521ea6f5c804d5b1eb3e.eml, please create an issue at https://github.com/zammad/zammad/issues"
"ERROR: #<ActiveRecord::InvalidForeignKey: PG::ForeignKeyViolation: ERROR:  insert or update on table \"activity_streams\" violates foreign key constraint \"fk_rails_15ed0d0859\"\nDETAIL:  Key (activity_stream_type_id)=(3) is not present in table \"type_lookups\".\n: INSERT INTO \"activity_streams\" (\"activity_stream_type_id\", \"activity_stream_object_id\", \"permission_id\", \"group_id\", \"o_id\", \"created_by_id\", \"created_at\", \"updated_at\") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING \"id\">"
E, [2018-08-03T15:51:17.372917 #74] ERROR -- : ERROR: Can't process email, you will find it for bug reporting under /opt/zammad/tmp/unprocessable_mail/2ed95a736941521ea6f5c804d5b1eb3e.eml, please create an issue at https://github.com/zammad/zammad/issues
E, [2018-08-03T15:51:17.372952 #74] ERROR -- : PG::ForeignKeyViolation: ERROR:  insert or update on table "activity_streams" violates foreign key constraint "fk_rails_15ed0d0859"
DETAIL:  Key (activity_stream_type_id)=(3) is not present in table "type_lookups".
: INSERT INTO "activity_streams" ("activity_stream_type_id", "activity_stream_object_id", "permission_id", "group_id", "o_id", "created_by_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id" (ActiveRecord::InvalidForeignKey)
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `async_exec'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `block (2 levels) in exec_no_cache'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:615:in `block in exec_no_cache'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:613:in `block (2 levels) in log'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block in log'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:604:in `log'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:614:in `exec_no_cache'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:603:in `execute_and_clear'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:79:in `exec_query'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in `exec_insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:113:in `exec_insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:133:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/query_cache.rb:17:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/relation.rb:61:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:585:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/counter_cache.rb:178:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/locking/optimistic.rb:76:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:297:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `block in _create_record'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_create_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/timestamp.rb:95:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:559:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `block in create_or_update'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_save_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:129:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/validations.rb:44:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:35:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:308:in `block (2 levels) in save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:384:in `block in with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:233:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:381:in `with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:308:in `block in save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:323:in `rollback_active_record_state!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:307:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/suppressor.rb:42:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:34:in `create'
/opt/zammad/app/models/activity_stream.rb:77:in `add'
/opt/zammad/app/models/application_model/can_activity_stream_log.rb:45:in `activity_stream_log'
/opt/zammad/app/models/concerns/has_activity_stream_log.rb:21:in `activity_stream_create'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:413:in `block in make_lambda'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:235:in `block in halting_and_conditional'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `block in invoke_after'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `each'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `invoke_after'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:132:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_create_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/timestamp.rb:95:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:559:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `block in create_or_update'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_save_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:162:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/validations.rb:50:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:43:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:313:in `block in save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:384:in `block in with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:233:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:381:in `with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:313:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/suppressor.rb:46:in `save!'
/opt/zammad/app/models/channel/email_parser.rb:641:in `block in _process'
/opt/zammad/app/models/transaction.rb:12:in `block in execute'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `block in transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/transaction.rb:194:in `block in within_new_transaction'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/transaction.rb:191:in `within_new_transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/opt/zammad/app/models/transaction.rb:10:in `execute'
/opt/zammad/app/models/channel/email_parser.rb:565:in `_process'
/opt/zammad/app/models/channel/email_parser.rb:508:in `process'
/opt/zammad/app/models/channel/email_parser.rb:852:in `block in process_unprocessable_mails'
/opt/zammad/app/models/channel/email_parser.rb:851:in `glob'
/opt/zammad/app/models/channel/email_parser.rb:851:in `process_unprocessable_mails'
(irb):17:in `irb_binding'
/usr/local/lib/ruby/2.4.0/irb/workspace.rb:87:in `eval'
/usr/local/lib/ruby/2.4.0/irb/workspace.rb:87:in `evaluate'
/usr/local/lib/ruby/2.4.0/irb/context.rb:381:in `evaluate'
/usr/local/lib/ruby/2.4.0/irb.rb:493:in `block (2 levels) in eval_input'
/usr/local/lib/ruby/2.4.0/irb.rb:627:in `signal_status'
/usr/local/lib/ruby/2.4.0/irb.rb:490:in `block in eval_input'
/usr/local/lib/ruby/2.4.0/irb/ruby-lex.rb:246:in `block (2 levels) in each_top_level_statement'
/usr/local/lib/ruby/2.4.0/irb/ruby-lex.rb:232:in `loop'
/usr/local/lib/ruby/2.4.0/irb/ruby-lex.rb:232:in `block in each_top_level_statement'
/usr/local/lib/ruby/2.4.0/irb/ruby-lex.rb:231:in `catch'
/usr/local/lib/ruby/2.4.0/irb/ruby-lex.rb:231:in `each_top_level_statement'
/usr/local/lib/ruby/2.4.0/irb.rb:489:in `eval_input'
/usr/local/lib/ruby/2.4.0/irb.rb:430:in `block in run'
/usr/local/lib/ruby/2.4.0/irb.rb:429:in `catch'
/usr/local/lib/ruby/2.4.0/irb.rb:429:in `run'
/usr/local/lib/ruby/2.4.0/irb.rb:385:in `start'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/console/console_command.rb:62:in `start'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/console/console_command.rb:17:in `start'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/console/console_command.rb:97:in `perform'
/usr/local/bundle/gems/thor-0.20.0/lib/thor/command.rb:27:in `run'
/usr/local/bundle/gems/thor-0.20.0/lib/thor/invocation.rb:126:in `invoke_command'
/usr/local/bundle/gems/thor-0.20.0/lib/thor.rb:387:in `dispatch'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/command/base.rb:63:in `perform'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/command.rb:44:in `invoke'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands.rb:16:in `<top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'
RuntimeError: #<ActiveRecord::InvalidForeignKey: PG::ForeignKeyViolation: ERROR:  insert or update on table "activity_streams" violates foreign key constraint "fk_rails_15ed0d0859"
DETAIL:  Key (activity_stream_type_id)=(3) is not present in table "type_lookups".
: INSERT INTO "activity_streams" ("activity_stream_type_id", "activity_stream_object_id", "permission_id", "group_id", "o_id", "created_by_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id">
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `async_exec'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `block (2 levels) in exec_no_cache'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:615:in `block in exec_no_cache'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:613:in `block (2 levels) in log'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block in log'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:604:in `log'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:614:in `exec_no_cache'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:603:in `execute_and_clear'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:79:in `exec_query'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in `exec_insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:113:in `exec_insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:133:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/query_cache.rb:17:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/relation.rb:61:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:585:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/counter_cache.rb:178:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/locking/optimistic.rb:76:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:297:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `block in _create_record'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_create_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/timestamp.rb:95:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:559:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `block in create_or_update'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_save_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:129:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/validations.rb:44:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:35:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:308:in `block (2 levels) in save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:384:in `block in with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:233:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:381:in `with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:308:in `block in save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:323:in `rollback_active_record_state!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:307:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/suppressor.rb:42:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:34:in `create'
/opt/zammad/app/models/activity_stream.rb:77:in `add'
/opt/zammad/app/models/application_model/can_activity_stream_log.rb:45:in `activity_stream_log'
/opt/zammad/app/models/concerns/has_activity_stream_log.rb:21:in `activity_stream_create'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:413:in `block in make_lambda'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:235:in `block in halting_and_conditional'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `block in invoke_after'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `each'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `invoke_after'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:132:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_create_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/timestamp.rb:95:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:559:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `block in create_or_update'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_save_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:162:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/validations.rb:50:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:43:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:313:in `block in save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:384:in `block in with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:233:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:381:in `with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:313:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/suppressor.rb:46:in `save!'
/opt/zammad/app/models/channel/email_parser.rb:641:in `block in _process'
/opt/zammad/app/models/transaction.rb:12:in `block in execute'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `block in transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/transaction.rb:194:in `block in within_new_transaction'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/transaction.rb:191:in `within_new_transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/opt/zammad/app/models/transaction.rb:10:in `execute'
/opt/zammad/app/models/channel/email_parser.rb:565:in `_process'
/opt/zammad/app/models/channel/email_parser.rb:508:in `process'
/opt/zammad/app/models/channel/email_parser.rb:852:in `block in process_unprocessable_mails'
/opt/zammad/app/models/channel/email_parser.rb:851:in `glob'
/opt/zammad/app/models/channel/email_parser.rb:851:in `process_unprocessable_mails'
(irb):17:in `irb_binding'
/usr/local/lib/ruby/2.4.0/irb/workspace.rb:87:in `eval'
/usr/local/lib/ruby/2.4.0/irb/workspace.rb:87:in `evaluate'
/usr/local/lib/ruby/2.4.0/irb/context.rb:381:in `evaluate'
/usr/local/lib/ruby/2.4.0/irb.rb:493:in `block (2 levels) in eval_input'
/usr/local/lib/ruby/2.4.0/irb.rb:627:in `signal_status'
/usr/local/lib/ruby/2.4.0/irb.rb:490:in `block in eval_input'
/usr/local/lib/ruby/2.4.0/irb/ruby-lex.rb:246:in `block (2 levels) in each_top_level_statement'
/usr/local/lib/ruby/2.4.0/irb/ruby-lex.rb:232:in `loop'
/usr/local/lib/ruby/2.4.0/irb/ruby-lex.rb:232:in `block in each_top_level_statement'
/usr/local/lib/ruby/2.4.0/irb/ruby-lex.rb:231:in `catch'
/usr/local/lib/ruby/2.4.0/irb/ruby-lex.rb:231:in `each_top_level_statement'
/usr/local/lib/ruby/2.4.0/irb.rb:489:in `eval_input'
/usr/local/lib/ruby/2.4.0/irb.rb:430:in `block in run'
/usr/local/lib/ruby/2.4.0/irb.rb:429:in `catch'
/usr/local/lib/ruby/2.4.0/irb.rb:429:in `run'
/usr/local/lib/ruby/2.4.0/irb.rb:385:in `start'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/console/console_command.rb:62:in `start'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/console/console_command.rb:17:in `start'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/console/console_command.rb:97:in `perform'
/usr/local/bundle/gems/thor-0.20.0/lib/thor/command.rb:27:in `run'
/usr/local/bundle/gems/thor-0.20.0/lib/thor/invocation.rb:126:in `invoke_command'
/usr/local/bundle/gems/thor-0.20.0/lib/thor.rb:387:in `dispatch'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/command/base.rb:63:in `perform'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/command.rb:44:in `invoke'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands.rb:16:in `<top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'
        from app/models/channel/email_parser.rb:524:in `rescue in process'
        from app/models/channel/email_parser.rb:506:in `process'
        from app/models/channel/email_parser.rb:852:in `block in process_unprocessable_mails'
        from app/models/channel/email_parser.rb:851:in `glob'
        from app/models/channel/email_parser.rb:851:in `process_unprocessable_mails'
        from (irb):17
4

1.) Create a file called debug_issue.rb in your Zammad directory (usually /opt/zammad)
2.) Run the file from your Zammad directory via zammad run rails r debug_issue.rb or rails r debug_issue.rb as zammad user, depending on your installation source (package/source)
3.) Post the output here. Make sure all sensitive data is anonymized!
4.) Delete the debug_issue.rb file

require 'activity_stream'

class ActivityStream < ApplicationModel

  def self.add(data)

    # lookups
    if data[:type]
      type_id = TypeLookup.by_name(data[:type])
    end
    if data[:object]
      object_id = ObjectLookup.by_name(data[:object])
    end

    permission_id = nil
    if data[:permission]
      permission = Permission.lookup(name: data[:permission])
      if !permission
        raise "No such Permission #{data[:permission]}"
      end
      permission_id = permission.id
    end

    # check newest entry - is needed
    result = ActivityStream.where(
      o_id: data[:o_id],
      #:activity_stream_type_id  => type_id,
      permission_id: permission_id,
      activity_stream_object_id: object_id,
      created_by_id: data[:created_by_id]
    ).order('created_at DESC, id DESC').first

    # resturn if old entry is really fresh
    if result
      activity_record_delay = 90.seconds
      return result if result.created_at.to_i >= ( data[:created_at].to_i - activity_record_delay )
    end

    # create history
    record = {
      o_id:                      data[:o_id],
      activity_stream_type_id:   type_id,
      activity_stream_object_id: object_id,
      permission_id:             permission_id,
      group_id:                  data[:group_id],
      created_at:                data[:created_at],
      created_by_id:             data[:created_by_id]
    }

    p data
    p record

    ActivityStream.create(record)
  end
end


Channel::EmailParser.process_unprocessable_mails
5

@thorsteneckel

root@61c5bd5fc6af:/opt/zammad# rails r debug_issue.rb
I, [2018-08-03T16:12:57.339194 #78]  INFO -- : Process email with msgid '<efc764ee-c1fb-6fce-85ca-63f105c52ec2@anon>'
I, [2018-08-03T16:12:57.355778 #78]  INFO -- : set_attributes_by_x_headers header x-zammad-ticket-customer_id found. Assign customer_id=2
{:o_id=>59811, :type=>"create", :object=>"Ticket", :group_id=>1, :permission=>"ticket.agent", :created_at=>Fri, 03 Aug 2018 16:12:57 UTC +00:00, :created_by_id=>2}
{:o_id=>59811, :activity_stream_type_id=>3, :activity_stream_object_id=>2, :permission_id=>45, :group_id=>1, :created_at=>Fri, 03 Aug 2018 16:12:57 UTC +00:00, :created_by_id=>2}
"ERROR: Can't process email, you will find it for bug reporting under /opt/zammad/tmp/unprocessable_mail/2ed95a736941521ea6f5c804d5b1eb3e.eml, please create an issue at https://github.com/zammad/zammad/issues"
"ERROR: #<ActiveRecord::InvalidForeignKey: PG::ForeignKeyViolation: ERROR:  insert or update on table \"activity_streams\" violates foreign key constraint \"fk_rails_15ed0d0859\"\nDETAIL:  Key (activity_stream_type_id)=(3) is not present in table \"type_lookups\".\n: INSERT INTO \"activity_streams\" (\"activity_stream_type_id\", \"activity_stream_object_id\", \"permission_id\", \"group_id\", \"o_id\", \"created_by_id\", \"created_at\", \"updated_at\") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING \"id\">"
E, [2018-08-03T16:12:57.371613 #78] ERROR -- : ERROR: Can't process email, you will find it for bug reporting under /opt/zammad/tmp/unprocessable_mail/2ed95a736941521ea6f5c804d5b1eb3e.eml, please create an issue at https://github.com/zammad/zammad/issues
E, [2018-08-03T16:12:57.371648 #78] ERROR -- : PG::ForeignKeyViolation: ERROR:  insert or update on table "activity_streams" violates foreign key constraint "fk_rails_15ed0d0859"
DETAIL:  Key (activity_stream_type_id)=(3) is not present in table "type_lookups".
: INSERT INTO "activity_streams" ("activity_stream_type_id", "activity_stream_object_id", "permission_id", "group_id", "o_id", "created_by_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id" (ActiveRecord::InvalidForeignKey)
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `async_exec'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `block (2 levels) in exec_no_cache'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:615:in `block in exec_no_cache'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:613:in `block (2 levels) in log'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block in log'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:604:in `log'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:614:in `exec_no_cache'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:603:in `execute_and_clear'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:79:in `exec_query'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in `exec_insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:113:in `exec_insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:133:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/query_cache.rb:17:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/relation.rb:61:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:585:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/counter_cache.rb:178:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/locking/optimistic.rb:76:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:297:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `block in _create_record'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_create_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/timestamp.rb:95:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:559:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `block in create_or_update'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_save_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:129:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/validations.rb:44:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:35:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:308:in `block (2 levels) in save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:384:in `block in with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:233:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:381:in `with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:308:in `block in save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:323:in `rollback_active_record_state!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:307:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/suppressor.rb:42:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:34:in `create'
debug_issue.rb:53:in `add'
/opt/zammad/app/models/application_model/can_activity_stream_log.rb:45:in `activity_stream_log'
/opt/zammad/app/models/concerns/has_activity_stream_log.rb:21:in `activity_stream_create'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:413:in `block in make_lambda'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:235:in `block in halting_and_conditional'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `block in invoke_after'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `each'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `invoke_after'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:132:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_create_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/timestamp.rb:95:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:559:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `block in create_or_update'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_save_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:162:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/validations.rb:50:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:43:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:313:in `block in save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:384:in `block in with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:233:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:381:in `with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:313:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/suppressor.rb:46:in `save!'
/opt/zammad/app/models/channel/email_parser.rb:641:in `block in _process'
/opt/zammad/app/models/transaction.rb:12:in `block in execute'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `block in transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/transaction.rb:194:in `block in within_new_transaction'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/transaction.rb:191:in `within_new_transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/opt/zammad/app/models/transaction.rb:10:in `execute'
/opt/zammad/app/models/channel/email_parser.rb:565:in `_process'
/opt/zammad/app/models/channel/email_parser.rb:508:in `process'
/opt/zammad/app/models/channel/email_parser.rb:852:in `block in process_unprocessable_mails'
/opt/zammad/app/models/channel/email_parser.rb:851:in `glob'
/opt/zammad/app/models/channel/email_parser.rb:851:in `process_unprocessable_mails'
debug_issue.rb:58:in `<top (required)>'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/runner/runner_command.rb:34:in `load'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/runner/runner_command.rb:34:in `perform'
/usr/local/bundle/gems/thor-0.20.0/lib/thor/command.rb:27:in `run'
/usr/local/bundle/gems/thor-0.20.0/lib/thor/invocation.rb:126:in `invoke_command'
/usr/local/bundle/gems/thor-0.20.0/lib/thor.rb:387:in `dispatch'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/command/base.rb:63:in `perform'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/command.rb:44:in `invoke'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands.rb:16:in `<top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'
/opt/zammad/app/models/channel/email_parser.rb:524:in `rescue in process': #<ActiveRecord::InvalidForeignKey: PG::ForeignKeyViolation: ERROR:  insert or update on table "activity_streams" violates foreign key constraint "fk_rails_15ed0d0859" (RuntimeError)
DETAIL:  Key (activity_stream_type_id)=(3) is not present in table "type_lookups".
: INSERT INTO "activity_streams" ("activity_stream_type_id", "activity_stream_object_id", "permission_id", "group_id", "o_id", "created_by_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id">
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `async_exec'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:616:in `block (2 levels) in exec_no_cache'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:615:in `block in exec_no_cache'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:613:in `block (2 levels) in log'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block in log'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract_adapter.rb:604:in `log'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:614:in `exec_no_cache'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:603:in `execute_and_clear'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:79:in `exec_query'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:102:in `exec_insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:113:in `exec_insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:133:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/query_cache.rb:17:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/relation.rb:61:in `insert'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:585:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/counter_cache.rb:178:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/locking/optimistic.rb:76:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:297:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `block in _create_record'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_create_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/timestamp.rb:95:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:559:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `block in create_or_update'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_save_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:129:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/validations.rb:44:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:35:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:308:in `block (2 levels) in save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:384:in `block in with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:233:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:381:in `with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:308:in `block in save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:323:in `rollback_active_record_state!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:307:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/suppressor.rb:42:in `save'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:34:in `create'
debug_issue.rb:53:in `add'
/opt/zammad/app/models/application_model/can_activity_stream_log.rb:45:in `activity_stream_log'
/opt/zammad/app/models/concerns/has_activity_stream_log.rb:21:in `activity_stream_create'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:413:in `block in make_lambda'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:235:in `block in halting_and_conditional'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `block in invoke_after'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `each'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:511:in `invoke_after'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:132:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_create_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:340:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/timestamp.rb:95:in `_create_record'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:559:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `block in create_or_update'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:131:in `run_callbacks'
/usr/local/bundle/gems/activesupport-5.1.5/lib/active_support/callbacks.rb:827:in `_run_save_callbacks'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/callbacks.rb:336:in `create_or_update'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/persistence.rb:162:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/validations.rb:50:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/attribute_methods/dirty.rb:43:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:313:in `block in save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:384:in `block in with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:233:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:381:in `with_transaction_returning_status'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:313:in `save!'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/suppressor.rb:46:in `save!'
/opt/zammad/app/models/channel/email_parser.rb:641:in `block in _process'
/opt/zammad/app/models/transaction.rb:12:in `block in execute'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `block in transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/transaction.rb:194:in `block in within_new_transaction'
/usr/local/lib/ruby/2.4.0/monitor.rb:214:in `mon_synchronize'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/transaction.rb:191:in `within_new_transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `transaction'
/usr/local/bundle/gems/activerecord-5.1.5/lib/active_record/transactions.rb:210:in `transaction'
/opt/zammad/app/models/transaction.rb:10:in `execute'
/opt/zammad/app/models/channel/email_parser.rb:565:in `_process'
/opt/zammad/app/models/channel/email_parser.rb:508:in `process'
/opt/zammad/app/models/channel/email_parser.rb:852:in `block in process_unprocessable_mails'
/opt/zammad/app/models/channel/email_parser.rb:851:in `glob'
/opt/zammad/app/models/channel/email_parser.rb:851:in `process_unprocessable_mails'
debug_issue.rb:58:in `<top (required)>'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/runner/runner_command.rb:34:in `load'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/runner/runner_command.rb:34:in `perform'
/usr/local/bundle/gems/thor-0.20.0/lib/thor/command.rb:27:in `run'
/usr/local/bundle/gems/thor-0.20.0/lib/thor/invocation.rb:126:in `invoke_command'
/usr/local/bundle/gems/thor-0.20.0/lib/thor.rb:387:in `dispatch'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/command/base.rb:63:in `perform'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/command.rb:44:in `invoke'
/usr/local/bundle/gems/railties-5.1.5/lib/rails/commands.rb:16:in `<top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'
        from /opt/zammad/app/models/channel/email_parser.rb:506:in `process'
        from /opt/zammad/app/models/channel/email_parser.rb:852:in `block in process_unprocessable_mails'
        from /opt/zammad/app/models/channel/email_parser.rb:851:in `glob'
        from /opt/zammad/app/models/channel/email_parser.rb:851:in `process_unprocessable_mails'
        from debug_issue.rb:58:in `<top (required)>'
        from /usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/runner/runner_command.rb:34:in `load'
        from /usr/local/bundle/gems/railties-5.1.5/lib/rails/commands/runner/runner_command.rb:34:in `perform'
        from /usr/local/bundle/gems/thor-0.20.0/lib/thor/command.rb:27:in `run'
        from /usr/local/bundle/gems/thor-0.20.0/lib/thor/invocation.rb:126:in `invoke_command'
        from /usr/local/bundle/gems/thor-0.20.0/lib/thor.rb:387:in `dispatch'
        from /usr/local/bundle/gems/railties-5.1.5/lib/rails/command/base.rb:63:in `perform'
        from /usr/local/bundle/gems/railties-5.1.5/lib/rails/command.rb:44:in `invoke'
        from /usr/local/bundle/gems/railties-5.1.5/lib/rails/commands.rb:16:in `<top (required)>'
        from bin/rails:4:in `require'
        from bin/rails:4:in `<main>'
6

Can you please run Cache.clear on your Zammad Rails console and execute the script again?

7

magic happened, the tickets appeared after executing your cmd. Here the output:

What is/was the failure ?


root@61c5bd5fc6af:/opt/zammad# rails c
Loading production environment (Rails 5.1.5)
irb(main):001:0> Cache.clear
=> [true]
irb(main):002:0>
root@61c5bd5fc6af:/opt/zammad# rails r debug_issue.rb
I, [2018-08-03T17:01:00.724884 #89]  INFO -- : Process email with msgid '<efc764ee-c1fb-6fce-85ca-63f105c52ec2@anon>'
I, [2018-08-03T17:01:00.741833 #89]  INFO -- : set_attributes_by_x_headers header x-zammad-ticket-customer_id found. Assign customer_id=2
{:o_id=>59812, :type=>"create", :object=>"Ticket", :group_id=>1, :permission=>"ticket.agent", :created_at=>Fri, 03 Aug 2018 17:01:00 UTC +00:00, :created_by_id=>2}
{:o_id=>59812, :activity_stream_type_id=>4, :activity_stream_object_id=>2, :permission_id=>45, :group_id=>1, :created_at=>Fri, 03 Aug 2018 17:01:00 UTC +00:00, :created_by_id=>2}
I, [2018-08-03T17:01:00.813269 #89]  INFO -- : set_attributes_by_x_headers header x-zammad-article-sender found Agent
I, [2018-08-03T17:01:00.813342 #89]  INFO -- : set_attributes_by_x_headers found Ticket::Article::Sender lookup for 'Agent'
I, [2018-08-03T17:01:00.814817 #89]  INFO -- : set_attributes_by_x_headers assign Ticket::Article sender_id=1
I, [2018-08-03T17:01:00.814910 #89]  INFO -- : set_attributes_by_x_headers header x-zammad-article-preferences found. Assign preferences={"send-auto-response"=>true, "is-auto-response"=>false}
{:o_id=>72331, :type=>"create", :object=>"Ticket::Article", :group_id=>1, :permission=>"ticket.agent", :created_at=>Fri, 03 Aug 2018 17:01:00 UTC +00:00, :created_by_id=>2}
{:o_id=>72331, :activity_stream_type_id=>4, :activity_stream_object_id=>13, :permission_id=>45, :group_id=>1, :created_at=>Fri, 03 Aug 2018 17:01:00 UTC +00:00, :created_by_id=>2}
I, [2018-08-03T17:01:00.916373 #89]  INFO -- : Process email with msgid '<55ddbd86-b2b6-d27a-6d08-e0a40d93f272@anon>'
I, [2018-08-03T17:01:00.927332 #89]  INFO -- : set_attributes_by_x_headers header x-zammad-ticket-customer_id found. Assign customer_id=2
{:o_id=>59813, :type=>"create", :object=>"Ticket", :group_id=>1, :permission=>"ticket.agent", :created_at=>Fri, 03 Aug 2018 17:01:00 UTC +00:00, :created_by_id=>2}
{:o_id=>59813, :activity_stream_type_id=>4, :activity_stream_object_id=>2, :permission_id=>45, :group_id=>1, :created_at=>Fri, 03 Aug 2018 17:01:00 UTC +00:00, :created_by_id=>2}
I, [2018-08-03T17:01:00.949524 #89]  INFO -- : set_attributes_by_x_headers header x-zammad-article-sender found Agent
I, [2018-08-03T17:01:00.949578 #89]  INFO -- : set_attributes_by_x_headers found Ticket::Article::Sender lookup for 'Agent'
I, [2018-08-03T17:01:00.949813 #89]  INFO -- : set_attributes_by_x_headers assign Ticket::Article sender_id=1
I, [2018-08-03T17:01:00.949889 #89]  INFO -- : set_attributes_by_x_headers header x-zammad-article-preferences found. Assign preferences={"send-auto-response"=>true, "is-auto-response"=>false}
{:o_id=>72332, :type=>"create", :object=>"Ticket::Article", :group_id=>1, :permission=>"ticket.agent", :created_at=>Fri, 03 Aug 2018 17:01:00 UTC +00:00, :created_by_id=>2}
{:o_id=>72332, :activity_stream_type_id=>4, :activity_stream_object_id=>13, :permission_id=>45, :group_id=>1, :created_at=>Fri, 03 Aug 2018 17:01:00 UTC +00:00, :created_by_id=>2}
I, [2018-08-03T17:01:01.016985 #89]  INFO -- : Process email with msgid '<5ab916e3-5ba7-0efa-0c03-27653fb84310@anon>'
I, [2018-08-03T17:01:01.027769 #89]  INFO -- : set_attributes_by_x_headers header x-zammad-ticket-customer_id found. Assign customer_id=2
{:o_id=>59814, :type=>"create", :object=>"Ticket", :group_id=>1, :permission=>"ticket.agent", :created_at=>Fri, 03 Aug 2018 17:01:01 UTC +00:00, :created_by_id=>2}
{:o_id=>59814, :activity_stream_type_id=>4, :activity_stream_object_id=>2, :permission_id=>45, :group_id=>1, :created_at=>Fri, 03 Aug 2018 17:01:01 UTC +00:00, :created_by_id=>2}
I, [2018-08-03T17:01:01.050240 #89]  INFO -- : set_attributes_by_x_headers header x-zammad-article-sender found Agent
I, [2018-08-03T17:01:01.050306 #89]  INFO -- : set_attributes_by_x_headers found Ticket::Article::Sender lookup for 'Agent'
I, [2018-08-03T17:01:01.050689 #89]  INFO -- : set_attributes_by_x_headers assign Ticket::Article sender_id=1
I, [2018-08-03T17:01:01.050755 #89]  INFO -- : set_attributes_by_x_headers header x-zammad-article-preferences found. Assign preferences={"send-auto-response"=>true, "is-auto-response"=>false}
{:o_id=>72333, :type=>"create", :object=>"Ticket::Article", :group_id=>1, :permission=>"ticket.agent", :created_at=>Fri, 03 Aug 2018 17:01:01 UTC +00:00, :created_by_id=>2}
{:o_id=>72333, :activity_stream_type_id=>4, :activity_stream_object_id=>13, :permission_id=>45, :group_id=>1, :created_at=>Fri, 03 Aug 2018 17:01:01 UTC +00:00, :created_by_id=>2}
8

Probably more a caching issue than magic :nerd_face: To be honest I don’t know how this might have happened but please let me/us know how to reproduce it if you know how.

9

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