>Description:
when running a "insert data infile" command on a 500MB text file, I
get the error "ERROR 1030: Got error 22 from table handler" from
mysql. I did a listing of the database files and it looks like this:
-rw-rw---- 1 root root 2147397632 Jul 3 09:46 finddata.MYD
-rw-rw---- 1 root root 266409984 Jul 3 10:01 finddata.MYI
-rw-rw---- 1 root root 8866 Jul 3 08:45 finddata.frm
I thought that Solaris 2.6 didn't have a problem with files over 2GB.
>How-To-Repeat:
Generate a large database, up to the 2GB limit. It should blow up on you.
>Fix:
unknown
>Submitter-Id: <submitter ID>
>Originator: Grant Miller
>Organization: Apple Computer
-Grant Miller [EMAIL PROTECTED]
Unix Systems Admin, Engineering Computer Services
>
>MySQL support: none
>Synopsis: ERROR 1030: Got error 22 from table handler
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: support
>Release: mysql-3.23.39 (Source distribution)
>Server: /local/solaris_2.6/mysql3.23.39/bin/mysqladmin Ver 8.21 Distrib 3.23.39, for
>sun-solaris2.6 on sparc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.39
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 226 days 17 hours 4 min 48 sec
Threads: 1 Questions: 856482843 Slow queries: 69635 Opens: 6790604 Flush tables: 2
Open tables: 61 Queries per second avg: 43.725
>Environment:
System: SunOS www-ecs 5.6 Generic_105181-21 sun4u sparc SUNW,Ultra-2
Architecture: sun4
Some paths: /usr/bin/perl /local/bin/make /local/bin/gmake /local/bin/gcc /usr/ucb/cc
GCC: Reading specs from
/local/solaris_2.6/gcc2.95.2-so/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='cc' CFLAGS=' -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64'
CXX='CC' CXXFLAGS='' LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1608144 Jul 13 2000 /lib/libc.a
lrwxrwxrwx 1 root root 11 Sep 10 2001 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1014272 Jul 13 2000 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1608144 Jul 13 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Sep 10 2001 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1014272 Jul 13 2000 /usr/lib/libc.so.1
Configure command: configure --with-gemini --disable-shared --enable-assembler
--enable-largefile --prefix=/usr/local/nusphere/mysql
---------------------------------------------------------------------
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
