Please check with the 20051020 dump and mwdumper.
Problem reproduced on 20051020_pages_articles.xml.bz2
Command line was:
/usr/java/jre1.5.0_05/bin/java -server -jar mwdumper.jar
--format=sql:1.4 20051020_pages_articles.xml.bz2 | mysql enwiki
Nature of the problem:
At first the number of articles goes up from 0, but then it stalls at
29155. Any articles beyond 29155 do not seem to get imported :
======================================================
mysql> select count(*) from cur;
+----------+
| count(*) |
+----------+
| 29155 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from cur;
+----------+
| count(*) |
+----------+
| 29155 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from cur;
+----------+
| count(*) |
+----------+
| 29155 |
+----------+
1 row in set (0.00 sec)
======================================================
If it stops, please
check what the error was (eg, key conflicts) and report that.
Console output is as follows:
======================================================
19,000 pages (110.119/sec), 19,000 revs (110.119/sec)
20,000 pages (110.596/sec), 20,000 revs (110.596/sec)
21,000 pages (110.747/sec), 21,000 revs (110.747/sec)
22,000 pages (110.813/sec), 22,000 revs (110.813/sec)
23,000 pages (110.643/sec), 23,000 revs (110.643/sec)
24,000 pages (111.562/sec), 24,000 revs (111.562/sec)
25,000 pages (111.3/sec), 25,000 revs (111.3/sec)
26,000 pages (111.093/sec), 26,000 revs (111.093/sec)
27,000 pages (111.733/sec), 27,000 revs (111.733/sec)
28,000 pages (111.115/sec), 28,000 revs (111.115/sec)
29,000 pages (113.361/sec), 29,000 revs (113.361/sec)
ERROR 1062 at line 459: Duplicate entry '0-1_E0_m?' for key 1
30,000 pages (115.039/sec), 30,000 revs (115.039/sec)
31,000 pages (116.308/sec), 31,000 revs (116.308/sec)
32,000 pages (117.91/sec), 32,000 revs (117.91/sec)
33,000 pages (119.448/sec), 33,000 revs (119.448/sec)
34,000 pages (121.732/sec), 34,000 revs (121.732/sec)
35,000 pages (122.996/sec), 35,000 revs (122.996/sec)
36,000 pages (124.101/sec), 36,000 revs (124.101/sec)
37,000 pages (125.216/sec), 37,000 revs (125.216/sec)
38,000 pages (126.43/sec), 38,000 revs (126.43/sec)
39,000 pages (127.583/sec), 39,000 revs (127.583/sec)
Mon Oct 24 19:41:15 EST 2005
ludo:/home/nickj/wikipedia# screendump 1 > screen1
======================================================
I did not spot any other errors, and there does not seem to be a log
file or equivalent.
All the best,
Nick.