Search error

Borf · March 19, 2002, 12:10 AM

While doing searches, I'm intermittently getting this error :

Fatal error: Maximum execution time of 30 seconds exceeded in /home/tfl/htdocs/forums/search.php on line 428

Note that the line number varies on each error. Thought you'd be interested.

yankytrash · March 19, 2002, 05:48 AM

What kind of search terms are you using?

Sounds like a typical server timeout on TFL's end, but I've never run across one here.

TheBluesMan · March 19, 2002, 09:52 PM

Has this problem recurred, Borf?

Borf · March 20, 2002, 01:08 AM

Interesting... I can reproduce it.
The original search was on

"gun safe"

it went out and sat for a bit, then returned the error on excessive execution time.
If I search on

"gun"

it comes up with the TFL error page saying it's dispatching an email to the staff.

I'm assuming this is due to the obscene number of threads containing this term.

However, doing a search on
"gun ammo"
works just fine.

Edit - "gun magazine" and "gun sight" also produce the error. using boolean AND has same effect.

hmmm

**Rich Lucibella** · March 20, 2002, 09:15 PM

Be careful what you ask for!

YT was right. It was simply tripping on a 30 second limit in the PHP module. I increased this to 60 seconds in the middle of the night. It wouldn't take, even after a restart of the database.

Next step: Server Reboot.

Result: Server down for 18 hours!

Now we know: It was all Borf's fault!

Rich

TheBluesMan · March 20, 2002, 09:15 PM

Thanks for the detailed response. It will be very helpful in trying to determine the cause of the error.

Thanks also for your continued patience while we readjust to our surroundings.

Borf · March 20, 2002, 11:38 PM

I'll be careful wishing in the future

Did you try restarting apache? If PHP is built as an apache module it could well have been caching the old values.

Thanks again for all the hard work!

March 19, 2002, 12:10 AM	#1
Borf Senior Member Join Date: February 24, 2001 Location: Middle Tennessee Posts: 424	Search error While doing searches, I'm intermittently getting this error : Fatal error: Maximum execution time of 30 seconds exceeded in /home/tfl/htdocs/forums/search.php on line 428 Note that the line number varies on each error. Thought you'd be interested. __________________ A great many people think they are thinking when they are merely rearranging their prejudices. -- Wiliam James If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money it values more, it will lose that, too. -- W. Somerset Maugham

March 19, 2002, 05:48 AM	#2
yankytrash Senior Member Join Date: April 17, 2001 Location: Farnham, Va Posts: 2,183	What kind of search terms are you using? Sounds like a typical server timeout on TFL's end, but I've never run across one here. __________________ Right turn, Clyde.

March 19, 2002, 09:52 PM	#3
TheBluesMan Moderator Emeritus Join Date: June 15, 1999 Location: Ohio Posts: 7,558	Has this problem recurred, Borf? __________________ -Dave Miller ΜΟΛΩΝ ΛΑΒΕ! NRA Certified Instructor: Pistol, Rifle, Shotgun, Home Firearms Safety, Personal Protection. Tick-off Obama - Join the NRA Today - Save $10

March 20, 2002, 01:08 AM	#4
Borf Senior Member Join Date: February 24, 2001 Location: Middle Tennessee Posts: 424	Interesting... I can reproduce it. The original search was on "gun safe" it went out and sat for a bit, then returned the error on excessive execution time. If I search on "gun" it comes up with the TFL error page saying it's dispatching an email to the staff. I'm assuming this is due to the obscene number of threads containing this term. However, doing a search on "gun ammo" works just fine. Edit - "gun magazine" and "gun sight" also produce the error. using boolean AND has same effect. hmmm __________________ A great many people think they are thinking when they are merely rearranging their prejudices. -- Wiliam James If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money it values more, it will lose that, too. -- W. Somerset Maugham

March 20, 2002, 09:15 PM	#5
Rich Lucibella Staff Join Date: October 6, 1998 Location: South Florida Posts: 10,229	Fixed now, BUT Be careful what you ask for! YT was right. It was simply tripping on a 30 second limit in the PHP module. I increased this to 60 seconds in the middle of the night. It wouldn't take, even after a restart of the database. Next step: Server Reboot. Result: Server down for 18 hours! Now we know: It was all Borf's fault! Rich __________________ S.W.A.T. Magazine Weapons, Training and Tactics for the Real World Join us at TFL or at AR15.com or on Facebook

March 20, 2002, 11:38 PM	#7
Borf Senior Member Join Date: February 24, 2001 Location: Middle Tennessee Posts: 424	I'll be careful wishing in the future Did you try restarting apache? If PHP is built as an apache module it could well have been caching the old values. Thanks again for all the hard work! __________________ A great many people think they are thinking when they are merely rearranging their prejudices. -- Wiliam James If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money it values more, it will lose that, too. -- W. Somerset Maugham