Indexing taking too long

Question

Hello,

I have 2 instances with the same number of issues and configuration, upgraded from 6.4 to 7.7v.

The indexing in 6.4 takes around 166186, where as the 7.7 takes 5437610. I found the below error. How do I fix it? What might cause this issue.

Please advice.

Thanks.

Veera rdy · Answer

Hi @Normann
The large numbers represent time taken for indexing in milliseconds.

We use an Oracle 12c Database.

The error doesn't exist anymore yet the indexing takes too long.

Thanks.

Normann P_ Nielsen _Netic_ · Answer

What does the large numbers in "The indexing in 6.4 takes around 166186, where as the 7.7 takes 5437610." represents?

The error above - I see it pretty often on JIRAs with Postgres database (never on Mysql) - I believe its only an error for a moment until the Index and Database has same number, eg. something asyncron stuff.