Hi all, While testing this feature I found a crash on PG head with parallel create index using pgbanch tables.
-- GUCs under postgres.conf max_parallel_maintenance_workers = 16 max_parallel_workers = 16 max_parallel_workers_per_gather = 8 maintenance_work_mem = 8GB max_wal_size = 4GB ./pgbench -i -s 500 -d postgres postgres=# create index pgb_acc_idx3 on pgbench_accounts(aid, abalance,filler); WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. 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. !> -- With Regards, Prabhat Kumar Sahu Skype ID: prabhat.sahu1984 EnterpriseDB Corporation The Postgres Database Company On Thu, Feb 8, 2018 at 6:15 PM, Robert Haas <robertmh...@gmail.com> wrote: > On Tue, Feb 6, 2018 at 3:53 PM, Robert Haas <robertmh...@gmail.com> wrote: > > On Tue, Feb 6, 2018 at 2:11 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> Robert Haas <robertmh...@gmail.com> writes: > >>> Unfortunately valgrind does not work at all on my laptop -- the server > >>> appears to start, but as soon as you try to connect, the whole thing > >>> dies with an error claiming that the startup process has failed. So I > >>> can't easily test this at the moment. I'll try to get it working, > >>> here or elsewhere, but thought I'd send the above reply first. > >> > >> Do you want somebody who does have a working valgrind installation > >> (ie me) to take responsibility for pushing this patch? > > > > I committed it before seeing this. It probably would've been better > > if you had done it, but I assume Peter tested it, so let's see what > > the BF thinks. > > skink and lousyjack seem happy now, so I think it worked. > > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > >
