List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:November 10 2003 5:48am
Subject:Re: Got error 12 from table handler
View as plain text  
On Sun, Nov 09, 2003 at 12:13:34PM +0000, george atef wrote:
> 
> Hi, i got this message after querying the 3255 records table, and the query
> is like this:
> 
> 
> SELECT a.book_no, a.isbn_a, a.author_a, a.title_a, a.title_b, a.title_c,
> a.edition, a.place_publication_a, a.place_publication_b,
> a.place_publication_c, a.physical_desc_b, a.physical_desc_c, a.actal_price,
> a.currency_code, a.book_name, a.author_name, a.publ_name, a.subject_code,
> b.subject_desc FROM book_data a, subject b where
> a.subject_code=b.subject_code ORDER BY b.subject_desc, a.entry_date DESC
> 
> it works fine locally on my win98 (PWS server) MySQL 4.0.15 but remotly on
> my FREEBSD server gives this error:
> 
> query error: Got error 12 from table handler
> 
> Any Suggesstions?

jzawodn@museful:~$ perror 12
Error code  12:  Cannot allocate memory

You have a memory shortage, it seems.
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 57 days, processed 2,151,315,841 queries (435/sec. avg)
Thread
Got error 12 from table handlergeorge atef9 Nov
  • Re: Got error 12 from table handlerJeremy Zawodny10 Nov