| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | iqcook(at)gmail(dot)com |
| Subject: | BUG #18975: PostgreSQL server doesn't process SQL request correctly over Windows replica of Linux server |
| Date: | 2025-07-01 23:10:12 |
| Message-ID: | 18975-b1fe0ffff85a800c@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 18975
Logged by: Egor Chashchin
Email address: iqcook(at)gmail(dot)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=24rhvs9ytroznxyt86xivlxef
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=0yygbv62hloay32sgapglwrsa
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maxim Boguk | 2025-07-02 00:03:00 | Re: BUG #18974: Postgresql repeatable crash after pg_upgrade from 15 to 17.5 version in postgresql_fdw queries |
| Previous Message | PG Bug reporting form | 2025-07-01 22:08:57 | BUG #18974: Postgresql repeatable crash after pg_upgrade from 15 to 17.5 version in postgresql_fdw queries |