Missing SPAM reports

Feb 21, 2022
Since the upgrade to 7.3.6

root@pmg1:~# pmgreport -debug 1
DBD::pg::db do failed: ERROR: cannot cast type timestamp with time zone to integer
LINE 1: ...Count = Count + 1,MTime = EXTRACT(EPOCH FROM now()::INTEGER)...
^ at /usr/share/perl5/PMG/Statistic.pm line 109.

Any thought?
Others (me included) reported this issue in a different ticket ("After succesfully upgrade to v8 error on pmg-smtp-filter") related to the PMG 8.0 upgrade but you are right, our logs show that this issue must have started with the 7.3-6 upgrade, not as part of the 8.0 upgrade (which we did 2 days later).
Spam quarantine page is empty in GUI, while there are some messages in /var/spool/pmg/spam

>ls -al /var/spool/pmg/spam
total 16
drwxr-xr-x 4 root root 4096 Jul 3 15:34 .
drwxr-xr-x 6 root root 4096 Jun 29 22:05 ..
drwxr-xr-x 2 root root 4096 Jul 3 15:34 41
drwxr-xr-x 2 root root 4096 Jul 2 15:13 8E

pmgversion -v
proxmox-mailgateway: 8.0.0 (API: 8.0.4/d649469164b3, running kernel: 6.2.16-3-pve)
pmg-api: 8.0.4
pmg-gui: 4.0.2
pve-kernel-6.2: 8.0.2
pve-kernel-6.2.16-3-pve: 6.2.16-3
clamav-daemon: 1.0.1+dfsg-2
ifupdown2: 3.2.0-1+pmx3
libarchive-perl: 3.6.2
libjs-extjs: 7.0.0-3
libjs-framework7: 4.4.7-2
libproxmox-acme-perl: 1.4.6
libproxmox-acme-plugins: 1.4.6
libpve-apiclient-perl: 3.3.0
libpve-common-perl: 8.0.6
libpve-http-server-perl: 5.0.4
libxdgmime-perl: 1.1.0
lvm2: 2.03.16-2
pmg-docs: 8.0.1
pmg-i18n: 3.0.5
pmg-log-tracker: 2.4.1
proxmox-mini-journalreader: 1.4.0
proxmox-offline-mirror-helper: 0.6.2
proxmox-spamassassin: 4.0.0-4
proxmox-widget-toolkit: 4.0.6
pve-firmware: 3.7-1
pve-xtermjs: 4.16.0-3
zfsutils-linux: 2.1.12-pve1
Spam quarantine page is empty in GUI, while there are some messages in /var/spool/pmg/spam
Yes this is perfectly possible.
a) you just showed the first level of directories in the spamquarantine (the quarantined mails are put in many subdirectories to not have a directory with too many files, which usually slows access to files and metadata quite a lot (most MTA daemons also split their spool directories) - if you want to find out which and how many files are still on disk - try `find /var/spool/pmg/spam`
b) You need to take into account that the spam-quarantine can be empty for one user, while still having messages for another (although nowadays you can select 'all' as mailbox to see the quarantine of all users
c) cleanup of the quarantine happens lazily after the quarantine life-time expires - if you click on deliver/delete the mail is only marked as deleted in the database - the actual removal of the file happens after it is past the lifetime (in the `pmgqm purge` invocation done by the pmgspamreport.timer)

I hope this explains it!
Thanks for hint, I indeed had to select mailbox to see list of messages.


The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!