>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