Bug #2617 mysql crashes due to table corruption
Submitted: 2 Feb 2004 12:43 Modified: 5 Feb 2004 0:00
Reporter: Thomas Mayer Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:4.0.17 (rpm) OS:Linux (Suse 8.2 kernel 2.4.20)
Assigned to: Heikki Tuuri CPU Architecture:Any

[2 Feb 2004 12:43] Thomas Mayer
Description:
Hi,

i have a very strange problem with my InnoDB Tablespaces:

Under similar circumstances running one statement which produces high load, takes a lot of time and is updating a lot of rows, mysql crashes sometimes. Or let's say often. I just could not reproduce yet WHEN.

I am running mysql on several servers, some smp some not. This is not the reason, I already tested. RAM configuration is similar and does not give hints to reproduce the error as well. 

I also tried to delete all InnoDB files, let mysql rebuilt them and tried the same. I have tried this step on 4.0.15 as well. And I have tried to recreate the InnoDB files on 4.0.15 and then update to 4.0.17.

With 4 of 7 Servers I have no Problems, 3 get the same Error at the same statements with similar data.

It is not only the number of rows, but in all cases I tested it was a lot of data. Some systems having transactions with even more rows did not make the error occur.

Usually there is only one Session writing to the database.

As I tested on several servers (all came from DELL at the same time) which are installed the same way, I don't think any more this is an OS/Hardware problem. my.cnf is similar on all servers as well.

I do nightly optimize all tables. To defragment, I do weekly no-change-alter-statements (type=innodb which is already set). So the storage might not be a problem at that time although all data is being moved.

So the only thing I can do right now is to send you the error-log-file and hope you can do anything senseful with it.

In case you need further information to solve the error, please let me know.

How to repeat:
- create InnoDB-Files
- create database and restore logical backup (data structure) with mysql client and sql-files created with mysqldump
- Import lots of data with php and execute several big SQL-Statements: no problem
- Import lots of different data and execute different statements: the error occurs. 

For example this case:
CREATE TABLE timeaxis (
  datum date NOT NULL default '0000-00-00',
  wochentag varchar(20) NOT NULL default 'nicht definiert',
  feiertag tinyint(1) unsigned zerofill NOT NULL default '0',
  at_vor date NOT NULL default '0000-00-00',
  at_nach date NOT NULL default '0000-00-00',
  at_stat date NOT NULL default '0000-00-00',
  PRIMARY KEY  (datum),
  KEY idx_at_vor (at_vor),
  KEY idx_at_nach (at_nach),
  KEY idx_at_stat (at_stat)
) TYPE=InnoDB COMMENT='Datumsliste';

CREATE TABLE lz_tag_kunde_todo (
  datum date NOT NULL default '0000-00-00',
  PRIMARY KEY  (datum)
) TYPE=InnoDB COMMENT='Todo tag_kunde';

CREATE TABLE bericht (
  scannart tinyint(3) unsigned NOT NULL default '0',
  terminal smallint(3) unsigned NOT NULL default '0',
  tour smallint(3) unsigned NOT NULL default '0',
  gebiet smallint(3) unsigned default NULL,
  stopp_nr smallint(3) unsigned default NULL,
  paketnummer bigint(11) unsigned NOT NULL default '0',
  fc1 tinyint(3) unsigned default NULL,
  fc2 tinyint(3) unsigned default NULL,
  fc3 tinyint(3) unsigned default NULL,
  fc4 tinyint(3) unsigned default NULL,
  fc5 tinyint(3) unsigned default NULL,
  paketart tinyint(1) unsigned default NULL,
  land tinyint(2) unsigned default NULL,
  plz mediumint(5) unsigned default NULL,
  route smallint(3) unsigned default NULL,
  gk_nr smallint(4) unsigned default NULL,
  gk_filiale smallint(4) unsigned default NULL,
  unbenutzt char(20) default NULL,
  stopp char(40) default NULL,
  kaufhausnummer int(8) unsigned default NULL,
  auftragsnummer char(13) default NULL,
  importnummer char(7) default NULL,
  datum date NOT NULL default '0000-00-00',
  zeit time default NULL,
  gewicht mediumint(8) unsigned default NULL,
  ber_id int(10) unsigned NOT NULL default '0',
  send_id int(10) unsigned NOT NULL default '0',
  kunden_nr mediumint(6) unsigned default NULL,
  importdatum date default '0000-00-00',
  eind tinyint(3) unsigned default '0',
  eind_tag tinyint(3) unsigned default '0',
  PRIMARY KEY  (ber_id),
  KEY idx_pkt (paketnummer),
  KEY idx_datum (datum),
  KEY idx_kd (kunden_nr),
  KEY idx_importdatum (importdatum),
  KEY idx_send_id (send_id),
  CONSTRAINT `0_19` FOREIGN KEY (`send_id`) REFERENCES `sendung` (`send_id`) ON DELETE CASCADE
) TYPE=InnoDB;

CREATE TABLE sendung (
  send_id int(10) unsigned NOT NULL default '0',
  paketnummer bigint(11) unsigned NOT NULL default '0',
  datum_von date NOT NULL default '0000-00-00',
  datum_bis date NOT NULL default '0000-00-00',
  kunden_nr mediumint(6) unsigned default NULL,
  clearing_ges decimal(6,5) default '0.00000',
  clearing_beutel decimal(6,5) default '0.00000',
  abholkosten decimal(6,5) default '0.00000',
  umschlagskosten decimal(6,5) default '0.00000',
  verkehrskosten decimal(6,5) default '0.00000',
  umschlagskosten_eingang decimal(6,5) default '0.00000',
  zustellkosten decimal(6,5) default '0.00000',
  np tinyint(1) unsigned NOT NULL default '0',
  kp tinyint(1) unsigned NOT NULL default '0',
  pl tinyint(1) unsigned NOT NULL default '0',
  express tinyint(1) unsigned NOT NULL default '0',
  rh tinyint(1) unsigned NOT NULL default '0',
  paketart tinyint(2) unsigned default NULL,
  laufzeit_ges tinyint(3) unsigned default NULL,
  laufzeit_5_23 tinyint(3) unsigned default NULL,
  laufzeit_5_3 tinyint(3) unsigned default NULL,
  laufzeit_5_3_letzte tinyint(3) unsigned default NULL,
  laufzeit_2_3 tinyint(3) unsigned default NULL,
  laufzeit_2_3_letzte tinyint(3) unsigned default NULL,
  route smallint(3) unsigned default NULL,
  plz mediumint(5) unsigned default NULL,
  tu_abholtour smallint(3) unsigned default NULL,
  PRIMARY KEY  (send_id),
  KEY idx_paketnummer (paketnummer),
  KEY idx_kunden_nr (kunden_nr),
  KEY idx_datum_von (datum_von),
  CONSTRAINT `0_15` FOREIGN KEY (`paketnummer`) REFERENCES `paketnummer_main` (`paketnummer`) ON DELETE CASCADE,
  CONSTRAINT `0_16` FOREIGN KEY (`paketnummer`) REFERENCES `paketnummer_main` (`paketnummer`) ON DELETE CASCADE
) TYPE=InnoDB COMMENT='Paket-Sendungen';

04-02-02 15:23:09   SQL: 

-- Werte pro Produktart
insert into lz_tag_kunde_update_db (datum, kunden_nr, produkt, menge, clearing,
	abholkosten, umschlagskosten, verkehrskosten, umschlagskosten_eingang, zustellkosten)
select t1.datum, t4.kunden_nr, '7', count(*),
	sum(t4.clearing_ges)+sum(t4.clearing_beutel),
	sum(t4.abholkosten),
	sum(t4.umschlagskosten),
	sum(t4.verkehrskosten),
	sum(t4.umschlagskosten_eingang),
	sum(t4.zustellkosten)
from lz_tag_kunde_todo t1
	inner join timeaxis t2 force index(idx_at_stat) on t1.datum=t2.at_stat
	inner join bericht t3 force index(idx_datum) on t2.datum=t3.datum
	inner join sendung t4 on t3.send_id=t4.send_id
where t3.scannart=5
and t3.eind=1
and t3.paketnummer not like "%9_______"
group by 1, 2, 3;
======================== SQL-FEHLER =====================
===== MySQL Error 2013: Lost connection to MySQL server during query

I'll send you further information in a second.
[2 Feb 2004 12:49] Heikki Tuuri
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://www.mysql.com/doc/en/Making_trace_files.html

Once you have generated a backtrace, please submit it to this bug
report and change the status back to 'Open'. Thank you for helping
us make our products better.
[2 Feb 2004 12:50] Thomas Mayer
Number of processes running now: 0
040202 13:24:50  mysqld restarted
040202 13:24:52  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 31 1658685726
InnoDB: Doing recovery: scanned up to log sequence number 31 1663928320
InnoDB: Doing recovery: scanned up to log sequence number 31 1667597755
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 333144 row operations to undo
InnoDB: Trx id counter is 0 66816
040202 13:24:52  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
InnoDB: Starting rollback of uncommitted transactions
InnoDB: Rolling back trx with id 0 66383, 333144 rows to undo
InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
InnoDB: Rolling back of trx id 0 66383 completed
InnoDB: Rollback of uncommitted transactions completed
040202 13:28:25  InnoDB: Flushing modified pages from the buffer pool...
040202 13:29:35  InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.15-Max'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
040202 13:33:30  /usr/sbin/mysqld-max: Normal shutdown

040202 13:33:30  InnoDB: Starting shutdown...
040202 13:33:31  InnoDB: Shutdown completed
040202 13:33:31  /usr/sbin/mysqld-max: Shutdown Complete

040202 13:33:31  mysqld ended

040202 13:33:37  mysqld started
040202 13:33:37  InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.15-Max'  socket: '/var/lib/mysql/mysql.sock'  port: 3306

