mysql errors, thread lists not updating

[EricNoah]

I've had the same problem twice in a row this morning:

I try to post to a thread, I get a big long error, and then when I go back and resubmit them it seems to go through fine. But then back on the list of threads, the thread doesn't move to the top or get updated with the correct time or who posted last (me).

Just seemed kind of weird is all!

 

[EricNoah]

For good measure I got an error while posting this thread, too. Here it is...

-------------

Database error in vBulletin 2.2.6:

Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (73370,977163,1),(1354,977163,1),(48,977163,1),(534,977163,1),(2424,977163,1),(926,977163,0),(1084,977163,0),(2,977163,0),(74,977163,0),(143,977163,0),(160,977163,0),(51203,977163,0),(110,977163,0),(396,977163,0),(153,977163,0),(454,977163,0),(1202,977163,0),(293,977163,0),(2384,977163,0),(178,977163,0),(50,977163,0),(786,977163,0),(3431,977163,0)
mysql error: Can't open file: 'searchindex.MYD'. (errno: 145)

mysql error number: 1016

Date: Tuesday 01st of July 2003 10:21:10 AM
Script: http://enworld.cyberstreet.com/newthread.php
Referer:

 

[EricNoah]

and when I posted the reply above, the thread lists showed 0 replies.

 

[Morrus]

Eeek! As error messages go, that one sounds pretty nasty. Hopefully Blacksway will be able to interpret it.

 

[Piratecat]

Should be all fixed. The search index got corrupted, so nothing was updating properly.

 

[DerianCypher]

All Hail the IT Masters! Maintainers of the Boards and dealer of our addiction!

DC

 

[Psionicist]

What Piratecat said.

When you search, the forum software will -not- go through every single post on the forum looking for the words you searched for, rather, it will consult two tables in the database.

First of all, the search function will go through the word index, a table with two columns (a numeric ID and the actual word) and several thousand rows.

[color="#CCCCCC"]Sample word index:

+------+------------------+
|      |                  |
|  ID  |       Word       |
|      |                  |
+------+------------------+
| 1102 | attack           |
+------+------------------+
| 1103 | gnome            |
+------+------------------+
| 1104 | minigun          |
+------+------------------+
| 1105 | scoot            |
+------+------------------+
| 1106 | away             |
+------+------------------+
| 1107 | quickly          |
+------+------------------+
| 1108 | asap             |
+------+------------------+
[/color]

Example: You searched for "gnome". "Gnome" is word 1103 in the word index.

The search function will now consult the search index. The seach index is a huge index (a search index can be well over 20 million rows for a site such as En World) with information where you can find a specific word.

[color="#CCCCCC"]Sample search index:
+--------+--------+---------+
|        |        |         |
| wordid | postid | intitle |
|        |        |         |
+--------+--------+---------+
| 1103   | 102314 | 0       |
+--------+--------+---------+
| 1103   | 012312 | 1       |
+--------+--------+---------+
| 1103   | 005565 | 0       |
+--------+--------+---------+
| 1104   | 128935 | 0       |
+--------+--------+---------+
| 1105   | 200956 | 0       |
+--------+--------+---------+
[/color]

The search function will find that word 1103 (the word gnome) can be found in post 102314, 12312 and 5565. Search will now check in which thread you can find these posts, and display them as the search result.

This is very ingenious, if the search function would have gone through every single post in the whole database, the server would die within seconds.

The search index and word index update whenever you post a new thread or reply to a thread, so, when Eric tried to post his thread, the search index was borked.