intermittent error: cannot find steampipe server when refreshing connections

[binaek]

We haven't found a reliable way to reproduce this yet!

When trying to start steampipe it errors out saying:
Error: failed to refresh connections: pq: server "steampipe" does not exist

[vielmetti]

I just ran into this on a fresh install from master

Error: failed to refresh connections: pq: server "steampipe" does not exist

emv@bastion-01:~$ steampipe -v
steampipe version 0.3.1

[e-gineer]

Hey @vielmetti ... thanks for reporting and sorry for the failure there.

A few follow up questions that would help us:

• Did it work if you tried running it again? Or does it fail consistently?
• Was steampipe previously installed on that machine?
• If steampipe was previously installed, do you know if it was still running?
• If it's still failing, what do you get from running ps aux | grep steampipe?

[vielmetti]

Thanks @e-gineer , here's a followup

• It fails consistently, even on a brand-new instance from scratch
• I've only tested on Ubuntus; the Mac version seems to work just fine

ps shows this

emv      3257836  0.0  0.0 204896 17280 ?        S    00:07   0:00 /home/emv/.steampipe/db/12.1.0/postgres/bin/postgres -p 9193 -c listen_addresses="*" -c application_name=steampipe -c cluster_name=steampipe -c autovacuum=off -c bgwriter_lru_maxpages=0 -c effective-cache-size=64kB -c fsync=off -c full_page_writes=off -c maintenance-work-mem=1024kB -c password_encryption=scram-sha-256 -c random-page-cost=0.01 -c seq-page-cost=0.01 -c synchronous_commit=off -c temp-buffers=800kB -c timezone=UTC -c track_activities=off -c track_counts=off -c wal-buffers=32kB -c work-mem=64kB -c jit=off -c log_statement=all -c log_min_duration_statement=2000 -c logging_collector=on -c log_min_error_statement=error -c log_directory=/home/emv/.steampipe/logs -c log_filename=database-%Y-%m-%d.log -D /home/emv/.steampipe/db/12.1.0/data
emv      3257837  0.0  0.0  63260  4132 ?        Ss   00:07   0:00 postgres: steampipe: logger
emv      3257839  0.0  0.0 205028  5464 ?        Ss   00:07   0:00 postgres: steampipe: checkpointer
emv      3257840  0.0  0.0 204896  4084 ?        Ss   00:07   0:00 postgres: steampipe: background writer
emv      3257841  0.0  0.0 204896  4084 ?        Ss   00:07   0:00 postgres: steampipe: walwriter
emv      3257842  0.0  0.0  63340  4148 ?        Ss   00:07   0:00 postgres: steampipe: stats collector
emv      3257843  0.0  0.0 205316  6524 ?        Ss   00:07   0:00 postgres: steampipe: logical replicat

which all looks good, but the logfile has this:

2021-03-19 23:57:03.920 UTC [3257682] LOG:  hostssl record cannot match because SSL is disabled
2021-03-19 23:57:03.920 UTC [3257682] HINT:  Set ssl = on in postgresql.conf.
2021-03-19 23:57:03.920 UTC [3257682] CONTEXT:  line 99 of configuration file "/home/emv/.steampipe/db/12.1.0/data/pg_hba.conf"
2021-03-19 23:57:03.920 UTC [3257682] LOG:  hostssl record cannot match because SSL is disabled
2021-03-19 23:57:03.920 UTC [3257682] HINT:  Set ssl = on in postgresql.conf.
2021-03-19 23:57:03.920 UTC [3257682] CONTEXT:  line 113 of configuration file "/home/emv/.steampipe/db/12.1.0/data/pg_hba.conf"
2021-03-19 23:57:03.920 UTC [3257682] LOG:  hostssl record cannot match because SSL is disabled
2021-03-19 23:57:03.920 UTC [3257682] HINT:  Set ssl = on in postgresql.conf.
2021-03-19 23:57:03.920 UTC [3257682] CONTEXT:  line 115 of configuration file "/home/emv/.steampipe/db/12.1.0/data/pg_hba.conf"

[e-gineer]

Tracking this over in #319