From: Satoshi Nakamoto <70camero@live.com>
To: Nikhil Shetty <nikhil.dba04@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Stuck Checkpoint Process
Date: Sun, 7 Nov 2021 16:55:27 +0000
Message-ID: <BYAPR02MB6438FD478ECC8954EC61E89BB3909@BYAPR02MB6438.namprd02.prod.outlook.com> (raw)
In-Reply-To: <CAFpL5Vzxa=BY5BefDtp9KQ_=2LOogaTFWiGxF2NeMnn6ppzB0w@mail.gmail.com>
References: <CAFpL5Vy10O2MnA9jNXGLsamN3a5yVqHiuUAuU0evC-xOfTWqRQ@mail.gmail.com>
<CAFpL5Vzxa=BY5BefDtp9KQ_=2LOogaTFWiGxF2NeMnn6ppzB0w@mail.gmail.com>
Restart then upload the fiol an run it then see what you can do you can put it in a block header an work on it with out crashing an burningthermit a termitburn is going to bet the ne upgrad to block chain.
Get Outlook for Android<https://aka.ms/AAb9ysg;
________________________________
From: Nikhil Shetty <nikhil.dba04@gmail.com>
Sent: Thursday, November 4, 2021 10:02:04 PM
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Stuck Checkpoint Process
Hi Team,
Any assist here would be helpful
Thanks,
Nikhil
On Wed, 3 Nov 2021 at 2:47 PM, Nikhil Shetty <nikhil.dba04@gmail.com<mailto:nikhil.dba04@gmail.com>> wrote:
Hi Team,
PostgreSQL Version - 11.7
OS - RHEL 7.9
Problem:
We see that the backups were not happening on one of the instances. On further checking, we saw that the checkpoint process was not working. Last checkpoint was 7 days ago. Manual checkpoint goes into hang state.
Checkpoint Process
> pid | backend_start | wait_event_type | wait_event | backend_type
> -------+-------------------------------+-----------------+---------------------+--------------
> 21237 | 2021-06-29 21:27:51.806746+00 | LWLock | replication_slot_io | checkpointer
> (1 row)
Time of latest checkpoint: Wed 27 Oct 2021 03:45:09 PM PDT
I see it is waiting for I/O on replication slots. I see no issue on standby and replication is working fine. Need help to further debug this
Replication Slots
> dbname=# select pg_current_wal_lsn();
> pg_current_wal_lsn
> --------------------
> 2B0/75042DE0
> dbname=# select * from pg_replication_slots ;
> slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn
> ---------------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+--------------+---------------------
> repmgr_slot_5 | | physical | | | f | t | 4285 | | | 2B0/75042DE0 |
> repmgr_slot_1 | | physical | | | f | t | 3402 | | | 2B0/75042DE0 |
Thanks and Regards,
Nikhil
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: 70camero@live.com, nikhil.dba04@gmail.com
Subject: Re: Stuck Checkpoint Process
In-Reply-To: <BYAPR02MB6438FD478ECC8954EC61E89BB3909@BYAPR02MB6438.namprd02.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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