040202 14:11:20  mysqld restarted
040202 14:11:21  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 31 1770763276
InnoDB: Doing recovery: scanned up to log sequence number 31 1770763276
040202 14:11:21  InnoDB: Flushing modified pages from the buffer pool...
040202 14:11:22  InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.15-Max'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 730231.
InnoDB: You may have to recover from a backup.
040202 15:33:12  InnoDB: Page dump in ascii and hex (16384 bytes):
 len 16384; hex 71d32ea9000b2477000b2476000b24780000001bbc09fa8745bf000000000000000000000000001c3b8d006e0000000000000002006b006c000000000000000000000000000000002f1f00000000000000000000000000000000000000000801000003009e696e66696d756d000905000803000073757072656d756d006b67645d514c494843413e3c3937343230afab2725211918110a0400001037012a009a7c2d00000000f4e6800004697430c8323030332d313252000000063c88efa3000000a7010b000000000000000001000000238fa793010b44452000a0444520000033343534200045555231362e3030202020202d302e3031323738303037323935364e5020000b633e6b67645d514c494843413e3c3937343230afab2725211918110a040000183701b6009a7c2e00000000f4e6800004697430d8323030332d313252000000063c88efa4000000a7010b000000000000000001000000238fa793010b4445200091444520000034363531200045555231362e3030202020202d302e3031323738303037323935364e5020000b633f6b67645d514c494843413e3c3937343230afab2725211918110a04000020370242009a7c2f00000000f4e6800004697430e8323030332d313252000000063c88efa5000000a7010b000000000000000001000000238fa793010b4445200091444520000035333537200045555231362e3030202020202d302e3031323738303037323935364e5020000b63406b67645d514c494843413e3c3937343230afab2725211918110a040400283702ce009a7c3000000000f4e6800004697430f8323030332d313252000000063c88efa6000000a7010b000000000000000001000000238fa793010b4445200091444520000035333537200045555231362e3030202020202d302e3031323738303037323935364e5020000b63416b67645d514c494843413e3c3937343230afab2725211918110a0400003037035a009a7c3100000000f4e680000469743108323030332d313252000000063c88efa7000000a7010b000000000000000001000000238fa793010b44452000c1444520000033333436200045555231362e3030202020202d302e3031323738303037323935364e5020000b63426b67645d514c494843413e3c3937343230afab2725211918110a040000383703e6009a7c3200000000f4e680000469743118323030332d313252000000063c88efa8000000a7010b000000000000000001000000238fa793010b444520008d444520000031383132200045555231362e3030202020202d302e3031323738303037323935364e5020000b63436b67645d514c494843413e3c3937343230afab2725211918110a04000040370472009a7c3300000000f4e680000469743128323030332d313252000000063c88efa9000000a7010b000000000000000001000000238fa793010b444520008d444520000031383132200045555231362e3030202020202d302e3031323738303037323935364e5020000b63446b67645d514c494843413e3c3937343230afab2725211918110a040400483704fe009a7c3400000000f4e680000469743138323030332d313252000000063c88efaa000000a7010b000000000000000001000000238fa793010b44452000a0444520000035393333200045555231362e3030202020202d302e3031323738303037323935364e5020000b63456b67645d514c494843413e3c3937343230afab2725211918110a0400005037058a009a7c3500000000f4e680000469743148323030332d313252000000063c88efab000000a7010b000000000000000001000000238fa793010b4445200077444520000038313930200045555231362e3030202020202d302e3031323738303037323935364e5020000b63466b67645d514c494843413e3c3937343230afab2725211918110a04000058370616009a7c3600000000f4e680000469743158323030332d313252000000063c88efac000000a7010b000000000000000001000000238fa793010b444520009d444520000035363330200045555231362e3030202020202d302e3031323738303037323935364e5020000b63476b67645d514c494843413e3c3937343230afab2725211918110a040000603706a2009a7c3700000000f4e680000469743168323030332d313252000000063c88efad000000a7010b000000000000000001000000238fa793010b444520009d444520000035363330200045555231362e3030202020202d302e3031323738303037323935364e5020000b63486b67645d514c494843413e3c3937343230afab2725211918110a0404006837072e009a7c3800000000f4e680000469743178323030332d313252000000063c88efae000000a7010b000000000000000001000000238fa793010b444520009d444520000035363330200045555231362e3030202020202d302e3031323738303037323935364e5020000b63496b67645d514c494843413e3c3937343230afab2725211918110a040000703707ba009a7c3900000000f4e680000469743188323030332d313252000000063c88efaf000000a7010b000000000000000001000000238fa793010b444520007d444520000032383434200045555231362e3030202020202d302e3031323738303037323935364e5020000b634a6b67645d514c494843413e3c3937343230afab2725211918110a04000078370846009a7c3a00000000f4e680000469743198323030332d313252000000063c88efb0000000a7010b000000000000000001000000238fa793010b444520009c444520000035373932200045555231362e3030202020202d302e3031323738303037323935364e5020000b634b6b67645d514c494843413e3c3937343230afab2725211918110a040000803708d2009a7c3b00000000f4e6800004697431a8323030332d313252000000063c88efb1000000a7010b000000000000000001000000238fa793010b44452000ba444520000036333433200045555231362e3030202020202d302e3031323738303037323935364e5020000b634c6b67645d514c494843413e3c3937343230afab2725211918110a0404008837095e009a7c3c00000000f4e6800004697431b8323030332d313252000000063c88efb2000000a7010b000000000000000001000000238fa793010b44452000a0444520000035323035200045555231362e3030202020202d302e3031323738303037323935364e5020000b634d6b67645d514c494843413e3c3937343230afab2725211918110a040000903709ea009a7c3d00000000f4e6800004697431c8323030332d313252000000063c88efb3000000a7010b000000000000000001000000238fa793010b44452000a0444520000035323035200045555231362e3030202020202d302e3031323738303037323935364e5020000b634e6b67645d514c494843413e3c3937343230afab2725211918110a04000098370a76009a7c3e00000000f4e6800004697431d8323030332d313252000000063c88efb4000000a7010b000000000000000001000000238fa793010b44452000a0444520000035323035200045555231362e3030202020202d302e3031323738303037323935364e5020000b634f6b67645d514c494843413e3c3937343230afab2725211918110a040000a0370b02009a7c3f00000000f4e6800004697431e8323030332d313252000000063c88efb5000000a7010b000000000000000001000000238fa793010b44452000b4444520000035343537200045555231362e3030202020202d302e3031323738303037323935364e5020000b63506b67645d514c494843413e3c3937343230afab2725211918110a040400a8370b8e009a7c4000000000f4e6800004697431f8323030332d313252000000063c88efb6000000a7010b000000000000000001000000238fa793010b44452000b4444520000035343537200045555231362e3030202020202d302e3031323738303037323935364e5020000b63516b67645d514c494843413e3c3937343230afab2725211918110a040000b0370c1a009a7c4100000000f4e680000469743208323030332d313252000000063c88efb7000000a7010b000000000000000001000000238fa793010b44452000b4444520000035343537200045555231362e3030202020202d302e3031323738303037323935364e5020000b63526b67645d514c494843413e3c3937343230afab2725211918110a040000b8370ca6009a7c4200000000f4e680000469743218323030332d313252000000063c88efb8000000a7010b000000000000000001000000238fa793010b444520009d444520000035373133200045555231362e3030202020202d302e3031323738303037323935364e5020000b63536b67645d514c494843413e3c3937343230afab2725211918110a040000c0370d32009a7c4300000000f4e680000469743228323030332d313252000000063c88efb9000000a7010b000000000000000001000000238fa793010b444520009d444520000035373133200045555231362e3030202020202d302e3031323738303037323935364e5020000b63546b67645d514c494843413e3c3937343230afab2725211918110a040400c8370dbe009a7c4400000000f4e680000469743238323030332d313252000000063c88efba000000a7010b000000000000000001000000238fa793010b444520009d444520000035373133200045555231362e3030202020202d302e3031323738303037323935364e5020000b63556b67645d514c494843413e3c3937343230afab2725211918110a040000d0370e4a009a7c4500000000f4e680000469743248323030332d313252000000063c88efbb000000a7010b000000000000000001000000238fa793010b444520007b444520000033383538200045555231362e3030202020202d302e3031323738303037323935364e5020000b63566b67645d514c494843413e3c3937343230afab2725211918110a040000d8370ed6009a7c4600000000f4e680000469743258323030332d313252000000063c88efbc000000a7010b000000000000000001000000238fa793010b444520007b444520000033383538200045555231362e3030202020202d302e3031323738303037323935364e5020000b63576b67645d514c494843413e3c3937343230afab2725211918110a040000e0370f62009a7c4700000000f4e680000469743268323030332d313252000000063c88efbd000000a7010b000000000000000001000000238fa793010b444520006d444520000039343638200045555231362e3030202020202d302e3031323738303037323935364e5020000b63586b67645d514c494843413e3c3937343230afab2725211918110a040400e8370fee009a7c4800000000f4e680000469743278323030332d313252000000063c88efbe000000a7010b000000000000000001000000238fa793010b4445200096444520000031333737200045555231362e3030202020202d302e3031323738303037323935364e5020000b63596b67645d514c494843413e3c3937343230afab2725211918110a040000f037107a009a7c4900000000f4e680000469743288323030332d313252000000063c88efbf000000a7010b000000000000000001000000238fa793010b4445200093444520000036333432200045555231362e3030202020202d302e3031323738303037323935364e5020000b635a6b67645d514c494843413e3c3937343230afab2725211918110a040000f8371106009a7c4a00000000f4e680000469743298323030332d313252000000063c88efc0000000a7010b000000000000000001000000238fa793010b44452000be444520000031303538200045555231362e3030202020202d302e3031323738303037323935364e5020000b635b6b67645d514c494843413e3c3937343230afab2725211918110a04000100371192009a7c4b00000000f4e6800004697432a8323030332d313252000000063c88efc1000000a7010b000000000000000001000000238fa793010b44452000a0444520000030353238200045555231362e3030202020202d302e3031323738303037323935364e5020000b635c6b67645d514c494843413e3c3937343230afab2725211918110a0404010837121e009a7c4c00000000f4e6800004697432b8323030332d313252000000063c88efc2000000a7010b000000000000000001000000238fa793010b4445200079444520000039353235200045555231362e3030202020202d302e3031323738303037323935364e5020000b635d6b67645d514c494843413e3c3937343230afab2725211918110a040001103712aa009a7c4d00000000f4e6800004697432c8323030332d313252000000063c88efc4000000a7010b000000000000000001000000238fa793010b4445200079444520000039353734200045555231362e3030202020202d302e3031323738303037323935364e5020000b635f6b67645d514c494843413e3c3937343230afab2725211918110a04000118371336009a7c4e00000000f4e6800004697432d8323030332d313252000000063c88efc5000000a7010b000000000000000001000000238fa793010b4445200079444520000039353734200045555231362e3030202020202d302e3031323738303037323935364e5020000b63606b67645d514c494843413e3c3937343230afab2725211918110a040001203713c2009a7c4f00000000f4e6800004697432e8323030332d313252000000063c88efc6000000a7010b000000000000000001000000238fa793010b4445200093444520000030343734200045555231362e3030202020202d302e3031323738303037323935364e5020000b63616b67645d514c494843413e3c3937343230afab2725211918110a0404012837144e009a7c5000000000f4e6800004697432f8323030332d313252000000063c88efc7000000a7010b000000000000000001000000238fa793010b4445200099444520000033313635200045555231362e3030202020202d302e3031323738303037323935364e5020000b63626b67645d514c494843413e3c3937343230afab2725211918110a040001303714da009a7c5100000000f4e680000469743308323030332d313252000000063c88efc8000000a7010b000000000000000001000000238fa793010b444520006e444520000032323737200045555231362e3030202020202d302e3031323738303037323935364e5020000b63636b67645d514c494843413e3c3937343230afab2725211918110a04000138371566009a7c5200000000f4e680000469743318323030332d313252000000063c88efc9000000a7010b000000000000000001000000238fa793010b4445200077444520000039333438200045555231362e3030202020202d302e3031323738303037323935364e5020000b63646b67645d514c494843413e3c3937343230afab2725211918110a040001403715f2009a7c5300000000f4e680000469743328323030332d313252000000063c88efca000000a7010b000000000000000001000000238fa793010b44452000c1444520000034313633200045555231362e3030202020202d302e3031323738303037323935364e5020000b63656b67645d514c494843413e3c3937343230afab2725211918110a0404014837167e009a7c5400000000f4e680000469743338323030332d313252000000063c88efcb000000a7010b000000000000000001000000238fa793010b444520007d444520000035353930200045555231362e3030202020202d302e3031323738303037323935364e5020000b63666b67645d514c494843413e3c3937343230afab2725211918110a0400015037170a009a7c5500000000f4e680000469743348323030332d313252000000063c88efcc000000a7010b000000000000000001000000238fa793010b444520009a444520000034343236200045555231362e3030202020202d302e3031323738303037323935364e5020000b63676b67645d514c494843413e3c3937343230afab2725211918110a04000158371796009a7c5600000000f4e680000469743358323030332d313252000000063c88efcd000000a7010b000000000000000001000000238fa793010b44452000ba444520000036393230200045555231362e3030202020202d302e3031323738303037323935364e5020000b63686b67645d514c494843413e3c3937343230afab2725211918110a04000160371822009a7c5700000000f4e680000469743368323030332d313252000000063c88efce000000a7010b000000000000000001000000238fa793010b44452000c5444520000037353335200045555231362e3030202020202d302e3031323738303037323935364e5020000b63696b67645d514c494843413e3c3937343230afab2725211918110a040401683718ae009a7c5800000000f4e680000469743378323030332d313252000000063c88efcf000000a7010b000000000000000001000000238fa793010b44452000c5444520000037353335200045555231362e3030202020202d302e3031323738303037323935364e5020000b636a6b67645d514c494843413e3c3937343230afab2725211918110a0400017037193a009a7c5900000000f4e680000469743388323030332d313252000000063c88efd0000000a7010b000000000000000001000000238fa793010b4445200078444520000031303739200045555231362e3030202020202d302e3031323738303037323935364e5020000b636b6b67645d514c494843413e3c3937343230afab2725211918110a040001783719c6009a7c5a00000000f4e680000469743398323030332d313252000000063c88efd1000000a7010b000000000000000001000000238fa793010b444520006d444520000038313037200045555231362e3030202020202d302e3031323738303037323935364e5020000b636c6b67645d514c494843413e3c3937343230afab2725211918110a04000180371a52009a7c5b00000000f4e6800004697433a8323030332d313252000000063c88efd3000000a7010b000000000000000001000000238fa793010b4445200093444520000030353931200045555231362e3030202020202d302e3031323738303037323935364e5020000b636e6b67645d514c494843413e3c3937343230afab2725211918110a04040188371ade009a7c5c00000000f4e6800004697433b8323030332d313252000000063c88efd4000000a7010b000000000000000001000000238fa793010b444520009c444520000035353435200045555231362e3030202020202d302e3031323738303037323935364e5020000b636f6b67645d514c494843413e3c3937343230afab2725211918110a04000190371b6a009a7c5d00000000f4e6800004697433c8323030332d313252000000063c88efd6000000a7010b000000000000000001000000238fa793010b444520008a444520000038343436200045555231362e3030202020202d302e3031323738303037323935364e5020000b63716b67645d514c494843413e3c3937343230afab2725211918110a04000198371bf6009a7c5e00000000f4e6800004697433d8323030332d313252000000063c88efd7000000a7010b000000000000000001000000238fa793010b444520007e444520000036313838200045555231362e3030202020202d302e3031323738303037323935364e5020000b63726b67645d514c494843413e3c3937343230afab2725211918110a040001a0371c82009a7c5f00000000f4e6800004697433e8323030332d313252000000063c88efd8000000a7010b000000000000000001000000238fa793010b4445200067444520000032393533200045555231362e3030202020202d302e3031323738303037323935364e5020000b63736b67645d514c494843413e3c3937343230afab2725211918110a040401a8371d0e009a7c6000000000f4e6800004697433f8323030332d313252000000063c88efd9000000a7010b000000000000000001000000238fa793010b444520009c444520000036323434200045555231362e3030202020202d302e3031323738303037323935364e5020000b63746b67645d514c494843413e3c3937343230afab2725211918110a040001b0371d9a009a7c6100000000f4e680000469743408323030332d313252000000063c88efda000000a7010b000000000000000001000000238fa793010b444520009c444520000037363239200045555231362e3030202020202d302e3031323738303037323935364e5020000b63756b67645d514c494843413e3c3937343230afab2725211918110a040001b8371e26009a7c6200000000f4e680000469743418323030332d313252000000063c88efdb000000a7010b000000000000000001000000238fa793010b444520006e444520000033353033200045555231362e3030202020202d302e3031323738303037323935364e5020000b63766b67645d514c494843413e3c3937343230afab2725211918110a040001c0371eb2009a7c6300000000f4e680000469743428323030332d313252000000063c88efdc000000a7010b000000000000000001000000238fa793010b444520006e444520000033343337200045555231362e3030202020202d302e3031323738303037323935364e5020000b63776b67645d514c494843413e3c3937343230afab2725211918110a040401c8371f3e009a7c6400000000f4e680000469743438323030332d313252000000063c88efdd000000a7010b000000000000000001000000238fa793010b4445200090444520000038353939200045555231362e3030202020202d302e3031323738303037323935364e5020000b63786b67645d514c494843413e3c3937343230afab2725211918110a040001d0371fca009a7c6500000000f4e680000469743448323030332d313252000000063c88efde000000a7010b000000000000000001000000238fa793010b444520009d444520000037343832200045555231362e3030202020202d302e3031323738303037323935364e5020000b63796b67645d514c494843413e3c3937343230afab2725211918110a040001d8372056009a7c6600000000f4e680000469743458323030332d313252000000063c88efdf000000a7010b000000000000000001000000238fa793010b44452000b2444520000038363336200045555231362e3030202020202d302e3031323738303037323935364e5020000b637a6b67645d514c494843413e3c3937343230afab2725211918110a040001e03720e2009a7c6700000000f4e680000469743468323030332d313252000000063c88efe2000000a7010b000000000000000001000000238fa793010b444520006e444520000032323037200045555231362e3030202020202d302e3031323738303037323935364e5020000b637d6b67645d514c494843413e3c3937343230afab2725211918110a040401e837216e009a7c6800000000f4e680000469743478323030332d313252000000063c88efe3000000a7010b000000000000000001000000238fa793010b44452000bb444520000038323530200045555231362e3030202020202d302e3031323738303037323935364e5020000b637e6b67645d514c494843413e3c3937343230afab2725211918110a040001f03721fa009a7c6900000000f4e680000469743488323030332d313252000000063c88efea000000a7010b000000000000000001000000238fa793010b4445200078444520000032353235200045555231362e3030202020202d302e3031323738303037323935364e5020000b63856b67645d514c494843413e3c3937343230afab2725211918110a040001f8372286009a7c6a00000000f4e680000469743498323030332d313252000000063c88efee000000a7010b000000000000000001000000238fa793010b44452000c2444520000034353339200045555231362e3030202020202d302e3031323738303037323935364e5020000b63896b67645d514c494843413e3c3937343230afab2725211918110a04000200372312009a7c6b00000000f4e6800004697434a8323030332d313252000000063c88efef000000a7010b000000000000000001000000238fa793010b4445200077444520000038333230200045555231362e3030202020202d302e3031323738303037323935364e5020000b638a6b67645d514c494843413e3c3937343230afab2725211918110a0404020837239e009a7c6c00000000f4e6800004697434b8323030332d313252000000063c88eff0000000a7010b000000000000000001000000238fa793010b444520007a444520000034313039200045555231362e3030202020202d302e3031323738303037323935364e5020000b638b6b67645d514c494843413e3c3937343230afab2725211918110a0400021037242a009a7c6d00000000f4e6800004697434c8323030332d313252000000063c88eff8000000a7010b000000000000000001000000238fa793010b444520009e444520000038343533200045555231362e3030202020202d302e3031323738303037323935364e5020000b63936b67645d514c494843413e3c3937343230afab2725211918110a040002183724b6009a7c6e00000000f4e6800004697434d8323030332d313252000000063c88effc000000a7010b000000000000000001000000238fa793010b44452000b8444520000033303236200045555231362e3030202020202d302e3031323738303037323935364e5020000b63976b67645d514c494843413e3c3937343230afab2725211918110a04000220372542009a7c6f00000000f4e6800004697434e8323030332d313252000000063c88effe000000a7010b000000000000000001000000238fa793010b444520007e444520000036333430200045555231362e3030202020202d302e3031323738303037323935364e5020000b63996b67645d514c494843413e3c3937343230afab2725211918110a040402283725ce009a7c7000000000f4e6800004697434f8323030332d313252000000063c88f005000000a7010b000000000000000001000000238fa793010b4445200078444520000032353839200045555231362e3030202020202d302e3031323738303037323935364e5020000b639f6b67645d514c494843413e3c3937343230afab2725211918110a0400023037265a009a7c7100000000f4e680000469743508323030332d313252000000063c88f006000000a7010b000000000000000001000000238fa793010b4445200087444520000035303433200045555231362e3030202020202d302e3031323738303037323935364e5020000b63a06b67645d514c494843413e3c3937343230afab2725211918110a040002383726e6009a7c7200000000f4e680000469743518323030332d313252000000063c88f00a000000a7010b000000000000000001000000238fa793010b4445200091444520000035343732200045555231362e3030202020202d302e3031323738303037323935364e5020000b63a46b67645d514c494843413e3c3937343230afab2725211918110a04000240372772009a7c7300000000f4e680000469743528323030332d313252000000063c88f00b000000a7010b000000000000000001000000238fa793010b44452000c1444520000033313035200045555231362e3030202020202d302e3031323738303037323935364e5020000b63a56b67645d514c494843413e3c3937343230afab2725211918110a040402483727fe009a7c7400000000f4e680000469743538323030332d313252000000063c88f00d000000a7010b000000000000000001000000238fa793010b44452000a0444520000031323331200045555231362e3030202020202d302e3031323738303037323935364e5020000b63a66b67645d514c494843413e3c3937343230afab2725211918110a0400025037288a009a7c7500000000f4e680000469743548323030332d313252000000063c88f00e000000a7010b000000000000000001000000238fa793010b444520008a444520000038313130200045555231362e3030202020202d302e3031323738303037323935364e5020000b63a76b67645d514c494843413e3c3937343230afab2725211918110a04000258372916009a7c7600000000f4e680000469743558323030332d313252000000063c88f00f000000a7010b000000000000000001000000238fa793010b4445200080444520000038383136200045555231362e3030202020202d302e3031323738303037323935364e5020000b63a86b67645d514c494843413e3c3937343230afab2725211918110a040002603729a2009a7c7700000000f4e680000469743568323030332d313252000000063c88f010000000a7010b000000000000000001000000238fa793010b4445200079444520000031353032200045555231362e3030202020202d302e3031323738303037323935364e5020000b63a96b67645d514c494843413e3c3937343230afab2725211918110a04040268372a2e009a7c7800000000f4e680000469743578323030332d313252000000063c88f011000000a7010b000000000000000001000000238fa793010b4445200068444520000034383038200045555231362e3030202020202d302e3031323738303037323935364e5020000b63aa6b67645d514c494843413e3c3937343230afab2725211918110a04000270372aba009a7c7900000000f4e680000469743588323030332d313252000000063c88f014000000a7010b000000000000000001000000238fa793010b444520008d444520000031383336200045555231362e3030202020202d302e3031323738303037323935364e5020000b63ad6b67645d514c494843413e3c3937343230afab2725211918110a04000278372b46009a7c7a00000000f4e680000469743598323030332d313252000000063c88f017000000a7010b000000000000000001000000238fa793010b44452000c1444520000034333737200045555231362e3030202020202d302e3031323738303037323935364e5020000b63b06b67645d514c494843413e3c3937343230afab2725211918110a04000280372bd2009a7c7b00000000f4e6800004697435a8323030332d313252000000063c88f01b000000a7010b000000000000000001000000238fa793010b444520008a444520000031323431200045555231362e3030202020202d302e3031323738303037323935364e5020000b63b46b67645d514c494843413e3c3937343230afab2725211918110a04040288372c5e009a7c7c00000000f4e6800004697435b8323030332d313252000000063c88f01e000000a7010b000000000000000001000000238fa793010b44452000c2444520000034303635200045555231362e3030202020202d302e3031323738303037323935364e5020000b63b76b67645d514c494843413e3c3937343230afab2725211918110a04000290372cea009a7c7d00000000f4e6800004697435c8323030332d313252000000063c88f020000000a7010b000000000000000001000000238fa793010b4445200096444520000033383034200045555231362e3030202020202d302e3031323738303037323935364e5020000b63b96b67645d514c494843413e3c3937343230afab2725211918110a04000298372d76009a7c7e00000000f4e6800004697435d8323030332d313252000000063c88f021000000a7010b000000000000000001000000238fa793010b444520007e444520000036343431200045555231362e3030202020202d302e3031323738303037323935364e5020000b63ba6b67645d514c494843413e3c3937343230afab2725211918110a040002a0372e02009a7c7f00000000f4e6800004697435e8323030332d313252000000063c88f024000000a7010b000000000000000001000000238fa793010b444520009e444520000031363437200045555231362e3030202020202d302e3031323738303037323935364e5020000b63bd6b67645d514c494843413e3c3937343230afab2725211918110a040402a8372e8e009a7c8000000000f4e6800004697435f8323030332d313252000000063c88f026000000a7010b000000000000000001000000238fa793010b444520007d444520000035353930200045555231362e3030202020202d302e3031323738303037323935364e5020000b63bf6b67645d514c494843413e3c3937343230afab2725211918110a040002b0372f1a009a7c8100000000f4e680000469743608323030332d313252000000063c88f028000000a7010b000000000000000001000000238fa793010b444520007d444520000035343531200045555231362e3030202020202d302e3031323738303037323935364e5020000b63c16b67645d514c494843413e3c3937343230afab2725211918110a040002b8372fa6009a7c8200000000f4e680000469743618323030332d313252000000063c88f029000000a7010b000000000000000001000000238fa793010b44452000a0444520000034333930200045555231362e3030202020202d302e3031323738303037323935364e5020000b63c26b67645d514c494843413e3c3937343230afab2725211918110a040002c0373032009a7c8300000000f4e680000469743628323030332d313252000000063c88f02a000000a7010b000000000000000001000000238fa793010b44452000ae444520000034343230200045555231362e3030202020202d302e3031b000000003e46aa84e8fa7968fa79607b36b2d302e303533363920302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020312e3232303030010000000001010101010000010b0000000000edeb68e6e564636261605f5e5d5c5b5a524a423a322a221f1c19110a040001d83b2110000d804a00000000f7c9800004840d2dbf00000003e46aa8508fa7968fa79607b36b2d302e303533363920302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020312e323230303001000000000101010101000000a70000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040001e03b2198000d804b0000000102b3000002d1682dc400000003e46aa8538fa7968fa79607b36b2d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e383530303000010000000201010101000000a70000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040401e83b2220000d804c0000000102b3000002d1682de200000003e46aa85a8fa7968fa79607b36b2d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e3835303030000100000002010101010000010b0000000000edeb6866e564636261605f5e5d5c5b5a524a423a322a221f1c19110a040001f03b22b0000d804d00000000f7c9800004840d2dec00000003e46ac0a78fa7968fa7960781152d342e363936373720302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020302e38353030300100000000010a02020a000701f70000000000edeb68e6e564636261605f5e5d5c5b5a524a423a322a221f1c19110a040001f83b2340000d804e00000000f7c9800004840d2dfb00000003e46b2dda8fa7968fa796079bb72d302e303533363920302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020312e3232303030010000000001010101010000010b0000000000edeb68e6e564636261605f5e5d5c5b5a524a423a322a221f1c19110a040002003b23d0000d804f00000000f7c9800004840d2e0a00000003e46b3e928fa7968fa79607b6d72d302e303533363920302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020312e323230303001000000000101010101000000a70000000000edeb68e6e564636261605f5e5d5c5b5a524a423a322a221f1c19110a040402083b2460000d805000000000f7c9800004840d2e1900000003e46b3e988fa7968fa79607b6d72d302e303533363920302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020312e323230303001000000000101010101000000a70000000000edeb68e6e564636261605f5e5d5c5b5a524a423a322a221f1c19110a040002103b24f0000d805100000000f7c9800004840d2e2800000003e46b3e9d8fa7968fa79607b6d72d302e303533363920302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020312e323230303001000000000101010101000000a70000000000edeb68e6e564636261605f5e5d5c5b5a524a423a322a221f1c19110a040002183b2580000d805200000000f7c9800004840d2e3700000003e46b4e798fa7928fa7920777e52d332e353639333720302e303030303020302e323630303020302e323230303020302e303030303020302e303030303020302e303030303001000000000102010101000002750000000000e5e3605edd5c5b5a59585756555453524a423a32aa2a221f1c19110a040002203b2608000d80530000000102b3000002d1682e0000000003e46bb51b8fa7968fa79607644f20302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020302e30303030300001000000021a03031a001602c40000000000edeb6866e564636261605f5e5d5c5b5a524a423a322a221f1c19110a040402283b2698000d805400000000f7c9800004840d2e5500000003e46bd16d8fa7968fa7960783102d322e323137303120302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020312e32323030300100000000010b01010b000900650000000000edeb6866e564636261605f5e5d5c5b5a524a423a322a221f1c19110a040002303b2728000d805500000000f7c9800004840d2e6400000003e46bd16e8fa7968fa7960783102d322e323137303120302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020312e32323030300100000000010b01010b000900650000000000edeb6866e564636261605f5e5d5c5b5a524a423a322a221f1c19110a040002383b27b8000d805600000000f7c9800004840d2e7300000003e46bd16f8fa7968fa7960783102d322e323137303120302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020312e32323030300100000000010b01010b000900650000000000edeb68666564636261605f5e5d5c5b5a524a423a322a221f1c19110a040002403b2848000d805700000000f7c9800004840d2e8200000003e46bd22c8fa7968fa7960783102d312e373732313920302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020312e3232303030010000000001040204040000009e0000000000edeb68666564636261605f5e5d5c5b5a524a423a322a221f1c19110a040402483b28d8000d805800000000f7c9800004840d2e9100000003e46bd24e8fa7928fa79207831020302e303030303020302e303030303020302e323630303020302e323230303020302e303030303020302e303030303020302e30303030300100000000010c010a0a080803c40000000000edeb68666564636261605f5e5d5c5b5a524a423a322a221f1c19110a040002503b2968000d805900000000f7c9800004840d2ea000000003e46bd24f8fa7928fa79207831020302e303030303020302e303030303020302e323630303020302e323230303020302e303030303020302e303030303020302e30303030300100000000010c010a0a080803c40000000000edeb68e6e564636261605f5e5d5c5b5a524a423a322a221f1c19110a040002583b29f8000d805a00000000f7c9800004840d2eaf00000003e46bd40d8fa7968fa7960785682d302e303533363920302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020312e3232303030010000000001010101010000010b0000000000e5e3605e5d5c5b5a59585756555453524a423a32aa2a221f1c19110a040002603b2a80000d805b0000000102b3000002d1682e1e00000003e46beabe8fa7968fa79606bc5920302e303030303020302e323630303020302e323230303020302e303030303020302e313730303020302e303030303000010000000208010808060600a70000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040402683b2b08000d805c0000000102b3000002d1682e3c00000003e46beac08fa7968fa79606bc592d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e383530303000010000000201010101000000a70000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040002703b2b90000d805d0000000102b3000002d1682e5a00000003e46beac18fa7968fa79606bc592d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e383530303000010000000201010101000000a70000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040002783b2c18000d805e0000000102b3000002d1682e7800000003e46beac28fa7968fa79606bc592d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e383530303000010000000201010101000000a70000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040002803b2ca0000d805f0000000102b3000002d1682e9600000003e46beac38fa7968fa79606bc592d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e383530303000010000000201010101000000a70000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040402883b2d28000d80600000000102b3000002d1682eb400000003e46beac48fa7968fa79606bc592d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e3835303030000100000002010101010000010b0000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040002903b2db0000d80610000000102b3000002d1682ed200000003e46beac58fa7968fa79606bc592d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e383530303000010000000201010101000000a70000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040002983b2e38000d80620000000102b3000002d1682ef000000003e46beac68fa7968fa79606bc592d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e3835303030000100000002010101010000010b0000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040002a03b2ec0000d80630000000102b3000002d1682f0e00000003e46beac78fa7968fa79606bc592d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e383530303000010000000201010101000000a70000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040402a83b2f48000d80640000000102b3000002d1682f2c00000003e46beac88fa7968fa79606bc592d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e383530303000010000000201010101000000a70000000000e5e360dedd5c5b5a59585756555453524a423a32aa2a221f1c19110a040002b03b2fd0000d80650000000102b3000002d1682f4a00000003e46bf52d8fa7968fa79606c2c12d302e303533363920302e323630303020302e323230303020302e303030303020302e313730303020302e383530303000010000000201010101000000a70000000000e5e3605e5d5c5b5a59585756555453524a423a32aa2a221f1c19110a040002b83b3058000d80660000000102b3000002d1682f6800000003e46bfa268fa7968fa79607b9782d302e303533363920302e323630; asc q.....$w..$v..$x........E...............;..n.........k.l................/............................infimum........supremum.kgd]QLIHCA><97420..'%!........7.*..|-.........it0.2003-12R....<.....................#.....DE ..DE ..3454 .EUR16.00    -0.012780072956NP ..c>kgd]QLIHCA><97420..'%!........7....|..........it0.2003-12R....<.....................#.....DE ..DE ..4651 .EUR16.00    -0.012780072956NP ..c?kgd]QLIHCA><97420..'%!....... 7.B..|/.........it0.2003-12R....<.....................#.....DE ..DE ..5357 .EUR16.00    -0.012780072956NP ..c@kgd]QLIHCA><97420..'%!.......(7....|0.........it0.2003-12R....<.....................#.....DE ..DE ..5357 .EUR16.00    -0.012780072956NP ..cAkgd]QLIHCA><97420..'%!.......07.Z..|1.........it1.2003-12R....<.....................#.....DE ..DE ..3346 .EUR16.00    -0.012780072956NP ..cBkgd]QLIHCA><97420..'%!.......87....|2.........it1.2003-12R....<.....................#.....DE ..DE ..1812 .EUR16.00    -0.012780072956NP ..cCkgd]QLIHCA><97420..'%!.......@7.r..|3.........it1(2003-12R....<.....................#.....DE ..DE ..1812 .EUR16.00    -0.012780072956NP ..cDkgd]QLIHCA><97420..'%!.......H7....|4.........it182003-12R....<.....................#.....DE ..DE ..5933 .EUR16.00    -0.012780072956NP ..cEkgd]QLIHCA><97420..'%!.......P7....|5.........it1H2003-12R....<.....................#.....DE .wDE ..8190 .EUR16.00    -0.012780072956NP ..cFkgd]QLIHCA><97420..'%!.......X7....|6.........it1X2003-12R....<.....................#.....DE ..DE ..5630 .EUR16.00    -0.012780072956NP ..cGkgd]QLIHCA><97420..'%!.......`7....|7.........it1h2003-12R....<.....................#.....DE ..DE ..5630 .EUR16.00    -0.012780072956NP ..cHkgd]QLIHCA><97420..'%!.......h7....|8.........it1x2003-12R....<.....................#.....DE ..DE ..5630 .EUR16.00    -0.012780072956NP ..cIkgd]QLIHCA><97420..'%!.......p7....|9.........it1.2003-12R....<.....................#.....DE .}DE ..2844 .EUR16.00    -0.012780072956NP ..cJkgd]QLIHCA><97420..'%!.......x7.F..|:.........it1.2003-12R....<.....................#.....DE ..DE ..5792 .EUR16.00    -0.012780072956NP ..cKkgd]QLIHCA><97420..'%!........7....|;.........it1.2003-12R....<.....................#.....DE ..DE ..6343 .EUR16.00    -0.012780072956NP ..cLkgd]QLIHCA><97420..'%!........7.^..|<.........it1.2003-12R....<.....................#.....DE ..DE ..5205 .EUR16.00    -0.012780072956NP ..cMkgd]QLIHCA><97420..'%!........7....|=.........it1.2003-12R....<.....................#.....DE ..DE ..5205 .EUR16.00    -0.012780072956NP ..cNkgd]QLIHCA><97420..'%!........7.v..|>.........it1.2003-12R....<.....................#.....DE ..DE ..5205 .EUR16.00    -0.012780072956NP ..cOkgd]QLIHCA><97420..'%!........7....|?.........it1.2003-12R....<.....................#.....DE ..DE ..5457 .EUR16.00    -0.012780072956NP ..cPkgd]QLIHCA><97420..'%!........7....|@.........it1.2003-12R....<.....................#.....DE ..DE ..5457 .EUR16.00    -0.012780072956NP ..cQkgd]QLIHCA><97420..'%!........7....|A.........it2.2003-12R....<.....................#.....DE ..DE ..5457 .EUR16.00    -0.012780072956NP ..cRkgd]QLIHCA><97420..'%!........7....|B.........it2.2003-12R....<.....................#.....DE ..DE ..5713 .EUR16.00    -0.012780072956NP ..cSkgd]QLIHCA><97420..'%!........7.2..|C.........it2(2003-12R....<.....................#.....DE ..DE ..5713 .EUR16.00    -0.012780072956NP ..cTkgd]QLIHCA><97420..'%!........7....|D.........it282003-12R....<.....................#.....DE ..DE ..5713 .EUR16.00    -0.012780072956NP ..cUkgd]QLIHCA><97420..'%!........7.J..|E.........it2H2003-12R....<.....................#.....DE .{DE ..3858 .EUR16.00    -0.012780072956NP ..cVkgd]QLIHCA><97420..'%!........7....|F.........it2X2003-12R....<.....................#.....DE .{DE ..3858 .EUR16.00    -0.012780072956NP ..cWkgd]QLIHCA><97420..'%!........7.b..|G.........it2h2003-12R....<.....................#.....DE .mDE ..9468 .EUR16.00    -0.012780072956NP ..cXkgd]QLIHCA><97420..'%!........7....|H.........it2x2003-12R....<.....................#.....DE ..DE ..1377 .EUR16.00    -0.012780072956NP ..cYkgd]QLIHCA><97420..'%!........7.z..|I.........it2.2003-12R....<.....................#.....DE ..DE ..6342 .EUR16.00    -0.012780072956NP ..cZkgd]QLIHCA><97420..'%!........7....|J.........it2.2003-12R....<.....................#.....DE ..DE ..1058 .EUR16.00    -0.012780072956NP ..c[kgd]QLIHCA><97420..'%!........7....|K.........it2.2003-12R....<.....................#.....DE ..DE ..0528 .EUR16.00    -0.012780072956NP ..c\kgd]QLIHCA><97420..'%!........7....|L.........it2.2003-12R....<.....................#.....DE .yDE ..9525 .EUR16.00    -0.012780072956NP ..c]kgd]QLIHCA><97420..'%!........7....|M.........it2.2003-12R....<.....................#.....DE .yDE ..9574 .EUR16.00    -0.012780072956NP ..c_kgd]QLIHCA><97420..'%!........7.6..|N.........it2.2003-12R....<.....................#.....DE .yDE ..9574 .EUR16.00    -0.012780072956NP ..c`kgd]QLIHCA><97420..'%!....... 7....|O.........it2.2003-12R....<.....................#.....DE ..DE ..0474 .EUR16.00    -0.012780072956NP ..cakgd]QLIHCA><97420..'%!.......(7.N..|P.........it2.2003-12R....<.....................#.....DE ..DE ..3165 .EUR16.00    -0.012780072956NP ..cbkgd]QLIHCA><97420..'%!.......07....|Q.........it3.2003-12R....<.....................#.....DE .nDE ..2277 .EUR16.00    -0.012780072956NP ..cckgd]QLIHCA><97420..'%!.......87.f..|R.........it3.2003-12R....<.....................#.....DE .wDE ..9348 .EUR16.00    -0.012780072956NP ..cdkgd]QLIHCA><97420..'%!.......@7....|S.........it3(2003-12R....<.....................#.....DE ..DE ..4163 .EUR16.00    -0.012780072956NP ..cekgd]QLIHCA><97420..'%!.......H7.~..|T.........it382003-12R....<.....................#.....DE .}DE ..5590 .EUR16.00    -0.012780072956NP ..cfkgd]QLIHCA><97420..'%!.......P7....|U.........it3H2003-12R....<.....................#.....DE ..DE ..4426 .EUR16.00    -0.012780072956NP ..cgkgd]QLIHCA><97420..'%!.......X7....|V.........it3X2003-12R....<.....................#.....DE ..DE ..6920 .EUR16.00    -0.012780072956NP ..chkgd]QLIHCA><97420..'%!.......`7."..|W.........it3h2003-12R....<.....................#.....DE ..DE ..7535 .EUR16.00    -0.012780072956NP ..cikgd]QLIHCA><97420..'%!.......h7....|X.........it3x2003-12R....<.....................#.....DE ..DE ..7535 .EUR16.00    -0.012780072956NP ..cjkgd]QLIHCA><97420..'%!.......p7.:..|Y.........it3.2003-12R....<.....................#.....DE .xDE ..1079 .EUR16.00    -0.012780072956NP ..ckkgd]QLIHCA><97420..'%!.......x7....|Z.........it3.2003-12R....<.....................#.....DE .mDE ..8107 .EUR16.00    -0.012780072956NP ..clkgd]QLIHCA><97420..'%!........7.R..|[.........it3.2003-12R....<.....................#.....DE ..DE ..0591 .EUR16.00    -0.012780072956NP ..cnkgd]QLIHCA><97420..'%!........7....|\.........it3.2003-12R....<.....................#.....DE ..DE ..5545 .EUR16.00    -0.012780072956NP ..cokgd]QLIHCA><97420..'%!........7.j..|].........it3.2003-12R....<.....................#.....DE ..DE ..8446 .EUR16.00    -0.012780072956NP ..cqkgd]QLIHCA><97420..'%!........7....|^.........it3.2003-12R....<.....................#.....DE .~DE ..6188 .EUR16.00    -0.012780072956NP ..crkgd]QLIHCA><97420..'%!........7....|_.........it3.2003-12R....<.....................#.....DE .gDE ..2953 .EUR16.00    -0.012780072956NP ..cskgd]QLIHCA><97420..'%!........7....|`.........it3.2003-12R....<.....................#.....DE ..DE ..6244 .EUR16.00    -0.012780072956NP ..ctkgd]QLIHCA><97420..'%!........7....|a.........it4.2003-12R....<.....................#.....DE ..DE ..7629 .EUR16.00    -0.012780072956NP ..cukgd]QLIHCA><97420..'%!........7.&..|b.........it4.2003-12R....<.....................#.....DE .nDE ..3503 .EUR16.00    -0.012780072956NP ..cvkgd]QLIHCA><97420..'%!........7....|c.........it4(2003-12R....<.....................#.....DE .nDE ..3437 .EUR16.00    -0.012780072956NP ..cwkgd]QLIHCA><97420..'%!........7.>..|d.........it482003-12R....<.....................#.....DE ..DE ..8599 .EUR16.00    -0.012780072956NP ..cxkgd]QLIHCA><97420..'%!........7....|e.........it4H2003-12R....<.....................#.....DE ..DE ..7482 .EUR16.00    -0.012780072956NP ..cykgd]QLIHCA><97420..'%!........7 V..|f.........it4X2003-12R....<.....................#.....DE ..DE ..8636 .EUR16.00    -0.012780072956NP ..czkgd]QLIHCA><97420..'%!........7 ...|g.........it4h2003-12R....<.....................#.....DE .nDE ..2207 .EUR16.00    -0.012780072956NP ..c}kgd]QLIHCA><97420..'%!........7!n..|h.........it4x2003-12R....<.....................#.....DE ..DE ..8250 .EUR16.00    -0.012780072956NP ..c~kgd]QLIHCA><97420..'%!........7!...|i.........it4.2003-12R....<.....................#.....DE .xDE ..2525 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7"...|j.........it4.2003-12R....<.....................#.....DE ..DE ..4539 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7#...|k.........it4.2003-12R....<.....................#.....DE .wDE ..8320 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7#...|l.........it4.2003-12R....<.....................#.....DE .zDE ..4109 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7$*..|m.........it4.2003-12R....<.....................#.....DE ..DE ..8453 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7$...|n.........it4.2003-12R....<.....................#.....DE ..DE ..3026 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!....... 7%B..|o.........it4.2003-12R....<.....................#.....DE .~DE ..6340 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!.......(7%...|p.........it4.2003-12R....<.....................#.....DE .xDE ..2589 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!.......07&Z..|q.........it5.2003-12R....<.....................#.....DE ..DE ..5043 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!.......87&...|r.........it5.2003-12R....<.....................#.....DE ..DE ..5472 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!.......@7'r..|s.........it5(2003-12R....<.....................#.....DE ..DE ..3105 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!.......H7'...|t.........it582003-12R....<.....................#.....DE ..DE ..1231 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!.......P7(...|u.........it5H2003-12R....<.....................#.....DE ..DE ..8110 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!.......X7)...|v.........it5X2003-12R....<.....................#.....DE ..DE ..8816 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!.......`7)...|w.........it5h2003-12R....<.....................#.....DE .yDE ..1502 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!.......h7*...|x.........it5x2003-12R....<.....................#.....DE .hDE ..4808 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!.......p7*...|y.........it5.2003-12R....<.....................#.....DE ..DE ..1836 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!.......x7+F..|z.........it5.2003-12R....<.....................#.....DE ..DE ..4377 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7+...|{.........it5.2003-12R....<.....................#.....DE ..DE ..1241 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7,^..||.........it5.2003-12R....<.....................#.....DE ..DE ..4065 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7,...|}.........it5.2003-12R....<.. ..................#.....DE ..DE ..3804 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7-v..|~.........it5.2003-12R....<..!..................#.....DE .~DE ..6441 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7....|..........it5.2003-12R....<..$..................#.....DE ..DE ..1647 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7....|..........it5.2003-12R....<..&..................#.....DE .}DE ..5590 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7/...|..........it6.2003-12R....<..(..................#.....DE .}DE ..5451 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........7/...|..........it6.2003-12R....<..)..................#.....DE ..DE ..4390 .EUR16.00    -0.012780072956NP ..c.kgd]QLIHCA><97420..'%!........702..|..........it6(2003-12R....<..*..................#.....DE ..DE ..4420 .EUR16.00    -0.01......j.N........k-0.05369 0.00000 0.26000 0.22000 0.00000 0.17000 1.22000.....................h..dcba`_^]\[ZRJB:2*".........;!....J...........-......j.P........k-0.05369 0.00000 0.26000 0.22000 0.00000 0.17000 1.22000.....................`..\[ZYXWVUTSRJB:2.*".........;!....K..........h-......j.S........k-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................`..\[ZYXWVUTSRJB:2.*".........;" ...L..........h-......j.Z........k-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................hf.dcba`_^]\[ZRJB:2*".........;"....M...........-......j...........-4.69677 0.00000 0.26000 0.22000 0.00000 0.17000 0.85000.....................h..dcba`_^]\[ZRJB:2*".........;#@...N...........-......k-..........-0.05369 0.00000 0.26000 0.22000 0.00000 0.17000 1.22000.....................h..dcba`_^]\[ZRJB:2*".........;#....O..................k>..........-0.05369 0.00000 0.26000 0.22000 0.00000 0.17000 1.22000.....................h..dcba`_^]\[ZRJB:2*".........;$`...P..................k>..........-0.05369 0.00000 0.26000 0.22000 0.00000 0.17000 1.22000.....................h..dcba`_^]\[ZRJB:2*".........;$....Q............(.....k>..........-0.05369 0.00000 0.26000 0.22000 0.00000 0.17000 1.22000.....................h..dcba`_^]\[ZRJB:2*".........;%....R............7.....kNy.......w.-3.56937 0.00000 0.26000 0.22000 0.00000 0.00000 0.00000.............u.......`^.\[ZYXWVUTSRJB:2.*"........ ;&....S..........h.......k.........dO 0.00000 0.26000 0.22000 0.00000 0.17000 0.00000.....................hf.dcba`_^]\[ZRJB:2*"........(;&....T............U.....k.m.........-2.21701 0.00000 0.26000 0.22000 0.00000 0.17000 1.22000.............e.......hf.dcba`_^]\[ZRJB:2*"........0;'(...U............d.....k.n.........-2.21701 0.00000 0.26000 0.22000 0.00000 0.17000 1.22000.............e.......hf.dcba`_^]\[ZRJB:2*"........8;'....V............s.....k.o.........-2.21701 0.00000 0.26000 0.22000 0.00000 0.17000 1.22000.............e.......hfedcba`_^]\[ZRJB:2*"........@;(H...W..................k.,.........-1.77219 0.00000 0.26000 0.22000 0.00000 0.17000 1.22000.....................hfedcba`_^]\[ZRJB:2*"........H;(....X..................k.N......... 0.00000 0.00000 0.26000 0.22000 0.00000 0.00000 0.00000.....................hfedcba`_^]\[ZRJB:2*"........P;)h...Y..................k.O......... 0.00000 0.00000 0.26000 0.22000 0.00000 0.00000 0.00000.....................h..dcba`_^]\[ZRJB:2*"........X;)....Z..................k..........h-0.05369 0.00000 0.26000 0.22000 0.00000 0.17000 1.22000.....................`^]\[ZYXWVUTSRJB:2.*"........`;*....[..........h.......k..........Y 0.00000 0.26000 0.22000 0.00000 0.17000 0.00000.....................`..\[ZYXWVUTSRJB:2.*"........h;+....\..........h.<.....k..........Y-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................`..\[ZYXWVUTSRJB:2.*"........p;+....]..........h.Z.....k..........Y-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................`..\[ZYXWVUTSRJB:2.*"........x;,....^..........h.x.....k..........Y-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................`..\[ZYXWVUTSRJB:2.*".........;,...._..........h.......k..........Y-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................`..\[ZYXWVUTSRJB:2.*".........;-(...`..........h.......k..........Y-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................`..\[ZYXWVUTSRJB:2.*".........;-....a..........h.......k..........Y-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................`..\[ZYXWVUTSRJB:2.*".........;.8...b..........h.......k..........Y-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................`..\[ZYXWVUTSRJB:2.*".........;.....c..........h/......k..........Y-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................`..\[ZYXWVUTSRJB:2.*".........;/H...d..........h/,.....k..........Y-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................`..\[ZYXWVUTSRJB:2.*".........;/....e..........h/J.....k.-.........-0.05369 0.26000 0.22000 0.00000 0.17000 0.85000.....................`^]\[ZYXWVUTSRJB:2.*".........;0X...f..........h/h.....k.&........x-0.05369 0.260;InnoDB: End of page dump
