>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]