Re: Segmentation fault - PostgreSQL 17.0

On 11/11/24 09:25, Ľuboslav Špilák wrote:
> Hello.
> 
> I am sending you the dump file from command:
>       Postgres@hdoppxendb1:~$ *PGOPTIONS="-c search_path=\"XEN_TS\""
> psql -XAt -d "xtimeseries" -c "SELECT
> encode(get_raw_page('test_idxbrin', 2),'base64')" | base64 -d >
> dump_block_2.page*
> 
> The steps for preparing table and index are:
> 
> 
> CREATE TABLE test (
>       cas int8 NULL
> );
> 
> CREATE INDEX test_idxbrin ON test USING brin (cas) WITH
> (pages_per_range='32');
> 

It took me a while to get this working. It was failing for me with

   ERROR:  column "cas" does not exist

because the spaces in CREATE TABLE are actually not regular spaces, but
"EN SPACES" (U+2002), which we just consider not-whitespace, and include
them in the column name.

Presumably it's been added by the mail client.

> insert into test values (123)
> 
> analyse test
> 
> vacuum test
> 
> CREATE extension pageinspect;
> 
> SELECT brin_page_type(get_raw_page('test_idxbrin', 0));
> 
> select * from "XEN_TS".brin_metapage_info(get_raw_page('test_idxbrin',0));
> 
> select * from brin_revmap_data(get_raw_page('test_idxbrin',1)) limit 1000;
> 
>       
> 
> select *
> from brin_page_items(
>   get_raw_page('test_idxbrin',2),
>   'test_idxbrin'
> );
> 
> Last select returns this error:
> 
> SQL Error [57P03]: FATAL: the database system is not yet accepting
> connections
>   Detail: Consistent recovery state has not been yet reached.
> 
> I am working on getting the backtrace.
> 

Well, all of this works just fine for me :-( I even tried on a cluster
that went thought the same PG12 -> PG17 pg_upgrade, but all of that
works. Even reading the page works fine:

test=# select lo_import('/tmp/dump_block_2.page');
 lo_import
-----------
     16443
(1 row)

test=# select * from brin_page_items(lo_get(16443), 'test_idxbrin');
 itemoffset | blknum | attnum | allnulls | hasnulls | placeholder |
empty |    value
------------+--------+--------+----------+----------+-------------+-------+--------------
          1 |      0 |      1 | f        | f        | f           | f
 | {123 .. 123}
(1 row)


Not sure what's going on. Can you maybe share which exact Ubuntu version
and packages you use?

Is there anything special about the system? Do you use extensions?


regards

-- 
Tomas Vondra