Hello,
I monitor the SMTP proxy spool folders with a simple script which counts the mails on the filesystem.
This works good but from time to time the spool folder has mails in it which get not counted by the Mail Manager only on filesystem basis.
What could be the problem for this? Any ideas?
Regards
UTMaddict
Hi UTMaddict,
Thanks for reaching out to the Communiuty!
What is the firmware version on your UTM? Did you see any database errors in the system logs?
Can you share the output of the command: ps aux | grep postgres
Thanks,
Hello H_Patel,
We are using version 9.705-3.
Can't see any database errors in the timeframe since the mail is in the spool folder...
This is the output of ps aux:
postgres 4471 0.0 0.0 15256 6244 ? Ss Mar08 1:17 /usr/local/bin/repctl postgres 6124 0.0 0.0 2215252 5212 ? Ss Apr22 0:00 postgres: pop3 pop3 127.0.0.1(58130) idle postgres 6266 0.0 0.0 2214972 3772 ? Ss Mar25 0:00 postgres: sandbox sandbox 127.0.0.1(59694) idle postgres 6339 0.0 0.0 2215160 7500 ? Ss May06 0:01 postgres: hotspot hotspot 127.0.0.1(44179) idle postgres 7104 0.0 0.1 2217012 23516 ? Ss Apr22 0:05 postgres: smtp smtp 127.0.0.1(54690) idle postgres 10541 0.0 0.0 2215140 6736 ? Ss May06 0:00 postgres: hotspot hotspot 127.0.0.1(44326) idle postgres 10812 0.0 0.0 2214836 4776 ? Ss 09:19 0:00 postgres: repmgr repmgr 198.19.250.2(57795) idle postgres 12774 0.0 0.0 2215128 7012 ? Ss 09:20 0:00 postgres: smtp smtp 127.0.0.1(42922) idle root 14657 0.0 0.0 5672 752 pts/0 S+ 09:21 0:00 grep postgres postgres 16938 0.0 0.0 2214964 5628 ? Ss 01:02 0:00 postgres: smtp smtp [local] idle postgres 16940 0.0 0.0 2214964 5636 ? Ss 01:02 0:00 postgres: smtp smtp [local] idle postgres 16944 0.0 0.0 2217392 7268 ? Ss 01:02 0:00 postgres: reporting reporting [local] idle postgres 16945 0.0 0.0 2214972 4836 ? Ss 01:02 0:00 postgres: reporting reporting [local] idle postgres 16977 14.7 5.0 2217824 613524 ? Ss 01:02 73:45 postgres: reporting reporting [local] idle postgres 16996 0.0 0.0 2215068 6340 ? Ss 01:02 0:00 postgres: hotspot hotspot [local] idle postgres 17006 0.0 0.0 2215068 6344 ? Ss 01:02 0:00 postgres: hotspot hotspot [local] idle postgres 17572 0.0 0.0 2215032 6764 ? Ss 01:03 0:00 postgres: sandbox sandbox [local] idle postgres 17579 0.0 0.0 2214968 5660 ? Ss 01:03 0:00 postgres: sandbox sandbox [local] idle postgres 18210 0.0 0.0 6912 428 ? Ss Mar17 0:00 /usr/bin/rsync --daemon --config /var/lib/postgresql/rsyncd.conf postgres 19774 0.0 0.5 2210544 62128 ? S Mar17 4:11 /usr/pgsql92-64/bin/postgres -D /var/storage/pgsql92/data postgres 20063 0.0 13.0 2211920 1590864 ? Ss Mar17 47:23 postgres: checkpointer process postgres 20064 0.0 0.1 2211572 14156 ? Ss Mar17 0:41 postgres: writer process postgres 20065 0.0 0.1 2211572 17076 ? Ss Mar17 35:45 postgres: wal writer process postgres 20066 0.0 0.0 2212712 1952 ? Ss Mar17 5:24 postgres: autovacuum launcher process postgres 20067 0.0 0.0 26928 600 ? Ss Mar17 0:24 postgres: archiver process last was 000000010000044D0000009B postgres 20068 0.0 0.0 27368 936 ? Ss Mar17 26:33 postgres: stats collector process postgres 20131 0.0 0.1 2215276 23448 ? Ss Mar17 6:17 postgres: hotspot hotspot 127.0.0.1(48167) idle postgres 20154 0.0 0.1 2217488 23424 ? Ss 01:07 0:01 postgres: reporting reporting [local] idle postgres 20230 0.0 0.1 2215060 15872 ? Ss Mar17 0:30 postgres: smtp smtp 127.0.0.1(48184) idle postgres 20344 0.0 0.4 2216312 59564 ? Ss Mar17 2:26 postgres: smtp smtp 127.0.0.1(48190) idle postgres 20693 0.0 0.0 2214964 3772 ? Ss Mar17 0:00 postgres: sandbox sandbox 198.19.250.1(37577) idle postgres 20695 0.0 0.2 2215268 31404 ? Ss Mar17 3:18 postgres: sandbox sandbox 198.19.250.1(37578) idle postgres 21328 0.1 0.0 2215128 7452 ? Ss 00:15 0:40 postgres: smtp smtp 198.19.250.2(54573) idle postgres 22561 0.0 0.0 2215160 7032 ? Ss Apr23 0:01 postgres: hotspot hotspot 127.0.0.1(59913) idle postgres 23484 0.0 0.0 2214840 2304 ? Ss Mar17 0:00 postgres: sandbox sandbox 198.19.250.2(37031) idle postgres 23485 0.0 0.2 2215248 29468 ? Ss Mar17 3:24 postgres: sandbox sandbox 198.19.250.2(37032) idle postgres 23561 0.0 0.1 2215060 15456 ? Ss Mar17 0:30 postgres: smtp smtp 198.19.250.2(37035) idle postgres 23565 0.0 0.0 2215096 5456 ? Ss Mar17 0:00 postgres: smtp smtp 198.19.250.2(37037) idle postgres 24695 0.0 0.0 2212548 1872 ? Ss Mar17 35:36 postgres: wal sender process repmgr 198.19.250.2(37078) streaming 44D/9C76E000
UTM_addict