>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
