Description:
Hi,
I am getting some error in my Mysql database by this error mysql is going down.
Please go through and log and let me know the reason with solution.
thanks in advance.
How to repeat:
Log:
Trx read view will not see trx with id >= 0 634735453, sees < 0 634735453
--------
FILE I/O
--------
I/O thread 0 state: wait Windows aio (insert buffer thread)
I/O thread 1 state: wait Windows aio (log thread)
I/O thread 2 state: wait Windows aio (read thread)
I/O thread 3 state: wait Windows aio (write thread)
Pending normal aio reads: 0, aio writes: 0,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
26459796 OS file reads, 2166348 OS file writes, 1141412 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
40820 inserts, 40820 merged recs, 34204 merges
Hash table size 1155127, used cells 392363, node heap has 472 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 4 1904691494
Log flushed up to 4 1904691494
Last checkpoint at 4 1904691494
0 pending log writes, 0 pending chkp writes
909475 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 292406718; in additional pool allocated 5318400
Buffer pool size 16000
Free buffers 0
Database pages 15517
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 26459799, created 17482, written 1140567
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
18 queries inside InnoDB, 3 queries in queue
22 read views open inside InnoDB
Main thread id 2036, state: waiting for server activity
Number of rows inserted 1517335, updated 474090, deleted 1498123, read 2807602048
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 153.49 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
090316 10:38:01 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090316 10:38:01 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 4 1904691494.
InnoDB: Doing recovery: scanned up to log sequence number 4 1904691494
090316 10:38:01 InnoDB: Started; log sequence number 4 1904691494
090316 10:38:02 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.45-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)