Bad data, no biscuit.

[John Robinson]

Exactly again the problem we experienced yesterday.

We use two databases in a master/slave relationship. The master receives all the posts and other changes we make to the forum. The slave copies all these posts and changes from the master, allowing either database to be queried in order to satisfy requests.

When it is working correctly.

We use a couple database tables to implement our search engine. Unfortunately, the tables on the the replicated slave are experiencing occassional crashes that look something like this:

Error 'Incorrect key file for table './FreeRepublic /search_full_title.MYI'; try to repair it' on query. Default database: 'FreeRepublic'. Query: 'DELETE FROM search_full_title

It's an easy enough problem to fix, takes just 2 minutes. But I've developed this nasty sleeping habit I've had a hard time kicking. :-(

To make a long sad story brief: It crashed again 2 hours ago. I just now did the little dance to bring it back, we'll see how this goes. Worse case I'll write a little monkey to do this for me... Worst case I'll disable search and its little unstable friends.

[rhombus]

Thanks for all your hard work.

[Lancey Howard]

Thanks for the update. Good luck.

[Dog Gone]

Thanks for all your efforts, John.

[i_dont_chat]

I appreciate the explanation.

[babyface00]

Thanks John.

[Semper Paratus]

Good explanation but I'm afraid the headlines in the MSM Friday will be :

"Free Republic admits to using slaves!"

[streetpreacher]

We can never hope to appeal to black voters as long as we post these slave/master threads. Please for the sake of unity...

[theDentist]

I keep a spare key hidden among the bamboos in the back yard. Perhaps you should consider same? :)

[Rebelbase]

"master/slave relationship."

Jesse and Al are on their way to pay you a visit.

[Spruce]

I h8 computers!

[Tijeras_Slim]

People actually use search? News to me. :)

[Soaring Feather]

Thanks for the update. You'll get it working properly.

[streetpreacher]

Left Out of Party(Blacks & the GOP)

[Wiz]

What, no cookies?

[kevkrom]

"master/slave relationship."

Hey... what Mrs. kevkrom and I do in our own home is our own business...

[LesbianThespianGymnasticMidget]

Which table type are you using with MySQL?

[Izzy Dunne]

two databases in a master/slave relationship.

A racist, judgemental comment, if ever I heard one.

[Michael Goldsberry]

Good for you, John.

I get little gremlins like this all the time at work. Whack-A-Mole!

[PissAndVinegar]

So do I but I know it's a ruse.....

We all know it's really Bush's fault :)