[Beta] Sphinx search for phpBB 1.0.beta2

[yais]

Thanks for the update.

When do you plan on releasing the mod as a file rather then code.

[roobarb]

Naderman, have you plans on making your mod work with Sphinx 0.9.8-rc1 ?

(this compiles fine on CentOS 5, but 0.9.7 blows chunks and dies with "/usr/bin/ld: skipping incompatible /usr/lib/mysql/libmysqlclient.so when searching for -lmysqlclient" ) etc

[naderman]

Yeah I'm planning to support 0.9.8 too. I'm a little busy with other stuff right now. But as soon as I get back to this I'll add some of the missing configuration items I still wanted to add and add support for 0.9.8. After that it should be ready for a first beta release.

[roobarb]

looking forward to it

[yais]

when is this being released?

[roobarb]

update: I recently got better hosting where i can install my own OS - so, sphinx for phpBB3 is now working on a freebsd-7.0 (amd 64) system running 2GB RAM, it is smooth

[roobarb]

update: I recently got better hosting where i can install my own OS - so, sphinx for phpBB3 is now working on a freebsd-7.0 (amd 64) system running 2GB RAM, it is smooth

scratch that - wasnt using sphinx - when I try to make a sphinx index, it times out no matter how long I have the value set to in php.ini

[naderman]

The sphinx index creation is executed in a seperate process so PHP does not wait for the indexing to be completed.

[roobarb]

my fault - i should have provided more detail, and been more accurate.

I install everything, then select the sphinx backend. Then when i go to create the index, ACP will not go to that page - mysql uses 100% of cpu and there it stays. I don't think at this stage sphinx is even creating the index. It is timing out when loading the page that the index is created from.

Would it be more correct to create the index *then* select the backend? I'll try it again anyway.

[naderman]

No, you need to select the backend first. Are you using sphinx 0.9.7? It doesn't work with 0.9.8 yet.

[roobarb]

No, you need to select the backend first. Are you using sphinx 0.9.7? It doesn't work with 0.9.8 yet.

yes, 0.9.7. It's in the ports tree

[naderman]

Well then I don't know why this could happen.

[roobarb]

OK. On a bare board, same server, 3.0.1 RC1 - it installed and i was able to select sphinx for use flawlessly.

So it has to be something to do with the active board - but what? hmmm.

What has your experience been with installing it on a board that already has 3000 topics?

On the board with all the posts in, also 3.0.1 RC1, same server - it installed OK, then it confirms the change of backend, I get the green screen with the link in to go to the page where you reindex posts. This time I managed to click on the reindex button. it bailed me out of the board back to the login screen.

I sign in again and get to the ACP, go to maintenance then click on search index. Apache goes to 100% CPU. I can repeatedly click on it - the screen never changes but each click launches another apache process. This is what top looks like after 10 or so clicks:

Code: Select all

last pid: 48784;  load averages: 18.98, 14.88,  8.01                                                                    up 2+19:34:57  04:03:03
102 processes: 20 running, 82 sleeping
CPU states: 47.4% user,  0.0% nice, 52.6% system,  0.0% interrupt,  0.0% idle
Mem: 267M Active, 1610M Inact, 295M Wired, 644K Cache, 214M Buf, 1623M Free
Swap: 4092M Total, 4092M Free

  PID USERNAME  THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU COMMAND
48489 www         1 127    0   155M 28196K RUN    0   0:53 10.06% httpd
48638 www         1 128    0   154M 27096K RUN    1   0:45  9.96% httpd
48555 www         1 128    0   154M 27536K RUN    0   0:50  9.86% httpd
48674 www         1 128    0   154M 27096K RUN    0   0:44  9.86% httpd
48668 www         1 127    0   154M 27096K RUN    1   0:44  9.86% httpd
48490 www         1 127    0   154M 27892K RUN    1   4:58  9.81% httpd
48651 www         1 128    0   154M 27096K RUN    0   0:44  9.81% httpd
48558 www         1 127    0   154M 27416K RUN    1   8:59  9.77% httpd
48492 www         1 127    0   154M 27836K RUN    1   0:51  9.77% httpd
48487 www         1 127    0   154M 27808K RUN    1   0:46  9.77% httpd
48644 www         1 127    0   154M 27096K RUN    0   0:45  9.77% httpd
48652 www         1 127    0   154M 27096K RUN    0   0:44  9.77% httpd
48556 www         1 128    0   154M 27936K RUN    1   0:51  9.72% httpd
48686 www         1 128    0   154M 27096K RUN    0   0:43  9.72% httpd
48650 www         1 127    0   154M 27096K RUN    1   0:45  9.67% httpd
48680 www         1 128    0   154M 27096K RUN    1   0:43  9.67% httpd
48488 www         1 127    0   154M 27832K RUN    1   1:15  9.62% httpd
48493 www         1 128    0   155M 27888K RUN    1   0:57  9.57% httpd
48491 www         1 127    0   154M 27536K CPU0   0   0:54  9.57% httpd
10204 mysql      28   4    0 64560K 46020K sbwait 0  20:07  0.00% mysqld
 9732 roobarb     1  96    0  7504K  2408K select 0   0:04  0.00% screen

The board still runs ok but that screen just won't load

[roobarb]

If it is allowed to timeout, the eventual error is

Code: Select all

Fatal error: Maximum execution time of 3000 seconds exceeded in /usr/local/www/apache22/data/www.growveg.info/includes/search/fulltext_sphinx.php on line 1177

If the existing db is dumped and a default one loaded, still same problem.

[roobarb]

replicated the problem on a fresh install now. It seems that you can select maintenance > search index ONCE, click on build sphinx index, exit out of the ACP. From then on, you can not ever select maintenance > search index again - the request never completes. This is on an empty board now, fresh install, fresh svn of sphinx plugin