Search shutdown?

Glockster35 · November 26, 2001, 04:21 PM

What happened to the search function? Mine is saying it doesn't work because the administrators shut it down???

**Rich Lucibella** · November 26, 2001, 04:52 PM

It's being reindexed. I started about 2AM in hopes of not disturbing the Board. With 20,000,000+ search items (yeah, I was surprised too!), it was about 4/5ths done at noon today when the server crashed due to disk space problems. I've resolved that and will attempt a re-index this PM.
Rich

Glockster35 · November 26, 2001, 07:08 PM

Thanks Rich

And if you didn't already know you guys are doing one heck of a job with this board, and SWAT magazine.

Keep it up

Jody Hudson · November 26, 2001, 08:00 PM

Yes, thanks Rich. NO matter how much curmugeoning I do...

This is a great place and my favorite resource on the web... other than my sites of course... :lol

garrettwc · November 27, 2001, 01:16 PM

Rich, any word on status of the servers?

The search feature/find new posts link is still coming up "turned off by admin".

**Rich Lucibella** · November 27, 2001, 07:11 PM

Yup-
Started it again today...lost connection halfway thru and it crashed. Just restarted now. Perhaps by morning. It really is a long process, unless we shut the board down for about 10 hours.
Rich

NINE · November 28, 2001, 01:30 AM

Shut down for 10 hours, eh? Rich, I'll get back to you with a time that is good for me.

LilJoe · November 28, 2001, 05:26 AM

I feel the withdrawls coming already!!!!!!

rock_jock · November 28, 2001, 06:08 PM

This is disheartening. I am trying to do research for my next gun and I feel like a ship tossed about on the sea without my TFL archive resources.

BTW, I think this points to the incredible benefits the community of firearm enthusiasts receives from this site. If we don't say thanks often enough, its only because we have come to take the great folks, information, and service for granted. It is nonetheless greatly appreciated.

Jody Hudson · November 28, 2001, 08:03 PM

That is so true Rock_Jock.

I consider this a MOST valuable part of my life. Thanks Rich and everyone else!!!!!!!!!!!!!!!

yorec · November 28, 2001, 10:49 PM

Came in to check on the status of the search function - I understand and will be patient. But I also had to post to "ditto" the sentiment's of support from those above!

Daedalus · November 29, 2001, 12:42 PM

Speaking of which, anyone know about the Jericho 941 Compact? I'm dying over here!

RugerSAfan · November 29, 2001, 04:40 PM

Relating to the reindexing, one option is to review history, determine time when least impact on over-all users, notify in advance, take database off-line with notice of expected return, and then re-index.

Sure would like to do a search. I enjoy TFL, BTW.

Edward429451 · November 29, 2001, 09:04 PM

So thats what happened to it. finally wandered to this forum to check out why. It must be a pain in the butt to have it keep crashing on you like that.

(I need to search for some sks info,whats it worth I got it as a tip for a guy I worked for!)...

We appreciate all your frustration and work to keep it going!!

**Rich Lucibella** · November 29, 2001, 09:47 PM

Guys-
It just keeps crashing. It really is a *huge* file. I know it can be done, but it requires my PC/Internet connection to stay up long enough. I've tried doing it in several screens, each with a smaller piece of the file....the server goes ballistic.

I just restarted again. With luck- noon tomorrow. Know that we all miss the function and we're doing everything possible to bring it back up.
Rich

rock_jock · November 29, 2001, 10:09 PM

Thanks Rich. Personally, I think it must be a HCI conspiracy. I mean if we never got to do research on guns at TFL again, firearms sales would plummet across the country.

garrettwc · November 29, 2001, 10:12 PM

I'm beginning to think it's a plot by the antis. Your internet connection keeps dropping out,

gunsamerica and 1911 forum are both down with a 403 error.

Are we under attack by a virus or million mom hackers

Seriously, Rich I know you're doing your best. We have been experiencing a variety of server problems at my job. I know how frustrated you must be. We appreciate all your hard work on this.

PUMC_TomG · November 29, 2001, 10:58 PM

Quote:

Thanks Rich. Personally, I think it must be a HCI conspiracy. I mean if we never got to do research on guns at TFL again, firearms sales would plummet across the country.

Oh contrare Senor Jock. It just means we would all have to buy a gun we had questions on to see if its worth it. In doubt? Buy it!!!

