postalserver / postal

📮 A fully featured open source mail delivery platform for incoming & outgoing e-mail
https://postalserver.io
MIT License
14.91k stars 1.06k forks source link

Pending messages #1094

Closed Bogdan1001 closed 4 years ago

Bogdan1001 commented 4 years ago

Hello, some strange behaviour a new messages marked as "Pending"

How did I tried to fix it:

  1. Purge queue
  2. Created a new server.
  3. Postal restart
  4. Postal auto-upgrade
  5. Delete workers.

Nothing do not help.

The additional info:

$ rabbitmqctl list_connections

Listing connections
postal  127.0.0.1   35782   running
postal  127.0.0.1   35784   running
postal  127.0.0.1   35794   running
postal  127.0.0.1   35822   running
rabbitmqctl list_queues -p /postal

Listing queues
deliver-jobs-outgoing-10    16
deliver-jobs-outgoing-5 0
deliver-jobs-outgoing-2 0
deliver-jobs-main   0
deliver-jobs-outgoing-6 0
deliver-jobs-outgoing-3 0
deliver-jobs-outgoing-4 0
deliver-jobs-outgoing-7 0
deliver-jobs-outgoing-1 0
deliver-jobs-outgoing-9 16
willpower232 commented 4 years ago

You should investigate the database, it might be that the messages are locked by some process. Have you also tried running postal status to ensure everything is running?

Bogdan1001 commented 4 years ago

I cleared the database. I have created a new organization. The test message has been sent successfully. However postal status

 * smtp only has 2 instances (should have 1)
 * smtp.3 is not running (Failed)
|| smtp
|| Quantity            1
|| Command             bundle exec rake postal:smtp_server
|| Respawning          5 every 3600 seconds
|| Restart mode        usr1
|| Log path            none specified
|| Address/Port        none
|| => smtp.2           Stopped                   pid:14646    respawns:0      port:-        tag:-
|| => smtp.3           Failed       21:53        pid:2293     respawns:5      port:-        tag:-
willpower232 commented 4 years ago

If you try running that command yourself, you should see what is causing the problem.

It might be that ruby needs permission to access the port or you may already have something running on port 25.

Bogdan1001 commented 4 years ago

It seems to Ruby listen to the port. Emails are sending now; however, that error does not disappear yet.

$  lsof -i -P -n

