View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000439 | Pgpool-II | General | public | 2018-10-30 15:51 | 2018-12-04 10:40 |
| Reporter | pio01 | Assigned To | pengbo | ||
| Priority | urgent | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | open | ||
| Product Version | 3.6.12 | ||||
| Summary | 0000439: EOF detected while reading pid file | ||||
| Description | Dear 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. | ||||
| Tags | No tags attached. | ||||
|
|
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 |
|
|
That's right ! Thanks pengbo |
| 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 |