Cluster issue Muthoot: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
[[category:Muthoot | [[category:Muthoot group]] | ||
If Muthoot HRMS (https://muthootonline.in/) page is opening but not able to login, then please check postgres status and try to login in | If Muthoot HRMS (https://muthootonline.in/) page is opening but not able to login, then please check postgres status and try to login in | ||
Latest revision as of 11:59, 15 October 2015
If Muthoot HRMS (https://muthootonline.in/) page is opening but not able to login, then please check postgres status and try to login in
DB .If not able to login if postgre then frist check cluster service by below command:
Login on Database server(Local ip 192.168.1.133 node1)
[root@liveserver ~]# clustat
Cluster Status for Muthoot_cluster @ Thu Oct 15 12:36:08 2015 Member Status: Quorate
Member Name ID Status ------ ---- ---- ------ node1 1 Online, Local, rgmanager node2 2 Online, rgmanager Service Name Owner (Last) State ------- ---- ----- ------ ----- service:Cluster-Service (node2) failed
If State is failed then run below command to disable the cluster service:
clusvcadm -d Cluster-Service
Again run below command to check cluster status:
[root@liveserver ~]# clustat
Cluster Status for Muthoot_cluster @ Thu Oct 15 12:38:12 2015 Member Status: Quorate
Member Name ID Status ------ ---- ---- ------ node1 1 Online, Local, rgmanager node2 2 Online, rgmanager Service Name Owner (Last) State ------- ---- ----- ------ ----- service:Cluster-Service (node2) Disabled
After that enable cluster service on node1 by below command:
clusvcadm -e Cluster-Service -m node1
Again run below command to check cluster status:
[root@liveserver ~]# clustat
Cluster Status for Muthoot_cluster @ Thu Oct 15 12:45:12 2015 Member Status: Quorate
Member Name ID Status ------ ---- ---- ------ node1 1 Online, Local, rgmanager node2 2 Online, rgmanager Service Name Owner (Last) State ------- ---- ----- ------ ----- service:Cluster-Service node1 started
Now please run below commands to ensure if every thing is OK:
[root@liveserver ~]# ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: usb0: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN qlen 1000
link/ether 36:40:b5:ad:d4:73 brd ff:ff:ff:ff:ff:ff
3: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000
link/ether 34:40:b5:aa:e5:a8 brd ff:ff:ff:ff:ff:ff
inet 192.168.1.133/24 brd 192.168.1.255 scope global eth0
inet 192.168.1.140/24 scope global secondary eth0
inet6 fe80::3640:b5ff:feaa:e5a8/64 scope link
valid_lft forever preferred_lft forever
4: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000
link/ether 34:40:b5:aa:e5:aa brd ff:ff:ff:ff:ff:ff
inet 10.0.0.1/24 brd 10.0.0.255 scope global eth1
inet6 fe80::3640:b5ff:feaa:e5aa/64 scope link
valid_lft forever preferred_lft forever
[root@liveserver ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup-LogVol01 99G 68G 26G 73% /
tmpfs 16G 26M 16G 1% /dev/shm
/dev/sdd1 1008M 62M 895M 7% /boot
/dev/mapper/VolGroup-LogVol02 197G 150G 38G 80% /home
/dev/mapper/DB-test 97G 17G 75G 19% /Database
/dev/mapper/LogsSpace-LogSystem 195G 111G 75G 60% /var/lib/pgsql
[root@liveserver ~]# ps -ef | grep postgres
postgres 1725 32729 46 15:27 ? 00:17:29 postgres: postgres muthoot_test 192.168.1.130(47221) idle
postgres 6572 32729 0 16:04 ? 00:00:00 postgres: postgres muthoot_test 192.168.1.130(49492) idle
root 7407 6573 0 16:04 pts/0 00:00:00 grep postgres
postgres 9772 32729 41 14:38 ? 00:35:40 postgres: postgres muthoot_test 192.168.1.130(44132) SELECT
postgres 11070 32729 52 15:32 ? 00:17:05 postgres: postgres muthoot_test 192.168.1.130(47473) idle
postgres 11539 32729 24 15:32 ? 00:07:57 postgres: postgres muthoot_test 192.168.1.130(47475) idle
postgres 11542 32729 46 15:32 ? 00:15:11 postgres: postgres muthoot_test 192.168.1.130(47476) SELECT
postgres 11543 32729 47 15:32 ? 00:15:22 postgres: postgres muthoot_test 192.168.1.130(47477) SELECT
postgres 12137 32729 37 12:51 ? 01:12:30 postgres: postgres muthoot_test 192.168.1.130(37016) SELECT
postgres 13553 32729 53 13:28 ? 01:23:08 postgres: postgres muthoot_test 192.168.1.130(39619) SELECT
postgres 13578 32729 43 12:52 ? 01:23:07 postgres: postgres muthoot_test 192.168.1.130(37087) SELECT
postgres 15933 32729 37 14:41 ? 00:31:32 postgres: postgres muthoot_test 192.168.1.130(44303) idle
postgres 16240 32729 38 13:47 ? 00:52:21 postgres: postgres muthoot_test 192.168.1.130(40982) SELECT