COMMAND     PID     USER   FD   TYPE  DEVICE SIZE/OFF NODE NAME
dhclient    604     root    6u  IPv4   12853      0t0  UDP *:68
zabbix_ag   668   zabbix    4u  IPv4   11815      0t0  TCP *:10050 (LISTEN)
zabbix_ag   679   zabbix    4u  IPv4   11815      0t0  TCP *:10050 (LISTEN)
zabbix_ag   680   zabbix    4u  IPv4   11815      0t0  TCP *:10050 (LISTEN)
zabbix_ag   681   zabbix    4u  IPv4   11815      0t0  TCP *:10050 (LISTEN)
zabbix_ag   682   zabbix    4u  IPv4   11815      0t0  TCP *:10050 (LISTEN)
sshd        702     root    3u  IPv4   11976      0t0  TCP *:22 (LISTEN)
sshd        702     root    4u  IPv6   11985      0t0  TCP *:22 (LISTEN)
nginx       785     root    6u  IPv4   13335      0t0  TCP *:80 (LISTEN)
nginx       785     root    7u  IPv6   13336      0t0  TCP *:80 (LISTEN)
nginx       785     root   13u  IPv6   92154      0t0  TCP *:443 (LISTEN)
nginx       785     root   14u  IPv4   92155      0t0  TCP *:443 (LISTEN)
mysqld      933    mysql   21u  IPv4   12204      0t0  TCP 127.0.0.1:3306 (LISTEN)
mysqld      933    mysql   42u  IPv4 6308915      0t0  TCP 127.0.0.1:3306->127.0.0.1:51370 (ESTABLISHED)
mysqld      933    mysql   75u  IPv4 6308919      0t0  TCP 127.0.0.1:3306->127.0.0.1:51374 (ESTABLISHED)
mysqld      933    mysql   76u  IPv4 6308920      0t0  TCP 127.0.0.1:3306->127.0.0.1:51376 (ESTABLISHED)
mysqld      933    mysql   77u  IPv4 6308922      0t0  TCP 127.0.0.1:3306->127.0.0.1:51378 (ESTABLISHED)
mysqld      933    mysql   78u  IPv4 6812447      0t0  TCP 127.0.0.1:3306->127.0.0.1:51860 (ESTABLISHED)
mysqld      933    mysql   79u  IPv4 6284934      0t0  TCP 127.0.0.1:3306->127.0.0.1:51118 (ESTABLISHED)
mysqld      933    mysql   81u  IPv4 6309451      0t0  TCP 127.0.0.1:3306->127.0.0.1:51388 (ESTABLISHED)
mysqld      933    mysql   82u  IPv4 6788806      0t0  TCP 127.0.0.1:3306->127.0.0.1:51802 (ESTABLISHED)
mysqld      933    mysql   99u  IPv4 5465448      0t0  TCP 127.0.0.1:3306->127.0.0.1:50512 (ESTABLISHED)
mysqld      933    mysql  100u  IPv4 6309469      0t0  TCP 127.0.0.1:3306->127.0.0.1:51422 (ESTABLISHED)
sshd       2095     root    3u  IPv4 6284871      0t0  TCP 92.53.120.94:22->213.169.63.9:51832 (ESTABLISHED)
sshd       2095     root    8u  IPv4 6284933      0t0  TCP 127.0.0.1:51118->127.0.0.1:3306 (ESTABLISHED)
ruby2.3    4155   postal    8u  IPv4 6308923      0t0  TCP 127.0.0.1:5000 (LISTEN)
ruby2.3    4155   postal   15u  IPv4 6807866      0t0  TCP 127.0.0.1:51838->127.0.0.1:3306 (CLOSE_WAIT)
ruby2.3    4155   postal   16u  IPv4 6309446      0t0  TCP 127.0.0.1:36912->127.0.0.1:5672 (ESTABLISHED)
ruby       4158   postal    9u  IPv4 6307979      0t0  TCP 127.0.0.1:36898->127.0.0.1:5672 (ESTABLISHED)
ruby       4158   postal   10u  IPv4 6308918      0t0  TCP 127.0.0.1:51374->127.0.0.1:3306 (ESTABLISHED)
ruby       4158   postal   11u  IPv4 6307984      0t0  TCP 127.0.0.1:51376->127.0.0.1:3306 (ESTABLISHED)
ruby       4158   postal   12u  IPv4 6308921      0t0  TCP 127.0.0.1:51378->127.0.0.1:3306 (ESTABLISHED)
ruby       4158   postal   13u  IPv4 6309450      0t0  TCP 127.0.0.1:51388->127.0.0.1:3306 (ESTABLISHED)
ruby       4158   postal   14u  IPv4 6787027      0t0  TCP 127.0.0.1:51802->127.0.0.1:3306 (ESTABLISHED)
ruby       4158   postal   15u  IPv4 6309468      0t0  TCP 127.0.0.1:51422->127.0.0.1:3306 (ESTABLISHED)
ruby2.3    4160   postal   11u  IPv4 6307975      0t0  TCP 127.0.0.1:36894->127.0.0.1:5672 (ESTABLISHED)
ruby2.3    4166   postal    9u  IPv4 6307978      0t0  TCP 127.0.0.1:51370->127.0.0.1:3306 (ESTABLISHED)
ruby2.3    4166   postal   10u  IPv4 6800490      0t0  TCP 127.0.0.1:37338->127.0.0.1:5672 (ESTABLISHED)
nginx      4701 www-data    6u  IPv4   13335      0t0  TCP *:80 (LISTEN)
nginx      4701 www-data    7u  IPv6   13336      0t0  TCP *:80 (LISTEN)
nginx      4701 www-data   13u  IPv6   92154      0t0  TCP *:443 (LISTEN)
nginx      4701 www-data   14u  IPv4   92155      0t0  TCP *:443 (LISTEN)
nginx      4702 www-data    6u  IPv4   13335      0t0  TCP *:80 (LISTEN)
nginx      4702 www-data    7u  IPv6   13336      0t0  TCP *:80 (LISTEN)
nginx      4702 www-data   13u  IPv6   92154      0t0  TCP *:443 (LISTEN)
nginx      4702 www-data   14u  IPv4   92155      0t0  TCP *:443 (LISTEN)
sshd       4788     root    3u  IPv4 6824767      0t0  TCP 92.53.120.94:22->108.59.0.38:1092 (ESTABLISHED)
sshd       4921     root    3u  IPv4 6830439      0t0  TCP 92.53.120.94:22->111.229.137.13:43446 (ESTABLISHED)
sshd       4922     sshd    3u  IPv4 6830439      0t0  TCP 92.53.120.94:22->111.229.137.13:43446 (ESTABLISHED)
sshd       4923     root    3u  IPv4 6830472      0t0  TCP 92.53.120.94:22->159.65.172.240:52256 (ESTABLISHED)
sshd       4924     sshd    3u  IPv4 6830472      0t0  TCP 92.53.120.94:22->159.65.172.240:52256 (ESTABLISHED)
epmd       8631     root    3u  IPv4   35513      0t0  TCP *:4369 (LISTEN)
epmd       8631     root    4u  IPv6   35514      0t0  TCP *:4369 (LISTEN)
epmd       8631     root    5u  IPv4   75250      0t0  TCP 127.0.0.1:4369->127.0.0.1:56042 (ESTABLISHED)
ruby2.3   14077   postal    8u  IPv6   93212      0t0  TCP *:25 (LISTEN)
ruby2.3   14077   postal   35u  IPv4 5464764      0t0  TCP 127.0.0.1:50512->127.0.0.1:3306 (ESTABLISHED)
ruby2.3   14077   postal   36u  IPv4 6815177      0t0  TCP 127.0.0.1:51860->127.0.0.1:3306 (ESTABLISHED)
ruby2.3   14077   postal   37u  IPv4 6323490      0t0  TCP 127.0.0.1:37076->127.0.0.1:5672 (ESTABLISHED)
beam.smp  20591 rabbitmq   45u  IPv4   74414      0t0  TCP *:25672 (LISTEN)
beam.smp  20591 rabbitmq   46u  IPv4   74416      0t0  TCP 127.0.0.1:56042->127.0.0.1:4369 (ESTABLISHED)
beam.smp  20591 rabbitmq   54u  IPv6   75281      0t0  TCP *:5672 (LISTEN)
beam.smp  20591 rabbitmq   55u  IPv6 6308912      0t0  TCP 127.0.0.1:5672->127.0.0.1:36894 (ESTABLISHED)
beam.smp  20591 rabbitmq   56u  IPv6 6308916      0t0  TCP 127.0.0.1:5672->127.0.0.1:36898 (ESTABLISHED)
beam.smp  20591 rabbitmq   57u  IPv6 6309447      0t0  TCP 127.0.0.1:5672->127.0.0.1:36912 (ESTABLISHED)
beam.smp  20591 rabbitmq   58u  IPv6 6323491      0t0  TCP 127.0.0.1:5672->127.0.0.1:37076 (ESTABLISHED)
beam.smp  20591 rabbitmq   59u  IPv6 6800041      0t0  TCP 127.0.0.1:5672->127.0.0.1:37338 (ESTABLISHED)
willpower232 commented 4 years ago

