View Issue Details

IDProjectCategoryView StatusLast Update
0000439Pgpool-IIGeneralpublic2018-12-04 10:40
Reporterpio01 Assigned Topengbo  
PriorityurgentSeveritymajorReproducibilityhave not tried
Status closedResolutionopen 
Product Version3.6.12 
Summary0000439: EOF detected while reading pid file
DescriptionDear all,

How I can fixed this error when I want to start the pgpool service?

[root@host-pgpool01 pgpool-II]# cd /var/run/pgpool/
[root@host-pgpool01 pgpool]# ls -lrt
total 0
-rwxrwxrwx. 1 root root 0 Oct 30 02:24 pgpool.pid
[root@host-pgpool01 pgpool]#

[root@host-pgpool01 pgpool-II]# systemctl status pgpool.service
● pgpool.service - Pgpool-II
   Loaded: loaded (/usr/lib/systemd/system/pgpool.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Tue 2018-10-30 02:38:14 EDT; 6min ago
  Process: 12409 ExecStop=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf $STOP_OPTS stop (code=exited, status=3)
  Process: 12407 ExecStart=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf $OPTS (code=exited, status=3)
 Main PID: 12407 (code=exited, status=3)

Oct 30 02:38:14 host-pgpool01.domain.ch systemd[1]: Started Pgpool-II.
Oct 30 02:38:14 host-pgpool01.domain.ch systemd[1]: Starting Pgpool-II...
Oct 30 02:38:14 host-pgpool01.domain.ch pgpool[12407]: [1-1] 2018-10-30 02:38:14: pid 12407: FATAL: EOF detected while reading pid file "/var/run/pgpool/pgpool.pid". reason: Success
Oct 30 02:38:14 host-pgpool01.domain.ch systemd[1]: pgpool.service: main process exited, code=exited, status=3/NOTIMPLEMENTED
Oct 30 02:38:14 host-pgpool01.domain.ch systemd[1]: pgpool.service: control process exited, code=exited status=3
Oct 30 02:38:14 host-pgpool01.domain.ch systemd[1]: Unit pgpool.service entered failed state.
Oct 30 02:38:14 host-pgpool01.domain.ch systemd[1]: pgpool.service failed.
TagsNo tags attached.

Activities

pengbo

2018-11-01 12:43

developer   ~0002232

Last edited: 2018-11-01 12:48

It seems that pid file is 0 byte.
Could you remove this pid file and restart pgpool?

# systemctl stop pgpool
# rm /var/run/pgpool/pgpool.pid
And also if the pgpool socket files (e.g. .s.PGSQL.9898, .s.PGSQL.9999) are left, remove them.

# systemctl start pgpool

pio01

2018-11-01 19:17

reporter   ~0002233

That's right !

Thanks pengbo

Issue History

Date Modified Username Field Change
2018-10-30 15:51 pio01 New Issue
2018-11-01 12:43 pengbo Note Added: 0002232
2018-11-01 12:48 pengbo Note Edited: 0002232
2018-11-01 19:17 pio01 Note Added: 0002233
2018-12-04 10:40 administrator Assigned To => pengbo
2018-12-04 10:40 administrator Status new => closed