开启Greenplum DataBase报错:could not bind IPv4 socket: Address already in use

时间:2023-03-09 02:13:24
开启Greenplum DataBase报错:could not bind IPv4 socket: Address already in use

在运行gpstart时无法开启服务,查看日志看到下图所示错误:

开启Greenplum DataBase报错:could not bind IPv4 socket: Address already in use

查看日志错误大概是端口已被占用,所以无法重启。

解决方法:

(1)利用ipcs查看数据库占用的共享内存。(如下图所示)

开启Greenplum DataBase报错:could not bind IPv4 socket: Address already in use

(2)查看数据库进程(ps -ewf|grep gpadmin)

开启Greenplum DataBase报错:could not bind IPv4 socket: Address already in use

(3)手动给postmaster进程发关闭信号:kill -15 5852

(4)现在启动数据库就可以了:gpstart -a

开启Greenplum DataBase报错:could not bind IPv4 socket: Address already in use