Trying to upgrade from unknown previous version
I'm trying to upgrade up to latest from a previous version, last updated sometime before the vectorchord change, but I'm running bare metal on Arch and running into a problem of not having certain tables/relations, namely "face_index" and "clip_index". It is refusing to start without these, and I don't know how to generate them.
I also never used the machine-learning portion before, so it shouldn't have any data worth keeping anyways, if what's needed is dropping some tables.
If someone would be able to help me or point me to a resource to help me either get these new relations, be it by creating them myself, or by re-creating a new DB and importing in my old data and doing any necessary upgrades to it, I'd be very appreciative.
9 Replies
:wave: Hey @Dr America,
Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:.
References
- Container Logs:
docker compose logs docs
- Container Status: docker ps -a docs
- Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
- Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA
Checklist
I have...
1. :ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time).
2. :ballot_box_with_check: read applicable release notes.
3. :ballot_box_with_check: reviewed the FAQs for known issues.
4. :ballot_box_with_check: reviewed Github for known issues.
5. :ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy).
6. :ballot_box_with_check: uploaded the relevant information (see below).
7. :ballot_box_with_check: 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)
Information
In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:
- Your docker-compose.yml and .env files.
- Logs from all the containers and their status (see above).
- All the troubleshooting steps you've tried so far.
- Any recent changes you've made to Immich or your system.
- Details about your system (both software/OS and hardware).
- Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h).
- The version of the Immich server, mobile app, and other relevant pieces.
- Any other information that you think might be relevant.
Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)
If this ticket can be closed you can use the /close command, and re-open it later if needed.The face_search and smart_search tables/relations also do not exist
Also the "corrupted migrations" were from trying to revert to an earlier version from latest, but I just copied my backup again to try another earlier version
Successfully submitted, a tag has been added to inform contributors. :white_check_mark:
Seems I'm having the same issue as https://github.com/immich-app/immich/discussions/17332
[Discussion] TypeError: Cannot read properties of undefined (reading 'dimsize') (immich-app/immich#17332)
at least on version 1.30.3
is there any simple way to build a new immich db and then just import all of my old data into it?
if so, then I could just
1. save old data for backup/restore
2. delete old immich db and create a new one
3. import all of my old data into new table
and then it should work (hopefully)
get these new relations, be it by creating them myself, or ...You can check DB schema drift with (assuming default
database service name in compose and version 1.136+, for earlier versions remove server/ from the path to migrations.js)
The tables face_search and smart_search may be missing/lost if you restored from backup without the required ML/vector extension.
PG restore would try to create tables. And fail. Because these tables depend on extensions.I recommend starting here by figuring out what version you’re coming from. Then you’ll need to make all needed breaking changes
Good chance you jumped over a lot of stuff