Wednesday, December 21, 2011

Postgresql - pgpool, bind(/tmp/.s.PGSQL.9898) failed. reason: Address already in use

When starting pgpool from pgadmin I got this message in the log file, then tried to remove the file in question, linux said: "hey it ain't such file", tried again, fired pgpool up , and there you go.

I'm adopting as temporary solution to delete that file at startup (nevertheless linux say's it doesn't exist).

rene@linux-2561:~> cat /var/log/pgpool/pgpool.log
2011-12-21 10:35:37 LOG:   pid 3531: Backend status file /var/log/pgpool//pgpool_status discarded
2011-12-21 10:35:37 LOG:   pid 3531: pgpool-II successfully started. version 3.1.1 (hatsuiboshi)
2011-12-21 10:35:37 ERROR: pid 3531: bind(/tmp/.s.PGSQL.9898) failed. reason: Address already in use
rene@linux-2561:~> sudo rm /tmp/.s.PGSQL.9898
rm: cannot remove `/tmp/.s.PGSQL.9898': No such file or directory
rene@linux-2561:~> cat /var/log/pgpool/pgpool.log
2011-12-21 10:37:15 LOG:   pid 3651: Backend status file /var/log/pgpool//pgpool_status discarded
2011-12-21 10:37:15 LOG:   pid 3651: pgpool-II successfully started. version 3.1.1 (hatsuiboshi)
2011-12-21 10:37:15 LOG:   pid 3651: find_primary_node: primary node id is 0


I'm sending this one to the mailing list.

No comments:

Post a Comment