Used Zammad version: 6.2.0-1711375558.ce1240f3.bookworm
Used Zammad installation type: (source, package, docker-compose, …) package
Operating system: Debian 12
Browser + version: Firefox 124.0.2
Problem description:
emails are not processed automatically, monitoring shows unprocessable mails
via Console (Channel::EmailParser.process_unprocessable_mails) all emails are processed and everything is fine.
Error description in production.log is
E, [2024-04-22T15:13:17.236786#11790-64486020] ERROR – : can’t run postmaster pre filter 0015_postmaster_filter_identify_sender: Channel::Filter::IdentifySender
Hi @mwa. Your post is missing the most interesting part. Next to the error description you’ve posted is the more technical error description. Please post it, otherwise it’s quite hard to help.
Now the next lin the log-file (i could’nt insert more lines because i get an error)
E, [2024-04-22T15:13:17.236810#11790-64486020] ERROR – : #<ActiveRecord::StatementInvalid: PG::InFailedSqlTransaction: ERROR: current transaction is aborted,
commands ignored until end of transaction block
E, [2024-04-22T15:13:17.236956#11790-64486020] ERROR – : Can’t process email, you will find it for bug reporting under …
E, [2024-04-22T15:13:17.236971#11790-64486020] ERROR – : PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
I, [2024-04-22T15:13:16.639562#11790-64486020] INFO – : fetching imap (imap.egr.eu/support-test@easterngraphics.com port=993,ssl=true,starttls=false,folder=INBOX,keep_on_server=true,auth_type=LOGIN)
I, [2024-04-22T15:13:17.043976#11790-64486020] INFO – : - message 1/1
I, [2024-04-22T15:13:17.224067#11790-64486020] INFO – : Process email with msgid ‘trinity-6faec411-c678-4b6e-acdc-306d9e20eb1c-1713791587844@3c-app-gmx-bs41’
E, [2024-04-22T15:13:17.236786#11790-64486020] ERROR – : can’t run postmaster pre filter 0015_postmaster_filter_identify_sender: Channel::Filter::IdentifySender
E, [2024-04-22T15:13:17.236810#11790-64486020] ERROR – : #<ActiveRecord::StatementInvalid: PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
E, [2024-04-22T15:13:17.236956#11790-64486020] ERROR – : Can’t process email, you will find it for bug reporting under /opt/zammad/var/spool/unprocessable_mail/22edd6b4bf26d462a055df00bffbb26a.eml, please create an issue at Issues · zammad/zammad · GitHub
E, [2024-04-22T15:13:17.236971#11790-64486020] ERROR – : PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block
(ActiveRecord::StatementInvalid)
app/models/channel/filter/identify_sender.rb:164:in user_create' app/models/channel/filter/identify_sender.rb:53:in run’
app/models/channel/email_parser.rb:164:in block in _process' app/models/channel/email_parser.rb:161:in each’
app/models/channel/email_parser.rb:161:in _process' app/models/channel/email_parser.rb:125:in block in process’
app/models/channel/email_parser.rb:124:in process' app/models/channel/driver/imap.rb:322:in block in fetch’
app/models/channel/driver/imap.rb:258:in each' app/models/channel/driver/imap.rb:258:in fetch’
app/models/channel.rb:56:in fetch' app/models/channel.rb:30:in fetch’
(eval):1:in eval_job_method' lib/background_services/service/process_scheduled_jobs/job_executor.rb:48:in eval’
lib/background_services/service/process_scheduled_jobs/job_executor.rb:48:in eval_job_method' lib/background_services/service/process_scheduled_jobs/job_executor.rb:23:in execute’
lib/background_services/service/process_scheduled_jobs/job_executor/continuous.rb:16:in block in run_loop' lib/background_services/service/process_scheduled_jobs/job_executor/continuous.rb:15:in times’
lib/background_services/service/process_scheduled_jobs/job_executor/continuous.rb:15:in run_loop' lib/background_services/service/process_scheduled_jobs/job_executor/continuous.rb:8:in run’
lib/background_services/service/process_scheduled_jobs/job_executor.rb:10:in run' lib/background_services/service/process_scheduled_jobs/manager.rb:84:in block in start_in_thread’
lib/application_handle_info.rb:19:in use' lib/background_services/service/process_scheduled_jobs/manager.rb:82:in start_in_thread’
lib/background_services/service/process_scheduled_jobs/manager.rb:73:in block (2 levels) in start' lib/background_services/service/process_scheduled_jobs/manager.rb:72:in block in start’