elasticsearch index reset or rebuild triggers error

[giannik]

When enabling elastic search and creating an index if you try to reset or rebuild the index I get the following error :

I am using "ConnectionType": "CloudConnectionPool" in the appsettings to connect to elastic search using a cloud Id.

@Skrypt @MikeAlhayek

[MikeAlhayek]

It seems to be data related.

But also, look at the yessql warning before

If you can somehow export your content-type and content-items that are expected to be indexed, I can try to reproduce it locally. Otherwise, you may want to take your content definition and items and import them on a new site using OC source and trace the problem.

@Skrypt may have other ideas.

[giannik]

It happens even on an index with an indexed content type that has no content items yet.

[MikeAlhayek]

What version are you using? I just tried to reset an index and it worked for me. I think the code I tested is using 1.9 preview

maybe share you're content definition. perhaps you have a unique fields that are causing the issue

[giannik]

in the indexingTasks table i had some contentitem ids for indexing from a year ago. I deleted all these records and started from zero and it worked.