If you try running that command yourself, you should see what is causing the problem.

You could also look in the log files to see what is happening.

eclanwide commented 4 years ago

When I check my postal status.

Here is an error. How do I resolve this error message below.

willpower232 commented 4 years ago

@eclanwide you will need to follow what I said in the previous posts above yours to get an actual error message, if you need further help, I suggest you open a new issue.

eclanwide commented 4 years ago

root@server:~# postal status Procodile Version 1.0.26 Application Root /opt/postal/app Supervisor PID 1712 Started 2020-06-12 17:08:46 +0200

|| web || Quantity 1 || Command bundle exec puma -C config/puma.rb || Respawning 5 every 3600 seconds || Restart mode usr1 || Log path none specified || Address/Port none || => web.1 Running 17:08 pid:1718 respawns:0 port:- tag:-

|| worker || Quantity 1 || Command bundle exec ruby script/worker.rb || Respawning 5 every 3600 seconds || Restart mode start-term || Log path none specified || Address/Port none || => worker.1 Failed 17:11 pid:1872 respawns:5 port:- tag:-

|| cron || Quantity 1 || Command bundle exec rake postal:cron || Respawning 5 every 3600 seconds || Restart mode term-start || Log path none specified || Address/Port none || => cron.1 Running 17:08 pid:1722 respawns:0 port:- tag:-

|| smtp || Quantity 1 || Command bundle exec rake postal:smtp_server || Respawning 5 every 3600 seconds || Restart mode usr1 || Log path none specified || Address/Port none || => smtp.1 Running 17:08 pid:1724 respawns:0 port:- tag:-

|| requeuer || Quantity 1 || Command bundle exec rake postal:requeuer || Respawning 5 every 3600 seconds || Restart mode term-start || Log path none specified || Address/Port none || => requeuer.1 Failed 17:10 pid:1865 respawns:5 port:- tag:- root@server:~#