search engine

Recommendations for the Cichlid Room Companion home page or error reporting

search engine

Postby Philippe Burnel » Fri Nov 11, 2011 3: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
Philippe Burnel
CichlidRoom Expert
 
Posts: 889
Joined: Thu Nov 27, 2003 6:54 am
Location: France/ Normandy

Re: search engine

Postby Willem Heijns » Fri Nov 11, 2011 4:15 am

Same here...
Slàinte mhath!

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

Re: search engine

Postby Juan Artigas » Fri Nov 11, 2011 10: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: 1360
Joined: Tue Nov 25, 2003 8:37 pm
Location: San Luis Potosi, México

Re: search engine

Postby Juan Artigas » Fri Nov 11, 2011 11: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
User avatar
Juan Artigas
Administrator
 
Posts: 1360
Joined: Tue Nov 25, 2003 8:37 pm
Location: San Luis Potosi, México

Re: search engine

Postby Bas Pels » Fri Nov 11, 2011 11: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
Bas Pels
 
Posts: 2014
Joined: Fri Mar 03, 2006 10:17 am
Location: Nijmegen - the Netherlands

Re: search engine

Postby Juan Artigas » Fri Nov 11, 2011 11: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
User avatar
Juan Artigas
Administrator
 
Posts: 1360
Joined: Tue Nov 25, 2003 8:37 pm
Location: San Luis Potosi, México

Re: search engine

Postby Dan Woodland » Fri Nov 11, 2011 11: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
Dan Woodland
CichlidRoom Expert
 
Posts: 2829
Joined: Wed Mar 01, 2006 10:49 am

Re: search engine

Postby Juan Artigas » Fri Nov 11, 2011 11: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
Juan Artigas
Administrator
 
Posts: 1360
Joined: Tue Nov 25, 2003 8:37 pm
Location: San Luis Potosi, México

Re: search engine

Postby Philippe Burnel » Fri Nov 11, 2011 11:39 am

Seems to work now.
Thanks

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


Return to Suggestions

Who is online

Users browsing this forum: No registered users and 0 guests