Yes. Can you CREATE TEMP TABLE ....? -----Original Message----- From: J S To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 7/16/04 7:34 AM Subject: RE: ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STTbtrac' (Errcode: 27
>Can you explicitly create temporary tables? Yes, I have full priviledges. Do you mean I could copy the internet_usage table to a temp table with new keys? JS. > >-----Original Message----- >From: J S >To: [EMAIL PROTECTED] >Sent: 7/16/04 3:54 AM >Subject: RE: ERROR 3 at line 1: Error writing file >'/proxydb/mysql/tmp/STTbtrac' (Errcode: 27 > > > > >>Are you files being created in /tmp? How big is this partition? > > >I wondered about that, but I've set the mysql tmpdir to >/proxydb/mysql/tmp, and the error does actually say: Error writing >file '/proxydb/mysql/tmp/STTbtrac' > >Also I couldn't see any mysql files in /tmp. It's tricky isn't it?! > >JS. > > > >> > >>-----Original Message----- > >>From: J S > >>To: [EMAIL PROTECTED] > >>Sent: 7/15/04 2:29 PM > >>Subject: ERROR 3 at line 1: Error writing file > >>'/proxydb/mysql/tmp/STTbtrac' > >>(Errcode: 27 > >> > >>Hi, > >> > >>I'm trying to create an index using the command: > >> > >>CREATE INDEX urlindex ON internet_usage (urlid) > >> > >>| Field | Type | Null | Key | Default | Extra | > >>| urlid | int(10) unsigned | | | 0 | | > >> > >>But I keep getting the following error: > >> > >>ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STTbtrac' > >>(Errcode: 27) > >> > >>perror says: > >> > >>$ perror 3 > >>Error code 3: The process does not exist. > >>$ perror 27 > >>Error code 27: A file cannot be larger than the value set by ulimit. > >>$ > >> > >>I'm using mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc on aix 4.3. > >> > >>The status of this table is: > >> > >>| Name | Type | Row_format | Rows | Avg_row_length | > >>Data_length | Max_data_length | Index_length | Data_free | > >>Auto_increment | > >>Create_time | Update_time | Check_time | > >>Create_options | Comment | > >>| internet_usage | MyISAM | Fixed | 324936160 | 32 | > >>10397957120 | 137438953471 | 2888631296 | 0 | > >>NULL | > >>2004-07-09 14:05:56 | 2004-07-13 20:27:06 | 2004-07-09 14:13:20 | > >>max_rows=4294967295 | | > >> > >> > >>I can't see any reason why there would be an error 27. The filesystem >is > >> > >>largefile enabled and has plenty of space: > >> > >>$ df -k . > >>Filesystem 1024-blocks Free %Used Iused %Iused Mounted on > >>/dev/sawmill02 65601536 30921916 53% 1064 1% /proxydb > >> > >>Also the filesize ulimit is unlimited: > >> > >># su - mysql > >>$ cd /proxydb/mysql/tmp > >>$ cat load-SG_BSGL01_main_460429210000 >> test > >>$ ls -l test > >>-rw-r--r-- 1 mysql mysql 4239906888 Jul 15 20:20 test > >> > >> > >># su - mysql > >>$ ulimit -a > >>time(seconds) unlimited > >>file(blocks) unlimited > >>data(kbytes) unlimited > >>stack(kbytes) unlimited > >>memory(kbytes) 500000 > >>coredump(blocks) unlimited > >>nofiles(descriptors) 2000 > >> > >>I'm not really sure why I get the error 3 though? > >> > >>Can anyone help me out please? > >> > >>Thanks, > >> > >>JS. > >> > >>_________________________________________________________________ > >>Express yourself with cool new emoticons > >>http://www.msn.co.uk/specials/myemo > >> > >> > >>-- > >>MySQL General Mailing List > >>For list archives: http://lists.mysql.com/mysql > >>To unsubscribe: > >>http://lists.mysql.com/[EMAIL PROTECTED] > > > >_________________________________________________________________ > >It's fast, it's easy and it's free. Get MSN Messenger today! > >http://www.msn.co.uk/messenger > > > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] > > > >_________________________________________________________________ >Express yourself with cool new emoticons >http://www.msn.co.uk/specials/myemo > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] _________________________________________________________________ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]