Page 1 of 2

Failed to Create Index

Posted: 05 Jun 2024, 11:09
by koalakoala
Hi., Trying to setup Terramaster photos but when I start TM photos, it redirects me to the media index.
If I 'enable media indexing' I get 2 messages:
- Configuration saved
- Failed to create index (in status).
Restarted, rebooted and checked that I have the latest TOS and no chance to make it work.

Does anyone knows what to do in this case?
Thanks in advance,
Cheers


Screnshot
tttt.png

Re: Failed to Create Index

Posted: 06 Jun 2024, 09:04
by TMzethar
The situation you encountered is almost unprecedented. Please contact the technical support e-mail or the official website home page customer service, we can arrange for you to engineer remote troubleshooting.

Re: Failed to Create Index

Posted: 11 Jun 2024, 11:56
by koalakoala
Will do. thanks

Re: Failed to Create Index

Posted: 25 Jun 2024, 03:55
by koalakoala
Organised a meeting with Terramaster support and they were able to fix this.
Thanks!

Re: Failed to Create Index

Posted: 04 Oct 2024, 15:35
by MickMin
Good day!
I have an absolutelly same problem. Please inform me how to fix it.
F4-424, TOS 6.0.507-00129

Re: Failed to Create Index

Posted: 04 Oct 2024, 17:43
by TMpzhen
MickMin wrote: 04 Oct 2024, 15:35
Did you encounter the issue of unable to enable media indexing after upgrading to TOS 6.0.507? Did this issue occur before the upgrade?

Re: Failed to Create Index

Posted: 05 Feb 2025, 00:28
by richie1201
I have the same issue after upgrading to 6.0.610. I can't get it to index the media files.

Re: Failed to Create Index

Posted: 05 Feb 2025, 14:47
by IrisLi
richie1201 wrote: 05 Feb 2025, 00:28
Hello!Is it still impossible to enable media indexing after rebooting the system?
If that's the case, it is recommended to visit the official website and contact the online customer service to schedule a remote check.

Re: Failed to Create Index

Posted: 26 Feb 2025, 00:51
by bertieuk
Similar issue on 5.1.145 after installing photos.

Enable media indexing and unchecks itself. Checking media.log it was having an issue with /Volume1/@system/media/sqlite/files.db which already exists (1.9Gb, possibly a previous index?)
Moved this out of the way and I now have an sql error: sql.c:310: error: sql:INSERT INTO PHOTO ........ ON CONFLICT DO NOTHING; PGSQL 7 ERROR ERROR: column "year" of relation "photo" does not exist

Changed to psql user, connected to database, renamed photo to photo_old, sql.c:310: error: sql:INSERT INTO PHOTO ....... ON CONFLICT DO NOTHING; PGSQL 7 ERROR ERROR: relation "photo" does not exist

So looks like the media index isn't correctly 1) checking if sqlite db exists and removing it & 2) checking the structure of the postgres is correct (should drop and re-create first)

Re: Failed to Create Index

Posted: 26 Feb 2025, 18:09
by TMzethar
bertieuk wrote: 26 Feb 2025, 00:51
The update of Terra Photos may require you to rebuild the media index to continue normal use.
Please try to rebuild the media index.