Re: pgsql: doc: Warn that ts_headline() output is not HTML-safe.

2025-05-01 Thread Robins Tharakan
On Fri, 2 May 2025 at 07:28, Robins Tharakan wrote: > > So ideally if gcc fixes the issue (or if I fix something stupid in the way > I am > compiling gcc etc), the next buildfarm run should automatically go > green soon after. > Does look like a gcc bug. Ideally should go g

Re: pgsql: doc: Warn that ts_headline() output is not HTML-safe.

2025-05-01 Thread Robins Tharakan
On Fri, 2 May 2025 at 06:57, Tom Lane wrote: > Robins Tharakan writes: > > On Thu, 1 May 2025 at 19:43, Dean Rasheed > wrote: > >> doc: Warn that ts_headline() output is not HTML-safe. > > > This commit looks harmless, but 2 separate machines are > > faili

Re: pgsql: doc: Warn that ts_headline() output is not HTML-safe.

2025-05-01 Thread Robins Tharakan
Hi, On Thu, 1 May 2025 at 19:43, Dean Rasheed wrote: > doc: Warn that ts_headline() output is not HTML-safe. > > Backpatch-through: 13 > > This commit looks harmless, but 2 separate machines are failing on this commit (at the same point). For now, it appears more like a compiler bug. I have req

Re: pgsql: Use extended stats for precise estimation of bucket size in hash

2025-04-09 Thread Robins Tharakan
Hi, On Mon, 10 Mar 2025 at 22:18, Alexander Korotkov wrote: > > Use extended stats for precise estimation of bucket size in hash join After this commit, I see a recurrence of an error similar to the one fixed in e28033fe1af8037e0fec8bb3a32fabbe18ac06b1 https://www.postgresql.org/message-id/188

Re: pgsql: Trial fix for old cross-version upgrades.

2025-03-07 Thread Robins Tharakan
On Sat, 1 Mar 2025 at 03:42, Sami Imseih wrote: > I was running "make check-world" this morning on a machine that has an > old version of perl, 5.16, and the check-world was hung on > /usr/bin/perl t/002_pg_upgrade.pl. > FWIW, both massasauga / snakefly were stuck owing to this for the past few

Re: pgsql: Track unpruned relids to avoid processing pruned relations

2025-03-03 Thread Robins Tharakan
Hi Amit, On Fri, 7 Feb 2025 at 18:45, Amit Langote wrote: > Track unpruned relids to avoid processing pruned relations > > Since this change, the SQL in the bug-report #18830 [1] segfaults reliably. The SQL was tested with commits as recent as 15a79c7311 (2nd March), so it appears unrelated to

Re: pgsql: Remove support for OpenSSL older than 1.1.0

2024-09-03 Thread Robins Tharakan
Hi Daniel, On Mon, 2 Sept 2024 at 21:54, Daniel Gustafsson wrote: > > Remove support for OpenSSL older than 1.1.0 > I am trying to update my buildfarm animals for this, and although I fixed massasauga (essentially by skipping the test for now), I am unclear why snakefly still fails (now, much la

Re: pgsql: Do assorted mop-up in the planner.

2023-02-05 Thread Robins Tharakan
On Mon, 6 Feb 2023 at 05:57, Tom Lane wrote: > I'd hoped that some of these failures shared a root cause, but nope > they were really four different bugs :-(. I've now pushed fixes > for all four, and I hope you'll turn your fuzzer back on. This > is very valuable testing. Thanks Tom for fixing

Re: pgsql: Do assorted mop-up in the planner.

2023-02-02 Thread Robins Tharakan
Hi Tom, I'll probably switch off testing master for a day (and probably stop posting more on this thread), but thought I'd post one last (seemingly different) signature around the same commit, before I wrap up for the day. On Thu, 2 Feb 2023 at 23:25, Robins Tharakan wrote: > >

Re: pgsql: Do assorted mop-up in the planner.

2023-02-02 Thread Robins Tharakan
) - 2489d76c4906f4461a364ca8ad7e0751ead8aa0d - Success Checking (0736fc1ceb~19) - ec7e053a98f39a9e3c7e6d35f0d2e83933882399 - Success Checking (0736fc1ceb~20) - fe9e658f4d7fbc12d2b6a74c4ee90c73e53d68ef - Success - robins On Thu, 2 Feb 2023 at 12:23, Tom Lane wrote: > > Robins Tharakan writes: > > This commit is causing occasi

Re: pgsql: Do assorted mop-up in the planner.

2023-02-01 Thread Robins Tharakan
076da25 - Crash Checking (fb1a59de0c~14) - 2489d76c4906f4461a364ca8ad7e0751ead8aa0d - Success Checking (fb1a59de0c~15) - ec7e053a98f39a9e3c7e6d35f0d2e83933882399 - Success Thanks to SQLSmith / SQLReduce. - Robins Tharakan Amazon Web Services

Re: pgsql: Make Vars be outer-join-aware.

2023-01-30 Thread Robins Tharakan
in fix_scan_expr (root=0x55bca217e358, node=0x55bca21c9e10, rtoffset=1, num_exec=0) at setrefs.c:2127 TRAP: failed Assert("phv->phnullingrels == NULL"), File: "setrefs.c", Line: 2208, PID: 1045580 Thanks to SQLSmith / SQLReduce for help on this. - Robins Tharakan Amazon Web Services

Re: pgsql: postgres_fdw: Fix assertion in estimate_path_cost_size().

2022-12-12 Thread Robins Tharakan
Hi, I think this bugfix needs to be backpatched to v12 too. See backtrace / repro SQL here - https://www.postgresql.org/message-id/17713-92cce66de7e81c04%40postgresql.org - Robins Tharakan Amazon Web Services On Fri, 5 Feb 2021 at 17:05, Etsuro Fujita wrote: > > postgres_fdw: Fix assert

Re: pgsql: Add scripts for retrieving the cluster file encryption key

2020-12-26 Thread Robins Tharakan
This script seems to have broken my instance. https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=massasauga&dt=2020-12-26%2006%3A20%3A19 - robins On Sat, 26 Dec 2020 at 17:19, Bruce Momjian wrote: > Add scripts for retrieving the cluster file encryption key > > Scripts are passphrase, dir