[ MySQL ]
Here's some additional data now that I've rebuilt using "--enable-debug" or
whatever the configure option is.
Here's what GDB is claiming is happening after it ran for about 2 minutes
(after initial startup when NO files needed to be created)
(gdb) where
#0 thr_local_get (id=60) at thr0loc.c:75
#1 0x1022f98c in thr_local_get_in_ibuf_field () at thr0loc.c:145
#2 0x101c1b74 in ibuf_inside () at ibuf0ibuf.c:223
#3 0x101bc59c in fil_io (type=537082596, sync=271108496,
space_id=804396760, block_offset=804396764, byte_offset=804396784,
len=804396776, buf=0x2ff21ed4,
message=0xdeadbeef) at fil0fil.c:1105
#4 0x1020609c in trx_sys_doublewrite_restore_corrupt_pages () at
trx0sys.c:281
#5 0x10189180 in innobase_start_or_create_for_mysql () at srv0start.c:1093
#6 0x10181e4c in innobase_init () at ha_innobase.cc:463
#7 0x1001350c in ha_init () at handler.cc:161
#8 0x10051120 in main (argc=21, argv=0x20052a70) at mysqld.cc:1899
#9 0x10000204 in __start ()
(gdb)
It appears to be running in a loop as can be seen below.. I found a comment
indicating something about it possibly running out of file handles, and
have included a LSOF output for this process as well :
% lsof -p22014
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 22014 mysql cwd VDIR 43,4 512 262153 /test2
(/dev/test2lv)
mysqld 22014 mysql 0u VCHR 38,7 0t2353 168294 /dev/pts/7
mysqld 22014 mysql 1w VREG 43,4 792 262156 /test2
(/dev/test2lv)
mysqld 22014 mysql 2w VREG 43,4 792 262156 /test2
(/dev/test2lv)
mysqld 22014 mysql 3u IPv4 0x7028e2dc 0t0 TCP *:3306 (LISTEN)
mysqld 22014 mysql 4u unix 10,7 0t0 70 /tmp/mysql.sock
75 in thr0loc.c
(gdb)
77 in thr0loc.c
(gdb)
79 in thr0loc.c
(gdb)
72 in thr0loc.c
(gdb)
81 in thr0loc.c
(gdb)
74 in thr0loc.c
(gdb)
75 in thr0loc.c
(gdb)
77 in thr0loc.c
(gdb)
79 in thr0loc.c
(gdb)
72 in thr0loc.c
(gdb)
81 in thr0loc.c
(gdb)
74 in thr0loc.c
(gdb)
75 in thr0loc.c
(gdb)
77 in thr0loc.c
(gdb)
79 in thr0loc.c
(gdb)
72 in thr0loc.c
(gdb)
81 in thr0loc.c
(gdb)
74 in thr0loc.c
(gdb)
75 in thr0loc.c
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
