[bug] company-statistics-by-repository-group broken for k8s

[dims]

https://k8s.devstats.cncf.io/d/8/company-statistics-by-repository-group?orgId=1&var-period=q&var-metric=activity&var-repogroup_name=Kubernetes&var-repo_name=&var-companies=All&inspect=1&inspectTab=error

shows this failure

[lukaszgryglicki]

Fixed, thanks for reporting.

[dims]

@lukaszgryglicki same problem with another company ( same URL! https://k8s.devstats.cncf.io/d/8/company-statistics-by-repository-group?orgId=1 )

[lukaszgryglicki]

Will TAL tomorrow.

[lukaszgryglicki]

Checking this.

[lukaszgryglicki]

I think I've found a bug, now testing if that solves this for good...

[lukaszgryglicki]

It fixed this, @dims, the issue seemed to be that

schemaname = 'public' and substring(tablename from %s) is not null

when called with %s = ^scompany_activity(_repos)?$ was returning a hit for table scompany_activity_repos but not for scompany_activity which doesn't seem to be OK for me (the expression in ()? should just be optional and it should hit both tables).

I've changed this to the ~ Postgres operator and it returns the correct hits now:

schemaname = 'public' and tablename ~ %s

Some tables were not returned as candidates to be updated with possible columns list, so the outcome was that columns were missing.

Hope it won't reappear...

[lukaszgryglicki]

Rechecked today (both the DB data and the dashboard) and it seems to be OK.

[lukaszgryglicki]

Rechecked once more after 2 weeks and it is still OK, so I'm assuming that this fixed it :)