Infos:
- Used Zammad version: 3.3
- Used Zammad installation source: package
- Operating system: CentOS 7
- Browser + version: Chrome on Linux
Hi,
I imported 34000 tickets from RT using the API
Before importing I disabled all triggers and I can’t remember if I disabled any schedulers, but none show on the scheduler list even with the schedulers table has 22 records all having a 1 in the active field.
I imported the 34000 tickets over days and no emails were generated. Last night, after finishing the last import and comparing the results, adjusted a couple of merges that were missed during the import, etc. After that, happy that both systems matched, I decided to update from 3.2 to 3.3 using “yum update”.
The update went OK and then I restarted zammad with “systemctl restart zammad”.
As soon as I restarted zammad it started sending email from ticket number 1
I removed hundred of emails from the postfix queue, I stopped postfix but emails are still being generated and going out.
On the Channel Email setup I have the use local mta.
Even with postfix stopped emails go out.
The only way I found to stop them is by stopping zammad.
Is there a queue somewhere that I can empty to stop old emails from going out and only start notifying by email changes from now on? Or is zammad going through the tickets and verifying some flag to see if it was notified before.
I work with MySQL so if there’s a flag I can update, I’ll do it if you point me in the right direction or and API function.
Also, should those schedulers appear in the schedulers list in the web interface or are they somehow internal?
Any help will be appreciated as I’m ready to start using it for real.
±—±------------------------------------------------------±------------------------------------±--------±------------------------±-------±-------+
| id | name | method | period | last_run | status | active |
±—±------------------------------------------------------±------------------------------------±--------±------------------------±-------±-------+
| 1 | Process pending tickets | Ticket.process_pending | 900 | 2020-06-07 10:25:10.610 | ok | 1 |
| 2 | Process escalation tickets | Ticket.process_escalation | 300 | 2020-06-07 10:37:31.996 | ok | 1 |
| 3 | Process auto unassign tickets | Ticket.process_auto_unassign | 600 | 2020-06-07 10:36:53.691 | ok | 1 |
| 4 | Import OTRS diff load | Import::OTRS.diff_worker | 180 | 2020-06-07 10:36:53.985 | ok | 1 |
| 5 | Check Channels | Channel.fetch | 30 | 2020-06-07 10:39:22.253 | ok | 1 |
| 6 | Check streams for Channel | Channel.stream | 60 | 2020-06-07 10:12:51.339 | ok | 1 |
| 7 | Generate Session data | Sessions.jobs | 60 | 2020-06-07 10:13:01.341 | ok | 1 |
| 8 | Execute jobs | Job.run | 300 | 2020-06-07 10:38:23.463 | ok | 1 |
| 9 | Cleanup expired sessions | SessionHelper.cleanup_expired | 43200 | 2020-06-07 01:09:01.674 | ok | 1 |
| 10 | Delete old activity stream entries. | ActivityStream.cleanup | 86400 | 2020-06-07 01:09:11.677 | ok | 1 |
| 11 | Delete old entries. | RecentView.cleanup | 86400 | 2020-06-07 01:09:21.676 | ok | 1 |
| 12 | Delete old online notification entries. | OnlineNotification.cleanup | 7200 | 2020-06-07 09:55:34.769 | ok | 1 |
| 13 | Delete old token entries. | Token.cleanup | 2592000 | 2020-06-07 01:09:41.678 | ok | 1 |
| 14 | Closed chat sessions where participients are offline. | Chat.cleanup_close | 900 | 2020-06-07 10:28:33.349 | ok | 1 |
| 15 | Cleanup closed sessions. | Chat.cleanup | 432000 | 2020-06-07 01:10:01.679 | ok | 1 |
| 16 | Sync calendars with ical feeds. | Calendar.sync | 86400 | 2020-06-07 01:10:11.690 | ok | 1 |
| 17 | Generate user based stats. | Stats.generate | 660 | 2020-06-07 10:30:43.433 | ok | 1 |
| 18 | Delete old stats store entries. | StatsStore.cleanup | 2678400 | 2020-06-07 01:10:31.716 | ok | 1 |
| 19 | Cleanup HttpLog | HttpLog.cleanup | 86400 | 2020-06-07 01:10:41.717 | ok | 1 |
| 20 | Cleanup Cti::Log | Cti::Log.cleanup | 2629746 | 2020-06-07 01:10:51.717 | ok | 1 |
| 21 | Import Jobs | ImportJob.start_registered | 3600 | 2020-06-07 09:55:14.363 | ok | 1 |
| 22 | Cleanup ActiveJob locks. | ActiveJobLockCleanupJob.perform_now | 86400 | 2020-06-07 01:03:57.999 | NULL | 1 |
±—±------------------------------------------------------±------------------------------------±--------±------------------------±-------±-------+