Skip site navigation (1) Skip section navigation (2)

Re: does wal archiving block the current client connection?

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: does wal archiving block the current client connection?
Date: 2006-05-19 15:23:11
Message-ID: Pine.LNX.4.64.0605190818350.5387@discord.home.frostconsultingllc.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
On Fri, 19 May 2006, Simon Riggs wrote:

> On Thu, 2006-05-18 at 10:08 -0700, Jeff Frost wrote:
>
>> May 18 08:00:18 discord postgres[20228]: [129-1] LOG:  archived transaction log file "00000001000000000000007F"
>> May 18 08:00:41 discord postgres[20573]: [254-1] LOG:  archived transaction log file "00000001000000000000007F"
>> May 18 08:00:41 discord postgres[20573]: [255-1] WARNING:  could not rename file "pg_xlog/archive_status/00000001000000000000007F.ready" to
>> May 18 08:00:41 discord postgres[20573]: [255-2]  "pg_xlog/archive_status/00000001000000000000007F.done": No such file or directory
>
> I'm not clear how you can have two processes both issuing this message,
> since it is only the archiver process that ever says this.
>
> Do you have two archivers running on this system?
> pid = 20229 and pid = 20573
>
> Presumably pg_xlog/archive_status/00000001000000000000007F.done already
> exists?
>
> Are there two postmasters running (at all)?
> Is there somehow an archiver process running from a previously shutdown
> postmaster (somehow)?

Ah!!  Good catch Simon!  There are in fact two postmasters running on this 
system.  The normal postmaster running in /var/lib/pgsql on port 5432 and this 
test postmaster running on port 55432.  The 8.0.7 postmaster on port 5432 
shows the following for it's archive_command though:

template1=# show archive_command;
  archive_command
-----------------
  unset
(1 row)

and the port 55432 postmaster shows:

template1=# show archive_command;
                    archive_command
------------------------------------------------------
  /usr/local/pgsql-8.1.3/bin/archive_test.sh "%p" "%f"
(1 row)

Do you think the postmaster on 5432 is trying to archive the other 
postmaster's WAL files somehow?

-- 
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954

In response to

Responses

pgsql-hackers by date

Next:From: Mark WoodwardDate: 2006-05-19 15:29:23
Subject: Re: [OT] MySQL is bad, but THIS bad?
Previous:From: Joshua D. DrakeDate: 2006-05-19 15:11:42
Subject: Re: [OT] MySQL is bad, but THIS bad?

pgsql-admin by date

Next:From: Tom LaneDate: 2006-05-19 15:49:18
Subject: Re: does wal archiving block the current client connection?
Previous:From: Simon RiggsDate: 2006-05-19 12:26:33
Subject: Re: does wal archiving block the current client connection?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group