Reindex Error at 1.2.2

[Chrysalis]

I posted on github also.

Now the ue0 has popped up as a bad index, but I dont know how to fix that one as the index appears to be the correct name.

I will leave that one alone for now as need to go to bed due to appointment tomorrow.

[BerndP]

HI everyone,

Is there any news on this issue, because we're facing it as well.

I have not checked yet if the indexes are static or not, though i assume the answer is: yes, they are static.

is there anything i can do to help you fixing this?
Do you need logs? Or a detailed description of the environment?

Maybe someone from the dev team can contact me via my account's mail address so that we can discuss steps for debugging and investigation - willing to help where ever i can!

Our current setup:
main poller on a veritas cluster
six remote pollers in different geo-locations, more to come in near future
~2500 monitored devices, currently migrating everything from an old 0.8.9 environment

Cheers & thanks!

[netniV]

you didn't say what version you had. There have been many fixes since 1.2.2, so you should move forward to 1.2.9 if you are still on that.

[thomas315]

Hello,

I've got around 30K bad index data sources. I would like to build a script (or sql query) to delete them. I've successfully manage to delete some of them using the CLI, but it will take too much time to delete them, one by one.

I guess i would be able to get a list of bad index data sources (sql query is already provided earlier in this post) (local_data_id), then if i got a list of related/associated graph, then i'll be able to script graph deletion (using cli/remove_graph).

So my issue is to find the sql query (or php function) that will allow me to get the graph id (local_graph_id) from the data id.

Thanks for your help

Thomas