On 2018-07-10 09:19:58 +0900, Michael Paquier wrote: > 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;
FWIW, this doesn't crash for me, using a trunk checkout for LLVM. I'll try older ones, as soon as they finish rebuilding. But perhaps you could re-verify that this still is an issue on recent PG checkouts? And which version of LLVM are you guys using? Greetings, Andres Freund
