From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: iqcook@gmail.com
Subject: BUG #18975: PostgreSQL server doesn't process SQL request correctly over Windows replica of Linux server
Date: Tue, 01 Jul 2025 23:10:12 +0000
Message-ID: <18975-b1fe0ffff85a800c@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18975
Logged by: Egor Chashchin
Email address: iqcook@gmail.com
PostgreSQL version: 17.5
Operating system: LInux / Wiondows
Description:
We have next configuration - master server on Linux Ubuntu and physical
replica on Windows 10 machine. Some kind of simple SELECT SQL request
returns none called on replica - and work correctly on server itself or
Linux physical replica. If we inspect data in windows replica tables - we
see, that all data needed presented.
we captured example of this behavior on this video
https://www.dropbox.com/scl/fi/c8msver0gm78turk3wfsv/2025-07-02_00-14-31.mp4?rlkey=24rhvs9ytroznxyt8...
Linux - 17.5.1
Windows - 17.5.2
We have this problem with 16.8.x too.
It occurs not with all requests of such kind even on same table, but not
randomly - running same code fails in same place everytime.
Additional attempts were captured too
https://www.dropbox.com/scl/fi/g9h3r7v3gu59j5max9r7k/2025-07-02_00-59-02.mp4?rlkey=0yygbv62hloay32sg...
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-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, iqcook@gmail.com
Subject: Re: BUG #18975: PostgreSQL server doesn't process SQL request correctly over Windows replica of Linux server
In-Reply-To: <18975-b1fe0ffff85a800c@postgresql.org>
* 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