Search Indexing with Enabled Board

[epicycler]

silly question ....

conversion from v2 to v3 went well, 4 hours. Search indexing looks like taking more than 30 hours.

Is it safe to enable board while search indexing?

[bolverk]

Is the indexing actually running or is it hung? 30 hours seems a bit excessive.

[epicycler]

database is postgresql.

30 hours was calculated projection based on how fast posts were being indexed.

Sometime overnight (I'm in Australia) indexing stopped at 6199 of 87199 posts. Timeout error page from script. I also have an SQL statement using postgresql console to count distinct posts in table phpbb_search_wordmatch.

This could take "forever". Apart from the load on the server, is it "safe" to run search indexing while board is enabled.

[Lumpy Burgertushie]

It should not hurt anything. If posts are made, then some words might not get indexed right away.
robert

[jage]

I had to rerun the indexing several times, which I did by refreshing, watching table counts in phpMyAdmin until the wordlist and then the wordmatch stopped growing. It was all on a live board and you can check your progress by post by searching for the word in the last wordlist and checking the post id against your last. I also posted a rare word to ensure it was working.

Once the lists stopped growing I went back to the ACP (instead of refreshing) and used the Continue button one more time, it completed and gives a list of indexes again.

Incidentally the progress bar window does nothing and can be closed.

[epicycler]

thanks jage. Looks like I have a bigger problem somewhere.