search

iv-org / invidious

Invidious is an alternative front-end to YouTube
https://invidious.io
GNU Affero General Public License v3.0
16.38k stars 1.83k forks source link

[Bug] Subscriptions Broken #3123

Closed Abystus closed 2 years ago

Abystus commented 2 years ago

Describe the bug Error appears when attempting to load subscriptions using https://vid.puffyan.us/feed/subscriptions.

Steps to Reproduce

  1. Log in
  2. Move to subscriptions tab (https://vid.puffyan.us/feed/subscriptions)

Screenshots image

le-honk1 commented 2 years ago

I am having the same issue

felixdv commented 2 years ago

Same here

unixfox commented 2 years ago

Is this still an issue?

unixfox commented 2 years ago

@ItsSt0ne Pinging owner of the instance

Abystus commented 2 years ago

@unixfox It seems to be resolved. Thanks!

GauthierPLM commented 1 year ago

I had the same issue after upgrading my PG cluster from v12 to v14. Reading at the error, the view existed but was simply missing data, making it invalid. I connected via psql and ran REFRESH MATERIALIZED VIEW <view name>; and it fixed the issue.

@unixfox I believe the solution would be for Invidious to refresh the view soon after starting or if this error is caught.

unixfox commented 1 year ago

I had the same issue after upgrading my PG cluster from v12 to v14. Reading at the error, the view existed but was simply missing data, making it invalid. I connected via psql and ran REFRESH MATERIALIZED VIEW <view name>; and it fixed the issue.

@unixfox I believe the solution would be for Invidious to refresh the view soon after starting or if this error is caught.

The real solution is to merge this PR: https://github.com/iv-org/invidious/pull/2469 But it requires some DB changes.

Quix0r commented 1 year ago

I also came across this one and the temporary solution was tor recreate the views. After that, the granted permissions were gone and an error message about this came. I then granted access to these individual views (I only have 2 users, including myself). I still feel that this might not be the best, flexible solution, but the subscriptions view works again. GRANT SELECT, INSERT, UPDATE, DELETE ON subscriptions_<ID_HERE> TO kemal;