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)
