Search Indexing with Enabled Board

Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Forum rules
Temporary forum to obtain support while phpBB.com is offline.
Please use the support forum on phpBB.com
Locked
epicycler
Registered User
Posts: 11
Joined: Thu Feb 05, 2009 9:41 am

Search Indexing with Enabled Board

Post by 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
I've been banned
Posts: 280
Joined: Mon Feb 02, 2009 5:39 pm

Re: Search Indexing with Enabled Board

Post by bolverk »

Is the indexing actually running or is it hung? 30 hours seems a bit excessive. :?
epicycler
Registered User
Posts: 11
Joined: Thu Feb 05, 2009 9:41 am

Re: Search Indexing with Enabled Board

Post by 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.
User avatar
Lumpy Burgertushie
Registered User
Posts: 1006
Joined: Tue Feb 28, 2006 5:26 pm

Re: Search Indexing with Enabled Board

Post by Lumpy Burgertushie »

It should not hurt anything. If posts are made, then some words might not get indexed right away.
robert
jage
Registered User
Posts: 19
Joined: Fri Feb 06, 2009 6:47 pm

Re: Search Indexing with Enabled Board

Post by 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
Registered User
Posts: 11
Joined: Thu Feb 05, 2009 9:41 am

Re: Search Indexing with Enabled Board

Post by epicycler »

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