Stemapipe service restart stuck after first attempt about steampipe HOT 4 OPEN

I have a different but similar issue, using:

powerpipe v0.4.0
aws plugin v0.139.0
steampipe v0.23.2

I create a config file and then run steampipe service start and then run powerpipe benchmark (aws compliance mod:latest), all in a docker container

Sometimes it works, sometimes I get a slew of errors like:

rpc error: code = Unavailable desc = error reading from server: read unix @->/tmp/plugin2367597389: read: connection reset by peer (SQLSTATE HV000

and

"scanIteratorBase cannot iterate: connection..."

from steampipe.

@jeffreymp17 I will try to reproduce this.

@idesofoctober is this something that you are seeing intermittently?

from steampipe.

This is happening every time

from steampipe.

@pskrbasu I'm looking at some reporting I created around this and across 419 accounts, it definitely DOES NOT happen with all accounts, but it happens consistently on the account it does occur with. Some additional context:

We run this on EKS and each account benchmark run is run in one EKS instance with it's own spc and credentials file (all of them created using the same underlying code). Happy to work with you re: what is the same/different about each account. I saw the issue posted here and thought it might be similar re: the overall database / connection load time/configuration, and my dockerfile does a steampipe service start, aws plugin install, and steampipe service stop. My code is doing a steampipe service start, wait 2 minutes, and then run benchmarks which (I think, my data and troubleshooting hasn't been super diligent) reduced the total number of accounts with this error.

One hypothesis I have (based on nothing tangible, but thought I'd share in case it raises an idea) is that the aws.spc for all of these is using * for region. Could the number or location of regions that are in play causing some difference in the load time (if the load time is in fact the issue?)?

I'm going on vacation soon, for next week, but if there is something I can look at re: differences between the accounts where this occurs and where this doesn't occur, i'll get back to you as soon as I can.

from steampipe.