David,
I'd say you ran out of memory, or out of disk space where ever your
mysqld is creating temporary tables. This happened while it was using a
temporary table to do the "group by" clause most likely. So, the "df"
command probably won't give you an immediate answer. Are you running
with the --big-tables option on mysqld?
PS. Thanks for including the Deep Purple link in your sig! I'm
listening to the House of Blues Cybercast as I write this! :-)
..chris
> -----Original Message-----
> From: daveh@stripped [mailto:daveh@stripped]On Behalf Of
> Dave Hodgkinson
> Sent: Thursday, March 30, 2000 9:33 AM
> To: sinisa@stripped
> Cc: mysql@stripped
> Subject: Re: ERROR 1030: Got error 28 from table handler
>
>
> sinisa@stripped wrote:
> >
> > Dave Hodgkinson writes:
> > >
> > > Any idea what this might be?
> > >
> > > mysql> select
> > > -> zone.name, month,count(distinct zone,month,username)
> > > -> from
> > > -> hit_gimp, zone
> > > -> group by zone,month ;
> > > ERROR 1030: Got error 28 from table handler
> > >
> > > TIA,
> > >
> > > Dave
> >
> > Hi!
> >
> > You ran out of disk space.
>
> Where? It'd be nice to know.
>
> root@ziggurat /root]# df -k
> Filesystem 1k-blocks Used Available Use% Mounted on
> /dev/hda3 9305844 8353300 479832 95% /
> /dev/hda1 15522 6131 8590 42% /boot
> /dev/md0 17630936 2156392 14578936 13% /u0
>
>
> --
> David Hodgkinson, Technical Director, Sift PLC
> http://www.sift.co.uk
> Editor, "The Highway Star"
> http://www.deep-purple.com
> Dave endorses Yanagisawa saxes, Apache, Perl, Linux, MySQL,
> emacs, gnus
>
> --
> ---------------------------------------------------------------------
> Please check
"http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail
mysql-thread32724@stripped
To unsubscribe, send a message to:
<mysql-unsubscribe-chris=claimlynx.com@stripped>
