PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15460
PG Version11.0
OSWindows Server 2008 R2
Opened2018-10-26 09:31:18+00
Reported bydoskabouter
StatusOpen

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15460
Logged by:          doskabouter
Email address:      (redacted)
PostgreSQL version: 11.0
Operating system:   Windows Server 2008 R2
Description:        

On large tables I get an error on:

CREATE INDEX nx_tablename ON tablename USING btree (col1); col1 being an
integer
and
ALTER TABLE ONLY tablename ADD CONSTRAINT pk_tablename PRIMARY KEY (col1,
col2); col1 and col2 both integer

First noticed that with pg_restore (from a pg_dump from PG10)
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 14005; 1259 546886907 INDEX
nx_tablename postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  could not
determine
 size of temporary file "0"
    Command was: CREATE INDEX nx_tablename ON tablename USING btree
(col1);

After the restore finished (with that error) I tried running that same query
in pgadmin.
There I got:
********** Error **********
ERROR: could not determine size of temporary file "0"
SQL state: 58P01

table definition:

CREATE TABLE tablename
(
  col1 bigint NOT NULL,
  col2 bigint NOT NULL,
  col3 bigint NOT NULL,
  col4 bigint NOT NULL,
  col5 bigint,
  col6 integer NOT NULL,
)

I have several comparable tables (same columns). Errors occur for tables
with 386726424 or 556071229 records
for other smaller tables (largest has 163183465 records) there's no error

postgres/postgis versions:
"POSTGIS="2.5.0 r16836" [EXTENSION] PGSQL="110" GEOS="3.7.0-CAPI-1.11.0
3.7.0" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.4, released
2018/03/19" LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" RASTER"
"PostgreSQL 11.0, compiled by Visual C++ build 1914, 64-bit"
running on a 28-core, 75GB Windows server 2008 R2 64-bit machine

postgres.conf: All parallel related options are at default

Messages

DateAuthorSubject
2018-10-26 09:31:18+00=?utf-8?q?PG_Bug_reporting_form?=BUG #15460: Error while creating index or constraint
2018-10-29 11:41:19+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 12:27:06+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 12:45:10+00Paul van der LindenRE: BUG #15460: Error while creating index or constraint
2018-10-29 12:53:28+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 13:01:15+00Paul van der LindenRE: BUG #15460: Error while creating index or constraint
2018-10-29 13:04:58+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 13:26:23+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 13:44:38+00Paul van der LindenRE: BUG #15460: Error while creating index or constraint
2018-10-29 14:11:08+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 14:13:00+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 14:19:37+00Paul van der LindenRE: BUG #15460: Error while creating index or constraint
2018-10-29 14:23:12+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 14:28:31+00Paul van der LindenRE: BUG #15460: Error while creating index or constraint
2018-10-29 14:29:22+00Paul van der LindenRE: BUG #15460: Error while creating index or constraint
2018-10-29 14:30:47+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 15:15:03+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 15:17:58+00Paul van der LindenRE: BUG #15460: Error while creating index or constraint
2018-10-29 15:24:16+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 15:25:48+00Tom LaneRe: BUG #15460: Error while creating index or constraint
2018-10-29 15:31:10+00Tom LaneRe: BUG #15460: Error while creating index or constraint
2018-10-29 15:31:11+00Paul van der LindenRE: BUG #15460: Error while creating index or constraint
2018-10-29 15:44:15+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 15:58:50+00Paul van der LindenRE: BUG #15460: Error while creating index or constraint
2018-10-29 16:28:25+00Tom LaneRe: BUG #15460: Error while creating index or constraint
2018-10-29 16:38:07+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 16:51:03+00Tom LaneRe: BUG #15460: Error while creating index or constraint
2018-10-29 17:11:57+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-10-29 18:39:51+00Tom LaneRe: BUG #15460: Error while creating index or constraint
2018-10-30 13:37:01+00Thomas MunroRe: BUG #15460: Error while creating index or constraint
2018-11-02 00:26:06+00Thomas MunroRe: BUG #15460: Error while creating index or constraint
2018-11-02 08:02:26+00Paul van der LindenRE: BUG #15460: Error while creating index or constraint
2018-11-03 09:13:44+00Thomas MunroRe: BUG #15460: Error while creating index or constraint
2018-11-13 09:13:37+00Thomas MunroRe: BUG #15460: Error while creating index or constraint
2018-11-13 09:49:26+00Thomas MunroRe: BUG #15460: Error while creating index or constraint
2018-11-13 17:50:26+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-11-13 20:12:10+00Thomas MunroRe: BUG #15460: Error while creating index or constraint
2018-11-15 01:09:10+00Thomas MunroRe: BUG #15460: Error while creating index or constraint
2018-11-28 19:31:48+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-11-28 21:04:06+00Tom LaneRe: BUG #15460: Error while creating index or constraint
2018-11-28 22:48:29+00Peter GeogheganRe: BUG #15460: Error while creating index or constraint
2018-11-29 00:01:13+00Thomas MunroRe: BUG #15460: Error while creating index or constraint