search engine

Recommendations for the Cichlid Room Companion home page or error reporting
Post Reply
User avatar
Philippe Burnel
CichlidRoom Expert
Posts: 1109
Joined: Thu Nov 27, 2003 5:54 am
Location: France/ Normandy
Contact:

search engine

Post by Philippe Burnel » Fri Nov 11, 2011 2:07 am

Seems there is a problem to find topics in the forum.
When I clic on ""view new post" I get this anser "Sorry but you cannot use search at this time. Please try again in a few minutes."

User avatar
Willem Heijns
CichlidRoom Expert
Posts: 800
Joined: Wed Jun 22, 2005 4:18 pm
Location: Stiphout, Netherlands

Re: search engine

Post by Willem Heijns » Fri Nov 11, 2011 3:15 am

Same here...
Slàinte mhath!

Uilleam

User avatar
Juan Artigas
Administrator
Posts: 1432
Joined: Tue Nov 25, 2003 7:37 pm
Location: San Luis Potosi, México
Contact:

Re: search engine

Post by Juan Artigas » Fri Nov 11, 2011 9:56 am

I am sorry for the inconvenience with this. In the past week the forum was under attack. This caused the database server where it is located to restart in repeated occasions, bringing down the forum and other databases hosted at the same server. My internet service provided decided to shut down our forum then. In researching the issue it became apparent that the attackers were using the search engine with automatic queries that produced near to a million rows examined each, causing the database engine to collapse (this is not google). I then limited the amount of searches that can be done in a certain amount of time and apparently that made the trick. So you as user can just make a search every ten seconds. Tell me please if this is happening with all your searches or just when you do searches repeatedly. Cheers
Juan Miguel Artigas
Editor

The Cichlid Room Companion
http://www.cichlidae.info

User avatar
Juan Artigas
Administrator
Posts: 1432
Joined: Tue Nov 25, 2003 7:37 pm
Location: San Luis Potosi, México
Contact:

Re: search engine

Post by Juan Artigas » Fri Nov 11, 2011 10:01 am

Alright, I had also limited the amount of processor power a search can use, I guess I went very low so complex searches were not being carried out, so I increased it a little bit and it seems to work much better.
Juan Miguel Artigas
Editor

The Cichlid Room Companion
http://www.cichlidae.info

Bas Pels
Posts: 2247
Joined: Fri Mar 03, 2006 9:17 am
Location: Nijmegen - the Netherlands

Re: search engine

Post by Bas Pels » Fri Nov 11, 2011 10:07 am

after using the search engine, and reding the above, I went back. Than I was informed I could not search now

So, obviously, the situation has not yet returned to normal

User avatar
Juan Artigas
Administrator
Posts: 1432
Joined: Tue Nov 25, 2003 7:37 pm
Location: San Luis Potosi, México
Contact:

Re: search engine

Post by Juan Artigas » Fri Nov 11, 2011 10:15 am

Well I just did a few searches and they worked. If I keep getting reports I will increase the CPU limit a bit, but not much. Oh when make searches please make sure you are logged in, guests are much more limited.
Juan Miguel Artigas
Editor

The Cichlid Room Companion
http://www.cichlidae.info

Dan Woodland
CichlidRoom Expert
Posts: 3049
Joined: Wed Mar 01, 2006 9:49 am

Re: search engine

Post by Dan Woodland » Fri Nov 11, 2011 10:29 am

The search does work Juanmi but it seems to be random. For example, if I search now, log off and log back in it won't work but if I'm logged in for a few minutes the search will work.

User avatar
Juan Artigas
Administrator
Posts: 1432
Joined: Tue Nov 25, 2003 7:37 pm
Location: San Luis Potosi, México
Contact:

Re: search engine

Post by Juan Artigas » Fri Nov 11, 2011 10:37 am

Thanks Woody I will keep my eyes open on this
Juan Miguel Artigas
Editor

The Cichlid Room Companion
http://www.cichlidae.info

User avatar
Philippe Burnel
CichlidRoom Expert
Posts: 1109
Joined: Thu Nov 27, 2003 5:54 am
Location: France/ Normandy
Contact:

Re: search engine

Post by Philippe Burnel » Fri Nov 11, 2011 10:39 am

Seems to work now.
Thanks

Philippe

Post Reply

Return to “Suggestions”