List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:December 11 2001 1:18pm
Subject:Re[2]: Stange Bug or Table corruption ... but strange.
View as plain text  
Bonjour Sinisa,

SM> There were some bug fixes with packed keys.

SM> 3.23.47 will soon be out and it would be fine if you could test your
SM> case with it again.

  I tried to do

>alter table historique_AMS PACK_KEYS=0;

  But it did not correct the problem.

  Then  I  wanted  check  if  the PACK_KEYS was equal to 0 when I do a
  "mysqldump -d" of the table.

  But  I forgot the "-d" ... and here is what I found : There are some
  "\r" at the end of some symbols ! (see below)

  I  don't  know  yet  if  this is a bug from my programs, but I don't
  think so.

  Any idea of how these "\r" appeared ? Could these have been added by
  Mysql ?

  Does it explain to you why the following query returns 31 rows

mysql> select * from historique_AMS where symbole='1rAUNIA';

  while the following returns 306 rows ?

mysql> select * from historique_AMS_bak where symbole='1rAUNIA' order by date desc;

  Regards,
  Alex.

INSERT INTO historique_AMS VALUES
('1aA13456\r','2000-09-28',104.40000,104.40000,104.40000,104.40000,0);
INSERT INTO historique_AMS VALUES
('1aA850737','2000-09-28',8.00000,8.00000,8.00000,8.00000,0);
INSERT INTO historique_AMS VALUES
('1aA716338','2000-09-28',101.80000,101.80000,101.80000,101.80000,0);
INSERT INTO historique_AMS VALUES
('1aAAABTE','2001-11-06',138.50000,141.00000,137.20000,140.00000,7280);
INSERT INTO historique_AMS VALUES
('1aAFINTO','2000-09-28',36.00000,36.00000,36.00000,36.00000,0);
INSERT INTO historique_AMS VALUES
('1aAFTUSF','2000-09-28',23.45000,23.45000,23.45000,23.45000,0);
INSERT INTO historique_AMS VALUES
('1aA12283','2000-09-28',104.00000,104.00000,104.00000,104.00000,250000);
INSERT INTO historique_AMS VALUES
('1aA12299','2000-09-28',99.75000,99.75000,98.75000,98.75000,19000);
INSERT INTO historique_AMS VALUES
('1aA148140\r','2000-09-28',101.50000,101.50000,101.50000,101.50000,0);
INSERT INTO historique_AMS VALUES
('1rAOPG','2001-11-08',37.70000,37.90000,37.15000,37.45000,10317);
INSERT INTO historique_AMS VALUES
('1rAFOBRA\r','2000-09-28',27.50000,27.50000,27.50000,27.50000,0);
INSERT INTO historique_AMS VALUES
('1rAFOBR\r','2000-09-28',24.00000,24.00000,24.00000,24.00000,0);
INSERT INTO historique_AMS VALUES
('1aAFEF\r','2000-09-28',36.95000,36.95000,36.05000,36.95000,5006);
INSERT INTO historique_AMS VALUES
('1aAFEFSC\r','2000-09-28',68.25000,68.25000,68.25000,68.25000,0);
INSERT INTO historique_AMS VALUES
('1aAFORJA\r','2000-09-28',34.95000,35.00000,34.65000,35.00000,2064);
INSERT INTO historique_AMS VALUES
('1aAFRODF\r','2000-09-28',49.30000,49.30000,49.30000,49.30000,8528);
INSERT INTO historique_AMS VALUES
('1aAFRNX\r','2000-09-28',25.82000,25.82000,25.82000,25.82000,38920);
INSERT INTO historique_AMS VALUES
('1aAFRNI\r','2000-09-28',24.25000,24.30000,24.25000,24.25000,61900);
INSERT INTO historique_AMS VALUES
('1aAFRNV\r','2000-09-28',25.12000,25.12000,25.12000,25.12000,41454);
INSERT INTO historique_AMS VALUES
('1rAFOCCA\r','2000-09-28',914.00000,914.00000,914.00000,914.00000,0);
INSERT INTO historique_AMS VALUES
('1aAFBAMF\r','2000-09-28',33.25000,33.75000,33.25000,33.75000,1438);
INSERT INTO historique_AMS VALUES
('1rAFOCCB\r','2000-09-28',25.15000,25.15000,25.15000,25.15000,14250);
INSERT INTO historique_AMS VALUES
('1rAFORDA','2000-09-28',27.00000,27.00000,27.00000,27.00000,0);
INSERT INTO historique_AMS VALUES
('1aAFRNAF\r','2000-09-28',66.20000,66.20000,66.20000,66.20000,78);
INSERT INTO historique_AMS VALUES
('1aAFBNAS','2000-09-28',51.90000,51.90000,51.00000,51.00000,9447);
INSERT INTO historique_AMS VALUES
('1aAFRNUI\r','2000-09-28',52.98000,52.98000,52.98000,52.98000,760);
INSERT INTO historique_AMS VALUES
('1aAFOWMF\r','2000-09-28',53.50000,53.50000,53.00000,53.00000,18889);  

Thread
Can't import dump file OS Xollie10 Dec
Re: Can't import dump file OS Xollie11 Dec
  • Stange Bug or Table corruption ... but strange.BAUMEISTER Alexandre11 Dec
Re: Stange Bug or Table corruption ... but strange.Sinisa Milivojevic11 Dec
  • Re[2]: Stange Bug or Table corruption ... but strange.BAUMEISTER Alexandre11 Dec
Re[2]: Stange Bug or Table corruption ... but strange.BAUMEISTER Alexandre11 Dec
Re[3]: Stange Bug or Table corruption ... but strange.BAUMEISTER Alexandre11 Dec