|HAWQ||1.x and 18.104.22.168|
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.
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,"
The issue is fixed in HAWQ 22.214.171.124. Upgrade to 126.96.36.199 or above.
- Change the Database settings to remove the search_path being set automatically on login: ALTER DATABASE db_name SET search_path TO default;
- Verify that search_path is not set for the Database: select datname,datconfig from pg_database where datname = 'db_name';
- Set the required search_path for that session after logging in.