This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Mails in filesystem spool folder - not showing in Mail Manager

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

This thread was automatically locked due to age.

Parents

0 FormerMember over 2 years ago

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,
Cancel
Vote Up 0 Vote Down

Cancel

0 UTMaddict over 2 years ago in reply to FormerMember

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 postgres  6124  0.0  0.0 2215252 5212 ? postgres  6266  0.0  0.0 2214972 3772 ? postgres  6339  0.0  0.0 2215160 7500 ? postgres  7104  0.0  0.1 2217012 23516 ? postgres 10541  0.0  0.0 2215140 6736 ? postgres 10812  0.0  0.0 2214836 4776 ? postgres 12774  0.0  0.0 2215128 7012 ? root     14657  0.0  0.0   5672   752 pts/0 postgres 16938  0.0  0.0 2214964 5628 ? postgres 16940  0.0  0.0 2214964 5636 ? postgres 16944  0.0  0.0 2217392 7268 ? postgres 16945  0.0  0.0 2214972 4836 ? postgres 16977 14.7  5.0 2217824 613524 ? postgres 16996  0.0  0.0 2215068 6340 ? postgres 17006  0.0  0.0 2215068 6344 ? postgres 17572  0.0  0.0 2215032 6764 ? postgres 17579  0.0  0.0 2214968 5660 ? postgres 18210  0.0  0.0   6912   428 ? postgres 19774  0.0  0.5 2210544 62128 ? postgres 20063  0.0 13.0 2211920 1590864 ? postgres 20064  0.0  0.1 2211572 14156 ? postgres 20065  0.0  0.1 2211572 17076 ? postgres 20066  0.0  0.0 2212712 1952 ? postgres 20067  0.0  0.0  26928   600 ? postgres 20068  0.0  0.0  27368   936 ? postgres 20131  0.0  0.1 2215276 23448 ? postgres 20154  0.0  0.1 2217488 23424 ? postgres 20230  0.0  0.1 2215060 15872 ? postgres 20344  0.0  0.4 2216312 59564 ? postgres 20693  0.0  0.0 2214964 3772 ? postgres 20695  0.0  0.2 2215268 31404 ? postgres 21328  0.1  0.0 2215128 7452 ? postgres 22561  0.0  0.0 2215160 7032 ? postgres 23484  0.0  0.0 2214840 2304 ? postgres 23485  0.0  0.2 2215248 29468 ? postgres 23561  0.0  0.1 2215060 15456 ? postgres 23565  0.0  0.0 2215096 5456 ? postgres 24695  0.0  0.0 2212548 1872 ?

4471  0.0  0.0  15256  6244 ?        Ss   Mar08   1:17 /usr/local/bin/repctl Ss   Apr22   0:00 postgres: pop3 pop3 127.0.0.1(58130) idle Ss   Mar25   0:00 postgres: sandbox sandbox 127.0.0.1(59694) idle Ss   May06   0:01 postgres: hotspot hotspot 127.0.0.1(44179) idle Ss   Apr22   0:05 postgres: smtp smtp 127.0.0.1(54690) idle Ss   May06   0:00 postgres: hotspot hotspot 127.0.0.1(44326) idle Ss   09:19   0:00 postgres: repmgr repmgr 198.19.250.2(57795) idle Ss   09:20   0:00 postgres: smtp smtp 127.0.0.1(42922) idle S+   09:21   0:00 grep postgres Ss   01:02   0:00 postgres: smtp smtp [local] idle Ss   01:02   0:00 postgres: smtp smtp [local] idle Ss   01:02   0:00 postgres: reporting reporting [local] idle Ss   01:02   0:00 postgres: reporting reporting [local] idle Ss   01:02  73:45 postgres: reporting reporting [local] idle Ss   01:02   0:00 postgres: hotspot hotspot [local] idle Ss   01:02   0:00 postgres: hotspot hotspot [local] idle Ss   01:03   0:00 postgres: sandbox sandbox [local] idle Ss   01:03   0:00 postgres: sandbox sandbox [local] idle Ss   Mar17   0:00 /usr/bin/rsync --daemon --config /var/lib/postgresql/rsyncd.conf S    Mar17   4:11 /usr/pgsql92-64/bin/postgres -D /var/storage/pgsql92/data Ss   Mar17  47:23 postgres: checkpointer process Ss   Mar17   0:41 postgres: writer process Ss   Mar17  35:45 postgres: wal writer process Ss   Mar17   5:24 postgres: autovacuum launcher process Ss   Mar17   0:24 postgres: archiver process   last was 000000010000044D0000009B Ss   Mar17  26:33 postgres: stats collector process Ss   Mar17   6:17 postgres: hotspot hotspot 127.0.0.1(48167) idle Ss   01:07   0:01 postgres: reporting reporting [local] idle Ss   Mar17   0:30 postgres: smtp smtp 127.0.0.1(48184) idle Ss   Mar17   2:26 postgres: smtp smtp 127.0.0.1(48190) idle Ss   Mar17   0:00 postgres: sandbox sandbox 198.19.250.1(37577) idle Ss   Mar17   3:18 postgres: sandbox sandbox 198.19.250.1(37578) idle Ss   00:15   0:40 postgres: smtp smtp 198.19.250.2(54573) idle Ss   Apr23   0:01 postgres: hotspot hotspot 127.0.0.1(59913) idle Ss   Mar17   0:00 postgres: sandbox sandbox 198.19.250.2(37031) idle Ss   Mar17   3:24 postgres: sandbox sandbox 198.19.250.2(37032) idle Ss   Mar17   0:30 postgres: smtp smtp 198.19.250.2(37035) idle Ss   Mar17   0:00 postgres: smtp smtp 198.19.250.2(37037) idle Ss   Mar17  35:36 postgres: wal sender process repmgr 198.19.250.2(37078) streaming 44D/9C76E000

Regards

UTM_addict

Reply

0 UTMaddict over 2 years ago in reply to FormerMember

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

Regards

UTM_addict

Children

No Data