Hello,
I am trying to copy my innodb table spaces to a new array. When I copy
the files to their new location and start mysql-max with the new
configuration, invariably I get the following after I attempt to
actually connect to a database with the command line client:
mysqld-max process hanging, pid 20607 - killed
050112 12:58:38 mysqld restarted
/usr/bin/mysqld_safe: line 1: 23476 Killed
nohup /usr/sbin/mysqld-max --defaults-file=/idb/d1/mysql/logdata/my.cnf
--basedir=/ --datadir=/idb/d1/mysql/logdata/data/ --user=mysql
--pid-file=/idb/d1/mysql/logdata/mysql.logdata.pid --skip-locking
--port=3301 --socket=/tmp/mysql.logdata.sock.idb
/idb/d1/mysql/logdata/log/mysql.logdata.err.log 21
050112 12:58:38 mysqld ended
InnoDB: Error: page n:o stored in the page read in is 1333252, should be
1589252!
InnoDB: Error: page n:o stored in the page read in is 1333249, should be
1589249!
InnoDB: Error: trying to access page number 1872904192 in space 0
InnoDB: which is outside the tablespace bounds.
InnoDB: Byte offset 0, len 16384, i/o type 10
050112 12:58:38 InnoDB: Assertion failure in thread 1132853616 in file
fil0fil.c line 1204
InnoDB: Failing assertion: 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to mysql@lists.mysql.com
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this
binary
or one of the libraries it was linked against is corrupt, improperly
built,
or misconfigured. This error can also be caused by malfunctioning
hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.
key_buffer_size=8388600
read_buffer_size=2093056
max_used_connections=0
max_connections=1000
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 4100184 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Number of processes running now: 1
mysqld-max process hanging, pid 20607 - killed
050112 12:58:38 mysqld restarted
I have tried the copy many times over. Yes I shut the database down
before the copy. I have tried using cp, and pax to do the copies. I
have run an md5sum agains't some of the innodb files comparing source
and destination after copy, and they are identical in all tests.
I cannot possibly imagine what I am missing. I copy InnoDB table spaces
to other machines using similar methods without this type of corruption.
I doubt it's the array becuase the md5sum's are correct.
Has anyone any clue why moving the innodb spaces to another
partition/disk could possibly cause this type of problem? I double
checked my innodb table space directives, the paths are all correct.
Thanks!
--
Richard F. Rebel
cat /dev/null `tty`
signature.asc
Description: This is a digitally signed message part
