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
