steampipe icon indicating copy to clipboard operation
steampipe copied to clipboard

On fresh install, when plugin install is run with a service running, running a query immediately after plugin install fails

Open kaidaguerre opened this issue 2 years ago • 0 comments

The following shell script

  export STEAMPIPE_INSTALL_DIR=foo_test
  rm -rf foo_test
  steampipe service start
  steampipe plugin install chaos
  steampipe query "select time_col from chaos_cache_check limit 1"
  steampipe query --output json "select from_qual_column from chaos_transforms where id=2"

results in either the error

Error: plugin manager: no connection config loaded for connection 'chaos'

or

Error: duplicate key value violates unique constraint "pg_namespace_nspname_index" (SQLSTATE 23505)

putting a delay after the plugin install removes the error

  export STEAMPIPE_INSTALL_DIR=foo_test
  rm -rf foo_test
  steampipe service start
  steampipe plugin install chaos
  sleep 1
  steampipe query "select time_col from chaos_cache_check limit 1"
  steampipe query --output json "select from_qual_column from chaos_transforms where id=2"
  steampipe service stop

also, not starting a service fixes the error:

  export STEAMPIPE_INSTALL_DIR=foo_test
  rm -rf foo_test
  steampipe plugin install chaos
  steampipe query "select time_col from chaos_cache_check limit 1"
  steampipe query --output json "select from_qual_column from chaos_transforms where id=2"

kaidaguerre avatar Sep 07 '22 11:09 kaidaguerre