>Description:
The included sql test script (output of mysqldump 10.2 (create table statement and
insertion of 250 records into this table) with added check for table integrity)
results in corrupted table and error message 'Found key at page 36864 that points to
record outside datafile' when checked with 'check table' or myisamcheck. Bizarrely, if
you delete any one of the records being inserted the resulting table will be OK. Also,
as you'll note, the value inserted into the 3rd column is always string
'DatabaseIdentifier'. If you change it in any record by deleting or adding a character
(i.e. change it to 'DatabaseIdentifie' or 'DatabaseIdentifierr' the resulting table
will also be fine.
If you don't issue the 'check table' command you'll be able to do selects on the
table.However, once the check has been issued any attempt to do select result in
"ERROR 1016: Can't open file: 'DatabaseObject.MYI'. (errno: 145)".
The problem also occurs on precompiled MySQL 4.1 for alphas (I haven't tested any
other platforms).
However, the problem does not occur with precompiled MySQL 4.0.16 on intel-linux (the
same platform used to run mysqlbug producing this report for 4.1). Also, if you dump
the test database with mysqldump 9.09 and re-upload it, the resulting table is OK.
>How-To-Repeat:
-- MySQL dump 10.2
--
-- Host: localhost Database: test
---------------------------------------------------------
-- Server version 4.0.16-standard
--
-- Table structure for table 'DatabaseObject'
--
DROP TABLE IF EXISTS DatabaseObject;
CREATE TABLE DatabaseObject (
DB_ID int(10) NOT NULL auto_increment,
_Protege_id varchar(255) default NULL,
_class varchar(64) default NULL,
_partial tinyint(4) NOT NULL default '0',
_displayName text,
created int(10) unsigned default NULL,
created_class varchar(64) default NULL,
_internal1 varchar(255) default NULL,
_internal2 varchar(255) default NULL,
_html longblob,
_timestamp timestamp(14) NOT NULL,
__is_ghost enum('TRUE') default NULL,
_internal3 varchar(255) default NULL,
PRIMARY KEY (DB_ID),
KEY _Protege_id (_Protege_id),
KEY _class (_class),
KEY created (created),
KEY _internal1 (_internal1),
KEY _internal2 (_internal2),
KEY _timestamp (_timestamp),
KEY __is_ghost (__is_ghost),
KEY _internal3 (_internal3),
KEY _partial (_partial),
FULLTEXT KEY _displayName (_displayName),
FULLTEXT KEY _Protege_id_fulltext (_Protege_id),
FULLTEXT KEY _class_fulltext (_class),
FULLTEXT KEY _internal1_fulltext (_internal1),
FULLTEXT KEY _internal2_fulltext (_internal2),
FULLTEXT KEY _internal3_fulltext (_internal3)
) TYPE=MyISAM;
--
-- Dumping data for table 'DatabaseObject'
--
/*!40000 ALTER TABLE DatabaseObject DISABLE KEYS */;
LOCK TABLES DatabaseObject WRITE;
INSERT INTO DatabaseObject VALUES
(9400,NULL,'DatabaseIdentifier',0,'GO:0006258',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9402,NULL,'DatabaseIdentifier',0,'GO:0042160',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9404,NULL,'DatabaseIdentifier',0,'GO:0042161',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9406,NULL,'DatabaseIdentifier',0,'GO:0042162',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9408,NULL,'DatabaseIdentifier',0,'GO:0042163',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9411,NULL,'DatabaseIdentifier',0,'GO:0042164',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9415,NULL,'DatabaseIdentifier',0,'GO:0046139',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9416,NULL,'DatabaseIdentifier',0,'GO:0006787',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9419,NULL,'DatabaseIdentifier',0,'GO:0042168',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9421,NULL,'DatabaseIdentifier',0,'GO:0046149',NULL,NULL,NULL,NULL,NULL,0!
0000000000000,NULL,NULL),(9422,NULL,'DatabaseIdentifier',0,'GO:0042167',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9424,NULL,'DatabaseIdentifier',0,'GO:0042169',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9427,NULL,'DatabaseIdentifier',0,'GO:0004200',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9429,NULL,'DatabaseIdentifier',0,'GO:0004201',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9431,NULL,'DatabaseIdentifier',0,'GO:0004202',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9432,NULL,'DatabaseIdentifier',0,'GO:0005600',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9434,NULL,'DatabaseIdentifier',0,'GO:0004203',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9435,NULL,'DatabaseIdentifier',0,'GO:0005601',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9437,NULL,'DatabaseIdentifier',0,'GO:0004204',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9438,NULL,'DatabaseIdentifier',0,'GO:0005602',NULL,NULL,NULL,NULL,NULL,0000000000!
0000,NULL,NULL),(9440,NULL,'DatabaseIdentifier',0,'GO:0004205',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9441,NULL,'DatabaseIdentifier',0,'GO:0005603',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9443,NULL,'DatabaseIdentifier',0,'GO:0004206',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9444,NULL,'DatabaseIdentifier',0,'GO:0005604',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9446,NULL,'DatabaseIdentifier',0,'GO:0004207',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9447,NULL,'DatabaseIdentifier',0,'GO:0005605',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9449,NULL,'DatabaseIdentifier',0,'GO:0004208',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9450,NULL,'DatabaseIdentifier',0,'GO:0005606',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9452,NULL,'DatabaseIdentifier',0,'GO:0004209',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9453,NULL,'DatabaseIdentifier',0,'GO:0005607',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL!
,NULL),(9454,NULL,'DatabaseIdentifier',0,'GO:0006264',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9455,NULL,'DatabaseIdentifier',0,'GO:0005608',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9456,NULL,'DatabaseIdentifier',0,'GO:0006265',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9457,NULL,'DatabaseIdentifier',0,'GO:0005609',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9458,NULL,'DatabaseIdentifier',0,'GO:0006266',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9459,NULL,'DatabaseIdentifier',0,'GO:0006267',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9460,NULL,'DatabaseIdentifier',0,'GO:0006268',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9461,NULL,'DatabaseIdentifier',0,'GO:0006269',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9463,NULL,'DatabaseIdentifier',0,'GO:0042171',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9465,NULL,'DatabaseIdentifier',0,'GO:0042173',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9!
467,NULL,'DatabaseIdentifier',0,'GO:0030435',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9469,NULL,'DatabaseIdentifier',0,'GO:0042174',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9471,NULL,'DatabaseIdentifier',0,'GO:0042175',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9474,NULL,'DatabaseIdentifier',0,'GO:0042176',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9476,NULL,'DatabaseIdentifier',0,'GO:0042177',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9479,NULL,'DatabaseIdentifier',0,'GO:0042179',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9481,NULL,'DatabaseIdentifier',0,'GO:0004210',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9483,NULL,'DatabaseIdentifier',0,'GO:0004211',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9484,NULL,'DatabaseIdentifier',0,'GO:0005610',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9486,NULL,'DatabaseIdentifier',0,'GO:0004213',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9487,NULL,!
'DatabaseIdentifier',0,'GO:0005611',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9489,NULL,'DatabaseIdentifier',0,'GO:0004214',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9490,NULL,'DatabaseIdentifier',0,'GO:0005612',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9492,NULL,'DatabaseIdentifier',0,'GO:0004215',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9493,NULL,'DatabaseIdentifier',0,'GO:0005613',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9495,NULL,'DatabaseIdentifier',0,'GO:0004216',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9496,NULL,'DatabaseIdentifier',0,'GO:0005614',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9498,NULL,'DatabaseIdentifier',0,'GO:0004217',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9499,NULL,'DatabaseIdentifier',0,'GO:0006271',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9501,NULL,'DatabaseIdentifier',0,'GO:0004218',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9502,NULL,'Database!
Identifier',0,'GO:0006272',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9503,NULL,'DatabaseIdentifier',0,'GO:0005616',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9504,NULL,'DatabaseIdentifier',0,'GO:0006273',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9505,NULL,'DatabaseIdentifier',0,'GO:0005617',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9507,NULL,'DatabaseIdentifier',0,'GO:0004219',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9508,NULL,'DatabaseIdentifier',0,'GO:0006274',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9509,NULL,'DatabaseIdentifier',0,'GO:0006275',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9510,NULL,'DatabaseIdentifier',0,'GO:0005619',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9511,NULL,'DatabaseIdentifier',0,'GO:0006276',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9512,NULL,'DatabaseIdentifier',0,'GO:0006277',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9513,NULL,'DatabaseIdentifie!
r',0,'GO:0006278',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9514,NULL,'DatabaseIdentifier',0,'GO:0006279',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9516,NULL,'DatabaseIdentifier',0,'GO:0042182',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9519,NULL,'DatabaseIdentifier',0,'GO:0015942',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9521,NULL,'DatabaseIdentifier',0,'GO:0042183',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9524,NULL,'DatabaseIdentifier',0,'GO:0042184',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9527,NULL,'DatabaseIdentifier',0,'GO:0042185',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9530,NULL,'DatabaseIdentifier',0,'GO:0042186',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9533,NULL,'DatabaseIdentifier',0,'GO:0042187',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9538,NULL,'DatabaseIdentifier',0,'GO:0009404',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9539,NULL,'DatabaseIdentifier',0,'GO:!
0017143',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9541,NULL,'DatabaseIdentifier',0,'GO:0017085',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9543,NULL,'DatabaseIdentifier',0,'GO:0046680',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9546,NULL,'DatabaseIdentifier',0,'GO:0009407',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9547,NULL,'DatabaseIdentifier',0,'GO:0046701',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9548,NULL,'DatabaseIdentifier',0,'GO:0042188',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9551,NULL,'DatabaseIdentifier',0,'GO:0042189',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9553,NULL,'DatabaseIdentifier',0,'GO:0004221',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9554,NULL,'DatabaseIdentifier',0,'GO:0005620',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9555,NULL,'DatabaseIdentifier',0,'GO:0005621',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9557,NULL,'DatabaseIdentifier',0,'GO:0004226',!
NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9558,NULL,'DatabaseIdentifier',0,'GO:0006280',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9559,NULL,'DatabaseIdentifier',0,'GO:0005624',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9560,NULL,'DatabaseIdentifier',0,'GO:0005625',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9561,NULL,'DatabaseIdentifier',0,'GO:0006282',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9562,NULL,'DatabaseIdentifier',0,'GO:0005626',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9564,NULL,'DatabaseIdentifier',0,'GO:0004228',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9565,NULL,'DatabaseIdentifier',0,'GO:0006283',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9566,NULL,'DatabaseIdentifier',0,'GO:0005627',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9568,NULL,'DatabaseIdentifier',0,'GO:0004229',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9569,NULL,'DatabaseIdentifier',0,'GO:0006284',NULL,NULL!
,NULL,NULL,NULL,00000000000000,NULL,NULL),(9570,NULL,'DatabaseIdentifier',0,'GO:0005628',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9571,NULL,'DatabaseIdentifier',0,'GO:0006285',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9572,NULL,'DatabaseIdentifier',0,'GO:0006286',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9573,NULL,'DatabaseIdentifier',0,'GO:0006287',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9574,NULL,'DatabaseIdentifier',0,'GO:0006288',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9575,NULL,'DatabaseIdentifier',0,'GO:0006289',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9577,NULL,'DatabaseIdentifier',0,'GO:0042190',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9581,NULL,'DatabaseIdentifier',0,'GO:0042191',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9584,NULL,'DatabaseIdentifier',0,'GO:0046414',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9585,NULL,'DatabaseIdentifier',0,'GO:0042192',NULL,NULL,NULL,NUL!
L,NULL,00000000000000,NULL,NULL),(9588,NULL,'DatabaseIdentifier',0,'GO:0046413',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9589,NULL,'DatabaseIdentifier',0,'GO:0042193',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9592,NULL,'DatabaseIdentifier',0,'GO:0042194',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9598,NULL,'DatabaseIdentifier',0,'GO:0046164',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9600,NULL,'DatabaseIdentifier',0,'GO:0046271',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9601,NULL,'DatabaseIdentifier',0,'GO:0042195',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9603,NULL,'DatabaseIdentifier',0,'GO:0042198',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9606,NULL,'DatabaseIdentifier',0,'GO:0042199',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9608,NULL,'DatabaseIdentifier',0,'GO:0004230',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9610,NULL,'DatabaseIdentifier',0,'GO:0004231',NULL,NULL,NULL,NULL,NULL,00!
000000000000,NULL,NULL),(9612,NULL,'DatabaseIdentifier',0,'GO:0004232',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9614,NULL,'DatabaseIdentifier',0,'GO:0008133',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9615,NULL,'DatabaseIdentifier',0,'GO:0005630',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9616,NULL,'DatabaseIdentifier',0,'GO:0005631',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9618,NULL,'DatabaseIdentifier',0,'GO:0004234',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9619,NULL,'DatabaseIdentifier',0,'GO:0005632',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9621,NULL,'DatabaseIdentifier',0,'GO:0004235',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9622,NULL,'DatabaseIdentifier',0,'GO:0005633',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9623,NULL,'DatabaseIdentifier',0,'GO:0006290',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9624,NULL,'DatabaseIdentifier',0,'GO:0006291',NULL,NULL,NULL,NULL,NULL,00000000000!
000,NULL,NULL),(9625,NULL,'DatabaseIdentifier',0,'GO:0005635',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9627,NULL,'DatabaseIdentifier',0,'GO:0004237',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9628,NULL,'DatabaseIdentifier',0,'GO:0006292',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9630,NULL,'DatabaseIdentifier',0,'GO:0004238',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9631,NULL,'DatabaseIdentifier',0,'GO:0006293',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9632,NULL,'DatabaseIdentifier',0,'GO:0005637',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9634,NULL,'DatabaseIdentifier',0,'GO:0004239',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9635,NULL,'DatabaseIdentifier',0,'GO:0006294',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9636,NULL,'DatabaseIdentifier',0,'GO:0005638',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9637,NULL,'DatabaseIdentifier',0,'GO:0006295',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,!
NULL),(9638,NULL,'DatabaseIdentifier',0,'GO:0005639',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9639,NULL,'DatabaseIdentifier',0,'GO:0006296',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9640,NULL,'DatabaseIdentifier',0,'GO:0006297',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9641,NULL,'DatabaseIdentifier',0,'GO:0006298',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9642,NULL,'DatabaseIdentifier',0,'GO:0006299',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9644,NULL,'DatabaseIdentifier',0,'GO:0004240',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9645,NULL,'DatabaseIdentifier',0,'GO:0005640',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9647,NULL,'DatabaseIdentifier',0,'GO:0004243',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9648,NULL,'DatabaseIdentifier',0,'GO:0005641',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9650,NULL,'DatabaseIdentifier',0,'GO:0004244',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(96!
51,NULL,'DatabaseIdentifier',0,'GO:0005642',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9653,NULL,'DatabaseIdentifier',0,'GO:0004245',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9654,NULL,'DatabaseIdentifier',0,'GO:0005643',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9656,NULL,'DatabaseIdentifier',0,'GO:0004246',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9657,NULL,'DatabaseIdentifier',0,'GO:0005645',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9659,NULL,'DatabaseIdentifier',0,'GO:0004247',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9660,NULL,'DatabaseIdentifier',0,'GO:0005646',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9662,NULL,'DatabaseIdentifier',0,'GO:0004248',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9663,NULL,'DatabaseIdentifier',0,'GO:0005647',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9665,NULL,'DatabaseIdentifier',0,'GO:0004249',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9666,NULL,'!
DatabaseIdentifier',0,'GO:0005648',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9667,NULL,'DatabaseIdentifier',0,'GO:0005649',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9669,NULL,'DatabaseIdentifier',0,'GO:0004250',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9671,NULL,'DatabaseIdentifier',0,'GO:0004251',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9672,NULL,'DatabaseIdentifier',0,'GO:0005650',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9674,NULL,'DatabaseIdentifier',0,'GO:0004253',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9675,NULL,'DatabaseIdentifier',0,'GO:0005651',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9677,NULL,'DatabaseIdentifier',0,'GO:0004254',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9678,NULL,'DatabaseIdentifier',0,'GO:0005652',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9679,NULL,'DatabaseIdentifier',0,'GO:0005653',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9680,NULL,'DatabaseI!
dentifier',0,'GO:0005655',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9681,NULL,'DatabaseIdentifier',0,'GO:0005656',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9682,NULL,'DatabaseIdentifier',0,'GO:0005657',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9683,NULL,'DatabaseIdentifier',0,'GO:0005658',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9684,NULL,'DatabaseIdentifier',0,'GO:0005659',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9686,NULL,'DatabaseIdentifier',0,'GO:0004261',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9688,NULL,'DatabaseIdentifier',0,'GO:0004262',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9689,NULL,'DatabaseIdentifier',0,'GO:0005660',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9691,NULL,'DatabaseIdentifier',0,'GO:0004263',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9692,NULL,'DatabaseIdentifier',0,'GO:0005662',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9693,NULL,'DatabaseIdentifier!
',0,'GO:0005663',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9694,NULL,'DatabaseIdentifier',0,'GO:0005664',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9695,NULL,'DatabaseIdentifier',0,'GO:0005665',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9696,NULL,'DatabaseIdentifier',0,'GO:0005666',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9697,NULL,'DatabaseIdentifier',0,'GO:0005668',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9698,NULL,'DatabaseIdentifier',0,'GO:0005669',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9699,NULL,'DatabaseIdentifier',0,'GO:0005670',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9700,NULL,'DatabaseIdentifier',0,'GO:0005671',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9701,NULL,'DatabaseIdentifier',0,'GO:0005672',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9703,NULL,'DatabaseIdentifier',0,'GO:0004274',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9704,NULL,'DatabaseIdentifier',0,'GO:0!
005673',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9706,NULL,'DatabaseIdentifier',0,'GO:0004275',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9707,NULL,'DatabaseIdentifier',0,'GO:0005674',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9709,NULL,'DatabaseIdentifier',0,'GO:0004276',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9710,NULL,'DatabaseIdentifier',0,'GO:0005675',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9712,NULL,'DatabaseIdentifier',0,'GO:0004277',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9713,NULL,'DatabaseIdentifier',0,'GO:0005676',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9715,NULL,'DatabaseIdentifier',0,'GO:0004278',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9716,NULL,'DatabaseIdentifier',0,'GO:0005677',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9718,NULL,'DatabaseIdentifier',0,'GO:0004279',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9719,NULL,'DatabaseIdentifier',0,'GO:0005678',N!
ULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9720,NULL,'DatabaseIdentifier',0,'GO:0005679',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9722,NULL,'DatabaseIdentifier',0,'GO:0004281',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9724,NULL,'DatabaseIdentifier',0,'GO:0008132',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9725,NULL,'DatabaseIdentifier',0,'GO:0005680',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9726,NULL,'DatabaseIdentifier',0,'GO:0005681',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9728,NULL,'DatabaseIdentifier',0,'GO:0004283',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9729,NULL,'DatabaseIdentifier',0,'GO:0005682',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9731,NULL,'DatabaseIdentifier',0,'GO:0004284',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9732,NULL,'DatabaseIdentifier',0,'GO:0005683',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9734,NULL,'DatabaseIdentifier',0,'GO:0004285',NULL,NULL,!
NULL,NULL,NULL,00000000000000,NULL,NULL),(9735,NULL,'DatabaseIdentifier',0,'GO:0005684',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9737,NULL,'DatabaseIdentifier',0,'GO:0004286',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9738,NULL,'DatabaseIdentifier',0,'GO:0005685',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9740,NULL,'DatabaseIdentifier',0,'GO:0004287',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9741,NULL,'DatabaseIdentifier',0,'GO:0005686',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9742,NULL,'DatabaseIdentifier',0,'GO:0005687',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9744,NULL,'DatabaseIdentifier',0,'GO:0004289',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9745,NULL,'DatabaseIdentifier',0,'GO:0005688',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9746,NULL,'DatabaseIdentifier',0,'GO:0005689',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9749,NULL,'DatabaseIdentifier',0,'GO:0005690',NULL,NULL,NULL,NULL!
,NULL,00000000000000,NULL,NULL),(9750,NULL,'DatabaseIdentifier',0,'GO:0005691',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9752,NULL,'DatabaseIdentifier',0,'GO:0005692',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9754,NULL,'DatabaseIdentifier',0,'GO:0005693',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9758,NULL,'DatabaseIdentifier',0,'GO:0008243',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9759,NULL,'DatabaseIdentifier',0,'GO:0005695',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9761,NULL,'DatabaseIdentifier',0,'GO:0005696',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9763,NULL,'DatabaseIdentifier',0,'GO:0005697',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9765,NULL,'DatabaseIdentifier',0,'GO:0005698',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9766,NULL,'DatabaseIdentifier',0,'GO:0005699',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9770,NULL,'DatabaseIdentifier',0,'GO:0046364',NULL,NULL,NULL,NULL,NULL,000!
00000000000,NULL,NULL),(9774,NULL,'DatabaseIdentifier',0,'GO:0046365',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9784,NULL,'DatabaseIdentifier',0,'GO:0046383',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9789,NULL,'DatabaseIdentifier',0,'GO:0046382',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9794,NULL,'DatabaseIdentifier',0,'GO:0046371',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9804,NULL,'DatabaseIdentifier',0,'GO:0046366',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9807,NULL,'DatabaseIdentifier',0,'GO:0046367',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9815,NULL,'DatabaseIdentifier',0,'GO:0015975',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9828,NULL,'DatabaseIdentifier',0,'GO:0045333',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9829,NULL,'DatabaseIdentifier',0,'GO:0009061',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9832,NULL,'DatabaseIdentifier',0,'GO:0009060',NULL,NULL,NULL,NULL,NULL,000000000000!
00,NULL,NULL),(9847,NULL,'DatabaseIdentifier',0,'GO:0046434',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9864,NULL,'DatabaseIdentifier',0,'GO:0006595',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9865,NULL,'DatabaseIdentifier',0,'GO:0006596',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9867,NULL,'DatabaseIdentifier',0,'GO:0008216',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9868,NULL,'DatabaseIdentifier',0,'GO:0008295',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9870,NULL,'DatabaseIdentifier',0,'GO:0046206',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9894,NULL,'DatabaseIdentifier',0,'GO:0046374',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL),(9897,NULL,'DatabaseIdentifier',0,'GO:0046450',NULL,NULL,NULL,NULL,NULL,00000000000000,NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE DatabaseObject ENABLE KEYS */;
CHECK TABLE DatabaseObject;
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Imre Vastrik
>Organization:EMBL-EBI
>MySQL support: none
>Synopsis: table corruption with certain (valid) insert statements
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.1.0-alpha-standard (Official MySQL-standard binary)
>Server: /scratch/vastrik/test2/bin/mysqladmin Ver 8.21 Distrib 3.23.40, for
>pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.0-alpha-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 28 min 36 sec
Threads: 2 Questions: 366 Slow queries: 0 Opens: 30 Flush tables: 1 Open tables:
1 Queries per second avg: 0.213
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux picard.ebi.ac.uk 2.4.22-xfs #7 SMP Tue Oct 21 18:34:14 BST 2003 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.3 2.96-113)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2
-mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Nov 16 13:38 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x 1 root root 1260480 Mar 5 2003 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 2312442 Mar 5 2003 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Mar 5 2003 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official
MySQL-standard binary' '--with-extra-charsets=complex'
'--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile'
'--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static'
'--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro'
'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