nnciderr · November 29, 2001, 11:34 PM

I'd be glad to donate some bandwidth if I can. My connection is only off 2 times a year. Let me know if I can help.

[email protected]

I miss the search.

What to do?

mini14jac · November 30, 2001, 08:37 AM

I want to join the chorus saying this a great board, and you guys do a great job in running it.

I am in favor of going down 10 hours if it will get the Search function back.
That is probably the most useful function when you are considering a new purchase.

Flip the switch on this puppy!

JP

tonyz · November 30, 2001, 11:00 AM

I also join in the shut down. If thats what it takes to get the program to function correctly.
So just post the time of the shut down and time frame then go for it!!

Tony

"The unsearchable"

Borf · November 30, 2001, 11:45 AM

But could I assume you're doing this remotely on a UNIX box? If so, have you tried either "nohup" or "screen" or equiv. to keep the process going on the other end if your session dies?

**Rich Lucibella** · November 30, 2001, 02:52 PM

The problem is not the server...it's Windows ME on my side. It crashes more often than a 20 year old Ford Pinto. Shutting down the server only shortens the time required for reindex a bit, and allows less time for Mr. Gates to get in the middle. But there's no guarantee that it will work.

Borf-
I like the way you talk!!!!!! Teach me...I'm a Red Had Linux newbie. I can get the basic stuff done; I'm fair with MySQL, but you're way ahead of me.

The reindex is done thru the vB control panel which runs in PHP. It's a typical point a click action on my part. (I might be able to isolate the script command sent to MySQL from vB, though).

I'm open to detailed instructs.
Rich

Borf · November 30, 2001, 04:53 PM

So it's an action from a webpage?

hmm...

Couple of things then - I'm not real swift on MySQL (I'm a C/Perl/Oracle/Informix/Postgres kind of junkie), and indexes are a very database-specific thing type of thing. I've also never seen the vB software so I don't know how it works, although I assume it uses PHP's built in facilities for talking to MySQL. I do know that newer versions of MySQL support an index type of FULLTEXT, which I'm assuming (you know what they say about assuming) TFL uses, perhaps multi-column. Chances are the re-indexing is being done through an ALTER INDEX( or CREATE INDEX) in one of PHP's "mysql_*" functions.

