1 (edited by kadu137 2012-06-03 00:11:42)

Topic: postgresql ending unexpectedly. [Iredmail 0.8.0]

==== Provide required information ====
- iRedMail version and backend (PGSQL):
- Linux/CentOS 6.2
- Iredmail 0.8.0
====



Good morning,
My IREDMAIL server service postgresql ended today at 4.10 am unexpectedly.

He is in production and is the principal of our network.
The following log at the moment:

************************************************** *************************************
Postgres log: cat postgresql-Sat.log

LOG: unexpected EOF while connected to the customer £
LOG: unexpected EOF while connected to the customer £
LOG: unexpected EOF while connected to the customer £
LOG: database system was interrupted; last one Execution on 6/2/2012 4:10:12 ET
LOG: database system in the £ was properly shut down; Recovery automatic is in progress
LOG: redo starts at 0/5338248
LOG: record with zero length in 0/5360A30
LOG: redo done in 0/53609F0
LOG: last one transation was effected on 02.06.2012 04:12:19.373534-03
LOG: database system're ready to accept incoming connections
LOG: autovacuum launcher started the
LOG: unexpected EOF while connected to the customer £
LOG: unexpected EOF while connected to the customer £
LOG: unexpected EOF while connected to the customer £
LOG: unexpected EOF while connected to the customer £
************************************************** ************************************



Dovecot log:
************************************************** ************************************
Jun 02 04:11:32 pop3(jacomoura@xxxx.xxxx.xx): Info: Disconnected: Logged out top=0/0, retr=0/0, del=0/0, size=0
Jun 02 04:12:13 pop3-login: Info: Login: user=<pedroaquino@xxxx.xxxx.xx>, method=PLAIN, rip=187.40.137.1, lip=200.137.4.2, mpid=21119, TLS
Jun 02 04:12:19 pop3(pedroaquino@xxxx.xxxx.xx): Info: Disconnected: Logged out top=0/0, retr=0/0, del=0/3, size=14214
Jun 02 04:19:08 auth: Error: pgsql(127.0.0.1): Connect failed to database vmail: could not connect to server: Connection refused
Jun 02 04:19:08 auth: Error:    Is the server running on host "127.0.0.1" and accepting
Jun 02 04:19:08 auth: Error:    TCP/IP connections on port 5432?
Jun 02 04:19:09 auth: Error: pgsql(127.0.0.1): Connect failed to database vmail: could not connect to server: Connection refused
Jun 02 04:19:09 auth: Error:    Is the server running on host "127.0.0.1" and accepting
Jun 02 04:19:09 auth: Error:    TCP/IP connections on port 5432?
Jun 02 04:19:14 auth: Error: pgsql(127.0.0.1): Connect failed to database vmail: could not connect to server: Connection refused
Jun 02 04:19:14 auth: Error:    Is the server running on host "127.0.0.1" and accepting
Jun 02 04:19:14 auth: Error:    TCP/IP connections on port 5432?
Jun 02 04:19:39 auth: Error: pgsql(127.0.0.1): Connect failed to database vmail: could not connect to server: Connection refused
Jun 02 04:19:39 auth: Error:    Is the server running on host "127.0.0.1" and accepting
Jun 02 04:19:39 auth: Error:    TCP/IP connections on port 5432?
Jun 02 04:19:48 pop3(pedroaquino@xxxx.xxxx.xx): Info: Disconnected: Logged out top=0/0, retr=0/0, del=0/3, size=14214
Jun 02 04:19:50 auth: Error: pgsql(127.0.0.1): Connect failed to database vmail: could not connect to server: Connection refused
Jun 02 04:19:50 auth: Error:    Is the server running on host "127.0.0.1" and accepting
Jun 02 04:19:50 auth: Error:    TCP/IP connections on port 5432?
Jun 02 04:19:51 auth: Error: pgsql(127.0.0.1): Connect failed to database vmail: could not connect to server: Connection refused
Jun 02 04:19:51 auth: Error:    Is the server running on host "127.0.0.1" and accepting
Jun 02 04:19:51 auth: Error:    TCP/IP connections on port 5432?
************************************************** ************************************

