#Missing "pg_vector_index_stat" (Getting to v1.95.0, Standard install, but botched upgrade)

1 messages · Page 1 of 1 (latest)

copper remnant
#

I attempted to upgrade my standard install (defaults with docker compose), but messed up the database upgrade due to have versions locked manually and mixing up versions. I think I've sorted most of it out, but am still having issues.
I have not been able to run "SELECT pgvectors_upgrade();", nor "GRANT SELECT ON TABLE pg_vector_index_stat to postgres;" Neither is found.

Under \d+, I have:
vectors | pg_vector_index_info | view | postgres | permanent | | 0 bytes |
I do not have "pg_vector_index_stat"

Under \z, I do not have "pg_vector_index_stat"

Is there a way to manually create that?

next muralBOT
#

:wave: Hey @copper remnant,

Thanks for reaching out to us. Please follow the recommended actions below; this will help us be more effective in our support effort and leave more time for building Immich immich.

References

Checklist

  1. :ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
  2. :ballot_box_with_check: I have read applicable release notes.
  3. :ballot_box_with_check: I have reviewed the FAQs for known issues.
  4. :ballot_box_with_check: I have reviewed Github for known issues.
  5. :ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
  6. :ballot_box_with_check: I have uploaded the relevant logs, docker compose, and .env files using the buttons below or the /upload command.
  7. :ballot_box_with_check: I have tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable

(an item can be marked as "complete" by reacting with the appropriate number)

If this ticket can be closed you can use the /close command, and re-open it later if needed.

next muralBOT
copper remnant
#

Database info in more relevant, but another symptom is that all of my images appear as blurred thumbnails, which can't be unblurred or opened. Oddly, hovering over a video results in the thumbnail version of the video playing but the full size video will not open when clicked.

copper remnant
#

Looks like this might be what i need. If I'm reading it right, the last set of commands here creates what's missing for me. I suspect I'm missing other items as well from this post. Will try and report back. #1221256493081428131 message