[sqlsmith] Failed assertion in brin_minmax_multi_distance_float4 on REL_14_STABLE

From: Andreas Seltenreich <andreas(dot)seltenreich(at)credativ(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [sqlsmith] Failed assertion in brin_minmax_multi_distance_float4 on REL_14_STABLE
Date: 2021-11-04 08:46:49
Message-ID: 87r1bw9ukm.fsf@credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

sqlsmith triggers the following assertion when testing REL_14_STABLE:

TRAP: FailedAssertion("a1 <= a2", File: "brin_minmax_multi.c", Line: 1879, PID: 631814)

I can reproduce it with the following query on a fresh regression
database:

insert into public.brintest_multi (float4col) values (real 'nan');

The branch was at f6162c020c while testing, backtrace below.

regards,
Andreas

(gdb) bt
#0 0x00007f703cc46ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6
#1 0x00007f703cc30537 in abort () from /lib/x86_64-linux-gnu/libc.so.6
#2 0x000055b17517c521 in ExceptionalCondition at assert.c:69
#3 0x000055b174d25871 in brin_minmax_multi_distance_float4 (fcinfo=<optimized out>) at brin_minmax_multi.c:1879
#4 0x000055b1751853ba in FunctionCall2Coll (flinfo=flinfo(at)entry=0x55b176913d10, collation=collation(at)entry=0, arg1=<optimized out>,
arg2=<optimized out>) at fmgr.c:1160
#5 0x000055b174d23a41 in build_distances (distanceFn=distanceFn(at)entry=0x55b176913d10, colloid=0,
eranges=eranges(at)entry=0x55b17693fad0, neranges=neranges(at)entry=5) at brin_minmax_multi.c:1352
#6 0x000055b174d256be in compactify_ranges (max_values=32, ranges=0x55b176945708, bdesc=<optimized out>) at brin_minmax_multi.c:1822
#7 brin_minmax_multi_serialize (bdesc=<optimized out>, src=94220687005448, dst=0x55b17693ae10) at brin_minmax_multi.c:2386
#8 0x000055b174d2ae0d in brin_form_tuple (brdesc=brdesc(at)entry=0x55b176914988, blkno=blkno(at)entry=15,
tuple=tuple(at)entry=0x55b17693aaa0, size=size(at)entry=0x7ffffcc6d4f8) at brin_tuple.c:165
#9 0x000055b174d20a5f in brininsert (idxRel=0x7f703b2ae170, values=0x7ffffcc6d610, nulls=0x7ffffcc6d5f0, heaptid=0x55b17690da78,

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2021-11-04 08:53:10 Re: CREATE ROLE IF NOT EXISTS
Previous Message Takashi Menjo 2021-11-04 08:46:18 Re: Map WAL segment files on PMEM as WAL buffers