040202 15:33:12  InnoDB: Page checksum 2164630931, prior-to-4.0.14-form checksum 3369504918
InnoDB: stored checksum 1909665449, prior-to-4.0.14-form stored checksum 909713456
InnoDB: Page lsn 27 3154770567, low 4 bytes of lsn at page end 775042608
InnoDB: Page may be an index page where index id is 0 12063
InnoDB: and table basis/clearing index PRIMARY
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 730231.
InnoDB: You may have to recover from a backup.
InnoDB: It is also possible that your operating
InnoDB: system has corrupted its own file cache
InnoDB: and rebooting your computer removes the
InnoDB: error.
InnoDB: If the corrupt page is an index page
InnoDB: you can also try to fix the corruption
InnoDB: by dumping, dropping, and reimporting
InnoDB: the corrupt table. You can use CHECK
InnoDB: TABLE to scan your table for corruption.
InnoDB: Look also at section 6.1 of
InnoDB: http://www.innodb.com/ibman.html about
InnoDB: forcing recovery.
InnoDB: Ending processing because of a corrupt database page.

Number of processes running now: 0
040202 15:33:12  mysqld restarted
040202 15:33:14  InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 32 1621526667
InnoDB: Doing recovery: scanned up to log sequence number 32 1621526667
040202 15:33:14  InnoDB: Flushing modified pages from the buffer pool...
040202 15:33:15  InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.15-Max'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 957251.
InnoDB: You may have to recover from a backup.
040202 16:19:32  InnoDB: Page dump in ascii and hex (16384 bytes):
 len 16384; hex 20a27f34000e9b4300000000000000000000002065caaf650002000000000000000000000000000200383fbb000e9b42002c000e9b44002c007f0ec82d6aa7200000000109b5049f922d920401999e0a002d0307323030332d31320508000000052465731a0d0a323030332d31322d3137000401999e0a1af0ffffffff003800c60ec82d6ba7200000000109b5049f922e130401999e0b002d0307323030332d3132050800000005246573230d0a323030332d31322d3137000401999e0b1af0ffffffff007f010d0ec82d6ca7200000000109b5049f922e940401999e0c002d0307323030332d31320508000000052465733f0d0a323030332d31322d3137000401999e0c1af0ffffffff00c601540ec82d6da7200000000109b5049f922f150401999e0d002d0307323030332d3132050800000005246573c50d0a323030332d31322d3137000401999e0d1af0ffffffff010d019b0ec82d6ea7200000000109b5049f922f960401999e0e002d0307323030332d3132050800000005246573c60d0a323030332d31322d3137000401999e0e1af0ffffffff015401e20ec82d6fa7200000000109b5049f9230170401999e0f002d0307323030332d3132050800000005246573c70d0a323030332d31322d3137000401999e0f1af0ffffffff019b02290ec82d70a7200000000109b5049f9230980401999e10002d0307323030332d3132050800000005246573c80d0a323030332d31322d3137000401999e101af0ffffffff01e202700ec82d71a7200000000109b5049f9231190401999e11002d0307323030332d3132050800000005246573eb0d0a323030332d31322d3138000401999e111af0ffffffff022902b70ec82d72a7200000000109b5049f92319a0401999e12002d0307323030332d31320508000000052465740e0d0a323030332d31322d3138000401999e121af0ffffffff027002fe0ec82d73a7200000000109b5049f92321b0401999e13002d0307323030332d3132050800000005246574190d0a323030332d31322d3138000401999e131af0ffffffff02b703450ec82d74a7200000000109b5049f92329c0401999e14002d0307323030332d3132050800000005246574790d0a323030332d31322d3138000401999e141af0ffffffff02fe038c0ec82d75a7200000000109b5049f92331d0401999e15002d0307323030332d31320508000000052465747d0d0a323030332d31322d3138000401999e151af0ffffffff034503d30ec82d76a7200000000109b5049f92339e0401999e16002d0307323030332d31320508000000052465749d0d0a323030332d31322d3138000401999e161af0ffffffff038c041a0ec82d77a7200000000109b5049f92341f0401999e17002d0307323030332d31320508000000052465751c0d0a323030332d31322d3138000401999e171af0ffffffff03d304610ec82d78a7200000000109b5049f9234a00401999e18002d0307323030332d3132050800000005246575860d0a323030332d31322d3139000401999e181af0ffffffff041a04a80ec82d79a7200000000109b5049f9235210401999e19002d0307323030332d31320508000000052465759f0d0a323030332d31322d3139000401999e191af0ffffffff046104ef0ec82d7aa7200000000109b5049f9235a20401999e1a002d0307323030332d3132050800000005246575be0d0a323030332d31322d3139000401999e1a1af0ffffffff04a805360ec82d7ba7200000000109b5049f9236230401999e1b002d0307323030332d3132050800000005246576040d0a323030332d31322d3139000401999e1b1af0ffffffff04ef057d0ec82d7ca7200000000109b5049f9236a40401999e1c002d0307323030332d3132050800000005246576560d0a323030332d31322d3233000401999e1c1af0ffffffff053605c40ec82d7da7200000000109b5049f9237250401999e1d002d0307323030332d3132050800000005246576570d0a323030332d31322d3232000401999e1d1af0ffffffff057d060b0ec82d7ea7200000000109b5049f9237a60401999e1e002d0307323030332d3132050800000005246576670d0a323030332d31322d3139000401999e1e1af0ffffffff05c406520ec82d7fa7200000000109b5049f9238270401999e1f002d0307323030332d31320508000000052465769f0d0a323030332d31322d3232000401999e1f1af0ffffffff060b06990ec82d80a7200000000109b5049f9238a80401999e20002d0307323030332d3132050800000005246576b60d0a323030332d31322d3139000401999e201af0ffffffff065206e00ec82d81a7200000000109b5049f9239290401999e21002d0307323030332d3132050800000005246576c20d0a323030332d31322d3139000401999e211af0ffffffff069907270ec82d82a7200000000109b5049f9239aa0401999e22002d0307323030332d3132050800000005246576c40d0a323030332d31322d3139000401999e221af0ffffffff06e0076e0ec82d83a7200000000109b5049f923a2b0401999e23002d0307323030332d3132050800000005246576ff0d0a323030332d31322d3139000401999e231af0ffffffff072707b50ec82d84a7200000000109b5049f923aac0401999e24002d0307323030332d31320508000000052465770b0d0a323030332d31322d3139000401999e241af0ffffffff076e07fc0ec82d85a7200000000109b5049f923b2d0401999e25002d0307323030332d3132050800000005246577ad0d0a323030332d31322d3232000401999e251af0ffffffff07b508430ec82d86a7200000000109b5049f923bae0401999e26002d0307323030332d3132050800000005246577e80d0a323030332d31322d3232000401999e261af0ffffffff07fc088a0ec82d87a7200000000109b5049f923c2f0401999e27002d0307323030332d3132050800000005246577ee0d0a323030332d31322d3232000401999e271af0ffffffff084308d10ec82d88a7200000000109b5049f923cb00401999e28002d0307323030332d3132050800000005246578300d0a323030332d31322d3232000401999e281af0ffffffff088a09180ec82d89a7200000000109b5049f923d310401999e29002d0307323030332d3132050800000005246578470d0a323030332d31322d3232000401999e291af0ffffffff08d1095f0ec82d8aa7200000000109b5049f923db20401999e2a002d0307323030332d3132050800000005246578ad0d0a323030332d31322d3232000401999e2a1af0ffffffff091809a60ec82d8ba7200000000109b5049f923e330401999e2b002d0307323030332d3132050800000005246578cf0d0a323030332d31322d3232000401999e2b1af0ffffffff095f09ed0ec82d8ca7200000000109b5049f923eb40401999e2c002d0307323030332d31320508000000052465792a0d0a323030332d31322d3232000401999e2c1af0ffffffff09a60a340ec82d8da7200000000109b5049f923f350401999e2d002d0307323030332d31320508000000052465792c0d0a323030332d31322d3232000401999e2d1af0ffffffff09ed0a7b0ec82d8ea7200000000109b5049f9300380401999e2e002d0307323030332d3132050800000005246579300d0a323030332d31322d3232000401999e2e1af0ffffffff0a340ac20ec82d8fa7200000000109b5049f9300b90401999e2f002d0307323030332d3132050800000005246579320d0a323030332d31322d3232000401999e2f1af0ffffffff0a7b0b090ec82d90a7200000000109b5049f93013a0401999e30002d0307323030332d3132050800000005246579780d0a323030332d31322d3233000401999e301af0ffffffff0ac20b500ec82d91a7200000000109b5049f9301bb0401999e31002d0307323030332d3132050800000005246579880d0a323030332d31322d3233000401999e311af0ffffffff0b090b970ec82d92a7200000000109b5049f93023c0401999e32002d0307323030332d3132050800000005246579a80d0a323030332d31322d3233000401999e321af0ffffffff0b500bde0ec82d93a7200000000109b5049f9302bd0401999e33002d0307323030332d313205080000000524657a110d0a323030332d31322d3233000401999e331af0ffffffff0b970c250ec82d94a7200000000109b5049f93033e0401999e34002d0307323030332d313205080000000524657a430d0a323030332d31322d3233000401999e341af0ffffffff0bde0c6c0ec82d95a7200000000109b5049f9303bf0401999e35002d0307323030332d313205080000000524657a6e0d0a323030332d31322d3233000401999e351af0ffffffff0c250cb30ec82d96a7200000000109b5049f9304400401999e36002d0307323030332d313205080000000524657ab30d0a323030332d31322d3233000401999e361af0ffffffff0c6c0cfa0ec82d97a7200000000109b5049f9304c10401999e37002d0307323030332d313205080000000524657acf0d0a323030332d31322d3233000401999e371af0ffffffff0cb30d410ec82d98a7200000000109b5049f9305420401999e38002d0307323030332d313205080000000524657b0a0d0a323030332d31322d3233000401999e381af0ffffffff0cfa0d880ec82d99a7200000000109b5049f9305c30401999e39002d0307323030332d313205080000000524657b1e0d0a323030332d31322d3233000401999e391af0ffffffff0d410dcf0ec82d9aa7200000000109b5049f9306440401999e3a002d0307323030332d313205080000000524657b5c0d0a323030332d31322d3239000401999e3a1af0ffffffff0d880e160ec82d9ba7200000000109b5049f9306c50401999e3b002d0307323030332d313205080000000524657b670d0a323030332d31322d3239000401999e3b1af0ffffffff0dcf0e5d0ec82d9ca7200000000109b5049f9307460401999e3c002d0307323030332d313205080000000524657b6c0d0a323030332d31322d3239000401999e3c1af0ffffffff0e160ea40ec82d9da7200000000109b5049f9307c70401999e3d002d0307323030332d313205080000000524657b8c0d0a323030332d31322d3239000401999e3d1af0ffffffff0e5d0eeb0ec82d9ea7200000000109b5049f9308480401999e3e002d0307323030332d313205080000000524657b970d0a323030332d31322d3239000401999e3e1af0ffffffff0ea40f320ec82d9fa7200000000109b5049f9308c90401999e3f002d0307323030332d313205080000000524657b9e0d0a323030332d31322d3239000401999e3f1af0ffffffff0eeb0f790ec82da0a7200000000109b5049f93094a0401999e40002d0307323030332d313205080000000524657bb70d0a323030332d31322d3239000401999e401af0ffffffff0f320fc00ec82da1a7200000000109b5049f9309cb0401999e41002d0307323030332d313205080000000524657bbe0d0a323030332d31322d3239000401999e411af0ffffffff0f7910070ec82da2a7200000000109b5049f930a4c0401999e42002d0307323030332d313205080000000524657bc70d0a323030332d31322d3239000401999e421a2020202020200fda10361ce061252fa720000000010b001876b62f960401d12f61011710302e3033383335202020202020202020100810641ce0612530a720000000010b001876b630170401d12f62011710302e3033383335202020202020202020103610921ce0612531a720000000010b001876b630980401d12f63011710302e3033383335202020202020202020106410c01ce0612532a720000000010b001876b631190401d12f64011710302e3033383335202020202020202020109210ee1ce0612533a720000000010b001876b6319a0401d12f65011710302e303338333520202020202020202010c0111c1ce0612534a720000000010b001876b6321b0401d12f66011710302e303338333520202020202020202010ee114a1ce0612535a720000000010b001876b6329c0401d12f67011710302e3033383335202020202020202020111c11781ce0612536a720000000010b001876b6331d0401d12f68011710302e3033383335202020202020202020114a11a61ce0612537a720000000010b001876b6339e0401d12f69011710302e3033383335202020202020202020117811d41ce0612538a720000000010b001876b6341f0401d12f6a011710302e303338333520202020202020202011a612021ce0612539a720000000010b001876b634a00401d12f6b011710302e303338333520202020202020202011d412301ce061253aa720000000010b001876b635210401d12f6c011710302e30333833352020202020202020201202125e1ce061253ba720000000010b001876b635a20401d12f6d011710302e30333833352020202020202020201230128c1ce061253ca720000000010b001876b636230401d12f6e011710302e3033383335202020202020202020125e12ba1ce061253da720000000010b001876b636a40401d12f6f011710302e3033383335202020202020202020128c12e81ce061253ea720000000010b001876b637250401d12f70011710302e303338333520202020202020202012ba13161ce061253fa720000000010b001876b637a60401d12f71011710302e303338333520202020202020202012e813441ce0612540a720000000010b001876b638270401d12f72011710302e3033383335202020202020202020131613721ce0612541a720000000010b001876b638a80401d12f73011710302e3033383335202020202020202020134413a01ce0612542a720000000010b001876b639290401d12f74011710302e3033383335202020202020202020137213ce1ce0612543a720000000010b001876b639aa0401d12f75011710302e303338333520202020202020202013a013fc1ce0612544a720000000010b001876b63a2b0401d12f76011710302e303338333520202020202020202013ce142a1ce0612545a720000000010b001876b63aac0401d12f77011710302e303338333520202020202020202013fc14581ce0612546a720000000010b001876b63b2d0401d12f78011710302e3033383335202020202020202020142a14861ce0612547a720000000010b001876b63bae0401d12f79011710302e3033383335202020202020202020145814b41ce0612548a720000000010b001876b63c2f0401d12f7a011710302e3033383335202020202020202020148614e21ce0612549a720000000010b001876b63cb00401d12f7b011710302e303338333520202020202020202014b415101ce061254aa720000000010b001876b63d310401d12f7c011710302e303338333520202020202020202014e2153e1ce061254ba720000000010b001876b63db20401d12f7d011710302e30333833352020202020202020201510156c1ce061254ca720000000010b001876b63e330401d12f7e011710302e3033383335202020202020202020153e159a1ce061254da720000000010b001876b63eb40401d12f7f011710302e3033383335202020202020202020156c15c81ce061254ea720000000010b001876b63f350401d12f80011710302e3033383335202020202020202020159a15f61ce061254fa720000000010b001876b700380401d12f81011710302e303338333520202020202020202015c816241ce0612550a720000000010b001876b700b90401d12f82011710302e303338333520202020202020202015f616521ce0612551a720000000010b001876b7013a0401d12f83011710302e3033383335202020202020202020162416801ce0612552a720000000010b001876b701bb0401d12f84011710302e303338333520202020202020202016521