Httpd Log
***************************************************************************************
187.40.137.1 - - [02/Jun/2012:04:06:55 -0300] "GET /webmail/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1338631628130 HTTP/1.1" 200 77 "http://mail.crn
2.dom.br/webmail/?_task=mail" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5"
187.40.137.1 - - [02/Jun/2012:04:07:55 -0300] "GET /webmail/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1338631688131 HTTP/1.1" 200 77 "http://mail.crn
2.dom.br/webmail/?_task=mail" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5"
187.40.137.1 - - [02/Jun/2012:04:08:55 -0300] "GET /webmail/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1338631748132 HTTP/1.1" 200 77 "http://mail.crn
2.dom.br/webmail/?_task=mail" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5"
187.40.137.1 - - [02/Jun/2012:04:09:55 -0300] "GET /webmail/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1338631808133 HTTP/1.1" 200 77 "http://mail.crn
2.dom.br/webmail/?_task=mail" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5"
187.40.137.1 - - [02/Jun/2012:04:10:55 -0300] "GET /webmail/?_task=mail&_action=check-recent&_mbox=INBOX&_list=1&_quota=1&_remote=1&_unlock=0&_=1338631868133 HTTP/1.1" 200 109 "http://mail.cr
n2.dom.br/webmail/?_task=mail" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5"
187.40.137.1 - - [02/Jun/2012:04:10:57 -0300] "GET /webmail/?_task=login&_err=session HTTP/1.1" 200 3441 "http://mail.dominio.dom.br/webmail/?_task=mail" "Mozilla/5.0 (Windows NT 6.1; WOW64) Ap
pleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5"
187.40.137.1 - - [02/Jun/2012:04:10:58 -0300] "GET /webmail/skins/default/images/logo_centralizado3.png HTTP/1.1" 304 - "http://mail.dominio.dom.br/webmail/?_ta … rr=session" "Mozilla/5
.0 (Windows NT 6.1; WOW64) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.52 Safari/536.5"
199.21.99.84 - - [02/Jun/2012:04:35:58 -0300] "GET / HTTP/1.1" 200 98 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
95.108.150.235 - - [02/Jun/2012:04:36:12 -0300] "GET /robots.txt HTTP/1.1" 200 189 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
95.108.150.235 - - [02/Jun/2012:04:36:12 -0300] "GET /robots.txt HTTP/1.1" 200 189 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
95.108.150.235 - - [02/Jun/2012:04:36:13 -0300] "GET / HTTP/1.1" 200 98 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
95.108.150.235 - - [02/Jun/2012:04:36:13 -0300] "GET / HTTP/1.1" 200 98 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
95.108.150.235 - - [02/Jun/2012:04:36:14 -0300] "GET /mail/ HTTP/1.1" 200 930 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
95.108.150.235 - - [02/Jun/2012:04:36:14 -0300] "GET /mail/ HTTP/1.1" 200 930 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
95.108.150.235 - - [02/Jun/2012:04:36:15 -0300] "GET /mail/ HTTP/1.1" 200 930 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
95.108.150.235 - - [02/Jun/2012:04:36:15 -0300] "GET /mail/ HTTP/1.1" 200 930 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
221.0.141.131 - - [02/Jun/2012:05:06:58 -0300] "GET http://www.sciencedirect.com/science/browse HTTP/1.1" 404 319 "-" "Mozilla/4.0 (compatible; MSIE 4.01; Windows 98)"
189.51.99.170 - - [02/Jun/2012:06:11:29 -0300] "HEAD / HTTP/1.0" 200 - "-" "-"
199.21.99.84 - - [02/Jun/2012:06:50:50 -0300] "GET / HTTP/1.1" 200 98 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
187.40.255.191 - - [02/Jun/2012:07:18:44 -0300] "GET /webmail/?_task=mail&_mbox=INBOX HTTP/1.1" 200 1017 "http://mail.dominio.dom.br/webmail/?_ta … on=folders" "Mozilla/5.0 (iPad;
CPU OS 5_1_1 like Mac OS X) AppleWebKit/534.46 (KHTML, like Gecko) Version/5.1 Mobile/9B206 Safari/7534.48.3"
187.40.255.191 - - [02/Jun/2012:07:19:04 -0300] "GET /webmail/ HTTP/1.1" 200 1017 "-" "Mozilla/5.0 (iPad; CPU OS 5_1_1 like Mac OS X) AppleWebKit/534.46 (KHTML, like Gecko) Version/5.1 Mobile
/9B206 Safari/7534.48.3"
187.40.255.191 - - [02/Jun/2012:07:19:10 -0300] "GET /webmail/ HTTP/1.1" 200 1017 "-" "Mozilla/5.0 (iPad; CPU OS 5_1_1 like Mac OS X) AppleWebKit/534.46 (KHTML, like Gecko) Version/5.1 Mobile
/9B206 Safari/7534.48.3"
187.40.255.191 - - [02/Jun/2012:07:19:10 -0300] "GET /webmail/skins/default/safari.css?s=1274168371 HTTP/1.1" 304 - "http://mail.dominio.dom.br/webmail/" "Mozilla/5.0 (iPad; CPU OS 5_1_1 like M
ac OS X) AppleWebKit/534.46 (KHTML, like Gecko) Version/5.1 Mobile/9B206 Safari/7534.48.3"
187.40.255.191 - - [02/Jun/2012:07:19:11 -0300] "GET /webmail/skins/default/common.css?s=1330947632 HTTP/1.1" 304 - "http://mail.dominio.dom.br/webmail/" "Mozilla/5.0 (iPad; CPU OS 5_1_1 like M
ac OS X) AppleWebKit/534.46 (KHTML, like Gecko) Version/5.1 Mobile/9B206 Safari/7534.48.3"
187.40.255.191 - - [02/Jun/2012:07:19:12 -0300] "GET /webmail/skins/default/images/roundcube_logo.png HTTP/1.1" 304 - "http://mail.dominio.dom.br/webmail/" "Mozilla/5.0 (iPad; CPU OS 5_1_1 like
Mac OS X) AppleWebKit/534.46 (KHTML, like Gecko) Version/5.1 Mobile/9B206 Safari/7534.48.3"
***************************************************************************************


Please, I need your help!

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: postgresql ending unexpectedly. [Iredmail 0.8.0]

kadu137 wrote:

LOG: unexpected EOF while connected to the customer £

No idea at all, sorry.

Does restarting PostgreSQL service fix it?