data corruption

[Cristian Sergiu]

Hi

I have a problem with 2 of my tables.
I don not know what caused that.

When i try to do :

mysql>Select * from table_name_1;

==> ERROR 2013: Lost connection to MySQL server during query
and the server stops.

If i do a mysqlcheck database_name and run mysqld-nt --console

I got a trace :

c:\mysql\data>mysqld-nt --console
050401 10:27:11 InnoDB: Started
mysqld-nt: ready for connections.
Version: '4.0.12-nt-log' socket: '' port: 3306
InnoDB: Error on pages 5897 and 5900 in index PRIMARY table comat/elemente_trans
fer
InnoDB: records in wrong order on adjacent pages
050401 10:27:43 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 0000000000001709000012ba0000170c000000002555a6a145bf000000000000

the end of the stack look like this:

500.000TIPARITA...~........Ü╥u.Se achita pana la data 15/02/2005.¬OTA.¬d .t9.7T5
î3─.t...├.{.3.δ.ú.[...╦.â.;.≤.½.c...╙.ï.C.√.│.k.#.█.ô.K...╗.eó└½U%ë@B;InnoDB: En
d of page dump
050401 10:27:45 InnoDB: Page checksum 2730535765 stored checksum 2730535765
InnoDB: Page lsn 0 629751874, low 4 bytes of lsn at page end 629751874
InnoDB: Page may be an index page where index id is 0 2582
InnoDB: record RECORD: info bits 0 0: len 4; hex 804d7f75; asc .M.u;; 1: len 6;
hex 0000011c8a70; asc ....èp;; 2: len 7; hex 80000014380699; asc ....8..;; 3: le
n 4; hex 804d7f04; asc .M..;; 4: len 4; hex 800000da; asc ...┌;; 5: len 4; hex 8
00002cd; asc ...═;; 6: len 22; hex 202020202020202020202020202020312e3030303030;
asc 1.00000;; 7: len 22; hex 202020202020202020202034363334342e3
534303030; asc 46344.54000;; 8: len 22; hex 2020202020202020202020343
63334342e3534303030; asc 46344.54000;; 9: len 22; hex 202020202020202
020202036333030302e3030303030; asc 63000.00000;; 10: len 22; hex 2020
20202020202020202034363334342e3534303030; asc 46344.54000;; 11: len 4
; hex 80000000; asc ....;; 12: len 22; hex 202020202020202020202036333030302e303
0303030; asc 63000.00000;;
InnoDB: record RECORD: info bits 16 0: len 6; hex 0000000950e4; asc ... PΣ;; 1:
len 4; hex 00001710; asc ....;;
050401 10:27:45 InnoDB: Assertion failure in thread 3984 in file D:\mysql-4.0.1
2\innobase\btr\btr0cur.c line 192
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [e-mail]
InnoDB: Thread 3304 stopped in file D:\mysql-4.0.12\innobase\os\os0sync.c line 1
50
InnoDB: Thread 2280 stopped in file D:\mysql-4.0.12\innobase\sync\sync0arr.c lin
e 126


What is the problem and what could lead to this ????

The other table takes the mysqlcheck but when i try to see all the data in
it with mysql > select * from table_name_2;
on the client i got :
ERROR 2013: Lost connection to MySQL server during query

on the console:
c:\mysql\data>mysqld-nt --console
050401 10:34:12 InnoDB: Started
mysqld-nt: ready for connections.
Version: '4.0.12-nt-log' socket: '' port: 3306
050401 10:34:39 InnoDB: Assertion failure in thread 2628 in file D:\mysql-4.0.1
2\innobase\btr\btr0cur.c line 3616
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [e-mail]
InnoDB: Thread 2448 stopped in file D:\mysql-4.0.12\innobase\sync\sync0arr.c lin
e 126


I am using Winnt40 ,mysql 4.0.12
my.cnf look like this:

[mysqld]
port=3306
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=128M
set-variable = table_cache=512
set-variable = sort_buffer=8M
set-variable = record_buffer=8M
set-variable = thread_cache=8
set-variable = max_heap_table_size=32M
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=4M
server-id = 1




set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=128M
set-variable = innodb_additional_mem_pool_size=16M

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[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

What is the problem?

I am not using binary log file.
If I have been used it would be helped me?


Thank you very very much