[2 Feb 2004 12:50] Heikki Tuuri
Hi!

Sorry, I pushed a wrong button.

Please post the WHOLE .err log of mysqld, and also resolve some of the stack traces there.

Best regards,

Heikki
[2 Feb 2004 12:53] Thomas Mayer
# This is for large system with memory of 1G-2G where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.

# The MySQL server
[mysqld]
port		= 3306
socket		= /var/lib/mysql/mysql.sock
skip-locking
set-variable	= key_buffer=384M
set-variable	= max_allowed_packet=1M
set-variable	= table_cache=150
set-variable	= sort_buffer=2M
set-variable	= record_buffer=2M
set-variable	= thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable	= thread_concurrency=4
set-variable	= myisam_sort_buffer_size=64M
default-table-type=innodb
set-variable	= max_connections=30
#open-files-limit= 8192
open-files-limit= 1000

#QUERY-Cache
#query_cache_limit: max. Speicherplatz für eine Abfrage (default 1M)
set-variable	= query_cache_limit=3M
#query_cache_size: max. Speicherplatz für alle Abfragen (default 0M(query cache disabled))
set-variable	= query_cache_size=40M
#Cache-Typ O=off, 1=alles cachen außer "select sql_no_cache ...", 2=nur "select sql_cache ..."
set-variable	= query_cache_type=1
#!!!!! Alle 3 Query-Cache-Variablen wieder reinsetzen! Nur zum Performance-Test rausnehmen!

