turbot / steampipe

Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.
https://steampipe.io
GNU Affero General Public License v3.0
6.84k stars 264 forks source link

Error when starting Steampipe #2316

Closed sapg closed 1 year ago

sapg commented 2 years ago

Describe the bug A clear and concise description of what the bug is.

I installed Steampipe using brew on MacOS 10.15.7 (Catalina).

Initially, it worked, I could run steampipe query but after I tried installing and using a dashboard (which never loaded, it looked like it was loading something but it never appeared) I can't run steampipe query anymore, I get this error:

Error: error acquiring database connection, failed to create introspection tables: ERROR: invalid byte sequence for encoding "UTF8": 0x96 (SQLSTATE 22021)

Steampipe version (steampipe -v) 0.15.4

To reproduce As above.

Expected behavior I was hoping to do some Steampipe queries and I was hoping to use the AWS Thrifty dashboard.

sapg commented 2 years ago

I got a dashboard to load but I still get a database error, albeit a different one.

image

kaidaguerre commented 2 years ago

@sapg sorry for delay in following this up. A few questions:

e-gineer commented 2 years ago

As background, once you have a mod.sp file in a directory, Steampipe will recursively search for *.sp and *.sql files from that point. So, perhaps one of your files has invalid UTF8?