List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:June 3 1999 3:17am
Subject:MySQL dies with corrupted index
View as plain text  
>>>>> "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
Thread
MySQL dies with corrupted indexMichal Ludvig31 May
  • Re: MySQL dies with corrupted indexJason Spears1 Jun
    • Re: MySQL dies with corrupted indexSasha Pachev1 Jun
  • MySQL dies with corrupted indexMichael Widenius3 Jun
Re: MySQL dies with corrupted indexMichal Ludvig31 May
  • Re: MySQL dies with corrupted indexDim Zegebart31 May
    • Re: MySQL dies with corrupted indexMichal Ludvig31 May
      • Re: MySQL dies with corrupted indexDim Zegebart31 May