# Replication Master Server (default)
#log-bin             # required for replication
#server-id	= 1 # required unique id between 1 and 2^32 - 1
                    # defaults to 1 if master-host is not set
                    # but will not function as a master if omitted

# Replication Slave Server (comment out master section to use this)
#master-host     =   # MUST BE SET
#master-user     =   # MUST BE SET
#master-password =   # MUST BE SET
#master-port     =   # optional--defaults to 3306
#log-bin             # not required for slaves, but recommended
#server-id       = 2 # required unique id between 2 and 2^32 - 1
                    # (and different from the master)
                    # defaults to 2 if master-host is set
                    # but will not function as a slave if omitted

# Point the following paths to different dedicated disks
#tmpdir		= /tmp/		
#log-update 	= /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#set-variable	= bdb_cache_size=384M
#set-variable	= bdb_max_lock=100000

# Uncomment the following if you are using Innobase tables
innodb_data_file_path = /mydata/ibdata1:4000M;/mydata/ibdata2:4000M;/mydata/ibdata3:4000M;/mydata/ibdata4:4000M;/mydata/ibdata5:4000M;/mydata/ibdata6:4000M

#innodb_data_home_dir = /var/lib/mysql/
innodb_data_home_dir =
#innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_group_home_dir = /mydata/iblog/
#innodb_log_arch_dir = /var/lib/mysql/
innodb_log_arch_dir = /mydata/iblog/
#set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
#Empfehlung: innodb_log_file_size*innodb_log_files_in_group=innodb_buffer_pool_size
#set-variable = innodb_log_file_size=5M
set-variable = innodb_log_file_size=600M
#Normal von 1M-8M, kann aber höher gesetzt werden. Zwischenspeicher vor Schreiben in Log-Files vor einem Commit
#set-variable = innodb_log_buffer_size=8M
set-variable = innodb_log_buffer_size=16M
#innodb_flush_log_at_trx_commit=1 Verwendung von Zwischenspeicherung in Logs, 0 ist schneller, 1 ist sicherer
innodb_flush_log_at_trx_commit=0
#fdatasync, fsync oder O_DSYNC Erfahrungswert, muss noch getestet werden!
#innodb_flush_method=fdatasync
innodb_flush_method=fdatasync
#innodb_log_archive=0
#innodb_buffer_pool_size: 50%-80% des gesamten Arbeitsspeichers, max. 2GB (!Test: max 1700M)
#set-variable = innodb_buffer_pool_size=16M
#####Bei 3 GB Arbeitsspeicher wieder auf 1700M hochsetzen!
set-variable = innodb_buffer_pool_size=1500M
#set-variable = innodb_buffer_pool_size=500M
#Zum Zwischenspeichern von Datenstrukturen und Internas, holt sich Speicher vom System, wenn zu klein, in diesem Fall erfolgt Vermerk im log
#set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_additional_mem_pool_size=2M
#innodb_file_io_threads=4 : normal 4, unter Windows gerne höher
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=600
#set-variable = innodb_thread_concurrency=8 Empfohlen: Festplatten + CPUs; Defaultwert: 8
set-variable = innodb_thread_concurrency=5

