Data Set Configuration Error after adding a new chart

[dorviedev]

I have a bunch of looker reports all with a postgres data source, which has worked fine for months now. After a new chart on one of the reports, they all broke. Some have cryptic errors like this one:

A load-shedding retryable throttled error could not be retried due to Extensible Stubs retrying limits (see go/stubs-retries). (old status: generic::unavailable: recvmsg: Connection reset by peer (104))

The database is still running and accessible. Copying an existing report showed some of the charts back, but I haven't found a way to get them all back at once.

[a_aleinikov · Accepted solution]

Hi @dorviedev ,

This error usually points to connection exhaustion or throttling between Looker and your Postgres database.

Try this:

• Check Postgres for connection limits or recent spikes in usage.

• Reduce the number of simultaneous queries (for example, simplify or split dashboards).

• Restart the Looker connection or create a new database connection in Looker.

• Monitor Looker’s query and connection logs for specific bottlenecks.

[dorviedev]

Thanks. It all came back after a few hours