steampipe fresh installation not working on Ubuntu 20.04 LTS

[paolo-losi]

Describe the bug Fresh installation is install script does not work on ubuntu 20.04 LTS

Steampipe version (steampipe -v) $ steampipe -v Steampipe v0.21.5

To reproduce $ steampipe plugin install steampipe

steampipe [====================================================================] Done

Installed plugin: steampipe@latest v0.10.0 Documentation: https://hub.steampipe.io/plugins/turbot/steampipe

$ steampipe query "select name from steampipe_registry_plugin;" Warning: You have a mod.sp file in your home directory. This is not recommended. As a result, steampipe will try to load all the files in home and its sub-directories, which can cause performance issues. Best practice is to put mod.sp files in their own directories. Hit Ctrl+C to stop.

Error: no rows in result set $ find . -name "mod.sp" $ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 20.04.6 LTS Release: 20.04 Codename: focal

Additional context recompiling from source with go 1.21.6 the warning disappears but the query still returns no rows

[pskrbasu]

@paolo-losi Thank you for reporting.

I'll try to install it in Ubuntu 20.04 LTS and see if I can reproduce it.

[pskrbasu]

@paolo-losi Seems like a bug we introduced in v0.21.5. We are working on a fix. Thanks ✌️

[pskrbasu]

@paolo-losi v0.21.6 is released. I tried it out - seems to be working now!

[paolo-losi]

I can confirm that I get no warnings now. But I still get no rows:

`$ which steampipe /usr/local/bin/steampipe $ steampipe -v Steampipe v0.21.6 $ steampipe plugin install steampipe

steampipe [====================================================================] Already installed

To update this plugin: steampipe plugin update steampipe To update all plugins: steampipe plugin update --all

$ steampipe plugin update --all

turbot/net [====================================================================] Latest already installed
turbot/steampipe [====================================================================] Latest already installed

$ steampipe query "select name from steampipe_registry_plugin;" Error: no rows in result set $ `

[pskrbasu]

@paolo-losi I ran the same query as above, but I did not get the error. I do get the result.

Can you try with STEAMPIPE_LOG=trace steampipe query "select name from steampipe_registry_plugin;" and check the logs in ~/.steampipe/logs/plugin-yyyy-mm-dd.log file? You might see some errors or warnings there.

[paolo-losi]

here you have the logs for the command:

$ STEAMPIPE_LOG=trace steampipe query "select name from steampipe_registry_plugin;"

Thanks!

database-2024-02-07.log steampipe-2024-02-07.log

[pskrbasu]

@paolo-losi Do you not have any plugin-yyyy-mm-dd.log file?

Can you uninstall the steampipe plugin and re-install and try again with steampipe v0.21.7?

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 90 days with no activity.