Sudden FTS-related error from parallel worker in 9.6

From: Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Sudden FTS-related error from parallel worker in 9.6
Date: 2016-10-04 00:38:47
Message-ID: CANNMO+JkykPUbPzXraZ_oPUeqcUOK1SMo2kjGhLbeQqDL45L2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I have a Postgres 9.6.0 instance for testing purposes. It turned out that
in postgresql.conf, this postgres cluster has "default_text_search_config"
being set to "ru" for some reason.

Suddenly, I encountered with an error relating to full text configuration
in test database, where I didn't use FTS at all, I just tried to test
parallel aggregation feature:

test=# create table test as
test-# select
test-# i as id,
test-# now() - random() * '5 years'::interval as ts,
test-# (random() * 100000000)::int4 as number,
test-# repeat('x', (10 + 40 * random())::int4) as txt
test-# from
test-# generate_series(1, 10000000) i;
SELECT 10000000

test=# alter table test add primary key (id);
ALTER TABLE

test=# explain analyze select min(ts) from test;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=226505.45..226505.46 rows=1 width=8) (actual
time=1460.227..1460.227 rows=1 loops=1)
-> Seq Scan on test (cost=0.00..201504.76 rows=10000276 width=8)
(actual time=0.013..697.676 rows=10000000 loops=1)
Planning time: 0.098 ms
Execution time: 1460.257 ms
(4 rows)

test=# set max_parallel_workers_per_gather to 8;
SET
test=# explain analyze select min(ts) from test;
*ERROR: invalid value for parameter "default_text_search_config": "ru"*
*CONTEXT: parallel worker*

Such an error would be OK if I tried to use some text search function
(since really no 'ru' configuration is present in 'test' database), but I
ovbviously didn't.

As you can see, no FTS features are involved in table definition, so it
seems really strange to see FTS-related error

Bottom line, steps to reproduce:
1) put not existing text search default configurtion
2) set max_parallel_workers_per_gather to 8;
3) do some aggregation query that would involved parallel workers and
doesn't use FTS features.

What I expected: no FTS-related error, because I FTS was not used by the
query.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nikolay Samokhvalov 2016-10-04 00:46:19 Re: Sudden FTS-related error from parallel worker in 9.6
Previous Message Marco Colombo 2016-10-03 20:31:02 Re: BUG #14351: Upsert not working in case of partitioned tables