Re: LLVM jit and matview

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>
To: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>, PostgreSQL mailing lists <pgsql-bugs@postgresql.org>
Date: 2018-07-10T00:19:58Z
Lists: pgsql-bugs, pgsql-hackers
On Mon, Jul 09, 2018 at 04:04:11PM +0200, Dmitry Dolgov wrote:
> # matview.sql
> ...
> =# REFRESH MATERIALIZED VIEW CONCURRENTLY mvtest_tm;
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.

Problem reproduced here with exactly the same stack.  Here is a simple
SQL sequence:
create table aa (a int);
create materialized view aam as select * from aa;
 create unique index aami on aam(a);
insert into aa values (generate_series(1,100000));
refresh materialized view CONCURRENTLY aam;

I have added an open item.
--
Michael

Commits

  1. LLVMJIT: Release JIT context after running ExprContext shutdown callbacks.