ERROR 1030: Got error 22 from table handler
Hi! grant == grant [EMAIL PROTECTED] writes: Description: grant when running a insert data infile command on a 500MB text file, I grant get the error ERROR 1030: Got error 22 from table handler from grant mysql. I did a listing of the database files and it looks like this: grant -rw-rw 1 root root 2147397632 Jul 3 09:46 finddata.MYD grant -rw-rw 1 root root 266409984 Jul 3 10:01 finddata.MYI grant -rw-rw 1 root root8866 Jul 3 08:45 finddata.frm grant I thought that Solaris 2.6 didn't have a problem with files over 2GB. How-To-Repeat: grant Generate a large database, up to the 2GB limit. It should blow up on you. Fix: grant unknown On Solaris 2.6 it depends on how you create the file system and how MySQL is compiled if you can create files bigger than 2G. You can verify the max file limit supported internally by MySQL by creating a file with MAX_ROWS=1 and then do a SHOW TABLE STATUS on the table. If the max data file length 2G then the limit is on the file system, in which case you probably have to do re-format your disk to get it to support larger files. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - 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
ERROR 1030: Got error 22 from table handler
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 root8866 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 version10 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
Can't delete from very fat table: ERROR 1030: Got error 22 from table handler
Description: Can't delete from incredibly fat table. When I attempt to delete from table rCamDom in my database, I get an error: ERROR 1030: Got error 22 from table handler. This table is *huge*, biggest one in my database, other deletes work fine. The table entries begin on Jan 1, 2001. When I try and delete even 1 day's worth of data, I get an error. I would eventually like to blow away several months ofdata . . . Info on fat table, mysql version platform: bash-2.03# du -sk rCamDom.ISM 4198404 rCamDom.ISM bash-2.03# mysql -V mysql Ver 9.38 Distrib 3.22.32, for sun-solaris2.7 (sparc) bash-2.03# uname -a SunOS apu 5.7 Generic_106541-11 sun4u sparc SUNW,Ultra-60 How-To-Repeat: mysql delete from rCamDom where When'2001-01-02'; ERROR 1030: Got error 22 from table handler Also: mysql delete from rCamDom where When='2001-01-01'; ERROR 1030: Got error 22 from table handler Fix: Submitter-Id: [EMAIL PROTECTED] Originator:Super-User Organization: Forbes.com MySQL support: none Synopsis: unable to delete table data, running out of disk space for it! Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.22.32 (Source distribution) Environment: System: SunOS apu 5.7 Generic_106541-11 sun4u sparc SUNW,Ultra-60 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes Perl: This is perl, version 5.005_03 built for sun4-solaris - 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