>Description:
I am not subscribe to this list so please cc me in your reply.
I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a fresh
build and there has been no activity except for the following:
1) Record inserts from flat file parsing.
2) OPTIMIZE TABLE wich died in batch & caused me to try and run the REPAIR.
I've also tried complete rebuilds with the same data and I get the same crashi but
builds with less data (~4GB) have worked.
The REPAIR TABLE dies repeatedly with:
mysql> repair table dna;
ERROR 2013: Lost connection to MySQL server during query
I've tried '-O max_allowed_packet=33554432' as per section A.2.2. But with the same
results.
I've tried a stack trace for the REPAIR:
But there is no information about the failed OPTIMIZE?!
========================================
020312 12:12:55 Warning: Retrying repair of: './MC_extra/dna' with keycache
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died.
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x40084e9d
0x4016cfcf
0x814a036
0x813e5d1
0x80f9678
0x80f92fd
0x80fe9b7
0x80fecac
0x80b750f
0x80b9948
0x80b5954
0x80b4e57
Stack trace successful, trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x82392c8 = repair table dna
0x40084e9d _end + 937950069
0x4016cfcf _end + 938900647
0x814a036 my_no_flags_free + 22
0x813e5d1 mi_repair + 2337
0x80f9678 repair__9ha_myisamP3THDR17st_mi_check_paramb + 584
0x80f92fd repair__9ha_myisamP3THDP15st_ha_check_opt + 285
0x80fe9b7
mysql_admin_table__FP3THDP13st_table_listP15st_ha_check_optPCc13thr_lock_typebT5UiPM7handlerFP7handlerP3THDP15st_ha_check_opt_i
+ 1703
0x80fecac mysql_repair_table__FP3THDP13st_table_listP15st_ha_check_opt + 76
0x80b750f mysql_execute_command__Fv + 4383
0x80b9948 mysql_parse__FP3THDPcUi + 72
0x80b5954 do_command__FP3THD + 1284
0x80b4e57 handle_one_connection__FPv + 663
Also the table layout is:
$dbh->do("CREATE TABLE dna ("
. "gi INT UNSIGNED NOT NULL PRIMARY KEY,"
. "acc CHAR(10) NOT NULL,"
. "ver TINYINT NOT NULL,"
. "loc CHAR(16) NOT NULL,"
. "type CHAR(16),"
. "div CHAR(3),"
. "date DATE,"
. "tax INT UNSIGNED,"
. "ori TINYTEXT,"
. "def TINYTEXT,"
. "acc2nd TEXT,"
. "word TEXT,"
. "src TEXT,"
. "com TEXT,"
. "seq LONGTEXT NOT NULL,"
. "KEY(acc),"
. "KEY(loc),"
. "KEY(div),"
. "KEY(tax))"
. "MAX_ROWS=8388608 AVG_ROW_LENGTH=4096 "
. "RAID_TYPE=STRIPED RAID_CHUNKS=4 RAID_CHUNKSIZE=256"
) or die $!;
>How-To-Repeat: Too much data is being processed to repeat easily.
>Fix: None
>Submitter-Id:
>Originator: Raphael LaFrance
>Organization: Foundation for Scientific Inquiry
>MySQL support: none
>Synopsis: Corrupted table after OPTIMIZE/REPAIR
>Severity: serious
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.37 (Source distribution)
>Environment:
System: Linux trex 2.4.16-64GB-SMP #1 SMP Tue Dec 18 15:32:55 GMT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-O2 -m486 -mcpu=i486
-march=i486 -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 1341670 Dec 18 10:50 /lib/libc.so.6
-rw-r--r-- 1 root root 24534176 Dec 18 10:39 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Dec 18 10:39 /usr/lib/libc.so
-rw-r--r-- 1 root root 859134 Jun 18 2001 /usr/lib/libc-client.a
lrwxrwxrwx 1 root root 20 Jul 15 2000 /usr/lib/libc-client.so ->
libc-client.so.2000c
-rwxr-xr-x 1 root root 720640 Jun 18 2001 /usr/lib/libc-client.so.2000c
Configure command: ./configure --enable-shared --enable-assembler
--enable-large-files --infodir=/usr/share/info --libdir=/usr/lib
--libexecdir=/usr/sbin --localstatedir=/var/lib/mysql --mandir=/usr/share/man
--prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --without-debug
--datadir=/usr/share --includedir=/usr/include --with-extra-charsets=complex
--with-unix-socket-path=/var/lib/mysql/mysql.sock --without-berkeley-db
--without-innodb
---------------------------------------------------------------------
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
