Content-Type: multipart/alternative;
 boundary="------------XRdlF7GsS9Laepr8ZjPagJrB"
Message-ID: <a33b0b52-157a-4004-a84a-44c6a8164147@jbitc.de>
Date: Mon, 27 Jul 2026 10:06:16 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: MI - WAL issue
To: pgsql-admin@lists.postgresql.org
References: 
 <CAGc_7HnEqS6HjZWvCPkqjZa58bexjhsHBZz8O9iUK+KETbVy7Q@mail.gmail.com>
Content-Language: de-DE, en-US
From: Jochen Bandhauer <jb@jbitc.de>
In-Reply-To: 
 <CAGc_7HnEqS6HjZWvCPkqjZa58bexjhsHBZz8O9iUK+KETbVy7Q@mail.gmail.com>
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/a33b0b52-157a-4004-a84a-44c6a8164147%40jbitc.de>
Precedence: bulk

This is a multi-part message in MIME format.
--------------XRdlF7GsS9Laepr8ZjPagJrB
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hello,

is this a standby database? Is the database currently running?

Regards
Jochen

On 7/27/2026 7:57 AM, mahamood hussain wrote:
>
> Hi team,
>
> I need some urgent assistance.
>
> We're running *PostgreSQL 17.6*, and the application team has reported 
> an *export issue*. While investigating, I found the following messages 
> in the PostgreSQL logs:
>
> |2026-07-26 10:58:52.902 MST [1183899] DETAIL: Parameters: $1 = 
> '1785088732902', $2 = 'ctsserver-11783137027378' 2026-07-26 
> 10:58:56.136 MST [1529364] LOG: checkpoint starting: time 2026-07-26 
> 10:58:56.447 MST [1529364] LOG: request to flush past end of generated 
> WAL; request 5D116/1, current position C8F/734E66C0 2026-07-26 
> 10:58:56.447 MST [1529364] CONTEXT: writing block 4400857 of relation 
> base/16384/1255337 2026-07-26 10:58:56.448 MST [1529364] ERROR: xlog 
> flush request 5D116/1 is not satisfied --- flushed only to 
> C8F/734E66C0 2026-07-26 10:58:56.448 MST [1529364] CONTEXT: writing 
> block 4400857 of relation base/16384/1255337 |
>
> Has anyone come across this issue before or know what could cause it? 
> Any guidance on the root cause or recommended troubleshooting steps 
> would be greatly appreciated.
>
> This is a *Major Incident (MI)* and requires immediate assistance.
>
> Thanks in advance.
>

-- 
Mit freundlichen Grüßen

Jochen Bandhauer


--------------XRdlF7GsS9Laepr8ZjPagJrB
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    Hello,<br>
    <br>
    is this a standby database? Is the database currently running?<br>
    <br>
    Regards<br>
    Jochen<br>
    <br>
    <div class="moz-cite-prefix">On 7/27/2026 7:57 AM, mahamood hussain
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAGc_7HnEqS6HjZWvCPkqjZa58bexjhsHBZz8O9iUK+KETbVy7Q@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <p>Hi team,</p>
        <p>I need some urgent assistance.</p>
        <p>We're running <strong>PostgreSQL 17.6</strong>, and the
          application team has reported an <strong>export issue</strong>.
          While investigating, I found the following messages in the
          PostgreSQL logs:</p>
        <pre><code class="gmail-language-text">2026-07-26 10:58:52.902 MST [1183899] DETAIL:  Parameters: $1 = '1785088732902', $2 = 'ctsserver-11783137027378'
2026-07-26 10:58:56.136 MST [1529364] LOG:  checkpoint starting: time
2026-07-26 10:58:56.447 MST [1529364] LOG:  request to flush past end of generated WAL; request 5D116/1, current position C8F/734E66C0
2026-07-26 10:58:56.447 MST [1529364] CONTEXT:  writing block 4400857 of relation base/16384/1255337
2026-07-26 10:58:56.448 MST [1529364] ERROR:  xlog flush request 5D116/1 is not satisfied --- flushed only to C8F/734E66C0
2026-07-26 10:58:56.448 MST [1529364] CONTEXT:  writing block 4400857 of relation base/16384/1255337
</code></pre>
        <p>Has anyone come across this issue before or know what could
          cause it? Any guidance on the root cause or recommended
          troubleshooting steps would be greatly appreciated.</p>
        <p>This is a <strong>Major Incident (MI)</strong> and requires
          immediate assistance.</p>
        <p>Thanks in advance.</p>
      </div>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Mit freundlichen Grüßen

Jochen Bandhauer</pre>
    <br>
  </body>
</html>

--------------XRdlF7GsS9Laepr8ZjPagJrB--