[mysqldump]
quick
add-drop-table
add-locks
extended-insert
complete-insert
single-transaction
no-autocommit
set-variable	= max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable	= key_buffer=256M
set-variable	= sort_buffer=256M
set-variable	= read_buffer=2M
set-variable	= write_buffer=2M

[myisamchk]
set-variable	= key_buffer=256M
set-variable	= sort_buffer=256M
set-variable	= read_buffer=2M
set-variable	= write_buffer=2M

[mysqlhotcopy]
interactive-timeout

# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3306
socket		= /var/lib/mysql/mysql.sock
host		= localhost

[client_fltk]
help_file=~/.guiclient/MySQL.help
client_file=~/.guiclient/MySQL.options
history_length=20
database = telcent
queries_root=~/.guiclient/queries
last_database_file=~/.guiclient/ladb
[2 Feb 2004 12:55] Thomas Mayer
Variable_name	Value
back_log	50
basedir	/
bdb_cache_size	8388600
bdb_log_buffer_size	76800
bdb_home	/var/lib/mysql/
bdb_max_lock	10000
bdb_logdir	
bdb_shared_data	OFF
bdb_tmpdir	/tmp/
bdb_version	Sleepycat Software: Berkeley DB 3.2.9a: (December 14
binlog_cache_size	32768
bulk_insert_buffer_size	8388608
character_set	latin1
character_sets	latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent_insert	ON
connect_timeout	5
convert_character_set	
datadir	/var/lib/mysql/
default_week_format	0
delay_key_write	ON
delayed_insert_limit	100
delayed_insert_timeout	300
delayed_queue_size	1000
flush	OFF
flush_time	0
ft_boolean_syntax	+ -><()~*:""&|
ft_min_word_len	4
ft_max_word_len	254
ft_max_word_len_for_sort	20
ft_stopword_file	(built-in)
have_bdb	YES
have_crypt	YES
have_innodb	YES
have_isam	YES
have_raid	YES
have_symlink	YES
have_openssl	NO
have_query_cache	YES
init_file	
innodb_additional_mem_pool_size	2097152
innodb_buffer_pool_size	1572864000
innodb_data_file_path	/mydata/ibdata1:4000M;/mydata/ibdata2:4000M;/mydata/ibdata3:4000M;/mydata/ibdata4:4000M;/mydata/ibdata5:4000M;/mydata/ibdata6:4000M
innodb_data_home_dir	
innodb_file_io_threads	4
innodb_force_recovery	0
innodb_thread_concurrency	5
innodb_flush_log_at_trx_commit	0
innodb_fast_shutdown	ON
innodb_flush_method	fdatasync
innodb_lock_wait_timeout	600
innodb_log_arch_dir	/mydata/iblog/
innodb_log_archive	OFF
innodb_log_buffer_size	16777216
innodb_log_file_size	629145600
innodb_log_files_in_group	3
innodb_log_group_home_dir	/mydata/iblog/
innodb_mirrored_log_groups	1
innodb_max_dirty_pages_pct	90
interactive_timeout	28800
join_buffer_size	131072
key_buffer_size	402653184
language	/usr/share/mysql/english/
large_files_support	ON
local_infile	ON
locked_in_memory	OFF
log	OFF
log_update	OFF
log_bin	OFF
log_slave_updates	OFF
log_slow_queries	OFF
log_warnings	OFF
long_query_time	10
low_priority_updates	OFF
lower_case_table_names	OFF
max_allowed_packet	1047552
max_binlog_cache_size	4294967295
max_binlog_size	1073741824
max_connections	30
max_connect_errors	10
max_delayed_threads	20
max_heap_table_size	16777216
max_join_size	4294967295
max_relay_log_size	0
max_seeks_for_key	4294967295
max_sort_length	1024
max_user_connections	0
max_tmp_tables	32
max_write_lock_count	4294967295
myisam_max_extra_sort_file_size	268435456
myisam_max_sort_file_size	2147483647
myisam_repair_threads	1
myisam_recover_options	OFF
myisam_sort_buffer_size	67108864
net_buffer_length	16384
net_read_timeout	30
net_retry_count	10
net_write_timeout	60
new	OFF
open_files_limit	1000
pid_file	/var/lib/mysql/qis3.pid
log_error	
port	3306
protocol_version	10
query_alloc_block_size	8192
query_cache_limit	3145728
query_cache_size	41943040
query_cache_type	ON
query_prealloc_size	8192
range_alloc_block_size	2048
read_buffer_size	2093056
read_only	OFF
read_rnd_buffer_size	262144
rpl_recovery_rank	0
server_id	0
slave_net_timeout	3600
skip_external_locking	ON
skip_networking	OFF
skip_show_database	OFF
slow_launch_time	2
socket	/var/lib/mysql/mysql.sock
sort_buffer_size	2097144
sql_mode	0
table_cache	150
table_type	INNODB
thread_cache_size	8
thread_stack	196608
tx_isolation	REPEATABLE-READ
timezone	CET
tmp_table_size	33554432
tmpdir	/tmp/
transaction_alloc_block_size	8192
transaction_prealloc_size	4096
version	4.0.17-Max
version_comment	Official MySQL RPM
wait_timeout	28800
[2 Feb 2004 13:14] Heikki Tuuri
Thomas,

this is probably a bug in the OS/drivers/hardware and not in mysqld.

Look at the end of the corrupt page:

"
...k.-.........-0.05369 0.26000 0.22000 0.00000 0.17000
0.85000.....................`^]\[ZYXWVUTSRJB:2.*".........;0X...f..........h/h..
...k.&........x-0.05369 0.260;InnoDB: End of page dump
040202 15:33:12  InnoDB: Page checksum 2164630931, prior-to-4.0.14-form checksum
3369504918
InnoDB: stored checksum 1909665449, prior-to-4.0.14-form stored checksum
909713456
InnoDB: Page lsn 27 3154770567, low 4 bytes of lsn at page end 775042608
"

Index records seem to extend over the page end, where the page record dir should be. And the lsn field at the page start differs from the lsn field at the page end! As if a few kB at the page end would be a displaced fragment from another index page. Before, I have seen one corruption report where an index page seemed to be 8 kB displaced.

Before writing a data page to a data file, InnoDB checks that the lsn at the start and the end is the same. The corruption has probably happened in the OS or the hardware.

Corruption is now rarer than it used to be with Linux-2.4.18 kernels. The standard advice in a case like this is:

1. Try rebooting the computer.
2. Run harware tests, like a RAM or disk test.
3. Upgrade to a more recent Linux kernel and more recent drivers.
4. Tweak the buffer pool size. Changing it might mask some bug/hardware fault.

With apologies,

Heikki
[2 Feb 2004 13:36] Thomas Mayer
Hello Heikki,

thanks a lot for that very fast reply.

I already tried rebooting the computer and tested ram using Memtest86 3.00

As the error occured on three new machines from dell, it does neither seem to be the IDE raid controller nor the hard disks. As far as I know, all OS on working and not working servers are installed the same. This includes OS Suse 8.2 using the same kernel on all systems. 

But I'll do the same tests once again to be sure. I won't do a backtrace until there is no reason to do so as I do not have a test system on which the error has occured. Please tell me if you need one.

In which way do you think changing the buffer pool size could influence the problem? Does my configuration contain any risk in case hardware/driver/os are ok?

Thanks in advance,
Thomas
[2 Feb 2004 13:55] Heikki Tuuri
Thomas,

a trace will not help. The corruption has already happened when InnoDB asserts.

My hypothesis has long been that most corruption cases like this are caused by bugs in drivers, or in their interfacing to Linux. Then an upgrade is the best bet.

Your my.cnf is ok, but changing the buffer pool size might change the access pattern enough to hide the bug, whatever it is. Though this usually does not help.

Regards,

Heikki