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.
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 |