Has anyone seen this before? Any idea what triggers it? Is it a bug or
a database corruption?
What I see is that the server suddenly becomes very slow, and new lmtpd
imap, etc connections either don't get greetings or they are very slow.
Looking into the logs give a bunch of messages like deadlock.txt.
The server owner thinks that something is wrong on the server and
reboots it. On reboot, innodb wants to rollback - rollback.txt.
dbmail-2.2.1
mysql-4.1.20
=====================================
061229 10:31:01 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 16 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 151927, signal count 146357
Mutex spin waits 105731, rounds 1481345, OS waits 18889
RW-shared spins 776058, OS waits 103590; RW-excl spins 49362, OS waits 29444
------------------------
LATEST DETECTED DEADLOCK
------------------------
061226 10:02:00
*** (1) TRANSACTION:
TRANSACTION 0 70537299, ACTIVE 3 sec, process no 2835, OS thread id 2969983920
starting index read
mysql tables in use 1, locked 1
LOCK WAIT 22 lock struct(s), heap size 2496, undo log entries 33
MySQL thread id 907, query id 1783430 localhost dbmail Updating
UPDATE dbmail_users SET curmail_size = curmail_size + 2089 WHERE user_idnr =
1731
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 327686 n bits 152 index `PRIMARY` of table
`dbmail/dbmail_users` trx id 0 70537299 lock_mode X locks rec but not gap
waiting
Record lock, heap no 33 PHYSICAL RECORD: n_fields 17; 1-byte offs FALSE; info
bits 0
0: len 8; hex 80000000000006c3; asc ;; 1: len 6; hex 000004344fae; asc
4O ;; 2: len 7; hex 00000680112b04; asc + ;; 3: len 23; hex
656661756c6b6a724073746d61726b732d73612e6f7267; asc [EMAIL PROTECTED];; 4: len
30; hex 24312433363438666430392466613633487131697832573274646955776e; asc
$1$3648fd09$fa63Hq1ix2W2tdiUwn;...(truncated); 5: len 8; hex 8000000000000000;
asc ;; 6: len 8; hex 8000000000000000; asc ;; 7: len 8; hex
80000000002d0285; asc - ;; 8: len 8; hex 8000000000000000; asc ;;
9: len 8; hex 8000000000000000; asc ;; 10: len 3; hex 6d6435; asc md5;;
11: len 8; hex 8000123ede333537; asc > 357;; 12: len 0; hex ; asc ;; 13: len
4; hex 80000000; asc ;; 14: len 8; hex 8000000000000000; asc ;; 15:
len 8; hex 8000000000000000; asc ;; 16: len 1; hex 81; asc ;;
*** (2) TRANSACTION:
TRANSACTION 0 70537134, ACTIVE 13 sec, process no 2835, OS thread id 2949917616
starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
19 lock struct(s), heap size 2496, undo log entries 30
MySQL thread id 931, query id 1783449 localhost dbmail Updating
UPDATE dbmail_users SET curmail_size = curmail_size + 2829 WHERE user_idnr =
1720
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 327686 n bits 152 index `PRIMARY` of table
`dbmail/dbmail_users` trx id 0 70537134 lock_mode X locks rec but not gap
Record lock, heap no 33 PHYSICAL RECORD: n_fields 17; 1-byte offs FALSE; info
bits 0
0: len 8; hex 80000000000006c3; asc ;; 1: len 6; hex 000004344fae; asc
4O ;; 2: len 7; hex 00000680112b04; asc + ;; 3: len 23; hex
656661756c6b6a724073746d61726b732d73612e6f7267; asc [EMAIL PROTECTED];; 4: len
30; hex 24312433363438666430392466613633487131697832573274646955776e; asc
$1$3648fd09$fa63Hq1ix2W2tdiUwn;...(truncated); 5: len 8; hex 8000000000000000;
asc ;; 6: len 8; hex 8000000000000000; asc ;; 7: len 8; hex
80000000002d0285; asc - ;; 8: len 8; hex 8000000000000000; asc ;;
9: len 8; hex 8000000000000000; asc ;; 10: len 3; hex 6d6435; asc md5;;
11: len 8; hex 8000123ede333537; asc > 357;; 12: len 0; hex ; asc ;; 13: len
4; hex 80000000; asc ;; 14: len 8; hex 8000000000000000; asc ;; 15:
len 8; hex 8000000000000000; asc ;; 16: len 1; hex 81; asc ;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 327686 n bits 152 index `PRIMARY` of table
`dbmail/dbmail_users` trx id 0 70537134 lock_mode X locks rec but not gap
waiting
Record lock, heap no 22 PHYSICAL RECORD: n_fields 17; 1-byte offs FALSE; info
bits 0
0: len 8; hex 80000000000006b8; asc ;; 1: len 6; hex 000004345053; asc
4PS;; 2: len 7; hex 00000680100a1d; asc ;; 3: len 24; hex
647072656e746973734073746d61726b732d73612e6f7267; asc [EMAIL PROTECTED];; 4:
len 30; hex 2431243835653534306131244767646d6477715061643241616332533832; asc
$1$85e540a1$GgdmdwqPad2Aac2S82;...(truncated); 5: len 8; hex 8000000000000000;
asc ;; 6: len 8; hex 8000000000000000; asc ;; 7: len 8; hex
800000000016235a; asc #Z;; 8: len 8; hex 8000000000000000; asc ;;
9: len 8; hex 8000000000000000; asc ;; 10: len 3; hex 6d6435; asc md5;;
11: len 8; hex 8000123ede414e8e; asc > AN ;; 12: len 0; hex ; asc ;; 13: len
4; hex 80000000; asc ;; 14: len 8; hex 8000000000000000; asc ;; 15:
len 8; hex 8000000000000000; asc ;; 16: len 1; hex 81; asc ;;
*** WE ROLL BACK TRANSACTION (2)
------------
TRANSACTIONS
------------
Trx id counter 0 73047634
Purge done for trx's n:o < 0 72887626 undo n:o < 0 4
History list length 7881
Total number of lock structs in row lock hash table 99820
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 73047462, not started, process no 2835, OS thread id 2916735920
MySQL thread id 27547, query id 7773076 localhost dbmail
---TRANSACTION 0 73047473, not started, process no 2835, OS thread id 2910608304
MySQL thread id 27549, query id 7773088 localhost dbmail
---TRANSACTION 0 73047545, not started, process no 2835, OS thread id 2940722096
MySQL thread id 27544, query id 7773186 localhost dbmail
---TRANSACTION 0 73047525, not started, process no 2835, OS thread id 2930600880
MySQL thread id 27543, query id 7773160 localhost dbmail
---TRANSACTION 0 73047392, not started, process no 2835, OS thread id 2957048752
MySQL thread id 27542, query id 7772953 localhost dbmail
---TRANSACTION 0 73047615, not started, process no 2835, OS thread id 2972392368
MySQL thread id 27535, query id 7773262 localhost dbmail
---TRANSACTION 0 73047149, not started, process no 2835, OS thread id 2922630064
MySQL thread id 27534, query id 7772663 localhost dbmail
---TRANSACTION 0 73047606, not started, process no 2835, OS thread id 2962561968
MySQL thread id 27529, query id 7773252 localhost dbmail
---TRANSACTION 0 73047629, not started, process no 2835, OS thread id 2964769712
MySQL thread id 27525, query id 7773275 localhost dbmail
---TRANSACTION 0 73047451, not started, process no 2835, OS thread id 2921024432
MySQL thread id 27519, query id 7773049 localhost dbmail
---TRANSACTION 0 73047471, not started, process no 2835, OS thread id 2960554928
MySQL thread id 27515, query id 7773086 localhost dbmail
---TRANSACTION 0 73047147, not started, process no 2835, OS thread id 2913016752
MySQL thread id 27514, query id 7772661 localhost dbmail
---TRANSACTION 0 73047113, not started, process no 2835, OS thread id 2922228656
MySQL thread id 27509, query id 7772569 localhost dbmail
---TRANSACTION 0 73047118, not started, process no 2835, OS thread id 2914020272
MySQL thread id 27508, query id 7772573 localhost dbmail
---TRANSACTION 0 73040150, not started, process no 2835, OS thread id 2907274160
MySQL thread id 27425, query id 7760016 localhost dbmail
---TRANSACTION 0 73047622, not started, process no 2835, OS thread id 2911009712
MySQL thread id 27426, query id 7773275 localhost dbmail
---TRANSACTION 0 73046172, not started, process no 2835, OS thread id 2965371824
MySQL thread id 27427, query id 7770590 localhost dbmail
---TRANSACTION 0 73043373, not started, process no 2835, OS thread id 2957249456
MySQL thread id 27487, query id 7764805 localhost dbmail
---TRANSACTION 0 73045582, not started, process no 2835, OS thread id 2926738352
MySQL thread id 27428, query id 7768442 localhost dbmail
---TRANSACTION 0 73040159, not started, process no 2835, OS thread id 2930199472
MySQL thread id 27429, query id 7760022 localhost dbmail
---TRANSACTION 0 73047116, not started, process no 2835, OS thread id 2971990960
MySQL thread id 27437, query id 7773064 localhost dbmail
---TRANSACTION 0 73045220, not started, process no 2835, OS thread id 2970987440
MySQL thread id 27421, query id 7767207 localhost dbmail
---TRANSACTION 0 73033522, not started, process no 2835, OS thread id 2971188144
MySQL thread id 27420, query id 7773288 localhost dbmail
---TRANSACTION 0 73047523, not started, process no 2835, OS thread id 2969582512
MySQL thread id 27281, query id 7773146 localhost dbmail
---TRANSACTION 0 73047485, not started, process no 2835, OS thread id 2949917616
MySQL thread id 27171, query id 7773100 localhost dbmail
---TRANSACTION 0 73047431, not started, process no 2835, OS thread id 2929998768
MySQL thread id 27160, query id 7773017 localhost dbmail
---TRANSACTION 0 73046629, not started, process no 2835, OS thread id 2964970416
MySQL thread id 27154, query id 7771787 localhost dbmail
---TRANSACTION 0 73047063, not started, process no 2835, OS thread id 2968980400
MySQL thread id 26928, query id 7773064 localhost dbmail
---TRANSACTION 0 73031773, not started, process no 2835, OS thread id 2914622384
MySQL thread id 26881, query id 7771612 localhost dbmail
---TRANSACTION 0 73047080, not started, process no 2835, OS thread id 2966772656
MySQL thread id 26821, query id 7773064 localhost dbmail
---TRANSACTION 0 73046556, not started, process no 2835, OS thread id 2915933104
MySQL thread id 26606, query id 7771618 localhost dbmail
---TRANSACTION 0 73047127, not started, process no 2835, OS thread id 2940320688
MySQL thread id 23386, query id 7772582 localhost dbmail
---TRANSACTION 0 73047633, not started, process no 2835, OS thread id 2960354224
MySQL thread id 21139, query id 7773279 localhost dbmail
---TRANSACTION 0 73047172, not started, process no 2835, OS thread id 2906672048
MySQL thread id 11378, query id 7772685 localhost dbmail
---TRANSACTION 0 73047421, not started, process no 2835, OS thread id 2963364784
MySQL thread id 140, query id 7773002 localhost dbmail
---TRANSACTION 0 73047014, not started, process no 2835, OS thread id 2963164080
MySQL thread id 141, query id 7772475 localhost dbmail
---TRANSACTION 0 73046795, not started, process no 2835, OS thread id 2962361264
MySQL thread id 145, query id 7772120 localhost dbmail
---TRANSACTION 0 70362965, not started, process no 2835, OS thread id 2963966896
MySQL thread id 137, query id 7773288 localhost dbmail
---TRANSACTION 0 70362946, not started, process no 2835, OS thread id 2967575472
MySQL thread id 134, query id 7773285 localhost dbmail
---TRANSACTION 0 73022722, ACTIVE 2031 sec, process no 2835, OS thread id
2953448368
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1024, undo log entries 6
MySQL thread id 27341, query id 7734522 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (1,680240,'text/plain;charset=iso-8859-1')
Trx read view will not see trx with id >= 0 73022723, sees < 0 72887623
---TRANSACTION 0 73005511, ACTIVE 3810 sec, process no 2835, OS thread id
2922027952
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1024, undo log entries 6
MySQL thread id 26489, query id 7705321 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (1,680239,'text/plain;charset=iso-8859-1')
Trx read view will not see trx with id >= 0 73005512, sees < 0 72887623
---TRANSACTION 0 72990567, ACTIVE 5295 sec, process no 2835, OS thread id
2962963376
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1024, undo log entries 6
MySQL thread id 26910, query id 7681542 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (1,680238,'multipart/mixed;boundary=\"----=_20061229090246_56478\"')
Trx read view will not see trx with id >= 0 72990568, sees < 0 72887623
---TRANSACTION 0 72968903, ACTIVE 7595 sec, process no 2835, OS thread id
2930801584
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1024, undo log entries 6
MySQL thread id 26886, query id 7646233 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (1,680237,'multipart/mixed;boundary=\"----=_20061229082426_52062\"')
Trx read view will not see trx with id >= 0 72968904, sees < 0 72887623
---TRANSACTION 0 72967849, ACTIVE 7715 sec, process no 2835, OS thread id
2963565488
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1024, undo log entries 6
MySQL thread id 139, query id 7644830 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (1,680236,'multipart/mixed;boundary=\"----=_20061229082226_78094\"')
Trx read view will not see trx with id >= 0 72967850, sees < 0 72887623
---TRANSACTION 0 72967139, ACTIVE 7835 sec, process no 2835, OS thread id
2962160560
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1024, undo log entries 6
MySQL thread id 26870, query id 7643419 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (1,680235,'multipart/mixed;boundary=\"----=_20061229082025_41634\"')
Trx read view will not see trx with id >= 0 72967140, sees < 0 72887623
---TRANSACTION 0 72957511, ACTIVE 8918 sec, process no 2835, OS thread id
2963766192
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1024, undo log entries 6
MySQL thread id 138, query id 7628434 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (1,680234,'multipart/mixed;boundary=\"----=_20061229080223_60335\"')
Trx read view will not see trx with id >= 0 72957512, sees < 0 72887623
---TRANSACTION 0 72888151, ACTIVE 19541 sec, process no 2835, OS thread id
2949114800
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1024, undo log entries 6
MySQL thread id 26094, query id 7515440 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (1,680233,'multipart/related; type=\"multipart/alternative\";
boundary=\"------------ms040706010009020504030405\"')
Trx read view will not see trx with id >= 0 72888152, sees < 0 72887623
---TRANSACTION 0 72888145, ACTIVE 19547 sec, process no 2835, OS thread id
2913418160
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1024, undo log entries 6
MySQL thread id 26159, query id 7515406 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (196,680232,'DomainKeys? See http://antispam.yahoo.com/domainkeys')
Trx read view will not see trx with id >= 0 72888146, sees < 0 72887623
---TRANSACTION 0 72887883, ACTIVE 19586 sec, process no 2835, OS thread id
2954976176
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1024, undo log entries 6
MySQL thread id 26241, query id 7515016 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (196,680231,'DomainKeys? See http://antispam.yahoo.com/domainkeys')
Trx read view will not see trx with id >= 0 72887884, sees < 0 72887623
---TRANSACTION 0 72887880, ACTIVE 19587 sec, process no 2835, OS thread id
2912414640
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1024, undo log entries 6
MySQL thread id 26161, query id 7514994 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (1,680230,'text/plain; charset=\"iso-8859-1\"')
Trx read view will not see trx with id >= 0 72887881, sees < 0 72887623
---TRANSACTION 0 72887653, ACTIVE 19601 sec, process no 2835, OS thread id
2961959856 fetching rows, thread declared inside InnoDB 149
mysql tables in use 2, locked 3
ROLLING BACK 99766 lock struct(s), heap size 7187776, undo log entries 2653017
MySQL thread id 26067, query id 7514667 localhost dbmail copy to tmp table
OPTIMIZE TABLE dbmail_headervalue
---TRANSACTION 0 72887637, ACTIVE 19601 sec, process no 2835, OS thread id
2926939056
mysql tables in use 1, locked 1
10 lock struct(s), heap size 1024, undo log entries 13
MySQL thread id 26093, query id 7514668 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (5,680229,'from dvp194.neoplus.adsl.tpnet.pl
(dvp194.neoplus.adsl.tpnet.pl [83.22.49.194]) by mail.example.com (Postfix)
with ESMTP id 0FB27939A7B; Fri, 29 Dec 2006 05:03:30 -0600 (CST)')
Trx read view will not see trx with id >= 0 72887638, sees < 0 72887576
---TRANSACTION 0 72887636, ACTIVE 19601 sec, process no 2835, OS thread id
2940521392
mysql tables in use 1, locked 1
10 lock struct(s), heap size 1024, undo log entries 14
MySQL thread id 26160, query id 7514693 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (5,680228,'from 66.17.16.17 (HELO mail.abspresort.com) by
example.com with esmtp (K04N*2)77 -14)) id 88H.\'6-QP-O(S-8S for [EMAIL
PROTECTED]; Fri, 29 Dec 2006 11:01:29 +0300')
Trx read view will not see trx with id >= 0 72887637, sees < 0 72887576
---TRANSACTION 0 72887634, ACTIVE 19601 sec, process no 2835, OS thread id
2965171120
mysql tables in use 1, locked 1
10 lock struct(s), heap size 1024, undo log entries 13
MySQL thread id 26158, query id 7514689 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (5,680227,'from dvp194.neoplus.adsl.tpnet.pl
(dvp194.neoplus.adsl.tpnet.pl [83.22.49.194]) by mail.example.com (Postfix)
with ESMTP id 0FB27939A7B; Fri, 29 Dec 2006 05:03:30 -0600 (CST)')
Trx read view will not see trx with id >= 0 72887635, sees < 0 72887576
---TRANSACTION 0 72887627, ACTIVE 19601 sec, process no 2835, OS thread id
2962762672
mysql tables in use 1, locked 1
10 lock struct(s), heap size 1024, undo log entries 14
MySQL thread id 26162, query id 7514690 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (5,680226,'from localhost (oro [127.0.0.1]) by mail.example.com
(Postfix) with ESMTP id 289FC939A8E; Fri, 29 Dec 2006 05:03:40 -0600
(CST)')
Trx read view will not see trx with id >= 0 72887628, sees < 0 72877375
---TRANSACTION 0 72887624, ACTIVE 19601 sec, process no 2835, OS thread id
2922830768
mysql tables in use 1, locked 1
10 lock struct(s), heap size 1024, undo log entries 13
MySQL thread id 26239, query id 7514688 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (5,680224,'by mail.example.com (Postfix, from userid 100) id
7CD47939A98; Fri, 29 Dec 2006 05:04:15 -0600 (CST)')
Trx read view will not see trx with id >= 0 72887625, sees < 0 72877375
---TRANSACTION 0 72887623, ACTIVE 19601 sec, process no 2835, OS thread id
2968378288
mysql tables in use 1, locked 1
10 lock struct(s), heap size 1024, undo log entries 14
MySQL thread id 26240, query id 7514691 localhost dbmail Table lock
INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue)
VALUES (5,680223,'from mail.example.com ([127.0.0.1]) by localhost
(mail.example.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id
JsXGgqOFyBf2 for <[EMAIL PROTECTED]>; Fri, 29 Dec 2006 05:04:00 -0600 (CST)
Trx read view will not see trx with id >= 0 72887624, sees < 0 72877375
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (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: 1; buffer pool: 0
15762452 OS file reads, 4968613 OS file writes, 784826 OS fsyncs
260.23 reads/s, 17135 avg bytes/read, 172.11 writes/s, 17.75 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf for space 0: size 1, free list len 26, seg size 28, is empty
Ibuf for space 0: size 1, free list len 26, seg size 28,
2645656 inserts, 2645656 merged recs, 288510 merges
Hash table size 34679, used cells 192, node heap has 1 buffer(s)
601.96 hash searches/s, 737.58 non-hash searches/s
---
LOG
---
Log sequence number 153 2605985991
Log flushed up to 153 2605985527
Last checkpoint at 153 2605873968
1 pending log writes, 0 pending chkp writes
500562 log i/o's done, 6.44 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 18674022; in additional pool allocated 1043072
Buffer pool size 512
Free buffers 0
Database pages 73
Modified db pages 41
Pending reads 0
Pending writes: LRU 2, flush list 0, single page 0
Pages read 27614764, created 1788291, written 7328715
272.17 reads/s, 0.00 creates/s, 214.17 writes/s
Buffer pool hit rate 950 / 1000
--------------
ROW OPERATIONS
--------------
1 queries inside InnoDB, 0 queries in queue
Main thread process no. 2835, id 2991680432, state: sleeping
Number of rows inserted 19633366, updated 350837, deleted 685487, read 366025266
0.00 inserts/s, 0.69 updates/s, 0.00 deletes/s, 2092.43 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
061229 10:35:21 mysqld started
061229 10:35:21 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...
061229 10:35:23 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 153 2607403651.
InnoDB: Doing recovery: scanned up to log sequence number 153 2607452592
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 2639886 row operations to undo
InnoDB: Trx id counter is 0 73048320
061229 10:35:23 InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 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 72887653, 2639886 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 72887653 completed
InnoDB: Rollback of uncommitted transactions completed
061229 10:41:44 InnoDB: Flushing modified pages from the buffer pool...
061229 10:41:45 InnoDB: Started; log sequence number 153 2607452592
/usr/libexec/mysqld: ready for connections.
Version: '4.1.20' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source
distribution
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
