Somehow having 2 notification channels

I’m not sure how i ended up in this situation, but i seem to have 2 emails channels for the notification channel;

Also checking the database is 4 records, one with id 1 and 2, and the other with id 7 & 8 created much later;

zammad_production=# select * from channels where area=‘Email::Notification’;
id | group_id | area | options | active | preferences | last_log_in | last_log_out | status_in | status_out | updated_by_id | created_by_id | created_at | updated_at
----±---------±--------------------±------------------------------------------------------------------±-------±--------------------------------------------------------±------------±------------------------------------------------------------------±----------±-----------±--------------±--------------±------------------------±------------------------
1 | 1 | Email::Notification | — !ruby/hash:ActiveSupport::HashWithIndifferentAccess +| f | — !ruby/hash:ActiveSupport::HashWithIndifferentAccess+| | | | | 3 | 1 | 2020-10-30 13:19:05.577 | 2020-10-30 13:24:46.252
| | | outbound: !ruby/hash:ActiveSupport::HashWithIndifferentAccess +| | online_service_disable: true +| | | | | | | |
| | | adapter: smtp +| | | | | | | | | |
| | | options: !ruby/hash:ActiveSupport::HashWithIndifferentAccess +| | | | | | | | | |
| | | host: host.example.com +| | | | | | | | | |
| | | user: ‘’ +| | | | | | | | | |
| | | password: ‘’ +| | | | | | | | | |
| | | ssl: true +| | | | | | | | | |
| | | | | | | | | | | | |
7 | 1 | Email::Notification | — !ruby/hash:ActiveSupport::HashWithIndifferentAccess +| f | — !ruby/hash:ActiveSupport::HashWithIndifferentAccess+| | | | | 3 | 1 | 2021-03-07 23:01:00.212 | 2021-04-01 21:44:37.232
| | | outbound: !ruby/hash:ActiveSupport::HashWithIndifferentAccess +| | online_service_disable: true +| | | | | | | |
| | | adapter: smtp +| | | | | | | | | |
| | | options: !ruby/hash:ActiveSupport::HashWithIndifferentAccess +| | | | | | | | | |
| | | host: host.example.com +| | | | | | | | | |
| | | user: ‘’ +| | | | | | | | | |
| | | password: ‘’ +| | | | | | | | | |
| | | ssl: true +| | | | | | | | | |
| | | | | | | | | | | | |
2 | | Email::Notification | — !ruby/hash:ActiveSupport::HashWithIndifferentAccess +| t | — !ruby/hash:ActiveSupport::HashWithIndifferentAccess+| | Can’t use Channel::Driver::Sendmail: #<Errno::EPIPE: Broken pipe> | | error | 3 | 1 | 2020-10-30 13:19:05.614 | 2021-04-04 00:09:35.506
| | | outbound: !ruby/hash:ActiveSupport::HashWithIndifferentAccess +| | online_service_disable: true +| | | | | | | |
| | | adapter: sendmail +| | | | | | | | | |
| | | options: !ruby/hash:ActiveSupport::HashWithIndifferentAccess {}+| | | | | | | | | |
| | | | | | | | | | | | |
8 | | Email::Notification | — !ruby/hash:ActiveSupport::HashWithIndifferentAccess +| t | — !ruby/hash:ActiveSupport::HashWithIndifferentAccess+| | | | ok | 3 | 1 | 2021-03-07 23:01:00.254 | 2021-04-02 08:20:26.939
| | | outbound: !ruby/hash:ActiveSupport::HashWithIndifferentAccess +| | online_service_disable: true +| | | | | | | |
| | | adapter: sendmail +| | | | | | | | | |
| | | options: !ruby/hash:ActiveSupport::HashWithIndifferentAccess {}+| | | | | | | | | |
| | | | | | | | | | | | |
(4 rows)

What would be the best way to remove one? or is this a correct configuration?
Would simply deleting them from the DB be a correct approach?

Thanks Olaf

This happens if you seed a seeded database.

Dangerzone

Below removes channels and is a potential dangerous operation.
Within a rails console:

Channel.find(7).destroy
Channel.find(8).destroy

Thank you, this worked!

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