PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16026
PG Version10.5
OSredhat 7 64 bits
Opened2019-09-26 12:57:01+00
Reported byvirgile crevon
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16026
Logged by:          virgile crevon
Email address:      (redacted)
PostgreSQL version: 10.5
Operating system:   redhat 7 64 bits
Description:        

Hi,

To reproduce :

1- create a tablespace data  (whereever you want it to be). Note that data
is lowercase without quotation marks.
2- set default_tablespace='DATA' in postgresql.conf. Note this is un
UPPERCASE.
3- reload conf.
4- create a database with default tablespace data (lowercase).
5- create a query that is using parallel (gather step) to seq scan.

Since the worker work with default tablespace at postgresql.conf level, he
will break with the following message :

2019-09-25 16:42:50.444 GMT [71530] ERROR:  invalid value for parameter
"default_tablespace": "DATA"
2019-09-25 16:42:50.444 GMT [71530] DETAIL:  Tablespace "DATA" does not
exist.
::  ::  ::  ::  2019-09-25 18:42:50.445 CEST ::
 LOG:  worker process: parallel worker for PID 62413 (PID 71531) exited with
exit code 1
 ::  ::  ::  ::  2019-09-25 18:42:50.445 CEST ::
 LOG:  worker process: parallel worker for PID 62413 (PID 71530) exited with
exit code 1

(2 workers for this query, will end up with more error if parallel mode is
configured differently on your system).

Perhaps it's a documentation issue (default_tablespace is not mentionned to
be used by parallel_query).
But i think it is more a bug : it would definitively have to get the default
tablespace from database where the query is run.

Regards,

Virgile CREVON

Messages

DateAuthorSubject
2019-09-26 12:57:01+00PG Bug reporting formBUG #16026: default_tablespace in postgresql.conf is used instead of the database's default.
2019-09-26 15:01:17+00Tom LaneRe: BUG #16026: default_tablespace in postgresql.conf is used instead of the database's default.
2019-09-27 01:36:15+00Thomas MunroRe: BUG #16026: default_tablespace in postgresql.conf is used instead of the database's default.
2019-10-17 01:31:02+00Thomas MunroRe: BUG #16026: default_tablespace in postgresql.conf is used instead of the database's default.
2019-10-17 09:23:10+00Crevon VirgileRE: BUG #16026: default_tablespace in postgresql.conf is used instead of the database's default.
2019-10-18 11:40:17+00Alvaro HerreraRe: BUG #16026: default_tablespace in postgresql.conf is used instead of the database's default.