What I would suggest (either for this time or future use) *is* to figure out what exactly vB is having MySQL index. Then you can either do it manually, or maybe easier to write a perl script (using DBD::MySQL) to do it. Or maybe the MySQL myisamchk util has something for indexes (I really don't know). Advantage of this being you can schedule it or run it from the command prompt. If you're just running something from a shell (command prompt) you can use "nohup" to invoke it (causes the process to ignore "SIGHUP" - the HangUP SIGnal the terminal driver sends when the connection is broken) so that it will keep going when you disconnect. Screen can give you similar benefits, but by maintaining multiple virtual consoles within a single tty connection... to which you can usually reconnect if you get disconnected.

Does vB have any utilities that can be run from a shell that will index?

I don't know how to help you from the web-browser aspect.

I just read back through that... geez I hope it helps somehow.

Borf · November 30, 2001, 04:56 PM

I should probably toss out that manually tinkering with indexes or anything that could affect the schema without understanding what vB was doing could be... uh... *bad*

November 26, 2001, 04:21 PM	#1
Glockster35 Senior Member Join Date: June 14, 2001 Location: Spangdahlem AB, Germany Posts: 223	Search shutdown? What happened to the search function? Mine is saying it doesn't work because the administrators shut it down???

November 26, 2001, 04:52 PM	#2
Rich Lucibella Staff Join Date: October 6, 1998 Location: South Florida Posts: 10,229	It's being reindexed. I started about 2AM in hopes of not disturbing the Board. With 20,000,000+ search items (yeah, I was surprised too!), it was about 4/5ths done at noon today when the server crashed due to disk space problems. I've resolved that and will attempt a re-index this PM. 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

November 26, 2001, 08:00 PM	#4
Jody Hudson Senior Member Join Date: February 16, 2000 Location: Near Rehoboth Beach Delaware Posts: 1,140	Yes, thanks Rich. NO matter how much curmugeoning I do... This is a great place and my favorite resource on the web... other than my sites of course... :lol __________________ We help people relocate to Rehoboth Beach Delaware. Our Site: www.Kate-Jody.com

November 27, 2001, 07:11 PM	#6
Rich Lucibella Staff Join Date: October 6, 1998 Location: South Florida Posts: 10,229	Yup- Started it again today...lost connection halfway thru and it crashed. Just restarted now. Perhaps by morning. It really is a long process, unless we shut the board down for about 10 hours. 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

November 28, 2001, 08:03 PM	#10
Jody Hudson Senior Member Join Date: February 16, 2000 Location: Near Rehoboth Beach Delaware Posts: 1,140	That is so true Rock_Jock. I consider this a MOST valuable part of my life. Thanks Rich and everyone else!!!!!!!!!!!!!!! __________________ We help people relocate to Rehoboth Beach Delaware. Our Site: www.Kate-Jody.com

November 26, 2001, 07:08 PM	#3
Glockster35 Senior Member Join Date: June 14, 2001 Location: Spangdahlem AB, Germany Posts: 223	Thanks Rich And if you didn't already know you guys are doing one heck of a job with this board, and SWAT magazine. Keep it up

November 27, 2001, 01:16 PM	#5
garrettwc Senior Member Join Date: October 3, 2001 Posts: 641	Rich, any word on status of the servers? The search feature/find new posts link is still coming up "turned off by admin".

November 28, 2001, 01:30 AM	#7
NINE Senior Member Join Date: May 4, 2001 Posts: 431	Shut down for 10 hours, eh? Rich, I'll get back to you with a time that is good for me.

November 28, 2001, 05:26 AM	#8
LilJoe Senior Member Join Date: March 2, 2001 Location: North Eastern Ohio Posts: 185	I feel the withdrawls coming already!!!!!!

November 28, 2001, 06:08 PM	#9
rock_jock Senior Member Join Date: January 19, 2000 Location: SE Texas Posts: 1,779	This is disheartening. I am trying to do research for my next gun and I feel like a ship tossed about on the sea without my TFL archive resources. BTW, I think this points to the incredible benefits the community of firearm enthusiasts receives from this site. If we don't say thanks often enough, its only because we have come to take the great folks, information, and service for granted. It is nonetheless greatly appreciated.

November 28, 2001, 10:49 PM	#11
yorec Senior Member Join Date: February 2, 2000 Location: Wyoming Posts: 2,328	Came in to check on the status of the search function - I understand and will be patient. But I also had to post to "ditto" the sentiment's of support from those above! __________________ What part of "... shall not be infringed..." don't you understand?

November 29, 2001, 12:42 PM	#12
Daedalus Senior Member Join Date: June 19, 2001 Location: Fairfax, VA Posts: 185	Speaking of which, anyone know about the Jericho 941 Compact? I'm dying over here! __________________ When life passes you by, downshift.

November 29, 2001, 04:40 PM	#13
RugerSAfan Member Join Date: April 21, 2001 Location: Barry County, Michigan Posts: 39	Relating to the reindexing, one option is to review history, determine time when least impact on over-all users, notify in advance, take database off-line with notice of expected return, and then re-index. Sure would like to do a search. I enjoy TFL, BTW.

November 29, 2001, 09:04 PM	#14
Edward429451 Junior member Join Date: November 12, 2000 Location: Colorado Springs, Colorado Posts: 9,494	So thats what happened to it. finally wandered to this forum to check out why. It must be a pain in the butt to have it keep crashing on you like that. (I need to search for some sks info,whats it worth I got it as a tip for a guy I worked for!)... We appreciate all your frustration and work to keep it going!!

November 29, 2001, 09:47 PM	#15
Rich Lucibella Staff Join Date: October 6, 1998 Location: South Florida Posts: 10,229	Guys- It just keeps crashing. It really is a huge file. I know it can be done, but it requires my PC/Internet connection to stay up long enough. I've tried doing it in several screens, each with a smaller piece of the file....the server goes ballistic. I just restarted again. With luck- noon tomorrow. Know that we all miss the function and we're doing everything possible to bring it back up. 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

November 29, 2001, 10:09 PM	#16
rock_jock Senior Member Join Date: January 19, 2000 Location: SE Texas Posts: 1,779	Thanks Rich. Personally, I think it must be a HCI conspiracy. I mean if we never got to do research on guns at TFL again, firearms sales would plummet across the country.

November 29, 2001, 10:12 PM	#17
garrettwc Senior Member Join Date: October 3, 2001 Posts: 641	I'm beginning to think it's a plot by the antis. Your internet connection keeps dropping out, gunsamerica and 1911 forum are both down with a 403 error. Are we under attack by a virus or million mom hackers Seriously, Rich I know you're doing your best. We have been experiencing a variety of server problems at my job. I know how frustrated you must be. We appreciate all your hard work on this.

November 29, 2001, 11:34 PM	#19
nnciderr Member Join Date: October 12, 2001 Location: 92, 42 Posts: 44	I'd be glad to donate some bandwidth if I can. My connection is only off 2 times a year. Let me know if I can help. [email protected] I miss the search. What to do? __________________ lay smack down

November 30, 2001, 08:37 AM	#20
mini14jac Senior Member Join Date: February 19, 2001 Location: The Volunteer State. Posts: 691	I want to join the chorus saying this a great board, and you guys do a great job in running it. I am in favor of going down 10 hours if it will get the Search function back. That is probably the most useful function when you are considering a new purchase. Flip the switch on this puppy! JP

November 30, 2001, 11:00 AM	#21
tonyz Senior Member Join Date: January 29, 2000 Location: Wa Posts: 922	I also join in the shut down. If thats what it takes to get the program to function correctly. So just post the time of the shut down and time frame then go for it!! Tony "The unsearchable" __________________ Nothing Ventured Nothing Gained

November 30, 2001, 11:45 AM	#22
Borf Senior Member Join Date: February 24, 2001 Location: Middle Tennessee Posts: 424	Just wondering But could I assume you're doing this remotely on a UNIX box? If so, have you tried either "nohup" or "screen" or equiv. to keep the process going on the other end if your session dies? __________________ 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

November 30, 2001, 02:52 PM	#23
Rich Lucibella Staff Join Date: October 6, 1998 Location: South Florida Posts: 10,229	The problem is not the server...it's Windows ME on my side. It crashes more often than a 20 year old Ford Pinto. Shutting down the server only shortens the time required for reindex a bit, and allows less time for Mr. Gates to get in the middle. But there's no guarantee that it will work. Borf- I like the way you talk!!!!!! Teach me...I'm a Red Had Linux newbie. I can get the basic stuff done; I'm fair with MySQL, but you're way ahead of me. The reindex is done thru the vB control panel which runs in PHP. It's a typical point a click action on my part. (I might be able to isolate the script command sent to MySQL from vB, though). I'm open to detailed instructs. 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

November 30, 2001, 04:53 PM	#24
Borf Senior Member Join Date: February 24, 2001 Location: Middle Tennessee Posts: 424	So it's an action from a webpage? hmm... Couple of things then - I'm not real swift on MySQL (I'm a C/Perl/Oracle/Informix/Postgres kind of junkie), and indexes are a very database-specific thing type of thing. I've also never seen the vB software so I don't know how it works, although I assume it uses PHP's built in facilities for talking to MySQL. I do know that newer versions of MySQL support an index type of FULLTEXT, which I'm assuming (you know what they say about assuming) TFL uses, perhaps multi-column. Chances are the re-indexing is being done through an ALTER INDEX( or CREATE INDEX) in one of PHP's "mysql_" functions. What I would suggest (either for this time or future use) is* to figure out what exactly vB is having MySQL index. Then you can either do it manually, or maybe easier to write a perl script (using DBD::MySQL) to do it. Or maybe the MySQL myisamchk util has something for indexes (I really don't know). Advantage of this being you can schedule it or run it from the command prompt. If you're just running something from a shell (command prompt) you can use "nohup" to invoke it (causes the process to ignore "SIGHUP" - the HangUP SIGnal the terminal driver sends when the connection is broken) so that it will keep going when you disconnect. Screen can give you similar benefits, but by maintaining multiple virtual consoles within a single tty connection... to which you can usually reconnect if you get disconnected. Does vB have any utilities that can be run from a shell that will index? I don't know how to help you from the web-browser aspect. I just read back through that... geez I hope it helps somehow. __________________ 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

November 30, 2001, 04:56 PM	#25
Borf Senior Member Join Date: February 24, 2001 Location: Middle Tennessee Posts: 424	I should probably toss out that manually tinkering with indexes or anything that could affect the schema without understanding what vB was doing could be... uh... bad __________________ 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