Gregory Maxwell schrieb:

It would appear that the dewiki replica on toolserver is experiencing significant corruption.

SELECT count(el_to) FROM externallinks JOIN page ON el_from=page_id WHERE page_title='Fabrixx' AND page_namespace=0;

returns 1346 rows

I just loaded the recent dumps locally and same query returns 13 rows, which appears to be the correct result.

This is just an example, the condition occurs on many pages. Either *links rows have not been deleted.. or they have been inserted to the wrong id or some other problem which would cause a relational integrity violation with respect to page table.

I would be surprised if this corruption was limited to externallinks.

The same query returns a better result to me now (yesterday it returned Greg's result):

mysql> SELECT count(el_to) FROM dewiki_p.externallinks JOIN dewiki_p.page ON el_from=page_id WHERE page_title='Fabrixx' AND page_namespace=0\G *************************** 1. row *************************** count(el_to): 14 1 row in set (0.00 sec)

-- Leon