pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLingering Checkpoint Process
3+ messages / 2 participants
[nested] [flat]
* Lingering Checkpoint Process
@ 2005-02-23 16:28 Cory Vokey <cvokey@rim.com>
2005-02-23 18:12 ` Re: Lingering Checkpoint Process Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Cory Vokey @ 2005-02-23 16:28 UTC (permalink / raw)
To: pgsql-admin
Hi all, I'm seeing a checkpoint process lingering around for ~ 24hrs on
one of my test systems and WAL logs are accumulating. It's running
postgres 7.4.6.
Research up to date indicates faulty memory or disks.
Has anyone else seen this behavior? Previously, I had to re-init the DB
for this to go away, but this is obviously not the permanent solution.
Tks.
--
Cory Vokey
BIS Database Engineering
Research In Motion Limited
185 Columbia Street, RIM3
Waterloo, ON, Canada, N2L 5Z5
519-888-7465, x3772
---------------------------------------------------------------------
This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Lingering Checkpoint Process
2005-02-23 16:28 Lingering Checkpoint Process Cory Vokey <cvokey@rim.com>
@ 2005-02-23 18:12 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2005-02-23 18:12 UTC (permalink / raw)
To: Cory Vokey <cvokey@rim.com>; +Cc: pgsql-admin
"Cory Vokey" <cvokey@rim.com> writes:
> Hi all, I'm seeing a checkpoint process lingering around for ~ 24hrs on
> one of my test systems and WAL logs are accumulating. It's running
> postgres 7.4.6.
Is the checkpoint process actually doing anything, or just sitting?
(strace'ing it would reveal this) If it seems to be just sitting,
could you attach to it with gdb and get a stack trace to find out
where it's sitting?
The only known cause of checkpoints not proceeding in 7.4.* is that
long btree CREATE INDEX operations can block them. But 24 hours
sounds pretty long for a CREATE INDEX too ...
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Lingering Checkpoint Process
@ 2005-02-23 18:43 Cory Vokey <cvokey@rim.com>
0 siblings, 0 replies; 3+ messages in thread
From: Cory Vokey @ 2005-02-23 18:43 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Thanks for the response Tom.
The checkpoint process seems to be just sitting. I'll post the details
of strace/gdb in the morning.
Thanks again!
--Cory
BIS Database Engineering
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, February 23, 2005 1:13 PM
To: Cory Vokey
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Lingering Checkpoint Process
"Cory Vokey" <cvokey@rim.com> writes:
> Hi all, I'm seeing a checkpoint process lingering around for ~ 24hrs
on
> one of my test systems and WAL logs are accumulating. It's running
> postgres 7.4.6.
Is the checkpoint process actually doing anything, or just sitting?
(strace'ing it would reveal this) If it seems to be just sitting,
could you attach to it with gdb and get a stack trace to find out
where it's sitting?
The only known cause of checkpoints not proceeding in 7.4.* is that
long btree CREATE INDEX operations can block them. But 24 hours
sounds pretty long for a CREATE INDEX too ...
regards, tom lane
---------------------------------------------------------------------
This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-02-23 18:43 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-23 16:28 Lingering Checkpoint Process Cory Vokey <cvokey@rim.com>
2005-02-23 18:12 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-02-23 18:43 Re: Lingering Checkpoint Process Cory Vokey <cvokey@rim.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox