search

RunningJon / TPC-DS

Greenplum TPC-DS benchmark
113 stars 96 forks source link

Should 02_init/rollout.sh set search path for ADMIN_USER? #26

Closed funcode closed 1 year ago

funcode commented 2 years ago

It is running "ALTER USER $USER SET search_path=...", but I think it should be "ALTER USER $ADMIN_USER SET search_path..." as in fact the script is run by ADMIN_USER via "su -l $ADMIN_USER". This will cause that no queries got run when ADMIN_USER is not the login user.

RunningJon commented 2 years ago

But that doesn't impact the ability for the script to successfully execute the test.

funcode commented 2 years ago

It does when I set ADMIN_USER to "gpadmin" but I ran the script from another user's login shell.

RunningJon commented 2 years ago

The script is run as root and it then switches to the ADMIN_USER. At this point, the $USER variable is the ADMIN_USER.