>>>>> "Michal" == Michal Ludvig <michal@stripped> writes:
Michal> Hi,
Michal> I have got a following table:
Michal> : CREATE TABLE ip_tbl (
Michal> : ipid int(10) unsigned DEFAULT '0' NOT NULL,
Michal> : ip varchar(18) DEFAULT '' NOT NULL,
Michal> : dn varchar(64) DEFAULT '' NOT NULL,
Michal> : dn1 int(10) unsigned DEFAULT '0' NOT NULL,
Michal> : dn2 int(10) unsigned DEFAULT '0' NOT NULL,
Michal> : rtime int(10) unsigned DEFAULT '0' NOT NULL,
Michal> : flag int(10) unsigned DEFAULT '0' NOT NULL,
Michal> :
Michal> : PRIMARY KEY (ipid),
Michal> : UNIQUE ip (ip),
Michal> : UNIQUE dn (dn),
Michal> : KEY dn1 (dn1),
Michal> : KEY dn2 (dn2),
Michal> : KEY rtime (rtime),
Michal> : KEY flag (flag)
Michal> : );
Michal> and I'm inserting records like this:
Michal> : INSERT IGNORE INTO ip_tbl VALUES
> (2990584515,'195.178.64.178','c-engine1.ten34.ces.net',1,1,924196794,0);
Michal> : INSERT IGNORE INTO ip_tbl VALUES
> (3007361731,'195.178.64.179','c-engine2.ten34.ces.net',1,1,924196794,0);
Michal> : INSERT IGNORE INTO ip_tbl VALUES
> (347371459,'195.119.180.20','robot.seznam.cz',2,2,928034112,0);
Michal> : INSERT IGNORE INTO ip_tbl VALUES
> (1148032450,'194.149.109.68','lbcd004.pvt.net',1,3,924367800,0);
Michal> : INSERT IGNORE INTO ip_tbl VALUES
> (3024138947,'195.178.64.180','c-engine3.ten34.ces.net',1,1,924196794,0);
Michal> : INSERT IGNORE INTO ip_tbl VALUES
> (4196151235,'195.47.28.250','fw.pszt.cz',2,4,924367800,0);
Michal> : INSERT IGNORE INTO ip_tbl VALUES
> (3057693379,'195.178.64.182','c-engine4.ten34.ces.net',1,1,924367801,0);
Michal> : [...]
Michal> After filling in a number of them (usually 60000 to 100000), MySQL dies:
Michal> : hop:root:/usr/local/mysql/var# cat /home2/mic/ipad | mysql -u mic dcres2
Michal> : hop:root:/usr/local/mysql/var# cat /home2/mic/ipae | mysql -u mic dcres2
Michal> : ERROR 2013 at line 1578: Lost connection to MySQL server during query
Michal> : Broken pipe
Michal> : hop:root:/usr/local/mysql/var#
Michal> : Number of processes running now: 0
Michal> : mysqld restarted on Mon May 31 14:19:47 CEST 1999
Michal> In error log there is nothing important:
Michal> : mysqld started on Mon May 31 14:02:50 CEST 1999
Michal> : /usr/local/mysql/libexec/mysqld: ready for connections
Michal> :
Michal> : Number of processes running now: 0
Michal> : mysqld restarted on Mon May 31 14:04:33 CEST 1999
Michal> : 990531 14:04:38 Can't start server: Bind on TCP/IP port: Address already in
> use
Michal> : 990531 14:04:38 Do you already have another mysqld server running on port:
> 3306 ?
Michal> : 990531 14:04:38 Aborting
Michal> Line 1578 of file /.../ipae is:
Michal> : INSERT IGNORE INTO ip_tbl VALUES
> (89502403,'195.178.85.5','195.178.85.5',0,0,922700250,4);
Michal> (nothing strange...)
Michal> And isamchk after that says:
Michal> : hop:root:/usr/local/mysql/var/dcres2# isamchk ip_tbl
Michal> : Checking ISAM file: ip_tbl
Michal> : Data records: 101577 Deleted blocks: 0
Michal> : - check file-size
Michal> : - check delete-chain
Michal> : - check index reference
Michal> : - check data record references index: 1
Michal> : - check data record references index: 2
Michal> : isamchk: error: Key in wrong position at page 2071552
Michal> : - check record links
Michal> : isamchk: error: Keypointers and records dosen't match
Michal> : ISAM-table 'ip_tbl' is corrupted
Michal> : Fix it using switch "-r" or "-o"
Michal> : hop:root:/usr/local/mysql/var/dcres2#
Michal> I'm using MySQL 3.22.22, but the same problem exists in 3.22.21 too.
Michal> What's wrong? Is it my fault od MySQL's? What should I do?
Michal> Thanks
Michal> Michal Ludvig
Hi!
Have you compiled MySQL with the --with-charset=czech option ?
In this case it's probably a bug in the czech sorting code.
I am working on a similar bug report and hope to solve this during
this week!
Regards,
Monty
