Hi there. I didn’t find out why this issue happened. Only backup and format of the filesystem where corrupted postmaster.pid file existed helped to get rid of it. Hopefully the file won’t appear in the future. Best regards, Michal Mistina From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Mistina Michal Hi all. I’m running 2 node pacemaker/pgsql cluster in one technical center TC1 and the second 2 node pacemaker/pgsql cluster in the TC2. After the streaming replication has been established between TC1 (master) and TC2 (slave) I’ve tried to migrate resources within TC1 from node 1 to node 2. Pacemaker operation FAILED to stop resource postgres. However postgresql was stopped but postmaster.pid stayed corrupted. This situation didn’t occur when streaming replication was not established. Why this happened? How am I able to delete corrupted pid file? Standard way of deleting file “rm –f” does not work. It looks like this: [root@tstcaps01 data]# ll ls: cannot access postmaster.pid: No such file or directory total 56 drwx------ 7 postgres postgres 62 Jun 26 17:13 base drwx------ 2 postgres postgres 4096 Aug 17 23:38 global drwx------ 2 postgres postgres 17 Jun 26 09:54 pg_clog -rw------- 1 postgres postgres 5127 Aug 17 16:24 pg_hba.conf -rw------- 1 postgres postgres 1636 Jun 26 09:54 pg_ident.conf drwx------ 2 postgres postgres 4096 Jul 2 00:00 pg_log drwx------ 4 postgres postgres 34 Jun 26 09:53 pg_multixact drwx------ 2 postgres postgres 17 Aug 17 23:38 pg_notify drwx------ 2 postgres postgres 6 Jun 26 09:53 pg_serial drwx------ 2 postgres postgres 6 Jun 26 09:53 pg_snapshots drwx------ 2 postgres postgres 6 Aug 17 23:38 pg_stat_tmp drwx------ 2 postgres postgres 17 Jun 26 09:54 pg_subtrans drwx------ 2 postgres postgres 6 Jun 26 09:53 pg_tblspc drwx------ 2 postgres postgres 6 Jun 26 09:53 pg_twophase -rw------- 1 postgres postgres 4 Jun 26 09:53 PG_VERSION drwx------ 3 postgres postgres 4096 Aug 17 23:38 pg_xlog -rw------- 1 postgres postgres 19884 Aug 17 22:54 postgresql.conf -rw------- 1 postgres postgres 71 Aug 17 23:38 postmaster.opts ?????????? ? ? ? ? ? postmaster.pid -rw-r--r-- 1 postgres postgres 491 Aug 17 16:33 recovery.done Some additional information… [root@tstcaps01 data]# crm_mon -1 ============ Last updated: Sun Aug 18 00:08:04 2013 Last change: Sat Aug 17 23:26:19 2013 via crm_resource on tstcaps01 Stack: openais Current DC: tstcaps02 - partition WITHOUT quorum Version: 1.1.7-6.el6-148fccfd5985c5590cc601123c6c16e966b85d14 2 Nodes configured, 4 expected votes 6 Resources configured. ============ Online: [ tstcaps01 tstcaps02 ] Resource Group: PGServer pg_lvm (ocf::heartbeat:LVM): Started tstcaps01 pg_fs (ocf::heartbeat:Filesystem): Started tstcaps01 pg_lsb (lsb:postgresql-9.2): Started tstcaps01 (unmanaged) FAILED pg_vip (ocf::heartbeat:IPaddr2): Stopped Master/Slave Set: ms_drbd_pg [drbd_pg] Masters: [ tstcaps01 ] Slaves: [ tstcaps02 ] Failed actions: pg_lsb_stop_0 (node=tstcaps01, call=90, rc=-2, status=Timed Out): unknown exec error [root@tstcaps01 data]# rpm -qa | grep postgres postgresql92-9.2.4-1PGDG.rhel6.x86_64 postgresql-libs-8.4.11-1.el6_2.x86_64 postgresql92-libs-9.2.4-1PGDG.rhel6.x86_64 postgresql92-server-9.2.4-1PGDG.rhel6.x86_64 postgresql92-devel-9.2.4-1PGDG.rhel6.x86_64 postgresql92-contrib-9.2.4-1PGDG.rhel6.x86_64 Any help would be appreciated. Best regards, Michal Mistina |
<<attachment: smime.p7s>>
