BUG #14004: pg_restore never returns on premature EOF of input file if invoked with with parallel job option - Mailing list pgsql-bugs

From armin.schoeffmann@aegaeon.de
Subject BUG #14004: pg_restore never returns on premature EOF of input file if invoked with with parallel job option
Date
Msg-id 20160307161619.25731.78653@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14004
Logged by:          Armin Schöffmann
Email address:      armin.schoeffmann@aegaeon.de
PostgreSQL version: 9.5.1
Operating system:   Microsoft Windows [Version 6.1.7601] x64
Description:

1) Multithreaded call of pg_restore with damaged input file:

pg_restore -Uaegaeon -v -j12 -c -dpostgres database_dump.dump
[...]
Element 2022 SEQUENCE SET recipes_recipe_id_seq abgeschlossen
pg_restore: [paralleler Archivierer] could not read from input file: end of
file

command never returns:
debugger shows blocking wait in parallel.c ln 403:
ret = WaitForMultipleObjects(nrun, (HANDLE *) lpHandles, false, INFINITE);



2) Singlethreaded call of pg_restore with damaged input file:

pg_restore -Uaegaeon -v -j1 -c -dpostgres database_dump.dump
[...]
pg_restore: [Custom-Archivierer] konnte nicht aus Eingabedatei lesen:
Dateiende

C:\Program Files\PGsql\bin>

Problem verified on 9.5.1, 9.5.0, 9.4.5
(all x64).

Best regards,
Armin.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #14003: Error "could not open relation with OID 18152875"
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`