Re: Re: unkown table is full

2002-04-12 Thread Victoria Reznichenko
Richard, Friday, April 05, 2002, 12:29:44 AM, you wrote: RC Hi, RC --- RC In MySQL Version 3.23, in-memory temporary tables will automatically be RC converted to a disk-based MyISAM table after the table size gets bigger than RC tmp_table_size. RC --- RC It also says this though. I'm using

Re: Re: unkown table is full

2002-04-12 Thread Richard Clarke
There is plenty of space. In excess of 5 gigs. Ric - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 12, 2002 2:02 PM Subject: Re: Re: unkown table is full Richard, Friday, April 05, 2002, 12:29:44 AM, you wrote: RC Hi, RC

Re: Re: unkown table is full

2002-04-12 Thread Sinisa Milivojevic
Richard Clarke writes: There is plenty of space. In excess of 5 gigs. Ric Hi! The error message that you get is quite unlikely for temporary tables. Which release of MySQL 3.23 have you used ?? If not recent, then try the latest and see if problem reccurs. If this happens with last

Re: Re: unkown table is full

2002-04-12 Thread Richard Clarke
This is mysql 4.0.1-alpha. Ric - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, April 12, 2002 5:08 PM Subject: Re: Re: unkown table is full Richard Clarke writes: There is plenty of space. In excess of 5

Re: Re: unkown table is full

2002-04-12 Thread Sinisa Milivojevic
Richard Clarke writes: This is mysql 4.0.1-alpha. Ric Please submit to us a full repeatable test case at [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime

Re: unkown table is full

2002-04-04 Thread Victoria Reznichenko
Richard, Thursday, April 04, 2002, 2:42:52 AM, you wrote: RC create table test select * from summary_rts union select * from RC summary_rts_old; RC ERROR 1114: The table '#sqld70c_b4_0' is full RC Can someone please help me figure out what is wrong with this. It was RC working fine up