[SOLVED] Unable to create index in collection

Since yesterday whenever I try to create an index in the collection, it shows the success toast on the top but in the cloud dashboard, it shows as failed. Is this a server issue or something going wrong on my end?

TL;DR

Issue: Unable to create index in collection. Error message: "Specified key was too long; max key length is 3072 bytes." User tried modifying attributes and creating a new collection but still unable to create index. Collection may be in an inconsistent state due to previous database upgrade/outage problems. Solution: Recreate the collection to clean up the inconsistent state. Full text indexes can only be created on string attributes, so check the attribute types. Consider using a string instead of integer for the "Time" attribute if ordering search results is needed. It is possible that the failure to create indexes is a server issue. User should provide

Please provide an update on this issue it has been more than 12hrs.

You can only have full text indexes on string attributes. What's the type on those time attributes?

Time is int but I need it to order the search results.

Ya same problem. Maybe you can use a (iso formatted) string instead?

Ok I will try it out.

Even creating a Full text index with a string attribute is not working. The index creation gets failed all the time.

What's your project id?

647ad9717a0ab865a248

soooo your collection has somehow gotten into an inconsistent state. Were you creating indexes when we had our database upgrade/outage problems?

I did create two of the indexes and although they show as failed they actually work.

ya im not sure what happened. if you want to clean it up, the easiest thing to do would be to recreate the collection

Okk I will try that out and give an update.

Created a new collection based on the previous one however when I try to combine three fields in a index it still fails. Is this due to the inconsistent state or only two attributes can be combined in a index.