BUG #15350: Getting invalid cache ID: 11 Errors

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15350: Getting invalid cache ID: 11 Errors
Дата
Msg-id 153512195228.1489.8545997741965926448@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15350: Getting invalid cache ID: 11 Errors  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15350
Logged by:          Kieran McCusker
Email address:      kieran.mccusker@gmail.com
PostgreSQL version: 10.5
Operating system:   Fedora 28
Description:

Hi

We're using 10.5 with parallel queries enabled and the config options
#max_worker_processes = 8
#max_parallel_workers_per_gather = 2
#max_parallel_workers = 8

I'm seeing invalid cache ID: 11 errors in the log. It's only happening
occasionally (15 times today on a not very busy system). I've been following
the thread about making windowing functions et al parallel restricted - Is
this another manifestation of the problem? 

On the first query setting set session max_parallel_workers to 0 more than
doubles the execution time from 208ms to 580ms so that doesn't seem
desirable, and it's not obvious to me why the second would have failed.

I'm probably being dense and if so apologies for wasting your time. I also
don't see how to create a test case sorry.

Many thanks

Kieran

A couple of example queries are :-
-----------------------------------------------------------------------------------------------
with limits as (
                      select min(contact_date), max(contact_date)
                      from q366midl.q366m1
                      where contact_date is not null 
                    )
                    select 
                    to_char(min,'YYYY-MM'),
                    'text' as format,
                    to_char(min,substr('YYYY-MM',1,7)) as code,
--
                    from limits
                    union all
                    select
                    to_char(max,'YYYY-MM'),
                    'text' as format,
                    to_char(max,substr('YYYY-MM',1,7)) as code,
                    to_char(max,'Mon YYYY') as text 
                    from limits
                    order by 1

2018-08-24 13:50:28.325 BST [68794] ERROR:  invalid cache ID: 11
2018-08-24 13:50:28.325 BST [68844] LOG:  worker process: parallel worker
for PID 67216 (PID 68793) exited with exit code 1
2018-08-24 13:50:28.327 BST [68844] LOG:  worker process: parallel worker
for PID 67216 (PID 68794) exited with exit code 1


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2018-08-23 11:04:23.020 BST [80148] ERROR:  invalid cache ID: 11
2018-08-23 11:04:23.020 BST [80148] CONTEXT:  parallel worker
2018-08-23 11:04:23.020 BST [80148] STATEMENT:  SELECT "survey"."calls".*
FROM "survey"."calls" WHERE ((survey_state is null or survey_state not in
(500,501)) and phone_numbers @> array['07854 xxxxxx']) ORDER BY created_at
desc
2018-08-23 11:04:23.021 BST [81154] ERROR:  invalid cache ID: 11
2018-08-23 11:04:23.023 BST [68844] LOG:  worker process: parallel worker
for PID 80148 (PID 81153) exited with exit code 1
2018-08-23 11:04:23.023 BST [68844] LOG:  worker process: parallel worker
for PID 80148 (PID 81154) exited with exit code 1


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #15347: Unaccent for greek characters does not work
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15350: Getting invalid cache ID: 11 Errors