Re: Error when setting default_text_search_config

On 2024-10-05 19:46 +0200, Murat Efendioğlu wrote:
> I've encountered some strange behavior in the new PostgreSQL 17 version.
> Previously, in versions before 17, I was able to set the
> default_text_search_config like this:
> 
> sql
> Copy code
> ALTER DATABASE "MyDatabase" SET default_text_search_config TO 'german';
> 
> Everything worked fine. However, after upgrading to PostgreSQL 17, when I
> ran the same ALTER statement on the new database, my database entered
> recovery mode.

Is it entering recovery mode just by running that ALTER DATABASE?  Are
you already connected to MyDatabase?

> The solution was to update the statement as follows:
> 
> sql
> Copy code
> ALTER DATABASE "MyDatabase" SET default_text_search_config TO
> 'pg_catalog.german';
> 
> It turns out I had to prefix the language with pg_catalog to resolve the
> issue.
> 
> Environment: Windows Server 2022 Standard 21H2 with PostgreSQL 17 installer

I can reproduce a segfault on my Arch machine with 17.0, but only by
also connecting to that database afterwards:

    postgres=# create database regress;
    postgres=# alter database regress set default_text_search_config to 'german';
    postgres=# \c regress
    connection to server at "localhost" (::1), port 15432 failed: server closed the connection unexpectedly
            This probably means the server terminated abnormally
            before or while processing the request.

The core dump shows this backtrace:

    #0  0x0000619056403314 in MemoryContextReset ()
    #1  0x0000619056016faa in spcache_init ()
    #2  0x0000619056017706 in recomputeNamespacePath ()
    #3  0x000061905601a705 in get_ts_config_oid ()
    #4  0x00006190563d5f08 in check_default_text_search_config ()
    #5  0x00006190563ee3c0 in call_string_check_hook ()
    #6  0x00006190563f107b in parse_and_validate_value ()
    #7  0x00006190563f1faa in set_config_with_handle ()
    #8  0x00006190563f6545 in ProcessGUCArray ()
    #9  0x0000619056027e97 in ApplySetting ()
    #10 0x00006190563ea256 in InitPostgres ()
    #11 0x000061905629eb66 in PostgresMain ()
    #12 0x000061905629ac9f in BackendMain ()
    #13 0x000061905620af9b in postmaster_child_launch ()
    #14 0x000061905620ea69 in ServerLoop.isra.0 ()
    #15 0x000061905621077d in PostmasterMain ()
    #16 0x0000619055f4ba03 in main ()

-- 
Erik