Pivotal Knowledge Base

Follow

HAWQ Error - FATAL: Invalid Value for Parameter "Search_path": "Public,"

Environment

 Product  Version
 HAWQ  1.x and 2.0.0.0
 OS  RHEL 6.x

Symptom

When search_path is set for a Database with the ALTER DATABASE command, for example: ALTER DATABASE db_name SET search_path to public, schema01, schema02;
Then the dispatcher is unable to dispatch the query to the segments.

Error Message:

gpadmin=# select * from table01;
ERROR: Error dispatching to seg0 hwq-sdw1:40000: connection pointer is NULL
DETAIL: Master unable to connect to seg0 hwq-sdw1:40000: FATAL: invalid value for parameter "search_path": "public,"
gpadmin=# 

Resolution

Fix

The issue is fixed in HAWQ 2.0.1.0. Upgrade to 2.0.1.0 or above.

Workaround

  1. Change the Database settings to remove the search_path being set automatically on login: ALTER DATABASE db_name SET search_path TO default;
  2. Verify that search_path is not set for the Database: select datname,datconfig from pg_database where datname = 'db_name';
  3. Set the required search_path for that session after logging in.

 

 

Comments

Powered by Zendesk